I have percent data format with one decimal visible. When I create a chart with the wizard and I want to add data label, the standard format displays two decimals. If I try to change manually Number format and I tick "Source format", nothing happens when I wish that Number format is the same as source format (two decimals visible instead of only one). How to reproduce it: - Open a new Spreadsheet file. - Create some data with more of three decimals. Store these data vertically. - Format cells as percent and with only one decimal visible (shortcuts "Format as Percent" and "Delete Decimal Place" from the toolbar). - Select the first cell. - Click on the "Insert Chart" button. - Choose "Column" as "Chart Type" and "Percent Stacked" as model (third of the available models). - Click on "Finish". - In edit chart mode (if not, double-click on chart), right-click on one column and choose "Insert Data Labels". First analysis: there are two decimals instead of one. - Select Data Labels. - Right-click and choose "Format Data Labels..." [it's the same with only one data label select and "Format Single Data Label..."]. - Click on the button "Number Format" and tick "Source Format". - Confirm the two windows. Actual results: - Number format of data labels display two decimals. - Source format in cells display one decimal. Expected results: - Number format of data labels display only one decimal, like source format. Additional Info: - This bug is present on 5.2.4.2 (x64) version and on the master version too.
It seems to be bind with this bug: https://bugs.documentfoundation.org/show_bug.cgi?id=95425
Hello, Thanks for reporting the bug. Yes, they seem to be related. Closing this one as duplicated then. *** This bug has been marked as a duplicate of bug 95425 ***