Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-59312

Preview/Excel macro uses US date format (MM/DD/YYYY) for Excel documents containing dates in European format (DD/MM/YYYY)

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Low Low
    • None
    • 7.2.0, 7.13.0
    • Content - File Previews
    • None

      Issue Summary

      Preview/Excel macro uses US date format (MM/DD/YYYY) for Excel documents containing dates in European format (DD/MM/YYYY)

      Environment

      • Confluence 7.2

      Steps to Reproduce

      1. Create MS Excel document.
      2. Add date to one of the spreadsheet cells in European Format for example 30.12.2019 or 30/12/2019
      3. Create new page upload above document to the page.
      4. Add new Excel macro and by using previously uploaded Excel document
      5. Save the page
      6. Preview the page,

      Expected Results

      Date from the spreadsheet cell is displayed as 30/12/2019

      Actual Results

      Date from the spreadsheet cell is displayed as 12/30/2019

      Workaround

      Currently there is no known workaround for this behavior. A workaround will be added here when available
      Possible of help, in Excel, right-click the cells and select Format cells... > Date > English[United Kingdom]. Then the date formatting of preference. Once uploaded in Confluence it will show correctly.

      Additional notes

      Above bug occurs regardless of user language profile setting or global language setting in Confluence

            [CONFSERVER-59312] Preview/Excel macro uses US date format (MM/DD/YYYY) for Excel documents containing dates in European format (DD/MM/YYYY)

            Jörn Donneau added a comment -

            This affects my customer on 8.5.x as well

            Jörn Donneau added a comment - This affects my customer on 8.5.x as well

            Marco Leist added a comment - - edited

            Interestingly, the error seems to occur only with .xlsx files, but not with the old Excel 97 format (.xls)

            Marco Leist added a comment - - edited Interestingly, the error seems to occur only with .xlsx files, but not with the old Excel 97 format (.xls)

            faizul.rabbe added a comment -

            this issue i believe affects Jira Service Management Cloud too. Excel preview in the ticket shows US date but when you download and open it in Excel it shows European date format

            faizul.rabbe added a comment - this issue i believe affects Jira Service Management Cloud too. Excel preview in the ticket shows US date but when you download and open it in Excel it shows European date format

            Glen Ritchie added a comment -

            This is probably related to, if not the same, as this known issue, open since 2012

            https://jira.atlassian.com/browse/CONFSERVER-27237

            Glen Ritchie added a comment - This is probably related to, if not the same, as this known issue, open since 2012 https://jira.atlassian.com/browse/CONFSERVER-27237

              Unassigned Unassigned
              gkowalczyk GMK
              Affected customers:
              46 This affects my team
              Watchers:
              33 Start watching this issue

                Created:
                Updated: