Hi - I see some similarity with StringValue/DisplayStringValue converting Text to Scientific Notation - #2 by amjad.sahi, but we have a customer who is using our product which uses Aspose.Cells to get raw text out of Excel documents.
In this instance for any cell type which is numeric, we output it as follows:
if (cell.getType() == CellValueType.IS_NUMERIC)
{
cellText.append(cell.getStringValueWithoutFormat().trim());
}
However they are seeing 4.265525E8 rather than 426,552,500 and 6.80792319E8 instead of 680,792,319 which is not desirable for our use-case.
I would expect getStringValueWithoutFormat() to output the number without scientific formatting like this. If this is not correct, can you suggest the right code please to get the raw number?