Very high precision decimals

[spire_sphillips]

I'm trying to use Spire.XLS to read very high precision decimals out of Excel. I'm loosing precision in all attempts (including DisplayedValue).

My example is
Put this value into Excel: 0.0003410362464207640

When you read it from Spire, you get 0.0003410362460000000 whether you use NumberText, NumberValue, Value, Value2, or DisplayedText.

Is there any way to do this using Spire?

Thanks,

Sam

[Ula.wang]

Hi,

Thank you for your inquiry.
I tested the number you provided through the latest commercial version of Spire.Xls 13.12, but I didn’t encounter the same problem as you. Please download the latest commercial version of Spire.xls13.12 for retesting through the link：https://www.e-iceblue.com/Download/download-excel-for-net-now.html
I put the complete code below for your reference:

Code: Select all

// Create a new Workbook object
Workbook workbook = new Workbook();

// Load the workbook from the specified file path
workbook.LoadFromFile(@"..\test1.xlsx");

// Get the first worksheet in the workbook
Worksheet worksheet = workbook.Worksheets[0];

// Get the range of the specified cell
CellRange cell = worksheet.Range["A1"];

// Output the value of the cell
Console.WriteLine("The value of the cell is: " + cell.Value);

Sincerely,
Ula
E-iceblue support team

[spire_sphillips]

You are correct! I had a 12.xx version. The upgrade seems to have done the trick. Thank you!

[Ula.wang]

Hi,

Thank you for your feedback.
If you have any question, just feel free to write back. I hope you have a wonderful day.

Sincerely,
Ula
E-iceblue support team