I have a number of chart related issues, but they seem to be related, so I report them in one. 1. The clear error Steps to reproduce: Make a chart on a sheet. Name the sheet (before or after the chart is made, does not matter) with a comma in the name, like "a,b". Copy the sheet either by the right mouse button "Move or Copy Sheet", or just Ctrl-drag with the mouse. Does not matter. The sheet is copied with all numbers in it, as well as the chart object, but no data is in it, it looses the data source. The other issue that might be linked to the above, as it also related to the way how a chart and a sheet are interconnected (but it might even be by design, so not a bug) 2. It is not clear when and how a chart object is linked to a sheet. If I select all (e.g. Ctrl-A, or the top left corner next to A and 1) and copy paste it into another sheet or file, it takes the chart with it (i.e. part of "All"). If I select all and Cut (and Paste or not) then again, the chart goes with the data and disappears from the old sheet. However if I select all and Delete (with Del e.g.) it deletes all the numbers, etc., but the empty chart stays. To me it is not a consistent handling of the object-sheet relationship. I would expect Del to be the same as Ctrl-X with the exception that it does not go to the Clipboard. As a result, if I want to clean a sheet, I rather use Ctrl-A, Ctrl-X than Ctrl-A, Del. And some other errors I see regularly, but cannot reproduce on a consistent way. 3. When I copy a sheet with a chart and delete the chart from the new sheet (because I wanted to copy only the data, but as per #2, the chart goes with it), sometimes - but not always - the chart on the old sheet gets confused (data range changes). Maybe again, it is linked to the way how an object is stored internally? 4. Copying a chart object from Calc to Write sometimes (but again do not know what triggers it) copies the empty object (just like #1 above, but it is not linked to comma in the sheet name).
No repro with Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: fd948fd27356e703fffc7e46df0f0e3a22f57967 CPU threads: 4; OS: Linux 6.5; UI render: default; VCL: gtk3 Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US Calc: threaded Jumbo After copy sheet "a,b" the chart is copied too. Please attach test file.
Created attachment 192857 [details] The test file
Sorry, comment lost when file attached. So, again: How it was made: Calc started Data entered Chart created with one mouse click in the toolbar and then "Finished" Sheet renamed Sheet copied with Ctrl-Mouse drag - Chart is empty, no data series in it File saved
Created attachment 192884 [details] simpler steps with this attachment (comment 4) Simpler steps with this attachment: 1. Right-click > Duplicate sheet "ab": chart remains 2. Right-click > Duplicate sheet "a,b": chart gone No issue when using any of the following characters: .!;-_$ Reproduced with recent trunk build: Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: e2473fe3a547e5a11d3b91ab8ded833bf5b74356 CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded Also on Windows 11. No repro in OOo 3.3, but reproduced with libreoffice-3.3.0 (checked with bibisect-64-releases repository; make sure to double-click on chart to confirm that data is gone) -> regression.
Regarding your 3 other issues, it is best to report on issue per ticket. 2) I can reproduce this: Ctrl + A -> Delete is different to Ctrl + A -> Ctrl + X. This feels inconsistent, but I assume some users might want a way to modify all cells without affecting objects... 3) Can't reproduce, but wondering if it is related to bug 158223, which is now fixed in 7.6.5. I recommend updating your version. 4) Can't reproduce either. In any case, please upgrade to the latest version, and open new reports if these issues remain.
Thanks, 3, 4 I have not seen either since the upgrade to 7.6.5.2. Might have been the other bug, that is fixed in the latest release. Should it happen again, I will report separately. 2, I reported a low priority issue on this.