Bug 164724 - Copying specific chart changes automatic X axis labels to date format
Summary: Copying specific chart changes automatic X axis labels to date format
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
6.2.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 20:20 UTC by Gabor Kelemen (allotropia)
Modified: 2025-01-30 14:45 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Example file from Calc (19.65 KB, application/vnd.oasis.opendocument.spreadsheet)
2025-01-15 20:20 UTC, Gabor Kelemen (allotropia)
Details
The example file in Calc and the pasted chart in Writer (188.74 KB, image/png)
2025-01-15 20:20 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 20:20:20 UTC
Created attachment 198567 [details]
Example file from Calc

Attached document contains a simple bar chart with a single data series.

When the chart is copy-pasted to Writer, the automatically generated X axis labels change from number formatting (1, 2, 3...) to date formatting starting from 1899-12-31.

1. Open attached document
2. Click on the top chart and copy it
3. Open a new Writer document and paste
-> the chart X axis labels become date formatted

Seems to be related to the presence of labels, since the bottom chart without them pastes correctly, somehow.

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 sometimes during the 6.2 cycle, but I'm unable to bibisect since the example file causes and endless loop in the bibisect repo in Linux.
Comment 1 Gabor Kelemen (allotropia) 2025-01-15 20:20:56 UTC
Created attachment 198568 [details]
The example file in Calc and the pasted chart in Writer
Comment 2 m_a_riosv 2025-01-16 01:33:54 UTC
Seems 'Category' values are pasted as time values.
Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 590157ac1584fb829b0c61905298114e7c4adfde
CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win
Locale: en-US (es_ES); UI: en-US
Calc: CL threaded
Comment 3 m_a_riosv 2025-01-16 01:38:11 UTC
Latest version that works on the ones I have installed.
Versión: 5.4.7.2
Id. de compilación: c838ef25c16710f8838b1faec480ebba495259d0
Subprocs. CPU: 16; SO: Windows 6.2; Repres. IU: predet.; 
Configuración regional: es-ES (es_ES); Calc: CL
Comment 4 Octavio Alvarez 2025-01-30 05:29:52 UTC
Fortunately, just some commits before started hanging the incorrect behavior was observed, so bibisecting was successful.

https://git.libreoffice.org/core/+/3956e4cb58033cae360beddf97136596ff3bb740
Comment 5 Octavio Alvarez 2025-01-30 05:31:02 UTC
I bibisected it using linux-dbgutil-daily-till60.
Comment 6 Commit Notification 2025-01-30 14:45:44 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.