SpreadProcessing: GetValue().Value.ResultValueType set to wrong type "text" and the Value to "error"

Telerik Document Processing Feedback Portal

Create an account Log In

Back to Feed

Request a Feature Report a Bug

Declined

Last Updated: 08 May 2018 13:00 by ADMIN

Stefan

Created on: 27 Apr 2018 15:30

Category: SpreadProcessing

Type: Bug Report

SpreadProcessing: GetValue().Value.ResultValueType set to wrong type "text" and the Value to "error"

When iterating through the rows and cells of an imported Worksheet in at least one of the rows GetValue().Value.ResultValueType for a number cell is set to GetValue().Value.ResultValueType.Text and the value to "error" or "string".

For us this happens in a worksheet with 200 rows max. and columns formated as date, time, time followed by some text and number columns.
In our Tests with different excel files it allways happened once (between line 11 and 16) and only for the first two columns.

Exporting the worksheet back into a new excel file will show all rows and columns types and values OK.

3 comments

ADMIN

Tanya

Posted on: 08 May 2018 13:00

After further discussion in the private support channel, it turned out that the behavior is related to the concrete implementation and not to the library. Thus, I am declining this item.

Stefan

Posted on: 02 May 2018 11:30

Hello,
i opened a support ticket (1164857) with some more informations attached.

Hope this helps.

Andreas

ADMIN

Tanya

Posted on: 02 May 2018 07:03

Hi Stefan,

Let's continue our conversation in the forum (or if it would be better for you, in a support ticket) so we can gather more details about the case. At this point, we couldn't reproduce the behavior so would be of a great help if you can share more information about the exact scenario.

Regards,
Tanya