Posted 1 February 2022, 5:15 am EST
Hello,
We are using the latest SpreadJS extension and are now seeing 2 new issues.
Bug 1: Formula includes references to both same sheet and different sheet (eg. = C5 + Sheet2!E7 , or = Sheet2!E5 + C7 + Sheet2!R6, etc.)
Ctrl + [ will only apply to the sheet of the first reference in the formula.
What this means, is if the first argument is on the same sheet, highlight all items on that sheet that go into that formula. If the first argument is on a separate sheet from the formula, jump to that sheet and highlight all items on that sheet that go into that formula (dependent on the AC decided upon for use case 2). Ignore cells that exist on the other sheets.
The cursor should be moved to the first cell that makes up that formula
Bug 2: After pressing Ctrl + [ a user can use Tab to move between the referenced cells. If the cells are not a continuous row (ex. =C5 + L7 +E11), when initially tabbing through the cells the cursor will first move through all the blank cells in between. On the second time tabbing through, only the referenced cells will be shown. This bug also exists for Ctrl + ]. This happens both when references are on the same sheet or a different sheet.
When pressing tab after Ctrl + [, only the reference cells should be toggled through and not any blank cells in between