Bug 164728 - Copy-pasting chart with percentage formatted data label changes number format
Summary: Copy-pasting chart with percentage formatted data label changes number format
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: target:25.8.0
Keywords: bibisected, regression
Depends on:
Blocks: Chart
  Show dependency treegraph
 
Reported: 2025-01-15 21:58 UTC by Gabor Kelemen (allotropia)
Modified: 2025-01-30 17:30 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Example file from Calc (13.58 KB, application/vnd.oasis.opendocument.spreadsheet)
2025-01-15 21:58 UTC, Gabor Kelemen (allotropia)
Details
The example file with the fresh chart and the same pasted to Writer (104.99 KB, image/png)
2025-01-15 21:59 UTC, Gabor Kelemen (allotropia)
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Gabor Kelemen (allotropia) 2025-01-15 21:58:30 UTC
Created attachment 198570 [details]
Example file from Calc

Attached example data series contains numbers formatted as percentage.
If a chart is created with data labels and copy-pasted into Writer, then the values format changes from percentage to fraction.

1. Open attached file
2. Select B1:B7
3. Insert a basic column chart with the toolbar button and click Finish on the first page of the chart wizard
4. Right click on one of the columns of the chart and choose "Insert Data Labels"
5. Finish editing the chart and copy it
6. Open a new Writer document and paste
-> the chart data labels change from percentages to hundreths.

Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: db6a6efdc49df054826e9019ebe955282de929a7
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: hu-HU (hu_HU.UTF-8); UI: en-US
Calc: threaded

Seems to have started in 6.4 with:

https://git.libreoffice.org/core/+/9c1063ba13028244346528e307d5563d6faf949d%5E%21

author	Balazs Varga <balazs.varga991@gmail.com>	Tue Dec 10 12:53:08 2019 +0100
committer	Xisco Faulí <xiscofauli@libreoffice.org>	Tue Dec 17 11:34:33 2019 +0100

tdf#129173 tdf#129175 Fix number format of data labels
Comment 1 Gabor Kelemen (allotropia) 2025-01-15 21:59:23 UTC
Created attachment 198571 [details]
The example file with the fresh chart and the same pasted to Writer
Comment 2 Commit Notification 2025-01-30 14:45:46 UTC
Oliver Specht committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/e72919a30132cabeb3e3fda2f9ce16688e9f40eb

tdf#151278 tdf#164724 tdf#164728 tdf#164729 switch off charts number format from source

It will be available in 25.8.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.