[Libreoffice-bugs] [Bug 113506] EDITING: X axis editing problem in Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=113506 Stéphane Guillou (stragu) changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=54 ||132 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 113506] EDITING: X axis editing problem in Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=113506 --- Comment #20 from Ross Johnson --- Created attachment 175787 --> https://bugs.documentfoundation.org/attachment.cgi?id=175787&action=edit Line chart with x integer values The attachment, following Regina's [comment 6], shows the result choosing the "Date" category but then choosing "Day" resolution and maximum major tick interval of 100. This is not intended as a suggested workaround, just an exercise to see how close it is possible to get to a satisfying representation using the Line Chart style. It is still not a general solution but IMO proves there is no fundamental reason to prevent Line Charts representing any regular sequence of values, especially integers, preferably a new category altogether. Line Charts and Area Charts share the same underlying limitations and, while an X-Y Scatter Chart may offer a workaround for simple line chart X-axis formatting, it doesn't provide one for Area charts, which have the same limitations. An Area chart (2D and 3D) with regular interval values is a common chart presentation style that is not available in LO. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 113506] EDITING: X axis editing problem in Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=113506 --- Comment #19 from Ross Johnson --- Still present in: Version: 7.2.1.2 (x64) / LibreOffice Community Build ID: 87b77fad49947c1441b67c559c339af8f3517e22 CPU threads: 12; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win Locale: en-AU (en_AU); UI: en-US Calc: threaded I had a look at both Dr Weisser's original and Peter's recreation. I think the question remains: why can't the Line Chart type X-Axis tick marks and labels be set in the same way as for the XY (Scatter) chart type? If I recreate the chart as a Line Chart I get X-axis labels: 4, 134, 264, ..., 4554, ie, every 130 starting at 4, and I cannot see how many major tick marks there are between each label nor which tick mark the label corresponds to. If I switch to the X-Y Chart type I get useful labels and tick marks automatically. This is an issue even without the manual overrides being available. This data should be representable as a simple line chart. When the Line Chart "categories" are integers, the same algorithm should be used with the same manual overrides should be available as for the X-Y Scatter chart. The X-Y Scatter chart is a work-around but it is not the type of chart I would choose first up to graph these values because they are not scattered (they are regular periodic temperature and humidity readings). -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 113506] EDITING: X axis editing problem in Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=113506 --- Comment #18 from Peter S Anderson --- Given my ability to easily create a graph where the X Axis is amendable as per Dr. Weiss' requirements, I suspect that the problem is with the initial loading of the Excel spreadsheet into Calc. Happy to show Dr Weiss what I did if it will help him. Regards. Peter. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 113506] EDITING: X axis editing problem in Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=113506 Peter S Anderson changed: What|Removed |Added CC||pe...@pza.net.au --- Comment #17 from Peter S Anderson --- Created attachment 168398 --> https://bugs.documentfoundation.org/attachment.cgi?id=168398&action=edit Modified Graph With amendable X Axis Hi Everyone, I have loaded the Excel spreadsheet in 6.4.7.2, deleted the graph and recreated it again and saved it as an ODC file. The X axis is scalable as can be seen from my amendments. I suspect that there was something about how the graph was created. Hopefully this will help the user. Regards.. Peter. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 113506] EDITING: X axis editing problem in Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=113506 Buovjaga changed: What|Removed |Added Keywords||needsDevAdvice CC||todven...@suomi24.fi --- Comment #16 from Buovjaga --- No more testing requests should be done, until we get more input from developers (or charting experts). Based on Regina's comments, this does not seem to be a bug. I tried creating an X-Y chart with the data, but I am not a charting expert and don't have infinite time at the moment, so I failed to replicate Matthias's chart with X-Y. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 113506] EDITING: X axis editing problem in Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=113506 Dr. Matthias Weisser changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 --- Comment #15 from Dr. Matthias Weisser --- (In reply to Xisco Faulí from comment #14) > Some changes has been done to charts recently. > Could you please try to reproduce it with a master build from > http://dev-builds.libreoffice.org/daily/master/ ? > You can install it alongside the standard version. Thank you - I did. Unfortunately the msi to make it german did not run correctly. > I have set the bug's status to 'NEEDINFO'. Please change it back to > 'UNCONFIRMED' if the bug is still present in the master build unfortunately the bug is still there. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 113506] EDITING: X axis editing problem in Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=113506 Xisco Faulí changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO Ever confirmed|0 |1 --- Comment #14 from Xisco Faulí --- Dear Dr. Matthias, Some changes has been done to charts recently. Could you please try to reproduce it with a master build from http://dev-builds.libreoffice.org/daily/master/ ? You can install it alongside the standard version. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the master build -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 113506] EDITING: X axis editing problem in Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=113506 --- Comment #13 from Dr. Matthias Weisser --- Created attachment 147143 --> https://bugs.documentfoundation.org/attachment.cgi?id=147143&action=edit shows that x axes numbers are not clearly shown the picture shows that opening the data file on my system the y numbers are shown ok but not the x axes values as can be seen. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 113506] EDITING: X axis editing problem in Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=113506 --- Comment #12 from Dr. Matthias Weisser --- (In reply to Xisco Faulí from comment #8) > Could you please try to reproduce it with the latest version of LibreOffice I did. Unfortunately the problem still seems to be there. when opening the data file for testing purpose with old Excel there is no problem to change the axis. also the numbers of the x-axes are nearly impossible to read. Please see the attachment "number_problem.png" for this. unfortunately with LO in comparison the performance in scrolling is poor. It feels sluggish. Also I cannot easily see a zoom possibility. May be this should become another report. Its not good handling this here. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 113506] EDITING: X axis editing problem in Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=113506 Dr. Matthias Weisser changed: What|Removed |Added Ever confirmed|1 |0 Status|NEEDINFO|UNCONFIRMED -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 113506] EDITING: X axis editing problem in Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=113506 --- Comment #11 from Dr. Matthias Weisser --- Created attachment 147142 --> https://bugs.documentfoundation.org/attachment.cgi?id=147142&action=edit problem to see with LO 6.1.3.2 here can be seen that with LO6.1.3.2 there is still no possibility there to change x-axis scaling. In comparison to y-axis the difference is easy to see. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 113506] EDITING: X axis editing problem in Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=113506 --- Comment #10 from Xisco Faulí --- (In reply to Dr. Matthias Weisser from comment #9) > (In reply to Xisco Faulí from comment #8) > > Could you please try to reproduce it with the latest version of LibreOffice > > from https://www.libreoffice.org/download/libreoffice-fresh/ > > thank you very much Xisco ! > > Which version should I install for testing? > at the moment I am not using version 6 because of trouble. > should I test the latest version 5? you should test with 6.1.3.2. Which trouble is it you're talking about? -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 113506] EDITING: X axis editing problem in Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=113506 --- Comment #9 from Dr. Matthias Weisser --- (In reply to Xisco Faulí from comment #8) > Could you please try to reproduce it with the latest version of LibreOffice > from https://www.libreoffice.org/download/libreoffice-fresh/ thank you very much Xisco ! Which version should I install for testing? at the moment I am not using version 6 because of trouble. should I test the latest version 5? -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 113506] EDITING: X axis editing problem in Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=113506 Xisco Faulí changed: What|Removed |Added CC||xiscofa...@libreoffice.org Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO --- Comment #8 from Xisco Faulí --- Dear Dr. Matthias Weisser, Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 113506] EDITING: X axis editing problem in Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=113506 --- Comment #7 from Dr. Matthias Weisser --- (In reply to Regina Henschel from comment #6) > A category axis does not allow to set a grid interval, only for dates it is > possible. In that case you have to set type "date" for the x-axis of the > line chart. But I do not see that your x-axis has dates. Your x-axis has > simple automatic integer numbers. Why does using an XY-chart do not solve > your problem? unfortunately I am not a real specialist for using Calc as designers of this might have thought of. I tried out what worked for me and ended up doing so as above. As can be seen I was able getting a picture showing the data. Also I am able clicking on the axes to change them. This works for me as it did in MS Excel also. Unfortunately it does not work in LO. This bothers me. I simply do not understand why this is not possible there. I really would like the behaviour as it was using MS Excel. This was easy and understandable. I do not understand LO here. May be I am too stupid. Sorry for that. May be also many others are as stupid as me. I think this could be the case. Therefore I hope there will be some help here. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 113506] EDITING: X axis editing problem in Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=113506 --- Comment #6 from Regina Henschel --- A category axis does not allow to set a grid interval, only for dates it is possible. In that case you have to set type "date" for the x-axis of the line chart. But I do not see that your x-axis has dates. Your x-axis has simple automatic integer numbers. Why does using an XY-chart do not solve your problem? -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 113506] EDITING: X axis editing problem in Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=113506 Dr. Matthias Weisser changed: What|Removed |Added Status|RESOLVED|UNCONFIRMED Resolution|NOTABUG |--- --- Comment #5 from Dr. Matthias Weisser --- (In reply to Regina Henschel from comment #4) > You have to use an XY-chart, not a line-chart. > BTW: You should use a secondary y-axis for the second series, because it has > a different unit. Thank you for this hint. I tried different possibilities creating those charts. This was one that worked for me. Unfortunately it does not seem to be possible editing the time axis as it was and still is possible using MS Excel 2000. I do not see this as solved. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 113506] EDITING: X axis editing problem in Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=113506 Regina Henschel changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED CC||rb.hensc...@t-online.de Resolution|--- |NOTABUG --- Comment #4 from Regina Henschel --- You have to use an XY-chart, not a line-chart. BTW: You should use a secondary y-axis for the second series, because it has a different unit. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 113506] EDITING: X axis editing problem in Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=113506 --- Comment #3 from Dr. Matthias Weisser --- Created attachment 137353 --> https://bugs.documentfoundation.org/attachment.cgi?id=137353&action=edit picture showing editing fields for X axis in MS Excel 2000 here is seen that using the old MS Excel 2000 the X axis can be properly edited which unfortunately did not work using LO. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 113506] EDITING: X axis editing problem in Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=113506 --- Comment #2 from Dr. Matthias Weisser --- Created attachment 137352 --> https://bugs.documentfoundation.org/attachment.cgi?id=137352&action=edit picture showing editing fields for X axis in LO here is the difference to see in comparison to Y axis. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 113506] EDITING: X axis editing problem in Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=113506 Dr. Matthias Weisser changed: What|Removed |Added CC||matthias.weis...@gmx.de --- Comment #1 from Dr. Matthias Weisser --- Created attachment 137351 --> https://bugs.documentfoundation.org/attachment.cgi?id=137351&action=edit picture showing editing fields for Y axis in LO -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs