[Libreoffice-bugs] [Bug 150965] CALC sort by one column changes cell numbers in formulae not involved in the sort range
https://bugs.documentfoundation.org/show_bug.cgi?id=150965 --- Comment #3 from van.sny...@sbcglobal.net --- Thanks for the informative comment and correcting my ignorant mistake. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150965] CALC sort by one column changes cell numbers in formulae not involved in the sort range
https://bugs.documentfoundation.org/show_bug.cgi?id=150965 Rafael Lima changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150965] CALC sort by one column changes cell numbers in formulae not involved in the sort range
https://bugs.documentfoundation.org/show_bug.cgi?id=150965 Rafael Lima changed: What|Removed |Added CC||rafael.palma.l...@gmail.com --- Comment #2 from Rafael Lima --- Created attachment 182470 --> https://bugs.documentfoundation.org/attachment.cgi?id=182470=edit Fixed file Hi, the result you're getting is the expected result since you locked the cells incorrectly. You'll get the same result in Google Sheets or Excel with these formulas. To fix your spreadsheet, use the following formulas (I also attached the fixed file, which can be sorted by column G as expected) In column D use "=C4/$C$39*100" In column F use "=E4/$E$39*100" Tested with Version: 7.4.1.2 / LibreOffice Community Build ID: 40(Build:2) CPU threads: 16; OS: Linux 5.15; UI render: default; VCL: kf5 (cairo+xcb) Locale: pt-BR (pt_BR.UTF-8); UI: en-US Ubuntu package version: 1:7.4.1~rc2-0ubuntu0.22.04.1~lo1 Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150965] CALC sort by one column changes cell numbers in formulae not involved in the sort range
https://bugs.documentfoundation.org/show_bug.cgi?id=150965 --- Comment #1 from van.sny...@sbcglobal.net --- Created attachment 182454 --> https://bugs.documentfoundation.org/attachment.cgi?id=182454=edit Test case. Sort rows 4-23 on column G to demonstrate the problem described in the report. Examine the formulae in rows 4-23 of columns D and F before and after sorting. -- You are receiving this mail because: You are the assignee for the bug.