• Type: Bug
• Resolution: Unresolved
• Priority: Low
• Fix Version/s: None
• Affects Version/s: 7.2.0, 7.13.0
• Component/s: Content - File Previews
• Labels:

  None

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

SET Analytics Bot made changes - 24/Jan/2025 2:02 AM

UIS

Original: 4

New: 2

SET Analytics Bot made changes - 10/Jan/2025 2:04 AM

UIS

Original: 7

New: 4

SET Analytics Bot made changes - 23/Dec/2024 2:02 AM

UIS

Original: 6

New: 7

SET Analytics Bot made changes - 15/Dec/2024 2:02 AM

UIS

Original: 7

New: 6

SET Analytics Bot made changes - 13/Dec/2024 4:06 AM

Support reference count

Original: 6

New: 7

SET Analytics Bot made changes - 13/Dec/2024 2:03 AM

UIS

Original: 4

New: 7

Roberto Diaz made changes - 12/Dec/2024 2:03 PM

Description

Original: h3. Issue Summary Preview/Excel macro uses US date format (MM/DD/YYYY) for Excel documents containing dates in European format (DD/MM/YYYY) h3. Environment * Confluence 7.2 h3. Steps to Reproduce # Create MS Excel document. # Add date to one of the spreadsheet cells in European Format for example 30.12.2019 or 30/12/2019 # Create new page upload above document to the page. # Add new Excel macro and by using previously uploaded Excel document # Save the page # Preview the page, h3. Expected Results Date from the spreadsheet cell is displayed as 30/12/2019 h3. Actual Results Date from the spreadsheet cell is displayed as 12/30/2019 h3. Workaround  Currently there is no known workaround for this behavior. A workaround will be added here when available h3. Additional notes Above bug occurs regardless of user language profile setting or global language setting in Confluence

New: h3. Issue Summary Preview/Excel macro uses US date format (MM/DD/YYYY) for Excel documents containing dates in European format (DD/MM/YYYY) h3. Environment * Confluence 7.2 h3. Steps to Reproduce # Create MS Excel document. # Add date to one of the spreadsheet cells in European Format for example 30.12.2019 or 30/12/2019 # Create new page upload above document to the page. # Add new Excel macro and by using previously uploaded Excel document # Save the page # Preview the page, h3. Expected Results Date from the spreadsheet cell is displayed as 30/12/2019 h3. Actual Results Date from the spreadsheet cell is displayed as 12/30/2019 h3. 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. h3. Additional notes Above bug occurs regardless of user language profile setting or global language setting in Confluence

SET Analytics Bot made changes - 26/Oct/2024 2:05 AM

UIS

Original: 2

New: 4

SET Analytics Bot made changes - 16/Jul/2024 2:03 AM

UIS

Original: 4

New: 2

SET Analytics Bot made changes - 13/Jul/2024 2:04 AM

UIS

Original: 6

New: 4

Load more older history items