You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2011/10/25 12:26:49 UTC
DO NOT REPLY [Bug 118546] New: CPU 100% on switched off
AutoCalculate with Conditional Formatting on date values
https://issues.apache.org/ooo/show_bug.cgi?id=118546
Bug #: 118546
Issue Type: DEFECT
Summary: CPU 100% on switched off AutoCalculate with
Conditional Formatting on date values
Classification: Application
Product: Spreadsheet
Version: OOo 3.4 Beta
Platform: All
OS/Version: All
Status: UNCONFIRMED
Severity: critical
Priority: P5
Component: ui
AssignedTo: spreadsheet@openoffice.org
ReportedBy: apache-ooo-bugzilla@turcan.sk
CC: ooo-issues@incubator.apache.org
Created attachment 76926
--> https://issues.apache.org/ooo/attachment.cgi?id=76926
reproduced problem in sample file
Problem description: When spreadsheet on foreground with switched off
AutoCalculate + there are some cells with Conditional Formatting and date
values, very high CPU load can be seen everlasting.
For simplicity I've created simple scenario (in reality I have complex document
and conditional formatting is only in the first column).
Steps to reproduce:
1. Create new Calc / Spreadsheet document
2. set A1 =TODAY()
3. set B1 .. K1 = A1+1 .. J1+1
4. copy row 1 to rows 2 ..40
5. set on this (A1..K40) cells the conditional formatting:
[x] Condition 1: Cell value is equal to TODAY()
6. set Tools / Cell Content / [ ] AutoCalculate
Current behavior: very high CPU load: 30-100% without any user input
Expected behavior: minimal CPU load (0-1%)
Platform (if different from the browser): probably on all platforms (at least
on linux and windows). this bug is also in older versions (at least 2 years
ago)
--
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
DO NOT REPLY [Bug 118546] CPU 100% on switched off AutoCalculate
with Conditional Formatting on date values
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=118546
lei.wang.leiw@gmail.com changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |lei.wang.leiw@gmail.com
--- Comment #2 from lei.wang.leiw@gmail.com 2012-03-08 06:32:21 UTC ---
Confirm it in AOO3.4 rev 1296433.
I am investigating it.
--
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
DO NOT REPLY [Bug 118546] CPU 100% on switched off AutoCalculate
with Conditional Formatting on date values
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=118546
leiw@apache.org changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|CONFIRMED |ACCEPTED
CC| |leiw@apache.org
AssignedTo|spreadsheet@openoffice.org |leiw@apache.org
--
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
DO NOT REPLY [Bug 118546] CPU 100% on switched off AutoCalculate
with Conditional Formatting on date values
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=118546
--- Comment #4 from leiw@apache.org 2012-03-16 08:56:23 UTC ---
If the auto calculate is disable, the result of the formula in the condition
entry will not be updated. So it does not need to make range dirty to update
the range.
Fix this issue with revision 1301380
--
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
[Bug 118546] CPU 100% on switched off AutoCalculate with Conditional
Formatting on date values
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=118546
Wang Lei <le...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|ACCEPTED |RESOLVED
Resolution|--- |FIXED
--
You are receiving this mail because:
You are on the CC list for the bug.
DO NOT REPLY [Bug 118546] CPU 100% on switched off AutoCalculate
with Conditional Formatting on date values
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=118546
mla@openoffice.org changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
Ever Confirmed|0 |1
--- Comment #1 from mla@openoffice.org 2011-10-25 16:03:25 UTC ---
Confirmed on Linux and OOo 3.3
--
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
[Bug 118546] CPU 100% on switched off AutoCalculate with Conditional
Formatting on date values
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=118546
binguo <bi...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |CLOSED
CC| |binbjguo@gmail.com
--- Comment #5 from binguo <bi...@gmail.com> ---
Verified on Aoo_Trunk_20120828.1800, it can not repro, it is fixed. so close
it.
--
You are receiving this mail because:
You are on the CC list for the bug.
DO NOT REPLY [Bug 118546] CPU 100% on switched off AutoCalculate
with Conditional Formatting on date values
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=118546
--- Comment #3 from leiw@apache.org 2012-03-16 07:11:10 UTC ---
When timer invoke Paint, it will call ScConditionEntry::Interpret(). If Auto
Calculate is disable, SC will not calc formula which make the temp formula
always dirty. The dirty state will make ScConditionEntry::DataChanged() be
invoked, which will call ScDocument::RepaintRange(). This will make some range
invalid and to be painted in next timer invoke Paint.
So there is always something to be repainted.
--
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.