Use the COPY as normal then instead of PASTE use PASTE SPECIAL and select what you want to paste eg "numbers". I hope this helps John van Barneveld
------ Original Message ------ From: "Mike Shearer" <mike.shea...@westnet.com.au> To: "OpenOffice Users" <users@openoffice.apache.org> Sent: 22/08/2020 1:17:26 PM Subject: CALC problem
I have a spreadsheet containing information about events that occur at various times over two weeks. I wish to sort the entries by the elapsed time in minutes between successive events. A simplified example: column A and B contain the date and time when events occur, column C contains the calculated time delay between events using "=B2-B1" displayed as hour:minutes. Column D calculates the time elapsed between events in minutes using "=HOUR(C2)*60+MINUTE(C2). I want to "play" with the values in column D, such as sorting them and charting the results to highlight various characteristics of the original data. How can I copy the calculated values from column D rather than take the formulae that determine the values? Mike Shearer
-- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
