We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Issues with a spreadsheet with filters

Hi There,

We are using Aspose.Cells to update built-in and custom properties dynamically in a spreadsheet. One of our spreadsheets has auto filter and when we save this spreadsheet with Aspose.Cells, the spreadsheet contains no rows other than the headers. Request your help to resolve this.

Regards,
Manikandan

Hi,

Thanks for your posting and using Aspose.Cells for .NET

Please download and use the latest version:
Aspose.Cells
for .NET v7.1.2.5



It is working fine.

Please see the code below and output file generated by it.

C#


var workbook = new Aspose.Cells.Workbook(“Before_IT-Req-URS-176347_1.xls”);


workbook.Save(“after.xls”, SaveFormat.Excel97To2003);



We are using Aspose.Cells for Java. Sorry for not mentioning that in my post.

Hi,

Thanks for your information.

I have found the latest version:
Aspose.Cells
for Java v7.1.2.5

is working fine.

Please see the code below. I have also attached the output file.

Java


String filePath = “Before_IT-Req-URS-176347_1.xls”;


Workbook workbook = new Workbook(filePath);

workbook.save(filePath + “out.xls”, SaveFormat.EXCEL_97_TO_2003);

Hi,

We are currently using Aspose.Cells-2.5.4 in our production. Is there any workaround for this issue with the current build we have in Production.

Thanks,
Manikandan

Hi,

I am afraid, we only provide fixes based on latest version.

There has been major changes in Aspose.Cells for Java since v7.0 so we strongly recommend you to upgrade your code according to the latest version.

Now, Aspose.Cells for .NET and Aspose.Cells for Java both have similar code and there are not any differences.

Anyway, you could try the most recent release of Aspose.Cells for Java before v7.0 and see if it resolves your issue.

Aspose.Cells for Java v2.5.4.20