Re: [libreoffice-documentation] Re: [libreoffice-users] MySQL/MariaDB Native Linux connector for LibreOffice 4.2 and 4.3 (32 and 64 bit)
Ubuntu 12.04, libreoffice Version: 4.3.2.2 Build ID: 430m0(Build:2), MariaDB 5.5.40 Sorry did not notice Stephan's problems. Just thought the connector for MariaDb needed testing. but maybe the versions are wrong for the job. sshelagh On 20 October 2014 07:23, Tom Davies tomc...@gmail.com wrote: Hi :) That sounds good! :) Have you tried the things that Stefan Gruber had trouble with? If so it'd be nice to hear which OS you tried it on, which version of LO and which version of MariasDb. That might help people pin-point the problems Stefan has been having. Many thanks for test-driving the connector! Regards from Tom :) On 19 October 2014 01:32, shelagh.man...@gmail.com shelagh.man...@gmail.com wrote: Ok, so I have mariabdb installed which is meant to work like a drop in replacement for mysql. In other stuff I have done, there has been no problem using mariadb instead of mysql. I was able to create a simple database in mariadb and open it in base using the direct connection. I changed some data, saved it and closed base. I checked in the database on cli and the data had been entered. So I would say that you could say that it works as advertised. Cheers Shelagh On 16 October 2014 02:50, Tom Davies tomc...@gmail.com wrote: Hi :) Has anyone been able to test this out yet? Is it possible to test-drive these connectors without breaking an existing database? Errr, i'm not going to be able to test them myself so i was just mildly curious. Regards from Tom :) On 11 October 2014 16:49, Dan Lewis elderdanle...@gmail.com wrote: These connectors are available as Release Candidate #1. They have been tested against both MariaDB and MySQL databases. I would like to have a few more people see if these work as well as they have so far been described. Unless I hear from someone with a reason why it does not work as it should within the next week, I will be upgrading these to final release. This is the URL: http://extensions.libreoffice.org/extension-center/mysql-native-connector/ -- 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: documentation+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/documentation/ 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] Is there a way for a Basic macro to detect what application is running it?
Quickly looking through the (not very user friendly) help for LibreOffice Basic, the closest thing I found is GetSolarVersion, but that's probably not enough. While checking if the type is a struct can be a good workaround, it's not completely future-proof; there is a need for a function to distinguish between version of the Basic API (not only between AOO and LO). -- Cley Faye http://cleyfaye.net 2014-10-19 21:06 GMT+02:00 Johnny Rosenberg gurus.knu...@gmail.com: 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. 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] Is there a way for a Basic macro to detect what application is running it?
A ctually there was another change from the post that I put before, the Setup.xcu seems to be replaced by the registrymodifications.xcu This has an ID check that list the following node: item oor:path=/org.openoffice.Setup/Office prop oor:name=LastCompatibilityCheckID oor:op=fuse value411m6(Build:9775)/value /prop /item Unfortunately there is no such thing as a vendor name, but I hink this could be good enough, unless someone come with a better node. On Mon, Oct 20, 2014 at 3:56 AM, Cley Faye cleyf...@gmail.com wrote: Quickly looking through the (not very user friendly) help for LibreOffice Basic, the closest thing I found is GetSolarVersion, but that's probably not enough. While checking if the type is a struct can be a good workaround, it's not completely future-proof; there is a need for a function to distinguish between version of the Basic API (not only between AOO and LO). -- Cley Faye http://cleyfaye.net 2014-10-19 21:06 GMT+02:00 Johnny Rosenberg gurus.knu...@gmail.com: 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. 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 -- Alexandro Colorado Apache OpenOffice Contributor 882C 4389 3C27 E8DF 41B9 5C4C 1DB7 9D1C 7F4C 2614 -- 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] Fatal error when exporting a dialogue.
Hi :) I don't know what is going on there. It might be worth asking on the devs irc channel. Thinking side-ways it might be worth asking on the international translators mailing list l...@libreoffice.org as they often seem to know contet for the different strings they have to translate. It might be easier to understand their answers where the devs answers might need a bit of translating into normal English. ;) Regards from Tom :) On 19 October 2014 12:12, Johnny Rosenberg gurus.knu...@gmail.com wrote: I tried this with the same file in both Apache OpenOffice Calc and LibreOffice Calc, the same result. Error message: Apache OpenOffice Calc: ”StringResourceImpl: No entry for resourceID:” If I click OK, Apache OpenOffice Calc crash. The file is saved but loading it doesn't work. Nothing happens. LibreOffice Calc: ”StringResourceImpl: No entry for resourceID: !!br0ken!!” LibreOffice Calc crash when clicking OK. The file is saved but loading it makes LibreOffice Calc crash. The file is quite big. It takes about 23 seconds to open it with LibreOffice Calc and 51 seconds with Apache OpenOffice. Apache OpenOffice 4.1 LibreOffice 4.2 Ubuntu 14.04 My question is: What does this error message mean? Can I do anything about it? Like editing my dialogue somehow before trying to export it? Seems like some parameter somewhere is missing for some reason. An earlier version of the dialogue can be exported and imported without any problems. The difference between the new and the old dialogue is that I added a label and a number field to the new one. I did that by copying and editing existing ones. Maybe something was lost during that process. Any hints will be appreciated. I guess I could just start all over again and create a new one, but I want to know (if possible) what's wrong with the one I already have. 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] Is there a way for a Basic macro to detect what application is running it?
Johnny, Regina , under tools we have a function GetProductName() who returns for me LibreOffice4.2 hope it helps 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. -- 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] Final Release: MySQL/MariaDB Native Connector for Linux
Today, I have changed the status of this connector from Release Candidate #1 to Final Release. This should be used with LibreOffice 4.2.x and 4.3.x that are downloaded from the LibreOffice website. LibreOffice that is downloaded from a Linux repository can use the MySQL native connector that its repository also contains. My version may also work with their version of LibreOffice. Dan -- 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?
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. -- 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] Missing feature at LibreOffice Writer.
Hi, I'm writing this because there is a *missing feature on LibreOffice Writer (4.3.2.2) *. I wanted to post online on ask.libreofice but i do not have any of the proposed accounts. (most of them are non-libre software related..) *The missing feature:* When creating text dialogs with the T (text) Button, it is not possible to change the font color. I was surprised because in libreoffice impress it is possible to change the color. So a simple hack is to copy paste the text dialog from impress to writer. The text can be modified and the color will remain. Anyways, the option is missing on libreoffice writer. This email may not be addressed to the good mailing list, if it is that the case, please transfer my message! It would be highly appreciated! Happy hacking ;} https://www.debian.org/ -- 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] Missing feature at LibreOffice Writer.
Hi :) It seems to be missing in LO 3.5.7 on Ubuntu 12.04 too. Regards from Tom :) On 20 October 2014 17:22, Rafael Senties Martinelli r...@imap.cc wrote: Hi, I'm writing this because there is a *missing feature on LibreOffice Writer (4.3.2.2) *. I wanted to post online on ask.libreofice but i do not have any of the proposed accounts. (most of them are non-libre software related..) *The missing feature:* When creating text dialogs with the T (text) Button, it is not possible to change the font color. I was surprised because in libreoffice impress it is possible to change the color. So a simple hack is to copy paste the text dialog from impress to writer. The text can be modified and the color will remain. Anyways, the option is missing on libreoffice writer. This email may not be addressed to the good mailing list, if it is that the case, please transfer my message! It would be highly appreciated! Happy hacking ;} https://www.debian.org/ -- 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] Missing feature at LibreOffice Writer.
Hi Rafael, Rafael Senties Martinelli schrieb: Hi, I'm writing this because there is a *missing feature on LibreOffice Writer (4.3.2.2) *. I wanted to post online on ask.libreofice but i do not have any of the proposed accounts. (most of them are non-libre software related..) *The missing feature:* When creating text dialogs with the T (text) Button, it is not possible to change the font color. Why not? I have no problems with changing the font color. I know three ways: (A) Mark the word, click on the Character icon in the toolbar, switch to tab Font effects and select your color from the drop-down list Font color. Instead of the icon you can use Format Character or context menu item Character as well. (B) Enable the icon command Font Color: Right click the toolbar Visible icons Click on text Font Color. Use the icon as usual. (c) Open the side bar in pane Properties. Mark the text and use the Font Color drop-down list from the side bar. I was surprised because in libreoffice impress it is possible to change the color. So a simple hack is to copy paste the text dialog from impress to writer. The text can be modified and the color will remain. Anyways, the option is missing on libreoffice writer. There are indeed some options missing in Writer which are available in Draw and Impress, for example formatting by using styles. But Font Color is no problem. Kind regards Regina -- 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] Missing feature at LibreOffice Writer.
Hi :) Ahh, i only noticed that the usual icons vanished from the icon-tool-bar. I haven't tried Regina's suggestions yet but i'm fairly sure they will work. Regards from Tom :) On 20 October 2014 18:58, Regina Henschel rb.hensc...@t-online.de wrote: Hi Rafael, Rafael Senties Martinelli schrieb: Hi, I'm writing this because there is a *missing feature on LibreOffice Writer (4.3.2.2) *. I wanted to post online on ask.libreofice but i do not have any of the proposed accounts. (most of them are non-libre software related..) *The missing feature:* When creating text dialogs with the T (text) Button, it is not possible to change the font color. Why not? I have no problems with changing the font color. I know three ways: (A) Mark the word, click on the Character icon in the toolbar, switch to tab Font effects and select your color from the drop-down list Font color. Instead of the icon you can use Format Character or context menu item Character as well. (B) Enable the icon command Font Color: Right click the toolbar Visible icons Click on text Font Color. Use the icon as usual. (c) Open the side bar in pane Properties. Mark the text and use the Font Color drop-down list from the side bar. I was surprised because in libreoffice impress it is possible to change the color. So a simple hack is to copy paste the text dialog from impress to writer. The text can be modified and the color will remain. Anyways, the option is missing on libreoffice writer. There are indeed some options missing in Writer which are available in Draw and Impress, for example formatting by using styles. But Font Color is no problem. Kind regards Regina -- 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