-
Type:
Bug
-
Resolution: Duplicate
-
Priority:
Low
-
Component/s: Macros - Attachments, Macros - Other - Native (1st Party)
-
None
-
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
- Change your system setting to "Deutsch(Deutschland)-primary"
- Change region to germany
- 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:
- Save the file.
The format would look like 1.234,00 as opposed to US format
- 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
- mentioned in
-
Page Loading...