Spreadsheet filter: cannot filter {blank} data

Discussion of the "Documents" module
Post Reply
Posts: 1
Joined: Sat May 26, 2018 4:42 pm

Spreadsheet filter: cannot filter {blank} data

Post by leandrochaves » Sat May 26, 2018 5:30 pm

So here is the thing the spreadsheets:
I have an open range data set, i.e., as more information is added, more rows are added to the data set.
Therefore, I define the filter to be not a limited range, but rather entire columns (12 columns in total).
As a consequence, beyond the last row which has information, there will be {blank} cells (which are included in the filter options)
When an user applies a filter, which inadvertently tries to exclude the {blank} cells, the entire Spreadsheets Editor crashes.

I believe this is because the Spreadsheets Editor is trying to hide all the millions {blank} rows beyond the last line.
A friend once told me that in the MS Excel, the app locates the last row and the last column which has non-blank information, and ignores everything beyond that.

So my question is: is there a workaround for this problem, besides telling all users to never uncheck the {blank} options in the filter?

Posts: 200
Joined: Mon Feb 09, 2015 11:17 am

Re: Spreadsheet filter: cannot filter {blank} data

Post by Kate » Mon Jun 11, 2018 9:52 am


We could ask you to provide us with some additional information:

- please send us screenshots of each the step you perform;
- send us your spreadsheet file.

Post Reply