Issue with enableExcelCopyBuffer and Hidden Columns Causing Selection Offset

[hwlv]

Describe the bug

When using the enableExcelCopyBuffer option set to true in slickgrid-universal, I’ve encountered an issue where selecting a range of cells causes the selection area to be offset if there is a hidden column in the grid. It appears that the hidden column is being included in the calculations, leading to discrepancies between the mouse position and the selected cells.

Reproduction

1. Set enableExcelCopyBuffer to true.
2. Add a column with the hidden property set to true.
3. Attempt to select a range of cells that includes both visible and hidden columns.

Which Framework are you using?

React

Environment Info

| Executable          | Version |
| ------------------- | ------- |
| (framework used)    | VERSION |
| Slickgrid-Universal | VERSION |
| TypeScript          | VERSION |
| Browser(s)          | VERSION |
| System OS           | VERSION |

Validations

• Follow our Code of Conduct
• Read the Wikis.
• Check that there isn't already an issue that reports the same bug to avoid creating a duplicate.
• Check that this is a concrete bug. For Q&A open a GitHub Discussion.
• The provided reproduction is a minimal reproducible example of the bug.

[ghiscoding]

cc @zewa666

[ghiscoding]

The hidden column property was something that was added not that long ago in the 6pac/slickgrid project but it is not not fully supported. The Grid Presets is much more supported to hide columns.

EDIT

I see major differences between the 2 approaches

1. hiding a column from ColumnPicker/GridMenu/GridPresets will not create the column at all (array doesn't include hidden cols)
2. the hidden column definition will however container all columns but skip the hidden cols (we can see below that .l6.r6 col is skipped in the DOM) (array does include hidden cols)

Another distinction is that if I do a selection from 0,0 to H3, I get a different toCell (notice below to cell 8 vs 9)

• with hidden column definition: {"fromRow":0,"fromCell":0,"toRow":2,"toCell":9}
  • (it adds 1 more because hidden is counted in cols array)
• hide from ColumnPicker: {"fromRow":0,"fromCell":0,"toRow":3,"toCell":8}
  • (in here it's 1 less because it's not included at all in the cols array)