sheet[!rows] not including all hidden rows #1413

New Issue

2019-01-24T01:46:57Z

kcwitt commented

2019-01-24 01:46:57 +00:00

(Migrated from github.com)

Not all hidden rows are included in the sheet['!rows'] array.

Hide the first two rows on a brand new spreadsheet, and then open with js-xlsx (using cellStyles: true) and only row 0 will show in the sheet['!rows'] array (instead of both rows 0 and 1).

Seems to work okay with the sheet['!cols'] array.

js-xlsx ver. 0.14.0
Excel ver. 16.21

Not all hidden rows are included in the `sheet['!rows']` array. Hide the first two rows on a brand new spreadsheet, and then open with js-xlsx (using `cellStyles: true`) and only row 0 will show in the `sheet['!rows']` array (instead of both rows 0 and 1). Seems to work okay with the `sheet['!cols']` array. js-xlsx ver. 0.14.0 Excel ver. 16.21

Sign in to join this conversation.