Small computed numbers

7 posts, 0 answers
  1. Mathias
    Mathias avatar
    5 posts
    Member since:
    Mar 2016

    Posted 18 Aug 2016 Link to this post

    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?

  2. Nikolay Demirev
    Admin
    Nikolay Demirev avatar
    126 posts

    Posted 22 Aug 2016 Link to this post

    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

  3. Mathias
    Mathias avatar
    5 posts
    Member since:
    Mar 2016

    Posted 10 Feb Link to this post

    Hello Nikolay

     

    is there still no workaround for the issue?

  4. Mathias
    Mathias avatar
    5 posts
    Member since:
    Mar 2016

    Posted 10 Feb Link to this post

    I tried some other formulas and it seems that the divide-operation only causes these problems (see attachment)
  5. Dinko
    Admin
    Dinko avatar
    361 posts

    Posted 15 Feb Link to this post

    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

  6. Mathias
    Mathias avatar
    5 posts
    Member since:
    Mar 2016

    Posted 16 Feb Link to this post

    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.

  7. Dinko
    Admin
    Dinko avatar
    361 posts

    Posted 17 Feb Link to this post

    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

Back to Top