[libreoffice-users] Re: spellcheck in calc

2011-08-01 Thread Andreas Säger
menu:ToolsOptions...LanguageSettingsLanguages... Locale settings are for numbers (for instance 1.23,99 vs 1,234.99 and 12/13/99 vs 13/12/99) Western Language refers to human language. Change the western language for newly generated documents or for your currently active template you

[libreoffice-users] Re: Python Equivalents for some BASIC uno calls

2011-08-01 Thread Andreas Säger
import uno form com.sun.star.sheet.CellFlags import FORMULA ThisComponent = XSCRIPTCONTEXT.getDocument() sh = ThisComponet.Sheets.getByIndex(0) oBasket = sh.queryContentCells(FORMULA) -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org Problems?

Re: [libreoffice-users] Re: Python Equivalents for some BASIC uno calls

2011-08-01 Thread Onyeibo Oku
Villeroy to the rescue! Thanks a lot sent from mobile device -Original Message- From: Andreas Säger ville...@t-online.de Date: Mon, 01 Aug 2011 00:07:46 To: users@global.libreoffice.org Reply-To: users@global.libreoffice.org Subject: [libreoffice-users] Re: Python Equivalents for some

Re: [libreoffice-users] Re: Code snippet

2011-08-01 Thread Onyeibo Oku
Com'on Andreas, please tell me I'm a coder. At least I try for an architect/CG-artist (could be better though). I came into programming from Visual BASIC (I know its procedural and limiting, let's not go there). I did a lot of VBA scripting for Excel then, mainly for result sheets which I'm

Re: [libreoffice-users] Python Equivalents for some BASIC uno calls

2011-08-01 Thread Onyeibo Oku
On 01/08/2011 02:57, Andrew Douglas Pitonyak wrote: I do believe that you have seen AndrewMacro, which contains an example that demonstrates that yes, you can. Just OR the values together. I likely show the same thing in OOME. I am currently working through the Calc chapter as time permits. I

Re: [libreoffice-users] Python Equivalents for some BASIC uno calls

2011-08-01 Thread Tom Davies
Hi :) Is it possible to write comments into a macro? Comments (that don't get executed) can help people reading the code to understand nuances more easily. Regards from Tom :) From: Onyeibo Oku twoho...@gmail.com To: users@global.libreoffice.org Cc: Andrew

Re: [libreoffice-users] Python Equivalents for some BASIC uno calls

2011-08-01 Thread Onyeibo Oku
Yes Put a '#' before the text to make it a comment sent from mobile device -Original Message- From: Tom Davies tomdavie...@yahoo.co.uk Date: Mon, 1 Aug 2011 12:34:14 To: users@global.libreoffice.org Reply-To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Python

[libreoffice-users] Calc: colour of negative numbers

2011-08-01 Thread Guy Voets
Hello, In LibO 3.3, I could make negative numbers show in white instead of the default red colour. I used white because of a green background, on which red numbers give a strange effect. In Lib 3.4, this [WHITE] code disappears from the Number Format Code, that goes back to #.##0,00:-#.##0,00

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-08-01 Thread Ian Whitfield
On 30/07/2011 19:37, Don C. Myers wrote: Magnificent!!! Thank you, ponsiarceds! I followed your instructions for having an older version of Java along side the present one. I'm running Ubuntu 11.04 with the LibreOffice version of 3.4.1. Now base works really fast like it always

Re: [libreoffice-users] Calc: colour of negative numbers

2011-08-01 Thread Guy Voets
Thanks Johnny! 2011/8/1 Johnny Rosenberg gurus.knu...@gmail.com: 2011/8/1 Guy Voets nimant...@gmail.com: Hello, In LibO 3.3, I could make negative numbers show in white instead of the default red colour. I used white because of a green background, on which red numbers give a strange

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-08-01 Thread Don C. Myers
Hi Ian, For some reason not all of the previous text I was responding to showed up in that post. This information I used was from a post from ponsiarceds. I'll paste everything below. Just make sure you are consistent with either jre or jdk in the instructions. The instructions have the two

Re: [libreoffice-users] Calc: colour of negative numbers

2011-08-01 Thread Johnny Rosenberg
2011/8/1 Guy Voets nimant...@gmail.com: Thanks Johnny! By the way: https://bugs.freedesktop.org/show_bug.cgi?id=37658 Regards Johnny Rosenberg ジョニー・ローゼンバーグ 2011/8/1 Johnny Rosenberg gurus.knu...@gmail.com: 2011/8/1 Guy Voets nimant...@gmail.com: Hello, In LibO 3.3, I could make

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-08-01 Thread Tom Cloyd
Some clarification: The JRE is sufficient (and smaller) if you just want to USE Base. I will absolutely attest to 1.6.0_21's being an order of magnatude faster than BOTH ...0_26 AND ...0_22, for me. The difference is very dramatic. Since running with ...0_21 my Base applications are simply

Re: [libreoffice-users] Word completion as a drop-down list like in IDEs ?

2011-08-01 Thread Tom Davies
Hi :) It might be worth posting a 'bug-report' about it but add [wishlist] into the subject line so that the devs know it is a feature request rather than a bug. This guide might have a better way of posting a feature request. http://wiki.documentfoundation.org/BugReport Regards from Tom

Re: [libreoffice-users] Re: QUESTION: Libreoffice documents constantly need recovery

2011-08-01 Thread Tom Davies
Hi :) Sometimes it is better to use the LibreOffice that is in the repositories because they have been tweaked for your specific distro. The .debs should work fine on all Debian family distros but sometimes it's better to have one fine-tuned to your specific distro. Which version of

[libreoffice-users] Re: Calc: colour of negative numbers

2011-08-01 Thread Andreas Säger
Am 01.08.2011 14:14, Guy Voets wrote: #.##0,00:[WHITE]-#.##0,00 is not a valid formatting code. Apart from the colon which should be a semicolon, WHITE is an English colour name while the comma can not be English. All English numerals use point decimals. The English number format

Re: [libreoffice-users] Problem with subscript in Impress

2011-08-01 Thread Tom Davies
Hi :) Have you tried NeoOffice for Mac? Also which version of LibreOffice are you using? The 3.3.3 should be the best but the ultra new 3.4.2 is worth trying. To install more than one version of OOo, LO or NeoOffice this guide might help

Re: [libreoffice-users] Problem with subscript in Impress

2011-08-01 Thread Regina Henschel
Hi Mårten, Mårten Behm schrieb: I am using Impress for lecturing in chemical engineering and subscripts in chemical formulae is a crucial feature. Have you tried to use a Math-object for your chemical formulas? You cannot insert it into a presentation object or a text object. But I use it

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-08-01 Thread planas
Ian, On Mon, 2011-08-01 at 17:36 +0200, Ian Whitfield wrote: On 30/07/2011 19:37, Don C. Myers wrote: Magnificent!!! Thank you, ponsiarceds! I followed your instructions for having an older version of Java along side the present one. I'm running Ubuntu 11.04 with the

Re: [libreoffice-users] Word completion as a drop-down list like in IDEs ?

2011-08-01 Thread Hoang Le
On Tue, Aug 2, 2011 at 12:30 AM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) It might be worth posting a 'bug-report' about it but add  [wishlist] into the subject line so that the devs know it is a feature request rather than a bug. This guide might have a better way of posting a