https://bugs.documentfoundation.org/show_bug.cgi?id=108290
Bug ID: 108290
Summary: Add function which will insert fixed date
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: kruno...@gmx.com
It will be very useful if there was a function which would insert fixed date.
Functions NOW() and TODAY() are changed every time spreadsheet is updated but
there are times when user want to insert fixed date. Example (in cell B1):
=IF(NOT(ISBLANK(A1)); FIXEDDATE(); "")
Let's say you want to add some invoice amount do a spredsheet, FIXEDDATE()
function could automatically populate cell with today's date in B1 when amount
is entered in A1.
People have been asking for this feature:
OOo: https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=82400
Google Sheets: https://productforums.google.com/forum/#!topic/docs/AD3EsxZVhG8
But only solutions are scripts and macros and very few users can effectively
use them. It would be more convenient if this feature were available as a
(plain) function.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs