Created attachment 55642 [details] and example of wrong axis plot In ubuntu 10.04 32bit, using LibreOffice 3.4.5 Calc (or Spreadsheet) You tried to plot the axis' leyend and it appears wrongly. In 3.3.x didnt happend. Start to happend in 3.4.x The problem appears when you have more than one row to plot. See the example! Thanks pa_descargar_cosas@yahoo.com
Well, it is actually the axis, not the leyend (i express myselft wrong).
The attached document has already lost the settings for Data Series. It might be, that the file had been affected by bug #36339. If the data series are corrupted, they cannot be repaired automatically, but you have to enter the correct ranges manually. Can you please try, if you can reproduce the error with a document, that is still correct in LO3.3 and will be wrong in LO3.5? (Use a copy of the file!)
Created attachment 55752 [details] error plotting axis still is the same bug... it is an answer for Regina Henschel <rb.henschel@t-online.de in this case i use LOdev 3.50beta3 in windows 7 64
Created attachment 57633 [details] The diagram on fileopen See second attachment...
Created attachment 57634 [details] The diagram after doubleclicking and giving away the focus (Sorry for the English...) It definitely should not look like this...
Because of hoping on a quick fix, I will assign the bug to a Calc pro hacker. My OS Win7x64 LibO 3.5
I cannot reproduce it. Please attach the document as it has been saved in LO 3.3. We do not need the version from LO 3.5, but we need the original content of the file. I work on WinXP. Can you please test it on WinXP too and/or on another Linux distribution.
I appreciate it. I hope this bug could be soon solved. Thanks for the support.
I have lost the original file in LO3.3 But you can reproduce it with this: Graphic tipe: Lineal. Dot and lines. Row data series. 1st column as tag. Y Value: $Hoja1.$B$5:$M$5;$Hoja1.$B$8:$M$8;$Hoja1.$B$11:$M$11;$Hoja1.$B$14:$M$14 Categories: $Hoja1.$B$4:$M$4;$Hoja1.$B$7:$M$7;$Hoja1.$B$10:$M$10;$Hoja1.$B$13:$M$13 Im using spanish version (so i translate the menus as i think it is). So where is "Hoja1" you should put "Sheet1" or something similar. You can replace it. It happens in 3.4.5 onwards (also 3.5 of course). Also in Windows (XP,7) or any linux distribution... If you need more specifications, just let me know.
I may be a Calc expert, but I'm not a Chart expert.. Anyway, could someone please create a working test case document in LibO/OOo 3.3 and attach it? Thanks.
Created attachment 57718 [details] the original file This file was done with oo3.2
(In reply to comment #10) > I may be a Calc expert, but I'm not a Chart expert.. > Anyway, could someone please create a working test case document in LibO/OOo > 3.3 and attach it? Thanks. Ok. I make my research and i have (somehow) good news. I tried LO3.3 and, know what? Still the bug is there. So i read the metadata of one old file that works fine, and it was made with OPENOFFICE 3.2. So openoffice 3.2 works fine. openoffice 3.3 (i dont know) libreoffice 3.3 and onwards (the bug is there) So, i just attached and OO3.2-without_bug-file
Now I see what you want to do. I have got some older versions and can see, that it is OK in DEV300m73(Build 9486) and is broken in DEV300m75(Build 9488). That has been 2010-03-08 to 2010-03-16 approximately.
(In reply to comment #13) > Now I see what you want to do. > I have got some older versions and can see, that it is OK in DEV300m73(Build > 9486) and is broken in DEV300m75(Build 9488). That has been 2010-03-08 to > 2010-03-16 approximately. A long-trace bug. I hope it could be solved. If you need something more, just tell me.
May be related to this feature : http://www.openoffice.org/dev_docs/features/3.3/#Hierarchical_Axis_Labels_for_Charts ?
@GeraldF: I think, that you are right. That feature was developed in CWS chartmultiline and that CWS was merged to DEV300m74 at 2010-03-09.
Can you please check with Libreoffice 3.5.1 or attach a screenshot of the expected result. I think the file looks correct and I fixed some bugs for 3.5.1 and 3.5.2 related to this. @Eike, I hope you don't mind if I take this. Hopefully it has been fixed already with http://cgit.freedesktop.org/libreoffice/core/commit/?h=libreoffice-3-5-1&id=065cdf07791b2de4c6ab580084d21d2b5020ca98
Ok, my fix seems to help for fileopen helps but there are even more issues there. Let me see if I can find the remaining issues.
There seems to be a really strange issue in VCartesianAxis::createAllTickInfosFromComplexCategories. TickInfo::fScaledTickValue should store the position of the axis labels but it contains more or less useless data for the second and following categories.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=a769fd1ec076b61c1ce2f84da87283cc637dd5d5 correctly set the position of the axis labels, related fdo#44832
My patch fixes only the positioning problem. There are even more problems around formatting of the string, transformation of the text shape, ... for the second category and following. I'm not sure if we should include this patch if we don't find someone knowing this code quite well or testing the hell out of the complex category charts. The CWS introducing this bug has already introduced several other issues and this patch while fixing this bug might cause new regressions.
Ok, I finally a have a fix that solves all remaining problems. The question is why Ingrid Halama added these lines in the first place. I will not ask for 3-5 review without someone either fully understanding this issue or someone testing these fixes with a set of test documents. I will send the patch for review to the ML and won't include it directly into master.
So, is there something that we (common humans) could do? Is there something (version libreoffice 3.5.1 beta)that we could try?
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=a1be31fd8bf830a4f5961e690bcffd050782e210 fdo#44832: Follow-up fix for axis labels for complex categories
This patch will not be in the 3-5 release. But there is one thing that would help us quite a lot: It would be great if someone could create a set of test documents containing a lot of different chart features. These would allow us to be safer when we fix bugs and we could try to integrate them into our automatic tests to prevent regressions.
*** Bug 46130 has been marked as a duplicate of this bug. ***