https://bugs.documentfoundation.org/show_bug.cgi?id=154217
Bug ID: 154217
Summary: Fields variables (user field and variable) cannot
format value for update as date (or similar)
Product: LibreOffice
Version: 7.4.5.1 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Writer
Assignee: [email protected]
Reporter: [email protected]
Fields >> Variables >> User Field, Set variable, Show Variable, and editing a
field or a variable by double click cannot handle formatting other than text or
numerical, causing a very confusing experience, especially for dates and
datetime.
Reproduction:
1. create a new variable with "Set variable", and set format to a date format
like "1999-01-01", and enter a date value, say, 2023-03-15.
2. Insert the variable, and close the dialog.
3. Double-click on the field: you will get value "42000"
I see that it's "number of dates since 1899-12-30", but that probably won't
help much in everyday use.
It seems user fields and variables remember their formatting, but the input
field ignores that when displaying. It is still possible to correctly update
the field with "2022-11-22", but it's not possible to view the actual value.
(As a sidenote: the manual about variables and user fields is pretty terse. It
even neglects to tell the difference between variables and user fields. I see
now but... possibly I shall create some diff there.)
--
You are receiving this mail because:
You are the assignee for the bug.
