https://bugs.freedesktop.org/show_bug.cgi?id=74479
Priority: medium
Bug ID: 74479
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: CALC problem counting weekdays with sumproduct. Only
Saturdays are not counted correctly when the selection
contains empty cells or no date.
Severity: minor
Classification: Unclassified
OS: other
Reporter: fwiubqpbvuebeqpnex32nfi3vinkq...@lazyinbox.com
Hardware: Other
Status: UNCONFIRMED
Version: 4.2.0.4 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 93327
--> https://bugs.freedesktop.org/attachment.cgi?id=93327&action=edit
CALC problem counting weekdays with sumproduct. Only Saturdays are not counted
correctly when the selection contains empty cells.
CALC problem counting weekdays with sumproduct. Only Saturdays are not counted
correctly when the selection contains empty cells or no date.
It looks like only while counting Saturdays the number of empty cells in the
range (C=34-20=14) is added to the expected result (2). So we get 16 as wrong
result.
Version: 4.2.0.4
Build-ID: 05dceb5d363845f2cf968344d7adab8dcfb2ba71
Previous versions have this bug too running on windows 64-bit Windows 7.
--
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
