[Libreoffice-bugs] [Bug 113506] EDITING: X axis editing problem in Calc

[bugzilla-daemon]

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

[bugzilla-daemon]

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=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

[bugzilla-daemon]

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

[bugzilla-daemon]

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

[bugzilla-daemon]

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=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

[bugzilla-daemon]

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

[bugzilla-daemon]

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

[bugzilla-daemon]

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

[bugzilla-daemon]

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=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

[bugzilla-daemon]

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

[bugzilla-daemon]

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

[bugzilla-daemon]

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=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

[bugzilla-daemon]

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

[bugzilla-daemon]

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

[bugzilla-daemon]

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

[bugzilla-daemon]

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

[bugzilla-daemon]

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

[bugzilla-daemon]

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

[bugzilla-daemon]

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

[bugzilla-daemon]

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=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

[bugzilla-daemon]

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=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

[bugzilla-daemon]

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=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