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" />

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

        Activity

        There are no comments yet on this issue.

          People

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

            Dates

            • Created:
              Updated:
              Resolved: