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.

Reply via email to