https://bugs.documentfoundation.org/show_bug.cgi?id=150712
--- Comment #2 from Pierre Fortin <[email protected]> --- I hate giving up... Here's a workaround in case that helps someone... Discovered that while a tad slow, though only a few seconds; I could select one column and apply 8 conditions to that column's 151K+ rows. Then, I edited the range from $B$2:$B$154161 to $B2:$SG$154161 which applied quickly across the entire range. I'll try this same workaround tomorrow on the 99 other sheets which are being created overnight (some expected to be 950Kx501)... Actually, the workaround should be even faster by applying the initial formatting to just a few cells, then edit the range... That said, it becomes obvious Calc loads the file, then applies the formatting before displaying the sheet -- that is quite slow too. -- You are receiving this mail because: You are the assignee for the bug.
