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 [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
