[libreoffice-users] Re: Calc: Has anyone tested the backward-compatibility of LibreOffice 3.4?

Jack wrote:
> array formulas in LibO/OOo are a little tricky (little more so than in
> Excel).  If you've entered the formula correctly and pressed ENTER
> (instead of CTRL+SHIFT+ENTER), then obviously it does not work.  If you
> then select the cell/formula again and press CTRL+SHIFT+ENTER, then it
> *still* won't work, because it doesn't register that you've changed the
> formula (thus won't take the CTRL+SHIFT+ENTER).  You'll need to physically
> change the formula again and then press CTRL+SHIFT+ENTER (I usually type
> and erase a space).

I pasted your formula so there were no typing errors. Of course that
triggered the bug you have already found a workaround. Well done ;)
But that is definitely a BUG. I have reported it here
https://bugs.freedesktop.org/show_bug.cgi?id=38014
and I will use your explanation to provide further details. Thanks!

Even with the array working it's not detecting non-numeric cells properly.
Can you upload your spreadsheet somewhere so I can see what I'm doing wrong?

--
View this message in context: 
http://nabble.documentfoundation.org/Calc-Has-anyone-tested-the-backward-compatibility-of-LibreOffice-3-4-tp3022764p3033666.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