Issue 98993

Summary: OOo stops responding when applying a custom AutoFormat style
Product: Calc Reporter: andreaippo <andrea.ippo>
Component: formattingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, rb.henschel
Version: OOo 3.0.1Keywords: oooqa, performance
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description andreaippo 2009-02-07 15:53:20 UTC
Steps to reproduce:

Define a new autoformat style: I did it by choosing a colour for the header row
(well, for A1:D1), one for the odd rows (A2:D2 and A4:D4) and another one for
the even ones (A3:D3).
Then I selected this 4x4 cells rectangle and added a new AutoFormat style
(Format->AutoFormat->Add... - I have the italian version so not sure about the
Now I select the entire sheet and try to apply the autoformat style I've just
created -> OOo stops responding and uses a lot of CPU (also writer and the other
programs of the suite don't respond any more).

Trying to apply a predefined AutoFormat style to the entire sheet takes instead
about 1 or 2 seconds on my dual core pc.
Comment 1 Regina Henschel 2009-02-07 17:58:14 UTC
I confirm it for OOoDEVm41 on WinXP. It depends not on whether it is a
predefined or a custom autoformat. It seems that it depends on whether you have
alternating rows.
Apply the predefined autoformat "Yellow" to an marked range in a new
spreadsheet. I have stopped these times:
     A1:Z12000     17seconds
     A1:Z16000     30seconds
     A1:Z20000     47seconds
     A1:Z24000     60seconds
I tried a whole sheet too, but I did not wait whether OOo will finish eventually.
Comment 2 Regina Henschel 2009-02-07 18:09:53 UTC
Add keyword performance. Excel2007 applies the format style immediately to
Comment 3 andreaippo 2009-02-07 18:16:31 UTC
I confirm your impression