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
