https://bugs.freedesktop.org/show_bug.cgi?id=54974
Bug #: 54974
Summary: : calculation based on a field containing a formula
with result "" produces an error
Classification: Unclassified
Product: LibreOffice
Version: 3.6.0.4 release
Platform: Other
OS/Version: All
Status: UNCONFIRMED
Status Whiteboard: BSA
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
Created attachment 67212
--> https://bugs.freedesktop.org/attachment.cgi?id=67212
a document showing the problem
Problem description:
Having a cell containing a formula, which produces "" (an empty string), and
another cell doing a calculation based on that cell, results in an error.
Earlier versions of LibreOffice resulted in 0 here.
Steps to reproduce:
1. create a new spreadsheet document
2. in cell B1, enter '=IF(ISBLANK(A1);"";A1)'
3. in cell C1, enter '=B1*3'
Current behavior:
the content of cell C1 reads '#VALUE!'
Expected behavior:
the content of cell C1 is 0
Platform (if different from the browser):
Browser: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:15.0) Gecko/20100101
Firefox/15.0.1
--
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
