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?
NOW() with a fixed date?
NOW() with a fixed date?
OpenOffice 4.1.2 / Gentoo AMD64
Re: NOW() with a fixed date?
Hallo
Type: =now() … <F9> … <enter> … <enter>
Karolus
Type: =now() … <F9> … <enter> … <enter>
Karolus
Libreoffice 7.4 on Debian 12 (Bookworm) (on RaspberryPI4)
Libreoffice 7.6 flatpak on Debian 12 (Bookworm) (on RaspberryPI4)
Re: NOW() with a fixed date?
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:
an example file:
...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
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: NOW() with a fixed date?
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.
AOO4/LO5 • Linux • Fedora 23
Re: NOW() with a fixed date?
Do you mean the 'fixed Date-Time fields' function of the LO? How you can insert them in a Calc cell?Libreoffice: it comes with this feature built-in and configured with a shortcut key.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: NOW() with a fixed date?
No, its only 2 predefined Entries for →Tools→Customize→Keyboard…→→insert→[current_Time|current_Date]Zizi64 wrote:Do you mean the 'fixed Date-Time fields' function of the LO? How you can insert them in a Calc cell?Libreoffice: it comes with this feature built-in and configured with a shortcut key.
Libreoffice 7.4 on Debian 12 (Bookworm) (on RaspberryPI4)
Libreoffice 7.6 flatpak on Debian 12 (Bookworm) (on RaspberryPI4)
Re: NOW() with a fixed 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.karolus wrote:No, its only 2 predefined Entries for →Tools→Customize→Keyboard…→→insert→[current_Time|current_Date]Zizi64 wrote:Do you mean the 'fixed Date-Time fields' function of the LO? How you can insert them in a Calc cell?Libreoffice: it comes with this feature built-in and configured with a shortcut key.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: NOW() with a fixed date?
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!
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!
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.