https://bugs.documentfoundation.org/show_bug.cgi?id=161642
Bug ID: 161642
Summary: output range of SORT function does not expand when
source range becomes larger
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 194808
--> https://bugs.documentfoundation.org/attachment.cgi?id=194808&action=edit
SORT function on database range
If the SORT function is based on a database range and the content of the
database range becomes larger, then the output range of the SORT function does
not expand to the new size of the source range.
Recalculate Hard does not expands the output range of the SORT function. There
is even no adaption, when the file is saved and reloaded.
How to reproduce:
Open attached file. It has formula SORT(Members_data;2) and
Members_data=$Sheet1.$A$2:$B$10.
Insert an entry in the green area between row 5 and 6 e.g. "Tim Hof". Verify in
Data > Define Range, that it is now Members_data=$Sheet1.$A$2:$B$11.
The new entry is visible in the output of the SORT function, but the output
range does not expand, so the entry "Eva Waldeck" is no longer visible.
Save and reload the file. The output range is still wrong although the formula
is {=SORT(Members_data;2)} and Members_data=$Sheet1.$A$2:$B$11
--
You are receiving this mail because:
You are the assignee for the bug.
