Uploaded image for project: 'ZK Spreadsheet'
  1. ZK Spreadsheet
  2. ZSS-1376

exporting causes an unexpected change of a currency number format in Excel

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: 3.9.3
    • Fix Version/s: 3.9.4
    • Component/s: None
    • Security Level: Jimmy
    • Labels:
      None

      Description

      Steps to Reproduce

      1. import 1376-explicitNumberFormat.xlsx
      2. export it
      3. open the exported file in Excel

      Current Result

      the number in A1 looks different from the one in the original file

      Expected Result

      Debug Information

      1. The source file style.xml contain an element:
      <x:numFmt numFmtId="176" formatCode=""$"#,##0.00_);[Red]("$"#,##0.00)" xmlns:x="http://schemas.openxmlformats.org/spreadsheetml/2006/main" /> but the exported file doesn't have that record.
      2. the exported file become built-in format index 8
      <x:xf numFmtId="8" fontId="0" fillId="0" borderId="0" xfId="0" applyNumberFormat="true" />

        Attachments

        1. 1376-explicitNumberFormat.xlsx
          9 kB
        2. excelTaiwan.png
          excelTaiwan.png
          2 kB
        3. expected.png
          expected.png
          15 kB
        4. incorrectExported.xlsx
          4 kB

          Activity

            People

            • Assignee:
              hawk hawk
              Reporter:
              hawk hawk
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: