Created attachment 146224 [details] Example file from Excel with 800k rows Attached user-made xlsx has a few rows with actual data then 800k empty rows that are actually saved. I have no idea how or why they made it so. Opening this in Excel takes a few seconds, but in Calc it takes several minutes with 100% processor use. Memory use jumps inside a range of a few megabytes, so it does not run away. It would be nice to improve performance in case of such "extreme" files.
Created attachment 146225 [details] Opening the file in Calc is sloooow Version: 6.2.0.0.alpha1+ Build ID: b6b31bbb1a9e2272ac77de127825c4ee9f71effa CPU threads: 4; OS: Windows 6.3; UI render: GL; VCL: win; Locale: hu-HU (hu_HU); Calc: CL
Created attachment 146226 [details] Opening the xl\worksheets\sheet1.xml Opening 25 Mb of this can be slow: <row r="812055" ht="15" customHeight="1" x14ac:dyDescent="0.25"/><row r="812057" ht="15" customHeight="1" x14ac:dyDescent="0.25"/><row r="812059" ht="15" customHeight="1" x14ac:dyDescent="0.25"/>
Repro with Version: 6.2.0.0.alpha1+ Build ID: 4fa9e6f7f891b335ae1b432e0848c1e46c8fe3ef CPU threads: 4; OS: Windows 6.3; UI render: default; VCL: win; TinderBox: Win-x86@42, Branch:master, Time: 2018-10-30_22:44:48 Locale: nl-NL (nl_NL); Calc: CL and with Versie: 4.4.7.2 Build ID: f3153a8b245191196a4b6b9abd1d0da16eead600 Locale: nl_NL
Noel Grandin committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/79927a934b8a27bd4dee7a263171981e6ca22f8a%5E%21 tdf#121094 Opening xlxs with many rows takes several minutes It will be available in 6.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.
Noel Grandin committed a patch related to this issue. It has been pushed to "libreoffice-6-3": https://git.libreoffice.org/core/+/cabaadf278ba099c53ed2b7a32f1e11bc632ad3a%5E%21 tdf#121094 Opening xlxs with many rows takes several minutes It will be available in 6.3.0.1. 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.
It opens instantly in Version: 6.3.0.0.beta1+ Build ID: cabaadf278ba099c53ed2b7a32f1e11bc632ad3a 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 @Noel, thanks for fixing this issue!
(In reply to Gabor Kelemen from comment #0) > I have no idea how or why they made it so. Probably from LO 5.2.0-5.2.5 bug 105840 - FILESSAVE XLS: file size increases to 21mb after re-saving a particular Calc document