https://bugs.documentfoundation.org/show_bug.cgi?id=151164
Bug ID: 151164
Summary: [Bug 151139] 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:
Hello,
In my Polish language version, this is the date format,
it is only misinterpreted.
I also changed the date format to ISO yyyy-mm-dd
it is not text or any other number - just a date - the number format dialog;
there is no apostrophe before the date in the formula bar
result: incorrect frequency calculation in date ranges -
see the chart - false, true;
For you it shows the text because you open the program with different regional
settings, not for me.
By the way, please add the date format:
DD.MM.YYYY: HH.MM
Q.YYYY - Q1.2022 - for quarterly statistics
MM.YYYY - for monthly statistics
WW.YYYY - for weekly statistics
Please see screenshot.
Pozdrawiam
Wiesław Dziecielski
kom.: +48 502 841 622
W dniu 23.09.2022 o 17:49, [email protected] pisze:
> m.a.riosv <mailto:[email protected]> changed bug 151139
> <https://bugs.documentfoundation.org/show_bug.cgi?id=151139>
> What Removed Added
> Resolution --- NOTABUG
> CC [email protected]
> Status UNCONFIRMED RESOLVED
>
> *Comment # 2 <https://bugs.documentfoundation.org/show_bug.cgi?id=151139#c2>
> on bug 151139 <https://bugs.documentfoundation.org/show_bug.cgi?id=151139>
> from m.a.riosv <mailto:[email protected]> *
>
> I don't find any bug.
>
> In 'tabela częstości.A20:a34' the mm.yyyy are strings, not dates, that can't
> be
> recognizer like dates. You can see it, if you try to change the cell format,
> it doesn't change, again because it is not a true spreadsheet date. The same
> happen with other supposed dates.
> You need to work with true dates, or to create auxiliary columns to use with
> the frequency function.
>
> On the other side, please read carefully the help
> file:///C:/Program%20Files/LibreOffice/help/en-US/text/scalc/01/04060107.html?DbPAR=CALC#bm_id3159084
> on how tu use the function.
> Before 01/05/21, there are no values on 'transakcje podobne.A1:A32' (the lower
> 26/05/2021), calculating with dd/mm/yyyy date. So only one between 01/05/2021
> and 01/06/2021.
Actual Results:
no bug
Expected Results:
no bug
Reproducible: Always
User Profile Reset: No
Additional Info:
no bug
--
You are receiving this mail because:
You are the assignee for the bug.
