Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index



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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.