How to keep today's Date from updating
How to keep today's Date from updating
I have a spreadsheet where i entered the formula that displays todays date when I open it. However, if I open the sheet three days later, it will display the new date and i want it to display the original date, kind of like a timestamp. Is there a way I can generate the date and keep it from updating? Your suggestions are greatly appreciated. Thanks
Open Office 3.1
Re: How to keep today's Date from updating
Just type-in the date as a constant.
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: How to keep today's Date from updating
I have the formula as =TODAY ()
Should I edit this so it will stay and not change when I open the sheet tommorow? Thanks
Should I edit this so it will stay and not change when I open the sheet tommorow? Thanks
Open Office 3.1
Re: How to keep today's Date from updating
The formulas always will refresh. Use constants.I have the formula as =TODAY ()
You can convert the actual results of the formulas to constants by usage the Ctrl-C / Paste special - Values and Format properties.
Last edited by Zizi64 on Sat Jul 20, 2019 3:49 pm, edited 1 time in total.
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: How to keep today's Date from updating
This is the old problem set out in Lewis Carroll's "Through the Looking Glass and What Alice Found There"
When you get to tomorrow, it isn't tomorrow, it is today. So the formula does exactly what it should."The rule is, jam to-morrow and jam yesterday – but never jam to-day."
"It must come sometimes to 'jam to-day'," Alice objected.
"No, it can't," said the Queen. "It's jam every other day: to-day isn't any other day, you know."
"I don't understand you," said Alice. "It's dreadfully confusing!
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Re: How to keep today's Date from updating
Im not sure im following you. Im clicking the cell that has the date of July 20, 19 which is the result from the formula =Today () and i dont get anything that says Values or constant? I just get a paste special window that gives me options for selection, operations, skip empty cells and shift cells. I think im either missing something or im not copy and paste special correctly?
Open Office 3.1
Re: How to keep today's Date from updating
Uncheck the "All" and the "Formulae" options. Check-in the "Numbers", "Text", "Date & Time" options, and you may check-in the "Formats" option too.I just get a paste special window that gives me options for selection, operations, skip empty cells and shift cells. I think im either missing something or im not copy and paste special correctly?
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: How to keep today's Date from updating
Okay. I see what you mean as I just did that and it makes sense now. I noticed how the input line now displays the date and not the formula. I'll keep my fingers crossed that the date july 20 19 will also show up tommorow when i open the sheet. Thanks again
Open Office 3.1
Re: How to keep today's Date from updating
The constants never will be changed automatically.I'll keep my fingers crossed that the date july 20 19 will also show up tommorow when i open the sheet.
Please update your signature in this forum.Open Office 3.1
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: How to keep today's Date from updating
Hello,
another possibility:
R
another possibility:
- Menue Tools/Options/OpenOffice Calc/Calculate->Check Iterations
- CELL B2 Formula:
Code: Select all
=IF(A2="";"";IF(CELL("TYPE";B2)="v";B2;TODAY()))
R
- MMove 1.0.6
- Extension for easy, exact positioning of shapes, pictures, controls, frames ...
- my current system
- Windows 10 AOO, LOLinux Mint AOO, LO
Re: How to keep today's Date from updating
You can also select the cell and press function key F2, then F9, then Enter twice.
For me, if it is a single instance, this is the fastest solution. Keyboard shortcuts are more efficient than mouse clicks.
If you need multiple datestamps, you may be better served with a macro, which can be assigned to a keyboard shortcut.
F2 brings up your formula for editing.
F9 recalculates the edit field content, and suggests the value in "autoinput" manner.
First enter accepts the input suggestion to the edit field.
Second enter commits the edit field to the cell.
For me, if it is a single instance, this is the fastest solution. Keyboard shortcuts are more efficient than mouse clicks.
If you need multiple datestamps, you may be better served with a macro, which can be assigned to a keyboard shortcut.
F2 brings up your formula for editing.
F9 recalculates the edit field content, and suggests the value in "autoinput" manner.
First enter accepts the input suggestion to the edit field.
Second enter commits the edit field to the cell.
Re: How to keep today's Date from updating
https://libreoffice.org/ (which is the successor to OpenOffice) has a built-in shortcut Ctrl+Alt+Y which inserts today's date as a constant value into the active cell.
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: How to keep today's Date from updating
The default shortcut associations depended on the locale settings of the LibreOffice. I have not such shortcut association in my Hungarian LO 6.1.6. I have Shift-Ctrl-. for inserting the actual time as a constant, and I have Ctrl-. for inserting the actual date as a constant.has a built-in shortcut Ctrl+Alt+Y which inserts today's date as a constant value into the active cell.
Check the default associations of the shortcut keys in the Custumize menu.
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.