select row/column on demand [has inital code]
tobwen opened this issue · 2 comments
Is your feature request related to a problem? Please describe.
I'm always frustrated when A1 is selected when opening XLSX files having a header or filter in the first row.
Describe the solution you'd like
I want the topLeftCell to be the first data cell (e.g. TopLeft = A2 when there's a header in first row).
Describe alternatives you've considered
I wrote this code and it does when I want. I didn't create a PR, since I wanted to talk about this first aaaand came to another idea.
https://github.com/tobwen/openxlsx/tree/feature/select-topLeftCell
Additional context
After finishing the code, I was fallen asleep. When I woke up, I came to the idea that it might be better to implement a generic function to set the selected freely. So it won't depend on frozen cells, but could be set whenever, wherever.
Maybe something like this?
setActiveCell(wb, sheet, row, column)
setSelectionToCell(wb, sheet, row, column)
selectCell(wb, sheet, row, column)
This issue is stale because it has been open 365 days with no activity. Remove stale label or comment or this will be closed in 7 days.
This issue was closed because it has been stalled for 7 days with no activity.