Quite often it is not possible to change series titles in graphs created in Calc after they are copied to Writer. Instead of changing series title any edition results in multiplication of existing series titles.
The issue affects 6.4 and 7.0 versions.
Steps to Reproduce:
1. Open attached file and enter chart.
2. Press View > Data Table.
3. Select any of series title and write some text.
4. Press Close and check result.
Instead of new series title previous and new title appears. Every edition attempt results in multiplication of previous title with added new title.
New series title appears instead of old one.
User Profile Reset: Yes
Build ID: 1c213561a365b5666167321de68c9977500c9612
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3
Locale: lv-LV (en_GB.UTF-8); UI: en-US
Created attachment 162252 [details]
Chart series title
Confirm it with
Build ID: 3d775be2011f3886db32dfd395a6a6d1ca2630ff
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3;
Locale: ro-RO (ro_RO.UTF-8); UI-Language: en-US
Also in Version 188.8.131.52 (Build ID: e183d5b), it is the first that I have
So, I supose it is inherited from Ooo.
(In reply to BogdanB from comment #3)
> Also in Version 184.108.40.206 (Build ID: e183d5b), it is the first that I have
> So, I supose it is inherited from Ooo.
It is important that the file provided with the report is created in Libreoffice 6.4.x, therefore wrong behavior in earlier Libreoffice versions may be result of a regression in the most recent versions. I use Charts intensively and this problem appeared to me only in Libreoffice 6.4.x, not earlier.
This is really annoying issue, it affects the most of the charts created in calc. 6.4 and 7.0 versions are affected.
This regression persists in LibreOffice 7.1 alpha.
Created attachment 167708 [details]
Cpmparison of simple and complex charts
An example of error demonstrating that it is not possible to change categories in charts, follows in attachment. If the Chart is created in Writer, there are no problems (first 2 charts in attached file); if chart is created in calc and pasted into writer, then it is not possible to replace categories later in writer, if initially in calc document they are in column, e.g. A1 to A6 (3rd to 4th chart), but they can be changed if categories are in row in calc, e.g. A1:E1. This is workaround, but, really, it would be good to solve this annoying issue.
I can confirm the bug and wrote about it in the mailing list: https://lists.freedesktop.org/archives/libreoffice/2020-December/086455.html
It affects all charts created in Calc with data in rows then copied to Writer. It is due to the charts with internal data table, like in Writer, trying to transpose the initial data to change the data to columns, but then this is not correctly managed during the category label edition and it causes the bug.
*** Bug 142596 has been marked as a duplicate of this bug. ***
*** This bug has been marked as a duplicate of bug 82298 ***