https://bugs.documentfoundation.org/show_bug.cgi?id=138896
Bug ID: 138896
Summary: AutoFilter sort reference not updated with nested IF
statement
Product: LibreOffice
Version: 7.0.3.1 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
If a cell contains nested IF statement and the cell is part of an array of
AUTO-FILTERED cells, then reversing the sort from Ascending to Descending only
updates the cell reference for the first IF statement.
The parameter is set to [SORT] in Tools> Options> LO Calc> General
Steps to Reproduce:
Spreadsheet Attached. Future dates have been filtered out in Column C. These
are "exposed" as the process ages. The sheet is only sorted - Ascending - when
extra processing weeks are added. It is normally utilised with the current date
as the primary focus. No difference is observed if the column & row freeze is
inactivated.
The formula simply tests for the current event and displays the intermediate
change at that location only. Well, that's what it does when the auto-filter
sorting is ascending order.
Note the cell references in Cell M10
=IF(J10="";"";IF(J11="";SUM(J7:J10);""))
Note the cell references and result in Cell M434
=IF(J434="";"";IF(J435="";SUM(J431:J434);""))
Sort Descending on Column Filter B
Note the cell references and result in Cell M56 (The last pertinent cell)
=IF(J56="";"";IF(J55="";SUM(J431:J434);""))
It may well be that you professionals have a better formula or knowledge of an
intrinsic CALC function that doesn't put a spanner in the works but I wouldn't
expect this fairly simplistic effort to cause an error.
Actual Results:
Reference and result corrupted
Expected Results:
No corruption
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
Version: 7.0.3.1 (x64)
Build ID: d7547858d014d4cf69878db179d326fc3483e082
CPU threads: 4; OS: Windows 10.0 Build 19042; 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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
