[Libreoffice-bugs] [Bug 131020] Set Default Year for data entry with options

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Tue May 12 12:29:37 UTC 2020


https://bugs.documentfoundation.org/show_bug.cgi?id=131020

--- Comment #9 from Eike Rathke <erack at redhat.com> ---
If you don't need to calculate with a date then preceding an incomplete input
with an ' apostrophe would force the input to text content, like
'13/5
(or en-US)
'5/13
Assigning a number format of
@"/19"
then would display that as
13/5/19
or
5/13/19

If you pre-format the cells with such text format
@"/19"
before input then you don't even need to (and must not) input the leading '
apostrophe.

As said, this works only if you don't need to calculate with such "date".

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200512/b52789ea/attachment-0001.htm>


More information about the Libreoffice-bugs mailing list