On Mon, Jun 6, 2011 at 3:40 PM, plino <[email protected]> wrote: > Hi Jack > > I couldn't make it work. In fact I just found out that array functions > don't > work in Lib (3.3 or 3.4) nor in OOo (3.4 beta) > > I don't know if it ever worked (I use it every now and then, so I couldn't > say if I used it before in OOo/LO) but if it did, someone broke it :) > > Another bug to fix for 3.5 :) > > -- > View this message in context: > http://nabble.documentfoundation.org/Calc-Has-anyone-tested-the-backward-compatibility-of-LibreOffice-3-4-tp3022764p3032323.html > Sent from the Users mailing list archive at Nabble.com. > > -- > Unsubscribe instructions: E-mail to [email protected] > In case of problems unsubscribing, write to > [email protected] > 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 > > From nvrk - Here's a crude attempt at efficiently finding non numerical entries in a long column of numbers. For each entry =if(isnumber(A1)<>1;Row();"") conditionally formatted in a bright color if desired. Single cell of =min(A1:Axxx)
-- Unsubscribe instructions: E-mail to [email protected] In case of problems unsubscribing, write to [email protected] 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
