https://bugs.documentfoundation.org/show_bug.cgi?id=148747
Bug ID: 148747
Summary: Bad use of the date in formulas
Product: LibreOffice
Version: 7.2.6.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: vojtech.k...@wo.cz
Description:
If I use a date reference in the formula, for example using the CONCAT
function: CONCAT ("*"; A1; "*") where A1 = 04.2021 and the date in the document
is 10.04.2021, but the CALC displays it 10.4.2021, For the calculation using
the formula, 10.4.2021 is used, it is not possible to filter through CONCAT.
Older version of LibreOffice used original cell content for formulas not
displayed content.
The whole formula: =SUMIFS($'Výpis CZK'.$E:$E;$'Výpis
CZK'.$C:$C;CONCAT("*";$Výpočet.$G$5;"*");$'Výpis
CZK'.$A:$A;CONCAT("*";AT1;"*"))
Explanations for the formula:
Column $E:$E = Area for the sum
Column $C:$C = Area 1
Cell $G$5 = Criteria 1
Column $A:$A = Area 2
Cell AT1 = Criteria 2
The error is in version 7.2.6 and 7.3.2
The version 7.1.8 is OK (I installed it backwards after the above versions.)
Translated by Google.
Actual Results:
-
Expected Results:
-
Reproducible: Always
User Profile Reset: No
Additional Info:
Sorry, I install old version without error and I will not reinstall the error
version.
Version without error:
Version: 7.1.8.1 (x64) / LibreOffice Community
Build ID: e1f30c802c3269a1d052614453f260e49458c82c
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render:
Skia/Raster; VCL: win
Locale: cs-CZ (cs_CZ); UI: cs-CZ
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
