https://bugs.documentfoundation.org/show_bug.cgi?id=145407
Bug ID: 145407
Summary: Some matrix operations do not seem to run correctly.
Maybe an already known problem, or did I mistype
something? Already resolved in later versions?
Product: LibreOffice
Version: 7.1.4.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
The example is quite self-explaining. Generate the following data set,
beginning at cell B4 (I'm sure it "works" everywhere):
Date
1 06.10.21 00:00
2 06.10.21 00:00
3 06.10.21 00:00
4 06.10.21 00:00
5 06.10.21 00:00
6 06.10.21 00:00
7 06.10.21 00:00
8 06.10.21 00:00
9 06.10.21 00:00
Enter then the same date into another cell (e.g. F5), and the following formula
(I run the German version of LibreOffice):
=SUMME( UND( MONAT(F5)=MONAT(C5:C13));TAG(F5)=TAG(C5:C13) )
The result is: 10
I had expected: 9
The formula should sum up the cells in which the month is "10" and the date is
"6". As you see, there are only 9 entries in the data block, all other cells
except the cell with the "check-date" and the formula are empty. Together with
the "check-date" the sum is 10, but this is not the expected result.
I'm using this type of formula to do some simple searches in rows, columns or
even matrixes. Runs fine in EXCEL.
Steps to Reproduce:
1. Fill the cells according description
2. Remember to make the formula a "matrix"
3.
Actual Results:
10
Expected Results:
9
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.1.4.2 / LibreOffice Community
Build ID: a529a4fab45b75fefc5b6226684193eb000654f6
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
