Re: [libreoffice-users] LO Base: MySQL or Mariadb ?

2014-02-10 Thread Jay Lozier
Hi, MariaDB is compatible with MySQL, the MySQL connectors, and MySQL API and is designed to be a drop-in replacement for MySQL. I have connected to MariaDB using the LO provided MySQL connector on earlier versions of LO. I have not done so with 4.1.X yet. Jay On 02/09/2014 03:16 PM, Tom

[libreoffice-users] Calc/Writer - Default for Font Colour button now a brown colour - bug or feature?

2014-02-10 Thread M Gillespie
Problem occured in both Calc and Writer in both version 4.0.4.2 and 4.1.4.2. On program start-up the Font Colour button on the toolbar is set to a muddy brown colour. In the past is has been set to Automatic on program start up (which works much better for me) From 4.0.1.2: I have the same

Re: [libreoffice-users] LO Base: MySQL or Mariadb ?

2014-02-10 Thread Andrew Douglas Pitonyak
I have seen nothing that indicates that you cannot use Maria DB as a drop-in replacement for MySQL at this point. Last I tried it was with Drupal 7. It just worked. I expect the same for Base, if it is not so, file a bug report against Maria DB. -- Andrew Pitonyak My Macro Document:

Re: [libreoffice-users] Fit Text to Contour

2014-02-10 Thread Cliff Scott
** Reply to message from Jean-Francois Nifenecker jean-francois.nifenec...@laposte.net on Sun, 09 Feb 2014 20:36:54 +0100 Better late than never... Le 24/01/2014 04:39, Cliff Scott a écrit : I'm trying to use Draw to make up some text to put around pictures in Writer. The help

[libreoffice-users] Python2 and Uno on Ubuntu 13.10

2014-02-10 Thread Luc Saffre
Hello, in November 2013, there was a thread about this: http://listarchives.libreoffice.org/global/users/msg35255.html Did somebody solve that problem meanwhile? Upgrading to Python 3 is not an option for me at the moment. Luc -- To unsubscribe e-mail to:

Re: [libreoffice-users] Fit Text to Contour

2014-02-10 Thread Jean-Francois Nifenecker
Le 10/02/2014 16:59, Cliff Scott a écrit : One question remains: Is there a way to put the text on a free form line or only on the shapes the Fontwork Button dialog box has? Yes, of course. Just draw a line by hand and associate (enter) the text you want. While it is selected, call the

Re: [libreoffice-users] Export PDF

2014-02-10 Thread Cliff Scott
** Reply to message from Marcello Romani mrom...@ottotecnica.com on Mon, 10 Feb 2014 08:28:09 +0100 Il 08/02/2014 23:40, Cliff Scott ha scritto: I've run into a strange occurrence in LO 4.1.4. Everytime I export to PDF I get a error message that PDF/A-1a forbids a transparency. Clicking OK

[libreoffice-users] Part of File is Missing

2014-02-10 Thread Carole Edwards Caruso
I had a 26 page file of 61 KB. I saved the file. When I went to open it again, the first page was blank, the second page was there, and the third page was a blank. Nothing more was there. My computer shows that the file is still there and is 61KB. Is the file hiding somewhere? Is there

Re: [libreoffice-users] Property or method not found: DocumentInfo

2014-02-10 Thread anne-ology
I'm assuming the document is saved on this machine; if so, then there must be a kink somewhere ;-( But if not, then be sure that the program knows where to seek the document. The more I hear of these 'kinks in the system', the more determined I am not to up-date

Re: [libreoffice-users] Part of File is Missing

2014-02-10 Thread anne-ology
It may be hiding in the cache ... it may have found its way to another folder ... ... ... [who knows ;-) ] Unless you know how to seek without losing any of these 'bits bytes', I would take the machine to your trusted computer guy [hopefully you know one]

Re: [libreoffice-users] Part of File is Missing

2014-02-10 Thread M Gillespie
I may be out of my depth here but in Windows 7 if you right click the file name it shows an option Restore Previous Versions i've never used it but that looks promising to me good luck From: anne-ology Sent: Monday, February 10, 2014 6:47 PM To: users@global.libreoffice.org Subject: Re:

Re: [libreoffice-users] Export PDF

2014-02-10 Thread Kracked_P_P---webmaster
Two other ways 1 - Try FileExport choose PDF for the format Then work with the options to see what works for you. 2- Use an external PDF printer doPDF for Windows [free] CUPS-PDF for Linux. Those PDF printers have some good things and bad things. CUPS-PDF will only print as Portrait so

Re: [libreoffice-users] Python2 and Uno on Ubuntu 13.10

2014-02-10 Thread Jay Lozier
On 02/10/2014 11:01 AM, Luc Saffre wrote: Hello, in November 2013, there was a thread about this: http://listarchives.libreoffice.org/global/users/msg35255.html Did somebody solve that problem meanwhile? Upgrading to Python 3 is not an option for me at the moment. Luc Luc Reviewing the

Re: [libreoffice-users] Part of File is Missing

2014-02-10 Thread Kracked_P_P---webmaster
You could always turn on the back up option. Tools Options Load/Save General Always create a backup copy Then make the Save AutoRecovery information every to be 1 or 2 minutes. Then there is the Automatically save the document too option [yes it states too] On 02/10/2014 02:31 PM, M

[libreoffice-users] Calc: help with VLOOKUP

2014-02-10 Thread Pikov Andropov
Something is not working for me. Hope someone can help. I have a two-sheeted speadsheet. Sheet 1 has three columns as follows: A. Name B. Price (ignorable as far as this example is concerned) C. ID number Sheet 2 has three columns as follows: A. Item Code

Re: [libreoffice-users] Property or method not found: DocumentInfo

2014-02-10 Thread Cor Nouws
Hi Ken, Ken Heard wrote (10-02-14 10:37) I cannot assign a template to a document. Whenever I try, the message which forms the title of this post appears. This sounds as if you do something with Basic? If so, in 4.0 there has been a change in the API. See the release notes.

Re: [libreoffice-users] LO Base: MySQL or Mariadb ?

2014-02-10 Thread Anthony Baldwin
On 2/10/2014 9:20 AM, Andrew Douglas Pitonyak wrote: I have seen nothing that indicates that you cannot use Maria DB as a drop-in replacement for MySQL at this point. Last I tried it was with Drupal 7. It just worked. I expect the same for Base, if it is not so, file a bug report against Maria

Re: [libreoffice-users] Calc: help with VLOOKUP

2014-02-10 Thread Dave Liesse
The first problem I see is that your lookup value -- in this case the ID number -- has to be the first column in the lookup array. Using your specific example, the VLOOKUP function would be used in column E of Sheet 2. If you were wanting to also copy the price from Sheet 1 (which you've

Re: [libreoffice-users] Part of File is Missing

2014-02-10 Thread anne-ology
Beware - by using 'restore', you could lose anything which was placed on the machine after that restore date ;-( From: M Gillespie mary.gilles...@yahoo.co.uk Date: Mon, Feb 10, 2014 at 1:31 PM Subject: Re: [libreoffice-users] Part of File is Missing To: anne-ology

Re: [libreoffice-users] Calc: help with VLOOKUP

2014-02-10 Thread Pikov Andropov
Dave Liesse has written on 2/10/2014 4:00 PM: The first problem I see is that your lookup value -- in this case the ID number -- has to be the first column in the lookup array. Interesting. I don't think I've ever seen that stated. Using your specific example, the VLOOKUP function would be

Re: [libreoffice-users] Fit Text to Contour

2014-02-10 Thread Cliff Scott
** Reply to message from Jean-Francois Nifenecker jean-francois.nifenec...@laposte.net on Mon, 10 Feb 2014 18:20:10 +0100 Le 10/02/2014 16:59, Cliff Scott a écrit : One question remains: Is there a way to put the text on a free form line or only on the shapes the Fontwork Button dialog

Re: [libreoffice-users] Re: Writer printing problem

2014-02-10 Thread rost52
driver? printer? This is what I am using: http://www.pdf995.com Use this SW already since many years. Thanks for the doPDF hint. On 2014-02-06 23:14, Kracked_P_P---webmaster wrote: PDF955?PDF printer/driver? I use doPDF for windows [default printer] and CUPS-PDF for Ubuntu [default

Re: [libreoffice-users] Re: Writer printing problem

2014-02-10 Thread rost52
Hi Joe, OS and LibO version is the same. Are there somewhere settings which can have an influence? HW differences? If you have an idea where to look, please advice I will do so and report. ROSt On 2014-02-08 21:25, Joe Alders wrote: Joe Alders capricorn.alders at hetnet.nl writes: There was

Re: [libreoffice-users] Python2 and Uno on Ubuntu 13.10

2014-02-10 Thread Luc Saffre
On 10/02/14 21:38, Jay Lozier wrote: Reviewing the archive, I did not see if it was solved. I believe Ubuntu primarily uses Python 2.7.5 not Python 3.3.4 for their system. The easiest way to check is to enter python in terminal and see which version is reported. Python3 is available in the

Re: [libreoffice-users] Calc: help with VLOOKUP

2014-02-10 Thread Carl Paulsen
OK, the item that you want to look up to return the price or name needs to be in both spreadsheets (otherwise you won't find a match!). IF (big IF here) the ID# and item code are the same for each item, then this could be done as follows: Database looks like this: Sheet 1: ID Name

Re: [libreoffice-users] Part of File is Missing

2014-02-10 Thread Kracked_P_P---webmaster
That is why having a backup copy option and a auto save for recovery is needed. I think every time you open or save the document, you might get a backup copy [or maybe not]. You will have to check the documentation to know for sure. I have had a few system crashes, yes for both Windows and

Re: [libreoffice-users] Calc: help with VLOOKUP

2014-02-10 Thread Carl Paulsen
Hmmm. Formatting leaves a little to be desired. Let's see: 1st sheet: Database looks like this: Sheet 1: ID Name Price ID 1Shirt 6 1 2Pants 5 2 3Hat3 3 4

Re: [libreoffice-users] Part of File is Missing

2014-02-10 Thread Tom Davies
Hi :) I think he is talking about some document-specific thing introduced in Win7. I've not explored it yet. (Had no idea it existed tbh) The Windows-wide restore should only affect programs but should leave files and data untouched. of course what should be and what is are often different

Re: [libreoffice-users] Part of File is Missing

2014-02-10 Thread Tom Davies
Hi :) I've no idea why it happened. I don't think anyone else has reported anything similar yet. Generally it's worth keeping back-ups whatever program you are using. I tend to add a version number to the end of files and occasionally increase that number so that i can always go back to an

Re: [libreoffice-users] Part of File is Missing

2014-02-10 Thread Tom Davies
Hi :) Which format was the file saved in? Do you know if it's .docX, .doc or .Odt? Can you upload the file to Nabble? (errr, is it confidential such as containing people's names and addresses (in which case DONT post it!)) http://www.libreoffice.org/get-help/nabble-mailing-list-interface/ Find

Re: [libreoffice-users] Python2 and Uno on Ubuntu 13.10

2014-02-10 Thread Jay Lozier
On 02/10/2014 09:52 PM, Luc Saffre wrote: On 10/02/14 21:38, Jay Lozier wrote: Reviewing the archive, I did not see if it was solved. I believe Ubuntu primarily uses Python 2.7.5 not Python 3.3.4 for their system. The easiest way to check is to enter python in terminal and see which version is

Re: [libreoffice-users] Fit Text to Contour

2014-02-10 Thread Jean-Francois Nifenecker
Hello Cliff, Le 11/02/2014 03:29, Cliff Scott a écrit : Tried that and somehow I'm missing something important. I draw a line using the Freeform Line tool from the Draw toolbar. I then use the text tool from the Draw toolbar to enter text. Nope. You select the line and hit F2, so that the

[libreoffice-users] Re: Export PDF

2014-02-10 Thread r_ouellette
I create pdf files since 1997 and I tried almost every possible way to do so (Linux or Windows softwares). LO does one of the best job! If you want really small and efficient pdf, do the following : Menu Tools Options Fonts and add these 3 substitutions (even if you don't have these fonts

Re: [libreoffice-users] Part of File is Missing

2014-02-10 Thread M Gillespie
Hi everyone FYI Details of recovery of a previous version of a single file from Restore Points or Windows Backup in Windows 7: http://windows.microsoft.com/en-gb/windows/previous-versions-files-faq#1TC=windows-7 I realise this may not solve your problem - I'm hoping others can help recover