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
Created attachment 162699 [details] Example file from Calc with very large sheets support enabled
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.
Created attachment 162701 [details] attachment #161078 [details] in Excel and Calc with very large sheets support enabled
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
This not only affects charts, but also image objects.
*** Bug 141647 has been marked as a duplicate of this bug. ***
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?
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
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.