[Libreoffice-bugs] [Bug 108290] New: Add function which will insert fixed date

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: kruno.se at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170601/8e76cc49/attachment.html>