https://bugs.freedesktop.org/show_bug.cgi?id=50902
Bug #: 50902
Summary: EDITING: Product Function Treats Empty Cells
Incorrectly
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.5.3 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 62829
--> https://bugs.freedesktop.org/attachment.cgi?id=62829
Steps to reproduce
Problem description:
Steps to reproduce:
1. =product(a1,b1)
2. where a1 is empty and
3. b1 contains 1
4. result is 1.
Current behavior:
Missing values (empty cells) seem to be treated as 1.
Expected behavior:
Missing values (empty cells) should be treated as zero, like sum.
Platform (if different from the browser):
Browser: Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:13.0) Gecko/20100101
Firefox/13.0
--
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
