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

Viewxls macro format date didn't adapt Windows locale

XMLWordPrintable

      Problem Description
      When you uploaded excel file to Confluence, and use Viewxls macro, the Date format will be reverted to US even though the format cell is already in other locale. This will only replicated when the Windows locale is the same with the one in Excel.

      Steps to replicate

      1. Change Windows Locale to Other language such as German
      2. Create an Office Excel file and enter date “31.12.2012” in cell A1.
      3. Check the locale and you will see that the Language is already in German.
      4. Save the file.
      5. Upload the file to Confluence
      6. Use Viewxls to view the file
      7. You will see that the date will be reverted to US format

        1. Date-Problem.PNG
          Date-Problem.PNG
          15 kB
        2. Test-Datum.xlsx
          8 kB

            [CONFSERVER-27237] Viewxls macro format date didn't adapt Windows locale

            Dubrau, Gunther (Allianz Technology, externer Mitarbeiter) added a comment -

            Known since 2012 and not fixed? I am suprised.....

            Dubrau, Gunther (Allianz Technology, externer Mitarbeiter) added a comment - Known since 2012 and not fixed? I am suprised.....

            François Longchamp added a comment -

            To be corrected please

            François Longchamp added a comment - To be corrected please

            Thomas added a comment -

            Confluence Server 7.10.1, issue is still there.

            Thomas added a comment - Confluence Server 7.10.1, issue is still there.

            Sven Alebrand added a comment -

            Confluence Data Center 7.4.7, still an issue. This is embarrassing.

            Sven Alebrand added a comment - Confluence Data Center 7.4.7, still an issue. This is embarrassing.

            Matthew Furry added a comment -

            Atlassian is abandoning us on-prem users... probably won't fix. 

            Matthew Furry added a comment - Atlassian is abandoning us on-prem users... probably won't fix. 

            Daniel Reschetow added a comment -

            Confluence Server 7.4.0, still an issue.

            Daniel Reschetow added a comment - Confluence Server 7.4.0, still an issue.

            Dirk Lindner added a comment -

            I think, the decimal separator Problem is the same Problem like this: https://jira.atlassian.com/browse/CONFSERVER-32549

            XLS works fine, but not as XLSX (Conf Serv 6.14.3 and 7.2.1)

            Dirk Lindner added a comment - I think, the decimal separator Problem is the same Problem like this:  https://jira.atlassian.com/browse/CONFSERVER-32549 XLS works fine, but not as XLSX (Conf Serv 6.14.3 and 7.2.1)

            Michael Bachmann added a comment -

            Still an issue in Confluence 7.3 with german date format in the Excel file.

            Michael Bachmann added a comment - Still an issue in Confluence 7.3 with german date format in the Excel file.

            Dominic Lagger added a comment -

            This issue still persists in Confluence 6.13.6
             

            Dominic Lagger added a comment - This issue still persists in Confluence 6.13.6  

            Dmitrii Kurillo added a comment -

            Still not fixed? The same problem...

            Dmitrii Kurillo added a comment - Still not fixed? The same problem...

              Unassigned Unassigned
              rjmasikome RianA
              Affected customers:
              70 This affects my team
              Watchers:
              62 Start watching this issue

                Created:
                Updated: