https://bugs.documentfoundation.org/show_bug.cgi?id=151139
Bug ID: 151139
Summary: Frequency function calculation error - Incorrect date
format recognition - EDITING
Product: LibreOffice
Version: 7.4.1.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I don't know English - Googletranslate.
I am working on the Polish language version on Linux Ubuntu 20.04.
I was working on libreoffice 7.3.6 - there was a bug in Calc with the
frequency-stat function execution.
Today I installed the latest version of 7.4.1.
in this version the problem persists.
I think it comes from interpreting the date format.
I counted how many times in each month there was a transaction in the set.
I chose the function wizard,
I chose the frequency
I've marked the range of data (dates)
and marked the range of categories (dates)
results are shifted and incorrect
effect - the chart is also incorrect.
Steps to Reproduce:
1.I chose the function wizard,
I chose the frequency
I've marked the range of data (dates)
and marked the range of categories (dates)
results are shifted and incorrect
effect - the chart is also incorrect.
2.
3.
Actual Results:
results are shifted and incorrect
effect - the chart is also incorrect.
Expected Results:
no false
Reproducible: Sometimes
User Profile Reset: No
Additional Info:
Attached is the file with errors in the function frequency - date, month,
quarter.
possibly the function does not recognize the date format - correctly
please add the following date formats as original,
DD.MM.YYYY - date
MM.YYYY - month of the year
Q.YYYY - quarter of the year - 1q.2022
DD.MM.YYYY:HH.MM - date and time
--
You are receiving this mail because:
You are the assignee for the bug.
