https://bugs.documentfoundation.org/show_bug.cgi?id=153790
Bug ID: 153790
Summary: Range in cell formula referring to another sheet gets
expanded using sheet name twice
Product: LibreOffice
Version: 7.5.0.3 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Consider a cell formula that refers to a range on another sheet:
E.g.
=INDEX($Sheet1.B:B,MATCH(A1,$Sheet1.A:A,0))
If I work with the workbook for a while it changes the formula to:
=INDEX($Sheet1.B:$Sheet1.B,MATCH(A1,$Sheet1.A:$Sheet1.A,0))
I'm not sure at what point it starts doing this and what actions of mine led up
to it but it always happens and is very annoying as it makes formulas
unnecessarily long and unreadable.
If I close the workbook and re-open it it's back to the normal short form.
--
You are receiving this mail because:
You are the assignee for the bug.
