https://bugs.documentfoundation.org/show_bug.cgi?id=145103
--- Comment #2 from [email protected] --- (In reply to m.a.riosv from comment #1) > 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. I confirm changing that did work, as no "invalid values." will pop up. So it appears that this is a wrong formula provided by the sheet maker (Amazon), I'll give this feedback to Amazon. However, the "Re-type Password" window still pops up, though. -- You are receiving this mail because: You are the assignee for the bug.
