https://bugs.freedesktop.org/show_bug.cgi?id=81765
--- Comment #5 from Markus Mohrhard <markus.mohrh...@googlemail.com> --- (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