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.