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: p...@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.