plino wrote:
>
> But as you said, I really don't want to browse 300.000 lines to spot
> errors ;)
>
Hi plino,
for your specific case I might have a possible workaround. The following
formula (place it in any cell) would give you the row number for the first
non-numeric value in the range A1:A3.
{= MIN(IF(ISNUMBER(A1:A3), "ALL GOOD", ROW(A1:A3)))}
Do not explicitly the curly braces, they appear automatically. It must be
entered as an array function, therefore press CTRL+SHIFT+ENTER to accept the
formula, not just ENTER.
Change the 2 references (A1:A3) to the cells you want to check. If you've
corrected the value (i.e. went to the row where the non-numeric value
appears and made it numeric) then it will refer to the next non-numeric row.
This way you can systematically address each issue (if there aren't too
many).
It's not a solution for the problem, just a workaround. Nevertheless, I
hope it helps.
Regards
Jack
--
View this message in context:
http://nabble.documentfoundation.org/Calc-Has-anyone-tested-the-backward-compatibility-of-LibreOffice-3-4-tp3022764p3029781.html
Sent from the Users mailing list archive at Nabble.com.
--
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted
