Posted 20 February 2023, 4:17 am EST
Hello,
I couldn’t find a way to tell if a specific row is filtered or not using the getAutoFilter property in server side ( in client it is possible…) ,
is there anyway to do it?
Thanks
Server side filtered rows indication
Posted by: asaf.shechter on 20 February 2023, 4:17 am EST
-
asaf.shechter
-
avinash.pathak
Posted 21 February 2023, 5:46 am EST
Hello,
SpreadJS is a client-side based application. Please specify what your use case is and how exactly you are using spreadjs on backend so that we can investigate the issue more efficiently and provide you better assistance.
Regards,
Avinash -
avinash.pathak
Posted 22 February 2023, 6:20 pm EST
Hi,
It seems like you are using GCExcel Java on your backend. Please refer to the following code snippet to get if the row is filtered or not.
boolean isRowFiltered = workbook.getWorksheets().get(sheetIndex).getAutoFilter().getRange().getRows().get(rowIndex).getHidden();Regards,
Avinash -
asaf.shechter
Posted 1 March 2023, 9:09 pm EST
Hi,
we checked this function and it doesn’t seem to work for us in a specific case :
original sheet :
sheet after row 2 is filtered :
now if you check if row 3 is hidden in server side you will also get true ,
seems like a bug with a big decimal numbers ,
is there a way to overcome it or we need to wait for a bug fix ?
Thanks. -
avinash.pathak
Posted 2 March 2023, 6:40 pm EST
Hi,
We have forwarded this to the GcDocs team for investigation and will share the update soon.
Regards,
Avinash -
prabhat.sharma
Posted 6 March 2023, 2:36 pm EST
Hello Asaf,
Apologies for the delay in response.
We have created an excel file as shown in your attached screenshot but do not face the issue of getting if the row is hidden or not.Please find the attached stripped-down sample implementing the same and let us know if you are doing anything different.
Regards,
Prabhat Sharma.
RowFilterDemo.zip -
asaf.shechter
Posted 6 March 2023, 9:15 pm EST
Hi Prabhat,
please try the example I posted message before,
with 7 digits after the decimal point,
Thanks. -
prabhat.sharma
Posted 9 March 2023, 5:50 pm EST
Hello Asaf,
Please find the attached excel file that we have tested at our end and it is working fine. Please update it accordingly so that we can replicate the issue on our end and assist you further accordingly.
Also, let us know the version of the GcExcel Java API you are using.
Regards,
Prabhat Sharma.
FilterDemo.zip -
asaf.shechter
Posted 14 March 2023, 9:45 pm EST
Hello again,
we found what was the issue ,
for some reason spreadjs create a default named styles and we also found which specific one causes this issue :
after removing it from the workbook seems like this bug is solved ,
what is your suggestion regarding this issue?
currently we can remove this default style but seems like there is a bug in spreadjs side… -
ankit.kumar
Posted 16 March 2023, 4:36 pm EST
Hi Asaf,
The “__builtInStyle1” styles are created internally by the SpreadJS.
I tested with the latest version of SpreadJS V16.0.4 and I was unable to replicate the issue at my end. At my end, I tried importing the attached Excel file into the SpreadJS and it seems to be working fine at my end.
With the excel file imported, if the row with value “1” is filtered, then SpreadJS does show it as filtered and vice-versa.
Could you please share the exact steps to reproduce the issue with SpreadJS and GCExcel. Also, mention the SpreadJS and GCExcel version also.
If you are facing the issues with any particular file, kindly share the excel file with us.
Regards,
Ankit
-
asaf.shechter
Posted 20 March 2023, 8:13 pm EST
Hi,
please try to create this example in SpreadJS first (so you will have __builtInStyle2).
After that send the workbook with the built in styles and this exact filter to the server and this bug should be reproduced.SpreadJS version 15.1.3
GcExcel version 5.1.3 -
ankit.kumar
Posted 22 March 2023, 4:03 pm EST
Hi Asaf,
Currently, we are investigating the issue at our end with SpreadJS and GCExcel Java. We will update you on this soon.
Regards,
Ankit -
ankit.kumar
Posted 23 March 2023, 1:58 pm EST - Updated 23 March 2023, 2:03 pm EST
Hi Asaf,
I tested with the latest versions of SpreadJS V16.0.5 and GCExcel Java V6.0.5 and I was unable to replicate the issue at my end. It seems like the issue has been fixed in the latest versions of SpreadJS and GCExcel. I request you to kindly upgrade to the latest version of SpreadJS and GCExcel and let us know if you face any issues.
For SpreadJS Testing, I generated the excel file from SpreadJS by visiting the hosted SpreadJS Designer: https://www.grapecity.com/spreadjs/designer/index.html
You could refer to the following gif that shows the steps.
Then the exported excel file is imported in GCExcel Java and checked if the row is filtered out. It was also working fine as expected.
You could refer to the following image that we have used for testing.
For GCExcel, please find the sample that we have used for testing.
Please try upgrading the versions and if the issue still persists for you, kindly share a sample replicating the issue so that we could investigate further and assist you accordingly.
Regards,
Ankit
