LightCells.getInstance() throws java.io.IOException: You are using an evaluation copy and have opened files exceeding limitation

Aspose.Cells Product Family
21

Hi,

For the issue of getting evaluation limit for LightCells, we fixed one bug of checking license. The bug would cause such kind of issue when an application accesses LightCells class(in the same word, JVM initializes LightCells class) before setting license, such as following code sequence:

LightCells inst;
…;
License lic;
…;
lic.setLicense(…);

From fix 2.5.0.2, we have fixed this issue by checking the license setting dynamically. And it is the only one bug we have found that may cause evaluation limit with valid license.

Thanks for your understanding!

22

Hi Amjad,

We are testing our application with the new Aspose jar that you have provided.

We are getting an exception while setting the below formula.This Formula was supported in earlier version of the Jar. Please provide new version of jar with the fix for this issue at the earliest.

java.lang.IllegalArgumentException: Unsupported formula : =AJ7+AL7+AN7+AR7+AT7+AV7+AZ7+BB7+BD7+BH7+BJ7+BL7).

Regards

Karuppiah

23

Hi,

Kindly give us your template file and sample code to reproduce the issue on our end, we will check your issue and figure it out (if we found the issue) soon.

Thank you.

24

Hi Amjad,

As requested by you, please find attached a zip file containing sample program "SampleProgram.java" and "SampleWorkbook.xls".

Treat this as critical item. We plan to move the new jar to our Production environment in another 4 days. Ensure that whatever fix you provide does not break the existing functionality in the current jar. We do not have enough time to perform an end-to-end testing with the new jar.

Thanks and Regards,

Karuppiah

25

Hi,

Thanks for the sample code and template file.

Well, in fact you are trying to input wrong formula with only the right ‘)’ without its ‘(’ to match. Even in MS Excel it is not allowed, you may test/confirm it. Actually, in recent versions we have made many enhancements for parsing and calculating formulas with accuracy, also some constraints have been made stronger when checking the user’s input formulas which our component should do.

For you case, either you should use: “=(A2+B2+A4)” or “=A2+B2+A4” but kindly do not use:
"=A2+B2+A4)".

Thanks for your understanding!