Created attachment 114882 [details] ScreenShot of function wizzard After chceck "Array" option and press "OK" it is immpossible to uncheck this box. Mayby it is not a bug...
On pc Debian x86-64 with master sources updated today or with LO Debian package 4.3.3, I don't reproduce this. On which env and which LO version do you use?
LO 4.0 - 4.4 on Windows XP, Windows 7
Thank you for your feedback. For the test, could you rename your LO directory profile (see https://wiki.documentfoundation.org/UserProfile#Windows) and give a new try? When you tell "4.4", do you mean 4.4.2 or a previous version? (4.4.0 or 4.4.1)
This bug has about 10 years and is inherited from OpenOffice. Attached screenshot file is from LO 4.4.2.2 on windows XP.
I just noticed I hadn't clicked on OK. I can reproduce this now. But I don't know if it's a bug or if it's on purpose. Since I don't have more questions, I put it back to UNCONFIRMED.
Let's call this a bug (if not a bug, then an enhancement - this UI could certainly be improved by allowing the array option to be removed) It has been this way since OOo 3.3.0 -> NEW -> Version: Inherited from OOo
Julien Nabet committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=bebc20c62be2df2cf2741fb82945ce6b631d2fe5 tdf#90695: In function Wizard Array box cannot be unchecked It will be available in 5.1.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Backport for 5.0 branch in review: https://gerrit.libreoffice.org/#/c/19598/
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=068178adf5de6ca667c0bcd2764519f6555d9d40 Revert "tdf#90695: In function Wizard Array box cannot be unchecked" It will be available in 5.1.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
This is not a bug. When editing an existing formula the checked but disabled Array button is meant as an indicator that the formula IS an array/matrix formula. Unchecking would result in the formula not being applied as array formula anymore, which it was before editing.
What with Ctrl+Shift+Enter - (it inserts brackets on both side of formula) it works, but I can't remove brackets after click only Enter.