Re: [libreoffice-users] calc problem

[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 :)  
>
>
>
>
>
>
>> 
>> From: Michael Wu 
>> To: users@global.libreoffice.org 
>> Sent: Friday, 29 March 2013, 1:13
>> Subject: Re: [libreoffice-users] calc problem
>>
>> 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
 improve LibreOffice's handling of Xls files but the answer to that is
 just "No" and that solves the problem.
 Regards from
 Tom :)

>>> IMHO it not necessarily a bug but certainly a feature request.
>> Because I can open the downloaded xls and csv file with gnumeric without
>> problem, maybe something in LibreOffice is needed to be checked.
>>
>> Regards from
>>
>> Michael


> 
> From: Tim Lloyd 
> To: nvrk 
> Cc: users@global.libreoffice.org
> Sent: Thursday, 28 March 2013, 3:23
> Subject: Re: [libreoffice-users] calc problem
>
> 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 is preferred to the .csv
>> version from the afr.com site?
>> nvsoar
>>
>> On Wed, Mar 27, 2013 at 5:47 PM, Michael Wu  wrote:
>>
> On Tue, Mar 26, 2013 at 7:44 AM, Tim Lloyd  > wrote:
>
> Hi, before I log this as a bug I would like to know whether anyone
> has seen it before/potential fix identified.
>
> I normally use Fedora linux and I download (.XLS) share tables
> from a financial newspaper here in Oz. Yesterday I inadvertently
> clicked on the wrong table by accident and tried to open it. Calc
> locked up! No problem with the files I normally look at, Calc
> opened them fine.
>
> So I tried again today and waited for an error - "LibreOffice
> 4.0.1.2 General input/output error". So I hopped over to the
> windows PC and tried LO portable. Same error. The error was
> repeated whether I tried to open directly from the website or if I
> saved to disk and then attempted to open the file. MS Excel has no
> problems.
>
> The file in question is accessible using this link:
>
> http://www.afr.com/share_tables/
>
> Just click on the xls link next to "Warrant Market"
>
> Any comments?
>
> Cheers
>
>
>>> Hi Tim,
>>>
>>> Since you use Fedora Linux, maybe you can try gnumeric as a temporary
>>> alternative.
>>>
>>> Hope it helps and regards,
>>>
>>> Michael
>>>
>>> -- 
>>> For unsubscribe instructions e-mail to:
>>> users+h...@global.libreoffice.org
>>> Problems?
>>> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>>> Posting guidelines + more:
>>> http://wiki.documentfoundation.org/Netiquette
>>> List archive: http://listarchives.libreoffice.org/global/users/
>>> All messages sent to this list will be publicly archived and
>>> cannot be
>>> deleted
>>>
> -- 
> For unsubscribe instructions e-mail to:
> users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more:
> http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot
> be deleted
>
>
>
>
>>>
>>
>>
>> -- 
>> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
>> Problems? 
>> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
>> List archive: http://listarchives.libreoffice.org/global/users/
>> All messages sent to this list will be publicly archived and cannot be 
>> deleted
>>
>>
>>



-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.o

Re: [libreoffice-users] calc problem

[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 is preferred to the .csv
version from the afr.com site?
nvsoar

On Wed, Mar 27, 2013 at 5:47 PM, Michael Wu  wrote:


On Tue, Mar 26, 2013 at 7:44 AM, Tim Lloyd mailto:tim.ll...@gmx.com>> wrote:

 Hi, before I log this as a bug I would like to know whether 
anyone

 has seen it before/potential fix identified.

 I normally use Fedora linux and I download (.XLS) share tables
 from a financial newspaper here in Oz. Yesterday I inadvertently
 clicked on the wrong table by accident and tried to open it. 
Calc

 locked up! No problem with the files I normally look at, Calc
 opened them fine.

 So I tried again today and waited for an error - "LibreOffice
 4.0.1.2 General input/output error". So I hopped over to the
 windows PC and tried LO portable. Same error. The error was
 repeated whether I tried to open directly from the website or 
if I
 saved to disk and then attempted to open the file. MS Excel 
has no

 problems.

 The file in question is accessible using this link:

 http://www.afr.com/share_tables/

 Just click on the xls link next to "Warrant Market"

 Any comments?

 Cheers



Hi Tim,

Since you use Fedora Linux, maybe you can try gnumeric as a temporary
alternative.

Hope it helps and regards,

Michael

--
For unsubscribe instructions e-mail to: 
users+h...@global.libreoffice.org

Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: 
http://wiki.documentfoundation.org/Netiquette

List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted






Tim:

I finally had enough free time(very rare(short leash)), with access to 
Excel '03, to work with the file.  I started by opening it in Excel and 
truncating rows of data.  I would then try to open this truncated file 
with Calc (latest portable version).  I started with large chunks (about 
1k row).  Once Calc would open the file (4k rows removed), I started 
splitting the difference between 3k and 4k rows removed. I kept getting 
the Data I/O failure until I had removed 3617rows from the end.  I then 
repeated the process by removing rows of data from the beginning of the 
file. Again the file would open in Calc with 3618 rows removed from the 
beginning of the file.  In another block of free time, I removed rows 
from the middle of the filewith similar results.


Items of note:

The original file used 7200 rows in Excel.

I neverremoved any rows from the Column labels on up.

The pass/fail for opening the file in Calc was unstable when near the 
3617row removal.


When cancelling the Data I/O error message, it would take nearly the 
same amount of time for the message to clearas it did to appear.


The original file structure had 191k lines. Row/cell tags were quite 
often on their own line from the data.


Once opened in Excel and saved the file structure was automatically 
changed to Excel Spreadsheet XML format.  This seemed to have no effect 
on Calc's ability to open the files.


When Calc was able to open the file, two empty rows above the column 
labels were missing that were there when opened in Excel.


I did not have enough time to try truncating data using a text editor on 
the original file.


TomW

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] calc problem

[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 
>To: users@global.libreoffice.org 
>Sent: Friday, 29 March 2013, 1:13
>Subject: Re: [libreoffice-users] calc problem
> 
>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
>>> improve LibreOffice's handling of Xls files but the answer to that is
>>> just "No" and that solves the problem.
>>> Regards from
>>> Tom :)
>>>
>> IMHO it not necessarily a bug but certainly a feature request.
>Because I can open the downloaded xls and csv file with gnumeric without
>problem, maybe something in LibreOffice is needed to be checked.
>
>Regards from
>
>Michael
>>>
>>>
>>>
 
 From: Tim Lloyd 
 To: nvrk 
 Cc: users@global.libreoffice.org
 Sent: Thursday, 28 March 2013, 3:23
 Subject: Re: [libreoffice-users] calc problem

 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 is preferred to the .csv
> version from the afr.com site?
> nvsoar
>
> On Wed, Mar 27, 2013 at 5:47 PM, Michael Wu  wrote:
>
 On Tue, Mar 26, 2013 at 7:44 AM, Tim Lloyd >>> > wrote:

 Hi, before I log this as a bug I would like to know whether anyone
 has seen it before/potential fix identified.

 I normally use Fedora linux and I download (.XLS) share tables
 from a financial newspaper here in Oz. Yesterday I inadvertently
 clicked on the wrong table by accident and tried to open it. Calc
 locked up! No problem with the files I normally look at, Calc
 opened them fine.

 So I tried again today and waited for an error - "LibreOffice
 4.0.1.2 General input/output error". So I hopped over to the
 windows PC and tried LO portable. Same error. The error was
 repeated whether I tried to open directly from the website or if I
 saved to disk and then attempted to open the file. MS Excel has no
 problems.

 The file in question is accessible using this link:

 http://www.afr.com/share_tables/

 Just click on the xls link next to "Warrant Market"

 Any comments?

 Cheers


>> Hi Tim,
>>
>> Since you use Fedora Linux, maybe you can try gnumeric as a temporary
>> alternative.
>>
>> Hope it helps and regards,
>>
>> Michael
>>
>> -- 
>> For unsubscribe instructions e-mail to:
>> users+h...@global.libreoffice.org
>> Problems?
>> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>> Posting guidelines + more:
>> http://wiki.documentfoundation.org/Netiquette
>> List archive: http://listarchives.libreoffice.org/global/users/
>> All messages sent to this list will be publicly archived and
>> cannot be
>> deleted
>>

 -- 
 For unsubscribe instructions e-mail to:
 users+h...@global.libreoffice.org
 Problems?
 http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more:
 http://wiki.documentfoundation.org/Netiquette
 List archive: http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly archived and cannot
 be deleted




>>
>>
>
>
>
>-- 
>For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
>Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
>List archive: http://listarchives.libreoffice.org/global/users/
>All messages sent to this list will be publicly archived and cannot be deleted
>
>
>
-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] calc problem

[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 LibreOffice might
>> improve LibreOffice's handling of Xls files but the answer to that is
>> just "No" and that solves the problem.
>> Regards from
>> Tom :)
>>
> IMHO it not necessarily a bug but certainly a feature request.
Because I can open the downloaded xls and csv file with gnumeric without
problem, maybe something in LibreOffice is needed to be checked.

Regards from

Michael
>>
>>
>>
>>> 
>>> From: Tim Lloyd 
>>> To: nvrk 
>>> Cc: users@global.libreoffice.org
>>> Sent: Thursday, 28 March 2013, 3:23
>>> Subject: Re: [libreoffice-users] calc problem
>>>
>>> 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 is preferred to the .csv
 version from the afr.com site?
 nvsoar

 On Wed, Mar 27, 2013 at 5:47 PM, Michael Wu  wrote:

>>> On Tue, Mar 26, 2013 at 7:44 AM, Tim Lloyd >> > wrote:
>>>
>>> Hi, before I log this as a bug I would like to know whether anyone
>>> has seen it before/potential fix identified.
>>>
>>> I normally use Fedora linux and I download (.XLS) share tables
>>> from a financial newspaper here in Oz. Yesterday I inadvertently
>>> clicked on the wrong table by accident and tried to open it. Calc
>>> locked up! No problem with the files I normally look at, Calc
>>> opened them fine.
>>>
>>> So I tried again today and waited for an error - "LibreOffice
>>> 4.0.1.2 General input/output error". So I hopped over to the
>>> windows PC and tried LO portable. Same error. The error was
>>> repeated whether I tried to open directly from the website or if I
>>> saved to disk and then attempted to open the file. MS Excel has no
>>> problems.
>>>
>>> The file in question is accessible using this link:
>>>
>>> http://www.afr.com/share_tables/
>>>
>>> Just click on the xls link next to "Warrant Market"
>>>
>>> Any comments?
>>>
>>> Cheers
>>>
>>>
> Hi Tim,
>
> Since you use Fedora Linux, maybe you can try gnumeric as a temporary
> alternative.
>
> Hope it helps and regards,
>
> Michael
>
> -- 
> For unsubscribe instructions e-mail to:
> users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more:
> http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and
> cannot be
> deleted
>
>>>
>>> -- 
>>> For unsubscribe instructions e-mail to:
>>> users+h...@global.libreoffice.org
>>> Problems?
>>> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>>> Posting guidelines + more:
>>> http://wiki.documentfoundation.org/Netiquette
>>> List archive: http://listarchives.libreoffice.org/global/users/
>>> All messages sent to this list will be publicly archived and cannot
>>> be deleted
>>>
>>>
>>>
>>>
>
>



-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[Steve Edmonds]

On 2013-03-29 07:50, T. R. Valentine wrote:

On 28 March 2013 13:33, Mirosław Zalewski  wrote:

On 28/03/2013 at 19:13, "Kevin O'Brien"  wrote:


Yes, there is.

... unless you are using 4.0, in which it is not possible. See #60589:
.

Then I will have to consider myself fortunate the Ubuntu archives
haven't updated to 4.0!


--
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

I retain the install files from the LO website for earlier installs so 
if they drop off my distro repository I can always go back and use the 
earlier version.

Steve


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] comments above the split line

[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 it to be able to continue to enter text.


Help,

John


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] calc problem

[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 chap.  
Regards from
Tom :)  





>
> From: Jay Lozier 
>To: users@global.libreoffice.org 
>Sent: Thursday, 28 March 2013, 18:23
>Subject: Re: [libreoffice-users] calc problem
> 
>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 improve 
>> LibreOffice's handling of Xls files but the answer to that is just "No" and 
>> that solves the problem.
>> Regards from
>> Tom :)
>>
>IMHO it not necessarily a bug but certainly a feature request.
>>
>>
>>
>>> 
>>> From: Tim Lloyd 
>>> To: nvrk 
>>> Cc: users@global.libreoffice.org
>>> Sent: Thursday, 28 March 2013, 3:23
>>> Subject: Re: [libreoffice-users] calc problem
>>>
>>> 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 is preferred to the .csv
 version from the afr.com site?
 nvsoar

 On Wed, Mar 27, 2013 at 5:47 PM, Michael Wu  wrote:

>>> On Tue, Mar 26, 2013 at 7:44 AM, Tim Lloyd >> > wrote:
>>>
>>>        Hi, before I log this as a bug I would like to know whether 
>>>anyone
>>>        has seen it before/potential fix identified.
>>>
>>>        I normally use Fedora linux and I download (.XLS) share tables
>>>        from a financial newspaper here in Oz. Yesterday I inadvertently
>>>        clicked on the wrong table by accident and tried to open it. Calc
>>>        locked up! No problem with the files I normally look at, Calc
>>>        opened them fine.
>>>
>>>        So I tried again today and waited for an error - "LibreOffice
>>>        4.0.1.2 General input/output error". So I hopped over to the
>>>        windows PC and tried LO portable. Same error. The error was
>>>        repeated whether I tried to open directly from the website or if 
>>>I
>>>        saved to disk and then attempted to open the file. MS Excel has 
>>>no
>>>        problems.
>>>
>>>        The file in question is accessible using this link:
>>>
>>>        http://www.afr.com/share_tables/
>>>
>>>        Just click on the xls link next to "Warrant Market"
>>>
>>>        Any comments?
>>>
>>>        Cheers
>>>
>>>
> Hi Tim,
>
> Since you use Fedora Linux, maybe you can try gnumeric as a temporary
> alternative.
>
> Hope it helps and regards,
>
> Michael
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>>>
>>> -- 
>>> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
>>> Problems? 
>>> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>>> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
>>> List archive: http://listarchives.libreoffice.org/global/users/
>>> All messages sent to this list will be publicly archived and cannot be 
>>> deleted
>>>
>>>
>>>
>>>
>
>
>-- 
>Jay Lozier
>jsloz...@gmail.com
>
>
>-- 
>For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
>Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
>List archive: http://listarchives.libreoffice.org/global/users/
>All messages sent to this list will be publicly archived and cannot be deleted
>
>
>
>
-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: booklet printing problem

[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.

At the rate I am going I might remove 4.0.1.2 and revert to 3.5 - but
that would be to admit defeat :-)


Cheers,

Jeff





Note: the LibreOffice profile holds your name, address, email etc and 
all of the other settings that you will find in Tools->Options. It will 
also store extra stuff like the extensions, clipart (that you may have 
added) ... In short all that you have done to LibreOffice to customize 
it for your own use.


=

It sounds like you are on a linux box. Try this:

* close ALL instances of LibreOffice
* open you main file browser -- KDE would be Dolphin
* make all of the files visible in your Home directory
* go to .config
* you will see the file folder libreoffice
* rename the folder to libreofficeOLD
* go back and start LibreOffice again, your configuration will be reset 
as if this is the first time you open LibreOffice
* try your file again to see if this makes a difference. If so you may 
consider keeping this configuration


NOTE
* IF there is no difference in how LibreOffice prints your handbook
* IF you liked the previous LibreOffice configuration
* close ALL instances of LibreOffice
* go back to .config
* delete the new file folder libreoffice
* rename your old configuration file libreofficeOLD to libreoffice
* this will return you to your original configuration with all of your 
settings etc.


Also,

Would you consider sending your file to one of us to see? Maybe it is a 
question that could be submitted as a bug.


Thanks for your patience with this.

Cheers,

Marc

--
Marc Paré
m...@marcpare.com
http://www.parEntreprise.com
parEntreprise.com Supports OpenDocument Formats (ODF)
parEntreprise.com Supports http://www.LibreOffice.org


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 :)








From: Jeff Shrowder
To: libreoffice_users
Sent: Thursday, 28 March 2013, 19:55
Subject: Re: [libreoffice-users] Re: booklet printing problem

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
alpha-test version if you help with QA for a bit which might also be a good way 
of
getting something done about your problem more quickly.


Hmmm. Gives me the idea to install LO 3.5.2 (Win) in Wine on my Linux machine.


Jeff


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted






Nah, not serious really 8-) But I did have such a setup several years ago. Can't 
remember why, but my recollection is that it worked/played OK.


Jeff


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] booklet printing problem

[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 it. Pages 2 and 3 are similarly affected.

The settings I use are the same as for LO 3.5. The layout image in the
Print dialogue box is the same as in 3.5 so, everything being equal, I
should get the right result. But I don't.


"Same setting" does not help us, because we do not know your setting.Booklet 
printing
works for me, so perhaps I describe my way and you can compare it to
your way.

Precondition: You document is written in A5. Your printer can duplex printing.
1. In normal view use LO print dialog via File > Print.
2. Click on printer properties to get the dialog of your printer driver. Set 
your
printer to use DIN A4 paper. In finishing set the orientation to landscape, and
enable duplex printing on printer. OK.
3. In LO print dialog click on tab 'Page Layout' and there on option 'brochure'.
4. OK to print

If your printer cannot duplex printing you need to turn the sheets manually. The
printer manual should have a guide for that. For me it would be in addition to 
the
settings above:
Step 1: Set 'front page' in drop down 'Includes' on the tab 'Page Layout'. 
Print.
Step 2: Put the sheets back into the tray.
Step 3: Set 'back page' in drop down 'Includes' on the tab 'Page Layout' and 
mark 'In
reverse page order' on tab 'General'. Print.



Thank you for trying to help me solve this problem.
My printer cannot do duplex. I have for many years (with OO and more recently LO) 
successfully used the print method you describe above. I use it with my recently 
installed LO 4.0.1.2 and have this terrible problem.


King regards,

Jeff





--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 
>To: libreoffice_users  
>Sent: Thursday, 28 March 2013, 19:55
>Subject: Re: [libreoffice-users] Re: booklet printing problem
> 
>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
>> alpha-test version if you help with QA for a bit which might also be a good 
>> way of
>> getting something done about your problem more quickly.
>
>Hmmm. Gives me the idea to install LO 3.5.2 (Win) in Wine on my Linux machine.
>
>
>Jeff
>
>
>-- 
>For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
>Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
>List archive: http://listarchives.libreoffice.org/global/users/
>All messages sent to this list will be publicly archived and cannot be deleted
>
>
>
>
-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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
alpha-test version if you help with QA for a bit which might also be a good way 
of
getting something done about your problem more quickly.


Hmmm. Gives me the idea to install LO 3.5.2 (Win) in Wine on my Linux machine.


Jeff


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[T. R. Valentine]

On 28 March 2013 14:03, Dan Lewis  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 opening the document whose styles I want to
> change:
>
> 1) Open the Styles and Formatting window (F11).
> 2) Click the "New Style from Selection" and click "Load Styles"
> 3) Check all of the checkboxes: Text through Overwrite.
> 4) Click "From File".
> 5) Browse to the file and select it.
> 6) Click the Open button.
>
> I have been doing this since OOo2.0 or perhaps before. Today it worked
> for LO 4.0.1.2. Just now it worked for 4.02.2 as well.
>  Has anyone else tried this?

I just gave it a test and it seems to work as well — better in some
ways, not as well in others. (The document from which I wanted to copy
styles had special paragraph, character, and page styles and I really
didn't want to have to go through manually creating them again.)

Thanks to all for the help.

--
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 to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 issue?  You can 
chown all you want but now you don't know whether the problem has been solved 
or not.  

One trouble-shooting technique is to try su or sudo and if it had no effect 
then you can rule out a whole bunch of stuff.  As has happened in this case.  

As Graham says, what would be really nice is to find a log-file or generate 
one.  Almost all commands have a "verbose" tag that does the job.  How can we 
get more info about what is going wrong?

Regards from 
Tom :)






>
> From: Jay Lozier 
>To: users@global.libreoffice.org 
>Sent: Thursday, 28 March 2013, 18:26
>Subject: Re: [libreoffice-users] --convert-to always fails silently on Ubuntu
> 
>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 folder - I have to look the 
>exact switches, etc. I have seen this issue crop up occasionally were a 
>folder tree does not have the permissions set to allow something like this.
>>
>>
>>
>>> 
>>> From: Jay Lozier 
>>> To: Kieran Peckett 
>>> Cc: users@global.libreoffice.org
>>> Sent: Thursday, 28 March 2013, 17:26
>>> Subject: Re: [libreoffice-users] --convert-to always fails silently on 
>>> Ubuntu
>>>
>>> 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 28/03/2013, Jay Lozier  wrote:
> On 03/27/2013 10:57 PM, Graham Glass wrote:
>> Hi everyone,
>>
>> I just downloaded libreoffice 4 and installed it on a Mac (Lion) and
>> Linux
>> (Ubuntu). On the Mac, everything works exactly as I expected, and I can
>> easily convert documents to pdfs using the command line tool like this:
>>
>> /Applications/LibreOffice.app/Contents/MacOS/soffice --headless
>> --convert-to
>> pdf sample.ppt
>>
>> However, on Unbuntu, when I execute the equivalent command, it always
>> fails
>> quickly and silently with exit code 77 (Permission denied).
>>
>> /opt/libreoffice4.0/program/soffice --headless --convert-to pdf
>> sample.ppt
>>
>> This failure happens regardless of whether I am a regular user or
>> superuser.
>> I am not running libreoffice via a user interface, and this command is
>> being
>> executed on an Amazon EC2 headless machine.
>>
>> Can someone offer any advice, either a method to get more error
>> information
>> (such as a log file or a verbose flag) so I can figure out what's going
>> on?
>> I'm sure it's a simple issue, but right now the lack of error reporting
>> is
>> making it hard to get the issue resolved.
>>
>> Thanks in advance!
>>
>> Cheers,
>> Graham
>>
>>
>>
>> --
>> View this message in context:
>> http://nabble.documentfoundation.org/convert-to-always-fails-silently-on-Ubuntu-tp4046531.html
>> Sent from the Users mailing list archive at Nabble.com.
>>
> Graham,
>
> Try the command prefixed with sudo.
>
> --
> Jay Lozier
> jsloz...@gmail.com
>
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>
>>>
>>> -- 
>>> Jay Lozier
>>> jsloz...@gmail.com
>>>
>>>
>>> -- 
>>> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
>>> Problems? 
>>> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>>> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
>>> List archive: http://listarchives.libreoffice.org/global/users/
>>> All messages sent to this list will be publicly archived and cannot be 
>>> deleted
>>>
>>>
>>>
>>>
>
>
>-- 
>Jay Lozier
>jsloz...@gmail.com
>
>
>-- 
>For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
>Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more: http://wiki.docume

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

[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.' -- Erasmus

 When I want to copy styles from one Writer document to another I 
have a few steps that I do after opening the document whose styles I 
want to change:


1) Open the Styles and Formatting window (F11).
2) Click the "New Style from Selection" and click "Load Styles"
3) Check all of the checkboxes: Text through Overwrite.
4) Click "From File".
5) Browse to the file and select it.
6) Click the Open button.

 I have been doing this since OOo2.0 or perhaps before. Today it 
worked for LO 4.0.1.2. Just now it worked for 4.02.2 as well.

 Has anyone else tried this?

--Dan

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[Kevin O'Brien]

On 3/28/2013 2:50 PM, T. R. Valentine wrote:

On 28 March 2013 13:33, Mirosław Zalewski  wrote:

On 28/03/2013 at 19:13, "Kevin O'Brien"  wrote:


Yes, there is.

... unless you are using 4.0, in which it is not possible. See #60589:
.

Then I will have to consider myself fortunate the Ubuntu archives
haven't updated to 4.0!


--
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


You and me both.

--
Kevin B. O'Brien
zwil...@zwilnik.com
A damsel with a dulcimer in a vision once I saw.


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[T. R. Valentine]

On 28 March 2013 13:33, Mirosław Zalewski  wrote:
> On 28/03/2013 at 19:13, "Kevin O'Brien"  wrote:
>
>> Yes, there is.
>
> ... unless you are using 4.0, in which it is not possible. See #60589:
> .

Then I will have to consider myself fortunate the Ubuntu archives
haven't updated to 4.0!


--
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 to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[Kevin O'Brien]

On 3/28/2013 2:33 PM, Mirosław Zalewski wrote:

On 28/03/2013 at 19:13, "Kevin O'Brien"  wrote:


Yes, there is.

... unless you are using 4.0, in which it is not possible. See #60589:
.

Oh my, that is not good. Thanks for the correction.

--
Kevin B. O'Brien
zwil...@zwilnik.com
A damsel with a dulcimer in a vision once I saw.


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[T. R. Valentine]

On 28 March 2013 13:13, Kevin O'Brien  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 window, and then the
> document/Template you want to copy to in the other, and click
> and drag. I explain it with screenshots here:
>
> http://www.ahuka.com/?page_id=461

Brilliant!

I figured it was in the Organise Templates, but I did not know one
could double-click on 'Styles' to get to individual styles (only knew
the first double-click to get to 'Styles' of the document). Doing it
with 'Styles and Formatting' window open (F11) and set to show
'Applied Styles' made it easy to know which styles to copy.

I've bookmarked your page for future reference.

Many thanks.


--
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 to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[Mirosław Zalewski]

On 28/03/2013 at 19:13, "Kevin O'Brien"  wrote:

> Yes, there is.

... unless you are using 4.0, in which it is not possible. See #60589:
.
-- 
Best regards
Mirosław Zalewski

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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
details of the issue is quite inefficient.


On Thu, Mar 28, 2013 at 11:27 AM, Jay Lozier [via Document Foundation Mail
Archive]  wrote:

> 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 folder - I have to look the
> exact switches, etc. I have seen this issue crop up occasionally were a
> folder tree does not have the permissions set to allow something like
> this.
>
> >
> >
> >
> >> 
> >> From: Jay Lozier <[hidden 
> >> email]>
>
> >> To: Kieran Peckett <[hidden 
> >> email]>
>
> >> Cc: [hidden email]
> >> Sent: Thursday, 28 March 2013, 17:26
> >> Subject: Re: [libreoffice-users] --convert-to always fails silently on
> Ubuntu
> >>
> >> 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 28/03/2013, Jay Lozier <[hidden 
> >>> email]>
> wrote:
>  On 03/27/2013 10:57 PM, Graham Glass wrote:
> > Hi everyone,
> >
> > I just downloaded libreoffice 4 and installed it on a Mac (Lion) and
> > Linux
> > (Ubuntu). On the Mac, everything works exactly as I expected, and I
> can
> > easily convert documents to pdfs using the command line tool like
> this:
> >
> > /Applications/LibreOffice.app/Contents/MacOS/soffice --headless
> > --convert-to
> > pdf sample.ppt
> >
> > However, on Unbuntu, when I execute the equivalent command, it
> always
> > fails
> > quickly and silently with exit code 77 (Permission denied).
> >
> > /opt/libreoffice4.0/program/soffice --headless --convert-to pdf
> > sample.ppt
> >
> > This failure happens regardless of whether I am a regular user or
> > superuser.
> > I am not running libreoffice via a user interface, and this command
> is
> > being
> > executed on an Amazon EC2 headless machine.
> >
> > Can someone offer any advice, either a method to get more error
> > information
> > (such as a log file or a verbose flag) so I can figure out what's
> going
> > on?
> > I'm sure it's a simple issue, but right now the lack of error
> reporting
> > is
> > making it hard to get the issue resolved.
> >
> > Thanks in advance!
> >
> > Cheers,
> > Graham
> >
> >
> >
> > --
> > View this message in context:
> >
> http://nabble.documentfoundation.org/convert-to-always-fails-silently-on-Ubuntu-tp4046531.html
> > Sent from the Users mailing list archive at Nabble.com.
> >
>  Graham,
> 
>  Try the command prefixed with sudo.
> 
>  --
>  Jay Lozier
>  [hidden email] 
> 
> 
>  --
>  For unsubscribe instructions e-mail to: [hidden 
>  email]
>  Problems?
>  http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>  Posting guidelines + more:
> http://wiki.documentfoundation.org/Netiquette
>  List archive: http://listarchives.libreoffice.org/global/users/
>  All messages sent to this list will be publicly archived and cannot
> be
>  deleted
> 
> 
> >>
> >> --
> >> Jay Lozier
> >> [hidden email] 
> >>
> >>
> >> --
> >> For unsubscribe instructions e-mail to: [hidden 
> >> email]
> >> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> >> Posting guidelines + more:
> http://wiki.documentfoundation.org/Netiquette
> >> List archive: http://listarchives.libreoffice.org/global/users/
> >> All messages sent to this list will be publicly archived and cannot be
> deleted
> >>
> >>
> >>
> >>
>
>
> --
> Jay Lozier
> [hidden email] 
>
>
> --
> For unsubscribe instructions e-mail to: [hidden 
> email]
> Problems?
> http://w

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

[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 folder - I have to look the 
exact switches, etc. I have seen this issue crop up occasionally were a 
folder tree does not have the permissions set to allow something like this.






From: Jay Lozier 
To: Kieran Peckett 
Cc: users@global.libreoffice.org
Sent: Thursday, 28 March 2013, 17:26
Subject: Re: [libreoffice-users] --convert-to always fails silently on Ubuntu

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 28/03/2013, Jay Lozier  wrote:

On 03/27/2013 10:57 PM, Graham Glass wrote:

Hi everyone,

I just downloaded libreoffice 4 and installed it on a Mac (Lion) and
Linux
(Ubuntu). On the Mac, everything works exactly as I expected, and I can
easily convert documents to pdfs using the command line tool like this:

/Applications/LibreOffice.app/Contents/MacOS/soffice --headless
--convert-to
pdf sample.ppt

However, on Unbuntu, when I execute the equivalent command, it always
fails
quickly and silently with exit code 77 (Permission denied).

/opt/libreoffice4.0/program/soffice --headless --convert-to pdf
sample.ppt

This failure happens regardless of whether I am a regular user or
superuser.
I am not running libreoffice via a user interface, and this command is
being
executed on an Amazon EC2 headless machine.

Can someone offer any advice, either a method to get more error
information
(such as a log file or a verbose flag) so I can figure out what's going
on?
I'm sure it's a simple issue, but right now the lack of error reporting
is
making it hard to get the issue resolved.

Thanks in advance!

Cheers,
Graham



--
View this message in context:
http://nabble.documentfoundation.org/convert-to-always-fails-silently-on-Ubuntu-tp4046531.html
Sent from the Users mailing list archive at Nabble.com.


Graham,

Try the command prefixed with sudo.

--
Jay Lozier
jsloz...@gmail.com


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted




--
Jay Lozier
jsloz...@gmail.com


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted







--
Jay Lozier
jsloz...@gmail.com


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] calc problem

[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 improve LibreOffice's 
handling of Xls files but the answer to that is just "No" and that solves the 
problem.
Regards from
Tom :)


IMHO it not necessarily a bug but certainly a feature request.






From: Tim Lloyd 
To: nvrk 
Cc: users@global.libreoffice.org
Sent: Thursday, 28 March 2013, 3:23
Subject: Re: [libreoffice-users] calc problem

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 is preferred to the .csv
version from the afr.com site?
nvsoar

On Wed, Mar 27, 2013 at 5:47 PM, Michael Wu  wrote:


On Tue, Mar 26, 2013 at 7:44 AM, Tim Lloyd mailto:tim.ll...@gmx.com>> wrote:

   Hi, before I log this as a bug I would like to know whether anyone
   has seen it before/potential fix identified.

   I normally use Fedora linux and I download (.XLS) share tables
   from a financial newspaper here in Oz. Yesterday I inadvertently
   clicked on the wrong table by accident and tried to open it. Calc
   locked up! No problem with the files I normally look at, Calc
   opened them fine.

   So I tried again today and waited for an error - "LibreOffice
   4.0.1.2 General input/output error". So I hopped over to the
   windows PC and tried LO portable. Same error. The error was
   repeated whether I tried to open directly from the website or if I
   saved to disk and then attempted to open the file. MS Excel has no
   problems.

   The file in question is accessible using this link:

   http://www.afr.com/share_tables/

   Just click on the xls link next to "Warrant Market"

   Any comments?

   Cheers



Hi Tim,

Since you use Fedora Linux, maybe you can try gnumeric as a temporary
alternative.

Hope it helps and regards,

Michael

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted



--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted







--
Jay Lozier
jsloz...@gmail.com


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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.' -- Erasmus

Yes, there is. Go to the File-->Templates-->Organize. Open the document 
you want to copy from in one window, and then the document/Template you 
want to copy to in the other, and click and drag. I explain it with 
screenshots here:


http://www.ahuka.com/?page_id=461

Regards,

--
Kevin B. O'Brien
zwil...@zwilnik.com
A damsel with a dulcimer in a vision once I saw.


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 
>To: Kieran Peckett  
>Cc: users@global.libreoffice.org 
>Sent: Thursday, 28 March 2013, 17:26
>Subject: Re: [libreoffice-users] --convert-to always fails silently on Ubuntu
> 
>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 28/03/2013, Jay Lozier  wrote:
>>> On 03/27/2013 10:57 PM, Graham Glass wrote:
 Hi everyone,

 I just downloaded libreoffice 4 and installed it on a Mac (Lion) and
 Linux
 (Ubuntu). On the Mac, everything works exactly as I expected, and I can
 easily convert documents to pdfs using the command line tool like this:

 /Applications/LibreOffice.app/Contents/MacOS/soffice --headless
 --convert-to
 pdf sample.ppt

 However, on Unbuntu, when I execute the equivalent command, it always
 fails
 quickly and silently with exit code 77 (Permission denied).

 /opt/libreoffice4.0/program/soffice --headless --convert-to pdf
 sample.ppt

 This failure happens regardless of whether I am a regular user or
 superuser.
 I am not running libreoffice via a user interface, and this command is
 being
 executed on an Amazon EC2 headless machine.

 Can someone offer any advice, either a method to get more error
 information
 (such as a log file or a verbose flag) so I can figure out what's going
 on?
 I'm sure it's a simple issue, but right now the lack of error reporting
 is
 making it hard to get the issue resolved.

 Thanks in advance!

 Cheers,
 Graham



 --
 View this message in context:
 http://nabble.documentfoundation.org/convert-to-always-fails-silently-on-Ubuntu-tp4046531.html
 Sent from the Users mailing list archive at Nabble.com.

>>> Graham,
>>>
>>> Try the command prefixed with sudo.
>>>
>>> --
>>> Jay Lozier
>>> jsloz...@gmail.com
>>>
>>>
>>> --
>>> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
>>> Problems?
>>> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>>> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
>>> List archive: http://listarchives.libreoffice.org/global/users/
>>> All messages sent to this list will be publicly archived and cannot be
>>> deleted
>>>
>>>
>
>
>-- 
>Jay Lozier
>jsloz...@gmail.com
>
>
>-- 
>For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
>Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
>List archive: http://listarchives.libreoffice.org/global/users/
>All messages sent to this list will be publicly archived and cannot be deleted
>
>
>
>
-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] copy styles from Writer document?

[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 to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 option: -v

Usage: soffice [options] [documents...]

Options:
--minimizedkeep startup bitmap minimized.
--invisibleno startup screen, no default document and no UI.
--norestoresuppress restart/restore after fatal errors.
--quickstart   starts the quickstart service
--nologo   don't show startup screen.
--nolockcheck  don't check for remote instances using the installation
--nodefaultdon't start with an empty document
--headless like invisible but no userinteraction at all.
--help/-h/-?   show this message and exit.
--version  display the version information.
--writer   create new text document.
--calc create new spreadsheet document.
--draw create new drawing.
--impress  create new presentation.
--base create new database.
--math create new formula.
--global   create new global document.
--web  create new HTML document.
-o open documents regardless whether they are templates or not.
-n always open documents as new files (use as template).

--display 
  Specify X-Display to use in Unix/X11 versions.
-p 
  print the specified documents on the default printer.
--pt  
  print the specified documents on the specified printer.
--view 
  open the specified documents in viewer-(readonly-)mode.
--show 
  open the specified presentation and start it immediately
--accept=
  Specify an UNO connect-string to create an UNO acceptor through which
  other programs can connect to access the API
--unaccept=
  Close an acceptor that was created with --accept=
  Use --unnaccept=all to close all open acceptors
--infilter=
  Force an input filter type if possible
  Eg. --infilter="Calc Office Open XML"
--convert-to output_file_extension[:output_filter_name] [--outdir
output_dir] files
  Batch convert files.
  If --outdir is not specified then current working dir is used as
output_dir.
  Eg. --convert-to pdf *.doc
  --convert-to pdf:writer_pdf_Export --outdir /home/user *.doc
--print-to-file [-printer-name printer_name] [--outdir output_dir] files
  Batch print files to file.
  If --outdir is not specified then current working dir is used as
output_dir.
  Eg. --print-to-file *.doc
  --print-to-file --printer-name nasty_lowres_printer --outdir
/home/user *.doc

Remaining arguments will be treated as filenames or URLs of documents to
open.





On Thu, Mar 28, 2013 at 10:49 AM, Tom [via Document Foundation Mail
Archive]  wrote:

> 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 going wrong?
> Perhaps something like
>
> /opt/libreoffice4.0/program/soffice --headless -v --convert-to pdf
> sample.ppt
>
> I'm not sure if position matters but i think it doesn't.  If it does then
> i've probably put it in the wrong place.  You can find out more about the
> tags that can be used in Gnu&Linux by just using the tag
>
> -h
>
> or
>
> --help
>
> Btw the double - and full word seems to be the newer way but not everyone
> has caught up yet so sometimes programs still need the shorter tag or are
> happy with either.  Its getting less messy like that now but it takes time
> for an evolution like that to ripple outwards.  Machines in remote places
> might be worth holding back from radical upgrades just in case something
> does go wrong.  No-one wants to go for a long hike in space just to plug a
> keyboard in and sit doing coding work.
> Regards from
> Tom :)
>
>
>
>
>
>
> >
> > From: Graham Glass <[hidden 
> > email]>
>
> >To: [hidden email] 
> >Sent: Thursday, 28 March 2013, 2:57
> >Subject: [libreoffice-users] --convert-to always fails silently on Ubuntu
> >
> >Hi everyone,
> >
> >I just downloaded libreoffice 4 and installed it on a Mac (Lion) and
> Linux
> >(Ubuntu). On the Mac, everything works exactly as I expected, and I can
> >easily convert documents to pdfs using the command line tool like this:
> >
> >/Applications/LibreOffice.app/Contents/MacOS/soffice --headless
> --convert-to
> >pdf sample.ppt
> >
> >However, on Unbuntu, when I execute the equivalent command, it always
> fails
> >quickly and silently with exit code 77 (Permission denied).
> >
> >/opt/libreoffice4.0/program/soffice --headless --convert-to pdf
> sample.ppt
> >
> >This failure happens regardle

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

[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 going wrong?  Perhaps 
something like 

/opt/libreoffice4.0/program/soffice --headless -v --convert-to pdf sample.ppt

I'm not sure if position matters but i think it doesn't.  If it does then i've 
probably put it in the wrong place.  You can find out more about the tags that 
can be used in Gnu&Linux by just using the tag

-h 

or 

--help

Btw the double - and full word seems to be the newer way but not everyone has 
caught up yet so sometimes programs still need the shorter tag or are happy 
with either.  Its getting less messy like that now but it takes time for an 
evolution like that to ripple outwards.  Machines in remote places might be 
worth holding back from radical upgrades just in case something does go wrong.  
No-one wants to go for a long hike in space just to plug a keyboard in and sit 
doing coding work.  
Regards from
Tom :)  






>
> From: Graham Glass 
>To: users@global.libreoffice.org 
>Sent: Thursday, 28 March 2013, 2:57
>Subject: [libreoffice-users] --convert-to always fails silently on Ubuntu
> 
>Hi everyone,
>
>I just downloaded libreoffice 4 and installed it on a Mac (Lion) and Linux
>(Ubuntu). On the Mac, everything works exactly as I expected, and I can
>easily convert documents to pdfs using the command line tool like this:
>
>/Applications/LibreOffice.app/Contents/MacOS/soffice --headless --convert-to
>pdf sample.ppt
>
>However, on Unbuntu, when I execute the equivalent command, it always fails
>quickly and silently with exit code 77 (Permission denied). 
>
>/opt/libreoffice4.0/program/soffice --headless --convert-to pdf sample.ppt
>
>This failure happens regardless of whether I am a regular user or superuser.
>I am not running libreoffice via a user interface, and this command is being
>executed on an Amazon EC2 headless machine.
>
>Can someone offer any advice, either a method to get more error information
>(such as a log file or a verbose flag) so I can figure out what's going on?
>I'm sure it's a simple issue, but right now the lack of error reporting is
>making it hard to get the issue resolved.
>
>Thanks in advance!
>
>Cheers,
>Graham
>
>
>
>--
>View this message in context: 
>http://nabble.documentfoundation.org/convert-to-always-fails-silently-on-Ubuntu-tp4046531.html
>Sent from the Users mailing list archive at Nabble.com.
>
>-- 
>For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
>Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
>List archive: http://listarchives.libreoffice.org/global/users/
>All messages sent to this list will be publicly archived and cannot be deleted
>
>
>
>
-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 28/03/2013, Jay Lozier  wrote:

On 03/27/2013 10:57 PM, Graham Glass wrote:

Hi everyone,

I just downloaded libreoffice 4 and installed it on a Mac (Lion) and
Linux
(Ubuntu). On the Mac, everything works exactly as I expected, and I can
easily convert documents to pdfs using the command line tool like this:

/Applications/LibreOffice.app/Contents/MacOS/soffice --headless
--convert-to
pdf sample.ppt

However, on Unbuntu, when I execute the equivalent command, it always
fails
quickly and silently with exit code 77 (Permission denied).

/opt/libreoffice4.0/program/soffice --headless --convert-to pdf
sample.ppt

This failure happens regardless of whether I am a regular user or
superuser.
I am not running libreoffice via a user interface, and this command is
being
executed on an Amazon EC2 headless machine.

Can someone offer any advice, either a method to get more error
information
(such as a log file or a verbose flag) so I can figure out what's going
on?
I'm sure it's a simple issue, but right now the lack of error reporting
is
making it hard to get the issue resolved.

Thanks in advance!

Cheers,
Graham



--
View this message in context:
http://nabble.documentfoundation.org/convert-to-always-fails-silently-on-Ubuntu-tp4046531.html
Sent from the Users mailing list archive at Nabble.com.


Graham,

Try the command prefixed with sudo.

--
Jay Lozier
jsloz...@gmail.com


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted





--
Jay Lozier
jsloz...@gmail.com


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] calc problem

[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 but the answer to that is just "No" and 
that solves the problem.
Regards from 
Tom :)  





>
> From: Tim Lloyd 
>To: nvrk  
>Cc: users@global.libreoffice.org 
>Sent: Thursday, 28 March 2013, 3:23
>Subject: Re: [libreoffice-users] calc problem
> 
>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 is preferred to the .csv
>> version from the afr.com site?
>> nvsoar
>>
>> On Wed, Mar 27, 2013 at 5:47 PM, Michael Wu  wrote:
>>
> On Tue, Mar 26, 2013 at 7:44 AM, Tim Lloyd  > wrote:
>
>      Hi, before I log this as a bug I would like to know whether anyone
>      has seen it before/potential fix identified.
>
>      I normally use Fedora linux and I download (.XLS) share tables
>      from a financial newspaper here in Oz. Yesterday I inadvertently
>      clicked on the wrong table by accident and tried to open it. Calc
>      locked up! No problem with the files I normally look at, Calc
>      opened them fine.
>
>      So I tried again today and waited for an error - "LibreOffice
>      4.0.1.2 General input/output error". So I hopped over to the
>      windows PC and tried LO portable. Same error. The error was
>      repeated whether I tried to open directly from the website or if I
>      saved to disk and then attempted to open the file. MS Excel has no
>      problems.
>
>      The file in question is accessible using this link:
>
>      http://www.afr.com/share_tables/
>
>      Just click on the xls link next to "Warrant Market"
>
>      Any comments?
>
>      Cheers
>
>
>>> Hi Tim,
>>>
>>> Since you use Fedora Linux, maybe you can try gnumeric as a temporary
>>> alternative.
>>>
>>> Hope it helps and regards,
>>>
>>> Michael
>>>
>>> --
>>> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
>>> Problems?
>>> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>>> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
>>> List archive: http://listarchives.libreoffice.org/global/users/
>>> All messages sent to this list will be publicly archived and cannot be
>>> deleted
>>>
>
>
>-- 
>For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
>Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
>List archive: http://listarchives.libreoffice.org/global/users/
>All messages sent to this list will be publicly archived and cannot be deleted
>
>
>
>
-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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  wrote:
> On 03/27/2013 10:57 PM, Graham Glass wrote:
>> Hi everyone,
>>
>> I just downloaded libreoffice 4 and installed it on a Mac (Lion) and
>> Linux
>> (Ubuntu). On the Mac, everything works exactly as I expected, and I can
>> easily convert documents to pdfs using the command line tool like this:
>>
>> /Applications/LibreOffice.app/Contents/MacOS/soffice --headless
>> --convert-to
>> pdf sample.ppt
>>
>> However, on Unbuntu, when I execute the equivalent command, it always
>> fails
>> quickly and silently with exit code 77 (Permission denied).
>>
>> /opt/libreoffice4.0/program/soffice --headless --convert-to pdf
>> sample.ppt
>>
>> This failure happens regardless of whether I am a regular user or
>> superuser.
>> I am not running libreoffice via a user interface, and this command is
>> being
>> executed on an Amazon EC2 headless machine.
>>
>> Can someone offer any advice, either a method to get more error
>> information
>> (such as a log file or a verbose flag) so I can figure out what's going
>> on?
>> I'm sure it's a simple issue, but right now the lack of error reporting
>> is
>> making it hard to get the issue resolved.
>>
>> Thanks in advance!
>>
>> Cheers,
>> Graham
>>
>>
>>
>> --
>> View this message in context:
>> http://nabble.documentfoundation.org/convert-to-always-fails-silently-on-Ubuntu-tp4046531.html
>> Sent from the Users mailing list archive at Nabble.com.
>>
> Graham,
>
> Try the command prefixed with sudo.
>
> --
> Jay Lozier
> jsloz...@gmail.com
>
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] booklet printing problem

[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. Pages 2 and 3 are similarly affected.

The settings I use are the same as for LO 3.5. The layout image in the
Print dialogue box is the same as in 3.5 so, everything being equal, I
should get the right result. But I don't.


"Same setting" does not help us, because we do not know your setting. 
Booklet printing works for me, so perhaps I describe my way and you 
can compare it to your way.


Precondition: You document is written in A5. Your printer can duplex 
printing.


That's interesting.  I've always prepared my documents in A4 (since some 
of my collaborators want an A4 rather than a A5 booklet) and then 
printed in brochure format, which gives me 2 A5 on a landscape A4.




1. In normal view use LO print dialog via File > Print.
2. Click on printer properties to get the dialog of your printer 
driver. Set your printer to use DIN A4 paper. In finishing set the 
orientation to landscape, and enable duplex printing on printer. OK.
There's also a setting in my printer properties to choose short-edge' or 
'long-edge' binding for duplex.  Short edge works for me.


3. In LO print dialog click on tab 'Page Layout' and there on option 
'brochure'.

4. OK to print

If your printer cannot duplex printing you need to turn the sheets 
manually. The printer manual should have a guide for that. For me it 
would be in addition to the settings above:
Step 1: Set 'front page' in drop down 'Includes' on the tab 'Page 
Layout'. Print.

Step 2: Put the sheets back into the tray.
Step 3: Set 'back page' in drop down 'Includes' on the tab 'Page 
Layout' and mark 'In reverse page order' on tab 'General'. Print.


Kind regards
Regina


Other than the above A4 difference, this has worked in LO 3.6 and LO 4

John

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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
 > * choose Properties
 > * choose device
 > * Printer Language type -- you may need to re-adjust the type to 
suit your printer.

 > You may have to experiment with this until you get it right.


Thank you, Marc,

There was no difference in the output. Each choice produced a perfect 
PDF replica of
the ODT file but Adobe Reader imposes wider margins when it prints to 
a hard copy.


If I could get LO to print in the right orientation when I ask it to 
print a booklet

I wouldn't need to mess around with PDF format


Jeff



I tried to print a series of test pages (8 pages in length) and then 
sent to print
with the "brochure" choice tagged. As you pointed out I got the same 
results as you
described in your original post. HOWEVER, I then reprinted a second 
time and for some
reason the print went according to what I would expect and the 
booklet was printed

without a problem.

I tried to replicate this again, but I could not do it. I tried 
different settings,

but again, could not reproduce it.

One explanation could be that the LibreOffice profile may have 
something to do with
this (maybe erasing it or forcing a new one by re-labelling your 
profile with another

name). I am not sure.

BTW ... I installed the v.4.0.2.1 build of LibreOffice as I am also 
testing it for
bugs. This is the version I test tried my file. I am not sure if this 
would correct

the problem.

Cheers,

Marc




==

Marc,

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.


At the rate I am going I might remove 4.0.1.2 and revert to 3.5 - but 
that would be to admit defeat :-)



Cheers,

Jeff





The Margins issue might be part of the "page scale" option - i.e. 
"shrink to page size" and "fit to page size" type of options.  I have 
the same problem with brochures if I do not turn that option off.




--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[Tom Davies]

Hi :)
Blimey!  Good timing! :)

Regards from
Tom :)  





>
> From: Thorsten Behrens 
>To: LibreOffice ; 
>l...@global.libreoffice.org; proje...@global.libreoffice.org; 
>libreoffice...@lists.freedesktop.org 
>Sent: Thursday, 28 March 2013, 9:59
>Subject: [libreoffice-l10n] [ANN] LibreOffice 4.0.2 RC2 available
> 
>Dear Community,
>
>The Document Foundation is pleased to announce the second release
>candidate of our upcoming LibreOffice 4.0.2. This will be the second
>in a series of frequent updates to our feature-packed 4.0
>branch. Please be aware that LibreOffice 4.0.2 RC2 is not ready for
>production use, you should continue to use LibreOffice 4.0.1 for that.
>
>The release is available for Windows, Linux and Mac OS X from our QA
>builds download page at
>
>  http://www.libreoffice.org/download/pre-releases/
>
>Should you find bugs, please report them to the FreeDesktop Bugzilla:
>
>  https://bugs.freedesktop.org
>
>A good way to assess the release candidate quality is to run some
>specific manual tests on it, our TCM wiki page has more details:
>
>http://wiki.documentfoundation.org/QA/Testing/Regression_Tests#Full_Regression_Test
>
>  - or checkout our manual test database for starting right away -
>
>http://manual-test.libreoffice.org/runtests/
>
>As usual, this update is accompanied with a new version of the Impress
>Remote - if you would like to test, an updated Android package is
>available here:
>
>http://downloadarchive.documentfoundation.org/libreoffice/old/sdremote-1.0.6/playstore/ImpressRemote.apk
>(and note https://wiki.documentfoundation.org/Development/Impress/RemoteHowTo)
>
>For other ways to get involved with this exciting project - you can
>e.g. contribute code:
>
>  http://www.libreoffice.org/get-involved/developers/
>
>translate LibreOffice to your language:
>
>  http://wiki.documentfoundation.org/LibreOffice_Localization_Guide
>
>or help with funding our operations:
>
>  http://donate.libreoffice.org/
>
>A list of known issues and fixed bugs with 4.0.2 RC2 is available
>from our wiki:
>
>  http://wiki.documentfoundation.org/Releases/4.0.2/RC2
>
>Let us close again with a BIG Thank You! to all of you having
>contributed to the LibreOffice project - this release would not have
>been possible without your help.
>
>Yours,
>
>The Document Foundation Board of Directors
>
>The Document Foundation, Zimmerstr. 69, 10117 Berlin, Germany
>Rechtsfähige Stiftung des bürgerlichen Rechts
>Legal details: http://www.documentfoundation.org/imprint
>
>-- 
>Unsubscribe instructions: E-mail to l10n+h...@global.libreoffice.org
>Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
>List archive: http://listarchives.libreoffice.org/global/l10n/
>All messages sent to this list will be publicly archived and cannot be deleted
>
>
>
>
-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[Tom Davies]

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 alpha-test version if you help with QA for a bit which might also be a good 
way of getting something done about your problem more quickly.  

Regards from 

Tom :)  






>
> From: Jeff Shrowder 
>
>
>
>
>> I tried to replicate this again, but I could not do it. I tried different 
>> settings,
>> but again, could not reproduce it.
>>
>> One explanation could be that the LibreOffice profile may have something to 
>> do with
>> this (maybe erasing it or forcing a new one by re-labelling your profile 
>> with another
>> name). I am not sure.
>>
>> BTW ... I installed the v.4.0.2.1 build of LibreOffice as I am also testing 
>> it for
>> bugs. This is the version I test tried my file. I am not sure if this would 
>> correct
>> the problem.
>>
>> Cheers,
>>
>> Marc
>>
>>
>
>==
>
>Marc,
>
>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.
>
>At the rate I am going I might remove 4.0.1.2 and revert to 3.5 - but that 
>would be 
>to admit defeat :-)
>
>
>Cheers,
>
>Jeff
>
>
>
>-- 
>For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
>Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
>List archive: http://listarchives.libreoffice.org/global/users/
>All messages sent to this list will be publicly archived and cannot be deleted
>
>
>
>
-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[Tom Davies]

Hi :)
Congrats and thanks for posting the answer back into the thread.  


I think that is a fairly perfect way to deal with a problem;
2.  post a question
3.  start looking into documentation and searches more deeply
4. race against everyone else on the list to get your answer up there first.  


Thanks, congrats and regards from
Tom :)  






>
> From: Ian Whitfield 
>To: users@global.libreoffice.org 
>Sent: Thursday, 28 March 2013, 12:11
>Subject: Re: [libreoffice-users] Re: Base stuck in Read Only mode??
> 
>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.
>
>Thanks for the help.
>
>IanW
>Pretoria RSA
>
>
-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] booklet printing problem

[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 settings I use are the same as for LO 3.5. The layout image in the
Print dialogue box is the same as in 3.5 so, everything being equal, I
should get the right result. But I don't.


"Same setting" does not help us, because we do not know your setting. 
Booklet printing works for me, so perhaps I describe my way and you can 
compare it to your way.


Precondition: You document is written in A5. Your printer can duplex 
printing.

1. In normal view use LO print dialog via File > Print.
2. Click on printer properties to get the dialog of your printer driver. 
Set your printer to use DIN A4 paper. In finishing set the orientation 
to landscape, and enable duplex printing on printer. OK.
3. In LO print dialog click on tab 'Page Layout' and there on option 
'brochure'.

4. OK to print

If your printer cannot duplex printing you need to turn the sheets 
manually. The printer manual should have a guide for that. For me it 
would be in addition to the settings above:
Step 1: Set 'front page' in drop down 'Includes' on the tab 'Page 
Layout'. Print.

Step 2: Put the sheets back into the tray.
Step 3: Set 'back page' in drop down 'Includes' on the tab 'Page Layout' 
and mark 'In reverse page order' on tab 'General'. Print.


Kind regards
Regina

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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.


Thanks for the help.

IanW
Pretoria RSA

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: booklet printing problem

[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 Language type -- you may need to re-adjust the type to suit your 
printer.
 > You may have to experiment with this until you get it right.


Thank you, Marc,

There was no difference in the output. Each choice produced a perfect PDF 
replica of
the ODT file but Adobe Reader imposes wider margins when it prints to a hard 
copy.

If I could get LO to print in the right orientation when I ask it to print a 
booklet
I wouldn't need to mess around with PDF format


Jeff



I tried to print a series of test pages (8 pages in length) and then sent to 
print
with the "brochure" choice tagged. As you pointed out I got the same results as 
you
described in your original post. HOWEVER, I then reprinted a second time and 
for some
reason the print went according to what I would expect and the booklet was 
printed
without a problem.

I tried to replicate this again, but I could not do it. I tried different 
settings,
but again, could not reproduce it.

One explanation could be that the LibreOffice profile may have something to do 
with
this (maybe erasing it or forcing a new one by re-labelling your profile with 
another
name). I am not sure.

BTW ... I installed the v.4.0.2.1 build of LibreOffice as I am also testing it 
for
bugs. This is the version I test tried my file. I am not sure if this would 
correct
the problem.

Cheers,

Marc




==

Marc,

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.


At the rate I am going I might remove 4.0.1.2 and revert to 3.5 - but that would be 
to admit defeat :-)



Cheers,

Jeff



--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: booklet printing problem

[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 type to suit 
your printer.

> You may have to experiment with this until you get it right.


Thank you, Marc,

There was no difference in the output. Each choice produced a perfect 
PDF replica of the ODT file but Adobe Reader imposes wider margins when 
it prints to a hard copy.


If I could get LO to print in the right orientation when I ask it to 
print a booklet I wouldn't need to mess around with PDF format



Jeff



I tried to print a series of test pages (8 pages in length) and then 
sent to print with the "brochure" choice tagged. As you pointed out I 
got the same results as you described in your original post. HOWEVER, I 
then reprinted a second time and for some reason the print went 
according to what I would expect and the booklet was printed without a 
problem.


I tried to replicate this again, but I could not do it. I tried 
different settings, but again, could not reproduce it.


One explanation could be that the LibreOffice profile may have something 
to do with this (maybe erasing it or forcing a new one by re-labelling 
your profile with another name). I am not sure.


BTW ... I installed the v.4.0.2.1 build of LibreOffice as I am also 
testing it for bugs. This is the version I test tried my file. I am not 
sure if this would correct the problem.


Cheers,

Marc

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 again and have a nice day, everyone
-- 
Best regards
Mirosław Zalewski

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted