[libreoffice-users] Re: Unexpected behavior while writing Calc Functions
Am 16.07.2012 06:11, Andrew Douglas Pitonyak wrote: On 07/15/2012 06:52 PM, Andreas Säger wrote: Calc does not know any dates nor times. It's all about doubles and text. -- View this message in context: http://nabble.documentfoundation.org/Unexpected-behavior-while-writing-Calc-Functions-tp3995669p3995674.html Sent from the Users mailing list archive at Nabble.com. Although that is true, I expected a date returned from a function would return as a double, not text. Internal Date functions in Calc appear to return as a double and then it is smart enough to display it as a date or am I mistaken? Sorry, no magic conversion. The double is displayed as date/time when the cell is formatted accordingly. The cell value remains a double. In the context of number format General, certain input strings are recognized as date/time and number format General displays one particular number format for the recognized data type. Once you applied some number format other than the General one, any number will be shown in that format. Nevertheless, we can queryContentCells for c.s.s.sheet.CellFlag.DATETIME because the application needs to keep track of those special doubles because the base date for the entire document may be changed by the user. http://www.openoffice.org/api/docs/common/ref/com/sun/star/util/NumberFormatSettings.html#NullDate -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Compose key is being ignored
2012/7/16 J.A. de Vries hdv.ja...@gmail.com: Hi all, Recently I moved from using the version of LibreOffice supplied by my package manager (aptitude) to the one provided on the LibreOffice website (currently I am running 3.5.4). So far all is well, but I noticed one difference that I'd really like to change. I've set up Capslock to be used as the compose key on my system (Debian GNU/Linux with KDE). That works just fine for all applications, but not so anymore for the version of LibreOffice I've installed outside of the package manager. There it seems the compose key is ignored completely. I can not reproduce the problem, but I use another operating system (Ubuntu 10.10) and an older LibreOffice (3.3.4), the LibreOffice website version. Maybe this is a LibreOffice 3.5.4 problem? I would try to install the most recent stable version, which seems to be 3.5.5 at the moment. If you can't make it work, an obvious workaround would be to use the Auto correction feature in LibreOffice. I think ”Straße” is already in the list if you set the character language style to German. If not, you can easily add it yourself in whatever language you want. But really, it should work. I use Caps Lock for compose, just like you, and it worked fine in LibreOffice Calc 3.3.4. I will install a more recent version soon and try, I've just been lazy lately, or maybe busy (I'm in the middle of my vacation right now)… Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ If I type StraCAPSLOCKsse I get the intended Straße in all apps, but LibreOffice gives me Strae. Can anyone advise me on how to fix this behavior? I use a lot of special characters when writing and I write a lot for my work, so it would really make a difference for me if I can use the compose key again in LibreOffice. But I'd prefer to not go back to the version provided by the package manager, because I need some recently added features that are not in there. Your help would be appreciated. Grx HdV -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Compose key is being ignored
On 2012-07-16 12:25, Johnny Rosenberg wrote: I can not reproduce the problem, but I use another operating system (Ubuntu 10.10) and an older LibreOffice (3.3.4), the LibreOffice website version. Maybe this is a LibreOffice 3.5.4 problem? I would try to install the most recent stable version, which seems to be 3.5.5 at the moment. If you can't make it work, an obvious workaround would be to use the Auto correction feature in LibreOffice. I think ”Straße” is already in the list if you set the character language style to German. If not, you can easily add it yourself in whatever language you want. I thought of that, but that works if you only have a couple of words with non-standard characters. I write a lot in Swedish and German (among other languages), both languages with lots of those characters. So I'll probably loose more time building replacement lists than just making a row of the most occurring charters in vim and copying that to each document after opening it. From that row I copy the characters needed when writing. It is cumbersome, but as a temporary measure it is workable. But really, it should work. I use Caps Lock for compose, just like you, and it worked fine in LibreOffice Calc 3.3.4. I will install a more recent version soon and try, I've just been lazy lately, or maybe busy (I'm in the middle of my vacation right now)… I've used both KDE and dpkg-reconfigure to map the compose key to Capslock and in *all* other applications that works just fine. But somehow it doesn't in LibreOffice (it does in the version provided by aptitude). Grx HdV -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Compose key is being ignored
Hi :) Would it help to add the dictionaries of the other languages? Sorry, i'm sure someone else has thought of this idea too but i often find the simplest waggle the wires type of answers get overlooked. Regards from Tom :) --- On Mon, 16/7/12, J.A. de Vries hdv.ja...@gmail.com wrote: From: J.A. de Vries hdv.ja...@gmail.com Subject: Re: [libreoffice-users] Compose key is being ignored To: users@global.libreoffice.org Date: Monday, 16 July, 2012, 11:57 On 2012-07-16 12:25, Johnny Rosenberg wrote: I can not reproduce the problem, but I use another operating system (Ubuntu 10.10) and an older LibreOffice (3.3.4), the LibreOffice website version. Maybe this is a LibreOffice 3.5.4 problem? I would try to install the most recent stable version, which seems to be 3.5.5 at the moment. If you can't make it work, an obvious workaround would be to use the Auto correction feature in LibreOffice. I think ”Straße” is already in the list if you set the character language style to German. If not, you can easily add it yourself in whatever language you want. I thought of that, but that works if you only have a couple of words with non-standard characters. I write a lot in Swedish and German (among other languages), both languages with lots of those characters. So I'll probably loose more time building replacement lists than just making a row of the most occurring charters in vim and copying that to each document after opening it. From that row I copy the characters needed when writing. It is cumbersome, but as a temporary measure it is workable. But really, it should work. I use Caps Lock for compose, just like you, and it worked fine in LibreOffice Calc 3.3.4. I will install a more recent version soon and try, I've just been lazy lately, or maybe busy (I'm in the middle of my vacation right now)… I've used both KDE and dpkg-reconfigure to map the compose key to Capslock and in *all* other applications that works just fine. But somehow it doesn't in LibreOffice (it does in the version provided by aptitude). Grx HdV -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Compose key is being ignored
On 2012-07-16 02:16, Mirosław Zalewski wrote: I could not reproduce your issue. I am using Debian testing, amd64, KDE 4.8.4. I have installed LO 3.5.5 downloaded from LO page, run it and compose key (which is right-Ctrl here) is working fine. If this is not architecture/LO version dependent (you did not provide information about it), then: This is on a Intel 32-bits platform, using an up-to-date Debian GNU/Linux testing with KDE 4.8.4 and LibreOffice 3.5.4 downloaded from the website. how did you map your compose key? In KDE system settings or through dpkg-reconfigure keyboard-configuration command? I have set mine through dpkg-reconfigure. I did not touch any KDE settings. I used both KDE and dpkg-reconfigure to map the compose key to Capslock and in *all* other applications (both GTK and QT based) that works just fine. But somehow it doesn't in LibreOffice. It does in the version provided by aptitude, just not in the official version downloaded from the website. Thanks for trying to help. Grx HdV -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Compose key is being ignored
On 2012-07-16 13:00, Tom Davies wrote: Hi :) Would it help to add the dictionaries of the other languages? After installation I always immediately add the dictionaries for the 5 languages I regularly use. So sadly, no. That doesn't change things. Sorry, i'm sure someone else has thought of this idea too but i often find the simplest waggle the wires type of answers get overlooked. In my experience you're right. Often it is the simplest things that get overlooked and that later on prove to be the solution. It'll probably be likewise in this case. I've just not thought of the proper simple thing yet... Thanks for thinking with me. Grx HdV -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] creating new master template
Hi :) There is some documentation at http://wiki.documentfoundation.org/Documentation/Publications and i think you might be in luck with the Impress Guide being ultra up-to-date. Good luck and regards from Tom :) --- On Wed, 13/6/12, Bala subramanian bala.biophys...@gmail.com wrote: From: Bala subramanian bala.biophys...@gmail.com Subject: [libreoffice-users] creating new master template To: users@global.libreoffice.org Date: Wednesday, 13 June, 2012, 11:30 Hello, If i have to design a new master slide and include it to the master templates, how can i do it in Libreoffice power point. Bala -- C. Balasubramanian -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Compose key is being ignored
2012/7/16 J.A. de Vries hdv.ja...@gmail.com: On 2012-07-16 12:25, Johnny Rosenberg wrote: I can not reproduce the problem, but I use another operating system (Ubuntu 10.10) and an older LibreOffice (3.3.4), the LibreOffice website version. Maybe this is a LibreOffice 3.5.4 problem? I would try to install the most recent stable version, which seems to be 3.5.5 at the moment. If you can't make it work, an obvious workaround would be to use the Auto correction feature in LibreOffice. I think ”Straße” is already in the list if you set the character language style to German. If not, you can easily add it yourself in whatever language you want. I thought of that, but that works if you only have a couple of words with non-standard characters. I write a lot in Swedish and German (among other languages), both languages with lots of those characters. I see, so you need ßåäöÅÄÖüÜ and maybe more, and you use a US keyboard or at least not a German or a Swedish one? I don't use KDE myself and I have a Swedish keyboard (since I write almost everything in Swedish – that explains my poor English…). I use a lot special characters, except those Swedish ones, so I just created my own keyboard layout (called Swedish – Johnny Rosenberg), so I can easily type characters, such as ”… – — ℃ π ℗”, using the AltGr key (”Right Alt key” on some keyboards), but I guess that's probably not the easiest way out of this problem… So I'll probably loose more time building replacement lists than just making a row of the most occurring charters in vim and copying that to each document after opening it. From that row I copy the characters needed when writing. It is cumbersome, but as a temporary measure it is workable. But really, it should work. I use Caps Lock for compose, just like you, and it worked fine in LibreOffice Calc 3.3.4. I will install a more recent version soon and try, I've just been lazy lately, or maybe busy (I'm in the middle of my vacation right now)… I installed 3.5.5 from the http://www.libreoffice.org/ web page and my compose key works perfectly in both LibreOffice Writer and LibreOffice Calc. Try to update and see what happens, maybe this is a 3.5.4 issue. That's what I would do, anyway. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ I've used both KDE and dpkg-reconfigure to map the compose key to Capslock and in *all* other applications that works just fine. But somehow it doesn't in LibreOffice (it does in the version provided by aptitude). Grx HdV -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] more free publicity for LO.
In an E-newsletter, I saw this: [quote] Here comes Office 2013 http://www.computerworld.com/s/article/9229119/Report_Ballmer_to_unveil_Office_2013_Monday Microsoft is reported to unveil the next version of Office today. Details are limited, but it will likely be reworked to integrate with Windows 8. Don't pay a bundle for Office before trying this great free alternative. Download it from my site. http://www.komando.com/downloads/category.aspx?id=10270utm_medium=nlutm_source=notdutm_content=2012-07-16-articleutm_campaign=end-f [unquote] The linked article is: http://www.computerworld.com/s/article/9229119/Report_Ballmer_to_unveil_Office_2013_Monday The free alternative to MSO link is: http://www.komando.com/downloads/category.aspx?id=10270utm_medium=nlutm_source=notdutm_content=2012-07-16-articleutm_campaign=end-f This page describes LibreOffice as the free alternative. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] creating new master template
Yes, the Impress 3.5 docs were finished in May. It is the most up-to-date full guide we have for the 3.5 line. On 07/16/2012 07:19 AM, Tom Davies wrote: Hi :) There is some documentation at http://wiki.documentfoundation.org/Documentation/Publications and i think you might be in luck with the Impress Guide being ultra up-to-date. Good luck and regards from Tom :) --- On Wed, 13/6/12, Bala subramanian bala.biophys...@gmail.com wrote: From: Bala subramanian bala.biophys...@gmail.com Subject: [libreoffice-users] creating new master template To: users@global.libreoffice.org Date: Wednesday, 13 June, 2012, 11:30 Hello, If i have to design a new master slide and include it to the master templates, how can i do it in Libreoffice power point. Bala -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Unexpected behavior while writing Calc Functions
Hi Andrew, Andrew Douglas Pitonyak schrieb: I wrote a simple function Function mydate As Date mydate = CDate(100) End Function I then called this function from a Calc document =myDate() Finally, I directly accessed the cells with the dates from a macro similar to the following code: Print ThisComponent.Sheets(0).getCellByPosition(0, 1).Value The cell displayed the value as I expected, but the returned value was zero. Turns out that dates are converted to strings when returned to Calc. Oops. The proper thing to do (if you want it to work as expected) is to return a numeric value. I'm not sure about that. date is a special Basic data type, it is not type double. The Programming Guide tells vaguely StarOffice Basic uses an internal format that permits comparisons and mathematical operations on date and time values. I do not find informations about mapping type date to UNO. The Developer's Guide has a mapping UNO - Basic, but I miss the other way round. There seems to be some conversions already in Basic. If your function returns double not date, then you get the serial number of the date/time. It is more a documentation issue, than a real bug. Kind regards Regina -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Unexpected behavior while writing Calc Functions
Hi :) I am pretty sure that Date is an Sql data-type, just like double or text but perhaps it got tweaked-off somewhere in the embedded HsqlDb? Andrew is almost never wrong and Regina is never wrong so i'm at a loss about this atm. Regards from Tom :) --- On Mon, 16/7/12, Regina Henschel rb.hensc...@t-online.de wrote: From: Regina Henschel rb.hensc...@t-online.de Subject: Re: [libreoffice-users] Unexpected behavior while writing Calc Functions To: users@global.libreoffice.org Date: Monday, 16 July, 2012, 13:07 Hi Andrew, Andrew Douglas Pitonyak schrieb: I wrote a simple function Function mydate As Date mydate = CDate(100) End Function I then called this function from a Calc document =myDate() Finally, I directly accessed the cells with the dates from a macro similar to the following code: Print ThisComponent.Sheets(0).getCellByPosition(0, 1).Value The cell displayed the value as I expected, but the returned value was zero. Turns out that dates are converted to strings when returned to Calc. Oops. The proper thing to do (if you want it to work as expected) is to return a numeric value. I'm not sure about that. date is a special Basic data type, it is not type double. The Programming Guide tells vaguely StarOffice Basic uses an internal format that permits comparisons and mathematical operations on date and time values. I do not find informations about mapping type date to UNO. The Developer's Guide has a mapping UNO - Basic, but I miss the other way round. There seems to be some conversions already in Basic. If your function returns double not date, then you get the serial number of the date/time. It is more a documentation issue, than a real bug. Kind regards Regina -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Compose key is being ignored
On 16/07/2012 at 13:03, J.A. de Vries hdv.ja...@gmail.com wrote: It does in the version provided by aptitude, just not in the official version downloaded from the website. I see. You could also try on fresh user profile. Run something like this from command line: /opt/path/to/soffice -env:UserInstallation=file:///tmp/lo/ (Please note that this is file:// protocol and then absolute path to directory) If it works, then we will at least know that this is something in your LO profile and not package problem. What GUI (Qt, GTK, X11) did you use? On my test, I have tried pure X11 (I didn't bother to install desktop integration packages). You can use different GUI than default with OOO_FORCE_DESKTOP variable. As far as I remember, GTK uses different, hardcoded in source code Xcompose sequences. This can be changed by GTK_IM_MODULE environment variable. I have set it to xim to ensure that GTK apps uses the same sequences as other apps. But if that's a case, then LO from repository should also be affected, which you claim is not. So perhaps it won't help, but you can give it a try anyway. Apart from these three things, I am out of ideas. -- Best regards Mirosław Zalewski -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Unexpected behavior while writing Calc Functions
2012/7/16 Tom Davies tomdavie...@yahoo.co.uk: Hi :) I am pretty sure that Date is an Sql data-type, just like double or text but perhaps it got tweaked-off somewhere in the embedded HsqlDb? Andrew is almost never wrong and Regina is never wrong so i'm at a loss about this atm. Regards from Tom :) Nobody is never wrong. Not even me… :P Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ --- On Mon, 16/7/12, Regina Henschel rb.hensc...@t-online.de wrote: From: Regina Henschel rb.hensc...@t-online.de Subject: Re: [libreoffice-users] Unexpected behavior while writing Calc Functions To: users@global.libreoffice.org Date: Monday, 16 July, 2012, 13:07 Hi Andrew, Andrew Douglas Pitonyak schrieb: I wrote a simple function Function mydate As Date mydate = CDate(100) End Function I then called this function from a Calc document =myDate() Finally, I directly accessed the cells with the dates from a macro similar to the following code: Print ThisComponent.Sheets(0).getCellByPosition(0, 1).Value The cell displayed the value as I expected, but the returned value was zero. Turns out that dates are converted to strings when returned to Calc. Oops. The proper thing to do (if you want it to work as expected) is to return a numeric value. I'm not sure about that. date is a special Basic data type, it is not type double. The Programming Guide tells vaguely StarOffice Basic uses an internal format that permits comparisons and mathematical operations on date and time values. I do not find informations about mapping type date to UNO. The Developer's Guide has a mapping UNO - Basic, but I miss the other way round. There seems to be some conversions already in Basic. If your function returns double not date, then you get the serial number of the date/time. It is more a documentation issue, than a real bug. Kind regards Regina -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Compose key is being ignored
On 2012-07-16 15:09, Mirosław Zalewski wrote: I see. You could also try on fresh user profile. Run something like this from command line: /opt/path/to/soffice -env:UserInstallation=file:///tmp/lo/ (Please note that this is file:// protocol and then absolute path to directory) If it works, then we will at least know that this is something in your LO profile and not package problem. Good suggestion. Tried it, but I am sorry to say it change things. Just to be sure I also tried with a complete new user on the system. Same result. What GUI (Qt, GTK, X11) did you use? I am running KDE (thus Qt) with the GTK+ Appearance package on top of it. On my test, I have tried pure X11 (I didn't bother to install desktop integration packages). You can use different GUI than default with OOO_FORCE_DESKTOP variable. I use SAL_USE_VCLPLUGIN=gen to get the same effect. As far as I remember, GTK uses different, hardcoded in source code Xcompose sequences. This can be changed by GTK_IM_MODULE environment variable. I have set it to xim to ensure that GTK apps uses the same sequences as other apps. But if that's a case, then LO from repository should also be affected, which you claim is not. So perhaps it won't help, but you can give it a try anyway. Just to be sure I did try it anyway. Alas, no show. Thanks for the suggestions! Grx HdV -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Compose key is being ignored
On 2012-07-16 13:34, Johnny Rosenberg wrote: I see, so you need ßåäöÅÄÖüÜ and maybe more, and you use a US keyboard or at least not a German or a Swedish one? Exactly. I use a US Intl keyboard. I don't use KDE myself and I have a Swedish keyboard (since I write almost everything in Swedish – that explains my poor English…). I use a lot special characters, except those Swedish ones, so I just created my own keyboard layout (called Swedish – Johnny Rosenberg), so I can easily type characters, such as ”… – — ℃ π ℗”, using the AltGr key (”Right Alt key” on some keyboards), but I guess that's probably not the easiest way out of this problem… Not really, but it is an improvement over what I have now. But really, it should work. I use Caps Lock for compose, just like you, and it worked fine in LibreOffice Calc 3.3.4. I will install a more recent version soon and try, I've just been lazy lately, or maybe busy (I'm in the middle of my vacation right now)… I installed 3.5.5 from the http://www.libreoffice.org/ web page and my compose key works perfectly in both LibreOffice Writer and LibreOffice Calc. Try to update and see what happens, maybe this is a 3.5.4 issue. That's what I would do, anyway. I updated my LO to the most recent version available at the moment, but it didn't change things. Grx HdV -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Compose key is being ignored
On 2012-07-16 15:09, Mirosław Zalewski wrote: What GUI (Qt, GTK, X11) did you use? On my test, I have tried pure X11 (I didn't bother to install desktop integration packages). You can use different GUI than default with OOO_FORCE_DESKTOP variable. As far as I remember, GTK uses different, hardcoded in source code Xcompose sequences. This can be changed by GTK_IM_MODULE environment variable. I have set it to xim to ensure that GTK apps uses the same sequences as other apps. But if that's a case, then LO from repository should also be affected, which you claim is not. So perhaps it won't help, but you can give it a try anyway. Apart from these three things, I am out of ideas. Well, it seems you are on the right track here! I tried changing my SAL_USE_VCLPLUGIN value from gen (generic X11) to kde and gtk and voila the compose key has magically reappeared. Great! However, now I am faced with another problem. This made me remember why I choose gen in the first place. If I use either kde or gtk some widgets (notably comboboxes and menu spearators) in the UI become very coarse and ugly (which I could live with if necessary) and in some cases even unusable (which is more problematic). Anyone else noticed this? Grx HdV -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Compose key is being ignored
Hi :) The best place to find out where your User Profile really is, is to open LibreOffice and then try Tools - Options - Paths but to help you find what sort of thing you are looking for this wiki helps http://wiki.documentfoundation.org/Documentation/UserProfile (hopefully helps anyway) as it gives the default location in the various operating systems Windows pre-Vista Windows Vista and beyond GnuLinux (except, of course, 1 of them has to be different from the rest) BSD (i think. BSDers tend to be left to their own devices and tend to get help from other BSDers in a separate forum and stuff) Of course the location had to change for 3.5.x as the standard changed for most operating systems in the interests of clarity (or something). So, the wiki-guide tries to make a fairly confusing set-up a lot less confusing but probably misses. Suggestions for the wiki-page are welcome (ish). Regards from Tom :) --- On Mon, 16/7/12, J.A. de Vries hdv.ja...@gmail.com wrote: From: J.A. de Vries hdv.ja...@gmail.com Subject: Re: [libreoffice-users] Compose key is being ignored To: users@global.libreoffice.org Date: Monday, 16 July, 2012, 15:12 On 2012-07-16 15:09, Mirosław Zalewski wrote: I see. You could also try on fresh user profile. Run something like this from command line: /opt/path/to/soffice -env:UserInstallation=file:///tmp/lo/ (Please note that this is file:// protocol and then absolute path to directory) If it works, then we will at least know that this is something in your LO profile and not package problem. Good suggestion. Tried it, but I am sorry to say it change things. Just to be sure I also tried with a complete new user on the system. Same result. What GUI (Qt, GTK, X11) did you use? I am running KDE (thus Qt) with the GTK+ Appearance package on top of it. On my test, I have tried pure X11 (I didn't bother to install desktop integration packages). You can use different GUI than default with OOO_FORCE_DESKTOP variable. I use SAL_USE_VCLPLUGIN=gen to get the same effect. As far as I remember, GTK uses different, hardcoded in source code Xcompose sequences. This can be changed by GTK_IM_MODULE environment variable. I have set it to xim to ensure that GTK apps uses the same sequences as other apps. But if that's a case, then LO from repository should also be affected, which you claim is not. So perhaps it won't help, but you can give it a try anyway. Just to be sure I did try it anyway. Alas, no show. Thanks for the suggestions! Grx HdV -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Compose key is being ignored
On 2012-07-16 16:41, Tom Davies wrote: Hi :) The best place to find out where your User Profile really is, is to open LibreOffice and then try Tools - Options - Paths but to help you find what sort of thing you are looking for this wiki helps http://wiki.documentfoundation.org/Documentation/UserProfile (hopefully helps anyway) as it gives the default location in the various operating systems Windows pre-Vista Windows Vista and beyond GnuLinux (except, of course, 1 of them has to be different from the rest) BSD (i think. BSDers tend to be left to their own devices and tend to get help from other BSDers in a separate forum and stuff) Of course the location had to change for 3.5.x as the standard changed for most operating systems in the interests of clarity (or something). So, the wiki-guide tries to make a fairly confusing set-up a lot less confusing but probably misses. Suggestions for the wiki-page are welcome (ish). Sorry for the typo in the previous message. I meant to say removing the profile did not improve things. I tried this by moving my old profile from .config/libreoffice/ and also by creating a new user on the system, in both cases the problem persisted. Miroslaw's idea of checking the environment variables did solve the problem of the disfunctional compose key, but made another problem reappear. Now I have a compose key, but also a GUI that is ugly and in some cases broken (parts of comboboxes become unreadable). Grx HdV -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Compose key is being ignored
Hi :) Ahh, so i guess that is something to do with desktop integration? I think one of these 2 wiki's might help with that http://wiki.documentfoundation.org/Installing_in_parallel http://wiki.documentfoundation.org/Installing_LibreOffice_on_Linux They aren't really designed for this purpose but they might contain useful pointers. At last! Wiki-pages that weren't edited by me at all! They probably make a lot more sense but don't count on it. Regards from Tom :) --- On Mon, 16/7/12, J.A. de Vries hdv.ja...@gmail.com wrote: From: J.A. de Vries hdv.ja...@gmail.com Subject: Re: [libreoffice-users] Compose key is being ignored To: users@global.libreoffice.org Date: Monday, 16 July, 2012, 15:50 On 2012-07-16 16:41, Tom Davies wrote: Hi :) The best place to find out where your User Profile really is, is to open LibreOffice and then try Tools - Options - Paths but to help you find what sort of thing you are looking for this wiki helps http://wiki.documentfoundation.org/Documentation/UserProfile (hopefully helps anyway) as it gives the default location in the various operating systems Windows pre-Vista Windows Vista and beyond GnuLinux (except, of course, 1 of them has to be different from the rest) BSD (i think. BSDers tend to be left to their own devices and tend to get help from other BSDers in a separate forum and stuff) Of course the location had to change for 3.5.x as the standard changed for most operating systems in the interests of clarity (or something). So, the wiki-guide tries to make a fairly confusing set-up a lot less confusing but probably misses. Suggestions for the wiki-page are welcome (ish). Sorry for the typo in the previous message. I meant to say removing the profile did not improve things. I tried this by moving my old profile from .config/libreoffice/ and also by creating a new user on the system, in both cases the problem persisted. Miroslaw's idea of checking the environment variables did solve the problem of the disfunctional compose key, but made another problem reappear. Now I have a compose key, but also a GUI that is ugly and in some cases broken (parts of comboboxes become unreadable). Grx HdV -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Impress animation
Hi, Just started to work with impress (3.5.4.2). Perhaps i don't know to do things but in don't think so. I wanted to do this. Add image (of arrow) , duplicate page. Move the image to new position (in page 2). After that i wanted to go back to page1 and set properties of that image so that i moves to the position that it is in page 2. So when i click, i get an animation and. movement Next page displays. I tried to make custom paths, but it was hell to get it exactly. So you dont get a smooth animation to new position. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Compose key is being ignored
On 2012-07-16 17:23, Tom Davies wrote: Hi :) Ahh, so i guess that is something to do with desktop integration? Possibly. I think so. I think one of these 2 wiki's might help with that http://wiki.documentfoundation.org/Installing_in_parallel http://wiki.documentfoundation.org/Installing_LibreOffice_on_Linux They aren't really designed for this purpose but they might contain useful pointers. At last! Wiki-pages that weren't edited by me at all! They probably make a lot more sense but don't count on it. Thanks. I've read them, but I haven't found anything there that solved this problem. Grx HdV -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Compose key is being ignored
On 16/07/2012 at 16:40, J.A. de Vries hdv.ja...@gmail.com wrote: I tried changing my SAL_USE_VCLPLUGIN value from gen (generic X11) to kde and gtk and voila the compose key has magically reappeared. Great! Glad I could help :) . However, now I am faced with another problem. This made me remember why I choose gen in the first place. If I use either kde or gtk some widgets (notably comboboxes and menu spearators) in the UI become very coarse and ugly (which I could live with if necessary) and in some cases even unusable (which is more problematic). Could you post example screenshot (please note that this mailing list does not allow attachments, so you must use some web page or FTP)? Also, what Qt/KDE theme do you use? What color scheme? As far as I know, LO really doesn't like dark color schemes. Do you have similar issues on LO from repository (BTW, the are co-installable, at least on Debian)? -- Best regards Mirosław Zalewski -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Unexpected behavior while writing Calc Functions
On 7/16/2012 6:20 AM, Johnny Rosenberg wrote: SNIP Nobody is never wrong. Not even me… :P Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ snip Cute. Joe Conner, Poulsbo, WA USA -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Unexpected behavior while writing Calc Functions
Hi Tom, Tom Davies schrieb: Hi :) I am pretty sure that Date is an Sql data-type, just like double or text but perhaps it got tweaked-off somewhere in the embedded HsqlDb? This is not about HSQL but about Basic. Andrew is almost never wrong and Regina is never wrong so i'm at a loss about this atm. There are lot of areas, where I likely wrong. And in Basic I'm sure no expert. I have looked a little bit into the code. It seems, that a Basic type 'date' is the same as com::sun::star::bridge::oleautomation struct Date. But I do not find, where the conversion to string happens. Kind regards Regina -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Unexpected behavior while writing Calc Functions
On 07/16/2012 02:58 PM, Regina Henschel wrote: Hi Tom, Tom Davies schrieb: Hi :) I am pretty sure that Date is an Sql data-type, just like double or text but perhaps it got tweaked-off somewhere in the embedded HsqlDb? This is not about HSQL but about Basic. Andrew is almost never wrong and Regina is never wrong so i'm at a loss about this atm. There are lot of areas, where I likely wrong. And in Basic I'm sure no expert. I have looked a little bit into the code. It seems, that a Basic type 'date' is the same as com::sun::star::bridge::oleautomation struct Date. But I do not find, where the conversion to string happens. Kind regards Regina I know that I can use a SQL Date type, but the regular Date type behaves like a double in every case that I have tested Note that I cannot say that I have tested some of the odd cases such as setting the date a day or two before some big jump based on date changes in history. I have special routines to convert between the SQL struct. I just did not expect a Basic Intrinsic Date to convert to a string. I expected it would auto-convert to Double on return. If the Basic internals is using a struct rather than a Double as I thought, then it makes much more sense that it would convert to a string. I think that I need to document the behavior. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
