https://bugs.freedesktop.org/show_bug.cgi?id=74893
Priority: medium Bug ID: 74893 Assignee: libreoffice-bugs@lists.freedesktop.org Summary: Other: array ctrl+shift+enter only seems to work on new functions not existing Severity: normal Classification: Unclassified OS: Linux (All) Reporter: afo...@gmail.com Hardware: Other Whiteboard: BSA Status: UNCONFIRMED Version: 4.2.0.4 release Component: Spreadsheet Product: LibreOffice Created attachment 93940 --> https://bugs.freedesktop.org/attachment.cgi?id=93940&action=edit the example workbook referred to in the long description of this bug Problem description: if I have an existing function and I hit f2 to edit then ctrl+shift+enter to turn it into an array function, it does not work. However, If I enter in the function for the first time in a new cell (and while I am still in that cell from typing the function) then ctrl+shift+enter turns the function into an array. Steps to reproduce: 1. open the attached spreadsheet 2. hit f2 on C7 then hit ctrl+shift+enter 3. notice the function does not turn into an array 4. now in cell C8 hit f2 and paste in =SUM(A1:A4*B1:B4) then hit ctrl+shift+enter 5. you will now see C8 is an array function Current behavior: ctrl+shift+enter only works on just entered formulas Expected behavior: ctrl+shift_enter should work on a formula that is already entered and you are now turning it into an array. Note: I know the example in the attached workbook could be resolved using sumproduct(), however the real example I have is a bit more complex, so I chose a simpler example that could still illustrate the point/issue. docs: https://help.libreoffice.org/Calc/Array_Functions Operating System: Linux (Other) Version: 4.2.0.4 release -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs