https://bugs.documentfoundation.org/show_bug.cgi?id=97913
Bug ID: 97913
Summary: Filtering changes my formulas
Product: LibreOffice
Version: 5.1.0.3 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
On my spreadsheet I have a formula that uses various cells from the same row
(L, K) and a specific cell on a different row (Q2)
When I filter my data and reorganize it, it changes the Q cell to a different
one or simply changes it to Q#REF!
I've extended the Q2 value all the way through Q but this hasn't helped at all.
I found a fix by adding the Q column to the filter, however this hasn't fixed
the issue of the Q2 cell in my formula changing to a different Q cell.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
