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

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

  • Posted 18 November 2020, 3:03 pm 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.

  • Replied 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.
  • Replied 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
  • Replied 25 November 2020, 7:59 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)
  • Replied 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
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels