Ctrl+Shift+Arrow highlights entire row/column even if cell has data

Posted by: mwyatt on 1 February 2022, 5:49 am EST

  • Posted 1 February 2022, 5:49 am EST

    Hello,

    When using say Ctrl+Shift+RightArrow, and focus is on A3. The entire 3rd row is highlighted instead of stopping focus on the first cell in that row that contains data and having all cells before that one highlighted.

    Example:

    • Go to cell B3 and enter in a number
    • Go to cell F3 and enter in a number
    • Go to cell A3 and press Ctrl+Shift+RightArrow

      Focus should be stopped at B3 and both A3 and B3 are highlighted. Pressing Ctrl+Shift+RightArrow again the focus would stop at F3 and cells A3-F3 are highlighted and focus is on F3.

    Thank you

  • Posted 1 February 2022, 10:38 pm EST

    Hi,

    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-11793

    Regards,

    Avinash

  • Posted 17 January 2023, 8:12 am EST

    Hello,

    Are there any updates to this issue?

    Thanks

  • Posted 17 January 2023, 4:59 pm EST

    Hi,

    We are sorry for delayed response. The issue has been fixed in our latest release that is 16.0.2. Please update to the latest build and let me know if you face any issues.

    regards,

    Avinash

  • Posted 17 February 2023, 7:43 am EST

    Hello,

    We are using v16.0.2 and still seeing this issue occur.

    Also still seeing the issue occur on https://www.grapecity.com/spreadjs/designer/index.html demo page.

    Is there any update on this?

    Thanks,

    Keith

  • Posted 19 February 2023, 4:53 pm EST

    Hello,

    We are sorry for the inconvenience. SpreadJS does not provide ctrl + shift + arrow keys behavior like ms excel. However, you can create your custom commands to override the default behavior of ctrl + shift + arrow keys.

    You can implement the shortcut keys(ctrl+shift+arrow keys like ms excel) in spreadjs with custom commands. You can create a custom command and register it with spread.commandManager() using spread.commandManager().register(name, command, key?, ctrl?, shift?, alt?, meta?) method. Keyboard key can be specified with other keys to execute a custom command. A custom command object has two properties canUndo and execute. execute(spread, options, isUndo) contains logic for command. Custom command is executed when corresponding keys are pressed. To perform navigation and selection operations on worksheet, you can use built-in commands in spreadjs.

    Please refer to the attached sample for further understanding.

    Sample: https://codesandbox.io/s/solution-forked-dzs25b?file=/src/index.js

    Doc References

    Custom Command Demo: https://www.grapecity.com/spreadjs/demos/features/worksheet/actions/custom-action/purejs

    spread.commandManager().register(): https://www.grapecity.com/spreadjs/api/classes/GC.Spread.Commands.CommandManager#register

    built-in commands: https://www.grapecity.com/spreadjs/api/modules/GC.Spread.Sheets.Commands#navigationleft

    keyboard keys codes: https://www.grapecity.com/spreadjs/api/enums/GC.Spread.Commands.Key

    Regards,

    Avinash

Need extra support?

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

Learn More

Forum Channels