[Libreoffice-bugs] [Bug 115488] FILESAVE: FILEOPEN: Abnormally long open & save times, thought to arise from conditional formatting in spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=115488 Xisco Faulí changed: What|Removed |Added Resolution|--- |DUPLICATE Status|NEW |RESOLVED --- Comment #14 from Xisco Faulí --- I've just checked again in Version: 6.3.0.0.alpha0+ Build ID: 0a04150b6eefb5feb7ecefaa5cd63dbac8c1574f 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 and it's even better ( probably because of https://cgit.freedesktop.org/libreoffice/core/commit/?id=1e3d0a57689006cd7244481958025177c01e4d09 ) real0m48,060s user0m50,231s sys 0m3,808s so let's close this one as dupe of bug 81765. it will improve even more after https://gerrit.libreoffice.org/#/c/71043/ lands in master *** This bug has been marked as a duplicate of bug 81765 *** -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 115488] FILESAVE: FILEOPEN: Abnormally long open & save times, thought to arise from conditional formatting in spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=115488 Xisco Faulí changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=81 ||765 --- Comment #13 from Xisco Faulí --- (In reply to Buovjaga from comment #12) > (In reply to Xisco Faulí from comment #11) > > it takes > > > > real1m11,283s > > user1m13,856s > > sys 0m6,017s > > > > to open in > > > > Version: 6.3.0.0.alpha0+ > > Build ID: e913727c7ee3af0bb4031c6829abfb3373306492 > > 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 > > People were getting 20 min opening times, so it is obvious the fixes for bug > 81765 had an effect. Maybe we will leave it open for now. I could do a new > trace later. While you wrote the comment I was checking in LibreOffice 6.2. I had to kill it... real9m43,806s user0m0,021s sys 0m0,007s So definitely bug 81765 is related... I would wait for https://gerrit.libreoffice.org/#/c/71043/ before getting a new trace -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 115488] FILESAVE: FILEOPEN: Abnormally long open & save times, thought to arise from conditional formatting in spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=115488 --- Comment #12 from Buovjaga --- (In reply to Xisco Faulí from comment #11) > it takes > > real 1m11,283s > user 1m13,856s > sys 0m6,017s > > to open in > > Version: 6.3.0.0.alpha0+ > Build ID: e913727c7ee3af0bb4031c6829abfb3373306492 > 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 People were getting 20 min opening times, so it is obvious the fixes for bug 81765 had an effect. Maybe we will leave it open for now. I could do a new trace later. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 115488] FILESAVE: FILEOPEN: Abnormally long open & save times, thought to arise from conditional formatting in spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=115488 Xisco Faulí changed: What|Removed |Added CC||xiscofa...@libreoffice.org --- Comment #11 from Xisco Faulí --- it takes real1m11,283s user1m13,856s sys 0m6,017s to open in Version: 6.3.0.0.alpha0+ Build ID: e913727c7ee3af0bb4031c6829abfb3373306492 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 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 115488] FILESAVE: FILEOPEN: Abnormally long open & save times, thought to arise from conditional formatting in spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=115488 --- Comment #10 from QA Administrators --- ** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 115488] FILESAVE: FILEOPEN: Abnormally long open & save times, thought to arise from conditional formatting in spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=115488 Buovjaga changed: What|Removed |Added Keywords||haveBacktrace Severity|normal |major -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 115488] FILESAVE: FILEOPEN: Abnormally long open & save times, thought to arise from conditional formatting in spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=115488 Buovjaga changed: What|Removed |Added CC||todven...@suomi24.fi --- Comment #9 from Buovjaga --- Created attachment 141178 --> https://bugs.documentfoundation.org/attachment.cgi?id=141178&action=edit Callgrind output from master (fileopen) Arch Linux 64-bit Version: 6.1.0.0.alpha0+ Build ID: 8ed2fb306ffa8c7fef336b858fc5074c309c3c9f CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: kde4; Locale: fi-FI (fi_FI.UTF-8); Calc: group Built on April 6th 2018 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 115488] FILESAVE: FILEOPEN: Abnormally long open & save times, thought to arise from conditional formatting in spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=115488 Timur changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=61 ||484 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 115488] FILESAVE: FILEOPEN: Abnormally long open & save times, thought to arise from conditional formatting in spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=115488 --- Comment #8 from Alex Thurgood --- FWIW, MS Excel 2016 (11.11.1) on macOS 10.13.4 opens the ODS file in less than 2 minutes ! Time to switch to Excel to open ODS files ? -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 115488] FILESAVE: FILEOPEN: Abnormally long open & save times, thought to arise from conditional formatting in spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=115488 Alex Thurgood changed: What|Removed |Added CC||ipla...@tuta.io --- Comment #7 from Alex Thurgood --- *** Bug 116844 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 115488] FILESAVE: FILEOPEN: Abnormally long open & save times, thought to arise from conditional formatting in spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=115488 Aron Budea changed: What|Removed |Added Version|3.3.0 release |Inherited From OOo Blocks||87351 OS|Mac OS X (All) |All --- Comment #6 from Aron Budea --- This issue is not specific to macOS. Two problem areas are these functions: https://opengrok.libreoffice.org/xref/core/sc/source/core/data/conditio.cxx#2270 sal_uInt32 ScConditionalFormatList::getMaxKey() const https://opengrok.libreoffice.org/xref/core/sc/source/core/data/conditio.cxx#2046 ScConditionalFormat* ScConditionalFormatList::GetFormat( sal_uInt32 nKey ) They are both linear searches over m_ConditionalFormats, so with many conditional format entries that can take a while. What could be done? The comparison is done against the nKey coming from the individual entries in m_ConditionalFormats (currently a set of pointers to ScConditionalFormat objects). One problem is that those nKey-s are set outside in the code, first by querying an available one from the ScConditionalFormatList (that's what getMaxKey() is for), setting it in the ScConditionalFormat, then adding it to the list, ie. in 'sal_uLong ScTable::AddCondFormat(...)', 'void ScTable::CopyConditionalFormat(...)' and 'ScCondFormatDlg::OkPressed()'. If managing nKey was internalized in ScConditionalFormatList, then it could keep track of the max (making it a constant time operation), and keep the conditional formats in a data structure sorted by nKey (making searching on nKey logarithmic). I'm not familiar with the code, so I can't tell if anything else could prevent this change. Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=87351 [Bug 87351] [META] Conditional formatting bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 115488] FILESAVE: FILEOPEN: Abnormally long open & save times, thought to arise from conditional formatting in spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=115488 Alex Thurgood changed: What|Removed |Added Version|6.0.0.3 release |3.3.0 release -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 115488] FILESAVE: FILEOPEN: Abnormally long open & save times, thought to arise from conditional formatting in spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=115488 --- Comment #5 from Alex Thurgood --- Also tested against LibreOffice 3.3.0 OOO330m19 (Build:6) tag libreoffice-3.3.0.4 File opens after ca. 20 mins. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 115488] FILESAVE: FILEOPEN: Abnormally long open & save times, thought to arise from conditional formatting in spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=115488 Alex Thurgood changed: What|Removed |Added Keywords||perf Status|UNCONFIRMED |NEW Ever confirmed|0 |1 --- Comment #4 from Alex Thurgood --- I could confirm this with B4.ods just on loading the file. So far, the loading process appears to be suspended and it has been going for more than 20 min. MacOS system reports that the LO app is not responding. So the document finally loaded after 22 minutes. Made a single letter change in one cell with a text string. Saved. Saving took 4 min. Version: 6.0.0.3 Build ID: 64a0f66915f38c6217de274f0aa8e15618924765 Threads CPU : 4; OS : Mac OS X 10.13.3; UI Render : par défaut; Locale : fr-FR (fr_FR.UTF-8); Calc: group -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 115488] FILESAVE: FILEOPEN: Abnormally long open & save times, thought to arise from conditional formatting in spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=115488 --- Comment #3 from Telesto --- Repro with B4.ods Version: 6.1.0.0.alpha0+ Build ID: 8a0b61172a14b8b766a2e85f27762db3558d3af7 CPU threads: 4; OS: Windows 6.3; UI render: default; TinderBox: Win-x86@42, Branch:master, Time: 2018-02-06_03:28:54 Locale: nl-NL (nl_NL); Calc: CL and with LibO 5.4.0.4 The file is pretty crash prior to 5.4.04 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 115488] FILESAVE: FILEOPEN: Abnormally long open & save times, thought to arise from conditional formatting in spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=115488 --- Comment #2 from tagishsimon --- Created attachment 139633 --> https://bugs.documentfoundation.org/attachment.cgi?id=139633&action=edit file with no conditional formatting -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 115488] FILESAVE: FILEOPEN: Abnormally long open & save times, thought to arise from conditional formatting in spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=115488 --- Comment #1 from tagishsimon --- Created attachment 139632 --> https://bugs.documentfoundation.org/attachment.cgi?id=139632&action=edit File with conditional format on column B Example of a problematic file -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
