Chris Ahlstrom wrote:
> After takin' a swig o' grog, Tim Smith belched out
> this bit o' wisdom:
>
>> In article <VpxWl.7192$Xw4.5629@xxxxxxxxxxxxxxxxxxxxxx>,
>> Chris Ahlstrom <ahlstromc@xxxxxxxxxxxxxxx> wrote:
>>>
>>> 's fine. I don't see any way to do what you want with OOo.
>>
>> You can do it. I think I mentioned how earlier. Put =NOW() in some
>> cell. When you want a time-stamp, copy that cell, and use "paste
>> special" to paste it where you want the time-stamp. In the "paste
>> special" dialog, deselect the default option (which is to paste all),
>> so that you can specify what to paste, and then deselect "formulas"
>> from the list of things pasted. This way, you are just pasting the
>> value of the source cell into the destination cell. You can then format
>> the destination cell with a time format.
>
> I thought I tried that, and it didn't work.
>
> FFE? (The "Fat Finger Effect").
>
>> What I found so odd about there not being (apparently) an easy way to
>> do this in the spreadsheet is that it is a quite common function on
>> office-type programs. Some that have an easy time-stamp procedure:
>>
>> OpenOffice word processor
>> Microsoft Excel, Word, Notepad, Wordpad
>> gedit
>> Apple Pages, Numbers
>> The Omni Group OmniOutliner
>
> Never heard of that feature, myself.
>
>> I don't feel like installing KOffice, Gnumeric, and Lotus Symphony to
>> see what they do. :-)
>
> I'd simply paste in the output of "date".
>
http://extensions.services.openoffice.org/project/DateTime2
Might also be of interest
--
"The Microsoft Game" rules are very simple:
1. If you play Microsoft's game, Microsoft wins.
2. If you refuse to play Microsoft's game, Microsoft wins.
3. Anytime you win, Microsoft gets to change the rules.
|
|