[libreoffice-users] Re: About.com Readers' Choice Awards 2013 for Office Software

2013-03-09 Thread Marc Paré
Here is an update to the About.com Choice Awards 2013 for Office Software FYI, the About.com Readers' Choice Awards 2013 for Office Software started on Feb. 19 and will end on March 19. You may vote every 24hrs. Let's make our LibreOffice suite the office suite of choice and it would be

[libreoffice-users] Re: KDE integration

2013-03-09 Thread Marc Paré
Le 09/03/13 01:20 AM, F Glopez a écrit : Hi Jay, I did what you proposed ... I added ppa:libreoffice/ppa to my sources , looked for libreoffice-kde package, installed it and some of its dependencies ( a couple of upstream packages had to be removed ) . Unfortunately it seems LibreOffice

Re: [libreoffice-users] Re: About.com Readers' Choice Awards 2013 for Office Software

2013-03-09 Thread Tom Davies
Hi :) I suspect that the 55% for AOO in business is due to LibreOffice voters not finding an option to vote for Libreoffice.  In such cases the votes seem to be split between Google-docs and AOO because they are the 2 suite that are most similar to LibreOffice.  Likewise where AOO is not

Re: [libreoffice-users] Re: About.com Readers' Choice Awards 2013 for Office Software

2013-03-09 Thread Tom Davies
Hi :) Do!  My example of the Academic Section was a tad flawed!  lol.  They do actually have 2 of the bundles for students and academics, they just don't have the 'normal' bundle for a comparison.  So, it's still not a fair vote but somehow LibreOffice is streaking ahead despite that. 

Re: [libreoffice-users] Currency conversion/display in calc

2013-03-09 Thread Tom Davies
Hi :) I think the usual way is to avoid typing in the $ sign and just let the cell formatting put that in front for you.  Regards from Tom :)  From: Steve Edmonds steve.edmo...@ptglobal.com To: users@global.libreoffice.org Sent: Saturday, 9 March 2013,

off-list Re: [libreoffice-users] Macros don't run

2013-03-09 Thread Tom Davies
Hi :) Lol, i was going to ask that! :)   Reminds me of the story of the Cambridge Maths Lecturer that at the beginning of 1 term wrote on blackboard It is obvious that ... then paused and looked at the board, then at his chalk, then back at his notes and back at the board again and then just

Fwd: [libreoffice-users] Currency conversion/display in calc

2013-03-09 Thread Johnny Rosenberg
Did it again… sent it privately. Sorry again, then. Here's to the list: -- Forwarded message -- From: Johnny Rosenberg gurus.knu...@gmail.com Date: 2013/3/9 Subject: Re: [libreoffice-users] Currency conversion/display in calc To: Tom Davies tomdavie...@yahoo.co.uk 2013/3/9 Tom

Fwd: [libreoffice-users] Currency conversion/display in calc

2013-03-09 Thread Johnny Rosenberg
Same mistake as usual, sending my replies privately. I will never learn, I'm quite sure of that now… Anyway, here it is again, to the list this time: -- Forwarded message -- From: Johnny Rosenberg gurus.knu...@gmail.com Date: 2013/3/9 Subject: Re: [libreoffice-users] Currency

Re: Fwd: [libreoffice-users] Currency conversion/display in calc

2013-03-09 Thread Tom Davies
Hi :) I think you might be over-complicating it?  Just typign the number in as a number and letting the formatting do it's magic seems a much easier route!  Regards from Tom :)  From: Johnny Rosenberg gurus.knu...@gmail.com To: LibreOffice Användare

Re: [libreoffice-users] Currency conversion/display in calc

2013-03-09 Thread Don Myers
Hi Steve, I only have 4.0.1.2 installed, but my guess is that with the comma in there, or possibly the dollar sign, or maybe both, when you are pasting it, calc thinks it is text and not a number. That causes the left alignment and not being dividable since text can't be divided. Don On

Re: Fwd: [libreoffice-users] Currency conversion/display in calc

2013-03-09 Thread Johnny Rosenberg
2013/3/9 Tom Davies tomdavie...@yahoo.co.uk: Hi :) I think you might be over-complicating it? Just typign the number in as a number and letting the formatting do it's magic seems a much easier route! Well, I don't know what the OP usually does, but maybe he goes to a website somewhere,

Re: [libreoffice-users] Currency conversion/display in calc

2013-03-09 Thread Dan Lewis
On 03/09/2013 01:00 AM, Steve Edmonds wrote: Hi. If I type or paste $2,441.99 into a cell in calc (3.6) it is left aligned. If I right click format cell it states number-general. If I divide it by 2 I get #value! How do I get LO to recognise this as a number. I found a long winded way,

[libreoffice-users] Macro Security Settings

2013-03-09 Thread Andrew
Version 3.6.5.2 (Build ID: 5b93205) I wrote a program? macro? many years ago in Excel 2000 that I haven't used in almost as long, but now I have need of it again. When I try to run it, Libre Calc complains about the security settings. I changed them in

Re: [libreoffice-users] Macro Security Settings

2013-03-09 Thread Mirosław Zalewski
Perhaps macro is not run due to error? LibreOffice does not use VBA, as MS Office does; it uses Star Basic instead. It tries to translate VBA to SB on the fly, but most of time it fails to do so. I bet this is your case. I am afraid you must rewrite your macro to Star Basic, so LO will be able

Re: [libreoffice-users] Currency conversion/display in calc

2013-03-09 Thread Steve Edmonds
On 2013-03-10 01:23, Johnny Rosenberg wrote: 2013/3/9 Steve Edmonds steve.edmo...@ptglobal.com: Hi. If I type or paste $2,441.99 into a cell in calc (3.6) it is left aligned. If I right click format cell it states number-general. If I divide it by 2 I get #value! How do I get LO to recognise

Re: Fwd: [libreoffice-users] Currency conversion/display in calc

2013-03-09 Thread Steve Edmonds
Thanks, but it is pasted text that this applies to. Steve On 2013-03-10 02:01, Tom Davies wrote: Hi :) I think you might be over-complicating it? Just typign the number in as a number and letting the formatting do it's magic seems a much easier route! Regards from Tom :)

Re: [libreoffice-users] Macro Security Settings

2013-03-09 Thread Andrew
Thanks for the response, but that doesn't sound right to me. If it were a run error I'd expect to get some kind of runtime error, not a security warning. But perhaps someone else knows? On 3/9/2013 10:47 AM, Mirosław Zalewski wrote: Perhaps macro is not run due to error? LibreOffice does

Re: [libreoffice-users] Macro Security Settings

2013-03-09 Thread Johnny Rosenberg
2013/3/9 Andrew apb5...@bak.rr.com: Version 3.6.5.2 (Build ID: 5b93205) I wrote a program? macro? many years ago in Excel 2000 that I haven't used in almost as long, but now I have need of it again. When I try to run it, Libre Calc complains about the security settings. I changed them in

Re: [libreoffice-users] Macro Security Settings

2013-03-09 Thread Andrew
On 3/9/2013 11:56 AM, Johnny Rosenberg wrote: 2013/3/9 Andrew apb5...@bak.rr.com: Version 3.6.5.2 (Build ID: 5b93205) I wrote a program? macro? many years ago in Excel 2000 that I haven't used in almost as long, but now I have need of it again. When I try to run it, Libre Calc complains about

Re: [libreoffice-users] Macro Security Settings

2013-03-09 Thread Johnny Rosenberg
2013/3/9 Andrew apb5...@bak.rr.com: On 3/9/2013 11:56 AM, Johnny Rosenberg wrote: 2013/3/9 Andrew apb5...@bak.rr.com: Version 3.6.5.2 (Build ID: 5b93205) I wrote a program? macro? many years ago in Excel 2000 that I haven't used in almost as long, but now I have need of it again. When I

[libreoffice-users] Basic macro – How to get locale info?

2013-03-09 Thread Johnny Rosenberg
I want my macro to find out my current decimal separator and thousands delimiter. Did some searching without any kinds of results. With xray I found my language, but not much more than that. I appreciate any link (or other information) that brings me closer to the answer. Johnny Rosenberg --

Re: [libreoffice-users] Currency conversion/display in calc

2013-03-09 Thread Steve Edmonds
On 2013-03-10 07:12, Dan Lewis wrote: On 03/09/2013 01:00 AM, Steve Edmonds wrote: Hi. If I type or paste $2,441.99 into a cell in calc (3.6) it is left aligned. If I right click format cell it states number-general. If I divide it by 2 I get #value! How do I get LO to recognise this as a

[libreoffice-users] Re: Macro Security Settings

2013-03-09 Thread Tom
Hi :) You can find Andrew Pitonyak's Macro Guide at https://wiki.documentfoundation.org/Documentation/Other_Documentation_and_Resources#Programmers That link might be redirected to something like https://wiki.documentfoundation.org/Documentation/Publications/Unofficial/Programmers or

Re: [libreoffice-users] Macro Security Settings

2013-03-09 Thread Tom Davies
Hi :) I think there are 4 different languages that can be used to create macros for LibreOffice.  Java is going down the pan now that Oracle run it so it might be best to use Python?  The LibreOffice devs are currently converting all java stuff to other languages, i think mostly to Python or

Re: [libreoffice-users] Currency conversion/display in calc

2013-03-09 Thread Tom Davies
Hi :) You can always try to use Paste Special Shift Ctrl V and choose unformatted text.  I'm not sure if that will strip the ' off the front or the marks from around it but it';s got to be worth a try when pasting stuff from websites.  Regards from Tom :) 

[libreoffice-users] Re: Currency conversion/display in calc

2013-03-09 Thread Tinkerer
What is your default Language set to? Before Pasting, Go to FormatCells and alter the Language to US English. After Pasting, alter it back to UK English, or whatever currency is the Default. Tink. -- View this message in context: