https://bugs.documentfoundation.org/show_bug.cgi?id=145640
Bug ID: 145640
Summary: CALC Update references when sorting on an autofiltered
range of cells evaluates incorrectly
Product: LibreOffice
Version: 7.2.2.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
A cell outside an autofiltered array accumulating values on a line within the
array will fail when the array is sorted and the numerical data moves to a new
location.
HOWEVER, the cell references appear to be updated but the result is incorrect.
Simple .ods attached
Steps to Reproduce:
Ensure the CALC option "update reference when sorting range of cells" is
enabled.
With the attached sheet;
Observe the formula in L10 and the result.
I know it looks "odd". I was experimenting to assess what failures relate to
null cells with the alternate sum() syntax variations.
Sort Descending with any autofilter on Row 7
If you filter on G7 on the first attempt it will be necessary to refilter any
other row A-Z to reinstate the correct assessment
Focus L10
Observe the amended formula at L10
Observe the incorrect result of that formula
With L10 still focused, activate the fx button adjacent to the "address box"
Observe the correct identification and assessment of the formula
Left click the default button [OK]
Observe the value change at L10
Observe that L12 (a simple assignment of G10) is correctly evaluated throughout
Reversing the change with the tool button or CTRL+Z will revert to the error
Neither F9 nor SHFT+CTRL+F9 impact the result.
Actual Results:
Failure to correctly assess the formula
Expected Results:
Correct assessment of the formula
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
Version: 7.2.2.2 (x64) / LibreOffice Community
Build ID: 02b2acce88a210515b4a5bb2e46cbfb63fe97d56
CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: sv-SE (en_GB); UI: en-GB
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
