https://bugs.documentfoundation.org/show_bug.cgi?id=145103
m.a.riosv <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO CC| |[email protected] | |rg --- Comment #1 from m.a.riosv <[email protected]> --- A1 it's empty so "1:"&LEN(A1) gives 1:0 what it's not a correct address with D25 instead A1 ISNUMBER(SUMPRODUCT(SEARCH(MID(D25;ROW(INDIRECT("1:"&LEN(D25)));1);"0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ"))) I think it works. -- You are receiving this mail because: You are the assignee for the bug.
