Bug 117992 - Chart labels truncated if chart area resized and then container resized
Summary: Chart labels truncated if chart area resized and then container resized
Status: RESOLVED DUPLICATE of bug 118778
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.4.7.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Chart-Labels
  Show dependency treegraph
 
Reported: 2018-06-04 11:36 UTC by PaulSh
Modified: 2019-05-20 15:43 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
Calc document showing chart label truncation (17.02 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-06-04 11:39 UTC, PaulSh
Details
Chart before container resize (75.36 KB, image/png)
2018-06-04 11:41 UTC, PaulSh
Details
Chart after container resize (65.91 KB, image/png)
2018-06-04 11:41 UTC, PaulSh
Details
Before and after of possible bug (16.49 KB, application/vnd.oasis.opendocument.text)
2018-06-11 23:23 UTC, Susan Gessing
Details
I can't reproduce it in LibreOffice 6.3 master (47.42 KB, image/png)
2019-05-16 12:14 UTC, Xisco Faulí
Details
Example file with chart before resizing (18.76 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-05-19 13:09 UTC, Buovjaga
Details

Note You need to log in before you can comment on or make changes to this bug.
Description PaulSh 2018-06-04 11:36:53 UTC
Description:
If a chart is created, even a very simple one, and the chart area is resized vertically so that there is substantial empty space at the top, if the height of the chart container is reduced then at some point the Y-axis labels will appear truncated.

This appears to have been introduced in 5.4.7.2 and 6.0.4.2.

Steps to Reproduce:
1. Create a new Calc document
2. Create a data series in column A, say 0, 1000, 2000, ... 30000
3. Create a chart from this data series - the default bar chart is fine
4. Open the chart and reduced the height of the chart area
5. Reduce the height of the chart container

Actual Results:  
When reducing the height of the chart container, at some point the Y-axis labels will appear truncated.

Expected Results:
Y-axis labels should not have been truncated.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Problem reproduced on Windows 7 x64 SP 1 with Nvidia graphics (all HW acceleration disabled) and Windows 10 x64 with Intel graphics.

The resulting Calc document created by following the repro steps will display the chart axis correctly if opened in 5.4.6.2


User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:60.0) Gecko/20100101 Firefox/60.0
Comment 1 PaulSh 2018-06-04 11:39:52 UTC
Created attachment 142509 [details]
Calc document showing chart label truncation

This document was created following the stated repro steps. The chart will appear correctly in 5.4.6.2 but not 5.4.7.2.
Comment 2 PaulSh 2018-06-04 11:41:15 UTC
Created attachment 142510 [details]
Chart before container resize

This shows the chart before the container resize as it should appear
Comment 3 PaulSh 2018-06-04 11:41:56 UTC
Created attachment 142511 [details]
Chart after container resize

This shows the chart with the truncated labels after the container resize.
Comment 4 Jacques Guilleron 2018-06-05 08:57:34 UTC
Hi Paul,

It seems the diagram area was moved too down. Move it upward and all will be displayed.
Do you agree?
Comment 5 PaulSh 2018-06-05 10:30:42 UTC
Yes, making the chart area larger again restores the axis labels, but a simple action such as inserting a chart title, which then of course reduces the height of the chart area, is sometimes enough to cause this issue.
Comment 6 Susan Gessing 2018-06-11 23:23:39 UTC
Created attachment 142666 [details]
Before and after of possible bug

I was able to reproduce a bug where, when I decrease the size of the chart area and container, most of the y-axis labels disappear. I'm not sure if this is the same bug that is listed in this report so I am keeping this one as unconfirmed. I wasn't able to cause the exact bug mentioned here. I followed the same steps to get where I was at in the images. I did this on version 6.0.4.2 x64, Windows.
Comment 7 Buovjaga 2018-06-13 13:45:32 UTC
I tried reproducing it by creating a new chart from the data in the file, but did not see any problem. I first reduced the chart area (outer frame) and then the "chart grid".

Arch Linux 64-bit
Version: 6.2.0.0.alpha0+
Build ID: 044b5d319cc8d337d819efddcc96dd2428961d2a
CPU threads: 8; OS: Linux 4.16; UI render: default; VCL: kde4; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group threaded
Built on June 13th 2018

Arch Linux 64-bit
Version: 6.0.4.2
Build ID: 6.0.4-1
CPU threads: 8; OS: Linux 4.16; UI render: default; VCL: kde4; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Comment 8 Xisco Faulí 2018-10-24 11:29:19 UTC
Hi PaulSh,
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.
Comment 9 PaulSh 2018-10-24 12:19:26 UTC
Sorry, things are still exactly the same with the version I just downloaded from the "Fresh" section:

LibreOffice_6.1.2_Win_x64.msi
Internal version UID {305CB5C7-F1B5-4576-996B-F393FDB5E896}

It's easy to see if it's fixed or not - just open the attached file "broken.ods" and look at the chart Y-axis. If it says 0, 5000, 10000, 15000 etc. then it's fixed, otherwise it's not.
Comment 10 Buovjaga 2018-10-24 12:39:25 UTC
(In reply to Buovjaga from comment #7)
> I tried reproducing it by creating a new chart from the data in the file,
> but did not see any problem. I first reduced the chart area (outer frame)
> and then the "chart grid".

PaulSh: what if you do this, though?
Comment 11 Xisco Faulí 2019-05-16 12:14:36 UTC
Created attachment 151452 [details]
I can't reproduce it in LibreOffice 6.3 master

I can't reproduce it in

Version: 6.3.0.0.alpha1+
Build ID: f897342320ad3a29cf4be1437c8e3ce888bdb3cb
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US
Calc: threaded
Comment 12 Xisco Faulí 2019-05-16 12:15:02 UTC
Hello PaulSh,
A new major release of LibreOffice is available since this bug was reported.
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.
Comment 13 PaulSh 2019-05-17 13:44:30 UTC
Interesting. With 6.2.3.2 I see a difference. So, what I can do now that works is:

1) I can create a chart and change the container height without the Y-axis legends going wrong
2) I can create a chart and change the chart height within the container without the Y-axis legends going wrong
3) I can even create a chart and insert a title (which will of course change the chart height) and then change the container height without the Y-axis legends going wrong

But... I still cannot create a chart, change the chart height within the container and then change the container height without the Y-axis legends going wrong. So if you open the document "Broken.ods" in the first attachment you will still see that it is wrong, but it's different from some earlier LO versions that I have tried.

It's really very, very easy to repro:

1) In a new sheet, create a column of data that goes 0, 1000, 2000 up to say 30,000.
2) Select that data, do Insert/Chart and click on Finish
3) Click in the chart itself and drag its top border down a little to reduce the height slightly
4) Drag the top border of the container down to reduce the height to around 50%

The Y-axis legends are now truncated.
Comment 14 Buovjaga 2019-05-19 13:09:33 UTC
Created attachment 151510 [details]
Example file with chart before resizing

(In reply to PaulSh from comment #13)
> It's really very, very easy to repro:
> 
> 1) In a new sheet, create a column of data that goes 0, 1000, 2000 up to say
> 30,000.
> 2) Select that data, do Insert/Chart and click on Finish
> 3) Click in the chart itself and drag its top border down a little to reduce
> the height slightly
> 4) Drag the top border of the container down to reduce the height to around
> 50%
> 
> The Y-axis legends are now truncated.

Now I could reproduce from scratch. It appears there has been some confusion due to the number of things we are able to resize.

Step 3 in more detail is: be in chart edit mode, left-click to select the *chart wall* - you can verify this by right-clicking and checking that the context menu says "Format Wall". Drag down the wall a bit.
Step 4 is done after you exit the edit mode.

I will bibisect this.

Arch Linux 64-bit
Version: 6.3.0.0.alpha1+
Build ID: 7aa30433719faece8c40e41d7aa8c7539287932d
CPU threads: 8; OS: Linux 5.1; UI render: default; VCL: gtk3; 
Locale: fi-FI (fi_FI.UTF-8); UI-Language: en-US
Calc: threaded
Built on 19 May 2019
Comment 15 Buovjaga 2019-05-19 13:48:45 UTC
I bibisected it and found another report blaming the same commit. I will close this as dupe, even though it is newer.

*** This bug has been marked as a duplicate of bug 118778 ***
Comment 16 PaulSh 2019-05-20 15:18:26 UTC
Thank you for your time. Should not bug 118778 now be marked as confirmed, though?

Sorry if I don't understand the way things work here, I'm a Jira user :)
Comment 17 Buovjaga 2019-05-20 15:43:50 UTC
(In reply to PaulSh from comment #16)
> Thank you for your time. Should not bug 118778 now be marked as confirmed,
> though?
> 
> Sorry if I don't understand the way things work here, I'm a Jira user :)

It is marked as confirmed (NEW).

https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status#How_to_use_NEW