https://bugs.documentfoundation.org/show_bug.cgi?id=150965
Rafael Lima <rafael.palma.l...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |rafael.palma.l...@gmail.com
--- Comment #2 from Rafael Lima <rafael.palma.l...@gmail.com> ---
Created attachment 182470
--> https://bugs.documentfoundation.org/attachment.cgi?id=182470&action=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.
