Re: [libreoffice-users] Sorting a MySQL Database

2013-08-29 Thread Ian Whitfield
Hi Noel On 29/08/13 06:12, Marion & Noel Lodge wrote: Hi Ian, With a Form, I have found the following is the way to lock in the Form's sort order - 1. Open the Form in Edit mode 2. Right click on the form and from the dropdown choose Form... 3. Click on the Data Tab 4. The contents field s

Re: [libreoffice-users] Sorting a MySQL Database

2013-08-29 Thread Ian Whitfield
Hi Noel On 29/08/13 06:12, Marion & Noel Lodge wrote: Hi Ian, With a Form, I have found the following is the way to lock in the Form's sort order - 1. Open the Form in Edit mode 2. Right click on the form and from the dropdown choose Form... 3. Click on the Data Tab 4. The contents field s

Re: [libreoffice-users] Re: LIBREOFFICE - Version: 4.1.0.4 Build ID: 410m0(Build:4) / ALL S.o. / - BUG FUNCTION GETPIVOTDATA

2013-08-29 Thread Michele contabilmenteAG
Dear Marlosv thanks for the reply. Enclosed is sending the file from these problems. I look forward to technical comments from the thing. (I have not yet thrown from my building, but customers may feel happy to push me from the brink, if he does not finish the job :-) ) ---

Re: [libreoffice-users] Sorting a MySQL Database

2013-08-29 Thread Marion & Noel Lodge
Hi Ian, There is another way - 1. After opening your Form in design mode, click on View | Toolbars | and make sure Form Design is ticked 2. On that toolbar, click on Form Navigator (5th from left on my toolbar - it's the one with the 4 point star on it) 3. Right click on your Form name (probab

[libreoffice-users] Re: LIBREOFFICE - Version: 4.1.0.4 Build ID: 410m0(Build:4) / ALL S.o. / - BUG FUNCTION GETPIVOTDATA

2013-08-29 Thread carlo.strata
Ciao Michele, your attachment has not reached us. To attach a file you can: - register to nabble http://nabble.documentfoundation.org and then going to the right post (mailing list -> thread -> post; you could find the link in this post's footer); in Nabble's editor there is a "More" button by cl

[libreoffice-users] Re: problem with formala inserted by macros when decimal separator is comma

2013-08-29 Thread Mindaugas
In 4.0 the properties Formula and FormulaLocal give the expected result: cell.Formula = "=2.1*2"=> 4,2 cell.Formula = "=2,1*2"=> #NAME? cell.FormulaLocal = "=2,1*2" => 4,2 cell.FormulaLocal = "=2.1*2" => #NAME? In 4.1 the both properties Formula and FormulaLocal give the same re

Re: migrating to new systems, was: Fw: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats?

2013-08-29 Thread anne-ology
the birds do it ... the fish do it ... now, the computerists migrate ;-) Does anyone really wish to remain with MSFT?; it's just already programmed into these glorified-typewriter machines ... scary prospect to remove it then install something else -and all alone, nary a

Re: [libreoffice-users] Download page is inaccesible for me

2013-08-29 Thread Tom Davies
Hi :) Indeed most of your links don't work.  I think the first one did but i wasn't sure.  Did you try starting at the main home-page for LibreOffice and navigate from there (or from the downloads page) or where you modifying links that you had used in the past? http://www.libreoffice.org/down

Re: migrating to new systems, was: Fw: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats?

2013-08-29 Thread Tom Davies
Hi :)  Yes, there are a lot of Kings Arms too, i'd kinda forgotten.  In Brighton there was one called the "Queens Head" with it's sign being a painting of Freddy Mercury.  Usually the signs are fairly predictable.  I saw a Queens Legs once but can't remember where.  Actually wrt to removing W

[libreoffice-users] Re: LIBREOFFICE - Version: 4.1.0.4 Build ID: 410m0(Build:4) / ALL S.o. / - BUG FUNCTION GETPIVOTDATA

2013-08-29 Thread Tom
Hi :) Yes, as Carlo says. You can also follow the Nabble links in Carlo's or my message to get to the exactly tight thread. Of course security experts say we shouldn't just click on any links in any emails or on unknown websites and should really navigate a safe known path instead. Regards fr

Re: [libreoffice-users] bibliography after endnotes

2013-08-29 Thread Info/UX
Thank you very much for this. I am using LO 4.0.2.2, which is the latest build available for Kubuntu 12.04 LTS. I wonder why you do not experience the bug I do. I did upgrade from 3.5 (I think) to my current version and found the same bug. Maybe I should try the .deb from the LibreOffice websi

Re: migrating to new systems, was: Fw: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats?

2013-08-29 Thread Tom Davies
Hi :) Just found this "  South Tyrol has announced to migrate 7000 PCs in the public administration to LibreOffice - http://www.provinz.bz.it/lpa/285.asp?redas=yes&aktuelles_action=4&aktuelles_article_id=428953 (announcement in german) " from the marketing list, the post from Christian Lohmaier in

Re: [libreoffice-users] bibliography after endnotes

2013-08-29 Thread Tom Davies
Hi :)  Zotero seems to make the whole thing a lot more flexible and easier to get working the more sensible ways.  If you look through the mailing lists archives then you see pretty much all questions about end-notes are magically resolved when the person started using Zotero.  Even though i

Re: [libreoffice-users] editing Sharepoint documents

2013-08-29 Thread Tom Davies
Hi :) There is a video about using an alternative to Sharepoint but i think it is meant to be generic enough that it gives the rough idea for Sharepoint too. http://www.libreoffice.org/home/Discover I was lucky enough to meet the lady whose voice was used in the video but sadly she was too shy t

Re: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats?

2013-08-29 Thread Tom Davies
Hi :) Yes, or spend it shouting at the stupid potholes that i hadn't noticed and that had given me a flat (or whatever problem i ran into).  At least with a push-bike it's reasonably easy to suddenly go off road and push the bike and generally make the most of it Regards from Tom :)  _

Re: [libreoffice-users] .ORD files

2013-08-29 Thread Tom Davies
Hi :) I did a google search about it and found a few proprietary tools that might work or might be dodgy.  I hate all that freeware/shareware or low cost dodgy looking proprietary looking stuff.  There is just no way of knowing what it's doing and there is a reputation that they do nasty stuff q

Re: [libreoffice-users] Sorting a MySQL Database

2013-08-29 Thread Girvin Herr
On 08/29/2013 12:30 AM, Ian Whitfield wrote: Hi Noel On 29/08/13 06:12, Marion & Noel Lodge wrote: Hi Ian, With a Form, I have found the following is the way to lock in the Form's sort order - 1. Open the Form in Edit mode 2. Right click on the form and from the dropdown choose Form... 3.

Re: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats?

2013-08-29 Thread Tom Davies
Hi :)  That helped me find it on Ubuntu 12.04 and gave the package name ttf-mscorefonts-installer so it'd be sudo apt-get install ttf-mscorefonts-installer on a debian (and probably quite a few others) command-line.  For Redhat just swap out apt-get with yum?  Regards from Tom :)  ___

[libreoffice-users] Translating questions and answers

2013-08-29 Thread Tom Davies
Hi :)  Ideally i like to forwards the question to the international translators list fairly quickly.  For the parts that appear on this list i try to use Quick translate (or other machine translator tool) but keep it close to the original in whatever language that was in.  Not everyone has

[libreoffice-users] Mobile devices?

2013-08-29 Thread Tom Davies
Hi :) I just had a glimpse of an Android and it looks like it's got a mini-Usb socket in the top.  If that could break-out to a powered usb-hub then surely you could get keyboard, mice, maybe even screens working off the Android?  So 1 docking station at work and 1 at home might be enough to

Re: [libreoffice-users] Mobile devices?

2013-08-29 Thread Paul
Sounds like the Ubuntu Edge: http://www.indiegogo.com/projects/ubuntu-edge On Thu, 29 Aug 2013 20:23:49 +0100 (BST) Tom Davies wrote: > Hi :) > I just had a glimpse of an Android and it looks like it's got a > mini-Usb socket in the top.  If that could break-out to a powered > usb-hub then su

Re: [libreoffice-users] Re: LIBREOFFICE - Version: 4.1.0.4 Build ID: 410m0(Build:4) / ALL S.o. / - BUG FUNCTION GETPIVOTDATA

2013-08-29 Thread MiguelAngel
El 29/08/13 10:38, Michele contabilmenteAG escribió: Dear Marlosv thanks for the reply. Enclosed is sending the file from these problems. I look forward to technical comments from the thing. (I have not yet thrown from my building, but customers may feel happy to push me from the brink, if he

Re: [libreoffice-users] .ORD files

2013-08-29 Thread Tim Lloyd
Thanks for following up Tom. The guy who posted this question over on LQ seems to have left the building so he either has a solution or he has given up. Anyway, we will know for next time! Cheers On 08/30/2013 03:38 AM, Tom Davies wrote: Hi :) I did a google search about it and found a few

Fwd: [libreoffice-users] Re: LIBREOFFICE - Version: 4.1.0.4 Build ID: 410m0(Build:4) / ALL S.o. / - BUG FUNCTION GETPIVOTDATA

2013-08-29 Thread Michele contabilmenteAG
-- Forwarded message -- From: Michele contabilmenteAG Date: 2013/8/29 Subject: Re: [libreoffice-users] Re: LIBREOFFICE - Version: 4.1.0.4 Build ID: 410m0(Build:4) / ALL S.o. / - BUG FUNCTION GETPIVOTDATA To: MiguelAngel Hola Miguel Angel, 1) true: it's a bug and I know, it is s

Re: [libreoffice-users] Mobile devices?

2013-08-29 Thread James Knott
Tom Davies wrote: > I just had a glimpse of an Android and it looks like it's got a > mini-Usb socket in the top. If that could break-out to a powered > usb-hub then surely you could get keyboard, mice, maybe even screens working > off the Android? > > > So 1 docking station at work and 1 at

Re: [libreoffice-users] Re: problem with formala inserted by macros when decimal separator is comma

2013-08-29 Thread Andrew Douglas Pitonyak
Thank you very much, This is exactly what I wanted to know. I was not able to run that test myself. On 08/29/2013 06:21 AM, Mindaugas wrote: In 4.0 the properties Formula and FormulaLocal give the expected result: cell.Formula = "=2.1*2"=> 4,2 cell.Formula = "=2,1*2"=> #NAME? cell

Re: [libreoffice-users] Re: problem with formala inserted by macros when decimal separator is comma

2013-08-29 Thread Andrew Douglas Pitonyak
seems that you are not the first to see this bug. Consider adding yourself to the CC list. I dropped an email to the dev list to see if I can figure out who introduced the bug. https://bugs.freedesktop.org/show_bug.cgi?id=67836 On 08/29/2013 10:30 PM, Andrew Douglas Pitonyak wrote: Thank yo

Re: [libreoffice-users] Mobile devices?

2013-08-29 Thread Daniel Espinosa
Motorola's phones have docks to connect any keyword and mouse, even an HDMI television. When docked you have a Desktop very similar to GNOME. First Atrix had a dock shipped with the devise and can use LAPTOP like dock. New models require to buy docks separately. With this kind if devices and a Lib

[libreoffice-users] Database error

2013-08-29 Thread Andreas Kloss
Hello all, I use Mac and have Libreoffice 4 download 2 day a go from your Server. Then I like to use the Database I get this error : SQL Status: 42000 Error code: 105 [Actual][SQL Server] Unclosed quotation mark after the character string 's'. -- To unsubscribe e-mail to: users+unsubscr.