[libreoffice-users] Re: LibreOffice base - cannot make a convenient form to add data
Ok I figured it out - manual setting doesn't do what it is supposed to, so I should use SQL and write smth like SELECT Location, ID FROM Locations - this works the way I want it to if column is listbox. I can also type in to quickly select items. Still couldn't find how to add a grid object if I delete it and how to use wizard to set up its columns. Found wizard when clicked on add listbox button on a panel - but this adds a separate listbox, not a column inside a table. And if you add a column to a table, there is no wizard. -- View this message in context: http://nabble.documentfoundation.org/LibreOffice-base-cannot-make-a-convenient-form-to-add-data-tp3227878p3234774.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] helper columns in Base - SQL query based on a value of a particular column of current element.
Can't figure this one out. I want to have helper columns in my form, which show text relevant to a value selected in a particular field for each element. EXAMPLE: Components ID--TypeParameter-Parameter-value INTINT--[this one should be dynamic]---VARCHAR Where Type is linked to another table which is as follows: Components-Types ID--TypeParameter INTVARCHAR--VARCHAR So I want to see Parameter-Name shown according to Type. But I don't want to store Parameter-Name in the table Components, I want it to only show in form, to make editing Parameter-value easy (so that I would see what kind of value I should enter). It seems that I need to use listbox to be able to use sql in a column, but if I use a listbox, I need to specify a field it correlates to, which I don't have, because the column should be dynamic. So I write smth like: SELECT Components - Types.Parameter FROM Components, Components - Types WHERE Components.Type = Components - Types.ID in SQL query for listbox, but this gives me nothing in my form (however works kinda right when I run it via SQL tool - shows me all parameter names correlating to Type field in Components) How do I do such a dynamic column in Base? -- View this message in context: http://nabble.documentfoundation.org/helper-columns-in-Base-SQL-query-based-on-a-value-of-a-particular-column-of-current-element-tp3234895p3234895.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: helper columns in Base - SQL query based on a value of a particular column of current element.
Oh again I'm too impatient to ask, finally I figured this out too. Should have selected listbox and used the relevant field (Type in my case), plus SQL query like: SELECT Parameter 1,ID FROM Components-Types. Works fine! -- View this message in context: http://nabble.documentfoundation.org/helper-columns-in-Base-SQL-query-based-on-a-value-of-a-particular-column-of-current-element-tp3234895p3234919.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: helper columns in Base - SQL query based on a value of a particular column of current element.
Hi :) It is a valid way of solving problems because it often takes a while before questions get answers. So, ask first, then hunt for HowTo and if you get the answer first then post back to say how you solved it. It might even help other people that run into a similar problem later if they serach through the threads. Congrats! Nicely solved! Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/helper-columns-in-Base-SQL-query-based-on-a-value-of-a-particular-column-of-current-element-tp3234895p3235133.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: Extending selection in Calc (LibreOffice 3.4.2, Linux)
Cor, Thank you for taking the time to explain. I have modified my spreadsheet accordingly. All the best to you and the /Libre/Office team! -- View this message in context: http://nabble.documentfoundation.org/Extending-selection-in-Calc-LibreOffice-3-4-2-Linux-tp3230960p3235268.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] new book
On 08/06/2011 08:55 AM, webmaster for Kracked Press Productions wrote: On 08/05/2011 05:46 PM, Andrew Douglas Pitonyak wrote: On 08/05/2011 08:59 AM, webmaster for Kracked Press Productions wrote: On 08/05/2011 08:49 AM, rogerio dandrea wrote: new book http://www.pitonyak.org/OOME_3_0.odt :0) thanks Pitonyak for the excellent work :0) From Brazil 498 pages worth of Macros Explained could help a lot of people on these lists. Have downloaded it and exported it as a PDF file. I usually upload the current PDF version when I upload the ODT version. (for what it is worth). All I had was the link to the .odt file. I always make PDF copies of every .odt file I download. I cannot wait to see what the book is like next. Please, would you list the link again. This time I might remember to bookmark the page for later use. I always need online [and offline] sources of documentation for people I have convinced to switch to LibreOffice. Documentation for Base and Macros are asked about. I do not use Base at all and rarely use macros, but I deal with people who deal with data bases and creating macros. Thanks for your book and the work you do to present this information to others. Most of my OOo content http://www.pitonyak.org/oo.php German Translation (in progress) of OOME version 3.0 http://www.uni-due.de/~abi070/ooo.html -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] HELP WITH CODE excel
On 08/07/2011 12:00 AM, nvrk wrote: On Sat, Aug 6, 2011 at 8:13 PM, Joseph Da Silvajoseph_da_si...@hotmail.com wrote: Hi I was wondering if someone could help me with this code it works in excel but not with libra office. =INDIRECT(CELL(ADDRESS,INDEX($P$28933:$P$29998,MATCH(MIN(Q28931:Q29998),Q28931:Q29998, The help would be greatly appreicated -- Wondering - what is purpose of the comma just to the left of the 4 close parentheses? nvsoar Besides the extra comma (good catch nvsoar), must the commas , be changed to semicolons ;? -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] new book
On 08/08/2011 08:04 AM, Andrew Douglas Pitonyak wrote: On 08/06/2011 08:55 AM, webmaster for Kracked Press Productions wrote: On 08/05/2011 05:46 PM, Andrew Douglas Pitonyak wrote: On 08/05/2011 08:59 AM, webmaster for Kracked Press Productions wrote: On 08/05/2011 08:49 AM, rogerio dandrea wrote: new book http://www.pitonyak.org/OOME_3_0.odt :0) thanks Pitonyak for the excellent work :0) From Brazil 498 pages worth of Macros Explained could help a lot of people on these lists. Have downloaded it and exported it as a PDF file. I usually upload the current PDF version when I upload the ODT version. (for what it is worth). All I had was the link to the .odt file. I always make PDF copies of every .odt file I download. I cannot wait to see what the book is like next. Please, would you list the link again. This time I might remember to bookmark the page for later use. I always need online [and offline] sources of documentation for people I have convinced to switch to LibreOffice. Documentation for Base and Macros are asked about. I do not use Base at all and rarely use macros, but I deal with people who deal with data bases and creating macros. Thanks for your book and the work you do to present this information to others. Most of my OOo content http://www.pitonyak.org/oo.php German Translation (in progress) of OOME version 3.0 http://www.uni-due.de/~abi070/ooo.html Thanks I always need web links to LibreOffice [and OOo when no LO one are available] to pass along to people I deal with. 1] Would you want your page/book link a part of the Documentation Page[s] for the North American Community DVD Project? 2] Would you allow the PDF version to be included on the DVD as well as a link to your site? Here is the two links to the online version[s] of the NA DVD. LibreOffice's CMS system version - being worked on http://dvd.north-america.libreofficebox.org/en/ my domain - Original site for online DVD testing site [for now - the most up-to-date - till the CMS version catches up] http://libreoffice-na.us/ -- 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] doc-files
Hello, I sometimes have to send files created under LO-Writer to people who use M$-Word. I then store them in .doc-format for sending. From time to time people tell me that they cannot open these files. Has anybody experienced this problem? Regards H. S. -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- 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] doc-files
On 08/08/2011 14:02, Heinrich Stoellinger wrote: Hello, I sometimes have to send files created under LO-Writer to people who use M$-Word. I then store them in .doc-format for sending. From time to time people tell me that they cannot open these files. Has anybody experienced this problem? Regards H. S. This is likely to be a consequence of the particular version of Word that your correspondents are using. A simple answer would be to save the documents in .rtf format instead. Graham -- 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 - Would like to see Insert Cut Cells Insert Copied Cells Added to Right-Click Menus
Here is the explanation for insert cut cells and insert copied cells as you requested. If I cut a range of cells (usually one or more rows or columns), select a similarly shaped range of cells (again usually one or more row or columns), the cut cells are inserted at the selection and the cut region is deleted. So if I select row 10, right-click on it, then select row 20, right-click and select Insert Cut cells, row 10 is deleted, rows 11 through 19 are shifted up one row, and the deleted row is inserted in front of row 20. Insert Copied Cells works similarly, except the original row is not deleted and rows 11 through 19 are not moved up to fill the gap. Instead a new row is insert in front of row 20 and the copied row pasted into row 20. I have assumed that both OpenOffice and LibreOffice intened to do more than just be a data file compatible mimic of Microsoft Office 2003. There should be more to LibreOffice than just partial mimicry. If features like I have just described are not in LibreOffice Calc and also not in its macro capability then MS Excel files won't be read and executed properly in Calc. That would be a shame. I believe that the future of LibreOffice is in freezing the constant changing, but not improving, behavior of Microsoft so that a product such as Calc can be stable and compatible over a period of decades or forever. Nuno J. Silva [via Document Foundation Mail Archive] ml-node+3233146-751127155-420...@n3.nabble.com wrote: On 2011-08-07, grfried wrote: It is not clear to me why Insert Cut Cells following a previous Cut and Insert Copied Cells following a previous Copy are not available in the right-click menu in LibreOffice Calc as they are in Microsoft Excel. I use them very frequently to re-order a set range of rows where sort is not appropriate. Is this the right forum for posting requests for features? I don't know what these Excel functions do (can you give us a quick explanation?). If they're about not overwriting existing shells and /shift/ them instead, that feature exists, just pick Paste Special... and you can select Down or Right in Shift cells. Now I guess the issue is that this isn't as efficient as just hitting a couple keys or picking one item in the context menu, and that is a problem if you use this frequently. -- Nuno J. Silva (aka njsg) gopher://sdf-eu.org/1/users/njsg -- 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 ___ If you reply to this email, your message will be added to the discussion below: http://nabble.documentfoundation.org/Calc-Would-like-to-see-Insert-Cut-Cells-Insert-Copied-Cells-Added-to-Right-Click-Menus-tp3232931p3233146.html To unsubscribe from Calc - Would like to see Insert Cut Cells Insert Copied Cells Added to Right-Click Menus, visit http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=3232931code=dGhyb3dhd2F5Z2ZAc2MucnIuY29tfDMyMzI5MzF8OTI3NjE0OTM2 -- View this message in context: http://nabble.documentfoundation.org/Calc-Would-like-to-see-Insert-Cut-Cells-Insert-Copied-Cells-Added-to-Right-Click-Menus-tp3232931p3235401.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] doc-files
Hi :) Perhaps give them the link to download LibreOffice and let them know it reads a wider range of formats and is more compatible with a wider range of other programs. Word 2010 is not always compatible with Word 2007 let alone Word 2003. Are you sure you are saving as Doc rather than DocX? The DocX used by default in MS Office 2007 2010 is not able to be read on earlier versions of MS Office without installing extra an extra patch. Do they have problems opening documents from anyone else or do they keep quiet about that? Again it would be a good reason for upgrading to LibreOffice because it can read both. In LibreOffice or OpenOffice choose to Save As Word (97/2000/XP) (scroll back up the list 1 place) rather than the default Word format. Or as Graham says use Rtf to avoid the whole issue. At work i set the older MS Office formats as the default by going to Tools - Options - Load/Save - General Then down at the bottom use the 2 drop-downs to set Text document = Microsoft Word (97/2000/XP) Spreadsheet = Microsoft Excel (97/2000/XP) Presentation = Microsoft Powerpoint (97/2000/XP) For the last 2 it's 2 back up the list as 1 back is a template which is well worth avoiding. On the same page about halfway up i tend to change ODF format version right back from 1.2 Extended (recommended) to 1.0/1.1 because MS Office 2010 2007 can just about read those. I don't know why they haven't tried the newer spec, it's not exactly hidden or difficult or anything. I think the 1.2 was not around in 2007. Further down in the Writer section - Compatibility i tick all the boxes just as the extra finesse. Regards from Tom :) From: Graham Mullan graham.mul...@coly.org.uk To: users@global.libreoffice.org Sent: Mon, 8 August, 2011 14:12:08 Subject: Re: [libreoffice-users] doc-files On 08/08/2011 14:02, Heinrich Stoellinger wrote: Hello, I sometimes have to send files created under LO-Writer to people who use M$-Word. I then store them in .doc-format for sending. From time to time people tell me that they cannot open these files. Has anybody experienced this problem? Regards H. S. This is likely to be a consequence of the particular version of Word that your correspondents are using. A simple answer would be to save the documents in .rtf format instead. Graham -- 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] [base] BaseTools Extension
BaseTools Extension works in libreoffice 3.4.2? I have a problem with filter in base , I need an example of form filter macro 1 and 2 dont work Sub New_Search(Event As Object) GlobalScope.BasicLibraries.LoadLibrary(BaseTools) Dim Form As object Dim Control As Object Dim nome,fnome As String If BasicLibraries.hasByName(BaseTools) Then BasicLibraries.LoadLibrary(BaseTools) End If Form=Event.Source.Model.Parent nome = InputBox(ENTRE COM AS INICIAIS DO NOME) fnome=Nome LIKE ' nome *' print fnome ' for test filter sintax OK OK '111 'Form.Filter=Nome = LIKE ' nome *' 'Form.ApplyFilter=True 'Form.reload() '2 RunCmd.ApplyFilter(fnome) End Sub -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] doc-files
for me,no problem with doc but sometimes faced problem with docx.avoiding it now On 8 August 2011 19:32, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) Perhaps give them the link to download LibreOffice and let them know it reads a wider range of formats and is more compatible with a wider range of other programs. Word 2010 is not always compatible with Word 2007 let alone Word 2003. Are you sure you are saving as Doc rather than DocX? The DocX used by default in MS Office 2007 2010 is not able to be read on earlier versions of MS Office without installing extra an extra patch. Do they have problems opening documents from anyone else or do they keep quiet about that? Again it would be a good reason for upgrading to LibreOffice because it can read both. In LibreOffice or OpenOffice choose to Save As Word (97/2000/XP) (scroll back up the list 1 place) rather than the default Word format. Or as Graham says use Rtf to avoid the whole issue. At work i set the older MS Office formats as the default by going to Tools - Options - Load/Save - General Then down at the bottom use the 2 drop-downs to set Text document = Microsoft Word (97/2000/XP) Spreadsheet = Microsoft Excel (97/2000/XP) Presentation = Microsoft Powerpoint (97/2000/XP) For the last 2 it's 2 back up the list as 1 back is a template which is well worth avoiding. On the same page about halfway up i tend to change ODF format version right back from 1.2 Extended (recommended) to 1.0/1.1 because MS Office 2010 2007 can just about read those. I don't know why they haven't tried the newer spec, it's not exactly hidden or difficult or anything. I think the 1.2 was not around in 2007. Further down in the Writer section - Compatibility i tick all the boxes just as the extra finesse. Regards from Tom :) From: Graham Mullan graham.mul...@coly.org.uk To: users@global.libreoffice.org Sent: Mon, 8 August, 2011 14:12:08 Subject: Re: [libreoffice-users] doc-files On 08/08/2011 14:02, Heinrich Stoellinger wrote: Hello, I sometimes have to send files created under LO-Writer to people who use M$-Word. I then store them in .doc-format for sending. From time to time people tell me that they cannot open these files. Has anybody experienced this problem? Regards H. S. This is likely to be a consequence of the particular version of Word that your correspondents are using. A simple answer would be to save the documents in .rtf format instead. Graham -- 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 -- Dr soumalya ray http://drsoumalya.blogspot.com drsouma...@gmail.com MBBS,MD(PGT)C.Medicine,Ex-HousePhysician(Medicine) Skype: som3776 | Twitter: @docbkp http://twitter.com/docbkp -- 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] doc-files
Hi Heinrich, Heinrich Stoellinger wrote (08-08-11 15:02) I sometimes have to send files created under LO-Writer to people who use M$-Word. I then store them in .doc-format for sending. From time to time people tell me that they cannot open these files. Has anybody experienced this problem? No. Maybe you have some details on the documents / circumstances? Thanks, -- - Cor - http://nl.libreoffice.org -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: HELP WITH CODE excel
Am 08.08.2011 14:08, Andrew Douglas Pitonyak wrote: =INDIRECT(CELL(ADDRESS,INDEX($P$28933:$P$29998,MATCH(MIN(Q28931:Q29998),Q28931:Q29998, The help would be greatly appreicated -- How can INDIRECT(CELL(ADDRESS;INDEX(...))) return anything else than INDEX(...) alone? If I recall correctly, this was an ugly hack for an Excel restriction where cell validation by range failed when the validation list was on another sheet. This hack is not required in OOo. Apart from this, the above formula should simply work when you import the xls file. The office takes care of this. Since this is LibreOffice, the comma should be just fine if it used to be just fine in Excel. But nobody can really tell for sure. I wish the devs would restore the clear formula syntax as in OOo. The last argument of MATCH is missing which is not intended in most cases. If it is intended, the comma should be left out as well. -- 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 base - cannot make a convenient form to add data
Am 08.08.2011 09:03, 3flight wrote: But I do it manually (i.e. via form editor - right click on column - change to listbox, then go open it's options and set it to take values from a linked table's second field). Can't see where in the Form Creation Wizard there is an option to change columns to listbox. Which wizard are you reffering to? Ignore all those wizards in Base. Most of them are misleading and time consuming. Draw your box or choose ReplaceWithListbox from another control's context menu. In the latter case you have to set property Drop Down on the general properties tab or you have to drag it taller for a multi-line box. Properties on tab Data can be as simple as this: Data field: The foreign key to be written (ArticleID or something) Source type: SQL Source: SELECT Visible Field, Primary Key FROM Other Table ORDER BY Visible Field Bound Field: 1 (which is the second field, 0 is th index of the visible one) Source may be also a concatenation like: SELECT ZIP||' '||City AS Visible Field, Primary Key FROM Other Table ORDER BY Visible Field [Example] Relations reflected by list boxes in forms: http://user.services.openoffice.org/en/forum/viewtopic.php?f=100t=40444 -- 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] Permanent state of recovery with non-existent document
On Thu, Aug 4, 2011 at 3:30 AM, Sigrid Carrera sigrid.carr...@googlemail.com wrote: On Thu, 4 Aug 2011 00:18:16 -0700 MR ZenWiz mrzen...@gmail.com wrote: Once, a long time ago, I tried to open a .pps file with LO, and it crashed LO - every single time. I deleted the document and yet every time I start LO, it tries to recover this non-existent document. : You have a few options: 1) You can press cancel the next time you start LibreOffice. This should end the endless recovery process. When I installed 3.4.2, I first uninstalled both 3.3.3 and 3.4.0. Then the first time I started LO, I selected cancel, and that seems to have fixed the problem. Thanks. -- 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: helper columns in Base - SQL query based on a value of a particular column of current element.
Am 08.08.2011 10:24, 3flight wrote: SELECT Components - Types.Parameter FROM Components, Components - Types WHERE Components.Type = Components - Types.ID It is as simple as: SELECT Parameter,ID FROM Components - Types ORDER BY Parameter with Parameter as visible field (index 0) and ID (index 1) being the bound field. If your form is bound to table Components, then Components.Type might be the data field where you write the selected ID value to. -- 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] doc-files
Make sure you save the file as Microsoft Word Win 97/2000/XP .doc format. That way you get one that should work fine. That is the one I use when I have to send a Word document to people. I never had any problems with it. As other will tell you, stay clear of .docx format. Any of the formats that show the x as the forth character are to be avoided. Sometimes, as I have been told by Word users, if you save a document with the latest Word format of .docx using Word 2010, it may not be read properly with Word 2007 or Word 2003 with the format extension/filter MS created for Office 2003 to read 2007 formats. So if MS cannot get their act together to allow their own products to read files saved by their own products, what hope will third-party packages have to be able to read/write those formats 100% of the time. So stick with .doc, and the other per Office 2007 formats. Also, send them the link for LibreOffice, if it is appropriate to do so. let them know that it uses as their default formats, the International Standard formats for Office packages - ODF, while MSO's formats are not. Let them know that the software is free. Many people I have told did not believe it was free, until I stated that fact several times, and some it took a printout of the page stating it was free AND handing the a DVD with the package in it. On 08/08/2011 10:46 AM, soumalya ray wrote: for me,no problem with doc but sometimes faced problem with docx.avoiding it now On 8 August 2011 19:32, Tom Daviestomdavie...@yahoo.co.uk wrote: Hi :) Perhaps give them the link to download LibreOffice and let them know it reads a wider range of formats and is more compatible with a wider range of other programs. Word 2010 is not always compatible with Word 2007 let alone Word 2003. Are you sure you are saving as Doc rather than DocX? The DocX used by default in MS Office 2007 2010 is not able to be read on earlier versions of MS Office without installing extra an extra patch. Do they have problems opening documents from anyone else or do they keep quiet about that? Again it would be a good reason for upgrading to LibreOffice because it can read both. In LibreOffice or OpenOffice choose to Save As Word (97/2000/XP) (scroll back up the list 1 place) rather than the default Word format. Or as Graham says use Rtf to avoid the whole issue. At work i set the older MS Office formats as the default by going to Tools - Options - Load/Save - General Then down at the bottom use the 2 drop-downs to set Text document = Microsoft Word (97/2000/XP) Spreadsheet = Microsoft Excel (97/2000/XP) Presentation = Microsoft Powerpoint (97/2000/XP) For the last 2 it's 2 back up the list as 1 back is a template which is well worth avoiding. On the same page about halfway up i tend to change ODF format version right back from 1.2 Extended (recommended) to 1.0/1.1 because MS Office 2010 2007 can just about read those. I don't know why they haven't tried the newer spec, it's not exactly hidden or difficult or anything. I think the 1.2 was not around in 2007. Further down in the Writer section - Compatibility i tick all the boxes just as the extra finesse. Regards from Tom :) From: Graham Mullangraham.mul...@coly.org.uk To: users@global.libreoffice.org Sent: Mon, 8 August, 2011 14:12:08 Subject: Re: [libreoffice-users] doc-files On 08/08/2011 14:02, Heinrich Stoellinger wrote: Hello, I sometimes have to send files created under LO-Writer to people who use M$-Word. I then store them in .doc-format for sending. From time to time people tell me that they cannot open these files. Has anybody experienced this problem? Regards H. S. This is likely to be a consequence of the particular version of Word that your correspondents are using. A simple answer would be to save the documents in .rtf format instead. Graham -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly
Re: [libreoffice-users] Calc - Would like to see Insert Cut Cells Insert Copied Cells Added to Right-Click Menus
On 8/7/2011 10:17 AM, Johnny Rosenberg wrote: 2011/8/7 Nuno J. Silvanunojsi...@ist.utl.pt: On 2011-08-07, grfried wrote: It is not clear to me why Insert Cut Cells following a previous Cut and Insert Copied Cells following a previous Copy are not available in the right-click menu in LibreOffice Calc as they are in Microsoft Excel. I use them very frequently to re-order a set range of rows where sort is not appropriate. Is this the right forum for posting requests for features? I don't know what these Excel functions do (can you give us a quick explanation?). If they're about not overwriting existing shells and /shift/ them instead, that feature exists, just pick Paste Special... and you can select Down or Right in Shift cells. Now I guess the issue is that this isn't as efficient as just hitting a couple keys or picking one item in the context menu, and that is a problem if you use this frequently. Probably not a big problem. If you selected ”Down” or ”Right” once, it will be selected next time you use it, so it only means one extra click more than Excel except for the first time and when you want to change from ”Down” to ”Right” and vice versa. This is why I read the lists. I learned something today. In Excel, I use Insert Cut Cells and Insert Copied Cells all the time, and that has been one big reason why I don't use OOo exclusively. (I'm on OOo v3.3.0 on WinXP, and haven't felt comfortable about moving to LO yet.) As Nuno surmised, the OOo/LO equivalent is: select the new location and then | Edit | Paste Special | Shift Cells Down | which I did NOT know before reading this exchange. Excel's process is that after you select the cells or row to be moved, you: right-click on the target cell or row, then click Insert cut cells which replaces the normal paste entry in the context menu. (Insert Copied Cells works the same way.) So it's 2 steps in MS vs 4 in OOo. But it's VERY nice to know that OOo/LO can do this at all. However, grfried has another point. If you want to take market-share from MS, you've got to do things like this at least conveniently as MS, if not more so. Otherwise your only market is those who can't get MS and those (like me) who are at least semi-technical and want an alternative to MS. Personally, I think that OOo/LO ought to be able to do everything that MSOffice 97 (14 years old now) could do, including convenience features. If it could, it would take a HUGE share of the market. (I have now added the suggestion to the bugzilla list at http://wiki.documentfoundation.org/BugReport per Nuno's suggestion.) Thanks, -- Tim Deaton -- 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: Need Calc help
Hello Andreas, Thank you for your message and your patience. I am attaching two files - the first one outlines what I am hoping to accomplish and the second one has three tables in a worksheet that provides a shortened typical entry of the files involved and what I hope to see as a result Hope this provides enough info so that someone can point me in the right direction Thanks again, Preston On 8/7/2011 1:12 PM, Andreas Säger wrote: Let me retry your request in this way: 0) Technical prerequisites: Running LibreOffice 3.3.3 under WinXP I have a spreadsheet with 2 tables imported from text files which I receive on a regular basis from other departments of our organization. 1) A list of persons with an ID number, name, forname, birthday, address info and more: 0 Smith Jennifer 1967-07-09 ... 1 Smith John 1988-07-29 ... 2 Doe Farina 1999-11-12 ... 2) A membership list with person ID, entry date, department 1 2003-12-03 Helsinki 2 2007-01-01 Stockholm 0 2010-11-11 London 2 2009-01-31 Berlin 3)Now I want to merge both lists so they look like Smith John 1988-07-29 2003-12-03 Helsinki ... Doe Farina 1999-11-12 2007-01-01 Stockholm ... Smith Jennifer 1967-07-09 2010-11-11 London ... Doe Farina 1999-11-12 2009-01-31 Berlin ... where the membership's person-ID is merged with the membership information. This entirely technical information about what you have and where you want to go could serve as a platform where anybody on this list could be involved with some hints, tips, suggestions how to process these concrete example data in a spreadsheet, in a database, in a scripting language. Example data can be copied into a spreadsheet very easily and from there into a database. -- 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] doc-files
One area where M$ Word still scores over LO is in the use of track-changes. I know many editors and authors who stay with M$ because the in-text change tracking that LO (and OO) use is much trickier to use than the in-margin alternative available in the M$ version. If the latter could be added to LO, then I can guarantee a lot more users. Graham -- graham.mul...@coly.org.uk -- 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] need to find the link
Don't know if this is what you want? http://blog.arpitnext.com/gpdf Graham -- graham.mul...@coly.org.uk 0117 9502556 or 07887 637064 (or 0844 2327803) On 08/08/2011 18:18, webmaster for Kracked Press Productions wrote: Earlier on this list, there was a thread that talked about a Firefox extension for LibreOffice. I know that Firefox can view .odt files, but I am looking for that Firefox add-on. Can anyone tell me the name of that add-on and maybe a direct link for it? I tried to find it on th Firefox site, but could do. I know there was an OOo extension/add-on for Firefox, but I could not find it either. -- 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] doc-files
Sorry guys, but I was talking about Calc/Excel spreadsheets, not Word text documents. -Aarni- On 08.08.2011 20:15, webmaster for Kracked Press Productions wrote: Make sure you save the file as Microsoft Word Win 97/2000/XP .doc format. That way you get one that should work fine. That is the one I use when I have to send a Word document to people. I never had any problems with it. As other will tell you, stay clear of .docx format. Any of the formats that show the x as the forth character are to be avoided. Sometimes, as I have been told by Word users, if you save a document with the latest Word format of .docx using Word 2010, it may not be read properly with Word 2007 or Word 2003 with the format extension/filter MS created for Office 2003 to read 2007 formats. So if MS cannot get their act together to allow their own products to read files saved by their own products, what hope will third-party packages have to be able to read/write those formats 100% of the time. So stick with .doc, and the other per Office 2007 formats. Also, send them the link for LibreOffice, if it is appropriate to do so. let them know that it uses as their default formats, the International Standard formats for Office packages - ODF, while MSO's formats are not. Let them know that the software is free. Many people I have told did not believe it was free, until I stated that fact several times, and some it took a printout of the page stating it was free AND handing the a DVD with the package in it. On 08/08/2011 10:46 AM, soumalya ray wrote: for me,no problem with doc but sometimes faced problem with docx.avoiding it now On 8 August 2011 19:32, Tom Daviestomdavie...@yahoo.co.uk wrote: Hi :) Perhaps give them the link to download LibreOffice and let them know it reads a wider range of formats and is more compatible with a wider range of other programs. Word 2010 is not always compatible with Word 2007 let alone Word 2003. Are you sure you are saving as Doc rather than DocX? The DocX used by default in MS Office 2007 2010 is not able to be read on earlier versions of MS Office without installing extra an extra patch. Do they have problems opening documents from anyone else or do they keep quiet about that? Again it would be a good reason for upgrading to LibreOffice because it can read both. In LibreOffice or OpenOffice choose to Save As Word (97/2000/XP) (scroll back up the list 1 place) rather than the default Word format. Or as Graham says use Rtf to avoid the whole issue. At work i set the older MS Office formats as the default by going to Tools - Options - Load/Save - General Then down at the bottom use the 2 drop-downs to set Text document = Microsoft Word (97/2000/XP) Spreadsheet = Microsoft Excel (97/2000/XP) Presentation = Microsoft Powerpoint (97/2000/XP) For the last 2 it's 2 back up the list as 1 back is a template which is well worth avoiding. On the same page about halfway up i tend to change ODF format version right back from 1.2 Extended (recommended) to 1.0/1.1 because MS Office 2010 2007 can just about read those. I don't know why they haven't tried the newer spec, it's not exactly hidden or difficult or anything. I think the 1.2 was not around in 2007. Further down in the Writer section - Compatibility i tick all the boxes just as the extra finesse. Regards from Tom :) From: Graham Mullangraham.mul...@coly.org.uk To: users@global.libreoffice.org Sent: Mon, 8 August, 2011 14:12:08 Subject: Re: [libreoffice-users] doc-files On 08/08/2011 14:02, Heinrich Stoellinger wrote: Hello, I sometimes have to send files created under LO-Writer to people who use M$-Word. I then store them in .doc-format for sending. From time to time people tell me that they cannot open these files. Has anybody experienced this problem? Regards H. S. This is likely to be a consequence of the particular version of Word that your correspondents are using. A simple answer would be to save the documents in .rtf format instead. Graham -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?
Re: [libreoffice-users] Calc - Would like to see Insert Cut Cells Insert Copied Cells Added to Right-Click Menus
Hi, grfried schrieb: It is not clear to me why Insert Cut Cells following a previous Cut and Insert Copied Cells following a previous Copy are not available in the right-click menu in LibreOffice Calc as they are in Microsoft Excel. I use them very frequently to re-order a set range of rows where sort is not appropriate. You do it different in LibO: For cutpaste: (1) Mark the row or column to move. (2) Hold down the Alt-key and drag. You will notice a bold horizontal line. If you have marked a whole row or column, do not try to use the header, but use a cell. (3) Drop when the line is there, where you want to insert the row or column. For copypaste hold down Alt-Key and Ctrl-Key. Kind regards Regina -- 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] need to find the link
No that is not what I was looking for. It was an add-on for Firefox and LO/OOo that connected the two packages together. It gave an option in Firefox to Open Lo/OOo and pass the ODF file[s] to the office package to oven and view them. Right now, Firefox can read .odt files internally, but if I wanted to view a Draw or Calc file, the add-on would automatically open LO and display the file in LO instead of within Firefox. I know that there was this Firefox/OOo add-on/extension, since I has it on my Windows laptop before it crashed to the point I has to reinstall the OS from scratch. I know that there should be a version for Linux, since I remember it on my Ubuntu system spring/summer of last year, before that system required a complete wipe and rebuild. Right now, I cannot find the extension/add-on in my extension/add-on folder for OOo/LO and the one for Firefox/Thunderbird. So I am looking for someone who knows where that link is. Also I run 64-bit OS for Ubuntu, so some of the Firefox add-ons cannot work on a 386-x64 system, and must have a 386-x32 one. I do not know why, since I have the 386 libraries installed to run non-64-bit packages. On 08/08/2011 01:32 PM, Graham Mullan wrote: Don't know if this is what you want? http://blog.arpitnext.com/gpdf Graham -- graham.mul...@coly.org.uk 0117 9502556 or 07887 637064 (or 0844 2327803) On 08/08/2011 18:18, webmaster for Kracked Press Productions wrote: Earlier on this list, there was a thread that talked about a Firefox extension for LibreOffice. I know that Firefox can view .odt files, but I am looking for that Firefox add-on. Can anyone tell me the name of that add-on and maybe a direct link for it? I tried to find it on th Firefox site, but could do. I know there was an OOo extension/add-on for Firefox, but I could not find it either. -- 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] doc-files
Same deal. Use the one Microsoft Excel 97/2000/XP .xls format, not the one that ends with x. On 08/08/2011 01:34 PM, Aarni Järvelä wrote: Sorry guys, but I was talking about Calc/Excel spreadsheets, not Word text documents. -Aarni- On 08.08.2011 20:15, webmaster for Kracked Press Productions wrote: Make sure you save the file as Microsoft Word Win 97/2000/XP .doc format. That way you get one that should work fine. That is the one I use when I have to send a Word document to people. I never had any problems with it. As other will tell you, stay clear of .docx format. Any of the formats that show the x as the forth character are to be avoided. Sometimes, as I have been told by Word users, if you save a document with the latest Word format of .docx using Word 2010, it may not be read properly with Word 2007 or Word 2003 with the format extension/filter MS created for Office 2003 to read 2007 formats. So if MS cannot get their act together to allow their own products to read files saved by their own products, what hope will third-party packages have to be able to read/write those formats 100% of the time. So stick with .doc, and the other per Office 2007 formats. Also, send them the link for LibreOffice, if it is appropriate to do so. let them know that it uses as their default formats, the International Standard formats for Office packages - ODF, while MSO's formats are not. Let them know that the software is free. Many people I have told did not believe it was free, until I stated that fact several times, and some it took a printout of the page stating it was free AND handing the a DVD with the package in it. On 08/08/2011 10:46 AM, soumalya ray wrote: for me,no problem with doc but sometimes faced problem with docx.avoiding it now On 8 August 2011 19:32, Tom Daviestomdavie...@yahoo.co.uk wrote: Hi :) Perhaps give them the link to download LibreOffice and let them know it reads a wider range of formats and is more compatible with a wider range of other programs. Word 2010 is not always compatible with Word 2007 let alone Word 2003. Are you sure you are saving as Doc rather than DocX? The DocX used by default in MS Office 2007 2010 is not able to be read on earlier versions of MS Office without installing extra an extra patch. Do they have problems opening documents from anyone else or do they keep quiet about that? Again it would be a good reason for upgrading to LibreOffice because it can read both. In LibreOffice or OpenOffice choose to Save As Word (97/2000/XP) (scroll back up the list 1 place) rather than the default Word format. Or as Graham says use Rtf to avoid the whole issue. At work i set the older MS Office formats as the default by going to Tools - Options - Load/Save - General Then down at the bottom use the 2 drop-downs to set Text document = Microsoft Word (97/2000/XP) Spreadsheet = Microsoft Excel (97/2000/XP) Presentation = Microsoft Powerpoint (97/2000/XP) For the last 2 it's 2 back up the list as 1 back is a template which is well worth avoiding. On the same page about halfway up i tend to change ODF format version right back from 1.2 Extended (recommended) to 1.0/1.1 because MS Office 2010 2007 can just about read those. I don't know why they haven't tried the newer spec, it's not exactly hidden or difficult or anything. I think the 1.2 was not around in 2007. Further down in the Writer section - Compatibility i tick all the boxes just as the extra finesse. Regards from Tom :) From: Graham Mullangraham.mul...@coly.org.uk To: users@global.libreoffice.org Sent: Mon, 8 August, 2011 14:12:08 Subject: Re: [libreoffice-users] doc-files On 08/08/2011 14:02, Heinrich Stoellinger wrote: Hello, I sometimes have to send files created under LO-Writer to people who use M$-Word. I then store them in .doc-format for sending. From time to time people tell me that they cannot open these files. Has anybody experienced this problem? Regards H. S. This is likely to be a consequence of the particular version of Word that your correspondents are using. A simple answer would be to save the documents in .rtf format instead. Graham -- 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: Virtual bold not workign when printing
BKh wrote (07-08-11 23:30) Apologies. I should have known better. Here goes: Windows XP service pack 3 LibreOffice 3.3.3 OOO330m19 (Build:301) tag libreoffice-3.3.3.1 PRINTER: Samsung SCX-4x28 Series PCL 6 Thanks, The font is Akkhara Regular.ttf. It is no longer available from the original source, but it seems to be at this site: http://www.4shared.com/file/7MTkSMIH/Akkhara_Regular.html Yes, found it. I was hoping there was just some setting I didn't know about. I may not have access to the internet for a few days so I apologize if there is a delay in responding. I don't know such a setting. And testing with 3.3.3 and 3.4.2 on Ubunto shows that for me it works fine. Printer Epson Aculaser. Sorry that I can help you any further, Best, -- - Cor - http://nl.libreoffice.org -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: libreoffice won't open files
On Sun, 2011-08-07 at 16:12 -0700, NoOp wrote: On 08/07/2011 06:49 AM, Dave Howorth wrote: I've had a strange experience recently - libreoffice won't open files. That is File/Open doesn't bring up a dialog box. File/New works and so does using a filename on the command line when starting libreoffice. Libreoffice previously worked fine. Does anybody know what this might be? Or how to diagnose it - I've been unable to find a method to turn on logging from the command-line for example. It's on opensuse 11.3, amd64, standard repository. I'm running LXDE. The program claims to be LibreOffice 3.3 330m19(Build:8). ... Try: Tools|Options|LibreOffice|General|Open/Save dialogs| and try with/without 'Use LibreOffie dialogs'. Uncheck uses your system file manager dialog, checked uses LO's internal dialog. Hmm, there's no such option :( I can choose Tools/Options and it opens a window. Within that I can select LibreOffice - General to select a page/tab/whatever. But there's no Use LibreOffie dialogs buttons/checkboxes/etc. If I click on the Help button on that page and view the topic 'opening;dialogue box settings', it tells me the same thing you do; that there should be such an option. But it's not there. There's options for: - Help - Document status - Year (two digits) - Enable experimental (unstable) features but there's no - LibreOffice Help formatting - Open/Save dialogue boxes I don't know what that means! -- 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: Base and SQLite in Ubuntu 11.04
Simon, Thanks for this it did get me a good way further on but I am having problems installing the driver. ./configure runs OK but sudo make install returns an error make: *** No rule to make target `install'. Stop. I have a .odbc.ini file and have made the necessary edit to point at my database. I can loacte it in LibreOffice now but it also tells me the driver is not installed: [unixODBC][Driver Manager]Data source name not found, and no default driver specified Can you help? Thanks, Graham -- View this message in context: http://nabble.documentfoundation.org/Base-and-SQLite-in-Ubuntu-11-04-tp3233705p3236671.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: libreoffice won't open files
On Mon, 2011-08-08 at 21:26 +0100, Dave Howorth wrote: On Sun, 2011-08-07 at 16:12 -0700, NoOp wrote: Try: Tools|Options|LibreOffice|General|Open/Save dialogs| and try with/without 'Use LibreOffie dialogs'. Uncheck uses your system file manager dialog, checked uses LO's internal dialog. Hmm, there's no such option :( I can choose Tools/Options and it opens a window. Within that I can select LibreOffice - General to select a page/tab/whatever. But there's no Use LibreOffie dialogs buttons/checkboxes/etc. If I click on the Help button on that page and view the topic 'opening;dialogue box settings', it tells me the same thing you do; that there should be such an option. But it's not there. There's options for: - Help - Document status - Year (two digits) - Enable experimental (unstable) features but there's no - LibreOffice Help formatting - Open/Save dialogue boxes I don't know what that means! As a follow-up. I just logged out and logged back in with a Gnome seesion and now there is a 'Use LibreOffice dialogue boxes' checkbox . It's not checked so I'm going to check it and try with LXDE again. -- 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 won't open files
On Mon, 2011-08-08 at 21:33 +0100, Dave Howorth wrote: On Mon, 2011-08-08 at 21:26 +0100, Dave Howorth wrote: On Sun, 2011-08-07 at 16:12 -0700, NoOp wrote: Try: Tools|Options|LibreOffice|General|Open/Save dialogs| and try with/without 'Use LibreOffie dialogs'. Uncheck uses your system file manager dialog, checked uses LO's internal dialog. Hmm, there's no such option :( I can choose Tools/Options and it opens a window. Within that I can select LibreOffice - General to select a page/tab/whatever. But there's no Use LibreOffie dialogs buttons/checkboxes/etc. If I click on the Help button on that page and view the topic 'opening;dialogue box settings', it tells me the same thing you do; that there should be such an option. But it's not there. There's options for: - Help - Document status - Year (two digits) - Enable experimental (unstable) features but there's no - LibreOffice Help formatting - Open/Save dialogue boxes I don't know what that means! As a follow-up. I just logged out and logged back in with a Gnome seesion and now there is a 'Use LibreOffice dialogue boxes' checkbox . It's not checked so I'm going to check it and try with LXDE again. And yes! Now I have dialog boxes in LXDE as well. So thanks very much for solving that. I guess there's a bug there somewhere. If so, how and where should I report it? Thanks again, Dave -- 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 - Would like to see Insert Cut Cells Insert Copied Cells Added to Right-Click Menus
Am 07.08.2011 16:13, Johnny Rosenberg wrote: So what does this ”Insert Copied Cells” actually do? The same as DragAlt+Drop -- 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: Base 3.4.2 doesn't run on Windows 7
Am 07.08.2011 15:00, webmaster for Kracked Press Productions wrote: I remember something about Sun/Oracle older version of Java having problem with LibreOffice, but there is an open-source version that would instead. The one on my Ubuntu system states it is Sun's Java, but the file's name [folder's name] of the runtime engine seems to be Java-6-openjdk. The Problem does not occur on Windows. -- 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: Older versions of LibreOffice
Am 08.08.2011 01:25, NoOp wrote: On 08/07/2011 01:58 PM, Andreas Säger wrote: The Address Book Wizard is the issue - see: https://bugs.freedesktop.org/show_bug.cgi?id=32948 [Address Book Data Source Wizard Doesn't Work] Ah, I see. Didn't know that. The OP did not address the problem clearly. Thank you for clarification, 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
[libreoffice-users] Re: Need Calc help
Am 08.08.2011 19:18, Betti Ann and Preston Smith wrote: Hello Andreas, Thank you for your message and your patience. I am attaching two files - the first one outlines what I am hoping to accomplish and the second one has three tables in a worksheet that provides a shortened typical entry of the files involved and what I hope to see as a result Mailing lists do not support attachments. Upload your files somewhere or register at the communitiy forum http://user.services.openoffice.org/en/forum/index.php where you can upload files of a size up to 100kB each. -- 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] need to find the link
Hi :) For linux there is a separate package rather than an add-on or extension so install from your package manager rather than from inside either LibreOffice or Firefox mozilla-libreoffice I prefer it this way anyway, with some add-ons for FireFox i sometimes have to search for a similar add-on for SeaMonkey and other web-browsers but the 1 package works for both of those and possibly more. Regards from Tom :) From: webmaster for Kracked Press Productions webmas...@krackedpress.com To: users@global.libreoffice.org Sent: Mon, 8 August, 2011 19:06:12 Subject: Re: [libreoffice-users] need to find the link No that is not what I was looking for. It was an add-on for Firefox and LO/OOo that connected the two packages together. It gave an option in Firefox to Open Lo/OOo and pass the ODF file[s] to the office package to oven and view them. Right now, Firefox can read .odt files internally, but if I wanted to view a Draw or Calc file, the add-on would automatically open LO and display the file in LO instead of within Firefox. I know that there was this Firefox/OOo add-on/extension, since I has it on my Windows laptop before it crashed to the point I has to reinstall the OS from scratch. I know that there should be a version for Linux, since I remember it on my Ubuntu system spring/summer of last year, before that system required a complete wipe and rebuild. Right now, I cannot find the extension/add-on in my extension/add-on folder for OOo/LO and the one for Firefox/Thunderbird. So I am looking for someone who knows where that link is. Also I run 64-bit OS for Ubuntu, so some of the Firefox add-ons cannot work on a 386-x64 system, and must have a 386-x32 one. I do not know why, since I have the 386 libraries installed to run non-64-bit packages. On 08/08/2011 01:32 PM, Graham Mullan wrote: Don't know if this is what you want? http://blog.arpitnext.com/gpdf Graham -- graham.mul...@coly.org.uk 0117 9502556 or 07887 637064 (or 0844 2327803) On 08/08/2011 18:18, webmaster for Kracked Press Productions wrote: Earlier on this list, there was a thread that talked about a Firefox extension for LibreOffice. I know that Firefox can view .odt files, but I am looking for that Firefox add-on. Can anyone tell me the name of that add-on and maybe a direct link for it? I tried to find it on th Firefox site, but could do. I know there was an OOo extension/add-on for Firefox, but I could not find it either. -- 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] Ping Andrew Douglas Pitonyak - password macro
Andrew, In attempting to help Bob Stia in the 'password problem' thread, I came across this macro: http://sourceforge.net/projects/ooomacros/files/PasswordCracker/Version%201.0/ This works *if* you have the *exact* password in the password file. Unfortunately it doesn't take regex etc., so it's only useful if the exact password is in the dictionary/password file. Is there any way to modify the macro so that it will try variations? Example: Password is 'test'. - try 't' and combinations of 't' for length 4. similar to pdfcrack. -- 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: Need Calc help
I have uploaded the information to the Calc Section of the OpenOffice Forum - it is titled 'Compare Two Files' Thanks again for your assistance, Preston On 8/8/2011 5:43 PM, Andreas Säger wrote: Am 08.08.2011 19:18, Betti Ann and Preston Smith wrote: Hello Andreas, Thank you for your message and your patience. I am attaching two files - the first one outlines what I am hoping to accomplish and the second one has three tables in a worksheet that provides a shortened typical entry of the files involved and what I hope to see as a result Mailing lists do not support attachments. Upload your files somewhere or register at the communitiy forum http://user.services.openoffice.org/en/forum/index.php where you can upload files of a size up to 100kB each. -- 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] doc-files
Graham, On Mon, 2011-08-08 at 18:23 +0100, Graham Mullan wrote: One area where M$ Word still scores over LO is in the use of track-changes. I know many editors and authors who stay with M$ because the in-text change tracking that LO (and OO) use is much trickier to use than the in-margin alternative available in the M$ version. If the latter could be added to LO, then I can guarantee a lot more users. Graham -- graham.mul...@coly.org.uk Could post a suggestion with bugzilla https://bugs.freedesktop.org/ and note ii is feature request. That why the devs will know about it. -- Jay Lozier jsloz...@gmail.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 won't open files
On 08/08/2011 01:37 PM, Dave Howorth wrote: On Mon, 2011-08-08 at 21:33 +0100, Dave Howorth wrote: On Mon, 2011-08-08 at 21:26 +0100, Dave Howorth wrote: On Sun, 2011-08-07 at 16:12 -0700, NoOp wrote: Try: Tools|Options|LibreOffice|General|Open/Save dialogs| and try with/without 'Use LibreOffie dialogs'. Uncheck uses your system file manager dialog, checked uses LO's internal dialog. Hmm, there's no such option :( I can choose Tools/Options and it opens a window. Within that I can select LibreOffice - General to select a page/tab/whatever. But there's no Use LibreOffie dialogs buttons/checkboxes/etc. If I click on the Help button on that page and view the topic 'opening;dialogue box settings', it tells me the same thing you do; that there should be such an option. But it's not there. There's options for: - Help - Document status - Year (two digits) - Enable experimental (unstable) features but there's no - LibreOffice Help formatting - Open/Save dialogue boxes I don't know what that means! As a follow-up. I just logged out and logged back in with a Gnome seesion and now there is a 'Use LibreOffice dialogue boxes' checkbox . It's not checked so I'm going to check it and try with LXDE again. And yes! Now I have dialog boxes in LXDE as well. So thanks very much for solving that. I guess there's a bug there somewhere. If so, how and where should I report it? Cool! Glad you got it sorted out. Use link that planas provided to report the bug for LO general. However, if your version is opensuse specific (opensuse 11.3, amd64, standard repository), then I'd recommend that you report it in your standard opensuse bug reporting channels as that build is an opensuse build rather than a standard LO build. Before you do that, you could try installing the standard LO version and see if it exhibits the same symptom(s) - I'd test but I don't have opensuse running in a virtual machine any longer my test machine with lxde is currently down. -- 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 won't open files
Hi :) The headings you listed are there but there is an additional heading just after the first one. - Help - Open/Save dialogue boxes - Document status - Year (two digits) It might be good to try renaming your LibreOffice config/user-profile to see if that has been blocking something. On a command-line try sudo mv /home/username/.libreoffice/3/user /home/username/.libreoffice/3/2011-08-09 If openSUSE doesn't have a sudo command then try su mv /home/username/.libreoffice/3/user /home/username/.libreoffice/3/2011-08-09 Note there is a space between user and the 2nd /home also replace username with the name you logged in with. Tab-complete can help get the spelling right even in a pathname. When i rename a folder like that i use reverse date order rather than something like backup or something equally vague in order to help me find the right one reasonably easily. I sometimes open files by opening the program and then just dragdrop the file i wanted to open into an appropriate part of the window. If i get a wrong part in LibreOffice it gives me a nice looking icon on the blank page. Good luck and regards from Tom :) From: Dave Howorth d...@howorth.org.uk To: users@global.libreoffice.org Sent: Mon, 8 August, 2011 21:26:58 Subject: Re: [libreoffice-users] Re: libreoffice won't open files On Sun, 2011-08-07 at 16:12 -0700, NoOp wrote: On 08/07/2011 06:49 AM, Dave Howorth wrote: I've had a strange experience recently - libreoffice won't open files. That is File/Open doesn't bring up a dialog box. File/New works and so does using a filename on the command line when starting libreoffice. Libreoffice previously worked fine. Does anybody know what this might be? Or how to diagnose it - I've been unable to find a method to turn on logging from the command-line for example. It's on opensuse 11.3, amd64, standard repository. I'm running LXDE. The program claims to be LibreOffice 3.3 330m19(Build:8). ... Try: Tools|Options|LibreOffice|General|Open/Save dialogs| and try with/without 'Use LibreOffie dialogs'. Uncheck uses your system file manager dialog, checked uses LO's internal dialog. Hmm, there's no such option :( I can choose Tools/Options and it opens a window. Within that I can select LibreOffice - General to select a page/tab/whatever. But there's no Use LibreOffie dialogs buttons/checkboxes/etc. If I click on the Help button on that page and view the topic 'opening;dialogue box settings', it tells me the same thing you do; that there should be such an option. But it's not there. There's options for: - Help - Document status - Year (two digits) - Enable experimental (unstable) features but there's no - LibreOffice Help formatting - Open/Save dialogue boxes I don't know what that means! -- 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 won't open files
Hi :) It might be a good plan to post the bug-report in both places. Here is link to the LO guide on bug-reporting. It's got the link in there somewhere http://wiki.documentfoundation.org/BugReport If you do post the bug in both places then it helps to give the url of the other as a 2nd comment or something so that people can easily check on progress in the other thread. I agree with NoOp that probably the best place to report it initially is in the openSUSE space instead of the LO one, especially since you have narrowed it down to a problem with their tweaked version on their LxDE. It doesn't really matter where since both projects have quite a few devs. Regards from Tom :) From: NoOp gl...@sbcglobal.net To: users@global.libreoffice.org Sent: Tue, 9 August, 2011 0:08:05 Subject: [libreoffice-users] Re: libreoffice won't open files On 08/08/2011 01:37 PM, Dave Howorth wrote: On Mon, 2011-08-08 at 21:33 +0100, Dave Howorth wrote: On Mon, 2011-08-08 at 21:26 +0100, Dave Howorth wrote: On Sun, 2011-08-07 at 16:12 -0700, NoOp wrote: Try: Tools|Options|LibreOffice|General|Open/Save dialogs| and try with/without 'Use LibreOffie dialogs'. Uncheck uses your system file manager dialog, checked uses LO's internal dialog. Hmm, there's no such option :( I can choose Tools/Options and it opens a window. Within that I can select LibreOffice - General to select a page/tab/whatever. But there's no Use LibreOffie dialogs buttons/checkboxes/etc. If I click on the Help button on that page and view the topic 'opening;dialogue box settings', it tells me the same thing you do; that there should be such an option. But it's not there. There's options for: - Help - Document status - Year (two digits) - Enable experimental (unstable) features but there's no - LibreOffice Help formatting - Open/Save dialogue boxes I don't know what that means! As a follow-up. I just logged out and logged back in with a Gnome seesion and now there is a 'Use LibreOffice dialogue boxes' checkbox . It's not checked so I'm going to check it and try with LXDE again. And yes! Now I have dialog boxes in LXDE as well. So thanks very much for solving that. I guess there's a bug there somewhere. If so, how and where should I report it? Cool! Glad you got it sorted out. Use link that planas provided to report the bug for LO general. However, if your version is opensuse specific (opensuse 11.3, amd64, standard repository), then I'd recommend that you report it in your standard opensuse bug reporting channels as that build is an opensuse build rather than a standard LO build. Before you do that, you could try installing the standard LO version and see if it exhibits the same symptom(s) - I'd test but I don't have opensuse running in a virtual machine any longer my test machine with lxde is currently down. -- 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: libreoffice won't open files
On 08/08/2011 04:30 PM, Tom Davies wrote: Hi :) The headings you listed are there but there is an additional heading just after the first one. - Help - Open/Save dialogue boxes - Document status - Year (two digits) It might be good to try renaming your LibreOffice config/user-profile to see if that has been blocking something. Did you not *read* the thread? quote Thanks for the reply. I've just tried moving .libreoffice to .libreoffice.sav (the contents of which are a single directory called 3-suse) and starting libreoffice. The results are unchanged: /quote ... -- 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 won't open files
On 08/08/2011 04:38 PM, Tom Davies wrote: Hi :) It might be a good plan to post the bug-report in both places. Here is link to the LO guide on bug-reporting. It's got the link in there somewhere http://wiki.documentfoundation.org/BugReport Did you not *read* the thread? planas/Jay already provided the link: quote The link to report bugs is https://bugs.freedesktop.org/ Once set up an account you can submit your report to the LO. You will see many projects so just scroll down till you see LO. /quote ... -- 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] Landscape Printing Format - Problem
I'm having problems trying to print documents in Lanscape format. Although the text appears nrmal in the print preview in the printed version the text is stretched horizontally and the individual characters run into each other. This occurs both with Calc and Writer. Does anyone have any suggestions? My OS is Zenwalk (Linux) and the version of LibreOffice is 3.3 Thanks, John -- 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] Ping Andrew Douglas Pitonyak - password macro
On 08/08/2011 06:56 PM, NoOp wrote: Andrew, In attempting to help Bob Stia in the 'password problem' thread, I came across this macro: http://sourceforge.net/projects/ooomacros/files/PasswordCracker/Version%201.0/ Interesting. I am familiar with the author. He has provided much advice to the community. This works *if* you have the *exact* password in the password file. Unfortunately it doesn't take regex etc., so it's only useful if the exact password is in the dictionary/password file. Is there any way to modify the macro so that it will try variations? yes Example: Password is 'test'. - try 't' and combinations of 't' for length 4. similar to pdfcrack. Would probably require some work to write it as you desire. For a one shot deal, however, it might be just as easy to simply generate a text file created in a spreadsheet. Otherwise, you would want to remove the file I/O related commands such as: Opening the file: iFile = FreeFile () open sDicFile for input as iFile ** Rather than opening a file, you would initialize your test password with something. Closing the file: close #iFile Reading the file: Line Input #iFile, sPass Rather than reading the file, you simply need to automatically choose the next password based on the current password. At one time, I wrote a checker that would check based on some assumed characters. I posted the code on the OOo forum. http://www.oooforum.org/forum/viewtopic.phtml?t=23014 -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] new book
On 08/08/2011 08:54 AM, webmaster for Kracked Press Productions wrote: On 08/08/2011 08:04 AM, Andrew Douglas Pitonyak wrote: On 08/06/2011 08:55 AM, webmaster for Kracked Press Productions wrote: On 08/05/2011 05:46 PM, Andrew Douglas Pitonyak wrote: On 08/05/2011 08:59 AM, webmaster for Kracked Press Productions wrote: On 08/05/2011 08:49 AM, rogerio dandrea wrote: new book http://www.pitonyak.org/OOME_3_0.odt :0) thanks Pitonyak for the excellent work :0) From Brazil 498 pages worth of Macros Explained could help a lot of people on these lists. Have downloaded it and exported it as a PDF file. I usually upload the current PDF version when I upload the ODT version. (for what it is worth). All I had was the link to the .odt file. I always make PDF copies of every .odt file I download. I cannot wait to see what the book is like next. Please, would you list the link again. This time I might remember to bookmark the page for later use. I always need online [and offline] sources of documentation for people I have convinced to switch to LibreOffice. Documentation for Base and Macros are asked about. I do not use Base at all and rarely use macros, but I deal with people who deal with data bases and creating macros. Thanks for your book and the work you do to present this information to others. Most of my OOo content http://www.pitonyak.org/oo.php German Translation (in progress) of OOME version 3.0 http://www.uni-due.de/~abi070/ooo.html Thanks I always need web links to LibreOffice [and OOo when no LO one are available] to pass along to people I deal with. 1] Would you want your page/book link a part of the Documentation Page[s] for the North American Community DVD Project? 2] Would you allow the PDF version to be included on the DVD as well as a link to your site? Here is the two links to the online version[s] of the NA DVD. LibreOffice's CMS system version - being worked on http://dvd.north-america.libreofficebox.org/en/ my domain - Original site for online DVD testing site [for now - the most up-to-date - till the CMS version catches up] http://libreoffice-na.us/ I have no problems with a copy of the documents from my site being included. Eventually, however, printed copies will be offered for sale. I have already spoken with Jean Weber about making this happen in a way that will involve the community hosting and providing the printing with a portion of the sales supporting the community. My only point to this is that for the most part, Jean Weber knows more about the details related to the stated license or copyright and how that works. Note that some documents are already released using this model. I am currently working on one of the getting started Macro chapters for the official LO documentation. Hmm, I have no idea if the LO authors group offers printed copies yet, or if that is only ODF authors (in my mind, they are strongly related). -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Develops, bring the classic icons back, pls
On Thu, 04 Aug 2011 14:20:53 +0200, OBUTEX/Hladůvka ad...@obutex.com wrote: The option Classic style is there missing and the default Galaxy I don't like. After I copied the mentioned file I can find the classic style among other options; the icons are OK but the three icons =f(x) , cancel and OK are only placeholders. Best regards, Jiri what do u mean? does the Classic LibO 3.4 compliant theme you downloaded from Bugzilla misses any icons? can you provide a screenshot? -- 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
