Re: [libreoffice-users] Which components do you use most?
For me: Calc90% of my LO use Writer 8% Base1 have never had a use that really needs it. Draweven less than base Ian On 12/05/2014, at 1:31 PM, som drsoumalya-l...@yahoo.co.in wrote: On , som drsoumalya-l...@yahoo.co.in wrote: On Monday, 12 May 2014 3:25 AM, Virgil Arrington cuyfa...@hotmail.com wrote: I'm curious to find out what components of LO are used most by the people on this list. Writer (85% of my use of LO) Calc(10%) Impress (3%, Maybe four to five presentations a year) Base (once a year to print out labels for my Christmas cards) Draw (What's that?) hi virgil, its a very interesting topic. for me, writer: 80-85% calc: not much (most of the analysis done on PSPP/R) impress: 15-20% base: none (could not understand) draw: once/twice a year (mainly for poster presentation in conferences) regards, som -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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] Which components do you use most?
Hello, I know this does not add up to 100%, but then - most of the time I use a combination of parts of LO together. So... Writer most of the time Calc 15 to 20% Impress3%, Maybe four to five presentations a year Base most of the time (I use it to interface to a MySQL-DB which is the base for the administration of a 50-piece band (music, performances, sponsors, uniforms, etc., etc.) Draw hardly used at all... Regards Heinrich -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- To unsubscribe e-mail to: users+unsubscr...@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] Native Connector
Thanks a lot, Girvin... My situation is exactly as you describe it. I used to run my own server, installing everything from Linux to Apache2, PHP, mail, MySQL, etc. Therefore I had the possibility to set my OWN parameters for MySQL. For cost and other reasons I changed to a stripped-down web-hosting structure and therefore have stopped being my own admin I also think that 60 seconds is an inappropriate value for the wait_timeout because it doesn't even allow you to go have a quick coffee (or other, more pressing things...). Yes, in MY situation it would be great if the native connector supported a kind of automatic reconnect after the SERVER (nothing to do with LO-Base!) shuts down an idle connection (in my case in 60 seconds, even though 28800 would be allowed!!! Regards from Austria H. S. On Mon, 12 May 2014 00:35:48 +0200, anne-ology lagin...@gmail.com wrote: Well, that autoReconnect=true must have something to do with JAVA ... I 'searched' and uncovered nearly 100,000 articles [whew ;-) ] https://www.google.com/search?q=autoReconnect%3Dtrueie=utf-8oe=utf-8aq=trls=org.mozilla:en-US:officialclient=firefox-achannel=sb BTW - when opening up the first few, I noticed others are asking the same question re. this timing out ???!!!???!!!??? Oops - Something tells me I should quit calling this machine a glorified-typewriter; maybe it will want revenge and blow up ... ... ... my mouse already died this year; had to replace the li'l fella' ;-) From: Girvin Herr girvin.h...@sbcglobal.net Date: Sun, May 11, 2014 at 2:53 PM Subject: Re: [libreoffice-users] Native Connector To: users@global.libreoffice.org Yes, if I understand Mr. Stoellinger's problem correctly, it is the MySQL server (aka back-end) which is dropping his connection. According to my MySQL documentation, by default, the MySQL server drops any connection after 8 hours of continuous connection. However, Mr. Stoellinger's admin has reduced that time to 60 seconds! IMHO, that is ridiculous, but it must be the policy at his institution, so he must live with it. The MySQL connector driver that he has been using has a workaround by triggering a reconnect operation every so often, effectively restarting the 60-second timer. That is the purpose of the autoReconnect=true connector driver parameter he talks about. Now, it appears that the new LO Base has a MySQL native driver that replaces the Oracle MySQL-connector-java driver that he most likely has been using and he needs to know if the new LO native driver supports the reconnect schema and if so, how to implement it. As far as I know, no one on this list so far has given him the answer to that question. I have no experience with the new native driver (yet), so I do not have the answer. If the native driver does not support it, or he does not get an answer, I would suggest keeping the Oracle JDBC driver until he gets his answer, if the new LO still allows replacement of the native built-in driver. BTW: I am my own admin, so my MySQL server is still set to the default timeout, if any. Therefore, I do not experience this disconnect problem. However, every so often, I see a posting about it on this forum, so he is not alone. HTH. Girvin Herr On 05/10/2014 03:37 PM, Tom Davies wrote: Hi :) It's the 2nd one Anne-ology. The connector is some sort of bridge between Base and MySql. It's the bridge that is timing out rather than the computer afaik. Regards from Tom :) On 10 May 2014 22:13, anne-ology lagin...@gmail.com wrote: If you're referring to the computer-machine shutting down and/or entering sleep-mode, then there's a simple solution; if you're referring to something else - well, I haven't a clue. If the 1st - go to properties/options/ and re-set the timing mechanism to never shut down; you can also do similarly in various programs - as LO - which otherwise decide they want to save every so often, causing me to lose my train of thought while writing ;-) If the 2nd - I'll be awaiting someone else's response on this list; and will attempt to figure out what's what ;-) From: Heinrich Stoellinger hc.stoellin...@aon.at Date: Sat, May 10, 2014 at 8:08 AM Subject: [libreoffice-users] Native Connector To: users@global.libreoffice.org users@global.libreoffice.org Hello, It's good to see a native connector for MySQL under 4.2. One question: In the server my.cnf the value for wait_timeout is set to 60 seconds and will not be increased. This is a nuisance if one needs to be connected over longer periods but sometimes has to go away from there client for more than a minute. Under the JDBC-connector there is a possibility to specify ?auto-reconnect=true after the database name. Is there some facility like that under the native connector? Regards H. Stoellinger -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ --
Re: *** SPAM *** [libreoffice-users] Re: Native Connector
On Mon, 12 May 2014 06:37:09 +0200, Alex Thurgood alex.thurg...@gmail.com wrote: Le 10/05/2014 15:08, Heinrich Stoellinger a écrit : Hi Heinrich, You do not give the whole story : - which connector are you talking about, where did you get it ? It is not supplied by default with official builds of LO, so either it has been included as a packet with your Linux distribution, or else you have got it from somewhere else ; I use JDBC-Connector mysql-connector-java-5.1.30-bin.jar; can't tell you where I got it from, certainly not from a Linux-distribution (I run Debian-Wheezy and Mint-16 respectively). - as for the autoreconnect, have you tried adding this as a parameter in the database URL when you set up the connection (i.e. as you would with the JDBC connector) - alternatively, is there anything in the Advanced Properties of the database connection ? Yes, with a JDBC-Connection (not in the native connection case!) one can specify ?autoReconnect=true right after the database name. The connector obviously uses this parameter to automatically reconnect to the server when the latter closes the connection after the idle time specified in my.cnf (or defaulted to the MUCH higher value mentioned by Girvin). If there isn't, or if the suggestion I made above doesn't work, then I doubt that it is possible. The only other alternative is to shut down the ODB and re-open it periodically. I don't have to shut down the ODB --- see above! Heinrich Alex -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- To unsubscribe e-mail to: users+unsubscr...@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] Native Connector
Hello Girvin, Yes, I will keep on using the JDBC-Driver, hoping that the native connector will support autoreconnect some time in the future. If LO drops JDBC, I have to look for a different Office system. To suggest restarting LO every time after having to go away for a short break really is NOT feasible in reality. Regards Heinrich P.S.: What do you guys think of Conchita winning the Eurovision song contest -- but THAT certainly should NOT start a new thread...(smiley!) On Sun, 11 May 2014 21:53:25 +0200, Girvin Herr girvin.h...@sbcglobal.net wrote: Yes, if I understand Mr. Stoellinger's problem correctly, it is the MySQL server (aka back-end) which is dropping his connection. According to my MySQL documentation, by default, the MySQL server drops any connection after 8 hours of continuous connection. However, Mr. Stoellinger's admin has reduced that time to 60 seconds! IMHO, that is ridiculous, but it must be the policy at his institution, so he must live with it. The MySQL connector driver that he has been using has a workaround by triggering a reconnect operation every so often, effectively restarting the 60-second timer. That is the purpose of the autoReconnect=true connector driver parameter he talks about. Now, it appears that the new LO Base has a MySQL native driver that replaces the Oracle MySQL-connector-java driver that he most likely has been using and he needs to know if the new LO native driver supports the reconnect schema and if so, how to implement it. As far as I know, no one on this list so far has given him the answer to that question. I have no experience with the new native driver (yet), so I do not have the answer. If the native driver does not support it, or he does not get an answer, I would suggest keeping the Oracle JDBC driver until he gets his answer, if the new LO still allows replacement of the native built-in driver. BTW: I am my own admin, so my MySQL server is still set to the default timeout, if any. Therefore, I do not experience this disconnect problem. However, every so often, I see a posting about it on this forum, so he is not alone. HTH. Girvin Herr On 05/10/2014 03:37 PM, Tom Davies wrote: Hi :) It's the 2nd one Anne-ology. The connector is some sort of bridge between Base and MySql. It's the bridge that is timing out rather than the computer afaik. Regards from Tom :) On 10 May 2014 22:13, anne-ology lagin...@gmail.com wrote: If you're referring to the computer-machine shutting down and/or entering sleep-mode, then there's a simple solution; if you're referring to something else - well, I haven't a clue. If the 1st - go to properties/options/ and re-set the timing mechanism to never shut down; you can also do similarly in various programs - as LO - which otherwise decide they want to save every so often, causing me to lose my train of thought while writing ;-) If the 2nd - I'll be awaiting someone else's response on this list; and will attempt to figure out what's what ;-) From: Heinrich Stoellinger hc.stoellin...@aon.at Date: Sat, May 10, 2014 at 8:08 AM Subject: [libreoffice-users] Native Connector To: users@global.libreoffice.org users@global.libreoffice.org Hello, It's good to see a native connector for MySQL under 4.2. One question: In the server my.cnf the value for wait_timeout is set to 60 seconds and will not be increased. This is a nuisance if one needs to be connected over longer periods but sometimes has to go away from there client for more than a minute. Under the JDBC-connector there is a possibility to specify ?auto-reconnect=true after the database name. Is there some facility like that under the native connector? Regards H. Stoellinger -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- To unsubscribe e-mail to: users+unsubscr...@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 -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- To unsubscribe e-mail to: users+unsubscr...@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] Which components do you use most?
On 11/05/2014 22:53, Virgil Arrington wrote: I'm curious to find out what components of LO are used most by the people on this list. I think it helps to know different folks' area of experience. It might also help us in learning new ways to integrate the different components. For myself, my approximate usage is: Writer: 4% Calc: 95% mainly for text manipulation (it's fast enough to be usable with the complex spreadsheets I use, but only just) Draw: 1% David Lynch -- To unsubscribe e-mail to: users+unsubscr...@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: Automating creation of PDF from Calc
Well eventually I seem to be getting somewhere. There seems to be a lot of choice. There are some people who use the method of hiding all the sheets except the sheet to be converted into a PDF. Which is the method I used below. Another methed seems to be to use printareas. To me this only seemed useful if one wanted to print a specific section of a sheet. Though I didn't quite master the intricacies of swithing on/off print areas though thgis code started to look promising - rem -- rem define variables dim oFrame as object dim oDispatcher as object Dim CellRangeAddress As New com.sun.star.table.CellRangeAddress Dim oDoc As Object Dim oSheet As Object Dim oFirstSheet As Object Dim iEndCol As Integer Dim aPrintRanges(0) As Object oDoc = ThisComponent oFirstSheet = oDoc.Sheets.getByIndex( 0 ) iEndCol = getLastUsedColumn(oFirstSheet) rem -- rem get access to the document oFrame = ThisComponent.CurrentController.Frame oDispatcher = createUnoService(com.sun.star.frame.DispatchHelper) rem -- CellRangeAddress.Sheet = 0 CellRangeAddress.StartColumn = 0 CellRangeAddress.StartRow = 0 CellRangeAddress.EndColumn = 6 CellRangeAddress.EndRow = 35 aPrintRanges(0)=CellRangeAddress oDoc.Sheets.getByIndex(0 ).setPrintAreas(aPrintRanges()) I used this method to erase the print areas on particular sheets so that the entire sheet became printable. oDoc.Sheets.getByIndex(1 ).AutomaticPrintArea=True The third method which seems to be the most promising selects the range of cells to be PDF'd and actually uses a method from the API. I cobbled this together from this tutorial https://wiki.openoffice.org/wiki/API/Tutorials/PDF_export and Andrew Pitonyak’s book converting from Java as I went along Sub exporttopdf1() Dim oFrame as object, oDispatcher as object, oDoc as object, oController as object, oSheet as object Dim oRange as object, oDispatcherService as object, oSelection as object Dim aFilterData(0) as new com.sun.star.beans.PropertyValue Dim aMediaDescriptor(1) as new com.sun.star.beans.PropertyValue oDocument = ThisComponent oFirstSheet = oDocument.Sheets(0) oSecondSheet = oDocument.Sheets(1) oController = oDocument.getCurrentController() oFrame = oController.getFrame() oDispatcherService = createUnoService(com.sun.star.frame.DispatchHelper) oRange = oFirstSheet.getCellRangeByPosition(0, 0, getLastUsedColumn(oFirstSheet), 3) oController.Select(oRange) oSelection = ThisComponent.getCurrentController().getSelection() sURL= file:///home/alex/example1.pdf aFilterData(0).Name = Selection aFilterData(0).Value = oSelection aMediaDescriptor(0).Name = FilterName aMediaDescriptor(0).Value = calc_pdf_Export aMediaDescriptor(1).Name = FilterData aMediaDescriptor(1).Value = aFilterData oDocument.storeToURL(sURL, aMediaDescriptor) End Sub All the best Alex On Thursday 08 May 2014 14:23:06 you wrote: Hi all I have a requirement to generate PDF's from specific set sheets contained in one Calc document, the document has 85 individual sheets. I've generated a macro to do this, having first recorded the steps using the macro recorder. Though the steps to record the macro worked perfectly as only the individual selection, i.e, all the cells on a specific sheet, was generated as a PDF. If I then run the macro with the same selection it always creates a PDF of the entire document - all 85 sheets instead of just the selection! Here's the recorded macro, note the selection $A$1:$G$35 sub exporttopdf rem -- rem define variables dim document as object dim dispatcher as object rem -- rem get access to the document document = ThisComponent.CurrentController.Frame dispatcher = createUnoService(com.sun.star.frame.DispatchHelper) rem -- dim args1(0) as new com.sun.star.beans.PropertyValue args1(0).Name = ToPoint args1(0).Value = $A$1:$G$35 dispatcher.executeDispatch(document, .uno:GoToCell, , 0, args1()) rem -- dim args2(2) as new com.sun.star.beans.PropertyValue args2(0).Name = URL args2(0).Value = file:///home/alex/example.pdf args2(1).Name = FilterName args2(1).Value = calc_pdf_Export args2(2).Name = FilterData args2(2).Value = Array( _ Array(UseLosslessCompression,0,false,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(Quality,0,90,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(ReduceImageResolution,0,false,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(MaxImageResolution,0,300,com.sun.star.beans.PropertyState.DIRECT_VALUE), _
[libreoffice-users] Re: *** SPAM *** Re: Native Connector
Le 12/05/2014 09:03, Heinrich Stoellinger a écrit : Hi Heinrich, I use JDBC-Connector mysql-connector-java-5.1.30-bin.jar; can't tell you where I got it from, certainly not from a Linux-distribution (I run Debian-Wheezy and Mint-16 respectively). You stated initially that you were using the native connector - where did you get it from ? I don't have to shut down the ODB --- see above! Heinrich Yes, in other words, it works with the JDBC connector, but not the mysql-native C/C++ connector, this has always been the case, as far as I know. The JDBC has a far broader range of acceptable connection parameters than the native connector. Alex -- To unsubscribe e-mail to: users+unsubscr...@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: Automating creation of PDF from Calc
Alex , using the Dispatcher is not a good idea , use te API and basic to automate some functions as printing to PDF under specific conditions. Please find below the code i use to print from a Writer doc Sub export2PDF() dim oDoc as object CheckReportUser() sParent = checkparent OpenParams = Array(MakePropertyValue(Hidden,True),) odoc = ThisComponent 'dispatcher = createUnoService(com.sun.star.frame.DispatchHelper) aray = Split(Date,/) D = Join(aray,-) aray = Split(Time,:) T = Join(aray,.) 'path = ConvertToUrl( file:///C:/export/test D _ T .pdf ) sfilename = left(odoc.title,12) .pdf path = ConvertToUrl( file:///H:/LowRes_ sfilename ) ' 'all documentation about filderdata: http://wiki.services.openoffice.org/wiki/API/Tutorials/PDF_export#PDF_Export_filter_data '** pdfFilterData() = array((makepropertyvalue(UseLosslessCompression, false)) AddPropertyValue(pdfFilterData,Quality,90) ' only if we set UseLosslessCompression to FALSE ( jpg) 'AddPropertyValue(pdfFilterData,ReduceImageResolution,false) 'AddPropertyValue(pdfFilterData,MaxImageResolution,300) ' only if we set ReduceImageResolution to TRUE (only 75, 150, 300, 600 or 1200 can been used AddPropertyValue(pdfFilterData,UseTaggedPDF,false) AddPropertyValue(pdfFilterData,SelectPdfVersion,0) '0= pdf1.4 , 1= pdf-xa AddPropertyValue(pdfFilterData,ExportNotes,false) AddPropertyValue(pdfFilterData,ExportBookmarks,false) AddPropertyValue(pdfFilterData,OpenBookmarkLevels,-1) AddPropertyValue(pdfFilterData,UseTransitionEffects,true) AddPropertyValue(pdfFilterData,IsSkipEmptyPages,true) AddPropertyValue(pdfFilterData,IsAddStream,false) AddPropertyValue(pdfFilterData,EmbedStandardFonts,false) AddPropertyValue(pdfFilterData,FormsType,0) AddPropertyValue(pdfFilterData,ExportFormFields,true) AddPropertyValue(pdfFilterData,AllowDuplicateFieldNames,false) AddPropertyValue(pdfFilterData,HideViewerToolbar,false) AddPropertyValue(pdfFilterData,HideViewerMenubar,false) AddPropertyValue(pdfFilterData,HideViewerWindowControls,false) AddPropertyValue(pdfFilterData,ResizeWindowToInitialPage,false) AddPropertyValue(pdfFilterData,CenterWindow,false) AddPropertyValue(pdfFilterData,OpenInFullScreenMode,false) AddPropertyValue(pdfFilterData,DisplayPDFDocumentTitle,true) AddPropertyValue(pdfFilterData,InitialView,0) AddPropertyValue(pdfFilterData,Magnification,0) AddPropertyValue(pdfFilterData,Zoom,100) AddPropertyValue(pdfFilterData,PageLayout,0) AddPropertyValue(pdfFilterData,FirstPageOnLeft,false) AddPropertyValue(pdfFilterData,InitialPage,1) AddPropertyValue(pdfFilterData,Printing,2) AddPropertyValue(pdfFilterData,Changes,4) AddPropertyValue(pdfFilterData,EnableCopyingOfContent,true) AddPropertyValue(pdfFilterData,EnableTextAccessForAccessibilityTools,true) AddPropertyValue(pdfFilterData,ExportLinksRelativeFsys,false) AddPropertyValue(pdfFilterData,PDFViewSelection,0) AddPropertyValue(pdfFilterData,ConvertOOoTargetToPDFTarget,false) AddPropertyValue(pdfFilterData,ExportBookmarksToPDFDestination,false) AddPropertyValue(pdfFilterData,_OkButtonString,) AddPropertyValue(pdfFilterData,EncryptFile,false) AddPropertyValue(pdfFilterData,DocumentOpenPassword,) AddPropertyValue(pdfFilterData,RestrictPermissions,false) AddPropertyValue(pdfFilterData,PermissionPassword,) oExport = Array( _ MakePropertyValue(Overwrite, True), _ MakePropertyValue(FilterName, writer_pdf_Export), _ MakePropertyValue(FilterData, pdfFilterData), _ ) oDoc.storeTOURL(path,oExport) ' oDoc.close(True) End Sub Well eventually I seem to be getting somewhere. There seems to be a lot of choice. There are some people who use the method of hiding all the sheets except the sheet to be converted into a PDF. Which is the method I used below. Another methed seems to be to use printareas. To me this only seemed useful if one wanted to print a specific section of a sheet. Though I didn't quite master the intricacies of swithing on/off print areas though thgis code started to look promising - rem -- rem define variables dim oFrame as object dim oDispatcher as object Dim CellRangeAddress As New com.sun.star.table.CellRangeAddress Dim oDoc As Object Dim oSheet As Object Dim oFirstSheet As Object Dim iEndCol As Integer Dim aPrintRanges(0) As Object oDoc = ThisComponent oFirstSheet = oDoc.Sheets.getByIndex( 0 ) iEndCol = getLastUsedColumn(oFirstSheet) rem -- rem get access to the document oFrame = ThisComponent.CurrentController.Frame oDispatcher = createUnoService(com.sun.star.frame.DispatchHelper) rem -- CellRangeAddress.Sheet = 0 CellRangeAddress.StartColumn = 0 CellRangeAddress.StartRow = 0 CellRangeAddress.EndColumn = 6 CellRangeAddress.EndRow = 35 aPrintRanges(0)=CellRangeAddress oDoc.Sheets.getByIndex(0
[libreoffice-users] print table without internal borders
Good evening I am sure, this is a stupid question. I have a table (cover sheet for medical records) with all sorts of lines at the top and all around. However, I would prefer NOT to print the borders between some 30 questions below that. Only an outer border around the whole thing. I checked table properties, format etc., set the area to no lines etc. but so far no setting has changed how the table looks in the print preview. The documentation also gives only the explanations about table properties etc. Surely there is a very simple trick. I just cannot figure it out. If anybody has the time to give me a hint, I would be very grateful. Thank you. Thomas -- To unsubscribe e-mail to: users+unsubscr...@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] Which components do you use most?
Writer: 30% Calc: 60% Impress:4% Base: 5% Draw: 1% Cheers Harvey On Mon, 2014-05-12 at 11:31 +0800, som wrote: On , som drsoumalya-l...@yahoo.co.in wrote: On Monday, 12 May 2014 3:25 AM, Virgil Arrington cuyfa...@hotmail.com wrote: I'm curious to find out what components of LO are used most by the people on this list. Writer (85% of my use of LO) Calc(10%) Impress (3%, Maybe four to five presentations a year) Base (once a year to print out labels for my Christmas cards) Draw (What's that?) hi virgil, its a very interesting topic. for me, writer: 80-85% calc: not much (most of the analysis done on PSPP/R) impress: 15-20% base: none (could not understand) draw: once/twice a year (mainly for poster presentation in conferences) regards, som -- To unsubscribe e-mail to: users+unsubscr...@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] Which components do you use most?
Calc: By far the component I use the most. I use this regularly. Mostly small stuff, household finance spreadsheets, usage stats, bank statements, that sort of thing. Writer: The second most used, although I seldom use this. Impress: I have used this on a couple of occasions. Base: I've only ever opened it for a quick look around. Being a programmer, I prefer to write my own. It may be past prejudice from the likes of Access, but I just can't feel comfortable using something like Base for anything; if the requirement is small, Base would be too much overhead, and if the requirement is large, then a custom application on top of a proper database would be a far better solution, more robust, more secure, more customised... Draw: I've only ever opened it for a quick look around. I use other, custom drawing software when I need to edit stuff, like the Gimp, or Inkscape. Again, probably more just my personal prejudices, but I just don't view an office suit as a graphics package. Paul On Sun, 11 May 2014 17:53:46 -0400 Virgil Arrington cuyfa...@hotmail.com wrote: I'm curious to find out what components of LO are used most by the people on this list. I think it helps to know different folks' area of experience. It might also help us in learning new ways to integrate the different components. For myself, my approximate usage is: Writer (85% of my use of LO) Calc(10%) Impress (3%, Maybe four to five presentations a year) Base (once a year to print out labels for my Christmas cards) Draw (What's that?) Virgil -- To unsubscribe e-mail to: users+unsubscr...@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] Which components do you use most?
On 05/11/2014 04:53 PM, Virgil Arrington wrote: I'm curious to find out what components of LO are used most by the people on this list. I think it helps to know different folks' area of experience. It might also help us in learning new ways to integrate the different components. For myself, my approximate usage is: Writer (85% of my use of LO) Calc(10%) Impress (3%, Maybe four to five presentations a year) Base (once a year to print out labels for my Christmas cards) Draw (What's that?) Virgil Good Morning Folks, My usage is: Calc: 90+% Write: 7+% Impress; 1% Base: 1% Draw: 2% I use LO on 3 systems and like it very much. I also advocate replacing M$ Office as often as I can! Cheers, Jay -- Jay Ridgley jridgl...@austin.rr.com Registered Linux User ID - 9115 https://linuxcounter.net/cert/9115.png Registered Ubuntu User ID - 23320 -- To unsubscribe e-mail to: users+unsubscr...@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: connection between Libre and Open Office
OpenOffice became LibreOffice. As for the header; I'm not sure I understand the question - neither OO nor LO should be noticeable on your form unless, for some reason, you've added that as your header for the document. From: George Roberts frenchma...@gmail.com To: users@global.libreoffice.org Date: Mon, 12 May 2014 09:47:05 +0100 Subject: [libreoffice-users] Dear Sir Is there any connection between Libre and Open Office? The reason I ask, I downloaded Open Office, did a spreadsheet, and on advice, was told Libre was better, so I downloaded Libre. Then I did a copy/paste of my spreadsheet from OO to Libre, but the heading still shows as Open Office. So, thinking it was because it was a copy/paste, I produced a sample spreadsheet called dates using Libre, and open office is still shown in the saved title name? Could it be because I have not uninstalled Open Office yet? *Regards* *George* -- To unsubscribe e-mail to: users+unsubscr...@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] print table without internal borders
If I understand the question, 'properties' will not eliminate these lines because they were added when the table was built; to eliminate them, you'll need to eliminate all the exterior tables, leaving only the innermost table. Open the document to show all then you should see where the table was set ... another was set ... etc. etc. etc. ... then the data was added; eliminate the extraneous one(s) - making sure to eliminate the opening and closing to each not desired. Hoping this helps, From: Thomas ny...@hb.tp1.jp Date: Mon, May 12, 2014 at 5:45 AM Subject: [libreoffice-users] print table without internal borders To: users@global.libreoffice.org users@global.libreoffice.org Good evening I am sure, this is a stupid question. I have a table (cover sheet for medical records) with all sorts of lines at the top and all around. However, I would prefer NOT to print the borders between some 30 questions below that. Only an outer border around the whole thing. I checked table properties, format etc., set the area to no lines etc. but so far no setting has changed how the table looks in the print preview. The documentation also gives only the explanations about table properties etc. Surely there is a very simple trick. I just cannot figure it out. If anybody has the time to give me a hint, I would be very grateful. Thank you. Thomas -- To unsubscribe e-mail to: users+unsubscr...@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]
Dear Sir Is there any connection between Libre and Open Office? The reason I ask, I downloaded Open Office, did a spreadsheet, and on advice, was told Libre was better, so I downloaded Libre. Then I did a copy/paste of my spreadsheet from OO to Libre, but the heading still shows as Open Office. So, thinking it was because it was a copy/paste, I produced a sample spreadsheet called dates using Libre, and open office is still shown in the saved title name? Could it be because I have not uninstalled Open Office yet? *Regards* *George* -- To unsubscribe e-mail to: users+unsubscr...@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]
George Roberts wrote: Is there any connection between Libre and Open Office? The reason I ask, I downloaded Open Office, did a spreadsheet, and on advice, was told Libre was better, so I downloaded Libre. Then I did a copy/paste of my spreadsheet from OO to Libre, but the heading still shows as Open Office. So, thinking it was because it was a copy/paste, I produced a sample spreadsheet called dates using Libre, and open office is still shown in the saved title name? Could it be because I have not uninstalled Open Office yet? LibreOffice is a fork from OpenOffice, created when Oracle hadn't decided what to to with OpenOffice StarOffice. So, there is a lot of similarity between them. However, what are you referring to by heading? If it's something you put in the document, it will always show, no matter what app you use. You can have both OpenOffice and LibreOffice on the same computer, but only one can be the default app for the various file formats. -- To unsubscribe e-mail to: users+unsubscr...@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: IT Geeks' Social Skills (was: Re: [libreoffice-users] Re: Installing windows explorer extension only)
Hello, Speaking as an Aspie myself, who helps fellow Aspies better work and live with others (and vice versa), thank you very much for your effort to understand. If I may: (1) You're right about its being Asperger Syndrome, named as it is after Dr. Hans Asperger who discovered it. It's also known as Asperger's Syndrome or Aspergers Syndrome. However, it does *not* contain the letter b, nor does it refer to any body part or popular fast food. =|8-} (2) Functional autism might be a phrase used by some laypeople to describe it. If you want to get more technical, it's an autism spectrum condition, along with High Functioning Autism, Semantic Pragmatic Disorder, Nonverbal Learning Disorder and Pervasive Developmental Disorder-Not Otherwise Specified (HFA, SPD, NLD/NVLD and PDD-NOS, respectively). Now that we've gotten the terminology out of the way... (3) You're right about Aspies not picking up on things that most others (neurotypicals, or NTs for short) absorb instinctively. Just as you rightly pointed out that social skills can be learned, so can the *need* to do so -- and not just in terms of avoiding getting fired, losing relationships and the like. Aspies have empathy just like any other non-sociopath/psychopath, and we can learn, say, how telling someone you don't like their food hurts their feelings even if we don't think it should. (4) Finally, thank you for calling for understanding and accommodation. Really, it goes both ways. We need to understand how NTs tick and how to better get along with them, and then act appropriately (in both senses of the term) as much as possible. Cheers, Jeff Deutsch Speaker Life Coach A SPLINT - ASPies LInking with NTs http://www.asplint.com Listen to the universe while it whispers before it has to shout. Marion Grobb Finkelstein, Communication Catalyst -- http://www.MarionSpeaks.com On Sun, May 11, 2014 at 11:57 AM, Jim Seymour jseym...@linxnet.com wrote: On Sun, 11 May 2014 11:52:18 +0100 Tom Davies tomc...@gmail.com wrote: [snip] On a side-issue ... The ones where Urmas does help are often highly technical. That raises the question of whether Urmas is a dev and just socially clumsy as so many are. Apparently Microsoft have recognised that many engineers and devs have high functioning aspergers syndrome or, even further along the spectrum, autism ... [snip] Asperger Syndrome (it's properly capitalized) is often referred-to as functional autism. In any event: Yes, in the IT world it is quite common for technically talented people to exhibit impaired social skills. It's usually not intentional. Such people are simply wired in such a manner that social skills that are second nature to normal people are, quite simply, incomprehensible to them. Good examples of these are the TV show characters Dr. Gregory House, Dr. Sheldon Cooper and Dr. Martin Ellingham (Doc Martin). These characters are all portrayed as being brilliant in their fields, but socially inept to the point of being widely regarded as rude and unfeeling. (These characters portray behavioural extremes, but they are, after all, actors, and it is, after all, entertainment.) Such people can learn, to a degree, to work within commonly accepted social norms, but they will never, ever understand the *need* to do so, other than that failing to do so may have (potentially) adverse consequences. This is not to excuse behaviour clearly out-of-bounds, but more to explain the reality that, in a venue such as this, you're going to encounter such people. The only way to stop it entirely is to encourage them to go away. Then what are you left with? Who will answer your questions and solve your problems? The likes of telephone sanitizers, hairstylists, advertising executives and lawyers? ;) Regards, Jim -- Note: My mail server employs *very* aggressive anti-spam filtering. If you reply to this email and your email is rejected, please accept my apologies and let me know via my web form at http://jimsun.LinxNet.com/contact/scform.php. -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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] Which components do you use most?
On 05/11/2014 02:53 PM, Virgil Arrington wrote: I'm curious to find out what components of LO are used most by the people on this list. I think it helps to know different folks' area of experience. It might also help us in learning new ways to integrate the different components. For myself, my approximate usage is: Writer (85% of my use of LO) Calc(10%) Impress (3%, Maybe four to five presentations a year) Base (once a year to print out labels for my Christmas cards) Draw (What's that?) Virgil I use Calc more than Writer but I rarely use Impress and have never used Draw or Base. So, it's between Calc and Writer for me. :) I use Calc daily (to update blood pressure monitoring spreadsheet, mostly) and Writer occasionally. Peace... Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+unsubscr...@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]
GeorgeWe are separate projects. LO is a fork off the 3.X branch of OO when it was controlled by Oracle. There are some differences between the two projects. Most of the differences are behind the scenes. I believe both projects are doing serious code cleanup as well as adding new features to their product.I hesitate to make the blanket statement that LO is always better than AOO, especially for a specific user.. The biggest, ongoing issue for both is the MSO document compatibility with the current MSO formats. Many users do not report any issues with compatibility but for more complex documents there can be issues.Depending on the OS, you can reset the defaults for each file type. I think this your problem, the OS has not changed the file associations to LO.JayOn 05/12/2014 04:47 AM, George Roberts wrote: Dear Sir Is there any connection between Libre and Open Office? The reason I ask, I downloaded Open Office, did a spreadsheet, and on advice, was told Libre was better, so I downloaded Libre. Then I did a copy/paste of my spreadsheet from OO to Libre, but the heading still shows as Open Office. So, thinking it was because it was a copy/paste, I produced a sample spreadsheet called dates using Libre, and open office is still shown in the saved title name? Could it be because I have not uninstalled Open Office yet? *Regards* *George*-- Jay lozierjsloz...@gmail.com -- To unsubscribe e-mail to: users+unsubscr...@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]
Hi :) Yes there is a strong connection between LibreOffice and OpenOffice. A few years ago they were both 1 and the same but underwent a process similar to cell division found in biological systems = where 1 cell buds off into 2 almost identical cells which each then grow in slightly different directions. If you really need to have both on your system at the same time it might be worth having a look through this wiki-guide https://wiki.documentfoundation.org/Installing_in_parallel Regards from Tom :) On 12 May 2014 15:07, James Knott james.kn...@rogers.com wrote: George Roberts wrote: Is there any connection between Libre and Open Office? The reason I ask, I downloaded Open Office, did a spreadsheet, and on advice, was told Libre was better, so I downloaded Libre. Then I did a copy/paste of my spreadsheet from OO to Libre, but the heading still shows as Open Office. So, thinking it was because it was a copy/paste, I produced a sample spreadsheet called dates using Libre, and open office is still shown in the saved title name? Could it be because I have not uninstalled Open Office yet? LibreOffice is a fork from OpenOffice, created when Oracle hadn't decided what to to with OpenOffice StarOffice. So, there is a lot of similarity between them. However, what are you referring to by heading? If it's something you put in the document, it will always show, no matter what app you use. You can have both OpenOffice and LibreOffice on the same computer, but only one can be the default app for the various file formats. -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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]
Hi :) Of course i would LibreOffice. I use it because i prefer it and because of those 2 things i'm here rather than the OpenOffice forums. A less-biased opinion would be that it might be a really good idea to uninstall OpenOffice and install LibreOffice and then try it out for a few weeks and decide for yourself which you prefer. The beauty of OpenSource is that 1. the programs are usually for free 2. they co-operate well and use the same formats So you can easily keep switching between different ones or you can settle down with one for a few years and then switch or just settle down with whichever one. Also it's entirely possible to have 1 on 1 machine and something else on another or to share documents with someone using something different from you without either of you needing to know what the other person is using. If you do go with LibreOffice i would recommend the 4.1.6 because that 3rd digit is higher and that indicates greater stability. On the other hand the 4.2.4 is already at 4 in the 3rd digit and that indicates it has just reached stability but is maybe not quite as rock solid as the 4.1.6. The advantage of going with the 4.3.0 is that although it might not be completely stable it will have more functionality and greater compatibility with MS formats. Many of us go for the more stable versions though and just wait for the newer branch to reach greater maturity and stability before taking it on. I put most of my colleagues on stable versions but try to play around with the newer branch as soon as possible to see if i can spot any bugs and report them to gain a bit of kudos. Sadly i've always found the newer branch to be more than stable enough for me and i've never yet found any problems worth reporting. Even so i play it safe. Regards On 12 May 2014 15:26, Jay Lozier jsloz...@gmail.com wrote: GeorgeWe are separate projects. LO is a fork off the 3.X branch of OO when it was controlled by Oracle. There are some differences between the two projects. Most of the differences are behind the scenes. I believe both projects are doing serious code cleanup as well as adding new features to their product.I hesitate to make the blanket statement that LO is always better than AOO, especially for a specific user.. The biggest, ongoing issue for both is the MSO document compatibility with the current MSO formats. Many users do not report any issues with compatibility but for more complex documents there can be issues.Depending on the OS, you can reset the defaults for each file type. I think this your problem, the OS has not changed the file associations to LO.JayOn 05/12/2014 04:47 AM, George Roberts wrote: Dear Sir Is there any connection between Libre and Open Office? The reason I ask, I downloaded Open Office, did a spreadsheet, and on advice, was told Libre was better, so I downloaded Libre. Then I did a copy/paste of my spreadsheet from OO to Libre, but the heading still shows as Open Office. So, thinking it was because it was a copy/paste, I produced a sample spreadsheet called dates using Libre, and open office is still shown in the saved title name? Could it be because I have not uninstalled Open Office yet? *Regards* *George*-- Jay lozierjsloz...@gmail.com -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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]
Hi *, Jay Lozier wrote (12-05-14 16:26) We are separate projects. LO is a fork off the 3.X branch of OO when it was controlled by Oracle. There are some differences between the two projects. Most of the differences are behind the scenes. A nice _summary_ of that can be found on this page http://de.libreoffice.org/features/why-libreoffice/?SubsiteID=3 But pls note that information about 4.2 and the upcoming 4.3 is not yet included. And that it is just a _summary_ of the _unique_ LibreOffice-features. I believe both projects are doing serious code cleanup I've marked some reports of the cleanup being done: https://people.gnome.org/~michael/blog/2012-08-08-libreoffice-3-6-0.html https://people.gnome.org/~michael/blog/2013-06-13-under-the-hood.html https://people.gnome.org/~michael/blog/2014-01-30-under-the-hood.html HTH, Cor -- Cor Nouws GPD key ID: 0xB13480A6 - 591A 30A7 36A0 CE3C 3D28 A038 E49D 7365 B134 80A6 - vrijwilliger http://nl.libreoffice.org - volunteer http://www.libreoffice.org - The Document Foundation Membership Committee Member -- To unsubscribe e-mail to: users+unsubscr...@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] Which components do you use most?
Hi :) I should use Draw more. It's the better tool for the job for the company newsletter but i just feel more comfortable in Writer. So, Writer = 80% Calc = 5% (and mostly only to check my answers to mailing list) Draw = 10% (mostly use Inkscape and Gimp tbh but Draw trumps them for floor plans etc) Base = 2% (again, use might not be an accurate term) Math = 2% Impress= 1% Regards from Tom :) On 12 May 2014 15:24, Tom Williams tomd...@comcast.net wrote: On 05/11/2014 02:53 PM, Virgil Arrington wrote: I'm curious to find out what components of LO are used most by the people on this list. I think it helps to know different folks' area of experience. It might also help us in learning new ways to integrate the different components. For myself, my approximate usage is: Writer (85% of my use of LO) Calc(10%) Impress (3%, Maybe four to five presentations a year) Base (once a year to print out labels for my Christmas cards) Draw (What's that?) Virgil I use Calc more than Writer but I rarely use Impress and have never used Draw or Base. So, it's between Calc and Writer for me. :) I use Calc daily (to update blood pressure monitoring spreadsheet, mostly) and Writer occasionally. Peace... Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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] Which components do you use most?
Le 11/05/2014 23:53, Virgil Arrington a écrit : I'm curious to find out what components of LO are used most by the people on this list. I think it helps to know different folks' area of experience. It might also help us in learning new ways to integrate the different components. Writer: 75% Calc:40% Draw:15% Impress: 10% Base:10% Math: 0% That's more than 100%? Probably because I'm working more than that as well ;-) -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@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] Which components do you use most?
Personal use: 50% Writer 50% Calc (Impress perhaps twice a year). But as a translator I am walking through the other components one after another. I like to know what I am translating. At the moment I am working partly on Impress partly on Base. Kolbjoern Den 12.05.2014 15:12, skreiv Jay Ridgley: On 05/11/2014 04:53 PM, Virgil Arrington wrote: I'm curious to find out what components of LO are used most by the people on this list. I think it helps to know different folks' area of experience. It might also help us in learning new ways to integrate the different components. For myself, my approximate usage is: Writer (85% of my use of LO) Calc(10%) Impress (3%, Maybe four to five presentations a year) Base (once a year to print out labels for my Christmas cards) Draw (What's that?) Virgil -- To unsubscribe e-mail to: users+unsubscr...@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] Which components do you use most?
calc 80% writer10% presentation 8% the rest 2% -- To unsubscribe e-mail to: users+unsubscr...@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: Which components do you use most?
Virgil Arrington wrote I'm curious to find out what components of LO are used most by the people on this list. I think it helps to know different folks' area of experience. It might also help us in learning new ways to integrate the different components. For myself, my approximate usage is: Writer 90% Calc 10% fairly often but in small bits. Coming from Generalized Markup Language (GML) background from the late 70s, I use Styles and Templates exclusively, especially when preparing books. I would be interested to know what proportion of time people use Styles when preparing text. The users I help are all home users and struggle with the concept of styles and even templates. Peter -- View this message in context: http://nabble.documentfoundation.org/Which-components-do-you-use-most-tp4108359p4108493.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@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: Which components do you use most?
I almost always use Styles and Templates. I know it has a somewhat shallow learning curve, but it is worth the effort to learn because it makes you much more efficient in the long run. Not doing that reminds me of the classic There is never time to do it right, but always time to do it over. Regards, On Mon, May 12, 2014 at 12:42 PM, Peter Maunder peter_maun...@orange.fr wrote: Virgil Arrington wrote I'm curious to find out what components of LO are used most by the people on this list. I think it helps to know different folks' area of experience. It might also help us in learning new ways to integrate the different components. For myself, my approximate usage is: Writer 90% Calc 10% fairly often but in small bits. Coming from Generalized Markup Language (GML) background from the late 70s, I use Styles and Templates exclusively, especially when preparing books. I would be interested to know what proportion of time people use Styles when preparing text. The users I help are all home users and struggle with the concept of styles and even templates. Peter -- View this message in context: http://nabble.documentfoundation.org/Which-components-do-you-use-most-tp4108359p4108493.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@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 -- Kevin B. O'Brien zwiln...@gmail.com http://google.me/+kevinobrien Facebook is Evil. Cancel your account. -- To unsubscribe e-mail to: users+unsubscr...@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] Which components do you use most?
I seem to have missed the OP's posting. Jumping in at the middle with my following order of usage: WriterFor text documentation CalcFor budgets and tabular lists Base For inventories and fixed asset accounting Draw For figures in documents, PDF form filling Impress Looking at powerpoint files sent to me Girvin Herr On 05/11/2014 03:45 PM, anne-ology wrote: an interesting survey - as for me: Writer - prefer this to any other text program; use to write, ... Calc - don't use since still do manually ;-) Impress - use to use for presentations, then would convert to video; now skip that 1st step Base - don't use since still do manually - (well, old-fashioned with good, artistic hand-writing) Draw - have not gotten the hang of drawing with these machines; they just don't look as appealing as done by hand ;-) From: Virgil Arrington cuyfa...@hotmail.com Date: Sun, May 11, 2014 at 4:53 PM Subject: [libreoffice-users] Which components do you use most? To: users@global.libreoffice.org users@global.libreoffice.org I'm curious to find out what components of LO are used most by the people on this list. I think it helps to know different folks' area of experience. It might also help us in learning new ways to integrate the different components. For myself, my approximate usage is: Writer (85% of my use of LO) Calc(10%) Impress (3%, Maybe four to five presentations a year) Base (once a year to print out labels for my Christmas cards) Draw (What's that?) Virgil -- To unsubscribe e-mail to: users+unsubscr...@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] Native Connector
Heinrich, Although I do not have the problem you are experiencing, I am keeping an eye on this thread is case I do have a similar problem in the future. I hope you can get an answer soon to solve your immediate problem. Aside from your cup of coffee example, from my experience, the Base Report Generator can take much more than 60 seconds to render a large report. I am not sure how Base collects the data for a report, but if it does so a record at a time, then your server would time out way before the report is finished! I would think that the best case would be that the constant reconnects would slow the Report Generator even more. Since it sounds like your system worked before LO 4.2.x and I suspect you where using the Oracle MySQL-connector-java, as I am, there may be a way to replace the new native connector with the tried-and-true Oracle connector. That would get you up and running again until more information on the native connector is released. I have no experience with this, but it may be an option for you, if it can be done. Good luck. Girvin On 05/11/2014 11:52 PM, Heinrich Stoellinger wrote: Thanks a lot, Girvin... My situation is exactly as you describe it. I used to run my own server, installing everything from Linux to Apache2, PHP, mail, MySQL, etc. Therefore I had the possibility to set my OWN parameters for MySQL. For cost and other reasons I changed to a stripped-down web-hosting structure and therefore have stopped being my own admin I also think that 60 seconds is an inappropriate value for the wait_timeout because it doesn't even allow you to go have a quick coffee (or other, more pressing things...). Yes, in MY situation it would be great if the native connector supported a kind of automatic reconnect after the SERVER (nothing to do with LO-Base!) shuts down an idle connection (in my case in 60 seconds, even though 28800 would be allowed!!! Regards from Austria H. S. On Mon, 12 May 2014 00:35:48 +0200, anne-ology lagin...@gmail.com wrote: Well, that autoReconnect=true must have something to do with JAVA ... I 'searched' and uncovered nearly 100,000 articles [whew ;-) ] https://www.google.com/search?q=autoReconnect%3Dtrueie=utf-8oe=utf-8aq=trls=org.mozilla:en-US:officialclient=firefox-achannel=sb BTW - when opening up the first few, I noticed others are asking the same question re. this timing out ???!!!???!!!??? Oops - Something tells me I should quit calling this machine a glorified-typewriter; maybe it will want revenge and blow up ... ... ... my mouse already died this year; had to replace the li'l fella' ;-) From: Girvin Herr girvin.h...@sbcglobal.net Date: Sun, May 11, 2014 at 2:53 PM Subject: Re: [libreoffice-users] Native Connector To: users@global.libreoffice.org Yes, if I understand Mr. Stoellinger's problem correctly, it is the MySQL server (aka back-end) which is dropping his connection. According to my MySQL documentation, by default, the MySQL server drops any connection after 8 hours of continuous connection. However, Mr. Stoellinger's admin has reduced that time to 60 seconds! IMHO, that is ridiculous, but it must be the policy at his institution, so he must live with it. The MySQL connector driver that he has been using has a workaround by triggering a reconnect operation every so often, effectively restarting the 60-second timer. That is the purpose of the autoReconnect=true connector driver parameter he talks about. Now, it appears that the new LO Base has a MySQL native driver that replaces the Oracle MySQL-connector-java driver that he most likely has been using and he needs to know if the new LO native driver supports the reconnect schema and if so, how to implement it. As far as I know, no one on this list so far has given him the answer to that question. I have no experience with the new native driver (yet), so I do not have the answer. If the native driver does not support it, or he does not get an answer, I would suggest keeping the Oracle JDBC driver until he gets his answer, if the new LO still allows replacement of the native built-in driver. BTW: I am my own admin, so my MySQL server is still set to the default timeout, if any. Therefore, I do not experience this disconnect problem. However, every so often, I see a posting about it on this forum, so he is not alone. HTH. Girvin Herr On 05/10/2014 03:37 PM, Tom Davies wrote: Hi :) It's the 2nd one Anne-ology. The connector is some sort of bridge between Base and MySql. It's the bridge that is timing out rather than the computer afaik. Regards from Tom :) On 10 May 2014 22:13, anne-ology lagin...@gmail.com wrote: If you're referring to the computer-machine shutting down and/or entering sleep-mode, then there's a simple solution; if you're referring to something else - well, I haven't a clue. If the 1st - go to properties/options/ and
[libreoffice-users] Re: Which components do you use most?
Girvin, Girvin Herr wrote I seem to have missed the OP's posting... No, y0u had to OP as tacked on to Anne's--by Virgil A. And just a reminder that anyone can (and maybe should) review partial threads (in thread context, or as a sequential list) from the Nabble interface to the LibreOffice Users forum http://nabble.documentfoundation.org/Users-f1639498.html . -- View this message in context: http://nabble.documentfoundation.org/Which-components-do-you-use-most-tp4108359p4108498.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@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: connection between Libre and Open Office
George, If new files are experiencing this problem, then it sounds like your default template is not clean. First, check the Tools - Options - Paths paths to be sure nothing is pointing to the OpenOffice directories. Especially the Templates path. If the Templates path is set to the OpenOffice templates path, then the OpenOffice default template could be used for new documents. If the paths are okay, then open a new document and/or spreadsheet and then look at File - Properties and verify they are blank. If not, and the Title property in the Description tab is set to OpenOffice, then you will have to make the change(s) to the template properties and save it as the new default. That should correct the problem with new documents. For old documents or spreadsheets, check the problem ones by opening them and check the properties as with the new file procedure above. If your spreadsheet or document has the Title property set to specify OpenOffice, and the Title field is inserted into the document or spreadsheet, then it will always be OpenOffice until that property is changed. The file properties are set in the document and will follow the document, not the application. As a last resort, you might try deleting or renaming the LO user profile. HTH. Girvin Herr On 05/12/2014 06:20 AM, anne-ology wrote: OpenOffice became LibreOffice. As for the header; I'm not sure I understand the question - neither OO nor LO should be noticeable on your form unless, for some reason, you've added that as your header for the document. From: George Roberts frenchma...@gmail.com To: users@global.libreoffice.org Date: Mon, 12 May 2014 09:47:05 +0100 Subject: [libreoffice-users] Dear Sir Is there any connection between Libre and Open Office? The reason I ask, I downloaded Open Office, did a spreadsheet, and on advice, was told Libre was better, so I downloaded Libre. Then I did a copy/paste of my spreadsheet from OO to Libre, but the heading still shows as Open Office. So, thinking it was because it was a copy/paste, I produced a sample spreadsheet called dates using Libre, and open office is still shown in the saved title name? Could it be because I have not uninstalled Open Office yet? *Regards* *George* -- To unsubscribe e-mail to: users+unsubscr...@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: Which components do you use most?
Virgil Arrington wrote I'm curious to find out what components of LO are used most by the people on this list. I think it helps to know different folks' area of experience. It might also help us in learning new ways to integrate the different components. For myself, my approximate usage is: Writer 80% (using Styles and Templates whenever possible) Calc 10% Base7% Draw3% john -- To unsubscribe e-mail to: users+unsubscr...@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] print table without internal borders
(2014/05/12 20:19), Brian Barker wrote: At 19:45 12/05/2014 +0900, you wrote: I'm not sure what you can mean by etc.: what else did you do, then? ... but so far no setting has changed how the table looks in the print preview. If you turn off the lines for a table, you should see the result in Print Preview. I just cannot figure it out. A few suggestions: o If you select a cell range before you turn off table boundaries, your action will affect only those cells: other cells will retain their borders. Is that what you did? o Do you have a single table or are there actually a number of adjacent tables? (If you inherited this document, you may not know how it was constructed.) If so, you'll need to adjust the borders on all of them. o Do you have a table within another table? o Do you really have not a table but a set of frames? Or frames within a table? o Do you actually have a picture of a table, perhaps imported from another application? I trust this helps. Brian Barker - privately Maybe I need to specify: I myself created ONE table in a Writer document. No images, no frames etc. Started with 6 columns and about 30 rows. Joined a few cells in the upper portion (to make more room for entries like address etc). Below there are the 6 colums and 14 rows. For THIS block - part of the ONE table - I would like to make the lines inside the table disappear (or at least NOT print) and retain only the border that surrounds the whole table. Yet, (so far) regardless of what cell/block of cells I select and what option pertaining to borders, lines etc. I choose ... NONE has ANY effect on the appearance of that table. Is that not a little strange? -- To unsubscribe e-mail to: users+unsubscr...@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: Which components do you use most?
Virgil Arrington wrote I'm curious to find out what components of LO are used most by the people on this list. I think it helps to know different folks' area of experience. It might also help us in learning new ways to integrate the different components. For myself, my approximate usage is: Writer 10%(using Styles and Templates whenever possible) Calc 90% Base0% Draw0% joe -- To unsubscribe e-mail to: users+unsubscr...@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] print table without internal borders
Thomas wrote: (2014/05/12 20:19), Brian Barker wrote: At 19:45 12/05/2014 +0900, you wrote: I'm not sure what you can mean by etc.: what else did you do, then? ... but so far no setting has changed how the table looks in the print preview. If you turn off the lines for a table, you should see the result in Print Preview. I just cannot figure it out. A few suggestions: o If you select a cell range before you turn off table boundaries, your action will affect only those cells: other cells will retain their borders. Is that what you did? o Do you have a single table or are there actually a number of adjacent tables? (If you inherited this document, you may not know how it was constructed.) If so, you'll need to adjust the borders on all of them. o Do you have a table within another table? o Do you really have not a table but a set of frames? Or frames within a table? o Do you actually have a picture of a table, perhaps imported from another application? I trust this helps. Brian Barker - privately Maybe I need to specify: I myself created ONE table in a Writer document. No images, no frames etc. Started with 6 columns and about 30 rows. Joined a few cells in the upper portion (to make more room for entries like address etc). Below there are the 6 colums and 14 rows. For THIS block - part of the ONE table - I would like to make the lines inside the table disappear (or at least NOT print) and retain only the border that surrounds the whole table. Yet, (so far) regardless of what cell/block of cells I select and what option pertaining to borders, lines etc. I choose ... NONE has ANY effect on the appearance of that table. Is that not a little strange? Hi Thomas, What makes it /strange/, or I should say difficult, is that we cannot see your document or know what options you are using. I am attaching a sample document (which may be removed by the list server) in the form of a mini-tutorial. Please follow the steps in that document using a new document of your own and write back to the list (not directly to me) and let us know if this works for you or not. This will give us some idea if the problem is in your existing document, or in the options you have been using. Regards Dave - (Writing Publicly Brian) -- To unsubscribe e-mail to: users+unsubscr...@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