I would like to hide the filters in the viewer. Is there a configuration setting that allows this?

Aspose.Cells Product Family
1

Hi Team ,
I don’t want filters to be visible in the viewer. Is there a configuration to hide them?

I attached the sample file EDA.PC.00000142.zip (3.2 MB)

image.png656×655 38.1 KB
image.png (38.1 KB)

2

@sarathepiq
We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSGRIDJS-1978 Support hide autofiter in readonly mode

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

3

Don’t we have any existing configuration to hide filters in the viewer?

4

@sarathepiq,

As a workaround temporarily, you could consider using the Aspose.Cells library to parse the file, disable the filter button, and then save it to the desired filepath or streams. This file can subsequently be loaded into the grid matrix using Aspose.Cells.GridJs. We hope the provided sample code snippet will assist you.

Workbook workbook = new Workbook("e:\\test2\\EDA.PC.00000142.xlsx");
Worksheet worksheet = workbook.Worksheets[0];
worksheet.ListObjects[0].AutoFilter.ShowFilterButton =false;
workbook.Save("e:\\test2\\out1.xlsx");

Hope, this helps a bit.

5

Is there any way to handle it in client side scripts?

6

@sarathepiq,

We apologize for the inconvenience, but currently, there is no alternative or workaround available in client-side scripts. Kindly wait as we will work on resolving the ticket (CELLSGRIDJS-1978) and releasing the updated supported (GridJs) version. Thank you for your patience.