[Libreoffice-bugs] [Bug 147380] VLOOKUP() result within and acting upon another sorted AUTOFILTER ARRAY does not update when the source is amended
https://bugs.documentfoundation.org/show_bug.cgi?id=147380 QA Administrators changed: What|Removed |Added Whiteboard| QA:needsComment| -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147380] VLOOKUP() result within and acting upon another sorted AUTOFILTER ARRAY does not update when the source is amended
https://bugs.documentfoundation.org/show_bug.cgi?id=147380 Martin Srdoš changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |WORKSFORME --- Comment #6 from Martin Srdoš --- (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 :-) -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147380] VLOOKUP() result within and acting upon another sorted AUTOFILTER ARRAY does not update when the source is amended
https://bugs.documentfoundation.org/show_bug.cgi?id=147380 Colin changed: What|Removed |Added Ever confirmed|1 |0 Status|NEEDINFO|UNCONFIRMED --- Comment #5 from Colin --- (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 ;) -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147380] VLOOKUP() result within and acting upon another sorted AUTOFILTER ARRAY does not update when the source is amended
https://bugs.documentfoundation.org/show_bug.cgi?id=147380 Martin Srdoš changed: What|Removed |Added Ever confirmed|0 |1 CC||srd...@email.cz Status|UNCONFIRMED |NEEDINFO --- Comment #4 from Martin Srdoš --- 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 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147380] VLOOKUP() result within and acting upon another sorted AUTOFILTER ARRAY does not update when the source is amended
https://bugs.documentfoundation.org/show_bug.cgi?id=147380 QA Administrators changed: What|Removed |Added Whiteboard|| QA:needsComment -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147380] VLOOKUP() result within and acting upon another sorted AUTOFILTER ARRAY does not update when the source is amended
https://bugs.documentfoundation.org/show_bug.cgi?id=147380 --- Comment #3 from Colin --- (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. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147380] VLOOKUP() result within and acting upon another sorted AUTOFILTER ARRAY does not update when the source is amended
https://bugs.documentfoundation.org/show_bug.cgi?id=147380 --- Comment #2 from Colin --- 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 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147380] VLOOKUP() result within and acting upon another sorted AUTOFILTER ARRAY does not update when the source is amended
https://bugs.documentfoundation.org/show_bug.cgi?id=147380 --- Comment #1 from Colin --- Created attachment 178226 --> https://bugs.documentfoundation.org/attachment.cgi?id=178226=edit simple sample .ods -- You are receiving this mail because: You are the assignee for the bug.