Make the Excel preview in Confluence locale-aware

XMLWordPrintable

    • Severity 3 - Minor

      Issue Summary

      Excel macro does not take the locale settings of excel into account when adding an excel file to confluence cloud using excel macro.Steps to Reproduce

      Steps to Reproduce

      On Mac:

      System settings >> language and region  

      1. Change your system setting to "Deutsch(Deutschland)-primary"
      2. Change region to germany
      3. Open excel >> create an excel file 
        Add number value to a cell eg: 1,234.00
        • #.##0,00 → Uses a dot (.) as the thousand separator and a comma (,) for decimals.
        • ;€ -#.##0,00 → Defines the format for negative numbers.

      Go to Format >> Format cells >> number >> custom 
      € #.##0,00;-€ #.##0,00

      Explanation of the Format Code:

      1. Save the file.

      The format would look like  1.234,00 as opposed to US format

      1. The format should look like  1.234,00 as opposed to US format

      On Confluence cloud:

      1. Create a page
      2. Add the excel file as an attachment to the page.
      3. Once, the file is attached the format changes to US format eg: 1,234.00 in Confluence

      Confluence cloud langauge is set to german and customer's language in id.atlassian.com is also set to german.

      Expected Results

      The number format in excel file should stay in german format.

      Actual Results

      Once, the file is attached the format changes to US format eg: 1,234.00 in Confluence 

      Workaround

      Currently there is no known workaround for this behavior. A workaround will be added here when available

            Assignee:
            Unassigned
            Reporter:
            Dollyk
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: