[libreoffice-users] Re: Base/SQL help

2012-01-04 Thread Tom
Hi :) If the database is small enough to upload then uploading it to Nabble might be the easiest. Just click the link to Nabble. Perhaps a copy of the database with no data in it might help Dan? Note to the two odd posts prior to Dan's: if people express dissatisfaction with a 3rd party

[libreoffice-users] Re: Base/SQL help

2012-01-04 Thread Alexander Thurgood
Le 03/01/12 16:58, Jeff Sadowski a écrit : Hi Jeff, I'm using the odbc connector for mysql. This has always had its own particular problems, dependent on the version you are using. I found it impossible working with tables that don't have primary keys in base. You can't create an entry

Re: [libreoffice-users] Error in calc file

2012-01-04 Thread Regina Henschel
Hi Theo, Theo schrieb: On 04/01/12 15:58, Jay Lozier wrote: Theo, On 01/03/2012 08:58 PM, Theo wrote: I have an error in a spreadsheet on opening. Any help would be very much appreciated. Read-Error Format error discovered in the file in sub-document content.xml at 2,734592(row,col).

Re: [libreoffice-users] Error in calc file

2012-01-04 Thread Tom Davies
Hi :) You can usually open xml documents in text-editors such as Notepad, Gedit, Kate or whatever.  Notepad doesn't colour-code it but most other ones do after you have changed the view from plain text to something such as html, css or xml or something like that.  SciTe is quite good in

Re: [libreoffice-users] Restore windows bug

2012-01-04 Thread Amy Mandaean
THANK YOU, ALL!! It is solved, and productivity is mine once again. :) The Lion OS does hide the Library folder, but Dominik's shift-cmd-G trick was magic. The thread Jay posted was exactly my problem, and I found the offending filename there: org.libreoffice.script.savedState which was in

Re: [libreoffice-users] Restore windows bug

2012-01-04 Thread Dominik Wnęk
W dniu 04.01.2012 14:50, Amy Mandaean pisze: THANK YOU, ALL!! It is solved, and productivity is mine once again. :) The Lion OS does hide the Library folder, but Dominik's shift-cmd-G trick was magic. The thread Jay posted was exactly my problem, and I found the offending filename there:

[libreoffice-users] Re: Restore windows bug

2012-01-04 Thread Ken Springer
On 1/4/12 6:50 AM, Amy Mandaean wrote: Thank you, Ken for the screen shots and walking me through my Finder preferences--suddenly I have so much more control over this incredible machine. You all are right--Mac is amazing. Never going back! :) You're welcome, Amy. Tom Davies comment

Re: [libreoffice-users] Restore windows bug

2012-01-04 Thread Tom Davies
Hi :) You are welcome!  It's good to hear you are enjoying using Macs already.  Sadly most of us are forced into going back to Windows, for example - at work or some cyber-cafes.  I think a lot of us have mostly escaped to GnuLinux which is another unix-based system (Mac is unix-based too)

[libreoffice-users] Re: Restore windows bug

2012-01-04 Thread Ken Springer
On 1/4/12 7:02 AM, Tom Davies wrote: It is difficult to avoid telling people that they would probably suffer less problems and be happier on Macs (or GnuLinux) but telling them back-fires somewhat and they seem to think that you think of yourself as superior. It's probably better to just

[libreoffice-users] Paper size and Lion (Mac)

2012-01-04 Thread Robert Peirce
On most Mac apps, selecting print allows you to select a paper size on the main print panel. In LibreOffice, as far as I have been able to determine, you have to drill down into Paper Handling and then the only way to change size is to select scale to fit. This results inm a ridiculously

Re: [libreoffice-users] Error in calc file

2012-01-04 Thread Regina Henschel
Hi Tom, Tom Davies schrieb: Hi :) You can usually open xml documents in text-editors such as Notepad, Gedit, Kate or whatever. Notepad doesn't colour-code it but most other ones do after you have changed the view from plain text to something such as html, css or xml or something like that.

Re: [libreoffice-users] Error in calc file

2012-01-04 Thread Dan Lewis
On Wed, 2012-01-04 at 17:13 +0100, Regina Henschel wrote: Hi Tom, Tom Davies schrieb: Hi :) You can usually open xml documents in text-editors such as Notepad, Gedit, Kate or whatever. Notepad doesn't colour-code it but most other ones do after you have changed the view from plain text

[libreoffice-users] Printing problems with a table and grpahics

2012-01-04 Thread Ken Springer
I'm creating a small sign simply for posting on local bulletin boards at convenience stores, grocery stores, etc. I've created screenshots and posted them here: http://db.tt/ekrMxDCg Document.png is a screenshot of the sign. The blueish-green boxes will not be part of the sign. I'm hiding

Re: [libreoffice-users] Base/SQL help

2012-01-04 Thread Jeff Sadowski
    This is all confusing to me. How many tables are in this database and what are they? What are the fields and to what table to they belong? What are the field types of each one of the fields? What do you mean by ip and serial are character arrays? Character arrays are not one of the field

[libreoffice-users] Re: Printing problems with a table and grpahics

2012-01-04 Thread Ken Springer
On 1/4/12 10:23 AM, Ken Springer wrote: I'm creating a small sign simply for posting on local bulletin boards at convenience stores, grocery stores, etc. I've created screenshots and posted them here: http://db.tt/ekrMxDCg Document.png is a screenshot of the sign. The blueish-green boxes

[libreoffice-users] Fedora 14 install

2012-01-04 Thread Kerry Miller
Hello People, I just tried to install LibreOffice on my Fedora 14 x86_64 system and had these results in my terminal window: [root@HAM RPMS]# yum install *.rpm Loaded plugins: presto, refresh-packagekit Setting up Install Process Examining libobasis3.3-base-3.3.4-401.x86_64.rpm:

[libreoffice-users] Printer driver, page size and 3.4.4 in Lion

2012-01-04 Thread Robert Peirce
I have a 4x6 card I need to print. In other apps I just select 4x6. In LibreOffice I need to go into Paper Handling, click scale to fit paper size before I can select the 4x6 size. When I do that, the print size is reduced to the point of being almost unreadable. I want to select 4x6

Re: [libreoffice-users] Error in calc file

2012-01-04 Thread Theo
Many thanks for the help. This file contains aspects of our business records for the past 6 years. We had a regular 2 hourly backup scheduled which unhappily has meant our backup data was overwritten with the corrupted file before we knew we had a problem. So we really appreciate the help. Our

Re: [libreoffice-users] Fedora 14 install

2012-01-04 Thread Jay Lozier
On 01/04/2012 10:26 AM, Kerry Miller wrote: Hello People, I just tried to install LibreOffice on my Fedora 14 x86_64 system and had these results in my terminal window: [root@HAM RPMS]# yum install *.rpm Loaded plugins: presto, refresh-packagekit Setting up Install Process Examining

Re: [libreoffice-users] Base/SQL help

2012-01-04 Thread Dan Lewis
On Wed, 2012-01-04 at 10:39 -0700, Jeff Sadowski wrote: This is all confusing to me. How many tables are in this database and what are they? What are the fields and to what table to they belong? What are the field types of each one of the fields? What do you mean by ip and serial are

Re: [libreoffice-users] Error in calc file

2012-01-04 Thread Jay Lozier
On 01/04/2012 03:00 PM, Theo wrote: Many thanks for the help. This file contains aspects of our business records for the past 6 years. We had a regular 2 hourly backup scheduled which unhappily has meant our backup data was overwritten with the corrupted file before we knew we had a problem.

Re: [libreoffice-users] Printer driver, page size and 3.4.4 in Lion

2012-01-04 Thread webmaster for Kracked Press Productions
Have you tried to set the page size to 4x6? FormatPage instead of letter size in the drop box, go to User then set the size to 4 x 6 inches and the margins to the smallest your printer will allow. I did this and created a 4x6 page and went to Print and selected my laser printer it showed the

Re: [libreoffice-users] Error in calc file

2012-01-04 Thread Regina Henschel
Hi Jay, Jay Lozier schrieb: [..] It could be the html code in the line or IMHO a line just prior. My guess is that a tag is not properly closed or the wrong tag format is being used. XML is fussier than html about using the correct tag formats and the like. For example br is acceptable html but

Re: [libreoffice-users] Error in calc file

2012-01-04 Thread Theo
The line in Firefox is just about at the top of the file. The only line before it is: ?xml version=1.0 encoding=UTF-8? Thanks, Theo On 05/01/12 09:31, Jay Lozier wrote: On 01/04/2012 03:00 PM, Theo wrote: Many thanks for the help. This file contains aspects of our business records for the

Re: [libreoffice-users] Printer driver, page size and 3.4.4 in Lion

2012-01-04 Thread Jay Lozier
Robert On 01/03/2012 06:52 PM, Robert Peirce wrote: I have a 4x6 card I need to print. In other apps I just select 4x6. In LibreOffice I need to go into Paper Handling, click scale to fit paper size before I can select the 4x6 size. When I do that, the print size is reduced to the point of

[libreoffice-users] Crashes with e-mail merge

2012-01-04 Thread Ferry Toth
Problem description: When running mail merge with a document header that contains an image, libre office crashes without sending the mail. Steps to reproduce: Tools Mail merge Wizard Fill in all the data to get simplest type of email merge (i.e. Hello field somemessage, Bye) without any

Re: [libreoffice-users] Error in calc file

2012-01-04 Thread Theo
Regina and Jay, you guys are great!!! Regina, it was a duplicated line of text. All fixed thank you. Time to re-evaluate our back up strategy. Again, many thanks, Theo On 05/01/12 09:51, Regina Henschel wrote: Hi Jay, Jay Lozier schrieb: [..] It could be the html code in the line or IMHO

Re: [libreoffice-users] Error in calc file

2012-01-04 Thread Tom Davies
Hi :) Ok, this is a long shot and going off on a tangent.  I think most of us are guessing that you have already run through all this many times in your mind.  If you turned on the back-ups feature then back-ups are stored in a sub-folder in the user-profile

Re: [libreoffice-users] Error in calc file

2012-01-04 Thread Tom Davies
Hi :) WooHooo, congrats!  A 1st step Tools - Options - +Load/Save - General Tick the relevant backup option.  Wikipedia pages might have good links that are not purely about selling a product.  Here is one http://en.wikipedia.org/wiki/Backup#Storage.2C_the_base_of_a_backup_system

[libreoffice-users] Re: Printer driver, page size and 3.4.4 in Lion

2012-01-04 Thread Robert Peirce
In article bob-825ce2.18521203012...@news.gmane.org, Robert Peirce b...@peirce-family.com wrote: I have a 4x6 card I need to print. In other apps I just select 4x6. In LibreOffice I need to go into Paper Handling, click scale to fit paper size before I can select the 4x6 size. When I do

Re: [libreoffice-users] linking a calc chart into a writer document

2012-01-04 Thread Cor Nouws
Hi David, David Edwards wrote (04-01-12 21:07) Firstly, congrats on Libreoffice - its pretty darn good and working very well for everything else I've tried doing with it. Glad to read that - thanks for sharing :-) I'm having weird problems trying to link a chart from calc spreadsheet into

Re: [libreoffice-users] Fedora 14 install

2012-01-04 Thread Tom Davies
Hi :) I think Fedora 14 is nearing the end of it's support cycle and probably needs upgrading to a newer release.  The 14 was the last version to have OpenOffice by default so upgrading to Fedora 15 will give you LibreOffice as a fully integrated package (whatever that means!)

Re: [libreoffice-users] Printer driver, page size and 3.4.4 in Lion

2012-01-04 Thread Tom Davies
Hi :) The scale to fit is likely to scale down (reduce in size) whatever you are trying to print in order to fit the paper-size.  It can be a useful feature but obviously not in this case! Perhaps Format - Page - Page (2nd tab) - Paper size Is a better option?  Don't worry.  We have all done

Re: [libreoffice-users] linking a calc chart into a writer document

2012-01-04 Thread David Edwards
Hi Cor, Thanks for the info. I've still not managed to work out how to do this! I had used OLE linking succesfully to insert other spreadsheets into writer and they work fine (but doesn't OLE obsolete DDE?). When I've selected the chart and paste special there is no DDE link option. Thus I've

Re: [libreoffice-users] linking a calc chart into a writer document

2012-01-04 Thread Cor Nouws
Hi David, David Edwards wrote (05-01-12 00:56) I've still not managed to work out how to do this! Hmm, again I got in trouble because of reading to fast/only half. When I've selected the chart and paste special there is no DDE link option. My suggestion helps for linking data - not for

Re: [libreoffice-users] linking a calc chart into a writer document

2012-01-04 Thread Tom Davies
Hi :) In Writer Insert - Object - Chart seems to do something and then right-click on the chart and have a look at data-range or something.  In the Draw guide there is a chapter about working with Objects and maybe that might help?

[libreoffice-users] Re: Printer driver, page size and 3.4.4 in Lion

2012-01-04 Thread Larry Gusaas
On 2012-01-03 5:52 PM Robert Peirce wrote: I have a 4x6 card I need to print. In other apps I just select 4x6. In LibreOffice I need to go into Paper Handling, click scale to fit paper size before I can select the 4x6 size. When I do that, the print size is reduced to the point of being

Re: [libreoffice-users] linking a calc chart into a writer document

2012-01-04 Thread MiguelAngel
El 05/01/12 1:12, Tom Davies escribió: Hi :) In Writer Insert - Object - Chart seems to do something and then right-click on the chart and have a look at data-range or something. In the Draw guide there is a chapter about working with Objects and maybe that might help?

Re: [libreoffice-users] Re: Printer driver, page size and 3.4.4 in Lion

2012-01-04 Thread Mieszko Kaczmarczyk
W dniu 2012-01-05 01:21, Larry Gusaas pisze: I used LibreOffice (or OpenOffice) before to print these cards but now it isn't working. LibreOffice (and OOo) have serious printing problems on Macs when using sizes other than the standard letter and legal sizes. A workaround: Go to