I’m working with Aspose.Cells version 7.0.1. We are upgrading from version 220.127.116.11.
I am finding that the getStringValue() method in version 7 returns inconsistent results depending on whether the cell has a format set or not (e.g. Number & Decimal places). In the older version the display value is always returned.
Attached are two excel files with identical tables & values except that the format in one is set to something specific (e.g. Number), while the other one is set to General.
In both files the user sees the same display value in excel. For example a cell contains -0.4 which is what the user sees. The getStringValue in aspose7 returns -0.4 if the cell has a Number format & 1 decimal place setting. However it returns -0.400000001066712 if the setting is General.
In aspose2 it consistently returns the display value of -0.4.
Is there are fix for this in aspose7? Your help on this would be greatly appreciated.
Our license allows up to version 7, however if this is a known issue in that version, and there is no workaround available then we will need to consider your recommentation. I will check with our management team for Aspose licensing/upgrade.
I take it that the latest version can be run, without issue on Java 1.6?