autofilter problem with Excel 2010 #1262

Closed
opened 2018-09-07 11:21:24 +00:00 by nitramL · 2 comments
nitramL commented 2018-09-07 11:21:24 +00:00 (Migrated from github.com)

Hi,

I'm having trouble when setting the autofilter parameter.
The dropdown filter is present for the columns I specified in the range, but when using a filter (whatever the column) it either makes Excel to crah and close unexpectedly or do the filter as expected but in this case the dropdown filters disappear (for all the columns), so no possibility to filter again.
If I then close the Excel file, I can see a popup saying that something went wrong.
I'm using Excel 2010.

I have the same behaviour with the auto.xlsx output from your fiddle :
http://jsfiddle.net/sheetjs/8drvn0w3/

Hi, I'm having trouble when setting the autofilter parameter. The dropdown filter is present for the columns I specified in the range, but when using a filter (whatever the column) it either makes Excel to crah and close unexpectedly or do the filter as expected but in this case the dropdown filters disappear (for all the columns), so no possibility to filter again. If I then close the Excel file, I can see a popup saying that something went wrong. I'm using Excel 2010. I have the same behaviour with the auto.xlsx output from your fiddle : http://jsfiddle.net/sheetjs/8drvn0w3/
reviewher commented 2018-09-16 21:14:58 +00:00 (Migrated from github.com)

Can't reproduce in Excel 2010 (screenshot attached). What version are you using? (it's under File .. Help)
issue1262

Can't reproduce in Excel 2010 (screenshot attached). What version are you using? (it's under File .. Help) <img width="240" alt="issue1262" src="https://user-images.githubusercontent.com/24845478/45601019-fede0000-b9d3-11e8-9bec-2142c9c0acb9.png">
nitramL commented 2018-09-18 08:23:18 +00:00 (Migrated from github.com)

Thanks for your answer.
I'm using version 14.0.7212.5000 (32 bits)

Thanks for your answer. I'm using version 14.0.7212.5000 (32 bits)
Sign in to join this conversation.
No Milestone
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: sheetjs/sheetjs#1262
No description provided.