When running a formula that applies to an array of cells, pressing Ctrl+Shift+Enter doesn't shift to array mode (which is visible because the formula is enclosed in {} brackets) I tested this under LibreOffice 3.3.3 OOO330m19 (Build:301) tag libreoffice-3.3.3.1 LibO-dev 3.4.0 OOO340m1 (Build:1) and OOo 3.4 Beta (I just noticed you can't copy the version from the About box in Ooo...) with the same results.
Can you please give an example? I tried it as the help says: Select a range of 3 x 3 cells on another part of the spreadsheet, enter the formula =10*A1:C3 and confirm this entry using the key combination Ctrl+Shift+Enter. The result is a 3 x 3 array in which the individual values in the cell range (A1:C3) are multiplied by a factor of 10. And it worked.
(In reply to comment #1) > Can you please give an example? I tried it as the help says: > > Select a range of 3 x 3 cells on another part of the spreadsheet, enter the > formula =10*A1:C3 and confirm this entry using the key combination > Ctrl+Shift+Enter. The result is a 3 x 3 array in which the individual values in > the cell range (A1:C3) are multiplied by a factor of 10. > > And it worked. I think there is some confusion/misunderstanding. What I believe pedlino is referring to is the behaviour that when a formula has *aleady* been entered with the ENTER key, selecting the formula again and then attempting to enter it as an array formula with CTRL+SHIFT+ENTER does not change it to a formula array. I believe this is in response to: http://nabble.documentfoundation.org/Calc-Has-anyone-tested-the-backward-compatibility-of-LibreOffice-3-4-tp3022764p3033637.html
Thanks, Stephan. That is exactly the problem. This is the contents of the workaround found by user "Jack" (just in case the linked post disappears or is moved) "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)." It shouldn't be required to use tricks to use this function ;)
The same on Linux (Suse 11.3)
[This is an automated message.] This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it started right out as NEW without ever being explicitly confirmed. The bug is changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases. Details on how to test the 3.5.0 beta1 can be found at: http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1 more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
needinfo keyword redundant by needinfo status.
Still occurs under 3.5.0 Beta2. Changed to New
Still occurs under 3.6.2.2
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.