On Mon, Jun 6, 2011 at 3:40 PM, plino <pedlino@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+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 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+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