Bug 162505 - Changing from normal cell entry array formula (editing) without extra keystrokes fails
Summary: Changing from normal cell entry array formula (editing) without extra keystro...
Status: RESOLVED DUPLICATE of bug 38014
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.2.4.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-08-17 22:41 UTC by libreoffice
Modified: 2024-09-11 13:08 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description libreoffice 2024-08-17 22:41:03 UTC 
If you enter a formula in a cell, e.g.
  =MIN(IF((B14:B15) > 0, 3, 50))
and forget to use <ctrl><shift><enter> to make it an array formula,
you cannot fix it by editing the cell and typing <ctrl><shift><enter>

You must edit the text and change it in some manner before clicking <ctrl><shift><enter>.
I.e. click to put the cursor somewhere, delete a character, reenter the character you deleted, then type <ctrl><shift><enter>
Comment 1 m_a_riosv 2024-08-17 22:44:16 UTC 
Or simply add a space at the end.
Comment 2 Buovjaga 2024-09-11 13:08:25 UTC 

*** This bug has been marked as a duplicate of bug 38014 ***