Forums Home / Spread / SpreadJS
Posted by: jeff on 6 May 2020, 10:32 am EST
jeff
Posted 6 May 2020, 10:32 am EST - Updated 3 October 2022, 12:09 am EST
Relative table column references work differently than excel.
Click an adjacent row in a table while in cell edit mode gives the A1 notion not column reference. Clicking should [@olumn1]
The whole col is highlighted in Spreadjs. Excel only does the relative row.
Excel by default populates the entire column with the relative references.
sharad.tomer
Posted 7 May 2020, 10:12 pm EST - Updated 3 October 2022, 12:09 am 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
Regards
jeff
Posted 9 May 2020, 7:11 am EST
Correct Solving 1) will also solve 2).
sharad.tomer
Posted 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.
sharad.tomer
Posted 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.
Regards
sharad.tomer
Posted 15 July 2020, 6:03 pm EST
Internal tracking ID for formula auto-fill: SJS-5007
jeff
Posted 21 August 2020, 6:22 am EST
Any updates on this ticket?
sharad.tomer
Posted 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.
Regards
jeff
Posted 29 August 2020, 9:25 am EST
Cool, We are particularly interested in:
A rough estimate of the release outlook would be great.
sharad.tomer
Posted 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.
avinash.pathak
Posted 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.
Regards
Avinash
petergroft
Posted 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,
Peter
