NOW() with a fixed date?

[nownownow]

How can I avoid NOW() fields being recalculated to the current date every time?
I want to enter the current timestamp once and it should stay fixed forever.
The only "solutions" I found were for OO 2.x and involved messing around with macros, which is just ridiculous.
Is there an easy way to solve this in OO 4.x?

[karolus]

Hallo

Type: =now() … <F9> … <enter> … <enter>

Karolus

[Zizi64]

viewtopic.php?f=9&t=35236

...Or you can type-in the actual date-time value manually...

But the most efficient way to create a macro, what will insert the actual date-time value into the selected (active) cell.

For beginners - with the macrorecorder:
https://scito.ch/content/insert-current ... ffice-calc



If you can use the API functions:

Code: Select all

Sub Timestamp

	oCell = ThisComponent.getCurrentSelection()
	oCell.setValue(DateValue(Now)+TimeValue(Now))
end sub

an example file:

Timestamp.ods

(11.59 KiB) Downloaded 254 times

[acknak]

If this function is important for you, you may want to try Libreoffice: it comes with this feature built-in and configured with a shortcut key.

[Zizi64]

Libreoffice: it comes with this feature built-in and configured with a shortcut key.

Do you mean the 'fixed Date-Time fields' function of the LO? How you can insert them in a Calc cell?

[karolus]

Libreoffice: it comes with this feature built-in and configured with a shortcut key.

Do you mean the 'fixed Date-Time fields' function of the LO? How you can insert them in a Calc cell?

No, its only 2 predefined Entries for →Tools→Customize→Keyboard…→→insert→[current_Time|current_Date]

[Villeroy]

Libreoffice: it comes with this feature built-in and configured with a shortcut key.

Do you mean the 'fixed Date-Time fields' function of the LO? How you can insert them in a Calc cell?

No, its only 2 predefined Entries for →Tools→Customize→Keyboard…→→insert→[current_Time|current_Date]

Wow. It can insert either the time or the date or a date text field borrowed from the Writer component. But it can not insert a time stamp (date + time) which is what virtually everybody wants.

[Zizi64]

Ahh yes, I see now: In the HUN version of the LibreOffice there are two predefined shortcut keys for the date and the time.

Ctrl-. (dot) → Date (formatted: "YYYY-MM-DD")
Shift-Ctrl-. → Time (formatted: "HH:MM:SS")


I do not remember these functions. Thank you for the information!