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.
Hello, Thank you for filing the bug. Please send us a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO', so please do change it back to 'UNCONFIRMED' once you have attached a document. (Please note that the attachment will be public, remove any sensitive information before attaching it.) How can I eliminate confidential data from a sample document? https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F Thank you
Created attachment 122705 [details] Example of the spreadsheet changing a value. Example of the cell (H2 in this case) changing. Just sort C as ascending.
Okay, I uploaded a spreadsheet
Sorted C as ascending from the filter. H2 was simply moved, but did not change to H#REF!. Win 7 Pro 64-bit, Version: 5.1.0.3 (x64) Build ID: 5e3e00a007d9b3b6efb6797a8b8e57b51ab1f737 CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; Locale: fi-FI (fi_FI) Version: 5.2.0.0.alpha0+ Build ID: a6f876d45bd4e41a7143594a6cb11b6893a0f620 CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; TinderBox: Win-x86@39, Branch:master, Time: 2016-02-11_00:07:38 Locale: fi-FI (fi_FI)
Created attachment 122729 [details] tools-Options Please look at this option
That seems to have fixed it. Thanks!
correct status