[Libreoffice-bugs] [Bug 74479] CALC problem counting weekdays with sumproduct. Only Saturdays are not counted correctly when the selection contains empty cells or no date. SUMPRODUCT() result error wi

https://bugs.freedesktop.org/show_bug.cgi?id=74479 Kohei Yoshida libreoff...@kohei.us changed: What|Removed |Added CC||karloofo...@arcor.de

[Libreoffice-bugs] [Bug 74479] CALC problem counting weekdays with sumproduct. Only Saturdays are not counted correctly when the selection contains empty cells or no date. SUMPRODUCT() result error wi

https://bugs.freedesktop.org/show_bug.cgi?id=74479 --- Comment #10 from Kohei Yoshida libreoff...@kohei.us --- (In reply to comment #8) Created attachment 93686 [details] File sample with SUMPRODUCT() error. I hope a more clear sample. mariosv, there is something wrong with your attachment,

[Libreoffice-bugs] [Bug 74479] CALC problem counting weekdays with sumproduct. Only Saturdays are not counted correctly when the selection contains empty cells or no date. SUMPRODUCT() result error wi

https://bugs.freedesktop.org/show_bug.cgi?id=74479 Kohei Yoshida libreoff...@kohei.us changed: What|Removed |Added Status|NEW |ASSIGNED

[Libreoffice-bugs] [Bug 74479] CALC problem counting weekdays with sumproduct. Only Saturdays are not counted correctly when the selection contains empty cells or no date.

https://bugs.freedesktop.org/show_bug.cgi?id=74479 mariosv mari...@miguelangel.mobi changed: What|Removed |Added Status|NEEDINFO|NEW --- Comment #4

[Libreoffice-bugs] [Bug 74479] CALC problem counting weekdays with sumproduct. Only Saturdays are not counted correctly when the selection contains empty cells or no date. SUMPRODUCT() result error wi

https://bugs.freedesktop.org/show_bug.cgi?id=74479 mariosv mari...@miguelangel.mobi changed: What|Removed |Added Summary|CALC problem counting |CALC problem counting

[Libreoffice-bugs] [Bug 74479] CALC problem counting weekdays with sumproduct. Only Saturdays are not counted correctly when the selection contains empty cells or no date. SUMPRODUCT() result error wi

https://bugs.freedesktop.org/show_bug.cgi?id=74479 --- Comment #5 from mariosv mari...@miguelangel.mobi --- Created attachment 93683 -- https://bugs.freedesktop.org/attachment.cgi?id=93683action=edit Simple file with SUMPRODUCT() error. A simple file where to verify the issue. -- You are

[Libreoffice-bugs] [Bug 74479] CALC problem counting weekdays with sumproduct. Only Saturdays are not counted correctly when the selection contains empty cells or no date. SUMPRODUCT() result error wi

https://bugs.freedesktop.org/show_bug.cgi?id=74479 --- Comment #6 from mariosv mari...@miguelangel.mobi --- Created attachment 93685 -- https://bugs.freedesktop.org/attachment.cgi?id=93685action=edit Simple file with SUMPRODUCT() error. The issue is not only with a function in the last

[Libreoffice-bugs] [Bug 74479] CALC problem counting weekdays with sumproduct. Only Saturdays are not counted correctly when the selection contains empty cells or no date. SUMPRODUCT() result error wi

https://bugs.freedesktop.org/show_bug.cgi?id=74479 mariosv mari...@miguelangel.mobi changed: What|Removed |Added CC|

[Libreoffice-bugs] [Bug 74479] CALC problem counting weekdays with sumproduct. Only Saturdays are not counted correctly when the selection contains empty cells or no date. SUMPRODUCT() result error wi

https://bugs.freedesktop.org/show_bug.cgi?id=74479 mariosv mari...@miguelangel.mobi changed: What|Removed |Added Keywords||regression -- You

[Libreoffice-bugs] [Bug 74479] CALC problem counting weekdays with sumproduct. Only Saturdays are not counted correctly when the selection contains empty cells or no date. SUMPRODUCT() result error wi

https://bugs.freedesktop.org/show_bug.cgi?id=74479 mariosv mari...@miguelangel.mobi changed: What|Removed |Added Blocks||65675 -- You are

[Libreoffice-bugs] [Bug 74479] CALC problem counting weekdays with sumproduct. Only Saturdays are not counted correctly when the selection contains empty cells or no date. SUMPRODUCT() result error wi

https://bugs.freedesktop.org/show_bug.cgi?id=74479 mariosv mari...@miguelangel.mobi changed: What|Removed |Added Attachment #93683|0 |1 is obsolete|

[Libreoffice-bugs] [Bug 74479] CALC problem counting weekdays with sumproduct. Only Saturdays are not counted correctly when the selection contains empty cells or no date.

https://bugs.freedesktop.org/show_bug.cgi?id=74479 karolus karloofo...@arcor.de changed: What|Removed |Added Attachment #93327|text/plain |application/octet-stream

[Libreoffice-bugs] [Bug 74479] CALC problem counting weekdays with sumproduct. Only Saturdays are not counted correctly when the selection contains empty cells or no date.

https://bugs.freedesktop.org/show_bug.cgi?id=74479 --- Comment #2 from fwiubqpbvuebeqpnex32nfi3vinkq...@lazyinbox.com --- (In reply to comment #1) Hi @fwiubqpbvuebeqpnEX32nfi3vinkqjfG, thanks for reporting. =WEEKDAY(0;2) = 6 = Saturday Date for 0 is 30/12/1899 = Saturday same result with an

[Libreoffice-bugs] [Bug 74479] CALC problem counting weekdays with sumproduct. Only Saturdays are not counted correctly when the selection contains empty cells or no date.

https://bugs.freedesktop.org/show_bug.cgi?id=74479 --- Comment #3 from mariosv mari...@miguelangel.mobi --- Please read again my first comment. With an empty cell the result for WEEKDAY(emptycell;2) is always Saturday, an empty cell is zero for WEEKDAY(), you need verify it is not an empty cell

[Libreoffice-bugs] [Bug 74479] CALC problem counting weekdays with sumproduct. Only Saturdays are not counted correctly when the selection contains empty cells or no date.

https://bugs.freedesktop.org/show_bug.cgi?id=74479 mariosv mari...@miguelangel.mobi changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO