Bug 134553 - New or XLSX-imported chart and images disappears with Jumbo sheets enabled
Summary: New or XLSX-imported chart and images disappears with Jumbo sheets enabled
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.0.0.alpha0+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: target:7.4.0
Keywords: bibisected, bisected, regression
: 141647 (view as bug list)
Depends on:
Blocks: Regressions-1024plus-Columns
  Show dependency treegraph
 
Reported: 2020-07-06 11:08 UTC by NISZ LibreOffice Team
Modified: 2022-03-11 10:15 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
Example file from Calc with very large sheets support disabled (13.89 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-07-06 11:08 UTC, NISZ LibreOffice Team
Details
Example file from Calc with very large sheets support enabled (13.39 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-07-06 11:10 UTC, NISZ LibreOffice Team
Details
The example ods files with very large sheets support disabled (99.83 KB, image/png)
2020-07-06 11:11 UTC, NISZ LibreOffice Team
Details
attachment #161078 in Excel and Calc with very large sheets support enabled (111.09 KB, image/png)
2020-07-06 11:12 UTC, NISZ LibreOffice Team
Details

Note You need to log in before you can comment on or make changes to this bug.
Description NISZ LibreOffice Team 2020-07-06 11:08:57 UTC
Created attachment 162698 [details]
Example file from Calc with very large sheets support disabled

When very large spreadsheets are enabled newly created charts are inserted outside the visible sheet area.
The same(?) also happens when opening existing XLXS files with charts too.

Steps to reproduce:
    1. Enable Experimental features, then Calc – Defaults – Enable very large spreadsheets
    2. Enter some data to the sheet and insert a default column chart
    3. OR open an existing XLSX file with chart, such as attachment #161078 [details]

Actual results:
Navigator shows the new (or XLSX-imported) chart, but it’s not visible on the sheet area. Turning off very large spreadsheets support avoids these problems.

Expected results:
New chart is visible.

LibreOffice details:
Version: 7.1.0.0.alpha0+ (x64)
Build ID: 9af38b4504ccda57a0c32eb8bdd03e5a8ca29ddc
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: en-US (hu_HU); UI: en-US
Calc: CL

Bibisected using bibisect-win64-6.5 to:
URL: https://cgit.freedesktop.org/libreoffice/core/commit/?id=1c8b8e97eb6127e430c1dc0fc3578cec94371fd7 

author: Noel Grandin <noel.grandin@collabora.co.uk> Mon Nov 25 13:03:42 2019 +0200 

committer: Noel Grandin <noel.grandin@collabora.co.uk> Wed Nov 27 13:10:45 2019 +0100 

sc: rowcol: tdf#50916 add UI to turn jumbo sheets on

Adding CC to: Noel Grandin
Comment 1 NISZ LibreOffice Team 2020-07-06 11:10:07 UTC
Created attachment 162699 [details]
Example file from Calc with very large sheets support enabled
Comment 2 NISZ LibreOffice Team 2020-07-06 11:11:50 UTC
Created attachment 162700 [details]
The example ods files with very large sheets support disabled

Also: the chart in the file made with very large sheet support turned off disappears with very large sheet support turned on.
Comment 3 NISZ LibreOffice Team 2020-07-06 11:12:05 UTC
Created attachment 162701 [details]
attachment #161078 [details] in Excel and Calc with very large sheets support enabled
Comment 4 Xisco Faulí 2020-07-21 16:09:42 UTC
Reproduced in

Version: 7.1.0.0.alpha0+
Build ID: abea0d6647c7f1f7e76c73c26cb80e6a67dc5111
CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
Comment 5 Kevin Suo 2020-10-13 03:57:33 UTC
This not only affects charts, but also image objects.
Comment 6 Xisco Faulí 2021-04-12 15:30:42 UTC
*** Bug 141647 has been marked as a duplicate of this bug. ***
Comment 7 Roman Kuznetsov 2022-02-15 08:36:46 UTC
No repro in

Version: 7.4.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 0bf0feb40ae5c394a14cdfe4f94fb98dd9053597
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
Calc: CL Jumbo

I tried the both cases (a new chart and the existing XLSX with chart)

NISZ team could you please retest your problem in current dev build?
Comment 8 Xisco Faulí 2022-02-15 10:25:58 UTC
Issue fixed by 

https://cgit.freedesktop.org/libreoffice/core/commit/?id=fd4384c59eefc8f34d5fe90929d7cb44ee15b27f

author	Luboš Luňák <l.lunak@collabora.com>	2022-02-07 18:06:12 +0100
committer	Luboš Luňák <l.lunak@collabora.com>	2022-02-08 12:26:18 +0100
commit fd4384c59eefc8f34d5fe90929d7cb44ee15b27f (patch)
tree 8543618389781675cafc6fabf88165d6e99b80ab
parent abc32f115ffd8df20ed122f6a769027b68da13f2 (diff)
avoid overflows in ScFlatUInt16RowSegments
Comment 9 Commit Notification 2022-02-15 11:54:37 UTC
Xisco Fauli committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/7b24b2f2a346bf65c9c997926ecddd1dc5aa05d5

tdf#134553: sc_jumbosheets: Add unittest

It will be available in 7.4.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.