I found some unexpected behaviours when I format a cell with some custom strings. Attached is the file I tested with.
The double value of C7 is 7975723.64986856. With the format string as _(* #,##0.0,,_);[Red]* (#,##0.0,,);_(* "-"_);_(@_), I supposed to see "8.0" as string value but I didn't.
Check with format string 0.00E+00, which give me the right string value of "7.98E+06". But if I modify it to ##0.0E+0, I get 7975723.6E+0 instead of 8.0E+6 that shown in Excel.
I guess there is some round problem with Aspose.Cells. Can you please investigate and let me know? It is very urgent since we already release our software to many clients. Thanks.
I did a complete test on the fix 4.4.0.9. It appeared the problem with formatting was still there and Excel custom formatting isn't supported very well. Attached is the Excel file I tested with.
On cells c7:c10 and e7:e10, I saw correct numbers in Excel as follows:
8.0 (2.2)
$453,937 -$ 618,190
498 (122)
917.8 (175.8)
But when I used Cell.StringValue to show data, I got the following results:
8.0 *(2.233,874.9)
-$453,937- -$* 618,190_-
498 *(122)
917.8 *(175,796.7)
Those are kind of mess and I cannot give client these results. I think there are still some issues with converting Excel format to .Net format.