[libreoffice-users] Re: Presentation conversion to/from Powerpoint - layout
Am 28.02.2012 01:10, Roger Sawkins wrote: I have Powerpoint on one machine and LibreOffice on another. I want to be able to edit and save PowerPoints on either machine. Hello Roger, It is not supposed to work like this. LibreOffice is not a drop in replacement for any other software. You can import complex and proprietary foreign file formats in order to create your own ODF documents to work with. The import accuracy is fairly well with .doc and .xls, it is not so good with .ppt. Your ODF documents should be fully compatible across several applications. Of course MS will never really support ODF. They do not support any file format they do not control. If and only if you want to share an office file with a co-editor who can not install ODF capable software, then you may send him doc/xls/ppt copies of your ODF documents together with a PDF version so he/she can compare the intended layout in a PDF viewer with the actual layout in his software. First of all you should care about the fonts used in your documents. This office suite can not transfer any fonts embedded in the sent documents. If your font is not installed on the other machine, the overall look and pagination will differ for sure. Since you are writing about 2 of your own computers, I'd suggest to use the same software on both machines. Hope this helps, Andreas -- 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] Tell me it's not true
Thanks Andreas, Unfortunately this isn't for a form, it's for a report. Mebbe I'll start having a look at that code, being on Linux you're other suggestion doesn't help me :-( Regards Mark Stanton One small step for mankind... -- 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: Relationships in Base
See my previous post on how I solved the problem. You suggested that I view Chpt 8 in the Getting Started Guide. Have done that. Question: Why is there NOT a separate guide for Base like there is for the others, ie Writer,Calc,etc? Question2: What are the parts of LO, ie Writer,Base,Calc called? Applications, modules or what? Thanks -- View this message in context: http://nabble.documentfoundation.org/Relationships-in-Base-tp3780236p3783630.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
[libreoffice-users] How to use GTK open dialog box in LibreOffice
Hello, I have LibreOffice on Debian, with Mate desktop. I would like LibreOffice to use GTK open dialog box in LibreOffice, instead of its own dialog box. I've got libreoffice-gtk and libreoffice-gnome packages installed, but I don't have the option in Tools -- General. LibreOffice only shows me its own open/save dialog box. Can anyone help me to set it ? Thank you, -- Arnaud Champollion -- 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: Tell me it's not true
Am 28.02.2012 11:27, Mark Stanton wrote: Thanks Andreas, Unfortunately this isn't for a form, it's for a report. Mebbe I'll start having a look at that code, being on Linux you're other suggestion doesn't help me :-( Regards Mark Stanton One small step for mankind... Create a brand new database (relational, embedded HSQLDB). Drag the table icons from your dBase connection into the new database. Do what you want in the new database. Note: HSQL tables need a primary key in order to be editable. -- 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: Relationships in Base
Hi :) The separate Base Guide is being worked on but there is only about 1 person working on it with occasional help from 1 other person who does the proof-reading. You can see some of the draft chaters at http://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Guide Sorry this is still not particularly help Apols and regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/Relationships-in-Base-tp3780236p3783728.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
Re: [libreoffice-users] Re: Relationships in Base
Tue, 2012-02-28 at 02:44 -0800, gerbreown wrote: See my previous post on how I solved the problem. You suggested that I view Chpt 8 in the Getting Started Guide. Have done that. Question: Why is there NOT a separate guide for Base like there is for the others, ie Writer,Calc,etc? Question2: What are the parts of LO, ie Writer,Base,Calc called? Applications, modules or what? Thanks 1) Very few people in the world are willing to take the time to write the Base Guide. There are many more people who have worked on the other user guides. 2) I'm not sure that there is a consensus for the answer to this question. When speaking of the parts of LO software, modules have been used. But when speaking of the the functions of the software, components have been use. For example, Writer is the word processing component. Perhaps someone else knows the answer to this one. --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
Re: [libreoffice-users] Re: Relationships in Base
Hi :) +1 I tend to call them apps most of the time but modules when i am being pedantic. When talking to Windows users i sometimes call them programs as tho they were independent of each other. It depends on how computer-savvy the person i'm talking to is. Regards from Tom :) --- On Tue, 28/2/12, Dan Lewis elderdanle...@gmail.com wrote: From: Dan Lewis elderdanle...@gmail.com Subject: Re: [libreoffice-users] Re: Relationships in Base To: users@global.libreoffice.org Date: Tuesday, 28 February, 2012, 11:46 Tue, 2012-02-28 at 02:44 -0800, gerbreown wrote: See my previous post on how I solved the problem. You suggested that I view Chpt 8 in the Getting Started Guide. Have done that. Question: Why is there NOT a separate guide for Base like there is for the others, ie Writer,Calc,etc? Question2: What are the parts of LO, ie Writer,Base,Calc called? Applications, modules or what? Thanks 1) Very few people in the world are willing to take the time to write the Base Guide. There are many more people who have worked on the other user guides. 2) I'm not sure that there is a consensus for the answer to this question. When speaking of the parts of LO software, modules have been used. But when speaking of the the functions of the software, components have been use. For example, Writer is the word processing component. Perhaps someone else knows the answer to this one. --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 -- 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] Presentation conversion to/from Powerpoint - layout
Hi :) It might be better to convert to Odp and then it should look the same on both machines. According to Microsoft you can expect differences in the way documents are displayed between their different operating systems. A file produced in MS Office 2010 on Xp might well look different if it's displayed in MS Office 2010 on Win7 even if they use the same printer and all settings are as close as they can be. Odp tends to look the same. Usually the older formats tend to work better, Ppt rather than PptX or Odp 1.1 rather than the default Odp 1.2 (Extended). If you really need things to look exactly the same then an uneditable format such as Pdf would be better. Regards from Tom :) --- On Tue, 28/2/12, Roger Sawkins ro...@sawkins.name wrote: From: Roger Sawkins ro...@sawkins.name Subject: [libreoffice-users] Presentation conversion to/from Powerpoint - layout To: users@global.libreoffice.org Date: Tuesday, 28 February, 2012, 0:10 I have Powerpoint on one machine and LibreOffice on another. I want to be able to edit and save PowerPoints on either machine. However, when loading Ppt in Presentation it does not always convert font and layout properly. Occasional tabs or spaces are missing or duplicated; occasional text boxes have text outside the slide, etc. Then when I then save the presentation as ppt it changes the font, for example, from bold to basic and shows tabs or spaces (see above) as missing. Is there some way of ensuring that the conversions are consistent and presentations can be switched back and forth? As a separate issue, in some cases Presentation show jpg's as sqeezed in the slide listing on the left, although they are OK when I click on the slide or when I do the show. Roger -- View this message in context: http://nabble.documentfoundation.org/Presentation-conversion-to-from-Powerpoint-layout-tp3782543p3782543.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 -- 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: Tell me it's not true
Hi :) So is the problem just with 1 type of connector and 1 type of back-end? Regards from Tom :) --- On Mon, 27/2/12, Andreas Säger ville...@t-online.de wrote: From: Andreas Säger ville...@t-online.de Subject: [libreoffice-users] Re: Tell me it's not true To: users@global.libreoffice.org Date: Monday, 27 February, 2012, 22:54 Am 27.02.2012 23:38, Mark Stanton wrote: When I select the dBase connector it seems to say that queries cannot contain more than one table. Tekll me it's not true... Mark Stanton One small step for mankind... Sadly, this is true. You may use a hierarchy of forms and subforms to mimic relations on form level (display records in subform that are related to the selected item in the parent form). You may use another dBase driver. If I remember correctly, there is one for Windows ODBC. -- 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] Unprotecting table cells
Hi! I've read many questions and answers regarding unprotection of table cells, however none of the replies I have seen worked in my case. When I try to edit a table cell text, I get the famous popup saying Readonly content cannot be changed. No modifications will be accepted. However, I can edit the content of some of the other cells in the same table. I do have read-write permission on the filesystem level. As mentioned, I can edit some other parts of the document. There is no unprotect option in the cell submenu on the right-click context menu in the cell. It only says No selection possible in greyed out text. Format - Sections is greyed out, so I have no access to any security settings there. The file properties shows that the document has no password protection. Nothing is activated on the Security tab there. One reply mentioned something about Design Mode, but I could not edit the text after activating that either. I'm using Libreoffice 3.4.5 OOO340m1 (Build:502) on Debian Sid Linux. Any ideas? This is often a problem for me when filling out downloadable forms with Libreoffice. Does it have some sort of Make everything editable option? That would have saved me many hours... Best regards, Torquil Sørensen -- 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] Calc broke my document
Hi :) Can you post a bug-report about your problem? http://wiki.documentfoundation.org/BugReport Regards from Tom :) --- On Mon, 27/2/12, Ferry Toth ft...@telfort.nl wrote: From: Ferry Toth ft...@telfort.nl Subject: [libreoffice-users] Calc broke my document To: users@global.libreoffice.org Date: Monday, 27 February, 2012, 22:04 A spreadsheet (ods) I have been using a while broke, and now Calc won't open it. Also alternatives refuse to open it. Passing it through http://odf-validator.rhcloud.com/ led to the following result (note the *Fatal*) below. Now I know that I can unzip the document, search for the offending attribute, delete this and rezip - and of course that didn't work. The point is, in 6 years that I use OO, and LO intensively I never had this before. And recently I saw other mentions on this list of broken Calc spreadsheets. I think there is a regression in Calc. I am using LO 3.4.4 from Ubuntu. Ferry Validator results below *** The document is NOT conformant ODF1.2! Details: Betalingen 2012.ods: Info: ODF version of root document: 1.2 internal:/schema/odf1.2/OpenDocument-v1.2-cos01-manifest-schema.rng: Info: parsed. Betalingen 2012.ods/META-INF/manifest.xml: Info: no errors, no warnings Betalingen 2012.ods/mimetype: Info: no errors, no warnings Betalingen 2012.ods: Info: Media Type: application/vnd.oasis.opendocument.spreadsheet internal:/schema/odf1.2/OpenDocument-v1.2-cos01-schema.rng: Info: parsed. Betalingen 2012.ods/meta.xml: Info: Generator: LibreOffice/3.4$Unix LibreOffice_project/340m1$Build-402 Betalingen 2012.ods/meta.xml: Info: no errors, no warnings Betalingen 2012.ods/settings.xml: Info: no errors, no warnings Betalingen 2012.ods/styles.xml[2,25749]: Error: unexpected attribute style:scale-to-X Betalingen 2012.ods/styles.xml: Info: 1 errors, no warnings Betalingen 2012.ods/content.xml[2,19097]: Error: attribute style:vertical-align has a bad value. Possible values are: automatic,bottom,middle,top Betalingen 2012.ods/content.xml[2,19520]: Error: attribute style:vertical-align has a bad value. Possible values are: automatic,bottom,middle,top Betalingen 2012.ods/content.xml[2,23292]: Error: unexpected attribute style:vertical-justify Betalingen 2012.ods/content.xml[2,24719]: Error: attribute style:vertical-align has a bad value. Possible values are: automatic,bottom,middle,top Betalingen 2012.ods/content.xml[2,28322]: Error: unexpected attribute style:vertical-justify Betalingen 2012.ods/content.xml[2,29008]: Error: unexpected attribute style:vertical-justify Betalingen 2012.ods/content.xml[2,29665]: Error: unexpected attribute style:vertical-justify Betalingen 2012.ods/content.xml[2,176262]: Error: element text:a is missing type attribute Betalingen 2012.ods/content.xml[2,429302]: Error: element text:a is missing type attribute Betalingen 2012.ods/content.xml[2,550174]: Error: element text:a is missing type attribute Betalingen 2012.ods/content.xml[2,671039]: Fatal: Attribute end-cell-address bound to namespace urn:oasis:names:tc:opendocument:xmlns:table:1.0 was already specified for element table:table-cell. Betalingen 2012.ods/content.xml: Info: 11 errors, no warnings internal:/schema/odf1.2/OpenDocument-v1.2-cos01-dsig-schema.rng: Info: parsed. Betalingen 2012.ods: Info: 12 errors, no warnings -- 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] Re: LibreOffice 3.5.0 Template problem
Hi :) Congrats! Nicely done! :)) Renaming the user Profile often fixes all sorts of weird things. Deleting also works but then you wouldn't have a back-up of all the Extensions and stuff. You kinda covered some of that by backing-up the templates folder which was pretty cool. So, congrats and regards from Tom :) --- On Sun, 26/2/12, branko-4 bhorv...@gmail.com wrote: From: branko-4 bhorv...@gmail.com Subject: [libreoffice-users] Re: LibreOffice 3.5.0 Template problem To: users@global.libreoffice.org Date: Sunday, 26 February, 2012, 15:04 I solved it so I deleted the folder (C: \ Documents and Settings \ x \ Application Data \ LibreOffice). Error message no longer appears. Look out, so all settings are cleared. Before deleting I just saved templates folder. -- View this message in context: http://nabble.documentfoundation.org/LibreOffice-3-5-0-Template-problem-tp3776869p3777064.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 -- 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: Unprotecting table cells
This is the same in OpenOffice.org, LibreOffice, Excel, Gnumeric and other spreadsheet programs. menu:ToolsProtectionSheet=OFF opens the locks of all the cells on that sheet having a lock attached. Now you can edit any cell. FormatCellsTab:Protection allows you to add or remove a lock to selected cells. Cells without a lock remain editable when sheet protection closes all cell locks. By default all cells have a lock, so the sheet protection locks all cell. You have to remove the locks from those cells you want to keep editable. -- 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] Unprotecting table cells
On Tue, 28 Feb 2012 14:18:42 +0100 Torquil Macdonald Sørensen torq...@gmail.com wrote: Hello Torquil, Any ideas? This is often a problem for me when filling out downloadable forms with Libreoffice. Does it have some sort of Make everything editable option? That would have saved me many hours... It might be Tools menu -- Protect Document... -- Regards _ / ) The blindingly obvious is / _)radnever immediately apparent I hit the ground, boy have I arrived! The History Of The World (Part 1) - The Damned -- 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: Calc broke my document
With all the given information about the flaws in your content.xml it should be possible to fix the file mainly by removing some format attributes. -- 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] Unprotecting table cells
On 28/02/12 14:47, Brad Rogers wrote: On Tue, 28 Feb 2012 14:18:42 +0100 Torquil Macdonald Sørensentorq...@gmail.com wrote: Hello Torquil, Any ideas? This is often a problem for me when filling out downloadable forms with Libreoffice. Does it have some sort of Make everything editable option? That would have saved me many hours... It might be Tools menu -- Protect Document... Hi Brad! I don't seem to have that menu item. Thanks anyway! :-) For clarification, I'm talking about a table in a Libreoffice Writer document. Best regards Torquil Sørensen -- 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: Unprotecting table cells
On 28/02/12 14:48, Andreas Säger wrote: This is the same in OpenOffice.org, LibreOffice, Excel, Gnumeric and other spreadsheet programs. menu:ToolsProtectionSheet=OFF opens the locks of all the cells on that sheet having a lock attached. Now you can edit any cell. FormatCellsTab:Protection allows you to add or remove a lock to selected cells. Cells without a lock remain editable when sheet protection closes all cell locks. By default all cells have a lock, so the sheet protection locks all cell. You have to remove the locks from those cells you want to keep editable. Oops, I'm talking about a table in the Libreoffice Writer program. Not a spreadsheet. As I understand it, your explanation is only in the context of a spreadsheet? As far as I can see, I cannot follow your procedure in Writer. But thanks anyway, and sorry for causing confusion! Best regard, Torquil Sørensen -- 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] Tell me it's not true
This is a very old bug with lots of people urgently wanting something done about it: https://issues.apache.org/ooo/show_bug.cgi?id=42464 -- 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] Unprotecting table cells
On Tue, 28 Feb 2012 15:17:35 +0100 Torquil Macdonald Sørensen torq...@gmail.com wrote: Hello Torquil, I don't seem to have that menu item. Thanks anyway! :-) For clarification, I'm talking about a table in a Libreoffice Writer document. Ah, I didn't realise. Yes, my, and Andreas' solutions are for Calc. -- Regards _ / ) The blindingly obvious is / _)radnever immediately apparent Does she always shout at you, does she tell you what to do Family Life - Sham 69 -- 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] Unprotecting table cells
On 28/02/12 15:40, Brad Rogers wrote: On Tue, 28 Feb 2012 15:17:35 +0100 Torquil Macdonald Sørensentorq...@gmail.com wrote: Hello Torquil, I don't seem to have that menu item. Thanks anyway! :-) For clarification, I'm talking about a table in a Libreoffice Writer document. Ah, I didn't realise. Yes, my, and Andreas' solutions are for Calc. I hope my problem is not the same as this: http://user.services.openoffice.org/en/forum/viewtopic.php?f=7t=19668 That one seems to be unsolvable without having access to MS Word: As of this moment the bug still exists in OO 3.1.1 for Windows, I haven't checked my Linux or Mac systems yet. OO Writer honours the protection status of a document but doesn't have any way of changing it. If a document has been locked in MS Word there is no way to unlock it without passing it through a copy of Word. My document was originally a *.doc, probably created in MS Word. When I saved my first modified version, I let Libreoffice save it as an ODT-file. Best regards, Torquil Sørensen -- 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: Tell me it's not true
Am 28.02.2012 12:09, John Talbut wrote: This is a very old bug with lots of people urgently wanting something done about it: https://issues.apache.org/ooo/show_bug.cgi?id=42464 That issue refers to the fact that you can only connect one database per database document. This topic is about joining tables of the same dBase source. SELECT * FROM A JOIN B ON A.F1 = B.F1 SELECT * FROM A,B WHERE A.F1 = B.F1 which is impossible in any of the file based database connections. The former Base developers did not recognize the importance of dBase. -- 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] Can several instances of soffice be run in parallel?
I have the following issue on my Intel i7 920 processor with Windows 7 x64 pro system: About the background: I have several documents opened in Libreoffice Calc, Writer and so on, but whenever I try to open a large CSV file (ie: 20MB in size) the entire Libreoffice suite becomes unresponsive until the Calc has finished opening the CSV file. It would seem each instance of Calc, write and so on rely only on the single soffice.bin application. During the opening of the CSV file, soffice.bin uses only 1 thread thus stalling all the other instance of Libreoffice. Solutions: Is there a way to enable Libreoffice to run multi-threaded, or simply to have Calc, Writer use a dedicated instance of soffice.bin? -- View this message in context: http://nabble.documentfoundation.org/Can-several-instances-of-soffice-be-run-in-parallel-tp3784375p3784375.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
[libreoffice-users] Re: Unprotecting table cells
On 28/02/12 14:18, Torquil Macdonald Sørensen wrote: Hi! I've read many questions and answers regarding unprotection of table cells, however none of the replies I have seen worked in my case. When I try to edit a table cell text, I get the famous popup saying Readonly content cannot be changed. No modifications will be accepted. However, I can edit the content of some of the other cells in the same table. I do have read-write permission on the filesystem level. As mentioned, I can edit some other parts of the document. There is no unprotect option in the cell submenu on the right-click context menu in the cell. It only says No selection possible in greyed out text. Format - Sections is greyed out, so I have no access to any security settings there. The file properties shows that the document has no password protection. Nothing is activated on the Security tab there. One reply mentioned something about Design Mode, but I could not edit the text after activating that either. I'm using Libreoffice 3.4.5 OOO340m1 (Build:502) on Debian Sid Linux. Any ideas? This is often a problem for me when filling out downloadable forms with Libreoffice. Does it have some sort of Make everything editable option? That would have saved me many hours... Best regards, Torquil Sørensen Hi, me! Abiword was able to edit the read-only parts of the document, so I'm happy now :-) I still welcome suggestions here on how to achieve this in Libreoffice Writer. Best regards Torquil -- 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: Can several instances of soffice be run in parallel?
Am 28.02.2012 16:37, Apollo wrote: Is there a way to enable Libreoffice to run multi-threaded, or simply to have Calc, Writer use a dedicated instance of soffice.bin? I can run LibO 3.3.x and 3.5 and OpenOffice.org in parallel. If the same office occurs twice in your task manager you should save your work and kill all instances because this state is rather unstable. -- 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] Presentation conversion to/from Powerpoint - layout
On 28/02/2012, Roger Sawkins ro...@sawkins.name wrote: I have Powerpoint on one machine and LibreOffice on another. I want to be able to edit and save PowerPoints on either machine. However, when loading Ppt in Presentation it does not always convert font and layout properly. Occasional tabs or spaces are missing or duplicated; occasional text boxes have text outside the slide, etc. Your are wasting your time. Make a cost-benefit analysis and decide whether to use either LO or m$; do not bother trying to use both. Then when I then save the presentation as ppt it changes the font, for example, from bold to basic and shows tabs or spaces (see above) as missing. This is because m$ has no desire to use odf. To prove the point, create an odp (two versions, one odf11, another odf12) document using LO. Open the odp document using m$. Send details of the changes to the odp file that m$ causes, to m$ technical support. Tell us the results of your contact with m$. Is there some way of ensuring that the conversions are consistent and presentations can be switched back and forth? Never in a million years. -- 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] Libreoffice 3.5
On 27/02/2012, MoolsM mools.marin...@gmail.com wrote: I'm currently running Windows Vista. A mistake... When I click on the icon I get some startup details and then a windows message saying L.O has stopped working. Tried a few cycles of un-install and reinstall but keep getting the same problem. Any thoughts? Please contact m$ and tell us your experience. -- 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] Calc broke my document
On 27/02/2012, Ferry Toth ft...@telfort.nl wrote: I think there is a regression in Calc. I am using LO 3.4.4 from Ubuntu. If so please file a bug report. If this bug does not occur with a previous version of LO, please propose this behaviour as a potential manual test (see: http://www.mail-archive.com/users@global.libreoffice.org/msg17418.html) -- 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] Presentation conversion to/from Powerpoint - layout
On 28/02/2012, e-letter inp...@gmail.com wrote: On 28/02/2012, Roger Sawkins ro...@sawkins.name wrote: I have Powerpoint on one machine and LibreOffice on another. I want to be able to edit and save PowerPoints on either machine. However, when loading Ppt in Presentation it does not always convert font and layout properly. Occasional tabs or spaces are missing or duplicated; occasional text boxes have text outside the slide, etc. Your are wasting your time. Make a cost-benefit analysis and decide whether to use either LO or m$; do not bother trying to use both. Sorry for the terrible English; should read: You are... Then when I then save the presentation as ppt it changes the font, for example, from bold to basic and shows tabs or spaces (see above) as missing. This is because m$ has no desire to use odf. To prove the point, create an odp (two versions, one odf11, another odf12) document using LO. Open the odp document using m$. Send details of the changes to the odp file that m$ causes, to m$ technical support. Tell us the results of your contact with m$. Is there some way of ensuring that the conversions are consistent and presentations can be switched back and forth? Never in a million years. -- 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] Tell me it's not true
I'm only talking about the dBase connector. It sounds like there may be more to it than that from Andreas' reply, but I don't think it's anything major to worry about, except the dBase connector :-( I'll have a look Mark Stanton One small step for mankind... -- 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] Tell me it's not true
That'll be a good stopgap, thanks. What I'm trying to do is migrate slowly over from the dBase (VFP really) application that (I wrote that) runs one of our businesses, so just producing output with LO while still using FoxPro would be good. I'll have a look at the code, but it looks like you're saying it's a slightly wider scope than just dBase. Don't hold your breath :-) Regards Mark Stanton One small step for mankind... -- 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] Specialized dictionary
I have a project to make display labels for a mineral museum. Does anyone know of a source for a specialized dictionary of mineral and chemical names that can be used with LO? Jerry -- 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: Tell me it's not true
Am 28.02.2012 18:08, Mark Stanton wrote: That'll be a good stopgap, thanks. I'll have a look at the code, but it looks like you're saying it's a slightly wider scope than just dBase. Don't hold your breath :-) We get editable relations from relational database servers if the connecting database driver supports this. So called file based databases are: dBase, plain text (csv), spreadsheets, mail client address books, LDAP provide a minumum of functionality, mainly because most of them are no databases at all. dBase is the only editable and indexable type of file based database and the built-in driver should support relations as well. File based databases are important sources for mail merge. Spreadsheets are most commonly used but worst choice. Supported SQL functions of file based databases: http://www.openoffice.org/dba/specifications/file_based_functions.html -- 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] Presentation conversion to/from Powerpoint - layout
Hi :) We successfully use MS Office alongside LibreOffice and it works out quite well. We tend to keep each document in one or the other rather than trying to convert the documents to-and-fro. So, for out newsletter we use LO because it's better with graphics and seems happier with larger (byte-wise) documents. Clients occasionally send us things in odf format. Unfortunately we have a couple of crucial documents with macros that were written for MSO 2010. Also people are wowed by the ribbon-bar and think that if something was that expensive and that much of a hassle to install then it must be great. So, we stick to having both because they each provide something useful that the other doesn't. If you are having troubles in getting permissions to install LibreOffice on the other machine then perhaps try it as a portable app on a usb-stick http://www.libreoffice.org/download/portable/ This allows you to customise LibreOffice and then just plug the usb-stick into any machine to use your customisations. Regards from Tom :) --- On Tue, 28/2/12, e-letter inp...@gmail.com wrote: From: e-letter inp...@gmail.com Subject: Re: [libreoffice-users] Presentation conversion to/from Powerpoint - layout To: users@global.libreoffice.org Date: Tuesday, 28 February, 2012, 16:51 On 28/02/2012, e-letter inp...@gmail.com wrote: On 28/02/2012, Roger Sawkins ro...@sawkins.name wrote: I have Powerpoint on one machine and LibreOffice on another. I want to be able to edit and save PowerPoints on either machine. However, when loading Ppt in Presentation it does not always convert font and layout properly. Occasional tabs or spaces are missing or duplicated; occasional text boxes have text outside the slide, etc. Your are wasting your time. Make a cost-benefit analysis and decide whether to use either LO or m$; do not bother trying to use both. Sorry for the terrible English; should read: You are... Then when I then save the presentation as ppt it changes the font, for example, from bold to basic and shows tabs or spaces (see above) as missing. This is because m$ has no desire to use odf. To prove the point, create an odp (two versions, one odf11, another odf12) document using LO. Open the odp document using m$. Send details of the changes to the odp file that m$ causes, to m$ technical support. Tell us the results of your contact with m$. Is there some way of ensuring that the conversions are consistent and presentations can be switched back and forth? Never in a million years. -- 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] Unprotecting table cells
On Tue, 28 Feb 2012 15:53:00 +0100 Torquil Macdonald Sørensen torq...@gmail.com wrote: Hello Torquil, I hope my problem is not the same as this: http://user.services.openoffice.org/en/forum/viewtopic.php?f=7t=19668 That one seems to be unsolvable without having access to MS Word: That seems to be the most likely probability, unfortunately. :-( -- Regards _ / ) The blindingly obvious is / _)radnever immediately apparent It couldn't adapt so it couldn't survive The Great British Mistake - The Adverts -- 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] Closing calc documents
On SOME occasions (not all), after I close a calc doc, my Windows Explorer still shows it as open. To remove the lock-file name entry in Explorer, I must reopen the doc and close it again. This usually gets the job done. Is this a bug, or am I not closing the doc properly? I usually hit the big red X to close (but sometimes the little black X to just close the doc and not calc. LibreOffice 3.3 Windoes XL Pro Thanks for your help! Al -- View this message in context: http://nabble.documentfoundation.org/Closing-calc-documents-tp3785063p3785063.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
[libreoffice-users] Re: Libreoffice 3.5
Hi :) I think it might just be that you have to reboot your machine after an install. Also after an uninstall. Remember this from the early days of Xp? http://nabble.documentfoundation.org/file/n3785115/mouse-reboot.jpg mouse-reboot.jpg Not a genuine message of course but it felt about right at the time. Instead of uninstalling perhaps try just renaming your User Profile as that does what most people expect an uninstallreinstall to do http://wiki.documentfoundation.org/Documentation/UserProfile Also with Vista it has some strange permissions thing that tries to block unwanted events from happening so perhaps it's the UAE or something blocking the install? Perhaps try downloading LIbreOffice 3.4.5 from the official web-site http://www.libreoffice.org/download/?type=win-x86lang=en-US I got there by choosing the option Change system, version or language - and then choose US as the language. Good luck and regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/Libreoffice-3-5-tp3781541p3785115.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
Re: [libreoffice-users] Re: Unprotecting table cells
Hi :) Brilliant, nicely done :) It would be nice to have protect/unprotect and password protection working in MS formats the way that it is meant to in MS Office. Perhaps time to post a feature request? http://wiki.documentfoundation.org/BugReport Don't worry if you don't have time or if e-letter's type of attitude puts you off. Regards from Tom :) --- On Tue, 28/2/12, Torquil Macdonald Sørensen torq...@gmail.com wrote: From: Torquil Macdonald Sørensen torq...@gmail.com Subject: [libreoffice-users] Re: Unprotecting table cells To: users@global.libreoffice.org Date: Tuesday, 28 February, 2012, 15:43 On 28/02/12 14:18, Torquil Macdonald Sørensen wrote: Hi! I've read many questions and answers regarding unprotection of table cells, however none of the replies I have seen worked in my case. When I try to edit a table cell text, I get the famous popup saying Readonly content cannot be changed. No modifications will be accepted. However, I can edit the content of some of the other cells in the same table. I do have read-write permission on the filesystem level. As mentioned, I can edit some other parts of the document. There is no unprotect option in the cell submenu on the right-click context menu in the cell. It only says No selection possible in greyed out text. Format - Sections is greyed out, so I have no access to any security settings there. The file properties shows that the document has no password protection. Nothing is activated on the Security tab there. One reply mentioned something about Design Mode, but I could not edit the text after activating that either. I'm using Libreoffice 3.4.5 OOO340m1 (Build:502) on Debian Sid Linux. Any ideas? This is often a problem for me when filling out downloadable forms with Libreoffice. Does it have some sort of Make everything editable option? That would have saved me many hours... Best regards, Torquil Sørensen Hi, me! Abiword was able to edit the read-only parts of the document, so I'm happy now :-) I still welcome suggestions here on how to achieve this in Libreoffice Writer. Best regards Torquil -- 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] How to use GTK open dialog box in LibreOffice
Hi It seems that LO fails to recognize MATE as GNOME/GTK-based desktop. You can try running LO like that: OOO_FORCE_DESKTOP=gnome libreoffice This way I was able to force GNOME file-picker on my KDE box. If you would like to force GTK everytime, try adding: export OOO_FORCE_DESKTOP=gnome into your ~/.bashrc (or similar, depending on your shell) or ~/.profile (AFAIR GDM from GNOME 2 read latter file on login; don't know about MATE and I don't know what login manager you are using). I think that variable name is quite misleading. Perhaps no one noticed it yet. Will you be able to find few minutes and file bug report about it on LO bugzilla? Or at least send message to developers mailing list (maybe it should be discussed first)? -- 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] Tell me it's not true
Thanks for that Andreas, Hmmm, that document is nearly nine years old, nothing's happened with file based database access since then? Ok, might as well start at the deep end I suppose. Any pointers gratefully received, and in the meantime I'll start digging. Mark Stanton One small step for mankind... -- 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] Training
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 12-02-23 08:28 AM, webmaster for Kracked Press Productions wrote: On 02/22/2012 01:13 PM, Fabian Rodriguez wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 12-02-21 02:16 PM, Deon Barnard wrote: I have just loaded LibreOffice and would like to know if there are any training offered, downloads,etc. especially in Calc. Thank you kindly Deon Barnard Hi Deon, I'd encourage you to search on the web for OpenOffice.org training and contact whoever provides such training clearly indicating your goals, budget (or lack thereof) and timelines. If someone already offers free or paid training for OOo, there are high chances they will consider adapting their material or using the existing material from LibreOffice to help you. I had a good experience in the pas with Solveig Haugland - http://openoffice.blogs.com/openoffice/2008/01/contact-me-for-consulting-time.html. You can also try Lanedo in Germany http://www.lanedo.com/libreoffice.html Cheers, Fabián Rodríguez http://libreplanet.org/wiki/User:MagicFab I know there are training, free training, sited for LibreOffice out there. I remember seeing one or two a few months ago. After LO became the office package for Linux distros, I started to see links that were LO training. If we tell people to use OOo training for LO, would the just encourage the users to try OOo and use it? Please read again carefully. I didn't advise to seek OOo training, but rather OOo /trainers/. LibO being a close relative, they will most probably consider adding it (or replacing OOo) to their offering. By going to Google, I found a few sites that offer training in/with LibreOffice. Yes OOo training has more links, but it has been around for a longer time. Last year there were posts about training offerings for LO. SO if a person wants LO training, give that person references to LO training, not OOo. Offer that person the links to our Guides and other documentation. Guide and documentation are, at most, self-learning, not training. Sorry if I assumed you meant human-led training ;) F. - -- - -- Fabián Rodríguez -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: PGP/Mime available upon request Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk9NYfQACgkQfUcTXFrypNU/cwCg2l9Ft40vWS52/4ZQ600ebAPg HPEAoKF2SL16+un8gZaL5DMdVZZU7qgA =BeBu -END PGP SIGNATURE- -- 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] LibreO-Base report layout problem
Dear you out there, I am working on a database (LibreO-Base 3.4.5, Win7Prof/32bit) that will result in a multipage-multicolumn report and have made the report using the Report Builder. My intention is to have the report's name and the column headings page number on the first page (= sections 'Report Header' 'Page Header' visible) and only column headings page number(s) on the next pages (= section 'Page Header' visible) According to the guides this a real feature and should be possible - like in MSAccess - by means of mixing with the sections 'Report Header/Footer', 'Page Header/Footer', 'Group Header/Footer' and the property options 'Force New Page' and 'visible/not visible'. There is one group name level above the 'detail' level data. I think I have tried all possible combinations and have got the pages 2..(n) OK but the first page still fails: if section 'Page Header' is put to 'not visible' there are no column headings at all nowhere if section 'Page Header' is 'visible' it is on every page - first page included - but placed above the report name if the column heading fields are put in the section 'Report Header' all the text in this section is visible on every page Please somebody, tell me how to do? Where can I find any instructions about the logic procedure in that mixing? A minor problem: There is a tool/button 'horizontal line' but the line drawn is not visible in preview! Regards Pertti Rönnberg -- 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] LO 3.5 Templates
I made a big mistake this morning. I upgraded to 3.5- I'm using Ubuntu 11.10. Installed from the libreoffice ppa I discovered early that it won't print multiple copies. I tried to revert to 3.4 by removing 3.4 and re-installing. It wouldn't start up. Now I find that I can't use templates. There is not even a templates folder in the organize templates module. The templates exist but just can't be used. If I try to use a template I get an error message templates already exists. If I try to open them as documents and save them as templates I get another similar error about them already existing- no option to overwrite. Has anyone come across any of this insanity? -- God bless you Keith Bates Narrabri NSW Jesus is the Way the Truth and the Life -- 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: increase testing to improve quality
On 02/27/2012 01:37 AM, e-letter wrote: Readers, For those people that consider high quality software to be of highest priority, more important than new features, please help to perform quality assurance manual software tests. There is a web page which describes manual testing: http://wiki.documentfoundation.org/QA/Testing/Manual_Tests. Clearly, there are insufficient testers... Clearly: quote IMPORTANT: Obsoleted by Litmus Litmus is a useful tool for organizing manual tests. Please, help us to migrate all these test cases there and remove them from this wiki page. /quote So why even point 'users' to that page? Please also subscribe to the quality assurance mailing list: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa. There are many bugs that seem to occur after so-called upgrade. People who make the effort to report bugs: please consider how important each bug is. If it is of major importance, the ability to remove the bug must become part of the quality assurance manual test, i.e. the software version is not passed as good quality until that bug is removed. Testing for the success in solving the bug needs to be approved by using 'litmus' (https://tcm.documentfoundation.org). So, the behaviour that caused the bug needs to be recorded and entered into litmus. This should prevent regression bugs and improve software quality in the long-term. Cool. Have you *actually* installed 3.5.1rc1 (as noted in the litmus test)? Description:Test run for *3.5.1 RC* regression testing. Please use *3.5.1 RC* build to test the cases in this run. If you did (and you'd need to find it someplace other than: http://www.libreoffice.org/download/pre-releases/ and (currently) only on http://dev-builds.libreoffice.org/daily/ you'd find that the install (at least on a debian linux system) smokes your existing 3.5.0 install (remember 3.5.0 is the released version). So, while I (we?) appreciate your efforts to get users on this user list as pre-release testers, I'd be overly cautious about asking users on this list to perform litmus tests... At least not without explaining in *detail* what is required, and how to avoid existing LO standard installations being blown away by a pre-release version. IMO it's probably better for 'users' on this list to wait to test/participate when http://www.libreoffice.org/download/pre-releases/ actually shows a pre-release version. *And* testers understand the implications of testing. This will avoid the LO blew up my thesis and wiped out all of my exisiting templates/files/settings. (Note: I'm not making light of those that do report such, but instead trying to avoid such reports here in the first place as they are *serious* issues can happen if you don't understand what you are doing when you test.) Gary Lee -- 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] Closing Calc Documents
On SOME occasions (not all), after I close a calc doc, my Windows Explorer still shows it as open. To remove the lock-file name entry in Explorer, I must reopen the doc and close it again. This usually gets the job done. Is this a bug, or am I not closing the doc properly? I usually hit the big red X to close (but sometimes the little black X to just close the doc and not calc. LibreOffice 3.3 Windoes XL Pro Thanks for your help! Al -- View this message in context: http://nabble.documentfoundation.org/Closing-Calc-Documents-tp3786180p3786180.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
[libreoffice-users] Headless mode examples for socket and pipe methods.
Hello. Using LibreOffice 3.4/3.5. I want to run LibreOffice in--headlessmode for converting files from .doc to .txt, and want to try outboththe socket and pipe methods. However, what is not clear to me is this... 1) With thesocketmethod: If I specify an arbitrary port (instead of the default 8100) in the--acceptargument, how does the the connecting client (a shell script) know about this port. In other words, where/how do I specify the port in the connecting client shell script? 2) With thepipemethod: Do I have to create the pipe myself (usingmkfifo)beforepassing its name to the--acceptargument, or will LibreOffice automatically create the pipe for me? Further, how do I tell the connecting client (again, a shell script) about the name of this pipe? Would greatly appreciate if you could give an example invocation each for the listening and connecting sides, for both the socket and pipe methods. I have searched the Net far and wide but haven't found any relevant information. Many thanks in advance, /HS -- 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] Delayed Execution of a Formula in Calc
I am using LibreOffice 3.4.4 on Kubuntu 11.10. I think my problem may be with an attempt by LO (and most likely with OOo as well) to optimize processing by immediately recalculating only those cells that are on the currently active sheet or those on other sheets that are _known_ to cause changes on the active sheet. Two examples of cells where immediate recalculation may be delayed are those in which a user written function or the INFO() function is involved. If this is the case, is there a way to set a preference to always recalculate everything? This should not hurt performance in a noticable way when dealing with a small document. I recognize that recalculating large complex spreadsheets can be a very intense operation so a warning associated with the selection of the option would be very appropriate. In case I have misdiagnosed the cause of my grief, here is my problem and the circumstances surrounding it. In Sheet4.C5 I have a formula that is not getting executed when the cells it references get changed. Instead, it gets executed when the next automatic backup occurs after the change of status of the referenced cells, when F9 is pressed to recalculate the whole document, or when Sheet4 is manually selected for viewing. In no case that I have found so far is this action performed immediately. Since I change the cell and thus cause this formula to be activated just before I start driving, I end up closing the laptop cover before an automatic backup occurs. That puts the computer to sleep which makes the timestamp that is generated of little use for my purposes. I have tweaked the environment by setting the automatic backup cycle to one minute but that is only a kludge and in any case it still does not solve the problem in the case where I close the cover of the laptop computer and it goes to sleep. This is the formula in Sheet4.C5. Note that it calls a function that I wrote in OOoBasic (aka StarBasic): =IF(ISNUMBER(Sheet3.D5),IF(ISNUMBER(Sheet3.A5),A,fnTStamp(2,0,ROW()-1)),B) Here is the code for my function fnTStamp(): Function fnTStamp(nSheet, nColumn, nRow) ' === Parameters nSheet, nColumn, and nRow specify the location of the cell ' === into which a static timestamp is to be stored. ' === The numbers are zero based. ' = ' === Definitions for the local variables used within this Function Dim oDoc as object Dim oSheet as object Dim oCell as object Dim nFormat as integer ' === I don't know the proper type for the next variable so it is variant here ' === Neither string nor integer worked. Dim CharLocale Dim nFormatId as integer ' === Initialize variables oDoc, oSheet, and oCell for the target oDoc = thisComponent oSheet = oDoc.getSheets().getByIndex(nSheet) oCell = oSheet.getCellByPosition(nColumn, nRow) ' === Get the format id number for HH:MM for this document's locale CharLocale = oDoc.getPropertyValue(CharLocale) nFormatId = oDoc.getNumberFormats.queryKey(HH:MM, CharLocale, false) If nFormatId = -1 then nFormatId = oDoc.getNumberFormats.addNew(HH:MM, CharLocale) End If ' === Store the HH:MM formatted static timestamp into the target cell ' === Also set the format by which this timestamp is displayed oCell.Value = now oCell.setPropertyValue(NumberFormat, nFormatId) ' === Return the string C to the cell from which this function was called fnTStamp = C End Function Sheet3.D5 starts out with this formula that evaluates to either the value 0 or an empty string (). =IF(C5=Reset,0,) I often overwrite that formula with a number. The normal content of Sheet3.D5 is . Sheet3.A5 starts out unformatted and totally empty. I key a number into Sheet3.D5 and tab out of that cell or cause its formula to evaluate to 0.0 by changing Sheet3.C5 to the string Reset. Nothing appears to happen until the next automatic backup or until I tell LO to recalculate everything (F9). Then the time at that moment appears in Sheet3.A5. The delayed processing of the formula does not make sense to me. Does anyone have a clue as to why this happens and, more to the point, how I can solve the problem. In the production version of this document both Sheet3.D5:D98 and Sheet4.C5:C98 are filled downward. It also contains similar formulas in Sheet4.C2:C93 relating to cells in corresponding rows of Sheet2. -- Jim -- 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: Headless mode examples for socket and pipe methods.
322 results for headless on the user forum: http://user.services.openoffice.org/en/forum/search.php?keywords=headless Dozends of tools have been written for OOo: http://www.oooforum.org/forum/viewtopic.phtml?t=11890 http://artofsolving.com/opensource/jodconverter Google shows dozends of other doc2txt tools that do not depend on a multi-megabyte office suite. WinWord and VBA might be the very best tool to convert their own proprietary file format to plain text. -- 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: Delayed Execution of a Formula in Calc
Try MY_NUMERIC_FUNC(constant_params)+RAND() or MY_TEXT_FUNC(constant_params)T(RAND()) The volatile randomizer enforces a recalculation on each and every change. -- 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: Headless mode examples for socket and pipe methods.
Am 29.02.2012 07:52, Andreas Säger wrote: 322 results for headless on the user forum: http://user.services.openoffice.org/en/forum/search.php?keywords=headless Dozends of tools have been written for OOo: http://www.oooforum.org/forum/viewtopic.phtml?t=11890 http://artofsolving.com/opensource/jodconverter Google shows dozends of other doc2txt tools that do not depend on a multi-megabyte office suite. WinWord and VBA might be the very best tool to convert their own proprietary file format to plain text. I forgot: Did you play with the command line options of LibreOffice? See soffice[.exe] -help -- 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: Headless mode examples for socket and pipe methods.
Hey Andreas,Please treat this question as a headless question from a headless one.I'm on RHEL 5, so cannot used Windows-based solutions. LO being multi-megabyte is not an issue as long as it works.I forgot: Did you play with the command line options of LibreOffice?Yes, I have been playing and reading and reading and playing for the last several hours. Have tried looking at the code of unoconv also but not much luck so far. I admit I'm not a good code-reader and I'm reading in a very rushed-mode also.I, for example, tried the following to start the LO as listener:$ soffice.bin --headless --accept='socket,host=0,port=8100,tcpNoDelay=1;urp;'[2] 13628$ netstat -tnap | grep sofficetcp 0 0 0.0.0.0:8100 0.0.0.0:* LISTEN 13628/soffice.bin So, clearly soffice is listening now.To connect, I'm issuing the following but don't really know if this what is needed to be done. Which is why I posted the question in the first place. Read this link also in the meantime (http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/ProUNO/Opening_a_Connection) , but I'm still missing something.$ soffice.bin --headless --accept='socket,host=127.0.0.1,port=8100,tcpNoDelay=1;urp;' --convert-to txt foo.doc; echo $?1$ ls foo.txtls: delme.txt: No such file or directory$I need a tool that converts not just .doc files but all MS Office files (.xls, .ppt, .docx, .xlsx, .pptx). I thought LO would be great to use these since I'm already satisfied by how it loads up these files in interactive/GUI mode.Would greatly appreciate if someone could point out what exactly I'm missing, my needle is stuck and not moving forward. :-(Regards,A headless listener :-)On 02/29/2012 12:26 PM, Andreas Säger wrote:Am 29.02.2012 07:52, Andreas Säger wrote:322 results for headless on the user forum:http://user.services.openoffice.org/en/forum/search.php?keywords=headlessDozends of tools have been written for OOo:http://www.oooforum.org/forum/viewtopic.phtml?t=11890http://artofsolving.com/opensource/jodconverterGoogle shows dozends of other doc2txt tools that do not depend on amulti-megabyte office suite.WinWord and VBA might be the very best tool to convert their ownproprietary file format to plain text.I forgot: Did you play with the command line options of LibreOffice?See soffice[.exe] -help -- 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] How to use GTK open dialog box in LibreOffice
Hello, Thank you for these answers. Here are the results. Le 28/02/2012 21:47, Mirosław Zalewski a écrit : try running LO like that: OOO_FORCE_DESKTOP=gnome libreoffice Works fine. I get gnome open/save dialog boxes. If you would like to force GTK everytime, try adding: export OOO_FORCE_DESKTOP=gnome into your ~/.bashrc Doesn't work, even after restarting the session. or ~/.profile Doesn't work either. Maybe I didn't paste it at the right place. I've seen there was if loops. Should OOO_FORCE_DESKTOP=gnome libreoffice be pasted into the looop or at the very end of the file ? I think that variable name is quite misleading. Perhaps no one noticed it yet. Will you be able to find few minutes and file bug report about it on LO bugzilla? Or at least send message to developers mailing list (maybe it should be discussed first)? OK. I'll do when I've solved the problem, so I can give a complete report. Thank you. -- Arnaud Champollion -- 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: Headless mode examples for socket and pipe methods.
$ ls foo.txtls: delme.txt: No such file or directory$Sorry, the delme.txt above is a typo. it should be$ ls foo.txtls: foo.txt: No such file or directory$(Basically, I'm issuing the 'ls' command to show that foo.txt did not get created.)On 02/29/2012 01:05 PM, Harry Simons wrote:Hey Andreas,Please treat this question as a headless question from a headless one.I'm on RHEL 5, so cannot used Windows-based solutions. LO being multi-megabyte is not an issue as long as it works.I forgot: Did you play with the command line options of LibreOffice?Yes, I have been playing and reading and reading and playing for the last several hours. Have tried looking at the code of unoconv also but not much luck so far. I admit I'm not a good code-reader and I'm reading in a very rushed-mode also.I, for example, tried the following to start the LO as listener:$ soffice.bin --headless --accept='socket,host=0,port=8100,tcpNoDelay=1;urp;'[2] 13628$ netstat -tnap | grep sofficetcp 0 0 0.0.0.0:8100 0.0.0.0:* LISTEN 13628/soffice.bin So, clearly soffice is listening now.To connect, I'm issuing the following but don't really know if this what is needed to be done. Which is why I posted the question in the first place. Read this link also in the meantime (http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/ProUNO/Opening_a_Connection) , but I'm still missing something.$ soffice.bin --headless --accept='socket,host=127.0.0.1,port=8100,tcpNoDelay=1;urp;' --convert-to txt foo.doc; echo $?1$ ls foo.txtls: delme.txt: No such file or directory$I need a tool that converts not just .doc files but all MS Office files (.xls, .ppt, .docx, .xlsx, .pptx). I thought LO would be great to use these since I'm already satisfied by how it loads up these files in interactive/GUI mode.Would greatly appreciate if someone could point out what exactly I'm missing, my needle is stuck and not moving forward. :-(Regards,A headless listener :-)On 02/29/2012 12:26 PM, Andreas Säger wrote:Am 29.02.2012 07:52, Andreas Säger wrote:322 results for headless on the user forum:http://user.services.openoffice.org/en/forum/search.php?keywords=headlessDozends of tools have been written for OOo:http://www.oooforum.org/forum/viewtopic.phtml?t=11890http://artofsolving.com/opensource/jodconverterGoogle shows dozends of other doc2txt tools that do not depend on amulti-megabyte office suite.WinWord and VBA might be the very best tool to convert their ownproprietary file format to plain text.I forgot: Did you play with the command line options of LibreOffice?See soffice[.exe] -help -- 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] How to use GTK open dialog box in LibreOffice
Le 28/02/2012 21:47, Mirosław Zalewski a écrit : OOO_FORCE_DESKTOP=gnome libreoffice Works, although I get a message : WARNING: gnome-keyring:: couldn't connect to: /tmp/keyring-uQs6sF/pkcs11: Aucun fichier ou dossier de ce type (Aucun fichier ou dossier de ce type = No such file or folder) -- Arnaud Champollion -- 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
