https://bugs.documentfoundation.org/show_bug.cgi?id=174436
Bug ID: 174436
Summary: EDITING: Array formula range shrinks spontaneously
after confirming Manage Named Ranges dialog
Product: LibreOffice
Version: 26.8.1.1 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 209641
--> https://bugs.documentfoundation.org/attachment.cgi?id=209641&action=edit
An example of the described behavior. There is an instruction in the file.
Steps to reproduce:
1. Create an array with a named range as formula argument. The array must be
larger as the named range.
2. There will be results in the array corresponding the named range size and
#NA in the remaining cells.
3. Check the array size with ctrl-/
4. Edit some random unrelated named range and press OK.
5. Check the array size above with ctrl-/ again. All #NA cells remain outside
the array.
Other observations:
1. The cell formulas remaining outside the array continue to be array formulas.
2. The cell formulas remaining outside continue to work properly (?) and react
e.g. to changes in the argument named range size.
3. Even though they look like array formulas the remaining outside formulas are
no more protected and can be edited separately.
4. For this phenomenon to occur, not even editing within the Manage Named
Ranges dialog is necessary. It is sufficient, for example, to add a character
to a name and immediately remove it before clicking OK.
--
You are receiving this mail because:
You are the assignee for the bug.