Uploaded image for project: 'Jira Platform Cloud'
  1. Jira Platform Cloud
  2. JRACLOUD-76610

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

XMLWordPrintable

      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.

              Unassigned Unassigned
              rli@atlassian.com Rick Li
              Votes:
              7 Vote for this issue
              Watchers:
              11 Start watching this issue

                Created:
                Updated:
                Resolved: