https://bugs.freedesktop.org/show_bug.cgi?id=72735
Priority: medium Bug ID: 72735 Assignee: libreoffice-bugs@lists.freedesktop.org Summary: Conditional formatting - LO hangs or takes very long time to make larger number of cell copies Severity: normal Classification: Unclassified OS: Windows (All) Reporter: mihovil.sta...@gmail.com Hardware: Other Status: NEW Version: 4.1.3.2 release Component: Spreadsheet Product: LibreOffice I'm on Win 7 64bit, Intel C2D E7500, 4GB of RAM and SSD HDD. When I try to copy 1 cell with conditional formatting to 40*300 cells, depending on conditional formatting, LO needs long time to copy cell or just hangs. TEST 1 1. Open new spreadsheet. 2. In A1 create new conditional formatting, for example If cell = 5 then text color = red. 3. Copy A1. 4. Mark A1:KN40 (40x300 cell range). 5. Paste Time needed to paste on my computer = 40 seconds. If I try to enter 5 after paste in any of cells in that range, it takes 2 sec for LO to accept number and mark it red. It should be instant. TEST 2 1. Open new spreadsheet. 2. In A1 create new conditional formatting, formula, OR(LEFT(A1;1)="R"), color background red and text white. It check for first letter in cell, if it's R, then conditional formatting is applied. 3. Copy A1. 4. Mark A1:KN40 (40x300 cell range). 5. Paste Time needed to paste on my computer = 90 seconds. Time needed to enter and accept R = 2 sec When pulling slider to return to column A, it lags. On my work computer I tried to copy to 365x40 range (1 year for 40 workers), cell had 3 conditional formattings like OR(LEFT(A1;1)="R";LEFT(A1;1)="r") and LO hanged, had to force close it. -- 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