<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Add function which will insert fixed date"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=108290">108290</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Add function which will insert fixed date
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>Inherited From OOo
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>enhancement
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>kruno.se@gmx.com
</td>
</tr></table>
<p>
<div>
<pre>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: <a href="https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=82400">https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=82400</a>
Google Sheets: <a href="https://productforums.google.com/forum/#!topic/docs/AD3EsxZVhG8">https://productforums.google.com/forum/#!topic/docs/AD3EsxZVhG8</a>
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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>