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: libreoffice-bugs@lists.freedesktop.org ReportedBy: frank.schoenh...@gmx.de 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 Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs