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+help@libreoffice.org In case of problems unsubscribing, write to postmaster@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