x-spreadsheet icon indicating copy to clipboard operation
x-spreadsheet copied to clipboard

Am I the only one here thinks the sort and filter function is not working?

Open Ta-LT opened this issue 4 years ago • 10 comments

The sorting only sorts by data index, and filter function often make all the data rows disapper, and it is not only happening in my code but also happening in the docs/index.html. Can someone comfirm this please?

Ta-LT avatar Apr 09 '20 06:04 Ta-LT

1, select area 2, click filter image

myliang avatar Apr 09 '20 06:04 myliang

Enter 50 a and a few b like so" image then select the first colum and set the filter like so: image then click OK and it's all gone image

And sorting is only sorting by the row index image

Ta-LT avatar Apr 09 '20 08:04 Ta-LT

And are you sure this is going to work? image If the exceptRowTotalHeight is bigger than the canvas' height, not a single row is ever gonna show.

Ta-LT avatar Apr 09 '20 08:04 Ta-LT

And all the t && t.text ? t.text : ""; needs to be changed to t && t.text != null ? t.text : ""; otherwise all 0s bind by code will be shown as empty string.

Ta-LT avatar Apr 09 '20 08:04 Ta-LT

use filter without freeze

myliang avatar Apr 09 '20 09:04 myliang

I'm not using freeze.

Ta-LT avatar Apr 09 '20 09:04 Ta-LT

this is a problem about filter

myliang avatar Apr 09 '20 10:04 myliang

@myliang Have you recently considered solving sort bug?

monkeydp avatar May 22 '20 02:05 monkeydp

@myliang Any update fix for this?

Leroyace avatar Jan 13 '21 23:01 Leroyace

Having the same issue. Has anyone been able to fix it on their own? P.S. It seems to be an issue with the last option in the filter. If you have multiple options in the filter. All except the last one work. If you select the last one plus any of the ones above it still works.

amritsingh22 avatar Feb 01 '22 22:02 amritsingh22