Re: [libreoffice-users] [Calc] How to work with long formulas?

2013-03-28 Thread Mirosław Zalewski
Everyone who participated in this thread, Thanks for your replies and tips. I will try to find my way in Calc's world. Also I have some ideas how debugging and creating long formulas could be improved; I will most certainly push them to developers, so maybe in future it will be simpler. Thanks

[libreoffice-users] Re: booklet printing problem

2013-03-28 Thread Marc Paré
Hi Jeff, I'm responding to the list as I think you probably wanted to answer there and share comments there. On 03/28/2013 04:03 PM, Marc Paré wrote: Try this: * choose Print * choose Properties * choose device * Printer Language type -- you may need to re-adjust the

[libreoffice-users] Re: booklet printing problem

2013-03-28 Thread Jeff Shrowder
On 03/28/2013 08:21 PM, Marc Paré wrote: Hi Jeff, I'm responding to the list as I think you probably wanted to answer there and share comments there. On 03/28/2013 04:03 PM, Marc Paré wrote: Try this: * choose Print * choose Properties * choose device * Printer

Re: [libreoffice-users] Re: Base stuck in Read Only mode??

2013-03-28 Thread Ian Whitfield
Thanks All I was - in the end - able to sort my problem out after some Googling!! As I said it was reporting a Duplicate Key but when I used DESCRIBE and SHOW it told me there was NO Key!! Using UPDATE I was able to re-set the KEY and all is now fine with everything working as expected.

Re: [libreoffice-users] booklet printing problem

2013-03-28 Thread Regina Henschel
Hi Jeff, Jeff Shrowder schrieb: Another problem I have with LO (ver. 4.0.1.2) is that when I try to print a booklet - let's say a 4 page A5 booklet - on A4 it prints pages 1 and 4 in landscape across the portrait-oriented A4 page rather than along it. Pages 2 and 3 are similarly affected. The

[libreoffice-users] Re: [libreoffice-l10n] [ANN] LibreOffice 4.0.2 RC2 available

2013-03-28 Thread Tom Davies
Hi :) Blimey!  Good timing! :) Regards from Tom :)  From: Thorsten Behrens t...@documentfoundation.org To: LibreOffice libreoff...@lists.freedesktop.org; l...@global.libreoffice.org; proje...@global.libreoffice.org; libreoffice...@lists.freedesktop.org

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

2013-03-28 Thread Kracked_P_P---webmaster
On 03/28/2013 07:21 AM, Jeff Shrowder wrote: On 03/28/2013 08:21 PM, Marc Paré wrote: Hi Jeff, I'm responding to the list as I think you probably wanted to answer there and share comments there. On 03/28/2013 04:03 PM, Marc Paré wrote: Try this: * choose Print *

Re: [libreoffice-users] booklet printing problem

2013-03-28 Thread John King
On 28/03/13 12:53, Regina Henschel wrote: Hi Jeff, Jeff Shrowder schrieb: Another problem I have with LO (ver. 4.0.1.2) is that when I try to print a booklet - let's say a 4 page A5 booklet - on A4 it prints pages 1 and 4 in landscape across the portrait-oriented A4 page rather than along it.

Re: [libreoffice-users] --convert-to always fails silently on Ubuntu

2013-03-28 Thread Kieran Peckett
How would that make a difference? Isn't that what he means when he said it wouldn't work as SU? - either that or he ran sudo su before running the command, so I doubt that that is th problem. On 28/03/2013, Jay Lozier jsloz...@gmail.com wrote: On 03/27/2013 10:57 PM, Graham Glass wrote: Hi

[libreoffice-users] Re: --convert-to always fails silently on Ubuntu

2013-03-28 Thread Graham Glass
I tried running the command as su and the same thing happened. -- View this message in context: http://nabble.documentfoundation.org/convert-to-always-fails-silently-on-Ubuntu-tp4046531p4046744.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions

Re: [libreoffice-users] calc problem

2013-03-28 Thread Tom Davies
Hi :) So it meant that instead of discovering a bug with LibreOffice it was a discovered problem with the 3rd party's website and their strange way of setting up their downloads.  The question was whether reporting a bug against LibreOffice might improve LibreOffice's handling of Xls files

Re: [libreoffice-users] --convert-to always fails silently on Ubuntu

2013-03-28 Thread Jay Lozier
Keieran I missed that last night - good catch On 03/28/2013 12:51 PM, Kieran Peckett wrote: How would that make a difference? Isn't that what he means when he said it wouldn't work as SU? - either that or he ran sudo su before running the command, so I doubt that that is th problem. On

Re: [libreoffice-users] --convert-to always fails silently on Ubuntu

2013-03-28 Thread Tom Davies
Hi :) I think you should NOT be using trying to run as SuperUser by su or sudo or anything.  It should work without that but i agree it was a good idea to give it a go to see what happens.  Can you try adding the tag -v or --verbose to see if it gives you more output to explain what is

[libreoffice-users] Re: --convert-to always fails silently on Ubuntu

2013-03-28 Thread Graham Glass
Hi Tom, Neither of -v or --verbose is recognized as a command line option. I'm using libreoffice 4.0.1.2, and here are the command line options that it supports. I wish I could find a way to get more information about why it's failing! Cheers, Graham == Unknown

[libreoffice-users] copy styles from Writer document?

2013-03-28 Thread T. R. Valentine
Is there an easy way to copy the styles used in one Writer document to another? -- T. R. Valentine Your friends will argue with you. Your enemies don't care. 'When I get a little money I buy books; and if any is left I buy food and clothes.' -- Erasmus -- For unsubscribe instructions e-mail

Re: [libreoffice-users] --convert-to always fails silently on Ubuntu

2013-03-28 Thread Tom Davies
Hi :) It might have made a difference if he didn't have read/write access to the folder or something dumb like that.  Also it's something quick to try and beats just tearing your hair out.  Regards from Tom :)  From: Jay Lozier jsloz...@gmail.com To:

Re: [libreoffice-users] copy styles from Writer document?

2013-03-28 Thread Kevin O'Brien
On 3/28/2013 1:56 PM, T. R. Valentine wrote: Is there an easy way to copy the styles used in one Writer document to another? -- T. R. Valentine Your friends will argue with you. Your enemies don't care. 'When I get a little money I buy books; and if any is left I buy food and clothes.' --

Re: [libreoffice-users] calc problem

2013-03-28 Thread Jay Lozier
On 03/28/2013 01:23 PM, Tom Davies wrote: Hi :) So it meant that instead of discovering a bug with LibreOffice it was a discovered problem with the 3rd party's website and their strange way of setting up their downloads. The question was whether reporting a bug against LibreOffice might

Re: [libreoffice-users] --convert-to always fails silently on Ubuntu

2013-03-28 Thread Jay Lozier
On 03/28/2013 01:58 PM, Tom Davies wrote: Hi :) It might have made a difference if he didn't have read/write access to the folder or something dumb like that. Also it's something quick to try and beats just tearing your hair out. Regards from Tom :) sudo chown blah to change ownership of the

[libreoffice-users] Re: --convert-to always fails silently on Ubuntu

2013-03-28 Thread Graham Glass
The folder is owned by the same user that is executing the command, so I don't think that's an issue. It would be ideal if there was a way to find out what the actual permissions error is. Is there a log file or a verbose option to get this information? Trying lots of things without knowing the

Re: [libreoffice-users] copy styles from Writer document?

2013-03-28 Thread Mirosław Zalewski
On 28/03/2013 at 19:13, Kevin O'Brien zwil...@zwilnik.com wrote: Yes, there is. ... unless you are using 4.0, in which it is not possible. See #60589: https://bugs.freedesktop.org/show_bug.cgi?id=60589. -- Best regards Mirosław Zalewski -- For unsubscribe instructions e-mail to:

Re: [libreoffice-users] copy styles from Writer document?

2013-03-28 Thread T. R. Valentine
On 28 March 2013 13:13, Kevin O'Brien zwil...@zwilnik.com wrote: On 3/28/2013 1:56 PM, T. R. Valentine wrote: Is there an easy way to copy the styles used in one Writer document to another? Yes, there is. Go to the File--Templates--Organize. Open the document you want to copy from in one

Re: [libreoffice-users] copy styles from Writer document?

2013-03-28 Thread Kevin O'Brien
On 3/28/2013 2:33 PM, Mirosław Zalewski wrote: On 28/03/2013 at 19:13, Kevin O'Brien zwil...@zwilnik.com wrote: Yes, there is. ... unless you are using 4.0, in which it is not possible. See #60589: https://bugs.freedesktop.org/show_bug.cgi?id=60589. Oh my, that is not good. Thanks for the

Re: [libreoffice-users] copy styles from Writer document?

2013-03-28 Thread T. R. Valentine
On 28 March 2013 13:33, Mirosław Zalewski mini...@poczta.onet.pl wrote: On 28/03/2013 at 19:13, Kevin O'Brien zwil...@zwilnik.com wrote: Yes, there is. ... unless you are using 4.0, in which it is not possible. See #60589: https://bugs.freedesktop.org/show_bug.cgi?id=60589. Then I will have

Re: [libreoffice-users] copy styles from Writer document?

2013-03-28 Thread Kevin O'Brien
On 3/28/2013 2:50 PM, T. R. Valentine wrote: On 28 March 2013 13:33, Mirosław Zalewski mini...@poczta.onet.pl wrote: On 28/03/2013 at 19:13, Kevin O'Brien zwil...@zwilnik.com wrote: Yes, there is. ... unless you are using 4.0, in which it is not possible. See #60589:

Re: [libreoffice-users] copy styles from Writer document?

2013-03-28 Thread Dan Lewis
On 03/28/2013 01:56 PM, T. R. Valentine wrote: Is there an easy way to copy the styles used in one Writer document to another? -- T. R. Valentine Your friends will argue with you. Your enemies don't care. 'When I get a little money I buy books; and if any is left I buy food and clothes.' --

Re: [libreoffice-users] --convert-to always fails silently on Ubuntu

2013-03-28 Thread Tom Davies
Hi :) There is not much point in fixing a problem when you don't know what the problem is or where it is if there is one.  That's a bit like pin the tail on the donkey but without anyone looking to see how close you got.  What if, as it turned out, that the file/folder permissions were not the

Re: [libreoffice-users] copy styles from Writer document?

2013-03-28 Thread T. R. Valentine
On 28 March 2013 14:03, Dan Lewis elderdanle...@gmail.com wrote: On 03/28/2013 01:56 PM, T. R. Valentine wrote: Is there an easy way to copy the styles used in one Writer document to another? When I want to copy styles from one Writer document to another I have a few steps that I do after

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

2013-03-28 Thread Jeff Shrowder
On 03/29/2013 12:57 AM, Tom Davies wrote: Hi :) Perhaps a compromise? https://wiki.documentfoundation.org/Installing_in_parallel Have both! :) Then when the 3.5.6 comes out you will be ready to test-drive it straight away! :) The 4.0.2 comes out soon too so it might be possible to find an

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

2013-03-28 Thread Tom Davies
HI :) No! I think that turns out to be a Pita and doesn't work particularly well but maybe something has changed in the last couple of years.  Might be interesting.  Hmm, i'm intrigued.  Go for it.  lol Regards from Tom :)  From: Jeff Shrowder

Re: [libreoffice-users] booklet printing problem

2013-03-28 Thread Jeff Shrowder
Regina, On 03/28/2013 11:53 PM, you wrote: Hi Jeff, Jeff Shrowder schrieb: Another problem I have with LO (ver. 4.0.1.2) is that when I try to print a booklet - let's say a 4 page A5 booklet - on A4 it prints pages 1 and 4 in landscape across the portrait-oriented A4 page rather than along

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

2013-03-28 Thread Jeff Shrowder
On 03/29/2013 07:07 AM, Tom Davies wrote: HI :) No! I think that turns out to be a Pita and doesn't work particularly well but maybe something has changed in the last couple of years. Might be interesting. Hmm, i'm intrigued. Go for it. lol Regards from Tom :)

[libreoffice-users] Re: booklet printing problem

2013-03-28 Thread Marc Paré
Hi Jeff, Le 28/03/13 07:21 AM, Jeff Shrowder a écrit : Thank you for your suggestions. I've had no success. What is the LibreOffice profile and what is its function? I haven't found a way to change the margins when printing a booklet in acroread. The default margins are bigger than I want.

Re: [libreoffice-users] calc problem

2013-03-28 Thread Tom Davies
Hi :) Yes, i agree.  Not handling a weird sort of Xls is not necessarily a bug.  Native formats might be more of an issue.  Since it's an ultra-weird format and not even an Xls it's definitely not an LO bug.  Btw many apols for being rude earlier.  I'm a bit of a pillock sometimes.  Sorry

[libreoffice-users] comments above the split line

2013-03-28 Thread John R. Sowden
When I have split a calc document to lock the titles, etc, I have a problem inserting/editing comments for a cell if the comment text area is above the split line. LO only accepts about 4 characters, then ignores further entry, I have to put the mouse cursor in the comment area and click on

Re: [libreoffice-users] copy styles from Writer document?

2013-03-28 Thread Steve Edmonds
On 2013-03-29 07:50, T. R. Valentine wrote: On 28 March 2013 13:33, Mirosław Zalewski mini...@poczta.onet.pl wrote: On 28/03/2013 at 19:13, Kevin O'Brien zwil...@zwilnik.com wrote: Yes, there is. ... unless you are using 4.0, in which it is not possible. See #60589:

Re: [libreoffice-users] calc problem

2013-03-28 Thread Michael Wu
Jay Lozier 提到: On 03/28/2013 01:23 PM, Tom Davies wrote: Hi :) So it meant that instead of discovering a bug with LibreOffice it was a discovered problem with the 3rd party's website and their strange way of setting up their downloads. The question was whether reporting a bug against

Re: [libreoffice-users] calc problem

2013-03-28 Thread Tom Davies
Hi :) You are welcome to post it as a bug.  One of the drop-down menus lets you choose enhancement request or something if you want https://wiki.documentfoundation.org/BugReport Regards from Tom :)  From: Michael Wu m...@tercel.com.tw To:

Re: [libreoffice-users] calc problem

2013-03-28 Thread TomW
On 2013-03-27 23:23, Tim Lloyd wrote: It was not a matter of preferences. It was because calc could not open a .XLS file. On further investigation it was found that it is not an XLS file hence the problem Cheers On 03/28/2013 01:48 PM, nvrk wrote: Is there a reason why the .xls file version

Re: [libreoffice-users] calc problem

2013-03-28 Thread Michael Wu
I have filed a bug report with the ticket number 62888. Regards from Michael Tom Davies 提到: Hi :) You are welcome to post it as a bug. One of the drop-down menus lets you choose enhancement request or something if you want https://wiki.documentfoundation.org/BugReport Regards from Tom