Cookie

Caution


This article was published more than a year ago, there may have been developments.
Please take this into account.

Today's article is simple and fast, and solves a question for LibreOffice Calc that I have recently put.

How to set up a Calc document so that every time you open the spreadsheet the date in one cell to automatically update to today's date?

The same operation is very simple with LibreOffice Writer: “Enter” – “Command field” – “Data”. In any reopening the file, the date is updated than today.

writer_data
Enter the date in Writer

As regards Calc there is not a field command, but if inserted a simple little formula that shows today's date: “= Today()”.

data_calc

Note the formula inside the bar, and the result within the cell.

It is also possible variant “= Now()”, that will show the date and time. If properly formatted can also show the date only, or only the month, or only the minute.

  Exclude files and directories from indexing using the file "robots.txt"
Categories: Tips

TheJoe

I keep this blog as a hobby by 2009. I am passionate about graphic, technology, software Open Source. Among my articles will be easy to find music, and some personal thoughts, but I prefer the direct line of the blog mainly to technology. For more information contact me.

0 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.