Re: [libreoffice-users] Is there a way for a Basic macro to detect what application is running it?
Hi to all, the most simple approach to distinguish the different behavior is to use an error handler. In the latest version of my translation of Andrew Pitonyak's OOME I give an example (see pp. 605-609). Andrew has changed his example to just handle LO alone. Have a look at https://www.uni-due.de/~abi070/ooo.html Greetings Volker Am 20.10.2014 um 18:59 schrieb Regina Henschel: Hi Fernand, Fernand Vanrie schrieb: Johnny, Regina , under tools we have a function GetProductName() who returns for me LibreOffice4.2 hope it helps Thanks for the hint to the application libraries. It works in Apache OpenOffice too. Kind regards Regina Fernand Hi Johnny, You might distinguish it with Basic function IsUnoStruct? Kind regards Regina Johnny Rosenberg schrieb: Here's my problem: I have both Apache OpenOffice and LibreOffice installed and I use them both. I have quite a few Calc files with Basic macros. Today I found my first difference between the Basic API in LibreOffice vs. Apache OpenOffice: Dim Dlg As Object, Ctl As Object DialogLibraries.LoadLibrary(Standard) Dlg=CreateUnoDialog(DialogLibraries.Standard.ElDialog) Ctl=Dlg.getControl(DateField) Now, I want to use Ctl.setDate(myDate) and myDate=Ctl.getDate(), and here's the difference: In Apache OpenOffice, myDate is a Long. Today's date, 2014-10-19, is represented as 20141019. I made two functions to convert to and from the format I needed. When running my macro in LibreOffice, the macro was interrupted by an error message, of course. After some debugging I found that the LibreOffice version of Ctl.setDate/Ctl.getDate works with a struct: Type DateType Year As Long Month As Long Day As Long End Type This is of course not a big deal, I can make the macro accept both formats, but the macro need to know if LibreOffice or Apache OpenOffice is running it. How can I do that? I have tried to find the answer myself, both using xray and searching the web, but so far nothing. -- Volker Lenhardt -- 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] 10 ways to help users move from Microsoft Office to LibreOffice - TechRepublic
Hi :) The article is excellent and it's good to see :)) I think there was a misleading bit about the newer MS Office formats working just fine in LibreOffice/OpenOffice as they do quite often run into problems. However, i am not sure it's a good thing to note down in an article. It's difficult to avoid ranting about vendor lock-in as well as the appearance of insanities, conspiracies and corruption of the ISO committees and the way big organisations have apparently been quite happy with MS's failure to implement their own format. So i think it's important to use the older MS formats if anyone who needs to edit a document has got to use MS Office. MS Office users seem to find it very difficult to use Save As and seem to get hopelessly confused and changing the default really needs an IT boffin. Personally i think MS Office is designed to make it all difficult to understand. In LibreOffice and OpenOffice it's all quite a lot easier, of course. I'm just not sure if it's a good thing to put into an article because it makes it all look tooo complicated. Also people tend to learn all that quite quickly if they ever do give LibreOffice a fair go so maybe just getting it onto their system is ore important. At the very least they are then able to open all the various formats quite easily and in a program that is designed to do so properly. ie MS Office for documents in OOXML (for at least 1 of the various transitional versions) and LibreOffice for everything else. Regards from Tom :) On 21 October 2014 20:12, James Knott james.kn...@rogers.com wrote: This could be useful to users of both LibreOffice and OpenOffice. http://www.techrepublic.com/blog/10-things/10-ways-to-help-users-move-from-microsoft-office-to-libreoffice/?tag=nl.e011s_cid=e011ttag=e011ftag=TRE475558a -- 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] LO and Java 8u25
Hello there, I have a fresh, clean install of OS X Yosemite on my Mac, along with Java 8u25 and LibreOffice 4.3.2.2. I can't make LibreOffice see” Java, as shown on the screen shot below. Any hints to share? Thanks. Alain. -- 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] LO and Java 8u25
On 10/22/2014 04:45 PM, Alain Andrieux wrote: I have a fresh, clean install of OS X Yosemite on my Mac, along with Java 8u25 and LibreOffice 4.3.2.2. I can't make LibreOffice see” Java, as shown on the screen shot below. Any hints to share? https://bugs.freedesktop.org/show_bug.cgi?id=74877 OS X 10.9: abrupt exit of LO in JNI_CreateJavaVM w/ Oracle Java 7 and w/o Apple Java 6. The workaround for that Oracle JRE bug is still to install Apple's Java for OS X alongside Oracle's JRE (as one gets prompted to do). Stephan -- 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: LO and Java 8u25
Le 22/10/2014 16:45, Alain Andrieux a écrit : You need to download and install : JavaForOSX2014-001.dmg as well. 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
[libreoffice-users] Connectors in draw.
Hi. How do I add or remove lines in connectors. When you right click a connector connector there is a property line skew. I am editing a drawing which has a connector with line 1 and line 2 filled in. I need to add more similar connectors (to avoid objects) but can't find how to add extra lines when the standard connector is inserted. TIA steve -- 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] Connectors in draw.
Hi, How can I build only the Calc part of LibreOffice. What are the changes I need to make in the makefile? Sreeraj C On Wed, Oct 22, 2014 at 10:56 PM, Steve Edmonds steve.edmo...@ptglobal.com wrote: Hi. How do I add or remove lines in connectors. When you right click a connector connector there is a property line skew. I am editing a drawing which has a connector with line 1 and line 2 filled in. I need to add more similar connectors (to avoid objects) but can't find how to add extra lines when the standard connector is inserted. TIA steve -- 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] Connectors in draw.
Hi Sreeraj Le 22/10/2014 19:42, sreeraj c a écrit : Hi, How can I build only the Calc part of LibreOffice. What are the changes I need to make in the makefile? You question would have more answers on the developers list. However, depending on what you want to do, if it's just for having the Calc module to work with, it won't be possible, modules are interdependent. Kind regards Sophie -- Sophie Gautier sophie.gaut...@documentfoundation.org Tel:+33683901545 Co-founder - Release coordinator The Document Foundation -- 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] Another spreadsheet destroyed.
A couple of years ago LibreOffice Calc destroyed one of my most important spreadsheets. Fortunately Apache OpenOffice was able to fix it for me, and since then I use Apache OpenOffice for all my important work. Since a few days back though, I started to use LibreOffice Calc (4.2.6.3) again, also for my important files. I shouldn't have done that, because the same thing happened again. Fortunately, the spreadsheet could be fixed again, this time thanks to some backups, but files are supposed to be used and worked with, not fixed… The file itself is maybe not that important, but I have been working on it for almost a decade, so I would probably be somewhat sad if I lost it. Happy – good, sad – bad… :P Anyway, it seems that LibreOffice Calc mess up my dialogues. I had three dialogues and today all the names of all their buttons were replaced with some default crap. Anyone else experienced this? If so, maybe I (or someone else) should file a bug report. Fortunately I export all my dialogues and basic code, so I could easily import them again with Apache OpenOffice. I tried first with LibreOffice, but when I imported the second dialogue it crashed. Ubuntu 14.04 LibreOffice 4.2.6.3. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- 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] Is there a way for a Basic macro to detect what application is running it?
I got a PM from Johnny feeling sorry that his German couldn't be profound enough to follow a lengthy course of explanations. So it's my turn to feel sorry for taking it for given that my post could suffice. I will be more precise. I need to explain why I consider it more expensive to control the code by the product name than by an error handler. The format change of the date *and time* controls started with LO 4.1 as far as I know. Maybe you can rely on this. But who knows at which point of time the AOO developers will decide to follow their colleagues and likewise change their API? And what about some other OpenOffices? (I don't know anything about them.) This is the listing in question with the comments in English: Listing 534. Initialize a date control to today’s date (works with all versions of AOO and LO). REM Initialize the date control. REM Set the initial date to TODAY. Dim tToday As Date tToday = Date() On Error Goto LO REM Try to initialize the control with a Long Integer. REM This is the correct format for AOO and for older versions of LO. oOOMEDlg.getModel().getByName(MyDateField).Date = CdateToIso(tToday) On Error Goto 0 'Clear the error handler. Goto GoOn LO: REM On Error the control is initialized using a structure. REM This is the correct format for newer versions of LO. On Error Goto 0 'Clear the error handler to prevent an infinite loop, 'in case the macro runs into some other runtime error. Dim oToday As New com.sun.star.util.Date oToday.Year = Year(tToday) oToday.Month = Month(tToday) oToday.Day = Day(tToday) oOOMEDlg.getModel().getByName(MyDateField).Date = oToday GoOn: Greetings Volker -- 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] Another spreadsheet destroyed.
Hi :) Over the decades i'd expect to need a few fresh starts, especially if it's in fairly frequent use. Is it possible to create a fresh new tab and copypaste some of the contents across? Perhaps as unformatted as possible to try to lose some more hidden coding? It might be worth posting a bug-report but you'd probably need an example spreadsheet showing how it goes wrong. Also it's a fairly rare use-case, to expect a spreadsheet to last so long without major revamps. Congrats on keeping it going! Regards from Tom :) On 22 October 2014 20:00, Johnny Rosenberg gurus.knu...@gmail.com wrote: A couple of years ago LibreOffice Calc destroyed one of my most important spreadsheets. Fortunately Apache OpenOffice was able to fix it for me, and since then I use Apache OpenOffice for all my important work. Since a few days back though, I started to use LibreOffice Calc (4.2.6.3) again, also for my important files. I shouldn't have done that, because the same thing happened again. Fortunately, the spreadsheet could be fixed again, this time thanks to some backups, but files are supposed to be used and worked with, not fixed… The file itself is maybe not that important, but I have been working on it for almost a decade, so I would probably be somewhat sad if I lost it. Happy – good, sad – bad… :P Anyway, it seems that LibreOffice Calc mess up my dialogues. I had three dialogues and today all the names of all their buttons were replaced with some default crap. Anyone else experienced this? If so, maybe I (or someone else) should file a bug report. Fortunately I export all my dialogues and basic code, so I could easily import them again with Apache OpenOffice. I tried first with LibreOffice, but when I imported the second dialogue it crashed. Ubuntu 14.04 LibreOffice 4.2.6.3. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- 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] Connectors in draw.
Hi :) Most of LibreOffice is the core shared stuff. The different modules/programs are effectively, mostly window dressing. So even if you do manage it then you'd save a very tiny percentage of space and resources. If you want a dedicated spreadsheet program then Gnumeric is good and co-operates well with LibreOffice; http://www.gnumeric.org/ It's so good that apparently quite a lot of people have it alongside an office suite such as MSO, LibreOffice or OpenOffice (and/or the others). Sometimes it's better to have a specialist program that doesn't have to worry about irrelevant features in other programs/modules. Abiword is a good stand-alone word-processor. I've not heard of people having that in addition to an office suite though. I have heard of people using a full Desktop Publishing program such as Scribus alognside LibreOffice even though Writer is more of a DTP than Word is. Apparently the output of Writer works well in Scribus. There are many stand-alone presentation software programs out there that are far better than Powerpoint / Impress, allegedly. Similarly with Draw. Most stand-alone programs have advantages and disadvantages compared to their LibreOffice/OpenOffice or MSO equivalents. For example Gimp doesn't do scalar-vector graphics very well, Draw does. Inkscape is great with scalar vector graphics but is very unusual and quite a stp learning curve at first, whereas Draw is fairly easy. It's only MS Office that doesn't play well with others. LibreOffice/OpenOffice do not aim to block out the rest of the world. They aim to co-operate and work well with a whole eco-system that includes a wide range of other programs. A classic example is email-clients. With MS Office you are restricted to really only using either Outlook or Outlook Express. With LibreOffice you find it integrates well with many other emailers, such as Evolution, Thunderbird, Claws or many others. On a low spec machine you might prefer Claws but if your needs are heftier you might prefer Thunderbird. Most people seem to default to Thunderbird but the choice is yours and you can change your mind and use something else later, or on a different machine. Regards from Tom :) On 22 October 2014 18:48, Sophie gautier.sop...@gmail.com wrote: Hi Sreeraj Le 22/10/2014 19:42, sreeraj c a écrit : Hi, How can I build only the Calc part of LibreOffice. What are the changes I need to make in the makefile? You question would have more answers on the developers list. However, depending on what you want to do, if it's just for having the Calc module to work with, it won't be possible, modules are interdependent. Kind regards Sophie -- Sophie Gautier sophie.gaut...@documentfoundation.org Tel:+33683901545 Co-founder - Release coordinator The Document Foundation -- 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] Emailing documents...
Using LO v4.2.6.3 on LinuxMint v17 Qiana MATE. I have two email clients on the computer. Thunderbird, which is set up for my wife's use, and MessengerPro which I use. LO has been set up to point to MessengerPro /usr/local/bin/messengerpro for sending documents by email but does not honour that path, inasmuch as it opens Thunderbird each time. My wife does not have a user account on the computer and I have not set one up as it would confuse her. She only uses the computer for email, browsing the internet and playing card games. LinuxMint Control Panel contains a Preferred Applications facility but the only choices in Email are Thunderbird and KMail. Is anyone able to suggest how I may solve the problem, please? David -- David Love Divorce, n. The past tense of marriage -- 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