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.
Not yet reproduced
Not really sure if I need to do something or you can't reproduce times I mesured?
please post a test file where you exactly reproduce the issue.
Created attachment 91265 [details] ODS test file In attached test file, copy B2 cell, then select range B2:NB41 (range marked with borders) and paste. I tested it and it took 7 minutes for LO to paste it!!! After pasting, try to enter letter "b" in any of the cells. It takes 2-3 seconds for LO to accept input.
Editing title since it never did hang, it only takes a lot of time.
tested under Win7 64bit my PC is less powerful than yours and that test freezes LibO either using 4.0.5 or 4.1.4 releases (so I edit release field to first release where it can be reproduced) I also add Calc expert to CC list.
If I may add to this, when I try to work similliar sheets which have about 5500 cells under conditional formatting, it's pain in ass to do anything. I tryed SUM() that row, and it take 30+ sec to enter SUM formula.
Created attachment 93285 [details] picture of manage dialog
(In reply to comment #4) > Created attachment 91265 [details] > ODS test file > > In attached test file, copy B2 cell, then select range B2:NB41 (range marked > with borders) and paste. > I tested it and it took 7 minutes for LO to paste it!!! > After pasting, try to enter letter "b" in any of the cells. It takes 2-3 > seconds for LO to accept input. This bug can be solved with a more rational/efficient use of CF : When copying CF of cell B2 to range B2:NB41 you create 12000 range of 1 cell with the same CF. Open the manage dialog (Format > Conditional formatting > Manage) and see what I mean. More rational use : 1 CF for 1 range. 1. Open the manage dialog 2. Select the CF for cell B2 3. Extend the range B2 to B2:AN41 (see screenshot attached in previous post) You have now only only CF applied to a range of cells.
*** Bug 81667 has been marked as a duplicate of this bug. ***
I also see the problem on a WIN7 64bit laptop with Version 3.6.5.2 (Build ID: 5b93205). GerardF's comment shows a more functional way how to apply Conditional formatting, but that will help nothing if a user deliberately copies / pastes cell contents, what (coincidentally) contains Conditional Formatting.
*** Bug 73171 has been marked as a duplicate of this bug. ***
Hi reporters :) How is this on recent versions of LibreOffice?
To be honest, I can't say. I've changed my work habits. What I do now is paste-special and leave formats unchecked. Then I manage conditional formatting to extend it to whatever cells I need covered rule-by-rule. The only time I don't do this is if I want to fill-down or fill-right. I haven't noticed it being slow for that but (a) I don't do it for many cells (10-20 at a time) and (b) I go clean-up what the rule covers under manage conditional formatting as soon as I do it so I don't have crazy messy lists of where formats apply.
(In reply to Cor Nouws from comment #13) > Hi reporters :) > > How is this on recent versions of LibreOffice? I'm testing it on work computer which is much faster (intel i5, 8GB of ram) then one in comment #1, and everything is much faster now. - Coping of cell from b2 to whole sheet now lasts around 3 seconds. - Inserting new letters/numbers after that is instant, no lag. Not sure if it's fixed or just because I'm on faster computer. When I go "Format - Conditional formatting - Manage" after paste, I see ranges only for column B (B2, B3, B4, ..., B41), but conditional formatting is working for all cells affected by paste. LO 4.4.1.1
Dear Bug Submitter, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INVALID due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/FDO/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team This NEEDINFO message was generated on: 2015-09-03
Hi Mikeyy, (In reply to Mikeyy - L10n HR from comment #15) > Not sure if it's fixed or just because I'm on faster computer. Thanks for your information. Lets set this issue to WorksForMe then