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: [email protected]
Reporter: [email protected]
CC: [email protected]
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.
