Gridjs-selector can be misaligned when sheet has freeze panes

Aspose.Cells Product Family
1

We’ve noticed an issue with selector rendering in gridjs-spreadsheet when a sheet has freeze panes enabled. Notice how the selector is rendering next to row 10, but row 8 is the active selection (set programmatically in the console with window.spreadsheet.setActiveCell(7, 9):

image.png (336.7 KB)

The issue can be reproduced with sampledataworkorders.xlsx.zip (4.0 MB) using the following steps:

  • Switch to Instructions sheet
  • Select a cell from row 4 or further down
  • Switch to a different sheet, then back to Instructions

The selector will be in the wrong spot. It looks like it’s offset by the size of the freeze pane, which makes sense given this only seems to happen with sheets that have freeze panes.

If you try and update the selector with setActiveCell, it will still be in the wrong spot. Interestingly, clicking a cell will put the selector in the correct location.

2

@jrf.att
We can reproduce this issue.
We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSGRIDJS-907

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

3

@jrf.att
Please try the latest client script v23.9.1 for GridJs.
this issue shall be fixed.

4

The issues you have found earlier (filed as CELLSGRIDJS-907) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi