Summary

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

Steps:

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
4. • #.##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 language is set to german and customer's language in id.atlassian.com is also set to german.

Customers would like the number format in excel file to stay in german format.

Current scenario:

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