This is a migrated thread and some comments may be shown as answers.

Small computed numbers

6 Answers 63 Views
SpreadProcessing
This is a migrated thread and some comments may be shown as answers.
Mathias
Top achievements
Rank 1
Mathias asked on 18 Aug 2016, 06:29 AM

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

Sort by
0
Nikolay Demirev
Telerik team
answered on 22 Aug 2016, 11:44 AM
Hello Mathias,

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

0
Mathias
Top achievements
Rank 1
answered on 10 Feb 2017, 12:26 PM

Hello Nikolay

 

is there still no workaround for the issue?

0
Mathias
Top achievements
Rank 1
answered on 10 Feb 2017, 12:51 PM
I tried some other formulas and it seems that the divide-operation only causes these problems (see attachment)
0
Dinko | Tech Support Engineer
Telerik team
answered on 15 Feb 2017, 09:29 AM
Hi Mathias,

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

0
Mathias
Top achievements
Rank 1
answered on 16 Feb 2017, 08:15 AM

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.

0
Dinko | Tech Support Engineer
Telerik team
answered on 17 Feb 2017, 01:01 PM
Hi Mathias,

This issue is already planned for implementation and it will be available in our next release. When the issue is fixed we will update the item status in our feedback portal.

Regards,
Dinko
Telerik by Progress

Tags
SpreadProcessing
Asked by
Mathias
Top achievements
Rank 1
Answers by
Nikolay Demirev
Telerik team
Mathias
Top achievements
Rank 1
Dinko | Tech Support Engineer
Telerik team
Share this question
or