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: [email protected]
ReportedBy: [email protected]
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.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
