FormatCode not working in MSOffice and Google Slides

[ViniciusM241CodeBit]

FormatCode not working in MSOffice and Google Slides

Issue Category

• Enhancement
• Bug
• Question
• Documentation gap/issue

Product Versions

• Library version 3.12.0
• Same problem with library demos

Desired Behavior

Created slides should use the formatCode configured in dataLabelFormatCode to show the values using a mask in MSOffice and Google Slides, though it just works in LibreOffice.

Observed Behavior

Data is shown without mask. Example: 10% => 0.1

LibreOffice:

Google Slides:

Steps to Reproduce

Create a pptx file using formatCode in dataLabelFormatCode or valAxisLabelFormatCode and then open it in Google Slides or MSOffice PowerPoint.

[szymon-jedify]

I have the same case, formatCode set as #,##0.## is not working at powerPoint and google slides, for all of the time values are displayed as: "100.", the dot is added even if it shouldn't be there. Libre office is working without any issues with such format