[libreoffice-users] Re: Forgotten where to look for template converting text dates to numeric and sortable form
Am 31.10.2014 um 04:01 schrieb Custfold: What do I put in the find replace boxes? Hi, First of all, it is easier to avoid this problem rather than fixing it. You turn on regular expressions and replace .+ with -- 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: Recommended version of Java?
Hi, To make it easy... We support every java Version Oracle supports in the same flavor as LibreOffice :) [Non Tech Answer] If you have a 32 bit LibO you need a 32 bit java, same with 64 bits. Oracle Supports (for free) Java 7 and 8 (I guess), so currently Java 1.7+ (Java 7 == 1.7). If there is a Bug in java, LibreOffice will suffer from it, but well, we cannot do anything against it Hope that helped :) -- Liebe Grüße, / Yours, Florian Reisinger -- 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] Macro to abandon edits
I'm migrating a bunch of spreadsheets from Debian Lenny/Openoffice to Debian Wheezy/Libreoffice 3.5.x. This is a dedicated setup used by many once-a-year users (who aren't chosen for their familiarity with computers) and, for instance, boots straight into a front end when switched on and shuts down when you close the front end. All driven by a startup script which launches the front end and waits for it to close. The front end is fundamentally some buttons to launch working sheets and unchanging except that today's date is filled in when it starts, or the user can enter a different date. Mass of macros to handle it all. Closing the front end is by doc.close()ing in a Goodbye macro but this leaves an soffice.bin process running and you get a 'Program is still running' dialogue box when the machine shuts down; it goes away after a bit but it will alarm the user. I can get rid of that by putting 'stardesktop.terminate' (is 'xdesktop.terminate' preferrred?) in the shutdown macro but then when it next starts it wants to Recover the front end; that's a big no-no. Under Lenny/Openoffice there isn't this problem, when you've doc.close()d it shuts down happily and when it's next switched on loads the front end without complaint. I've tried doc.setmodified(FALSE) but no joy. I suppose I could get the shutdown macro to save it and the startup script to then delete that and copy the master back but that's pretty horrible. Is there a sensible way to fix this? -- Dick Georgeson -- 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] Base Relationships: Update cascade not working
Hi, I am trying to change some Primary Keys in my main table, and get the changes to be reflected in several Foreign Keys. I have gone into Tools | Relationships, have set up the 1 to n connections between the tables and chosen Update cascade. However when I open the main table and attempt to change a Primary Key, I get the message Referential integrity constrain violation. I thought that Update cascade would override this. Have I missed something, or is it a possible bug? Thanks, Noel -- Noel Lodge lodg...@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] Printing Reports from BASE extends to Writer?
I expect something like this to print the document ThisComponent.printPages(Array()) Of course, you need to load it first so you would likely have something like oDoc = StarDesktop.loadComponentFromURL( URL_OF_THE_DOCUMENT, _ _blank, 0, Array() ) And then print the oDoc I did not try this, but it should work. Also, don't just close the document On 10/30/2014 10:18 AM, Paul D. Mirowsky wrote: Yes, that seems correct. On 10/29/2014 4:55 PM, Andrew Douglas Pitonyak wrote: Are you asking if it is possible to use a macro to open a document and then print it? On 10/28/2014 11:56 PM, Paul D. Mirowsky wrote: Can this be extended to Writer document, eliminating the requirement of opening Writer and selecting 'Print'? On 10/28/2014 4:05 AM, Walther Koehler wrote: Hi Peter just another proposal: sub printreport() Dim oDoc as Object Dim arg(0) as new com.sun.star.beans.PropertyValue oDoc=ThisComponent arg(0).name = Name arg(0).value = myprinter oDoc.printPages(arg()) end sub Yours Walther Am Dienstag, 28. Oktober 2014 schrieb Peter Goggin: On 28/10/14 15:01, Marion Noel Lodge wrote: Hi Peter, A macro similar to this should do what you want - Sub PrintReport() ThisDatabaseDocument.ReportDocuments.getbyname(name of your report).open() End Sub Then edit your Menu form, double click on the Print button and under Events | 'Mouse button pressed', link the button to the PrintReport() sub. Then when you run your application, clicking on the button should fire your report. Noel -- Noel Lodge lodg...@gmail.com On 28 October 2014 13:24, Peter Goggin petergog...@bigpond.com wrote: I have a report run from a push button on a menu form. I can print it from the screen, but in Access I was able to program a push button to print id directly. Is this possible in BASE? I cannot find any reference to this. Regards Peter Goggin -- 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 Thanks for the suggestion. However all the subroutine does is display the report on the screen. I want to be able to send it to the printer without first displaying it on the screen. So far I cannot see any reference on how to doi this. Regards Peter Goggin -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.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
Re: [libreoffice-users] Printing Reports from BASE extends to Writer?
Thanks I'll see what I can do. On 10/31/2014 9:28 AM, Andrew Douglas Pitonyak wrote: I expect something like this to print the document ThisComponent.printPages(Array()) Of course, you need to load it first so you would likely have something like oDoc = StarDesktop.loadComponentFromURL( URL_OF_THE_DOCUMENT, _ _blank, 0, Array() ) And then print the oDoc I did not try this, but it should work. Also, don't just close the document On 10/30/2014 10:18 AM, Paul D. Mirowsky wrote: Yes, that seems correct. On 10/29/2014 4:55 PM, Andrew Douglas Pitonyak wrote: Are you asking if it is possible to use a macro to open a document and then print it? On 10/28/2014 11:56 PM, Paul D. Mirowsky wrote: Can this be extended to Writer document, eliminating the requirement of opening Writer and selecting 'Print'? On 10/28/2014 4:05 AM, Walther Koehler wrote: Hi Peter just another proposal: sub printreport() Dim oDoc as Object Dim arg(0) as new com.sun.star.beans.PropertyValue oDoc=ThisComponent arg(0).name = Name arg(0).value = myprinter oDoc.printPages(arg()) end sub Yours Walther Am Dienstag, 28. Oktober 2014 schrieb Peter Goggin: On 28/10/14 15:01, Marion Noel Lodge wrote: Hi Peter, A macro similar to this should do what you want - Sub PrintReport() ThisDatabaseDocument.ReportDocuments.getbyname(name of your report).open() End Sub Then edit your Menu form, double click on the Print button and under Events | 'Mouse button pressed', link the button to the PrintReport() sub. Then when you run your application, clicking on the button should fire your report. Noel -- Noel Lodge lodg...@gmail.com On 28 October 2014 13:24, Peter Goggin petergog...@bigpond.com wrote: I have a report run from a push button on a menu form. I can print it from the screen, but in Access I was able to program a push button to print id directly. Is this possible in BASE? I cannot find any reference to this. Regards Peter Goggin -- 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 Thanks for the suggestion. However all the subroutine does is display the report on the screen. I want to be able to send it to the printer without first displaying it on the screen. So far I cannot see any reference on how to doi this. Regards Peter Goggin -- 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] Tab defaults change when pasting into Writer from some other applications
Sorry for the delay in responding. Too many other things going on. -- Tim === On 10/26/2014 4:56 PM, Brian Barker wrote: At 16:25 26/10/2014 -0400, Dan Lewis wrote: On 10/26/2014 02:13 PM, Brian Barker wrote: At 13:51 26/10/2014 -0400, Tim Deaton wrote: I'm currently running LO v4.2.6.3 on Windows 7, 64-bit, SP1. I use Writer primarily to create notes for Bible study lessons. In that process, I often copy text into Writer from other programs (most likely e-Sword and TheWord (two free Bible software programs which, I think, both use the SQLite open-source database program). The template I use for this has the default tab-stop setting (Tools|Options|LO Writer|General) set to 0.25 inch. My problem is that when copying text passages from those (and perhaps other) programs into LO, that default tab-stop gets reset to 0.5 inch, so that I have to go into the Options to change it back after each copy/paste. I don't know when exactly this behavior started, but I do know this resetting did not happen when I was using OOo and then LO 3.x. It either started with LO 4.0 or 4.1. I'm not sure why you would want to use default tab stops at all. They are so close that you often need to add multiple consecutive tab characters, and this is surely a recipe for your documents being fragile and not robust to changes of font, paper size, printer, platform, and so on? Tab stops are a property of paragraph styles. Why not set up a paragraph style with just the tab stops you actually need and then apply this style to the text (very easily done) immediately after pasting What about using paste special the Unformatted text option after creating the paragraph style you want? I'm not sure how that helps. In any case, the questioner originally said he wanted to retain elements of formatting in the copied text. Brian Barker Thanks for your comments, and your patience. The reason for the .25 tab stops (about 6mm) is that in these documents I do a lot of outline-type indenting, but without the outline numbering. Also, the pasted-in scripture sections use .25 hanging indents in one of the source programs, and I like to keep that. It's NOT for tabbed spaces in the middle of a line. When I started using OOo for this, I set up a template just for these documents, and brought that over to LO when I switched. The .25 default tab stops are part of that template. Given its age, I doubt I used styles then, but I really don't remember. I just know that the default setting used to not be bothered by the stuff I paste in from eSword and TheWord, but now it is. Here's a link to a recent document: https://dl.dropboxusercontent.com/u/50459876/ss20141026.Heb8.odt (I wanted to include this on my original post, but computer problems - part of the too many other things above - prevented that.) - Tim D. -- 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] Macro to abandon edits
You might have to run a logout script from some type of .rc file. This is not the actual command and is not the best way to do it. It should be possible. The script will have a kill -9 soffice.bin and will need code to find it with 'ps'. See https://unix.stackexchange.com/questions/2745/how-to-run-a-script-during-gnome-log-out as an example from Gnome. Hope this helps. On 10/31/2014 7:20 AM, rmg wrote: I'm migrating a bunch of spreadsheets from Debian Lenny/Openoffice to Debian Wheezy/Libreoffice 3.5.x. This is a dedicated setup used by many once-a-year users (who aren't chosen for their familiarity with computers) and, for instance, boots straight into a front end when switched on and shuts down when you close the front end. All driven by a startup script which launches the front end and waits for it to close. The front end is fundamentally some buttons to launch working sheets and unchanging except that today's date is filled in when it starts, or the user can enter a different date. Mass of macros to handle it all. Closing the front end is by doc.close()ing in a Goodbye macro but this leaves an soffice.bin process running and you get a 'Program is still running' dialogue box when the machine shuts down; it goes away after a bit but it will alarm the user. I can get rid of that by putting 'stardesktop.terminate' (is 'xdesktop.terminate' preferrred?) in the shutdown macro but then when it next starts it wants to Recover the front end; that's a big no-no. Under Lenny/Openoffice there isn't this problem, when you've doc.close()d it shuts down happily and when it's next switched on loads the front end without complaint. I've tried doc.setmodified(FALSE) but no joy. I suppose I could get the shutdown macro to save it and the startup script to then delete that and copy the master back but that's pretty horrible. Is there a sensible way to fix this? -- 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] Tab defaults change when pasting into Writer from some other applications
Tim, I'm way too late in this thread to be helpful as I have been absent for several months (for some reason the list stopped recognizing my email address, so I recently resubscribed with a different address). That said, I can relate to what I perceive to be your issues. I do a lot of Bible study work with LO and eSword and Bibletime as well as Bible.org. I always run into problems when I copy and paste quotes from one of these sources to LO. As I look at your document (an interesting study indeed, btw -- love the reference to Origen), I see a lot of formatting inconsistency going on. Font changes, smartquotes here, dumbquotes there, etc. This is the result of pasting formatted text from one source into LO. Now you may not care about this as I'm sure these are probably private notes, not necessarily for dissemination, but... In my experience with extra-LO sources such as eSword, etc., I've come to always paste using Paste-Special/Unformatted text. That way, I can then quickly apply an appropriate paragraph style to the text and all is well. Virgil btw., Ironically, as I'm typing this, I'm sitting in my Law Office Technology class while my students are taking a test on the use of paragraph styles. After teaching this class for five semesters, I've finally found an approach that works. I think Tom suggested it. I give them an unformatted document and ask them to format it using any method they understand. They usually take 30 to 45 minutes and end up with a mess. I then demonstrate reformatting the document with styles and I'm done in about 3 minutes and the document formatting is consistent and useful. I then ask, If your client was paying $200 an hour to have a legal document prepared and formatted, who would they rather pay, me or you? On 10/31/2014 9:57 AM, Tim Deaton wrote: Sorry for the delay in responding. Too many other things going on. -- Tim === On 10/26/2014 4:56 PM, Brian Barker wrote: At 16:25 26/10/2014 -0400, Dan Lewis wrote: On 10/26/2014 02:13 PM, Brian Barker wrote: At 13:51 26/10/2014 -0400, Tim Deaton wrote: I'm currently running LO v4.2.6.3 on Windows 7, 64-bit, SP1. I use Writer primarily to create notes for Bible study lessons. In that process, I often copy text into Writer from other programs (most likely e-Sword and TheWord (two free Bible software programs which, I think, both use the SQLite open-source database program). The template I use for this has the default tab-stop setting (Tools|Options|LO Writer|General) set to 0.25 inch. My problem is that when copying text passages from those (and perhaps other) programs into LO, that default tab-stop gets reset to 0.5 inch, so that I have to go into the Options to change it back after each copy/paste. I don't know when exactly this behavior started, but I do know this resetting did not happen when I was using OOo and then LO 3.x. It either started with LO 4.0 or 4.1. I'm not sure why you would want to use default tab stops at all. They are so close that you often need to add multiple consecutive tab characters, and this is surely a recipe for your documents being fragile and not robust to changes of font, paper size, printer, platform, and so on? Tab stops are a property of paragraph styles. Why not set up a paragraph style with just the tab stops you actually need and then apply this style to the text (very easily done) immediately after pasting What about using paste special the Unformatted text option after creating the paragraph style you want? I'm not sure how that helps. In any case, the questioner originally said he wanted to retain elements of formatting in the copied text. Brian Barker Thanks for your comments, and your patience. The reason for the .25 tab stops (about 6mm) is that in these documents I do a lot of outline-type indenting, but without the outline numbering. Also, the pasted-in scripture sections use .25 hanging indents in one of the source programs, and I like to keep that. It's NOT for tabbed spaces in the middle of a line. When I started using OOo for this, I set up a template just for these documents, and brought that over to LO when I switched. The .25 default tab stops are part of that template. Given its age, I doubt I used styles then, but I really don't remember. I just know that the default setting used to not be bothered by the stuff I paste in from eSword and TheWord, but now it is. Here's a link to a recent document: https://dl.dropboxusercontent.com/u/50459876/ss20141026.Heb8.odt (I wanted to include this on my original post, but computer problems - part of the too many other things above - prevented that.) - Tim D. -- 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:
[libreoffice-users] Re: Tab defaults change when pasting into Writer from some other applications
Virgil Arrington-2 wrote ... btw., Ironically, as I'm typing this, I'm sitting in my Law Office Technology class while my students are taking a test on the use of paragraph styles. After teaching this class for five semesters, I've finally found an approach that works. I think Tom suggested it. I give them an unformatted document and ask them to format it using any method they understand. They usually take 30 to 45 minutes and end up with a mess. I then demonstrate reformatting the document with styles and I'm done in about 3 minutes and the document formatting is consistent and useful. I then ask, If your client was paying $200 an hour to have a legal document prepared and formatted, who would they rather pay, me or you? A bit OT, but that is a great instructional example on the value of applying styles to unformatted text. Thanks! -- View this message in context: http://nabble.documentfoundation.org/Tab-defaults-change-when-pasting-into-Writer-from-some-other-applications-tp4126945p4127484.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] Macro to abandon edits
Hi :) In Debain family maybe pkill might be better to kill a named process rather than by it's id? Wouldn't a kill (or pkill) command also mean the next time you open LibreOffice it'll try to recover a file? I'm not sure about any of this so i'm just wondering. I tend to stay as far away from the command-line as possible but occasionally find myself doing odd things there. Regards from Tom :) On 31 October 2014 14:05, Paul D. Mirowsky p_mirow...@bentaxna.com wrote: You might have to run a logout script from some type of .rc file. This is not the actual command and is not the best way to do it. It should be possible. The script will have a kill -9 soffice.bin and will need code to find it with 'ps'. See https://unix.stackexchange.com/questions/2745/how-to-run- a-script-during-gnome-log-out as an example from Gnome. Hope this helps. On 10/31/2014 7:20 AM, rmg wrote: I'm migrating a bunch of spreadsheets from Debian Lenny/Openoffice to Debian Wheezy/Libreoffice 3.5.x. This is a dedicated setup used by many once-a-year users (who aren't chosen for their familiarity with computers) and, for instance, boots straight into a front end when switched on and shuts down when you close the front end. All driven by a startup script which launches the front end and waits for it to close. The front end is fundamentally some buttons to launch working sheets and unchanging except that today's date is filled in when it starts, or the user can enter a different date. Mass of macros to handle it all. Closing the front end is by doc.close()ing in a Goodbye macro but this leaves an soffice.bin process running and you get a 'Program is still running' dialogue box when the machine shuts down; it goes away after a bit but it will alarm the user. I can get rid of that by putting 'stardesktop.terminate' (is 'xdesktop.terminate' preferrred?) in the shutdown macro but then when it next starts it wants to Recover the front end; that's a big no-no. Under Lenny/Openoffice there isn't this problem, when you've doc.close()d it shuts down happily and when it's next switched on loads the front end without complaint. I've tried doc.setmodified(FALSE) but no joy. I suppose I could get the shutdown macro to save it and the startup script to then delete that and copy the master back but that's pretty horrible. Is there a sensible way to fix this? -- 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
[libreoffice-users] Re: Base Relationships: Update cascade not working
Am 31.10.2014 um 14:11 schrieb Marion Noel Lodge: Hi, I am trying to change some Primary Keys in my main table, and get the changes to be reflected in several Foreign Keys. I have gone into Tools | Relationships, have set up the 1 to n connections between the tables and chosen Update cascade. However when I open the main table and attempt to change a Primary Key, I get the message Referential integrity constrain violation. I thought that Update cascade would override this. Have I missed something, or is it a possible bug? Thanks, Noel -- Noel Lodge lodg...@gmail.com Hi, If it were a bug, then it would be a bug in the underlying database program which is HSQL and not Base. Base is not a database at all. Referencial integrity never lets you enter any foreign key value on the n-side if there is no corresponding value in the other table's primary key (the 1-side). Update cascade allows you to update a primary key value on the 1-side. This update will automatically change all the values in related foreign keys. Normally you don't want cascading updates, particularly when using auto-IDs which may be inserted and deleted but never updated. If you want to enter arbitrary values into some field then you must not make it a foreign key of some other table's primary key. You can make it optional (nullable) but an orphaned foreign key value is not possible. If you happen to work with an embedded HSQLDB (this is indicated in the status bar), http://www.hsqldb.org/doc/1.8/guide/ch09.html is the complete official documentation for the database program you are working with. Hope this helps, A.S. -- 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: Macro to abandon edits
Am 31.10.2014 um 12:20 schrieb rmg: I'm migrating a bunch of spreadsheets from Debian Lenny/Openoffice to Debian Wheezy/Libreoffice 3.5.x. This is a dedicated setup used by many once-a-year users (who aren't chosen for their familiarity with computers) and, for instance, boots straight into a front end when switched on and shuts down when you close the front end. All driven by a startup script which launches the front end and waits for it to close. This sounds like a horrible mess. As far as I know, you can control the entire office process through a real program (Java, Python, Java Script) which starts up the office suite in listening mode, connects to the listening office, plays games with the same UNO-Api as macros do and finally takes care of the proper shutdown. I would train my users instead. -- 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: Recommended version of Java?
On 10/30/2014 5:02 PM, Virgil Arrington arringto...@gmail.com wrote: In my experience on this list, Tom has been extremely helpful and, just as important, courteous. I agree for the most part, and he is always polite and cordial. I just really hate it when someone deigns to try to 'help' me as if I'm a child, rather than just answer a simple question. The fact is, Libreoffice, for a long time, simply did not work at all with Java7. So, I figured I'd ask if Java8 was supported - meaning, expected to work properly in most cases... Sheesh... -- 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: Recommended version of Java?
Am 31.10.2014 um 19:10 schrieb Tanstaafl: On 10/30/2014 5:02 PM, Virgil Arrington arringto...@gmail.com wrote: In my experience on this list, Tom has been extremely helpful and, just as important, courteous. I agree for the most part, and he is always polite and cordial. I just really hate it when someone deigns to try to 'help' me as if I'm a child, rather than just answer a simple question. The fact is, Libreoffice, for a long time, simply did not work at all with Java7. So, I figured I'd ask if Java8 was supported - meaning, expected to work properly in most cases... Sheesh... You are the one to check this out. We don't even know your operating system. -- 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: Recommended version of Java?
On 10/31/2014 3:26 PM, Andreas Säger ville...@t-online.de wrote: Am 31.10.2014 um 19:10 schrieb Tanstaafl: So, I figured I'd ask if Java8 was supported - meaning, expected to work properly in most cases... You are the one to check this out. We don't even know your operating system. Please STOP it. If Libreoffice requires Java to do certain things (yes, I understand that iits reliance on Java is less and less as time goes on, but it still requires it for some things), then it is on LIBREOFFICE to provide information what version(s) of Java it supports, and for what platforms. THAT IS WHAT I ASKED FOR. SHEESH. -- 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: Recommended version of Java?
Hi Andreas GSM Le 31 oct. 2014 20:27, Andreas Säger ville...@t-online.de a écrit : Am 31.10.2014 um 19:10 schrieb Tanstaafl: On 10/30/2014 5:02 PM, Virgil Arrington arringto...@gmail.com wrote: In my experience on this list, Tom has been extremely helpful and, just as important, courteous. I agree for the most part, and he is always polite and cordial. I just really hate it when someone deigns to try to 'help' me as if I'm a child, rather than just answer a simple question. The fact is, Libreoffice, for a long time, simply did not work at all with Java7. So, I figured I'd ask if Java8 was supported - meaning, expected to work properly in most cases... Sheesh... You are the one to check this out. We don't even know your operating system. This is your second not constructive comment on this thread. We really don't need them. We only need people able to help and respect each others. If you have problems with some persons here, please move to another list or to the Ask forum. Thanks. Sophie -- 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: Recommended version of Java?
Am 31.10.2014 um 20:32 schrieb Tanstaafl: On 10/31/2014 3:26 PM, Andreas Säger ville...@t-online.de wrote: Am 31.10.2014 um 19:10 schrieb Tanstaafl: So, I figured I'd ask if Java8 was supported - meaning, expected to work properly in most cases... You are the one to check this out. We don't even know your operating system. Please STOP it. If Libreoffice requires Java to do certain things (yes, I understand that iits reliance on Java is less and less as time goes on, but it still requires it for some things), then it is on LIBREOFFICE to provide information what version(s) of Java it supports, and for what platforms. THAT IS WHAT I ASKED FOR. SHEESH. And you got valid answers from me and from Florian for all operating systems (since you don't tell us yours). The fact is, Libreoffice, for a long time, simply did not work at all with Java7. Huh? Really? Which issue number was that? I can't believe that any LO version had been released with such a show stopper issue. The only issue I am aware of is that Windows users could not use any Java features because they pointed their 32 bit office suite to 64 bit Java runtimes. The issue was that the option dialog did not hide inadequate runtime versions. My LO 3.5 (64 bit, shipped with Ubuntu 12.4) works with any 64 bit Java I throw at it, including the latest Java 8.25, 6.33 shipped with Ubuntu 12.4 and 7.65. At least I can start the document wizards, Base forms, Base wizards and the report builder extension, configure another JRE, restart the office and start again document wizards, Base forms, Base wizards and report builder. -- 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
Fwd: [libreoffice-users] LO Calc question...
Sorry,, this should have gone to all... -- Forwarded message -- From: Andrew Sullivan andrew.t.sulli...@gmail.com Date: 31 October 2014 20:22 Subject: Re: [libreoffice-users] LO Calc question... To: Joe Conner joeconner2...@gmail.com Is it possible to freeze the left and right parts of a spreadsheet (as opposed to the upper and lower parts, which I know you can do)? Thanks Andrew On 26 October 2014 20:06, Andrew Sullivan andrew.t.sulli...@gmail.com wrote: That doesn't do exactly what I want... The data starts at A1; the chart occupies the space G3/M19. What I'd ideally like to do is split the sheet vertically between say columns E and F and be able to scroll the data columns. Can this be done? Thanks again. Andrew On 26 October 2014 19:21, Joe Conner joeconner2...@gmail.com wrote: You are able. Select a cell below your chart, then select WINDOW - FREEZE. That should do it. Blessings, Joe Conner, Poulsbo, WA USA On 10/26/2014 11:48 AM, Andrew Sullivan wrote: Hello First post here, hope it's in the right place... I have a simple spreadsheet in Calc - just a few columns fo data and a chart at the top of the page. The data columns are quite long (hundreds of lines eventually) and I would like to fix the position of the chart at the top of the page and scroll down the data columns. Assuming this makes sense, is it possible??? TIA Andrew -- 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: Recommended version of Java?
Am 31.10.2014 um 20:50 schrieb Sophie Gautier: Hi Andreas GSM Le 31 oct. 2014 20:27, Andreas Säger ville...@t-online.de a écrit : Am 31.10.2014 um 19:10 schrieb Tanstaafl: On 10/30/2014 5:02 PM, Virgil Arrington arringto...@gmail.com wrote: In my experience on this list, Tom has been extremely helpful and, just as important, courteous. I agree for the most part, and he is always polite and cordial. I just really hate it when someone deigns to try to 'help' me as if I'm a child, rather than just answer a simple question. The fact is, Libreoffice, for a long time, simply did not work at all with Java7. So, I figured I'd ask if Java8 was supported - meaning, expected to work properly in most cases... Sheesh... No, that was: THAT IS WHAT I ASKED FOR. SHEESH. See the difference? You are the one to check this out. We don't even know your operating system. This is your second not constructive comment on this thread. We really don't need them. We only need people able to help and respect each others. If you have problems with some persons here, please move to another list or to the Ask forum. Thanks. Sophie -- 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: Macro to abandon edits
On 31/10/14 15:58, Andreas Säger wrote: Am 31.10.2014 um 12:20 schrieb rmg: I'm migrating a bunch of spreadsheets from Debian Lenny/Openoffice to Debian Wheezy/Libreoffice 3.5.x. This is a dedicated setup used by many once-a-year users (who aren't chosen for their familiarity with computers) and, for instance, boots straight into a front end when switched on and shuts down when you close the front end. All driven by a startup script which launches the front end and waits for it to close. This sounds like a horrible mess. As far as I know, you can control the entire office process through a real program (Java, Python, Java Script) which starts up the office suite in listening mode, connects to the listening office, plays games with the same UNO-Api as macros do and finally takes care of the proper shutdown. I would train my users instead. Best of luck. It's for a club and there are 80 or so people who use it. If you had a well publicised training session you might get 15 or 20 turn up - and they'd have forgotten it all when it came to their turn to use it up to a year later. -- Dick Georgeson -- 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] Macro to abandon edits
On 31/10/14 21:23, Andrew Douglas Pitonyak wrote: http://www.oooforum.org/forum/viewtopic.phtml?t=46441 Last i checked, and that was a while ago, you could not tell LO to exit while a macro is running, but, you can probably issue a shell command to kill it from a macro. 'stardesktop.terminate' as the last statement in the shutdown macro seems to do the job. Feels better to me than a killall in the script after closing. I did wonder what doc.close(false) would do, it's shown everywhere as doc.close(true) but without any documentation of the parameter that I can find. On 10/31/2014 10:05 AM, Paul D. Mirowsky wrote: You might have to run a logout script from some type of .rc file. This is not the actual command and is not the best way to do it. It should be possible. The script will have a kill -9 soffice.bin and will need code to find it with 'ps'. See https://unix.stackexchange.com/questions/2745/how-to-run-a-script-during-gnome-log-out as an example from Gnome. Hope this helps. On 10/31/2014 7:20 AM, rmg wrote: I'm migrating a bunch of spreadsheets from Debian Lenny/Openoffice to Debian Wheezy/Libreoffice 3.5.x. This is a dedicated setup used by many once-a-year users (who aren't chosen for their familiarity with computers) and, for instance, boots straight into a front end when switched on and shuts down when you close the front end. All driven by a startup script which launches the front end and waits for it to close. The front end is fundamentally some buttons to launch working sheets and unchanging except that today's date is filled in when it starts, or the user can enter a different date. Mass of macros to handle it all. Closing the front end is by doc.close()ing in a Goodbye macro but this leaves an soffice.bin process running and you get a 'Program is still running' dialogue box when the machine shuts down; it goes away after a bit but it will alarm the user. I can get rid of that by putting 'stardesktop.terminate' (is 'xdesktop.terminate' preferrred?) in the shutdown macro but then when it next starts it wants to Recover the front end; that's a big no-no. Under Lenny/Openoffice there isn't this problem, when you've doc.close()d it shuts down happily and when it's next switched on loads the front end without complaint. I've tried doc.setmodified(FALSE) but no joy. I suppose I could get the shutdown macro to save it and the startup script to then delete that and copy the master back but that's pretty horrible. Is there a sensible way to fix this? -- Dick Georgeson -- 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: Recommended version of Java?
On 31/10/14 20:12, Andreas Säger wrote: The fact is, Libreoffice, for a long time, simply did not work at al with Java7. Huh? Really? Which issue number was that? I can't believe that any LO version had been released with such a show stopper issue. The problem is/was much more subtle than the OP implied. Java functioned correctly for some things, but not others. Change the build, and it worked correctly for a different set of things, but failed for the original set. Switch to a third build, and there was a different set of failures and successes. The only viable fix, is to completely rip Java out, and prohibit both extensions, and future code submissions that require Java. jonathon * English - detected * English * English javascript:void(0); and politly, but firmly prohibit any extenion that requires Java, and all coide that calls Java. IOW, make Java a prohibited language. -- 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