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 Formatted text [RTF]

Miguel Ángel.





--
View this message in context: 
http://nabble.documentfoundation.org/Copy-Paste-special-times-in-Calc-tp4211360p4211366.html
Sent from the Users mailing list archive at Nabble.com.




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

[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 from the Users mailing list archive at Nabble.com.

-- 
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] 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 there, but menus have been changed and Insert 
Page Break is now in the new Sheet menu. See

https://help.libreoffice.org/Calc/Insert_Page_Break .


I need to be able to install page breaks.


There are multiple ways to do this (so it would have been helpful for 
you to have specified which method you found not working). Apart from 
using the menus, you can also go to View | Page Break Preview. In that 
view, you can right-click a cell and select Insert Row Break or Insert 
Column Break. There is also Delete All Manual Breaks. Once you have 
breaks inserted, you can easily drag them around to modify your 
selection. This is probably the easiest way to adjust pagination after 
you have prepared your material.


I trust this helps.

Brian Barker - privately





---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


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

[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 as seconds.


I am attempting to copy those seconds and paste elsewhere on the sheet 
as just numbers in seconds. I can't seem to do this directly.
I can copy and paste into writer as HTML and I get those seconds in a 
table. I can then copy the table back into calc as numbers.
In linux the numbers of seconds are copied to Klipper (the KDE clipboard 
if it is still called that) and I can paste back as a text import which 
is convenient for linux users.


Is there a way within Calc (as windows doesn't have klipper) to paste 
the numbers only as displayed. They paste as numbers as displayed into 
other applications such as notepad so they are available for pasting 
from the clipboard.


Steve

--
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] 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 divide 100 by the seconds.

Option 1 will give you the m(ft)/second velocity.
Option 2 will give you the m(ft)/day velocity.

Quite different answers.
Steve

On 30/03/17 05:06, Cley Faye wrote:

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.


Option 1


​The actual, numerical value stored in such a cell is a number of day. To
find this out, you can remove formating.

Suppose you have 02:58.03 in A1, you put "=A1" in A2, then Ctrl+M to remove
formatting, it will show you something like 0.002060532
To convert from "number of day" to "number of seconds", multiply with
60*60*24. For example, putting "=A1*60*60*24" in A3 will display 178.03

Option 2

Changing the format to
[SS].00
wold help.

Regards

Robert



--
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] 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, numerical value stored in such a cell is a number of day. To
find this out, you can remove formating.

Suppose you have 02:58.03 in A1, you put "=A1" in A2, then Ctrl+M to remove
formatting, it will show you something like 0.002060532
To convert from "number of day" to "number of seconds", multiply with
60*60*24. For example, putting "=A1*60*60*24" in A3 will display 178.03

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

iQIcBAEBAgAGBQJY29FUAAoJELDKYwaoS9AIxrMP/Ai5sA9dMH7sJ25/Ao8cHA0j
tzB1pa9Kf7tKqhd6h1wYyyEujVs790M9N3oYYa6RbN74BOy/7kbCzsq5pqcE7TBE
G254tIOsMrXN9PTWfihDR63GYUZJU1crKPUOTSAS5rRC9ev3Qc7lq41B/cHZK/CZ
LZ7lhW01sB0zBxVORdUO5Z1H4lUQZJSXLTHPNTUzsKC1euTcJk7Ql/dBpQCHX/JV
//DWfR2g5BBseLta5istG2xfWSxpC0/8c1UsBr/U+3Gxc98G7GPKf8PlwWHjweh1
cWVA2Wbz04prUJfHeKAIjY0LeEHf6jxJUvbgSui3UpNWzMi6hWb8TuvS5U3IkuA7
c4lPbf1eqRmDw6GZVGVLNAM+Vqlrdu2FjIXSkot2vuXeN3fXv4v7hOQqpFx5a9++
GyaXI3pPAjvbgfG2M+BdWlR6JNIF998E9po59yXsWzrz8ffUo7EG3ZBDWmfdw+q6
kOkTkBoRXC6SysGV1HQH48yAOuDpRcg/qbuaqBBszbhq/lK+xB4wZI6pZYC9FZjZ
8EiJaauExs+zAUYKDtg7qNec2jvEkJly0lyKq/qWhx/9IW/T7c4B1ueg01PyGpoU
OGx19m/zK9r8BYg5k6qxCvNXWpeLzUc84FJZw0KguMeNDwmttK/kbQoYSbkRbJYn
4MkSh8VBs447G0SkbqhC
=LbIl
-END PGP SIGNATURE-

-- 
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] 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 42 11 • F +32 56 43 44 88 • www.tvh.com
View our company movies via downloads on our website.


On 29 March 2017 at 16:29, Gregory Forster  wrote:
> 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,
> version 5.? and it installed great. However, one thing is still missing in
> LO 5.? that works fine in LO 4.2.2. 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.?  I need to be able to install page breaks.
>
> Thanks,
>
> Greg
>
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
>
>
> --
> 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

-- 


 DISCLAIMER 

http://www.tvh.com/glob/en/email-disclaimer

"This message is delivered to all addressees subject to the conditions
set forth in the attached disclaimer, which is an integral part of this
message."

-- 
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] 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 above value.

Changing the format to
[SS].00
wold help.

Regards

Robert
- -- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
-BEGIN PGP SIGNATURE-
Version: GnuPG v2

iQIcBAEBAgAGBQJY289AAAoJELDKYwaoS9AIew4P/jYPKREEQYuubE6qoTOUoUkX
qCMw/jS2LC1wxarnyxGwF7XpfIxw+VM71t25BYPM+jVdMD3oM4xnVEOYJq6jJiqG
PZdzBLP3mbmuFs6ManeE7vDJpMX3qIABUO25ZCEwFQvfZR0L7u5JNhuoRw15SfBN
9Q426B6OiNoaq7DVKqBv4C1f5x3DPBkW9sAxFQGMRhBtgW5RKTxp9z/efkojQXcv
thQObq+Ym/0lzPGGbkpr9aQ6wepagcAtQIw3SH4JKmmhEsK0hemdWos1khmq0UjI
g7pjfhQ051GfdgWf70SLDnB/TtADbr8bWHTf6UX7yXEgdDWMUUnTHsCcA1mphPUZ
jyKGNfzd5X+tlwQxVNxfYmMYElFXPAO/K19qfzmINLOriNWcZ7oS6+PKq2gbLqJ3
yExRPrmbPfsEn590vXTpklORD+AJoyipMI92Y8gG/aBuKjsWYiP232jGjNkxmlSq
HqIsFVcnvWANPp5UGYmD6jUUcpYq9QfESRy9lY4lxioozumb09lfFrrV9Z4Z0LKY
zXj+zdeVn8N485XbpE2TeF194HIeBsW3/aO6/Nd8eDbZI7LdXZ3bKGb1n0d/gral
GJMqQ9bQYL+dPPKmyqtxAYtpfNwfRtMQIg24kwSsu9v2Iv0I60Vperb3L/s4InVb
D2ruLsp7bTnRU77nPJrZ
=bB+l
-END PGP SIGNATURE-

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

[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 the right direction.

Thanks,

Vytas


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

[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, version 5.? and it installed great. However, one thing is still 
missing in LO 5.? that works fine in LO 4.2.2. 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.?  I need to be able to 
install page breaks.


Thanks,

Greg


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


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