On Mon, Jun 6, 2011 at 3:40 PM, plino <pedl...@gmail.com> 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 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 > > 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 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