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
Created attachment 178226 [details] simple sample .ods
For the record: I did not experiment to ascertain whether the same anomaly was present if the two autofilter arrays were defined as discrete Database Ranges on the same sheet with MENU>Data>Define Range
(In reply to Colin from comment #0) > Description: > > The word count on Sheet2 will also demonstrate the replication failure > Ooops, my apologies, I removed that after writing the description.
Hello Colin, Thank you for reporting the bug. it seems you're using an old version of LibreOffice. Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version. I can't reproduce it in: Version: 7.2.6.2 (x64) / LibreOffice Community Build ID: b0ec3a565991f7569a5a7f5d24fed7f52653d754 CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win Locale: cs-CZ (cs_CZ); UI: en-US Calc: CL
(In reply to Martin Srdoš from comment #4) > Hello Colin, > > Thank you for reporting the bug. > it seems you're using an old version of LibreOffice. > Hi Martin I'm now using 7.2.7.2 and also noticed that my vlookup sort range parameter had inadvertently been left blank as opposed to zero. I now realise it was my mistake - less experience of the function at that stage :(. If you set it to resolved - not a bug then the kudos goes to you ;)
(In reply to Colin from comment #5) > (In reply to Martin Srdoš from comment #4) > > Hello Colin, > > > > Thank you for reporting the bug. > > it seems you're using an old version of LibreOffice. > > > Hi Martin > > I'm now using 7.2.7.2 and also noticed that my vlookup sort range parameter > had inadvertently been left blank as opposed to zero. > > I now realise it was my mistake - less experience of the function at that > stage :(. > > If you set it to resolved - not a bug then the kudos goes to you ;) Ok, everything is good :-)