Ubuntu
openoffice.org2 package

How do I automatically insert todays date in a cell [Calc]

Asked by SandyEggoBoy

Hello, all. I am trying to create an invoice in calc but i need the current date automatically inserted in the "purchase_date" cell when i open the file.

Can anyone tell me how to do this?

Thanks,

Deric Stowell

Question information

Language:
English Edit question
Status:
Answered
For:
Ubuntu openoffice.org2 Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Alan Pope 🍺🐧🐱 🦄 (popey) said : 		#1

=TODAY()

To find this I did the following:-

Open OpenOffice.org SpreadSheet, Click Insert (menu) --> Function List. Then in the function list window that appears I chose "Date&Time", then found TODAY.

Revision history for this message
Ubuntu User (anotherubuntuuser) said : 		#2

If these comments solved your problem, please consider closing this request as answered. You can find useful information on managing your support requests here: https://wiki.ubuntu.com/SupportRequests

If you are still having problems, let us know and we'll keep working on them.

Thanks-

Jim Jones

Revision history for this message
SandyEggoBoy (deric-sandyeggoboy) said : 		#3

Thanks for the comments. I have not yet had a chance to test any of your solutions out, but i will in the next few hours.

The other thing i am trying to accomplish is setting a cell to auto-increment a numbher, such as an invoice number. Does anyone know where I can get a templete for invoicing ? can i use an excel sheet from M$'s site?

Revision history for this message
Wim van der Meer (wim-zaf) said : 		#4

OpenOffice can read MS Office files, but the compatibility is not 100%. I have had some problems myself, but nothing that couldn't be fixed.

I don't know about an auto increment function, but if there is one in Excel chances are that it is possible in OpenOffice as well.

++Wim

Revision history for this message
Ubuntu User (anotherubuntuuser) said : 		#5

For autoincrement.

1. Select the cell series

2. Choose Edit -> Fill -> Series

If these comments solved your problem, please consider closing this request as answered. You can find useful information on managing your support requests here: https://wiki.ubuntu.com/SupportRequests

If you are still having problems, let us know and we'll keep working on them.

Thanks-

Jim Jones

Can you help with this problem?

Provide an answer of your own, or ask SandyEggoBoy for more information if necessary.

To post a message you must log in.