Hello,
i have trouble reading small numbers from xlsx-files by using the spread processing components. in the attached file you can see an example. column A contains the values i want to read which are computed from row 2 to row 8. the used formula can be seen in column B. column C contains the values that the spread processing is able to read using
workbook.Worksheets[0].Cells[4,0].GetValue().Value.GetResultValueAsString(CellValueFormat.GeneralFormat)
i'm able to read small numbers that aren't computed by using
workbook.Worksheets[0].Cells[4,0].GetValue().Value.RawValue
what is the proper way to read the computed result values?
6 Answers, 1 is accepted
Thank you for reporting this issue.
I have logged it in our backlog with high priority. I hope we will manage to fix it soon. I have logged a public item in our Feedback portal where you can track the progress on the matter.
As a token of appreciation for reporting this issue, I have updated your Telerik Points.
Regards,
Nikolay Demirev
Telerik by Progress
Hello Nikolay
is there still no workaround for the issue?
At this moment we can't give any suitable workaround for this issue. You can subscribe for the item in our feedback portal (mentioned in the last reply from Nikolay) in order to receive notification of the status change.
Regards,
Dinko
Telerik by Progress
Hi Dinko,
i noticed that nothing happend with the issue in the feedback portal since i reported it 6 months ago. i'm following this item but thanks for the hint.
We want to know if the issue will be solved soon? Otherwise we need to switch to a different framework.