I use an existing excel workbook, which has an active auto filter. The auto filter works on the formula in column D, which in turn tests the values in column C for a certain text.
(see attached auto_filter_scaffold.xlsx)
The sheet is filled new data. Afterwards all formulas are calculateed (workbook.calculateFormula()) and the auto filter refreshed (sheet.getAutoFilter().refresh()).
Opening the workbook in excel the auto filter does not work and shows also not matching rows. I need to open the filter dialog and press ok.
(see attached auto_filter_filled.xlsx)
The auto filter works, when I omit the formulas. Also the formulas are correctly calculated (I printed them before saving).
Is this a known issue or are any additional calls to perform (like calculateFormula etc).
I am using aspose-cells-184.108.40.206
Thank you very much!
String filePath = “auto_filter_filled.xlsx”;
Workbook workbook = new Workbook(filePath);
Worksheet worksheet = workbook.getWorksheets().get(0);
are there any news on this topic?
Thanks for your posting and using Aspose.Cells.
We have checked your issue status from our database and found your issue is fixed. We will provide you a fix in couple of days hopefully before the end of this week. Once, the fix is available for you, we will update you asap.