Re: [libreoffice-users] "Today" in calc

Hello,

You could also refer to this post:

https://forum.openoffice.org/en/forum/viewtopic.php?f=45&t=30071 

I believe it describes a way to do what you are looking for. Basically
they describe a way to trigger a macro that monitors a range of cells
and that performs a specific operation when something is changed.

Rémy Gauthier.

Le dimanche 27 novembre 2016 à 23:57 +0000, Brian Barker a écrit :
> At 07:04 27/11/2016 -0500, William Drescher wrote:
> > (2nd posting, it appears the first disappeared in cyberia)
>
> Both messages presumably awaited moderation. Your first arrived 47 
> seconds after your second.
>
> > When I update the data in a spreadsheet I need to also update the 
> > one of two cells "date data sent" or "date data received." I can't 
> > figure out a way of doing that automagically so I have a field in 
> > the header set to TODAY() and I copy and paste that into the row. 
> > > > Plain pasting doesn't work as that will paste the function, not
the 
> > > > value. Paste Special works but is a lot of clicks. Can anyone
think 
> > of a better way to do this.
>
> Right-click | Paste Only > | Number?
>
> If you prefer, you can find Paste Only under Edit in Tools | 
> Customise... | Keyboard and bind it to an unused keyboard shortcut.
>
> I trust this helps.
>
> Brian Barker

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted