Re: [users] Macro to insert current date?

2007-01-17 Thread NSP Ciudad Madero
unfortunately in my OOo.Calc (Ver 2.1) CTRL+F2 is insert function in main menu insert.field is not exist or is missing. Well, then don't insert the date field, but the date function, select DATTIME and choose TODAY() Saludos, Roberto

[users] Macro to insert current date?

2007-01-16 Thread RBL
Apparently OpenOffice doesn't have native keystrokes to insert current date or current time. In MSFT Office, it's Ctrl+; and Shift+Ctrl+; (if memory serves). If anyone happens to have a macro or other keystroke-based approach they use to do this in Writer and Calc, I would be most

Re: [users] Macro to insert current date?

2007-01-16 Thread Alan Frayer
RBL wrote: Apparently OpenOffice doesn't have native keystrokes to insert current date or current time. In MSFT Office, it's Ctrl+; and Shift+Ctrl+; (if memory serves). If anyone happens to have a macro or other keystroke-based approach they use to do this in Writer and Calc, I would be

Re: [users] Macro to insert current date?

2007-01-16 Thread NSP Ciudad Madero
RBL escribió: Apparently OpenOffice doesn't have native keystrokes to insert current date or current time. In MSFT Office, it's Ctrl+; and Shift+Ctrl+; (if memory serves). If anyone happens to have a macro or other keystroke-based approach they use to do this in Writer and Calc, I would be

Re: [users] Macro to insert current date?

2007-01-16 Thread TerryJ
RBL wrote: Apparently OpenOffice doesn't have native keystrokes to insert current date or current time. In MSFT Office, it's Ctrl+; and Shift+Ctrl+; (if memory serves). If anyone happens to have a macro or other keystroke-based approach they use to do this in Writer and Calc, I

Re: [users] Macro to insert current date?

2007-01-16 Thread John Meyer
TerryJ wrote: RBL wrote: Apparently OpenOffice doesn't have native keystrokes to insert current date or current time. In MSFT Office, it's Ctrl+; and Shift+Ctrl+; (if memory serves). If anyone happens to have a macro or other keystroke-based approach they use to do this in Writer

Re: [users] Macro to insert current date?

2007-01-16 Thread Ahromi Irawan, Cirebon
unfortunately in my OOo.Calc (Ver 2.1) CTRL+F2 is insert function in main menu insert.field is not exist or is missing. sorry my bad english. Ahromi Indonesia NSP Ciudad Madero wrote: RBL escribió: Apparently OpenOffice doesn't have native keystrokes to insert current date or current time.

Re: [users] Macro to insert current date?

2007-01-16 Thread Michael Adams
In calc you can record your own Macro, then set it to any free key combination. Start record: - Set function of cell to Today() or NOW() - Format - Cells (Numbers Tab) - Select date or time format desired Stop Recording: On Wed, 17 Jan 2007 09:36:54 +0700 Ahromi Irawan, Cirebon wrote:

Re: [users] Macro to insert current date?

2007-01-16 Thread Ahromi Irawan, Cirebon
The problem is : if i use function now() and i open the document on the other day, cell value will be different. some macro from pitonyak, just assign this macro to a button (will be easy) '** 'Author: Andrew Pitonyak 'email:

Re: [users] Macro to insert current date?

2007-01-16 Thread Ahromi Irawan, Cirebon
reattach macro in text file Ahromi Irawan, Cirebon wrote: The problem is : if i use function now() and i open the document on the other day, cell value will be different. some macro from pitonyak, just assign this macro to a button (will be easy)