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 2013/12/02 19:22:40 UTC
[Bug 123799] New: insert columns causes very slow recalc
https://issues.apache.org/ooo/show_bug.cgi?id=123799
Bug ID: 123799
Issue Type: DEFECT
Summary: insert columns causes very slow recalc
Product: Calc
Version: 4.0.1
Hardware: PC
OS: Windows 7
Status: UNCONFIRMED
Severity: major
Priority: P3
Component: programming
Assignee: issues@openoffice.apache.org
Reporter: paul@solarandthermal.com
CC: issues@openoffice.apache.org
Created attachment 82029
--> https://issues.apache.org/ooo/attachment.cgi?id=82029&action=edit
BOM spreadsheet
inserting 4 columns into 200 row workbook takes minutes to recalc
The problem is bad, but it is getting worse and this delay was the proverbial
"straw that broke..."
Heavy use of MATCH() to recursively examine columns for previous instances of
text to create hierarchy of parts in assemblies.
Uses borrowed macro to generate a short and unique 'hash' for use in unique
part-number.
This workbook is primarily a text processor. The number crunching has been
omitted.
This concept worked much better in Version 3.6 I was disappointed with the 4.0
upgrade, someone broke something, probably the "dirty-bit' that causes
recalculations on cell updates.
Feel free to contact me with questions. I'd like to do more, but don't know
where/how to contribute to the coding effort.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 123799] insert columns causes very slow recalc
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123799
Edwin Sharp <el...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords| |needmoreinfo
CC| |elish@apache.org
--- Comment #1 from Edwin Sharp <el...@apache.org> ---
Can not open attachment with
AOO410m1(Build:9750) - Rev. 1539999
2013-11-09_04:08:11 - Rev. 1540252
Debian:
BASIC runtime error.
Object variable not set.
Apache OpenOffice had no version 3.6. Maybe LibreOffice...
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 123799] insert columns causes very slow recalc
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123799
--- Comment #2 from Paul Passarelli <pa...@solarandthermal.com> ---
Greetings,
I consider the error tester received to be another BUG with:
Apache_OpenOffice_4.0.1_Win_x86_install_en-US.exe
Windows 7.0 Professional 7 SP1 OEM
HP xw8600 XEON 3.33GHz
The macro(s) invoked expect string and/or long arguments. The environment
behaves badly when the macro is passed a labeled cell (which I do
extensively)...
Suggest trying the attached workbook on a Windows PC (instead of linux) at
least it loads on the Micro$oft platform. ;^)
Apologies (regarding 3.6) the previous version I was using was:
"OpenOffice.org 3.4.1 (en-US) Installation Files"
I can't say for certain that this particular workbook would work on that
version, but, I had created previous workbooks in that earlier version of OO
that ran satisfactorily with many more rows (~1000) before the performance hit
became unacceptable (on an HP xw4600 2.33 GHz Core2Duo).
Appreciatively,
--Paul
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 123799] insert columns causes very slow recalc
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123799
--- Comment #3 from Paul Passarelli <pa...@solarandthermal.com> ---
One more thing, the slow recacl is just as evident with macros disabled.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 123799] insert columns causes very slow recalc
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123799
Paul Passarelli <pa...@solarandthermal.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |paul@solarandthermal.com
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 123799] insert columns causes very slow recalc
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123799
Edwin Sharp <el...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |IRREPRODUCIBLE
--- Comment #4 from Edwin Sharp <el...@apache.org> ---
Can not open attachment 82029.
AOO410m1(Build:9750) - Rev. 1543812
Rev.1543812
Win 7
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.