Ctrl + [ not working between sheets or workbooks

Posted by: mwyatt on 7 October 2021, 6:46 am EST

  • Posted 7 October 2021, 6:46 am EST

    Issue 1: Say Sheet1 has a link =Sheet2!C4. Pressing Ctrl + [ will jump you to Sheet1 C4 instead of sheet 2

    Issue 2: doesn't work with links between separate workbooks (nothing happens)

    Issue 3: after you hit ctrl [ and it highlights the cells, pressing Enter just mo0ves off the first cell and un-highlights (in Excel, you can hit enter repeatedly and edit any of the cells within that range)
  • Marked as Answer

    Replied 7 October 2021, 9:30 pm EST



    You may create a custom command and set the selection according to the requirement. Please refer to the following sample and let me know if you face any issues.

    sample: https://codesandbox.io/s/condescending-https-1spgq?file=/src/index.js


    We are sorry but spreadJS does not support multi-workbook references. We are sorry for the inconvenience.


    We are sorry but spread does not support change the active inside the selection. we are sorry for the inconvenience.

  • Replied 1 November 2021, 4:24 am EST


    We feel that Issue1 is a bug and the default should match the functionality of Excel, where Ctrl + [ will jump you to the correct cell on the correct sheet.

    Is this something that can/will be fixed?

    Thank you

  • Replied 1 November 2021, 7:22 pm EST


    The dev is currently looking into it and it will be fixed in future releases but currently we don't have any ETA, We will update you once we have information from the team,

  • Replied 4 November 2021, 6:36 am EST


    I just wanted to give you an update and let you know that the developers are still working on fixing this, and we will let you know once it is fixed.

  • Replied 1 February 2022, 5:15 am EST


    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
  • Replied 2 February 2022, 10:14 pm EST


    We are able to replicate the issue at our end hence we have escalated this issue to the concerned team for further investigation. We will update you regarding this as we get any information from the team. The internal ID for this issue will be SJS-11799

  • Replied 24 February 2022, 9:17 pm EST


    The issue has been fixed in our latest 15.0.3 build. Please update to the latest and build and let me know if you face any issues.

Need extra support?

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

Learn More

Forum Channels