[libreoffice-users] Re: About.com Readers' Choice Awards 2013 for Office Software
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 nice if we won out on all categories where we appear! To vote, you can log in with your Facebook or About.com accounts or you can enter your email address in a field on the page. Here are the details: = = The Readers' Choice Awards 2013 for Office Software categories webpage can be found here: http://office.about.com/od/ReaderResponse/tp/About-Com-Readers-Choice-Awards-2013-For-Office-Software-Nominations.htm = = As of today, March 9 2013, LibreOffice ranking in the various Office Software Suites categories is: = Favorite Office Suite for Android: LIBREOFFICE does not have an official implementation of an Android version. Favorite Office Suite for Android: Google Docs/Apps 75% -- Quickoffice Pro HD 25% = Favorite Office Software Suite or App for iOS: LIBREOFFICE does not have an official implementation of an iOS version. Favorite Office Software Suite or App for iOS: Google Apps 66% -- iWork 22% -- Documents Free 11% = Favorite Office Software for Mac: LibreOffice 84% -- iWork 5% -- MSO 2% -- NeoOffice 7% = Favorite Office Software for Windows: LibreOffice 56% -- MSO 2% -- AOO 41% = Favorite Office Software for BlackBerry: LibreOffice 80% -- LibreOffice 80% *** NOTE THAT THERE IS NO VERSION OF LIBREOFFICE FOR BLACKBERRY YET WE ARE STILL LEADING!!! WEIRD! = Favorite Office Software for Business: LIBREOFFICE IS NOT ON THIS LIST!!! ITALO IS AWARE OF THIS. Favorite Office Software for Business: MSO 2% -- Google Docs/Apps 41% -- AOO 55% ??? WordPerfect 1% -- IMO strange as LibreOffice is most likely used in Business = Favorite Academic Software Suite: LIBREOFFICE IS NOT ON THIS LIST!!! ITALO IS AWARE OF THIS. Favorite Academic Software Suite: MSO Home and Student 11% -- Google Apps for Education 88% -- IMO, strange as LibreOffice is most likely used in education extensively!!! = Favorite Site for Office Software Templates: LibreOffice templates 58% -- MSO templates 1% -- OpenOffice 40% = Favorite Cloud Office Suite: LIBREOFFICE, at present, does not have an official Cloud implementation, but is working on it. Favorite Cloud Office Suite: Google docs 84% -- MSOffice 365 7% -- ThinkFree Office (Hancom) 7% = Favorite Office Software Company or Organization Based on Social Responsibility: TheDocumentFoundation 59% -- TheApacheFoundation 37% -- Microsoft 1% Google 1% -- Apple 1% = Congrats to all who are voting every 24hrs. If you are not voting yet, feel free to join in. It will make a difference to our brand and show that we are a very committed community. Cheers, Marc -- Marc Paré m...@marcpare.com http://www.parEntreprise.com parEntreprise.com Supports OpenDocument Formats (ODF) parEntreprise.com Supports http://www.LibreOffice.org -- For unsubscribe instructions e-mail to: users+h...@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: KDE integration
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 upstream packages didn't cohabited properly with ppa:libreoffice/ppa ones ( LibreOffice didn't even started ) , so ... I fully uninstalled upstream LibreOffice and finally installed LO 4.0.1 from ppa:libreoffice/ppa . Well, I have to say something ... I had initially decided installing LO from upstream after almost two years running with ppa:libreoffice/ppa . I decided to made this change after suffering several problems regarding 'Partial Upgrades' , this is a very unconfortable issue where you have to uninstall quite a lot of packages to reinstall them again and ... even in that position, you may be unable to upgrade your LO version. I have decided to give a last opportunity to ppa:libreoffice/ppa , but either way, I believe the proper solution would be to include 'KDE Integration' packages on LibreOffice upstream. Does anybody know if this is a plausible/planned solution ? Thanks a lot. Although I do not use Ubuntu linux, I use Mageia2 Linux with KDE. I install the freedesktop menus that are found in the Desktop Integration file folder, and the menus work well with KDE. I am not sure if this would work with Ubuntu. Cheers, Marc -- Marc Paré m...@marcpare.com http://www.parEntreprise.com parEntreprise.com Supports OpenDocument Formats (ODF) parEntreprise.com Supports http://www.LibreOffice.org -- For unsubscribe instructions e-mail to: users+h...@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] Re: About.com Readers' Choice Awards 2013 for Office Software
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 listed i suspect their voters are torn between voting for Google-docs or LibreOffice. When i first voted i was determined to vote everyday but then forgot after the 2nd day. I suspect that AOO is more dedicated to voting because of the early massive lead LibreOffice had. In my opinion LibreOffice and AOO should be offered as 1 single choice because the products are so similar. We don't see the MS Office vote split between the various different bundles or different versions. It would be interesting to see how many in the Academics Section just carried on using whatever came with the machine rather than deliberately going out and getting the Student Edition of MSO. Machines seldom come with LibreOffice/AOO preinstalled so votes for them are from people that have found good reason NOT to stick with whatever they already had on their machine. Votes for MSO are often a vote to just a vote for inability, apathy, ignorance or even fear of their machine. MSO 'should' be winning in the votes because of the percentages of people using it and their resistance to change. The fact it isn't points more to apathy of MS users. Regards from Tom :) From: Marc Paré m...@marcpare.com To: users@global.libreoffice.org Sent: Saturday, 9 March 2013, 11:05 Subject: [libreoffice-users] Re: About.com Readers' Choice Awards 2013 for Office Software 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 nice if we won out on all categories where we appear! To vote, you can log in with your Facebook or About.com accounts or you can enter your email address in a field on the page. Here are the details: = = The Readers' Choice Awards 2013 for Office Software categories webpage can be found here: http://office.about.com/od/ReaderResponse/tp/About-Com-Readers-Choice-Awards-2013-For-Office-Software-Nominations.htm = = As of today, March 9 2013, LibreOffice ranking in the various Office Software Suites categories is: = Favorite Office Suite for Android: LIBREOFFICE does not have an official implementation of an Android version. Favorite Office Suite for Android: Google Docs/Apps 75% -- Quickoffice Pro HD 25% = Favorite Office Software Suite or App for iOS: LIBREOFFICE does not have an official implementation of an iOS version. Favorite Office Software Suite or App for iOS: Google Apps 66% -- iWork 22% -- Documents Free 11% = Favorite Office Software for Mac: LibreOffice 84% -- iWork 5% -- MSO 2% -- NeoOffice 7% = Favorite Office Software for Windows: LibreOffice 56% -- MSO 2% -- AOO 41% = Favorite Office Software for BlackBerry: LibreOffice 80% -- LibreOffice 80% *** NOTE THAT THERE IS NO VERSION OF LIBREOFFICE FOR BLACKBERRY YET WE ARE STILL LEADING!!! WEIRD! = Favorite Office Software for Business: LIBREOFFICE IS NOT ON THIS LIST!!! ITALO IS AWARE OF THIS. Favorite Office Software for Business: MSO 2% -- Google Docs/Apps 41% -- AOO 55% ??? WordPerfect 1% -- IMO strange as LibreOffice is most likely used in Business = Favorite Academic Software Suite: LIBREOFFICE IS NOT ON THIS LIST!!! ITALO IS AWARE OF THIS. Favorite Academic Software Suite: MSO Home and Student 11% -- Google Apps for Education 88% -- IMO, strange as LibreOffice is most likely used in education extensively!!! = Favorite Site for Office Software Templates: LibreOffice templates 58% -- MSO templates 1% -- OpenOffice 40% = Favorite Cloud Office Suite: LIBREOFFICE, at present, does not have an official Cloud implementation, but is working on it. Favorite Cloud Office Suite: Google docs 84% -- MSOffice 365 7% -- ThinkFree Office (Hancom) 7% = Favorite Office Software Company or Organization Based on Social Responsibility: TheDocumentFoundation 59% -- TheApacheFoundation 37% -- Microsoft 1% Google 1% -- Apple 1% = Congrats to all who are voting every 24hrs. If you are not voting yet, feel free to join in. It will make a difference to our brand and show that we are a very committed community. Cheers, Marc -- Marc Paré m...@marcpare.com http://www.parEntreprise.com parEntreprise.com
Re: [libreoffice-users] Re: About.com Readers' Choice Awards 2013 for Office Software
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. Regards from Tom :) From: Tom Davies tomdavie...@yahoo.co.uk To: Marc Paré m...@marcpare.com; users@global.libreoffice.org users@global.libreoffice.org Sent: Saturday, 9 March 2013, 11:55 Subject: Re: [libreoffice-users] Re: About.com Readers' Choice Awards 2013 for Office Software 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 listed i suspect their voters are torn between voting for Google-docs or LibreOffice. When i first voted i was determined to vote everyday but then forgot after the 2nd day. I suspect that AOO is more dedicated to voting because of the early massive lead LibreOffice had. In my opinion LibreOffice and AOO should be offered as 1 single choice because the products are so similar. We don't see the MS Office vote split between the various different bundles or different versions. It would be interesting to see how many in the Academics Section just carried on using whatever came with the machine rather than deliberately going out and getting the Student Edition of MSO. Machines seldom come with LibreOffice/AOO preinstalled so votes for them are from people that have found good reason NOT to stick with whatever they already had on their machine. Votes for MSO are often a vote to just a vote for inability, apathy, ignorance or even fear of their machine. MSO 'should' be winning in the votes because of the percentages of people using it and their resistance to change. The fact it isn't points more to apathy of MS users. Regards from Tom :) From: Marc Paré m...@marcpare.com To: users@global.libreoffice.org Sent: Saturday, 9 March 2013, 11:05 Subject: [libreoffice-users] Re: About.com Readers' Choice Awards 2013 for Office Software 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 nice if we won out on all categories where we appear! To vote, you can log in with your Facebook or About.com accounts or you can enter your email address in a field on the page. Here are the details: = = The Readers' Choice Awards 2013 for Office Software categories webpage can be found here: http://office.about.com/od/ReaderResponse/tp/About-Com-Readers-Choice-Awards-2013-For-Office-Software-Nominations.htm = = As of today, March 9 2013, LibreOffice ranking in the various Office Software Suites categories is: = Favorite Office Suite for Android: LIBREOFFICE does not have an official implementation of an Android version. Favorite Office Suite for Android: Google Docs/Apps 75% -- Quickoffice Pro HD 25% = Favorite Office Software Suite or App for iOS: LIBREOFFICE does not have an official implementation of an iOS version. Favorite Office Software Suite or App for iOS: Google Apps 66% -- iWork 22% -- Documents Free 11% = Favorite Office Software for Mac: LibreOffice 84% -- iWork 5% -- MSO 2% -- NeoOffice 7% = Favorite Office Software for Windows: LibreOffice 56% -- MSO 2% -- AOO 41% = Favorite Office Software for BlackBerry: LibreOffice 80% -- LibreOffice 80% *** NOTE THAT THERE IS NO VERSION OF LIBREOFFICE FOR BLACKBERRY YET WE ARE STILL LEADING!!! WEIRD! = Favorite Office Software for Business: LIBREOFFICE IS NOT ON THIS LIST!!! ITALO IS AWARE OF THIS. Favorite Office Software for Business: MSO 2% -- Google Docs/Apps 41% -- AOO 55% ??? WordPerfect 1% -- IMO strange as LibreOffice is most likely used in Business = Favorite Academic Software Suite: LIBREOFFICE IS NOT ON THIS LIST!!! ITALO IS AWARE OF THIS. Favorite Academic Software Suite: MSO Home and Student 11% -- Google Apps for Education 88% -- IMO, strange as LibreOffice is most likely used in education extensively!!! = Favorite Site for Office Software Templates: LibreOffice templates 58% -- MSO templates 1% -- OpenOffice 40% = Favorite Cloud Office Suite: LIBREOFFICE, at present, does not have an official Cloud implementation,
Re: [libreoffice-users] Currency conversion/display in calc
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, 6:00 Subject: [libreoffice-users] Currency conversion/display in calc 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, format it as currency and remove the ' that LO puts in front. Steve -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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
off-list Re: [libreoffice-users] Macros don't run
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 walked out the room leaving all the students wondering wtf was going on. The next week they arrived to find a note on the lecture halls door saying the lecture had been postponed. Same thing the week after and the week after that. On the 5th week they arrived to find the professor waiting and he wrote on the board It IS obvious that ... Regards from Tom :) From: Andrew Douglas Pitonyak and...@pitonyak.org To: users@global.libreoffice.org Sent: Saturday, 9 March 2013, 5:45 Subject: Re: [libreoffice-users] Macros don't run Does that mean that you have solved your problem / answered your own question? On 03/07/2013 08:39 AM, Malcolm Moore wrote: I think I may have sussed this one Ta M _ From: Malcolm Moore [mailto:st-malcolm.mo...@whsg.info] To: users@global.libreoffice.org Sent: Thu, 07 Mar 2013 12:18:30 + Subject: [libreoffice-users] Macros don't run If you have a macro assigned to a button in calc where there is only one sheet it works If calc has lots of sheets the macro doesn't run. Do I need to tell the macro which sheet it should be running on somehow Ta M -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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
Fwd: [libreoffice-users] Currency conversion/display in calc
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 Davies tomdavie...@yahoo.co.uk: 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. Yes, of course, but didn't he say he also want to paste? What about pasting a whole column from somewhere? Johnny Rosenberg Regards from Tom :) From: Steve Edmonds steve.edmo...@ptglobal.com To: users@global.libreoffice.org Sent: Saturday, 9 March 2013, 6:00 Subject: [libreoffice-users] Currency conversion/display in calc 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, format it as currency and remove the ' that LO puts in front. Steve -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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
Fwd: [libreoffice-users] Currency conversion/display in calc
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 conversion/display in calc To: Steve Edmonds steve.edmo...@ptglobal.com 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 this as a number. I found a long winded way, format it as currency and remove the ' that LO puts in front. Steve I think a macro could do that for you and I was even thinking of writing one, but if it should be useful no matter what locale settings you have, the macro needs to know things like decimal- and thousands separator (for example in my country we use space for thousands separator and comma for decimal separator, which is quite different from yours). I am sure it's possible but still searching… Johnny Rosenberg -- For unsubscribe instructions e-mail to: users+h...@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: Fwd: [libreoffice-users] Currency conversion/display in calc
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 users@global.libreoffice.org Sent: Saturday, 9 March 2013, 12:54 Subject: Fwd: [libreoffice-users] Currency conversion/display in calc 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 conversion/display in calc To: Steve Edmonds steve.edmo...@ptglobal.com 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 this as a number. I found a long winded way, format it as currency and remove the ' that LO puts in front. Steve I think a macro could do that for you and I was even thinking of writing one, but if it should be useful no matter what locale settings you have, the macro needs to know things like decimal- and thousands separator (for example in my country we use space for thousands separator and comma for decimal separator, which is quite different from yours). I am sure it's possible but still searching… Johnny Rosenberg -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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] Currency conversion/display in calc
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 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, format it as currency and remove the ' that LO puts in front. Steve -- *~~* Don C. Myers Manager, Farm and Rural Property Division e-PRO Certified by the National Association of Realtors Don's Cell Phone: 814-571-9518, Don's Home Phone: 814-422-8111 Don's E-mail: donmy...@myersfarm.com mailto:donmy...@myersfarm.com *RE/MAX Centre Realty **1375 Martin Street, State College, PA 16803* Office Phone: 814-231-8200 Fax: 814-231-8220 Visit the Farm and Rural Property Division web site at _www.CentralPaRuralProperty.com http://www.CentralPaRuralProperty.com/ _ Visit the RE/MAX Centre Realty main web site at _www.StateCollegeHomeSales.com http://www.statecollegehomesales.com/ _ View Don's Farm Web Site at www.myersfarm.com http://www.myersfarm.com/ *~~* -- For unsubscribe instructions e-mail to: users+h...@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: Fwd: [libreoffice-users] Currency conversion/display in calc
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, highlight a a table or something and then paste it into calc? Of course he could then do a Search/Replace to get rid of the thousands separator and the dollar sign, and form there it is probably quite a lot easier to do the rest. But it feels like that's at least one step too much… It's easy to create a macro that does all the necessary Search/Replace steps in one single step, though. Johnny Rosenberg Regards from Tom :) From: Johnny Rosenberg gurus.knu...@gmail.com To: LibreOffice Användare users@global.libreoffice.org Sent: Saturday, 9 March 2013, 12:54 Subject: Fwd: [libreoffice-users] Currency conversion/display in calc 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 conversion/display in calc To: Steve Edmonds steve.edmo...@ptglobal.com 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 this as a number. I found a long winded way, format it as currency and remove the ' that LO puts in front. Steve I think a macro could do that for you and I was even thinking of writing one, but if it should be useful no matter what locale settings you have, the macro needs to know things like decimal- and thousands separator (for example in my country we use space for thousands separator and comma for decimal separator, which is quite different from yours). I am sure it's possible but still searching… Johnny Rosenberg -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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] Currency conversion/display in calc
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, format it as currency and remove the ' that LO puts in front. Steve I use LO 3.6.5.2 from the LO website. When I write $2,441.99, Calc recognizes it as a currency. When I copy it and then paste it into a cell, I get the Import Options dialog. At its bottom is the Options and a box that should be checked any time the data contains special numbers such as dates, currencies, etc. So I have 2 ways to paste currency: click the box in the Option section, or paste special. However, if you have gotten you version of LO from a repository rather than from the LO website, your version may not have the Import Options dialog. --Dan -- For unsubscribe instructions e-mail to: users+h...@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] Macro Security Settings
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 tools-options--LibreOffice---Security--Macro Security to Low and it still gives me the same error and refuses to run the macro. Any help? Thank you in advance -- For unsubscribe instructions e-mail to: users+h...@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] Macro Security Settings
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 to run it. Or try with MS Office (although they might have changed API in past 10 years, in which case your macro will not run anyway). -- Best regards Mirosław Zalewski -- For unsubscribe instructions e-mail to: users+h...@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] Currency conversion/display in calc
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 this as a number. I found a long winded way, format it as currency and remove the ' that LO puts in front. Steve I think a macro could do that for you and I was even thinking of writing one, but if it should be useful no matter what locale settings you have, the macro needs to know things like decimal- and thousands separator (for example in my country we use space for thousands separator and comma for decimal separator, which is quite different from yours). I am sure it's possible but still searching… Johnny Rosenberg Thanks Johnny I thought easy enough with regexp but noticed that there are instructions on how to do it in excel so thought LO might too. Steve -- For unsubscribe instructions e-mail to: users+h...@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: Fwd: [libreoffice-users] Currency conversion/display in calc
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 :) From: Johnny Rosenberg gurus.knu...@gmail.com To: LibreOffice Användare users@global.libreoffice.org Sent: Saturday, 9 March 2013, 12:54 Subject: Fwd: [libreoffice-users] Currency conversion/display in calc 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 conversion/display in calc To: Steve Edmonds steve.edmo...@ptglobal.com 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 this as a number. I found a long winded way, format it as currency and remove the ' that LO puts in front. Steve I think a macro could do that for you and I was even thinking of writing one, but if it should be useful no matter what locale settings you have, the macro needs to know things like decimal- and thousands separator (for example in my country we use space for thousands separator and comma for decimal separator, which is quite different from yours). I am sure it's possible but still searching… Johnny Rosenberg -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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] Macro Security Settings
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 tools-options--LibreOffice---Security--Macro Security to Low and it still gives me the same error and refuses to run the macro. Did you restart LibreOffice after changing that setting? When does it complain? When you start the macro or when you open the file with LibreOffice? Exactly what does the error message say? For security reasons I think it's better to keep the highest level, just add paths in the ”Trusted sources” (or whatever it's called in English version) tab whenever LibreOffice complains about macro security. Johnny Rosenberg Any help? Thank you in advance -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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] Macro Security Settings
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 the security settings. I changed them in tools-options--LibreOffice---Security--Macro Security to Low and it still gives me the same error and refuses to run the macro. Did you restart LibreOffice after changing that setting? I did not. And that has resolved the problem. Thank you! I now have the problem Miroslaw has already commented on - star office vs. VBA. Ouch. I've received Basic runtime error 1. Is there a translation guide? This is not just a simple one line macro, this is a program of relatively large proportion - I estimate hundreds of lines of code. And I have others I will probably need to do the same. By the way, it sure would be nice if I could copy paste error messages directly from the error dialogs (the same way I was able to copy paste the version string), instead of having to retype them. Thank you -- For unsubscribe instructions e-mail to: users+h...@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] Macro Security Settings
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 try to run it, Libre Calc complains about the security settings. I changed them in tools-options--LibreOffice---Security--Macro Security to Low and it still gives me the same error and refuses to run the macro. Did you restart LibreOffice after changing that setting? I did not. And that has resolved the problem. Thank you! I now have the problem Miroslaw has already commented on - star office vs. VBA. Ouch. I've received Basic runtime error 1. Is there a translation guide? I'm not sure, I don't think so. I have never tried to load an Excel macro in LibreOffice and I didn't use Excel since I don't know when, 2006? Does it look like LibreOffice has tried to translate the macro somehow or does it look exactly like the original Excel macro? What does the line look like that currently is producing an error? Are there many lines like that? Andrew Pitonyak's macro document is a good start if you want to learn LibreOffice Basic macro programming. Search for AndrewMacro and you will find a PDF and an ODF (same document, different formats). Installing something called ”xray” is also a very good idea. It's a macro that helps you investigate objects, for example cell ranges, selections and much more. If you just want to know a couple of simple things, like how to get and set properties for a cell range, you can ask here if you can't find the answer by searching. Johnny Rosenberg This is not just a simple one line macro, this is a program of relatively large proportion - I estimate hundreds of lines of code. And I have others I will probably need to do the same. By the way, it sure would be nice if I could copy paste error messages directly from the error dialogs (the same way I was able to copy paste the version string), instead of having to retype them. Thank you -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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] Basic macro – How to get locale info?
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 -- For unsubscribe instructions e-mail to: users+h...@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] Macro Security Settings
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 C++. Regards from Tom :) From: Andrew apb5...@bak.rr.com To: users@global.libreoffice.org Sent: Saturday, 9 March 2013, 22:12 Subject: Re: [libreoffice-users] Macro Security Settings On 3/9/2013 12:42 PM, Johnny Rosenberg wrote: I now have the problem Miroslaw has already commented on - star office vs. VBA. Ouch. I've received Basic runtime error 1. Is there a translation guide? I'm not sure, I don't think so. I have never tried to load an Excel macro in LibreOffice and I didn't use Excel since I don't know when, 2006? Does it look like LibreOffice has tried to translate the macro somehow or does it look exactly like the original Excel macro? What does the line look like that currently is producing an error? Are there many lines like that? Andrew Pitonyak's macro document is a good start if you want to learn LibreOffice Basic macro programming. Search for AndrewMacro and you will find a PDF and an ODF (same document, different formats). Installing something called ”xray” is also a very good idea. It's a macro that helps you investigate objects, for example cell ranges, selections and much more. If you just want to know a couple of simple things, like how to get and set properties for a cell range, you can ask here if you can't find the answer by searching. Johnny Rosenberg This is not just a simple one line macro, this is a program of relatively large proportion - I estimate hundreds of lines of code. And I have others I will probably need to do the same. By the way, it sure would be nice if I could copy paste error messages directly from the error dialogs (the same way I was able to copy paste the version string), instead of having to retype them. I have this sinking feeling that converting to star basic is a step backwards in time, not forward. Is there any other *current* program this BASIC is compatible with? Or does this lock me into LibreOffice? Maybe I'd be better off converting to java if I'm going to do a major rewrite? Maybe the differences/changes are minor. I looked at the macro guide you mentioned and... well, it seems like it's a whole different language. Here is the first thing it errored out on. The set rng= statement. I include the entire subroutine so that you have some context. Since this is the entry point to my program I suppose you could just copy paste it to your own empty file called newinputs.xls and see what happens when you run it. Thank you Private Sub UserForm_Initialize() Dim rng As Range Dim myPath As String Dim appl As String Dim myName As String Dim lastRow As Integer Dim lastColumn As Integer Dim pro As Worksheet 'frmPropertyEntry.Hide dWidth = Me.Height appl = newinputs.xls myPath = ActiveWorkbook.Path myName = ActiveWorkbook.Name If myName appl Then MsgBox I'm confused! Please close myName before trying to run appl Exit Sub End If Set pro = ThisWorkbook.Worksheets(Processed) pro.Activate lastRow = pro.UsedRange.Rows.count lastColumn = pro.UsedRange.Columns.count *Set rng = pro.Range(b2, pro.Cells(lastRow, lastColumn).Address)* frmPropertyEntry.PropertyInfo.RowSource = vbNullString frmPropertyEntry.PropertyInfo.RowSource = rng.Address page = Processed Set rng = Nothing Set pro = Nothing 'frmPropertyEntry.Show (vbModeless) End Sub -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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] Currency conversion/display in calc
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 :) From: Steve Edmonds steve.edmo...@ptglobal.com To: Dan Lewis elderdanle...@gmail.com Cc: users@global.libreoffice.org Sent: Saturday, 9 March 2013, 21:41 Subject: Re: [libreoffice-users] Currency conversion/display in calc 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 number. I found a long winded way, format it as currency and remove the ' that LO puts in front. Steve I use LO 3.6.5.2 from the LO website. When I write $2,441.99, Calc recognizes it as a currency. When I copy it and then paste it into a cell, I get the Import Options dialog. At its bottom is the Options and a box that should be checked any time the data contains special numbers such as dates, currencies, etc. So I have 2 ways to paste currency: click the box in the Option section, or paste special. However, if you have gotten you version of LO from a repository rather than from the LO website, your version may not have the Import Options dialog. --Dan Thanks for the help. I may have figured it. If I copy and paste from a plain text document it works fine. If I copy and paste from another source, say a web page I have a problem. If I copy and paste into writer, and then copy again into calc I am fine. I think I have to do this to copy html tables from the web to calc. Cheers, Steve -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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: Currency conversion/display in calc
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: http://nabble.documentfoundation.org/Currency-conversion-display-in-calc-tp4042568p4042714.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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