Ask Your Question

Revision history [back]

How to debug 'Wrong data type' problem (`SEARCH` function) ?

I'm using LO Calc 6.0.4.2 x64 on Window$ 7 Enterprise SP1 x64.

Even when I create a new spreadsheet and regardless of whether the cell referenced by SEARCH is formatted to be text or a number, I always get the Wrong data type error.

In Untitled 2.ods L2 uses a RegEx version, L3 a wildcard version and L4 a normal version.