https://bugs.documentfoundation.org/show_bug.cgi?id=147380
Bug ID: 147380
Summary: VLOOKUP() result within and acting upon another sorted
AUTOFILTER ARRAY does not update when the source is
amended
Product: LibreOffice
Version: 7.2.5.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When a named autofiltered array is accessed by VLOOKUP() from another
autofiltered array and that second array is then sorted and filtered then, any
changes made to the source cells are ignored in the sorted array until the sort
and filter are released.
Steps to Reproduce:
Within the attached Vlookup.ods sheet1
Observe the value of B9
Within the attached Vlookup.ods sheet2
Observe the value of B9 - It is NOT replicating the source
It will rectify itself when sheet2's autofilter is cleared and the full column
thus restored
NOTE: Both arrays are already filtered. Feel free to experiment with amending
the source contents and alternate permutations of sorted and filtered source
and destination arrays.
The word count on Sheet2 will also demonstrate the replication failure
Actual Results:
Replicated cell contents are not updated when a sort/select is in operation
Expected Results:
Replication should follow any autocalc event
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
Version: 7.2.5.2 (x64) / LibreOffice Community
Build ID: 499f9727c189e6ef3471021d6132d4c694f357e5
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.
