Bug 77995

Summary: Other: Enlarging array formula does not apply unless formula is edited.
Product: LibreOffice Reporter: alha02
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED NOTABUG    
Severity: normal CC: miguelangelrv
Priority: medium    
Version: 4.2.3.3 release   
Hardware: Other   
OS: macOS (All)   
Whiteboard: BSA
Crash report or crash signature: Regression By:

Description alha02 2014-04-27 12:24:04 UTC 
Problem description: 

When enlarging the array size of an array formula (or trying to convert a regular formula into an array formula), no array is created unless the formula is edited. 

Steps to reproduce:
1. Mark a few cells in Calc.
2. Press F2.
3. Enter "=munit(4)".
4. Mark a set of cells which covers the previously marked cells, starting from the cell where you entered the formula.
5. Press F2.
6. Press cmd+shift+enter to see that nothing happens.
7. Do steps 1 to 5 again.
8. Press backspace and then retype ).
9. Press cmd+shift+enter to see that the array is now larger.

Current behavior:

Marking a set of cells which covers an existing array or formula, pressing F2 followed by cmd+shift+enter, does not enlarge the array. Nothing happens instead. For the enlargement to have effect, I have to edit the formula by for example removing the trailing ")" and retyping it again.

Expected behavior:

Marking a set of cells which covers an existing array or formula, pressing F2 followed by cmd+shift+enter, was expected to enlarge the array without having to edit the formula.
Operating System: Mac OS X
Version: 4.2.3.3 release
Comment 1 m_a_riosv 2014-05-03 09:06:11 UTC 
Hi Alha, thanks for reporting.

I think edit is the key, if you don't change anything in the formula, it is not edited, an easy way is add a space after [F2] to avoid touch the formula.

I don't think it is a bug. Please take a look to https://help.libreoffice.org/Calc/Array_Functions#Editing_Array_Formulas

Maybe it's a good request for enhancement, if [Crtl+Shift+Enter] was detected as formula edit if it was not already an array.
Comment 2 QA Administrators 2015-01-10 18:06:21 UTC 
Dear Bug Submitter,

This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INVALID due to lack of needed information.

For more information about our NEEDINFO policy please read the wiki located here: 
https://wiki.documentfoundation.org/QA/FDO/NEEDINFO

If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed.


Thank you for helping us make LibreOffice even better for everyone!


Warm Regards,
QA Team

Message generated on: 10/01/2015