Relative table column references work differently than excel.

Posted by: jeff on 6 May 2020, 10:32 am EST

  • Posted 6 May 2020, 10:32 am EST

    Relative table column references work differently than excel.

    1) Click an adjacent row in a table while in cell edit mode gives the A1 notion not column reference. Clicking should [@olumn1]

    2) The whole col is highlighted in Spreadjs. Excel only does the relative row.

    3) Excel by default populates the entire column with the relative references.

  • Replied 7 May 2020, 10:12 pm EST

    Hi Jeff,

    For 1). and 3), We are able to replicate the issue at our end and hence we have forwarded it to the concerned team for further investigation of the issue(SJS-4302). We will let you know about any updates regarding the same.

    For 2). We are unable to replicate it, I've attached a screenshot of the behaviour observed at our end. Please have a look at it and let us know if we are missing something here

  • Replied 9 May 2020, 7:11 am EST

    Correct Solving 1) will also solve 2).
  • Replied 14 May 2020, 3:43 pm EST

    Dev team has confirmed that these are the missing features that have now been added to our backlog. We will let you know about updates regarding the same.
  • Replied 9 July 2020, 4:54 pm EST

    An additional note. When doing a col reference in an adjacent cell excel detects the reference to the table and autocompletes the table.

    Note: This cell reference is done through a cell click in formula edit mode.

  • Replied 9 July 2020, 4:53 pm EST

    when doing text it does not auto complete the column.

  • Replied 12 July 2020, 10:51 pm EST

    Hi Jeff,

    We have shared the additional use case with the dev team too. Will keep you notified with the updates regarding the same.

  • Replied 15 July 2020, 6:03 pm EST

    Internal tracking ID for formula auto-fill: SJS-5007
  • Replied 21 August 2020, 6:22 am EST

    Any updates on this ticket?
  • Replied 23 August 2020, 2:57 pm EST

    Hi Jeff,

    This case is still with the dev team, I've asked the team for an update and will let you know as soon as I get more information on this.

  • Replied 29 August 2020, 9:25 am EST

    Cool, We are particularly interested in:

    1) Click an adjacent row in a table while in cell edit mode gives the A1 notion. Clinking a column reference should show column notation i.e. [@Column1].

    A rough estimate of the release outlook would be great.
  • Replied 30 August 2020, 5:59 pm EST

    We are sorry but we not have an ETA for now. I've asked the dev team for an ETA and will let you know as soon as I get an update from the dev team.
  • Replied 10 December 2020, 4:30 pm EST

    Hi Jeff,

    The Devs are working on this feature and it should be added in the 14.2.0 build which would release in late July.

  • Replied 28 July 2022, 5:25 pm EST

    A relative reference in Excel is a pointer to a cell or range of cells. For example, a relative reference to cell A1 looks like this: = A1 A relative address will change when copied to another location in a worksheet because it describes the "offset... An Excel Table is a special object for managing data in Excel.

    Hope You Find This Useful,
Need extra support?

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

Learn More

Forum Channels