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

2016-11-27 Thread Remy Gauthier
Hello,

You could also refer to this post:

https://forum.openoffice.org/en/forum/viewtopic.php?f=45=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 +, 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+unsubscr...@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


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

2016-11-27 Thread Brian Barker

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+unsubscr...@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



[libreoffice-users] "Today" in calc

2016-11-27 Thread william drescher

(2nd posting, it appears the first disappeared in cyberia)

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.

--
-bill


--
To unsubscribe e-mail to: users+unsubscr...@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