https://bugs.freedesktop.org/show_bug.cgi?id=81765
--- Comment #4 from Eduardo Moreno <[email protected]> --- (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 [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
