https://bugs.documentfoundation.org/show_bug.cgi?id=158062
Bug ID: 158062
Summary: CALC: changing cell format to date type does not fix
#WERT! issue in aligning cell
Product: LibreOffice
Version: unspecified
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: crptdng...@gmx.net
Description:
After correcting the format of a cell that until then contains a date in
unformatted text writing to correct date type the formular of an aligning cell
does not update its value from "#WERT!" to value expected by formula in this
cell (year of the cell).
Steps to Reproduce:
1.CALC: Create a rather large table to track monthly financial expenses. Table
contains 6 columns. Second column is "Jahr" which uses formula JAHR(#cell) to
extract calender year of aligning column 3 that is labelled "Datum"
2. In cell C4240 place a date string in unformatted format but indicating a
valid date. Cell format currently is NOT "date" type. Date string is "Mi., 01.
Nov 2023" which is a date string taken from another CALC sheet copied, just the
format is not copied, only text, so in principle this is an exact date
formatted string and should be recognized as a date formatted string.
3. In cell B4240 place formula "=JAHR(C4240)" to extract calender year from
column C date formatted cells.
4. Change cell format of C4240 to date (right mouseclick-> "Zellen formatieren"
-> Datum, use entry that fully matches the date string, -> "OK"
Actual Results:
3. Cell B4240 correctly shows "#WERT!" as cell C4240 is not formatted as a date
format. (OK)
4. BUG: Cell B4240 fails and still shows "#WERT!" (NOK)
Expected Results:
4. Cell B4240 should now show value 2023 as this is the year-part of the date
string in C4240.
Workaround: in cell C4240 type exactly the same date string again. Cell B4240
will then magically switch to 2023 as expected before.
Apparently the option to change cell format is totally useless as somehow the
overlying processes are somehow not notified that the format of a cell has
changed and a new format was applied to it. This only happens after tediously
manually entering the whole cell again by typing the exact string over again.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.5.8.2 (X86_64) / LibreOffice Community
Build ID: 50(Build:2)
CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.utf8); UI: de-DE
Debian package version: 4:7.5.8-1
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
