Hidden Column is visible #2117

New Issue

2020-09-28T13:18:24Z

appu-sm commented

2020-09-28 13:18:24 +00:00

(Migrated from github.com)

I have a XLS file which has few hidden columns, when i open it in sheetjs, the hidden columns are visible and there is no {hidden: true} property in [!cols]

DaivdLei commented

2021-06-17 06:57:54 +00:00

(Migrated from github.com)

excuse me. do you solution? please, i have the same question...

appu-sm commented

2021-06-18 01:46:44 +00:00

(Migrated from github.com)

I have started using xlsx files, for XLS files, during opening a file i automatically convert it into xlsx using php.

SheetJSDev commented

2021-09-17 09:02:56 +00:00

(Migrated from github.com)

For XLS, the change is in bits/76_xls.js

						colinfo[val.e--] = { width: val.w/256, hidden: !!(val.flags & 1) };

We'd accept a PR with this change

For XLS, the change is in [`bits/76_xls.js`](https://github.com/SheetJS/sheetjs/blob/master/bits/76_xls.js#L573) ```js colinfo[val.e--] = { width: val.w/256, hidden: !!(val.flags & 1) }; ``` We'd accept a PR with this change

Sign in to join this conversation.