Re: [libreoffice-users] Writer

2012-01-27 Thread Cor Nouws
Hi Greg, Gregory Forster wrote (27-01-12 01:02) First, I highlight First Name in the box on the left. Then I click the between the two boxes to move the First Name to the box on the right. [...] That format gives me the proper address labeling for letters, labels, etc. However, when I exit

Re: [libreoffice-users] Base question - report exception on faultless query

2012-01-27 Thread Mark Stanton
Hi Dan, Thanks for your reply. Yes, it was a bit short on details, but I thought there were enough, obviously not. I had the query set for Do not analyze, which I thought would stop Base from inspecting the SQL, but apparently not. I'm using MySQL via the jDBC... Thingy. In fact the piece it

Re: [libreoffice-users] Re: Mysterious spacing problem

2012-01-27 Thread Séamas Ó Brógáin
Jay wrote: Is this a screen resolution or a printing problem. Could you specify which font(s) are troublesome? Also, I forgot - what OS are you using? GNU/Linux (Ubuntu 11.10). Various fonts, including Plantin, but mostly my own (work in progress). In all of them I have verified the

[libreoffice-users] Re: what is the alternative of countifs function in libreoffice?

2012-01-27 Thread Pedro
soumalya ray wrote now i am trying to include the row/column percentage into the data pilot result directly along with the absolute count.so far, no luck!! I guess you just bumped into the LO Pivot Table limitations (compared to MS Office) In MS Office you would just add again the same

[libreoffice-users] solution to hungarian crash on launch writer

2012-01-27 Thread Tim Hatton
This is my attempt to give something back I dont know how to get this solution into the offical bug reporting libreoffice system so could you please forward this solution to someone who does thanks Tim on XP SP3 HUNGARIAN CRASH ??? INSTALL JAVA 6 SIX is a must.. this is a reproducible

[libreoffice-users] Windows parallel install

2012-01-27 Thread Pedro
Hi all I'm trying to do a parallel install of LO 3.5.0RC2 under Windows XP Pro x86 After unpacking (using msiexec /a) to folder D:\LO350 I can't save the edits to file Bootstrap.ini. i get Error saving... Access is denied. I also had the same problem with RC1. The only solution i found is to

[libreoffice-users] Re: what is the alternative of countifs function in libreoffice?

2012-01-27 Thread Andreas Säger
Am 27.01.2012 11:23, Pedro wrote: I'm almost sure that you can't do that in the LibreOffice Pivot Tables (unless there are some undocumented features that I'm not aware of? ) You can select multiple functions for the same data field. The function selector is a multi-select list box. Indeed,

Re: [libreoffice-users] Base - No SDBC driver found!!

2012-01-27 Thread Ian Whitfield
On 26/01/2012 18:15, Fernand Vanrie wrote: make sure nobody is connected or has opened the odb or make a copy with a new name and open this copy then everiting must been editable Not working Fernand I've made a new copy of the file but permissions are still grayed out!! I tried

Re: [libreoffice-users] Base - No SDBC driver found!!

2012-01-27 Thread Tom Davies
Hi :) Would something like ps aux | grep name-of-backend show if somehow the database thinks it is doing a process?  Is it possible to see what the permissions of a file are set as?  I assume the back-end is created by the user that is using the back-end rather than created by

Re: [libreoffice-users] Windows parallel install

2012-01-27 Thread Tom Davies
Hi :) Does this guide help at all? http://wiki.documentfoundation.org/Installing_in_parallel#Windows I think it needs a bit of work for the Windows part so if there is anything you can add that would be great! Regards from Tom :) --- On Fri, 27/1/12, Pedro pedl...@gmail.com wrote: From: Pedro

Re: [libreoffice-users] Windows parallel install

2012-01-27 Thread Manfred J. Krause
Hi Pedro, On Fri, Jan 27, 2012 at 12:20 PM, Pedro wrote: Hi all I'm trying to do a parallel install of LO 3.5.0RC2 under Windows XP Pro x86 After unpacking (using msiexec /a) to folder D:\LO350 I can't save the edits to file Bootstrap.ini. i get Error saving... Access is denied. I also

Re: [libreoffice-users] solution to hungarian crash on launch writer

2012-01-27 Thread Tom Davies
Hi :) Do you know which version of Java 6?  Was it the 6u21 or a more recent version? I think you mean in Windows?  If so you can check what versions of java are installed on the machine through the machine's Control Panel but you could also see through LibreOffice menus Tools - Options -

Re: [libreoffice-users] Windows parallel install

2012-01-27 Thread Tom Davies
HI :) Errr, which version of java is LibreOffice trying to use?  Is it trying to use something newer than java 6u24? Regards from Tom :) --- On Fri, 27/1/12, Manfred J. Krause courrier.oou.fr@googlemail.com wrote: snip / When i tried to run the program it is excruciatingly slow...

[libreoffice-users] Re: Windows parallel install

2012-01-27 Thread Pedro
Hi Tom ;) Does this guide help at all? http://wiki.documentfoundation.org/Installing_in_parallel#Windows I think it needs a bit of work for the Windows part so if there is anything you can add that would be great! TBH No :) I have already fixed some of it (the instructions for Windows had

[libreoffice-users] Re: Windows parallel install

2012-01-27 Thread Pedro
Hi Manfred Manfred J. Krause wrote Maybe → http://support.microsoft.com/kb/324852/en-us Excellent suggestion! My bad for not looking it up before posting. That error message sure does provide a tip (which is unusual in Windows :) ) This means that there is a problem with the RC installer

Re: [libreoffice-users] Windows parallel install

2012-01-27 Thread Manfred J. Krause
Hi Tom, On Fri, Jan 27, 2012 at 1:36 PM, Tom Davies wrote: HI :) Errr, which version of java is LibreOffice trying to use?  Is it trying to use something newer than java 6u24? Regards from Tom :) --- On Fri, 27/1/12, Manfred J. Krause courrier.oou.fr.mjkatgooglemail.com wrote: snip /

[libreoffice-users] Re: Windows parallel install

2012-01-27 Thread Pedro
Hi Tom Tom wrote Errr, which version of java is LibreOffice trying to use?  Is it trying to use something newer than java 6u24? It has nothing to do with Java. Manfred's suggestion solved it. It was a Windows error (not reported by the RC installer though) Thank you for your help, though

Re: [libreoffice-users] Base - No SDBC driver found!!

2012-01-27 Thread Ian Whitfield
OK - I've been doing some Googling on this problem. It seems to be known about and is listed as 'Bug 32948'. Does anyone know what the current status of this bug is? Or seen as Alex Thurgood's name comes up a lot in the Bug Report does anyone have his eMail address so that we can get an

Re: [libreoffice-users] Base question - report exception on faultless query

2012-01-27 Thread Mark Stanton
Hi Dan, Ok, here's the query. SELECT CONCAT(people.Title, ' ', LTRIM(people.Firstname), ' ', LTRIM(people.Surname)) AS PersonName, people.PersonId, issues.iId AS iiID, issues.Issue, people.LastIssue, subscription.iId AS subiId, subscription.Type,

Re: [libreoffice-users] Base - No SDBC driver found!!

2012-01-27 Thread Heinrich Stoellinger
Hi, I can only agree with you. The only connector that works really well is the native one. Using ODBC is buggy and the Java-Connector is (for the Java state of affairs!) so slow! It would be good to step up the priority of the connector (and Base as a whole, ofcourse!) Regards Heinrich On

[libreoffice-users] Re: Mail Merge print from Query instead of table.

2012-01-27 Thread Tom
Hi :) I thought it was better practice to use Queries than Tables to build report/forms/mail-merge from and then print the result? I don't know if anyone has an answer to all this? Regards from Tom :) -- View this message in context:

off-list Re: [libreoffice-users] Re: Re: How to migrate OpenOfficec Writer settings into LinbreOffice Writer

2012-01-27 Thread Tom Davies
Hi :) Did you manage to solve the problem in the end?  Did you get any good answers from the LO mailing list?  Was the UserProfile page any help? http://wiki.documentfoundation.org/Documentation/UserProfile Regards from Tom :) --- On Mon, 23/1/12, Fridolin Gansheimer

Re: [libreoffice-users] Base - No SDBC driver found!!

2012-01-27 Thread Tom Davies
Hi :) It is going to take more than 1 more person to sort out Base.  We need to find a way of getting a whole load of people involved.  The BoD has decided to just sitwait and is happy to leave it to chance and natural progression (ie waiting for devs to move beyond Writer and Calc towards the

[libreoffice-users] Re: Base - No SDBC driver found!!

2012-01-27 Thread Alexander Thurgood
Le 27/01/12 14:37, Ian Whitfield a écrit : Hi Ian, It seems to be known about and is listed as 'Bug 32948'. This bug is related to the Address Datasource wizard, not HSQLDB ? Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

[libreoffice-users] Re: Base - No SDBC driver found!!

2012-01-27 Thread Alexander Thurgood
Le 27/01/12 14:52, Heinrich Stoellinger a écrit : Hi Heinrich, I can only agree with you. The only connector that works really well is the native one. Using ODBC is buggy and the Java-Connector is (for the Java state of affairs!) so slow! The old mysql connector versions (i.e. the

Re: [libreoffice-users] Re: Mail Merge print from Query instead of table.

2012-01-27 Thread Fernand Vanrie
Query's are not working , Views (who are a kind of query's) are by LO seen as tables and act like that in mailmerge Have provided a temporary work around for myself by creating temporary tables from my Query and using these for my mail merge. However it would be much less of a convoluted

[libreoffice-users] Not printing Base fields

2012-01-27 Thread Mark Stanton
I *want* to omit empty fields from my report. I'm using the report writer to print address labels (sheets really, but it's largely the same thing). I want to print name, company, address lines 1, 2 3, tc. If there's no company name I want the whole line omitted. I don't mean don't print any

[libreoffice-users] Re: Mail Merge print from Query instead of table.

2012-01-27 Thread oldlace
Thanks folks for your replies. Am now going down the views route as on a very quick test it seems to resolve the problem. It is these strange quirks that can have you scratching your head for much longer than they deserve. -- View this message in context:

Re: [libreoffice-users] Re: Mysterious spacing problem

2012-01-27 Thread Jay Lozier
On 01/27/2012 05:21 AM, Séamas Ó Brógáin wrote: Jay wrote: Is this a screen resolution or a printing problem. Could you specify which font(s) are troublesome? Also, I forgot - what OS are you using? GNU/Linux (Ubuntu 11.10). Various fonts, including Plantin, but mostly my own (work in

Re: [libreoffice-users] Re: Base - No SDBC driver found!!

2012-01-27 Thread Heinrich Stoellinger
Hi Alex, I have LO 3.3 installed on Windows/Vista and Linux-Mint-Lisa. The native MySQL-Connector worked flawlessly - at least for what I use it. As a fall-back I still use the Vista- System. But, when going to 3.5.0-RC2 today, I saw that - as I had already noticed earlier on, the connector

[libreoffice-users] Re: Base - No SDBC driver found!!

2012-01-27 Thread Alexander Thurgood
Le 27/01/12 16:51, Heinrich Stoellinger a écrit : Hi Heinrich, I have LO 3.3 installed on Windows/Vista and Linux-Mint-Lisa. The native MySQL-Connector worked flawlessly - at least for what I use it. As a fall-back I still use the Vista- System. But, when going to 3.5.0-RC2 today, I saw

[libreoffice-users] Re: Base - No SDBC driver found!!

2012-01-27 Thread Alexander Thurgood
Le 27/01/12 16:51, Heinrich Stoellinger a écrit : Hi Heinrich, I have LO 3.3 installed on Windows/Vista and Linux-Mint-Lisa. The native MySQL-Connector worked flawlessly - at least for what I use it. As a fall-back I still use the Vista- System. But, when going to 3.5.0-RC2 today, I saw

Re: [libreoffice-users] Not printing Base fields

2012-01-27 Thread Mark Stanton
Hidden fields are the answer. Ah, yes. But that then puts me in your boat, not being able to mailmerge from a query. I suppose, if the view things turns out not to work, a function/produced/thing could be written that ran the query, exported the results to a csv file with a name that had

Re: [libreoffice-users] Mail Merge print from Query instead of table.

2012-01-27 Thread Mark Stanton
I thought it was better practice to use Queries than Tables to build report/forms/mail-merge from and then print the result? That's his whole point. Mailmerge doesn't appear to be able to use queries. Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to:

Re: [libreoffice-users] Re: Base - No SDBC driver found!!

2012-01-27 Thread Heinrich Stoellinger
My Linux-Mint is 32-bit... Will try your suggestions. Thanks a lot Regards from Salzburg (all snowed in!) H On Fri, 27 Jan 2012 17:39:55 +0100, Alexander Thurgood alex.thurg...@gmail.com wrote: Le 27/01/12 16:51, Heinrich Stoellinger a écrit : Hi Heinrich, I have LO 3.3 installed on

[libreoffice-users] Problem printing an .xls file

2012-01-27 Thread Maurice Batey
The file referenced below prints correctly under OpenOffice Writer 3.2.1, but not with LO 3.4.5. (Tried on 2 different PC's, two different printers.) Under LO 3.4.5, although a Print Preview is complete, the actual printed page is missing several inches of text on the right. (The rightmost

Re: [libreoffice-users] Problem pasting spreadsheet cells into Impress

2012-01-27 Thread Tanstaafl
On 2012-01-26 5:05 PM, Cor Nouws oo...@nouenoff.nl wrote: Hi, Tanstaafl wrote (13-01-12 22:17) Whenever I try to copy some cells from a spreadsheet and paste the into an Impress Presentation Libreoffice (and Openoffice used to do the same thing) totally locks up goes into never-never land, and

Re: [libreoffice-users] Base - No SDBC driver found!!

2012-01-27 Thread drew
On Fri, 2012-01-27 at 14:16 +0200, Ian Whitfield wrote: OK!!! I've cracked the permissions problem!!! By using DolphinRoot ActionsChange Permissions I've been able to make the file open again. (I wonder why this works but nothing else???) *BUT* - That leaves me back with my original

[libreoffice-users] Re: off-list Re: Re: Re: How to migrate OpenOfficec Writer settings into LinbreOffice Writer

2012-01-27 Thread Maurice Batey
On Fri, 27 Jan 2012 14:30:39 +, Tom Davies wrote: Did you manage to solve the problem in the end? Did you get any good answers from the LO mailing list? Was the UserProfile page any help? Yes, yes, yes - thanks to all! -- /\/\aurice -- For unsubscribe instructions e-mail

Re: [libreoffice-users] Problem printing an .xls file

2012-01-27 Thread Don C. Myers
Hi Maurice, When I print it on a Samsung ML-1710 laser, it prints fine except there is no left hand margin. The cells in Column A are right against the left edge of the paper. I saved it in ods format, and had the same thing. Then I inserted a new column A, so that all of the other columns moved

Re: [libreoffice-users] Problem printing an .xls file

2012-01-27 Thread Thomas Damratowski
Worked fine for me, except that the rightmost horizontal line is missing. Running Windows 7 Ultimate LO 3.4.5 HP Officejet 6500A Plus Printer 2012/1/27 Maurice Batey maur...@bcs.org.uk The file referenced below prints correctly under OpenOffice Writer 3.2.1, but not with LO 3.4.5. (Tried on

Re: [libreoffice-users] Re: what is the alternative of countifs function in libreoffice?

2012-01-27 Thread soumalya ray
sorry;could not understand the meaning of 'duplicate the field'.could you explain a bit more please? regards, On 27 January 2012 17:05, Andreas Säger ville...@t-online.de wrote: Am 27.01.2012 11:23, Pedro wrote: I'm almost sure that you can't do that in the LibreOffice Pivot Tables (unless

[libreoffice-users] Re: Problem printing an .xls file

2012-01-27 Thread Maurice Batey
On Fri, 27 Jan 2012 13:02:01 -0500, Thomas Damratowski wrote: the rightmost horizontal line is missing. Not rightmost *vertical* line? -- /\/\aurice -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

[libreoffice-users] Re: what is the alternative of countifs function in libreoffice?

2012-01-27 Thread Andreas Säger
Am 27.01.2012 19:04, soumalya ray wrote: sorry;could not understand the meaning of 'duplicate the field'.could you explain a bit more please? regards, Create a calculated field with nothing but a reference to the field you need twice. -- For unsubscribe instructions e-mail to:

[libreoffice-users] Re: Problem printing an .xls file

2012-01-27 Thread Maurice Batey
On Fri, 27 Jan 2012 13:01:18 -0500, Don C. Myers wrote: it prints fine except there is no left hand margin. Windows, Linux, Don? -- /\/\aurice -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

Re: [libreoffice-users] Re: Problem printing an .xls file

2012-01-27 Thread Don C. Myers
I'm sorry! Ubuntu 11.10 with LibreOffice 3.4.5 downloaded from LibreOffice. On 01/27/2012 01:28 PM, Maurice Batey wrote: On Fri, 27 Jan 2012 13:01:18 -0500, Don C. Myers wrote: it prints fine except there is no left hand margin. Windows, Linux, Don? --

Re: [libreoffice-users] Re: Problem printing an .xls file

2012-01-27 Thread Thomas Damratowski
Yes, the right most vertical line is missing. Sorry about that. 2012/1/27 Don C. Myers donmy...@myersfarm.com I'm sorry! Ubuntu 11.10 with LibreOffice 3.4.5 downloaded from LibreOffice. On 01/27/2012 01:28 PM, Maurice Batey wrote: On Fri, 27 Jan 2012 13:01:18 -0500, Don C. Myers wrote:

[libreoffice-users] Window focus bug when importing a file into Calc

2012-01-27 Thread Fabian Rodriguez
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Before reporting this as a bug I wanted to know if Mac and Gnu/Linux users can reproduce it The problem: When importing a text file into Calc (eg. CSV), the import dialog does not steal focus as expected This only happend when LibO is already

[libreoffice-users] LibreOffice Calc: Update External Link Question

2012-01-27 Thread Steve Smith
I have a series of spreadsheets with external links to other spreadsheets. The link will not update unless the spreadsheet the link references is open. Is that the expected/desired response of the developers? -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org

[libreoffice-users] Re: Problem printing an .xls file

2012-01-27 Thread Tinkerer
It prints fine on my iMac using LO 3.5rc, with a Canon 4700 printer. All the lines are present and there is a 17mm margin on both sides. Tink. -- View this message in context: http://nabble.documentfoundation.org/Problem-printing-an-xls-file-tp3693933p3694406.html Sent from the Users mailing

[libreoffice-users] Re: LibreOffice Calc: Update External Link Question

2012-01-27 Thread Andreas Säger
Am 27.01.2012 21:02, Steve Smith wrote: I have a series of spreadsheets with external links to other spreadsheets. The link will not update unless the spreadsheet the link references is open. Is that the expected/desired response of the developers? There are 5 different ways to link

Re: [libreoffice-users] Re: LibreOffice Calc: Update External Link Question

2012-01-27 Thread Steve Smith
Understand linking, I think. My question is updating the link. If the source spreadsheet is not opened when a link to external file is updated (Edit - Links... - Update), I receive a #REF! error. Thanks! -Original Message- From: Andreas Säger ville...@t-online.de Sent: Jan 27, 2012

Re: [libreoffice-users] Re: LibreOffice Calc: Update External Link Question

2012-01-27 Thread Thomas Damratowski
Links work correctly for me. Running Windows 7 Ultimate LibreOffice 3.4.5 On Fri, Jan 27, 2012 at 4:29 PM, Steve Smith s...@earthlink.net wrote: Understand linking, I think. My question is updating the link. If the source spreadsheet is not opened when a link to external file is updated

[libreoffice-users] displaying the result of pageNum + 1

2012-01-27 Thread william drescher
In the footer of a faxed document I want to display: This fax continues on page x where x is to be the current page number + 1 Can I do this, how ? Thanks in advance, bill -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

[libreoffice-users] LO Base - calculating dates

2012-01-27 Thread cbeckmore
Hi, I'm a very basic Base user. Can't seem to find any info on having Base calculate a date in a Table. I want to enter the date of a Lease Agreement; follow up is required at 6 months and 12 months, it would be nice to have these dates automatically calculated I'm hoping I can set this up

Re: [libreoffice-users] displaying the result of pageNum + 1

2012-01-27 Thread Dan Lewis
On Fri, 2012-01-27 at 10:31 -0500, william drescher wrote: In the footer of a faxed document I want to display: This fax continues on page x where x is to be the current page number + 1 Can I do this, how ? Thanks in advance, bill In the footer, enter the text you want: This

[libreoffice-users] create mailmerge with spreadsheet librecalc without using libre base ! pls help how to do it TQ

2012-01-27 Thread sonic
HI, i'm facing a problem which doing mailmerge without using BASE to registered to the data source. i did successfully do it with base but now i do not wan to using base to registered the data from spreadsheet table librecalc because i wan to edit the spreadsheet data table easily for me to

Re: [libreoffice-users] Re: what is the alternative of countifs function in libreoffice?

2012-01-27 Thread soumalya ray
its really time consuming.is there any other way to achieve this? regards, On 27 January 2012 23:57, Andreas Säger ville...@t-online.de wrote: Create a calculated field with nothing but a reference to the field you need twice. -- For unsubscribe instructions e-mail to:

[libreoffice-users] LWP documents

2012-01-27 Thread Gregory Forster
How do I open LotusWord Pro documents? When I click on the document in Windows Explorer, I get a blank screen. When I enter LibreOffice and open the document, I get a blank screen. In LibreOffice, I File/Open, change the file selection to Lotus WordPro document (*.lwp), select the file and

[libreoffice-users] capitalization

2012-01-27 Thread lee
Hi, why does LO change words I type to begin with a capital letter instead of the small letter I typed, and how do I prevent that? It´s a bug that needs to be fixed ... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

Re: [libreoffice-users] capitalization

2012-01-27 Thread Jay Lozier
On 01/27/2012 06:39 PM, lee wrote: Hi, why does LO change words I type to begin with a capital letter instead of the small letter I typed, and how do I prevent that? It´s a bug that needs to be fixed ... AFAIK the normal capitalization is determined by the language settings. To reset the

Re: [libreoffice-users] LWP documents

2012-01-27 Thread Jay Lozier
On 01/26/2012 06:30 PM, Gregory Forster wrote: How do I open LotusWord Pro documents? When I click on the document in Windows Explorer, I get a blank screen. When I enter LibreOffice and open the document, I get a blank screen. In LibreOffice, I File/Open, change the file selection to Lotus

Re: [libreoffice-users] Base - No SDBC driver found!!

2012-01-27 Thread Ian Whitfield
On 27/01/2012 19:36, drew wrote: This is a 650Meg file using the embedded db engine, right. The file is usable on other machines, but not on the Mint based machine you need it on and this stopped working after the most recent update of the OS (to version 12) - do I have that correct? If so one