Bug 61662 - EDITING: No immediate VLOOKUP recalc
Summary: EDITING: No immediate VLOOKUP recalc
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other All
: medium normal
Assignee: Not Assigned
Whiteboard: BSA
Depends on:
Reported: 2013-03-01 13:22 UTC by Mike
Modified: 2017-03-25 19:04 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

sample doc (131.64 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-03-01 13:22 UTC, Mike

Note You need to log in before you can comment on or make changes to this bug.
Description Mike 2013-03-01 13:22:15 UTC
Created attachment 75737 [details]
sample doc

See attached doc.
If you change values in J1 or J2, then result in J5 won't be recalculated after change.
However, if value will be changed twice, recalc do occurs.
Operating System: Windows 7
Version: release
Comment 1 Joel Madero 2013-03-18 23:04:24 UTC
Cannot confirm on Bodhi Linux 2.2, Version release

If it exists it's Windows only, will try to find someone to test
Comment 2 Thomas van der Meulen [retired] 2013-03-19 10:07:56 UTC
Can't reproduce running LibreOffice on mac osx 10.6.8.

@ joel I wil try on Windows 7 wenn I am am home.
Comment 3 Mike 2013-03-19 10:11:11 UTC
My LO build ID is: 7545bee9c2a0782548772a21bc84a9dcc583b89
Comment 4 Thomas van der Meulen [retired] 2013-03-19 10:18:36 UTC
Can reproduce running LibreOffice on mac osx 10.6.8.
first I worked fine but wen I made a new user profile and I edit J2 then it didn't recaculated. but on the secont edit it did recalc.
Comment 5 ign_christian 2013-05-13 03:50:33 UTC
reproducible on LO (Win7 Home Premium 32bit)

inconsistent result on cell J5 when changing cell J2 
-> changing value on J2 to another value than back to value '2' will give different result on J5
Comment 6 Mike 2014-12-09 09:11:34 UTC
Reproducible on LO, Ubuntu 14.04 x64 with LibreOffice PPA.

1. open the sample doc
2. change value in J4 - recalc OK
3. change value in J2 - NO recalc!
4. change value in J2 again, with same data - recalc OK
Comment 7 Joel Madero 2014-12-11 04:41:59 UTC
Hey Mike - 

In the future please don't add your own bugs to the MAB tracker. Even experienced QA people don't add their own bugs. If you're convinced it should go on the list - please poke the QA mailing list and ask for an independent party to look at it.

Removing from MAB list as it's not clear why it belongs there and it was nominated by the reporter.

Mike - feel free to email the QA list for a 2nd opinion. Getting it on the MAB list will not necessarily get it fixed any faster - it actually can slow it down if a developer is convinced that it was placed their inappropriately.

Thanks for your understanding :)
Comment 8 QA Administrators 2015-12-20 16:07:11 UTC Comment hidden (obsolete)
Comment 9 Mike 2015-12-29 07:39:13 UTC
Re-tested with LO (Build ID: 1:5.0.4~rc2-0ubuntu1~trusty1).
Bug still exists.

An addition: on second value change resulting cell J5 shows PREVIOUS calculated value.
Comment 10 QA Administrators 2017-01-03 19:55:05 UTC Comment hidden (obsolete)
Comment 11 Mike 2017-01-05 19:04:00 UTC
Cannot reproduce this bug with:
Version: (from Ubuntu PPA)
or with
Version: (vanilla).
Comment 12 Buovjaga 2017-03-25 19:04:24 UTC
(In reply to Mike from comment #11)
> Cannot reproduce this bug with:
> Version: (from Ubuntu PPA)
> or with
> Version: (vanilla).

Great, let's close.