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