Table should use column references on mouse select and key board select

Table should use column references on mouse select and key board select

Posted by: jeff on 18 November 2020, 3:03 pm EST

• 

  jeff

  • Post Options:
  • Link
    Copy

  Posted 18 November 2020, 3:03 pm EST - Updated 3 October 2022, 1:05 am EST

  Selecting columns with the mouse or keyboard in a table gives the absolute cell reference “D5”. The relative reference “[@Score]” is expected.

  Steps:

  1. Edit a cell in a table.
  2. Begin formula mode. Press “=”
  3. Arrow left once
  4. “D5” absolute reference appears in the cell.

  

• 

  jeff

  • Post Options:
  • Link
    Copy

  Posted 18 November 2020, 3:12 pm EST

  This might already be tracked by SJS-4302 in the ticket https://www.grapecity.com/forums/spreadjs/relative-table-column-refe.

  I want to clearly state this is the most important behavior for our table purpose. It’s important that our users explicitly tell us they want relative “[@mycol]” col.

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 19 November 2020, 6:03 pm EST

  Hi Jeff,

  Thanks for the information. The feature is still in our backlog. we have asked Devs about the update. we will update you once we have any information regarding the same.

  Regards
  
  Avinash

• 

  jeff

  • Post Options:
  • Link
    Copy

  Posted 25 November 2020, 7:59 am EST - Updated 3 October 2022, 1:05 am EST

  There is an edge case for this as well.

  1. Edit a cell in a table.
  2. Begin formula mode. Press “=”
  3. Select a cell in a different table (but at the same row index)
  4. Absolute reference appears in the cell.

  Expected to see the table column reference from the other table. (see screen shot)
  
  

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 30 November 2020, 8:26 pm EST

  Hi Jeff,

  Thanks for the information. We are able to replicate the issue at our end. We have added a new enhancement request on your behalf. We will update you regarding this as soon as we get any information. The internal id for this issue will be SJS-6730.

  Regards
  
  Avinash