Issue 98993

Summary:	OOo stops responding when applying a custom AutoFormat style
Product:	Calc	Reporter:	andreaippo <andrea.ippo>
Component:	formatting	Assignee:	AOO issues mailing list <issues>
Status:	CONFIRMED ---	QA Contact:
Severity:	Trivial
Priority:	P3	CC:	issues, rb.henschel
Version:	OOo 3.0.1	Keywords:	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
words).
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
A1:z24000.

Comment 3 andreaippo 2009-02-07 18:16:31 UTC

I confirm your impression