https://bugs.freedesktop.org/show_bug.cgi?id=72735
Priority: medium
Bug ID: 72735
Assignee: [email protected]
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: [email protected]
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
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
