[Libreoffice-bugs] [Bug 49071] New: Cell returns incorrect value upon file open when AutoCalculate is disabled

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=49071

             Bug #: 49071
           Summary: Cell returns incorrect value upon file open when
                    AutoCalculate is disabled
    Classification: Unclassified
           Product: LibreOffice
           Version: LibO 3.5.2 Release
          Platform: Other
        OS/Version: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: ahiroshige at ashisuto.co.jp


Verified with 3.4.5 and 3.5.2 on Windows 7.
The bug did not occur with OpenOffice 3.2.1 and 3.3.0.

Steps to reproduce:
1. Start new Calc.
2. Enter some formula to B1 e.g. =IF(A1="","",A1)
3. Disable AutoCalculate via Tools -> Cell Contents -> AutoCalculate
4. Save file and close.
5. Open the file again, and a zero value is returned to B1

This behaviour is not specifically for IF function but
with other functions as well such as VLOOKUP and so on.

Here are another cases.
A.) 
1. Enter VLOOKUP to B1 e.g. =VLOOKUP(A1,E1:F5,2,0)
2. If A1 is empty, B1 returns an error value.
3. Save and reload, again, a zero value is returned

B.)
1. Enter some formula to B1 (This time, the same IF formula used
   in the example)
2. Input some texts into A1
3. Press F9 to calculate
4. Save and open, the correct calculated results is shown key to
   calculate the result.

C.)
1. Enter some formula to B1 (This time, the same IF formula used
   in the example)
2. Input some text into A1
3. Press F9 to calculate
4. Delete the text in A1, save and close
5. Open the file, and the text that was in A1 is still shown in B1

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.