Excel file preview showing wrong date if using customized format such as 'yyyy/m/d(aaa) '

XMLWordPrintable

    • 4
    • Severity 3 - Minor
    • 0

      Issue Summary

      Excel preview showing wrong date if using yyyy/m/d(aaa) customized format.

      Steps to Reproduce

      1. Create a Excel file
      2. Input '2021/4/28' in Excel
      3. Set the format as customized: 'yyyy/m/d(aaa)'
      4. Save the file
      5. Upload the excel file into a ticket, and preview the Excel file in ticket.

      Expected Results

      Showing 2021/4/28(Wed) as setting in Excel

      Actual Results

      Showing 2021/2/16(wed)

      Workaround

      Set the text formats for the dates, or download the attachment and view it.

        1. jira_excel_date_format_1.png
          54 kB
          Rick Li
        2. jira_excel_date_format_2.png
          13 kB
          Rick Li

              Assignee:
              Unassigned
              Reporter:
              Rick Li
              Votes:
              7 Vote for this issue
              Watchers:
              11 Start watching this issue

                Created:
                Updated:
                Resolved: