Issue 123447 - Cell does not automatically recalculate possibly because it uses vliookup
Summary: Cell does not automatically recalculate possibly because it uses vliookup
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 4.0.1
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-10-09 05:37 UTC by openoffice
Modified: 2013-10-11 10:13 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
spreadsheet which exhibits the error (314.48 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-10-09 05:39 UTC, openoffice 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description openoffice 2013-10-09 05:37:54 UTC 

    


    


      



        
          Comment 1
        

        
          openoffice

        

        
        

        
          2013-10-09 05:39:38 UTC
        

      






Created attachment 81732 [details]
spreadsheet which exhibits the error

    


    


      



        
          Comment 2
        

        
          openoffice

        

        
        

        
          2013-10-09 05:51:43 UTC
        

      






The 3 important cells are on the Prediction tab and are highlighted in red.
Note that cells Q3 and Q7 have identical formulas.
Make sure that automatic recalculation is on.
Change the value of cell B7 from 4.0 to another value, e.g. 5.0
Note the value of Cell Q7 changes to 6.4 but the value of cell Q3 remains unchanged with a value of 5.6. This is the symptom of the bug.
Force all cells to recalculate by typing ctrl-alt-F9.
Note that cell Q3 now gets updated to 6.4.
That is the problem in a nutshell. Cell Q3 does not automatically get recalculated.

Other information about the problem.
If you hit ctrl-z (undo) after forcing the recalculation, cell Q7 will not be recalculated.

If you clear the formula from cell Q3, then Cell Q7 will no longer update when cell B7 is changed.

Note that changing cell B3 changes the table used in the vlookup's in cells Q3 and Q7. I suspect this is related to the problem but have no strong evidence of that.

    


    


      



        
          Comment 3
        

        
          Martin Motschmann

        

        
        

        
          2013-10-09 14:22:49 UTC
        

      






I can confirm this!

    


    


      



        
          Comment 4
        

        
          Edwin Sharp

        

        
        

        
          2013-10-11 10:13:55 UTC
        

      






As given in description.

AOO401m5(Build:9714)  -  Rev. 1523756
2013-09-16 20:50:21 (Mo, 16 Sep 2013)
Win 7