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.
- Number format of data labels display two decimals.
- Source format in cells display one decimal.
- Number format of data labels display only one decimal, like source format.
- This bug is present on 126.96.36.199 (x64) version and on the master version too.
It seems to be bind with this bug:
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 ***