Created attachment 90373 [details] problematic chart Problem description: This is a bug I have experimented several times, since I started to use OOo. Sadly, I had not been able to find steps to reproduce it, since it just happens, when "it" wants. This usually happens with a big spreadsheets, with lots of sheets and charts (houndreds). I save the file after work, open it again another day, and the data references in charts are lost. So, when updating data, the chart already done now is completely useless. This is really sad, when there are lots of charts and suddenly, all of them are useless. And since creating lots of formatted charts is a cumbersome task (see bug 62925), this bug is even painful (for me, of course). I have though sometimes that this big content was the responsible, but all my tries to reproduce it failed. Up to now, with a specific file! Sadly, I cannot reproduce it with LibO 3.5, but with LibO 4.0.4 on Windows 7 x86 (collegue compute, different profile, almost clean), and Libo 4.1.3 on Kubuntu 12.04 x86_64. Steps to reproduce: 1. Open the attached file. 2. You should see the problematic chart. 3. Copy and paste it in the same sheet (the copied chart _looks_ identical to the original) 4. Activate it through double click 5. Try to change any series of it Current behavior: You cannot: it has become a "general chart" with internal data, like if it were copied in Writer. Expected behavior: The new chart should be not only identical in appearance, but internaly too. This means, it's an editable "Calc chart" Again: I have experienced this bug many times, with different LibO versions, even with OOo. But this is the first time I can obtain a problematic file which I'm able to share. Operating System: Ubuntu Version: 4.0.6.2 release Last worked in: 3.5 all versions
I can confirm this behaviour. The cause of the problem is in the name of the sheet. It contains a comma, which is the field separator. Changing the comma in the sheet name to something without meaning (e.g. "_") makes the problem disappear. @Francisco: Could you confirm for me that this is indeed the problem in all cases the charts get messed up?
Stephan: I can confirm that erasing that comma, the problem disappears in this specific case. However, I don't have this problem with LibO 3.5, so, it's a regression. Since you were able to reproduce it, I'm marking as new. Besides, this behavior should not happen, or no comma should be allowed in the sheet name, am I right? One more thing. I have suffered the problem first described many times: saving, closing and reopening a spreadsheed with lots of charts has shown me the same problem, even without commas in my sheet names. Could the bug reported here be related?
As you confirm that this case is caused by the commas I mark this bug a duplicate. You may file a new issue for the problem with saving and loading without commas. I have not done so until now because, while colleagues reported something similar, I cannot reproduce it. Also, in our case it involved older Open Office versions 3.2.1 and 3.3. I can try a repair for damaged files later this weekend if you want. *** This bug has been marked as a duplicate of bug 70869 ***
(In reply to comment #3) > *** This bug has been marked as a duplicate of bug 70869 *** Oh, yes, sorry I completely forgot to search for duplicates of the specific bug instead of the bug I had in my mind :-/. And thanks, for the offer! I have none right now but if it happens again, I'll consider your help. :-)
Migrating Whiteboard tags to Keywords: (possibleRegression) [NinjaEdit]