[libreoffice-users] LightProof behind LibreOffice
Hello, Am I correct to say that LightProof is the tool behind the grammar check function of LibreOffice 3.5? What should I do to modify or to add new grammar rules? What should I do to add grammar rules for another kind of language, not English? C. H. D. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ -- 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] Installing a vanilla copy of LO
Has anyone got any instruction for installing a vanilla copy of LO 3.6.something on openSuse Every time I try it ends up looking terrible and a bit like a Windows 95 app ;-( . OpenSuse's unstable repos are still at 3.6.1 -- 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] Installing a vanilla copy of LO
On 10/28/2012 09:10 AM, Malcolm Moore wrote: Has anyone got any instruction for installing a vanilla copy of LO 3.6.something on openSuse Every time I try it ends up looking terrible and a bit like a Windows 95 app ;-( . OpenSuse's unstable repos are still at 3.6.1 Have you looked at this page? http://www.libreoffice.org/get-help/installation/linux/ Under the section called: Installation of LibreOffice on Fedora, Suse, Mandriva and other Linux systems using RPM packages They talk about decompressing the file and then: quote: For other RPM-using systems (Suse, etc.): su rpm -Uvh *.rpm unquote: Then the page describes the installation of the desktop-integration file. I am not a user of a RPM installs, since I use Ubuntu. Yet, I find that the instructions on this page works well for me. -- 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: off-list Re: [libreoffice-users] Date changes to a 5 digit number
No computer access, but my guess its that the problem its that the format is set to an integer constant. The correct method is to lookup the format index and create the format if it does not exist. I would explain more, but my phone is slow to use for this. Will have better access in a few days if needed. There is an example in andrewmacro.odt I believe. Hth Sent from my Samsung Epic™ 4G Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) Looks like the code didn't get to the list so here it is REM * BASIC * Sub Main End Sub sub Insert_Line_and_Date rem -- rem define variables dim document as object dim dispatcher as object rem -- rem get access to the document document = ThisComponent.CurrentController.Frame dispatcher = createUnoService(com.sun.star.frame.DispatchHelper) rem -- dim args1(1) as new com.sun.star.beans.PropertyValue args1(0).Name = GraphicName args1(0).Value = args1(1).Name = IsSimpleLine args1(1).Value = true dispatcher.executeDispatch(document, .uno:InsertGraphicRuler, , 0, args1()) rem -- dim args2(5) as new com.sun.star.beans.PropertyValue args2(0).Name = Type args2(0).Value = 0 args2(1).Name = SubType args2(1).Value = 0 args2(2).Name = Name args2(2).Value = args2(3).Name = Content args2(3).Value = 0 args2(4).Name = Format args2(4).Value = 5122 args2(5).Name = Separator args2(5).Value = dispatcher.executeDispatch(document, .uno:InsertField, , 0, args2()) rem -- dim args3(0) as new com.sun.star.beans.PropertyValue args3(0).Name = Text args3(0).Value = , dispatcher.executeDispatch(document, .uno:InsertText, , 0, args3()) rem -- dim args4(1) as new com.sun.star.beans.PropertyValue args4(0).Name = Template args4(0).Value = Heading 1 args4(1).Name = Family args4(1).Value = 2 dispatcher.executeDispatch(document, .uno:StyleApply, , 0, args4()) end sub Regards from Tom :) From: . l...@ebookring.net To: Tom Davies tomdavie...@yahoo.co.uk Sent: Saturday, 27 October 2012, 18:37 Subject: Re: off-list Re: [libreoffice-users] Date changes to a 5 digit number Tom, Did my code message get to the list? I know you replied with it but it seems there's no option for me to reply to the list. Thanks, Carl On 10/27/2012 01:33 PM, Tom Davies wrote: snip / From: . l...@ebookring.net To: Tom Davies tomdavie...@yahoo.co.uk Sent: Saturday, 27 October 2012, 18:29 Subject: Re: [libreoffice-users] Date changes to a 5 digit number On 10/27/2012 01:06 PM, Tom Davies wrote: Hi :) Can you copypaste the macro's code into a reply as text? If we could see the code then some people here might be able to spot the error. Good luck and regards from Tom :) Here's the code- REM * BASIC * Sub Main End Sub sub Insert_Line_and_Date rem -- rem define variables dim document as object dim dispatcher as object rem -- rem get access to the document document = ThisComponent.CurrentController.Frame dispatcher = createUnoService(com.sun.star.frame.DispatchHelper) rem -- dim args1(1) as new com.sun.star.beans.PropertyValue args1(0).Name = GraphicName args1(0).Value = args1(1).Name = IsSimpleLine args1(1).Value = true dispatcher.executeDispatch(document, .uno:InsertGraphicRuler, , 0, args1()) rem -- dim args2(5) as new com.sun.star.beans.PropertyValue args2(0).Name = Type args2(0).Value = 0 args2(1).Name = SubType args2(1).Value = 0 args2(2).Name = Name args2(2).Value = args2(3).Name = Content args2(3).Value = 0 args2(4).Name = Format args2(4).Value = 5122 args2(5).Name = Separator args2(5).Value = dispatcher.executeDispatch(document, .uno:InsertField, , 0, args2()) rem -- dim args3(0) as new com.sun.star.beans.PropertyValue args3(0).Name = Text args3(0).Value = , dispatcher.executeDispatch(document, .uno:InsertText, , 0, args3()) rem
[libreoffice-users] WordNet for Spell and Grammar Check?
Hello, I don't know what kind of engine is the underlying tool for the spell check and grammar check features. Any ideas? Can WordNet be used for LibreOffice, according the license? Reference: http://wordnet.princeton.edu/wordnet/license/ C. H. D. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ -- 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] WordNet for Spell and Grammar Check?
On 10/28/2012 10:56 AM, webofht-libreoffice...@yahoo.com.hk wrote: Hello, I don't know what kind of engine is the underlying tool for the spell check and grammar check features. Any ideas? Can WordNet be used for LibreOffice, according the license? Reference: http://wordnet.princeton.edu/wordnet/license/ C. H. D. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ I was looking up various packages on my Ubuntu system. Aspell, Hunspell, Myspell, Mythes. When I type Myspell in the Ubuntu Software Center, LibreOffice comes up. I did some looking inside some of the spell checking dictionaries for LO and I see the WordNet license text file listed in a few. So there look like LO may be able to use some of the WordNet files. What types of files it can use, I do not know. I know some of the dictionary/thesaurus extensions are from a time when LO did not exist, so it was OpenOffice.org that used it. Now LO uses the same files and file formats for the dictionary/thesaurus/hyphenationformats. The only thing I really know about WordNet, is that the offline definition dictionary and thesaurus Artha uses WordNet as part of their system. I do not know what the file formats are for WordNet files. I just know what works for creating a spell checking dictionary extension out of a list of words to check. -- 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] Installing a vanilla copy of LO
Hi. On 2012-10-29 02:28, webmaster-Kracked_P_P wrote: On 10/28/2012 09:10 AM, Malcolm Moore wrote: Has anyone got any instruction for installing a vanilla copy of LO 3.6.something on openSuse Every time I try it ends up looking terrible and a bit like a Windows 95 app ;-( . OpenSuse's unstable repos are still at 3.6.1 Have you looked at this page? http://www.libreoffice.org/get-help/installation/linux/ Under the section called: Installation of LibreOffice on Fedora, Suse, Mandriva and other Linux systems using RPM packages They talk about decompressing the file and then: quote: For other RPM-using systems (Suse, etc.): su rpm -Uvh *.rpm unquote: Then the page describes the installation of the desktop-integration file. I am not a user of a RPM installs, since I use Ubuntu. Yet, I find that the instructions on this page works well for me. On opensuse I have always downloaded the RPMs, right click and install with YAST, in the correct sequence. I have not tried the 3.6 line. I installed the KDE integration also. Did you remove the Suse RPM completely. 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
[libreoffice-users] Fonts
Hi everyone, can you change the default font in Spreadsheet, and if so, how? -- 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] Fonts
Le 28/10/2012 21:06, jeremy heiser a écrit : Hi everyone, can you change the default font in Spreadsheet, and if so, how? Yes: create a template with the font you want and define this template as default template. Best regards. JBF -- Seuls des formats ouverts peuvent assurer la pérennité de vos documents. -- 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] Fonts
At 21:45 28/10/2012 +0100, Jean-Baptiste Faure wrote: Le 28/10/2012 21:06, Jeremy Heiser a écrit : can you change the default font in Spreadsheet, and if so, how? Yes: create a template with the font you want and define this template as default template. Note: 1. You will need to change the font of all sheets in your template separately. 2. Any new sheets you create in a spreadsheet created from the new template will still have the original default font, not your new modified font. Brian Barker -- 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] Installing a vanilla copy of LO
Hi :) Probably just haven't installed the Desktop Integration packages yet? In the .deb they are in a sub-folder after you uncompress the tarball. I would guess that the rpm version does something similar? Regards from Tom :) From: Steve Edmonds steve.edmo...@ptglobal.com To: webmaster-Kracked_P_P webmas...@krackedpress.com Cc: users@global.libreoffice.org Sent: Sunday, 28 October 2012, 19:37 Subject: Re: [libreoffice-users] Installing a vanilla copy of LO Hi. On 2012-10-29 02:28, webmaster-Kracked_P_P wrote: On 10/28/2012 09:10 AM, Malcolm Moore wrote: Has anyone got any instruction for installing a vanilla copy of LO 3.6.something on openSuse Every time I try it ends up looking terrible and a bit like a Windows 95 app ;-( . OpenSuse's unstable repos are still at 3.6.1 Have you looked at this page? http://www.libreoffice.org/get-help/installation/linux/ Under the section called: Installation of LibreOffice on Fedora, Suse, Mandriva and other Linux systems using RPM packages They talk about decompressing the file and then: quote: For other RPM-using systems (Suse, etc.): su rpm -Uvh *.rpm unquote: Then the page describes the installation of the desktop-integration file. I am not a user of a RPM installs, since I use Ubuntu. Yet, I find that the instructions on this page works well for me. On opensuse I have always downloaded the RPMs, right click and install with YAST, in the correct sequence. I have not tried the 3.6 line. I installed the KDE integration also. Did you remove the Suse RPM completely. 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
Re: [libreoffice-users] Installing a vanilla copy of LO
Well the answer to that question is on the Linux install page as well. You just have to use the proper file name[s]. http://www.libreoffice.org/get-help/installation/linux/ - 4) The above command(s) does the first part of the installation process. To complete the process, you also need to install the desktop integration packages. To do this, change directory to the desktop-integration directory that is within the RPMS directory, by entering the following command at the command line of a terminal window: cd desktop-integration Now run the installation command again: If you have a Suse system, execute this command: su -c 'rpm -Uvh install libreoffice3.3-suse-menus-3.3-1.noarch.rpm' - On 10/28/2012 06:59 PM, Tom Davies wrote: Hi :) Probably just haven't installed the Desktop Integration packages yet? In the .deb they are in a sub-folder after you uncompress the tarball. I would guess that the rpm version does something similar? Regards from Tom :) From: Steve Edmonds steve.edmo...@ptglobal.com To: webmaster-Kracked_P_P webmas...@krackedpress.com Cc: users@global.libreoffice.org Sent: Sunday, 28 October 2012, 19:37 Subject: Re: [libreoffice-users] Installing a vanilla copy of LO Hi. On 2012-10-29 02:28, webmaster-Kracked_P_P wrote: On 10/28/2012 09:10 AM, Malcolm Moore wrote: Has anyone got any instruction for installing a vanilla copy of LO 3.6.something on openSuse Every time I try it ends up looking terrible and a bit like a Windows 95 app ;-( . OpenSuse's unstable repos are still at 3.6.1 Have you looked at this page? http://www.libreoffice.org/get-help/installation/linux/ Under the section called: Installation of LibreOffice on Fedora, Suse, Mandriva and other Linux systems using RPM packages They talk about decompressing the file and then: quote: For other RPM-using systems (Suse, etc.): su rpm -Uvh *.rpm unquote: Then the page describes the installation of the desktop-integration file. I am not a user of a RPM installs, since I use Ubuntu. Yet, I find that the instructions on this page works well for me. On opensuse I have always downloaded the RPMs, right click and install with YAST, in the correct sequence. I have not tried the 3.6 line. I installed the KDE integration also. Did you remove the Suse RPM completely. 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
Re: [libreoffice-users] Problem sorting data in Calc 3.6.2 with headers
Thanks for reporting this bug. Here is where you can do it: https://www.libreoffice.org/get-help/bug/ On 2012-10-28 04:21, MR ZenWiz wrote: I originally reported this against 3.60 (I think), but now I have the refined detail. I do my expense balances in a spreadsheet with a header line. One of the columns is called What, which is how I categorize my expenses. If I sort the data and the first sort key is the What column, even though I select the Range contains column labels option, the sort includes the header line, which puts the header down near the bottom. This doesn't happen when I sort by the date column as the first sort key, just the alphabetical column. I'll report this as a bug if I can remember where to do that MR -- 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] Delete a Registered Database
Hello, In LibreOffice 3.5 Writer, how should I delete a registered database? Edit → Exchange Database... → Browse... → (Choose an ODF Spreadsheet file) → Define → Close Data Sources (or F4) → Right-click the left panel → Registered databases → (Choose a file) → Delete → OK (Restart LibreOffice) → Data Sources (or F4) → (The “registered database” is _not_ deleted.) Any ideas? C. H. D. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ -- 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] Delete a Registered Database
El 29/10/12 2:14, webofht-libreoffice...@yahoo.com.hk escribió: Hello, In LibreOffice 3.5 Writer, how should I delete a registered database? Edit → Exchange Database... → Browse... → (Choose an ODF Spreadsheet file) → Define → Close Data Sources (or F4) → Right-click the left panel → Registered databases → (Choose a file) → Delete → OK (Restart LibreOffice) → Data Sources (or F4) → (The “registered database” is _not_ deleted.) Any ideas? C. H. D. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Menu/Tools/Options/Database/LibreOffice Base or F4, right-click the base to delete the registration. This only delete the registration in LibreOffice. The .odb file with their data remains in the OS file system. -- 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] Installing a vanilla copy of LO
_ From: webmaster-Kracked_P_P [mailto:webmas...@krackedpress.com] To: users@global.libreoffice.org Sent: Sun, 28 Oct 2012 13:28:16 + Subject: Re: [libreoffice-users] Installing a vanilla copy of LO On 10/28/2012 09:10 AM, Malcolm Moore wrote: Has anyone got any instruction for installing a vanilla copy of LO 3.6.something on openSuse Every time I try it ends up looking terrible and a bit like a Windows 95 app ;-( . OpenSuse's unstable repos are still at 3.6.1 Have you looked at this page? http://www.libreoffice.org/get-help/installation/linux/ Under the section called: Installation of LibreOffice on Fedora, Suse, Mandriva and other Linux systems using RPM packages They talk about decompressing the file and then: quote: For other RPM-using systems (Suse, etc.): su rpm -Uvh *.rpm unquote: Then the page describes the installation of the desktop-integration file. I am not a user of a RPM installs, since I use Ubuntu. Yet, I find that the instructions on this page works well for me. -- 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 delet It installs and works using the RPMs it just looks terrible, I must be missing some themes or something. M -- 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] export to pdf does not carry over the file name of writer
When I export an LibO file (e.g. abcd.odt) to pdf, I would like that the original file name is automatically transferred to become the pdf-file name (e.g .abcd.pdf). At least in version 3.5.6.2 this was possible for a certain while, then this functionality disappeared and came back again. After upgrading to 3.5.7.2 the file name line appears blank when making an pdf-export. Is this a bug? Do I miss a setting somewhere? As I cannot find any information in the LO documentation etc., I ask you to please give me a hint how this can be done. -- 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] Fonts
Le 28/10/2012 23:27, Brian Barker a écrit : At 21:45 28/10/2012 +0100, Jean-Baptiste Faure wrote: Le 28/10/2012 21:06, Jeremy Heiser a écrit : can you change the default font in Spreadsheet, and if so, how? Yes: create a template with the font you want and define this template as default template. Note: 1. You will need to change the font of all sheets in your template separately. 2. Any new sheets you create in a spreadsheet created from the new template will still have the original default font, not your new modified font. No, if you use styles. Open an empty spreadsheet - F11 - select Default style - right clic - modify - Tab Font - make the changes you want - validate - save as template - menu File Templates Manage - select your new template - Commands button - define as default - validate - restart LO Best regards JBF -- Seuls des formats ouverts peuvent assurer la pérennité de vos documents. -- 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] Fonts
At 06:19 29/10/2012 +0100, Jean-Baptiste Faure wrote: No, if you use styles. Funny how you didn't mention them! Brian Barker -- 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