Re: [libreoffice-users] Re: Copy-Paste(special) times in Calc. - solved

2017-03-29 Thread Steve Edmonds
Copy to the group. Wow, never knew that was there. All those options that don't seem to be in any menu. Thanks, that solved it On 30/03/17 10:16, m.a.riosv wrote: There is a way. After select and copy, click on the right arrow of the paste icon and select paste as Unformatted text or Format

[libreoffice-users] Re: Copy-Paste(special) times in Calc.

2017-03-29 Thread m.a.riosv
There is a way. After select and copy, click on the right arrow of the paste icon and select paste as Unformatted text or Formatted text [RTF] Miguel Ángel. -- View this message in context: http://nabble.documentfoundation.org/Copy-Paste-special-times-in-Calc-tp4211360p4211366.html Sent fro

Re: [libreoffice-users] Calc Question

2017-03-29 Thread Gregory Forster
THANKS! I checked my wife's computer - sure enough. On 3/29/2017 12:46 PM, Brian Barker wrote: At 09:29 29/03/2017 -0500, you wrote: In Calc, how do insert page breaks in version 5.? The documentation for LO 5 states what's in version 4.2.2, but it's missing from LO 5.? The facility is still

[libreoffice-users] Copy-Paste(special) times in Calc.

2017-03-29 Thread Steve Edmonds
Hi. Playing with the calculate decimal seconds I came across an interesting thing, is it a bug, I am not sure. Tested in LO 5.2, Linux and Win7. If you create a list of times say 02:58.03, etc. down from A1 In the column next (B) enter =A1 and copy down. Format as [SS].00 so it shows column A

Re: [libreoffice-users] Calculate decimal seconds

2017-03-29 Thread Steve Edmonds
Hi. 2 interesting options, which one you choose depends upon what you want to do with the number you get. You need to bear in mind that option 2 is just showing you DAYS in a different format. If the time is how long to run 100 (m/ft) and you want to calculate a speed for instance you would d

Re: [libreoffice-users] Calculate decimal seconds

2017-03-29 Thread Cley Faye
2017-03-29 15:38 GMT+02:00 vytas : > I have a spreadsheet containing timing results which are displayed using > the a Format code of MM:SS.00 (02:58.03). > > What I require is the number of seconds the cell represents as a decimal > number of seconds (178.03) for the above value. > ​The actual,

Re: [libreoffice-users] Calc Question

2017-03-29 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Greg, mark the row and choose Sheet > Insert Page Break > Row Break Regards Robert - -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_3 -BEGIN PGP SIGNATURE- Version: GnuPG v2 i

Re: [libreoffice-users] Calc Question

2017-03-29 Thread Dries Feys
Hi Greg, You can find the solution in the online help. https://help.libreoffice.org/Calc/Insert_Page_Break Met vriendelijke groeten, Salutations distinguées, Kind Regards, DRIES FEYS CORPORATE SERVICES • Specialist Software Developer TVH GROUP NV Brabantstraat 15 • BE-8790 WAREGEM T +32 56 43

Re: [libreoffice-users] Calculate decimal seconds

2017-03-29 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Helo Vytas, > > I have a spreadsheet containing timing results which are displayed > using the a Format code of MM:SS.00 (02:58.03). > > What I require is the number of seconds the cell represents as a > decimal number of seconds (178.03) for the ab

[libreoffice-users] Calculate decimal seconds

2017-03-29 Thread vytas
Hi, I have a spreadsheet containing timing results which are displayed using the a Format code of MM:SS.00 (02:58.03). What I require is the number of seconds the cell represents as a decimal number of seconds (178.03) for the above value. I would be very grateful if someone point me in th

[libreoffice-users] Calc Question

2017-03-29 Thread Gregory Forster
Hi, I have a Windows 7 laptop and desktop with LO 4.2.2. Everything works great! In February, for my wife's birthday, I bought her a very nice laptop with Windows 10 on it. LO 4.2.2 would not install on it. Apparently, LO 4.2.2 was too old a version. So I downloaded the latest LO, ver