[libreoffice-users] "Today" in calc
(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
Re: [libreoffice-users] "Today" in calc
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
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 +, 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