Hello,
I’m using Aspose.Cells version 7.2.0.0 from a component developed in .NET. It takes an xls file with data and merge it with another xls file which is a template, with a specific format, filtered columns, etc. This template has around 60 columns with data and 40 columns with functions.
I generate a file with 5000 rows with this component. When I open it and try to filter rows using Excel filters, it takes a los of time -around 20 seconds- to refresh the workbook with filtered rows.
This behavior doesn’t occur when generating a file with few rows (less than 1000) or when using a template without any Excel function.
But it still occurs using 8.2.2.0 and 8.4.1.0 versions of Aspose.cells.
.NET Framework is 4.4.0.
I hope somebody could help me with this problem.
Thanks,
Ariel
Hi Ariel,
Thank you for contacting Aspose support.
It would be of great help in identifying the bottlenecks in your application if you can provide us an executable standalone sample application replicating the said issue. Anyway, as you are currently using 7.2.0, an older release of the Aspose.Cells for .NET API, you cannot use the memory preferences introduced in the more recent releases. Please check the
detailed article, and give this approach a try on your end with latest release v8.4.1. In case the problem persists, please provide us a sample application for review.