https://bugs.documentfoundation.org/show_bug.cgi?id=155551
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Version|7.5.3.2 release |Inherited From OOo --- Comment #5 from Eike Rathke <[email protected]> --- The problem here is that functions like MATCH() and [HV]LOOKUP() (have to) force its range parameters into array mode, which for functions like TRIM() that do not handle cell ranges (i.e. expect a single scalar value as argument) means having to iterate over its given cell range to produce an array that will be passed to MATCH(). For a cell range like in TRIM(B:B) that is iterating over a million rows to generate a million elements array.. -- You are receiving this mail because: You are the assignee for the bug.
