- Operating system version & architecture
- Locale/Regional setting of the machine
- JDK vendor & version
- JVM arguments (if any)
- Complete source code (preferably a sample console application)
- Sample spreadsheets for testing
Following in the architecture and CPU configuration we running against. Due to company policy we cant provide you the actual sheet. but the code is pretty much what is mentioned in my post. All we are doing is opening excel files and inserting certain data to that and forcing a calculation. and saving the results. let me know if we can schedule a call to provide additional information needed.
|CPU op-mode(s)||32-bit, 64-bit|
64-Bit Server VM (build 24.79-b02, mixed mode))
Also if you can let us know any benchmark available processing 15 MB excel files from your end.
Sundarrajaspose:Also if you can let us know any benchmark available processing 15 MB excel files from your end.
Sundarrajaspose:File size is due to number of sheets and data inside the sheet. I wasn't suggesting the size was because of the formula. Its our company policy we cant share the actual spreadsheets which are very complex to create a sample. if needed we can have a working session to explain the issues that we are trying to address.
Sundarrajaspose:We need a technical suggestion on the following1) how to reduce the load time (Instead of loading the same sheet again and again can we do something in memory to clone the Worksheet Object)2) Best practices to reduce the calculation time.
Sundarrajaspose:We are working on using the latest aspose jars. currently running in to issues there are some calculation difference between the existing version aspose-cells-22.214.171.124 and aspose-cells-126.96.36.199. Trying to figure out which formula is getting calculated wrongly. We had issues before with the api and got it fixed through a patch. can you please confirm if the patch is included in the latest version.Here is link for the old ticket.http://www.aspose.com/community/forums/577525/sumproduct-with-indirect-not-working/showthread.aspx#577525