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

On 11/27/2016 8:11 PM, Remy Gauthier wrote:
> 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.

Thank you Rémy
> 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

Thanks Brian.



--
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