Public bug reported:
Binary package hint: openoffice.org
oocalc repeatedly re-evaluates STYLE in Conditional Formats forever,
sucking CPU even when "doing nothing".
This occurs if the formula in the Cond. Format calls the STYLE function and
references any cell content,
for example 'STYLE( somefunction(A1) )'
In a large spreadsheet this causes 80-90% CPU utilization when "nothing"
is happening. Also, if the formulas are calling (working) Basic
functions, it is almost impossible to develop new macro code for other
purposes because the existing macros are called constantly while you are
trying to edit new code; the compiler "spontaneously" runs from time to
time and strange crashes occur, loosing recent edits.
Please open the attached demo spreadsheet.
In the demo, a Conditional Format formula calls a Basic macro, which
displays a message every 350th time it is called.
ProblemType: Bug
DistroRelease: Ubuntu 10.04
Package: openoffice.org-calc 1:3.2.0-7ubuntu4
ProcVersionSignature: Ubuntu 2.6.32-22.33-generic 2.6.32.11+drm33.2
Uname: Linux 2.6.32-22-generic x86_64
NonfreeKernelModules: fglrx
Architecture: amd64
Date: Thu May 27 15:50:54 2010
InstallationMedia: Ubuntu 10.04 LTS "Lucid Lynx" - Release amd64 (20100429)
ProcEnviron:
PATH=(custom, user)
LANG=en_US.UTF-8
SHELL=/bin/bash
SourcePackage: openoffice.org
** Affects: openoffice.org (Ubuntu)
Importance: Undecided
Status: New
** Tags: amd64 apport-bug lucid
--
Conditional Formats using STYLE func re-eval forever, sucking CPU
https://bugs.launchpad.net/bugs/586599
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
