[Libreoffice-bugs] [Bug 81765] FILEOPEN: slow loading of .ods and .xlsx
https://bugs.documentfoundation.org/show_bug.cgi?id=81765 Maarten Bosmans changed: What|Removed |Added Keywords||perf CC||mkbosm...@gmail.com -- 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 81765] FILEOPEN: slow loading of .ods and .xlsx
https://bugs.documentfoundation.org/show_bug.cgi?id=81765 --- Comment #6 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 on a currently supported version of LibreOffice (5.0.0.5 or later) https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System 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) 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: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for your help! -- The LibreOffice QA Team This NEW Message was generated on: 2015-09-03 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 81765] FILEOPEN: slow loading of .ods and .xlsx
https://bugs.freedesktop.org/show_bug.cgi?id=81765 tommy27 changed: What|Removed |Added Status|UNCONFIRMED |NEW CC||ba...@quipo.it Summary|FILEOPEN: Open slow |FILEOPEN: slow loading of ||.ods and .xlsx Ever confirmed|0 |1 --- Comment #1 from tommy27 --- very slow loading of both the .ods and .xlsx version of that file. tested under Win7x64 using LibO 4.2.5.2 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 81765] FILEOPEN: slow loading of .ods and .xlsx
https://bugs.freedesktop.org/show_bug.cgi?id=81765 Eike Rathke changed: What|Removed |Added Hardware|Other |All OS|Windows (All) |All Version|4.2.5.2 release |4.1.6.2 release --- Comment #2 from Eike Rathke --- Also slow in 4.1.6.2 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 81765] FILEOPEN: slow loading of .ods and .xlsx
https://bugs.freedesktop.org/show_bug.cgi?id=81765 Eike Rathke changed: What|Removed |Added CC||markus.mohrhard@googlemail. ||com --- Comment #3 from Eike Rathke --- Slowness is due to the massive amount (>1000) of conditional formats, most on sheets FT-ING-PR-02 and FT-ING-PR-03, many of them even applied to identical ranges. Looks like a result of heavy copy&paste actions, or the macro you mentioned creates them. All these conditionals also extremely slow down scrolling around in the document once it was loaded. @Markus: Shouldn't a conditional style when pasted be merged with its neighbors if identical? Can we somehow detect and correct this mess during document load? @Eduardo: You could unprotect the sheets and invoke Format->Conditional->Manage and manually remove all the single formats and extend one of them to cover the needed ranges. It's quite a tedious task though. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 81765] FILEOPEN: slow loading of .ods and .xlsx
https://bugs.freedesktop.org/show_bug.cgi?id=81765 --- Comment #4 from Eduardo Moreno --- (In reply to comment #3) > Slowness is due to the massive amount (>1000) of conditional formats, most > on sheets FT-ING-PR-02 and FT-ING-PR-03, many of them even applied to > identical ranges. Looks like a result of heavy copy&paste actions, or the > macro you mentioned creates them. All these conditionals also extremely slow > down scrolling around in the document once it was loaded. > > @Markus: > Shouldn't a conditional style when pasted be merged with its neighbors if > identical? Can we somehow detect and correct this mess during document load? > > @Eduardo: > You could unprotect the sheets and invoke Format->Conditional->Manage and > manually remove all the single formats and extend one of them to cover the > needed ranges. It's quite a tedious task though. The password to unprotect is 123456. The macro create a conditional format when add a row. Never know how many rows will be add. If you say the roblem is conditional format, I try to modify the macro to create only uone range of conditional format. I report the changes. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 81765] FILEOPEN: slow loading of .ods and .xlsx
https://bugs.freedesktop.org/show_bug.cgi?id=81765 --- Comment #5 from Markus Mohrhard --- (In reply to comment #3) > Slowness is due to the massive amount (>1000) of conditional formats, most > on sheets FT-ING-PR-02 and FT-ING-PR-03, many of them even applied to > identical ranges. Looks like a result of heavy copy&paste actions, or the > macro you mentioned creates them. All these conditionals also extremely slow > down scrolling around in the document once it was loaded. > > @Markus: > Shouldn't a conditional style when pasted be merged with its neighbors if > identical? Can we somehow detect and correct this mess during document load? > We already do that if a document is imported and does not contain the new conditional format entries. However it is much more complicated during copy&paste as we have now conditional formats that rely on the range. Take the simple example of a conditional format that just formats one column with a color scale. Now copying that column to the next one has two solutions for what we could do with the conditional formatting: merge and create ahuge one spanning two columns or create a second one that just spans this new column. There will always be cases where one or the other solution are wrong. Therefore we have now the manage conditional formatting dialog which helps the user to change the formatting or range if it is not what he expected. Sadly I don't see a perfect solution here. Sadly the UNO API does not reflect all the possibilities (I have to support the old one as it is published) and does not allow to modify the range of a conditional formatting currently. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs