Uploaded image for project: 'CloverDX'
  1. CloverDX
  2. CLO-8007

SpreadsheetDataReader looses precision when reading numbers into strings

    XMLWordPrintable

    Details

    • Story Points:
      0.5
    • Branch:
    • QA Testing:
      Graph automated test
    • QA Test Identification:
      SDR_rawParsing_rawFormat, SDR_rawParsing_noFormat
    • Epic Link:
    • Sprint:
      PRG Sprint 8, PRG Sprint 9

      Description

      We can't read the data from xlsx file 'as is', meaning that I want to use string fields in my metadata to read the data and validate them in Validator afterwards.

      The problem is that we if the excel file contains i.e. 12.3456, MS Excel displays the value as 12.34 as the rest is hidden by used cell formatting.

      It can be adjusted using Text (and others) formats but that's not always feasible for the customer.

      We should be able to read the raw data as string, at least with some additional option in metadata format property, i.e. excel:raw.

      Interesting thing is, that if I play with the format, it turns out that the complete data/number IS actually available, see the 71428.001500002996 value in the error:

       Component [SpreadsheetDataReader:SPREADSHEET_DATA_READER1] finished with status ERROR. (Out0: 0 recs)
         Error in A2 in record 0, field 1 ("value"), metadata "LoosingPrecisionAsString_Sheet1"; value: '71428.001500002996', sheet: 'Sheet1'
          value (string) cannot be set to "71,428.00" - doesn't match defined format "#.####"; value: '71,428.00'
      

        Attachments

          Activity

            People

            Assignee:
            korbelj Jan Korbel
            Reporter:
            harazimj Jiri Harazim (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 1 day, 4 hours
                1d 4h