https://bugs.documentfoundation.org/show_bug.cgi?id=163808
Bug ID: 163808
Summary: Featurerequest: TRIMRANGE and accompanying trim
references
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
MS Office is now capable of trimming ranges with a simple dot before and/or
after the colon.
https://techcommunity.microsoft.com/blog/excelblog/announcing-trimrange-and-accompanying-trim-references/4230202
Steps to Reproduce:
Create complex formula that extends and without calculating all empty fields
all the time
Actual Results:
=XLOOKUP(lookup_start:INDEX(index_array;COUNTA(index_array));lookup_array;return_array)
Expected Results:
Without dot operator:
=XLOOKUP(TRIMRANGE(lookup_start:lookup_end; 2);lookup_array;return_array)
With dot operator:
=XLOOKUP(lookup_start:.lookup_end;lookup_array;return_array)
Reproducible: Always
User Profile Reset: No
Additional Info:
Needed to stay MS Office compatible in the future and improve handling large
data sheets
--
You are receiving this mail because:
You are the assignee for the bug.
