Bug 149055 - Embedded chart no longer works properly
Summary: Embedded chart no longer works properly
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
7.3.2.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-05-12 14:47 UTC by John
Modified: 2022-10-06 17:06 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Chart showing problem (176.83 KB, image/jpeg)
2022-05-12 14:47 UTC, John
Details
Requested sample file (90.85 KB, application/vnd.oasis.opendocument.spreadsheet)
2022-08-14 23:21 UTC, John
Details

Note You need to log in before you can comment on or make changes to this bug.
Description John 2022-05-12 14:47:52 UTC
Created attachment 180083 [details]
Chart showing problem

I have a spreadsheet in which I've embedded two charts. To allow both charts to be combined I created one with a transparent background. I then placed the one chart on top of the other.

After the Tuesday May 10th Windows 10 updates the background chart no longer displays correctly. The chart is scrunched. I can click on the chart and it looks fine. It scrunches when I bring the other chart forward. I've enclosed a screenshot of the problem.

The Chart worked properly on Monday evening and Tuesday evening. The update occurred Tuesday night-Wednesday morning sometime. Wednesday evening I could not make the chart appear properly.

Each time I save and reopen the spreadsheet the problem is worse. I have attempted to open older copies and to restore from backup. The problem remains for all instances.

Windows 10 with all updates. Problem verified in LibreOffice 7.3.2 and 7.3.3

John
Comment 1 John 2022-05-12 17:45:19 UTC
I disassembled the malfunctioning chart. The specific problem was caused by some vertical lines added to the charge using the drawing tools. 

For some reason the lines blew up and extended outside the chart boundaries. 

I don't know whether the lines were like that before the update and the update has some graphic API that misinterprets the line meta-data or if the update corrupts the meta-data. The fact the situation was getting worse on saving/reopening leans toward data corruption.

Old charts that were working before the update are still not working and after saving/reopening the corrected file the problem reappears. 

There is something in the graphic engine that's corrupting the lines.

John
Comment 2 raal 2022-08-09 19:54:46 UTC Comment hidden (obsolete)
Comment 3 John 2022-08-14 23:21:01 UTC
Created attachment 181776 [details]
Requested sample file

I've enclosed a copy of the file. If you open it in the current version of LibreOffice the vertical lines in the chart will be elongated. The original the lines were within the colored part of the chart. On opening you will see they are elongated past that area. Make a minor change to  a cell and save, close and reopen the spreadsheet. You will observe the lines have lengthened again. Each iteration will cause the lines to grow longer.

The lines originally marked the boundary between months. As they lengthen they become skewed.

There are no instructions about where to upload the file so I'm enclosing it with this email. I'll also try to upload it to the bug report.
Comment 4 QA Administrators 2022-08-15 03:45:58 UTC Comment hidden (obsolete)
Comment 5 BogdanB 2022-08-16 09:53:55 UTC
it's ok in
Version: 7.4.0.2 (x64) / LibreOffice Community
Build ID: 1512ce97d7ed39dce3121f7e15651fd8895f950e
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: ro-RO (ro_RO); UI: en-US
Calc: threaded
Comment 6 BogdanB 2022-08-16 09:54:57 UTC
Working well in
Version: 7.5.0.0.alpha0+ (x86) / LibreOffice Community
Build ID: 550392aeb849b326aa0d5d84a0ec1d28d3d42503
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: ro-RO (ro_RO); UI: en-US
Calc: threaded
Comment 7 John 2022-08-16 15:40:06 UTC
I see in the comments the problem is fixed in version 7.4.02. The current available release is 7.3.5. What is the expected release date for 7.4?
Thanks, John
Comment 9 Timur 2022-08-16 18:55:30 UTC
To be sure that problem is fixed in 7.4, tester should first reproduce with 7.3.
Comment 10 raal 2022-10-04 20:41:03 UTC
Looks good in Version: 7.5.0.0.alpha0+ / LibreOffice Community
Build ID: a0bc0cc81b597aa81189355a8125753d6b873cce
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded

and Version: 7.3.6.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: cs-CZ
Ubuntu package version: 1:7.3.6-0ubuntu0.22.04.1
Calc: threaded

@John, please, can you retest with newer version? Thank you.
Comment 11 John 2022-10-06 05:37:52 UTC
I'm at version 7.3.3.2 and it works great. I re-added all my lines!

Which version did you want me to test with? The downloads page shows 7.4.1 as the bleeding edge version and 7.3.6 as the stable version. I don't usually do the early adopter version as I'm just an ordinary user.

Thanks for your great work, John
Comment 12 Timur 2022-10-06 07:18:54 UTC
(In reply to John from comment #0)
> Windows 10 with all updates. Problem verified in LibreOffice 7.3.2 and 7.3.3

(In reply to John from comment #11)
> I'm at version 7.3.3.2 and it works great. I re-added all my lines!

I hope you mean that it works O in 7.3.6.2.
I didn't reproduce with 7.3.0 like described, but I did that opening was wrong, artifacts (like frozen screen parts) in chart. 
LO 7.3.6 seems OK for me. 
I understand this may be closed. If not, please explain. 

> Which version did you want me to test with? The downloads page shows 7.4.1
> as the bleeding edge version and 7.3.6 as the stable version. I don't
> usually do the early adopter version as I'm just an ordinary user.
Normally it's prudent to keep Still for work and that's 7.3.6 now, soon 7.3.7.
Best is to test with daily master from https://dev-builds.libreoffice.org/daily/master/current.html that installs in addition to working LO and doesn't take extensions, so it's useful for testing of specific bug and general changes. 
 
> Thanks for your great work, John
Thanks to you too for reporting and retesting.
Comment 13 John 2022-10-06 17:06:06 UTC
I installed 7.4.1 to test. Works, no problem.
John