Re: [libreoffice-users] trouble with Page Styles and Fields in Writer

[Cor Nouws]

James wrote (30-08-11 03:50)

It is confusing because it's wrong behaviour, if it forces people to
print it, then it should be visible in editing mode.


It is not forced. A explained, you can set it to print or not the  empty 
pages that are automatically inserted blanc pages (tools > Options as 
well as the print dialog, 2nd tab)

Hmm, maybe it should be turned off by default ..


Why do the developers assume something is always going to be printed or
put on the web?


Well, I guess we have to go back to 1995 or so, to find that out ;-) But 
I guess it is designed with large production/documents in mind, that get 
printed double sided (not to waste paper, even then).


Cheers,

--
 - Cor
 - http://nl.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] New to Group, and so checking on Browser Plug-in

[Tom Davies]

Hi :)
Maybe about 5mins for the full book.  On mine it took 15 seconds to reach the 
grey-out inside the tab and just under 30 seconds to display the Getting 
Started 
guide.  More than 10secs feels like "forever" of course.  


The wiki-page shows the approximate number of pages in each guide
http://wiki.documentfoundation.org/Documentation
which might help you guess at roughly how long each might take.  

Just out of curiosity which version of java are you using?
Tools - Options - LibreOffice - Java
The 2.6.0_21 is the best with the _20 and _22 being good 2nd best and the more 
recent ones, such as _24 and _26, being completely hopeless.  I don't think 
java 
is the issue here.  I just don't know tbh.  


Are other things taking ages to start-up, such as YouTube videos and stuff?  
How 
about other apps?  Does it take ages to open-up LibreOffice normally?  Is it 
faster 2nd time, after you close and re-open?  Have you cleared "private data" 
such as temp folders, history and stuff in FireFox?  Have you defragged you 
system lately?

Also, a little while ago, someone was asking about which plug-in to use to make 
it possible to view documents inside FireFox and i only knew how to do that in 
Gnu&Linux, not Windows.  In Firefox 

Tools - Add-ons - Plug-ins
do you also have "OpenOffice.org Plug in"?  I tried using that pop-up to do a 
search in FireFox add-ons to try to find the proper name of the plug-in but 
couldn't find it listed there.  Presumably it's an option given during install? 
 
Did you do a "Custom" install?  I was thinking that maybe it's one of the extra 
files in the download bundle?  Luckily i think the person only wanted to know 
for Gnu&Linux so we were able to help but it would be good to know for future 
reference.

How long is it taking to reach the grey-out stage?
God luck, thanks and regards from
Tom :)




From: Dave Barton 
To: users@global.libreoffice.org
Sent: Tue, 30 August, 2011 1:49:39
Subject: Re: [libreoffice-users] New to Group, and so checking on Browser 
Plug-in

 Original Message  
From: webmaster for Kracked Press Productions 
To: users@global.libreoffice.org
Date: Mon, 29 Aug 2011 20:21:04 -0400

> On 08/29/2011 07:35 PM, Dave Barton wrote:
>>  Original Message  
>> From: Tom Davies
>> To: users@global.libreoffice.org
>> Date: Mon, 29 Aug 2011 13:35:05 +0100
>>
>>> Hi :)
>>> If you open the manuals/guides by doing a right-click and then "open
>>> in a new
>>> tab" then you can give it plenty of time to open.  The full books
>>> take ages to
>>> download but the individual chapters should only take a couple of
>>> minutes.
>>> Where the web-pages normally appear, ie inside the tab, will be grey
>>> until the
>>> chapter/book has downloaded.
>>>
>>>
>>> Are you using Internet Explorer or Firefox?
>>> Regards from
>>> Tom :)
>> Hi Tom,
>>
>> Using FF 6 with LO 3.4.2 on Win 7 x64. How many days, weeks, years ;) do
>> you recommend we wait for the blank tab to display the document (eg.
>> chapter 1 of the GS guide)? Identical result with LO 3.3 on a Linux box.
>>
>> I agree with Tim about the value of viewing documents in a web browser,
>> but if we are going to offer a non-experimental function it should work.
>>
>> Regards
>> Dave
> I do not remember when I first found out that .odt files open in Firefox.
> I found out by accident when downloading a LO file.

IIRC this "feature" was introduced somewhere around the end of OOo v2
and start of v3 series.
-- 
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] No hatched cell background? Why?

[Onyeibo Oku]

In M$-Excel, cell backgrounds can be hatched. The printout is solid and that 
makes for nicer photocopied documents. LibO provides color backgrounds only. Is 
this by intention or are there plans to include that feature?

For now - I gray-out cells that are usually hatched. Some photocoping machines 
here don't pick tones very well. The result is a fake-looking document. This is 
saddening.

-
from twohot@device.mobile :)

-- 
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: Calc row filter extraction

[Andreas Säger]

Yes, I do agree

But when there is only one table, Calc will do the job, no ?

No need to use a hammer to slam a fly...

Regards from Olivier

That's why I linked a data pilot tutorial. Apart from that, a single table
in a database is not a hammer and much easier to maintain in the long run
(and you can create data pilots from it)


Le 28/08/2011 21:12, Andreas Säger a écrit :
> What you do in that spreadsheet would be a 100% database task. The data
> pilot
> is Calc's most database-ish tool.
>
> http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/DataPilot
> http://user.services.openoffice.org/en/forum/download/file.php?id=8592
>
> --


--
View this message in context: 
http://nabble.documentfoundation.org/Calc-row-filter-extraction-tp3207632p3294384.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

[libreoffice-users] Re: strikethrough in draw

[NoOp]

On 08/29/2011 03:24 AM, Andre wrote:
> Hi all,
> it seems like a simple question, but maybe not. In Draw, I want to 
> strikethrough
> the text of a connector shape. I can choose the option from the
> context/character menu of the shape but nothing happens on the screen. Same 
> with
> underlining. Has anyone experienced this and knows a solution?

Select the characters: Format|Character|Font Effects|Strikethrough:
single. Does this not work for you?

If not, then perhaps I'm misunderstanding what you want to do. So if you
can explain the steps in detail of what you are doing then I (or others)
can help.





-- 
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] trouble with Page Styles and Fields in Writer

[James]

On 08/29/11 19:05, Brian Barker wrote:

At 16:12 29/08/2011 -0400, James Lockie wrote:
There are 3 physical pages but I set the starting page# to 1 on the 
FirstPage so I expect Page-Count to start from there.  There is no 
way it should even have Page-Count=4.


At 08:26 30/08/2011 +1200, Steve Edmonds wrote:
LO just can't count.  [...]  Page Count is total pages, [...] 5 is 
definitely wrong and so is 4 as there are only 3 pages. That's a bug 
somewhere.


I can explain this bit, which LibreOffice will not see as a bug.  
Writer considers that you may wish to print your document 
double-sided.  You have set your second page ("first page") to be 
numbered "1", an odd number, and Writer decides that you will 
therefore want this to be a recto (or right-hand page), not the verso 
(or left-hand page) that it would otherwise be.  To achieve this, it 
notionally inserts a blank page between "cover page" and "first 
page".  Including this blank page, you do indeed now have four pages, 
not three.

Is there any way to just have pages that are not right or left pages?


In editing mode, you do not see the blank page, and this may be confusing.
It is confusing because it's wrong behaviour, if it forces people to 
print it, then it should be visible in editing mode.



  But you can see it in Page Preview.  You will want the page to print 
(as it were) if you are printing double-sided but not if you are 
printing single-sided.  You can control this at Tools | Options... | 
LibreOffice Writer | Print | Other | Print automatically inserted 
blank pages.  Alternatively you can reach the same dialogue on the fly 
via the Options... button in the Print dialogue.


Oh, and I'm not advocating this arrangement, merely describing it.

Thanks.
Why do the developers assume something is always going to be printed or 
put on the web?

Maybe there should be a View->PDF Layout.


Brian Barker





--
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] New to Group, and so checking on Browser Plug-in

[Dave Barton]

 Original Message  
From: webmaster for Kracked Press Productions 
To: users@global.libreoffice.org
Date: Mon, 29 Aug 2011 20:21:04 -0400

> On 08/29/2011 07:35 PM, Dave Barton wrote:
>>  Original Message  
>> From: Tom Davies
>> To: users@global.libreoffice.org
>> Date: Mon, 29 Aug 2011 13:35:05 +0100
>>
>>> Hi :)
>>> If you open the manuals/guides by doing a right-click and then "open
>>> in a new
>>> tab" then you can give it plenty of time to open.  The full books
>>> take ages to
>>> download but the individual chapters should only take a couple of
>>> minutes.
>>> Where the web-pages normally appear, ie inside the tab, will be grey
>>> until the
>>> chapter/book has downloaded.
>>>
>>>
>>> Are you using Internet Explorer or Firefox?
>>> Regards from
>>> Tom :)
>> Hi Tom,
>>
>> Using FF 6 with LO 3.4.2 on Win 7 x64. How many days, weeks, years ;) do
>> you recommend we wait for the blank tab to display the document (eg.
>> chapter 1 of the GS guide)? Identical result with LO 3.3 on a Linux box.
>>
>> I agree with Tim about the value of viewing documents in a web browser,
>> but if we are going to offer a non-experimental function it should work.
>>
>> Regards
>> Dave
> I do not remember when I first found out that .odt files open in Firefox.
> I found out by accident when downloading a LO file.

IIRC this "feature" was introduced somewhere around the end of OOo v2
and start of v3 series.


-- 
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] New to Group, and so checking on Browser Plug-in

[webmaster for Kracked Press Productions]

On 08/29/2011 07:35 PM, Dave Barton wrote:

 Original Message  
From: Tom Davies
To: users@global.libreoffice.org
Date: Mon, 29 Aug 2011 13:35:05 +0100


Hi :)
If you open the manuals/guides by doing a right-click and then "open in a new
tab" then you can give it plenty of time to open.  The full books take ages to
download but the individual chapters should only take a couple of minutes.
Where the web-pages normally appear, ie inside the tab, will be grey until the
chapter/book has downloaded.


Are you using Internet Explorer or Firefox?
Regards from
Tom :)

Hi Tom,

Using FF 6 with LO 3.4.2 on Win 7 x64. How many days, weeks, years ;) do
you recommend we wait for the blank tab to display the document (eg.
chapter 1 of the GS guide)? Identical result with LO 3.3 on a Linux box.

I agree with Tim about the value of viewing documents in a web browser,
but if we are going to offer a non-experimental function it should work.

Regards
Dave

I do not remember when I first found out that .odt files open in Firefox.
I found out by accident when downloading a LO file.







--
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] New to Group, and so checking on Browser Plug-in

[Dave Barton]

 Original Message  
From: Tom Davies 
To: users@global.libreoffice.org
Date: Mon, 29 Aug 2011 13:35:05 +0100

> Hi :)
> If you open the manuals/guides by doing a right-click and then "open in a new 
> tab" then you can give it plenty of time to open.  The full books take ages 
> to 
> download but the individual chapters should only take a couple of minutes.  
> Where the web-pages normally appear, ie inside the tab, will be grey until 
> the 
> chapter/book has downloaded.  
> 
> 
> Are you using Internet Explorer or Firefox?
> Regards from
> Tom :)

Hi Tom,

Using FF 6 with LO 3.4.2 on Win 7 x64. How many days, weeks, years ;) do
you recommend we wait for the blank tab to display the document (eg.
chapter 1 of the GS guide)? Identical result with LO 3.3 on a Linux box.

I agree with Tim about the value of viewing documents in a web browser,
but if we are going to offer a non-experimental function it should work.

Regards
Dave




-- 
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] trouble with Page Styles and Fields in Writer

[Brian Barker]

At 16:12 29/08/2011 -0400, James Lockie wrote:
There are 3 physical pages but I set the starting page# to 1 on the 
FirstPage so I expect Page-Count to start from there.  There is no 
way it should even have Page-Count=4.


At 08:26 30/08/2011 +1200, Steve Edmonds wrote:
LO just can't count.  [...]  Page Count is total pages, [...] 5 is 
definitely wrong and so is 4 as there are only 3 pages. That's a bug somewhere.


I can explain this bit, which LibreOffice will not see as a 
bug.  Writer considers that you may wish to print your document 
double-sided.  You have set your second page ("first page") to be 
numbered "1", an odd number, and Writer decides that you will 
therefore want this to be a recto (or right-hand page), not the verso 
(or left-hand page) that it would otherwise be.  To achieve this, it 
notionally inserts a blank page between "cover page" and "first 
page".  Including this blank page, you do indeed now have four pages, 
not three.


In editing mode, you do not see the blank page, and this may be 
confusing.  But you can see it in Page Preview.  You will want the 
page to print (as it were) if you are printing double-sided but not 
if you are printing single-sided.  You can control this at Tools | 
Options... | LibreOffice Writer | Print | Other | Print automatically 
inserted blank pages.  Alternatively you can reach the same dialogue 
on the fly via the Options... button in the Print dialogue.


Oh, and I'm not advocating this arrangement, merely describing it.

Brian Barker


--
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: trouble with Page Styles and Fields in Writer

[NoOp]

On 08/29/2011 01:12 PM, James wrote:
> On 08/29/11 15:39, webmaster for Kracked Press Productions wrote:
>> On 08/29/2011 02:16 PM, James wrote:
>>>
>>> I'm having a bit of trouble with Page Styles and Fields in Writer.
>>> It's a pretty simple test file.
>>> The current page Field works the way I want but the page count Field 
>>> is not what I want.
>>>
>>> http://lockie.ca/test/pageTest.odt.bz2
>>>
>>>
>> looked at your file.
>>
>> Try the following.
>>
>> Format > Page > Footer
>> check the "Footer On" box
>>
>> Then go to the first page footer with the footer page count.
>>
>> Insert > Field
>> There you have Page-Number and Page-Count options.
>>
>> That should help you.
>>
> It's not that I can't make a footer.
> I have the text
> "page " Field->Page-Number " of " Field->Page-Count
> and it displays:
> "page 2 of 4"
> 
> I want it to display "'page 2 of 2".
> 
> There are 3 physical pages but I set the starting page# to 1 on the 
> FirstPage so I expect Page-Count to start from there.
> There is no way it should even have Page-Count=4.
> 
> 


Perhaps this will help:





-- 
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] trouble with Page Styles and Fields in Writer

[Cor Nouws]

Steve Edmonds wrote (29-08-11 22:26)

No, I think you did it right as I get page count = 5 also. LO just can't
count.
I think what is required are some more statistics fields. Page Count is
total pages, 4 was correct, 5 is definately wrong and so is 4 as there
are only 3 pages. Thats a bug somewhere.


No, Writer starts pages with a new page style as right page, odd 
numbered. And inserts the even as hidden. Can be shown though, and 
turned of with printing too.



There needs also to be a "Pages since last count restart" or similar.


And maybe some more. Indeed, not that handy.

Regards,

--
 - Cor
 - http://nl.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] trouble with Page Styles and Fields in Writer

[Cor Nouws]

James wrote (29-08-11 22:14)


On the paragraph 'normal page' click Format > Paragraph, tab tex flow
and set the page number there to 1.


I must have done that wrong because it made Page-Count=5. :-(


Oh, sorry. It was my mistake. I thought you wanted to tweak the page 
number, not the page count.

To change the page-count ... no idea.
I looked at that years ago, and think I ended up with using a reference 
to the page number of a bookmark .. Not ideal.


Sorry for the confusion,

--
 - Cor
 - http://nl.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] trouble with Page Styles and Fields in Writer

[Steve Edmonds]

Hi.

On 30/08/11 8:14 AM, James wrote:

On 08/29/11 15:02, Cor Nouws wrote:

Hi James,

James wrote (29-08-11 20:16)

I'm having a bit of trouble with Page Styles and Fields in Writer.
It's a pretty simple test file.
The current page Field works the way I want but the page count Field is
not what I want.

http://lockie.ca/test/pageTest.odt.bz2


On the paragraph 'normal page' click Format > Paragraph, tab tex flow 
and set the page number there to 1.


Regards,


I must have done that wrong because it made Page-Count=5. :-(
No, I think you did it right as I get page count = 5 also. LO just can't 
count.
I think what is required are some more statistics fields. Page Count is 
total pages, 4 was correct, 5 is definately wrong and so is 4 as there 
are only 3 pages. Thats a bug somewhere.

There needs also to be a "Pages since last count restart" or similar.

--
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] Fedora 14 and Libreoffice

[Cor Nouws]

Hi Fabio,

Fabio Andrijauskas wrote (28-08-11 23:45)


   I installed the LibreOffice 3.4.2 on Fedora 14, but when i start the
software, the startup screen stops with the message "Enabling: Report
Builder"

   What i can do to start the libreoffice ?


Looks as if something goes wrong with trying to 'install' the extension 
on the first run.

Maybe some java related thing?
Of version of the report builder?

It is possible (...) to install without the report builder. That will 
bring you over that heap in the first place.


Kind regards.

--
 - Cor
 - http://nl.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] trouble with Page Styles and Fields in Writer

[James]

On 08/29/11 15:02, Cor Nouws wrote:

Hi James,

James wrote (29-08-11 20:16)

I'm having a bit of trouble with Page Styles and Fields in Writer.
It's a pretty simple test file.
The current page Field works the way I want but the page count Field is
not what I want.

http://lockie.ca/test/pageTest.odt.bz2


On the paragraph 'normal page' click Format > Paragraph, tab tex flow 
and set the page number there to 1.


Regards,


I must have done that wrong because it made Page-Count=5. :-(

--
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] trouble with Page Styles and Fields in Writer

[James]

On 08/29/11 15:39, webmaster for Kracked Press Productions wrote:

On 08/29/2011 02:16 PM, James wrote:


I'm having a bit of trouble with Page Styles and Fields in Writer.
It's a pretty simple test file.
The current page Field works the way I want but the page count Field 
is not what I want.


http://lockie.ca/test/pageTest.odt.bz2



looked at your file.

Try the following.

Format > Page > Footer
check the "Footer On" box

Then go to the first page footer with the footer page count.

Insert > Field
There you have Page-Number and Page-Count options.

That should help you.


It's not that I can't make a footer.
I have the text
"page " Field->Page-Number " of " Field->Page-Count
and it displays:
"page 2 of 4"

I want it to display "'page 2 of 2".

There are 3 physical pages but I set the starting page# to 1 on the 
FirstPage so I expect Page-Count to start from there.

There is no way it should even have Page-Count=4.


--
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] trouble with Page Styles and Fields in Writer

[webmaster for Kracked Press Productions]

On 08/29/2011 02:16 PM, James wrote:


I'm having a bit of trouble with Page Styles and Fields in Writer.
It's a pretty simple test file.
The current page Field works the way I want but the page count Field 
is not what I want.


http://lockie.ca/test/pageTest.odt.bz2



looked at your file.

Try the following.

Format > Page > Footer
check the "Footer On" box

Then go to the first page footer with the footer page count.

Insert > Field
There you have Page-Number and Page-Count options.

That should help you.

--
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] trouble with Page Styles and Fields in Writer

[Cor Nouws]

Hi James,

James wrote (29-08-11 20:16)

I'm having a bit of trouble with Page Styles and Fields in Writer.
It's a pretty simple test file.
The current page Field works the way I want but the page count Field is
not what I want.

http://lockie.ca/test/pageTest.odt.bz2


On the paragraph 'normal page' click Format > Paragraph, tab tex flow 
and set the page number there to 1.


Regards,

--
 - Cor
 - http://nl.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

[libreoffice-users] trouble with Page Styles and Fields in Writer

[James]

I'm having a bit of trouble with Page Styles and Fields in Writer.
It's a pretty simple test file.
The current page Field works the way I want but the page count Field is 
not what I want.


http://lockie.ca/test/pageTest.odt.bz2


--
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: 2Q -- WollMux for LibreOffice? -- Archives area?

[NoOp]

On 08/28/2011 10:28 PM, Russell Wilson wrote:
> The WollMux extension is listed on the extensions site but clicking
> on it leads to a page missing error.
> 
> When downloading and trying to install it from a third party, it says
> it's unable to be installed due to OOo not being installed.
> 
> 
> Will there be a version available for LO?
> 
> Is there an archives site where such basic questions can be searched?
> The mailing list signon doesn't mention any archives area.
> 
> bw Russell J. Wilson Dunedin, New Zealand

Download the 11.2d .oxt from here:
http://forge.osor.eu/frs/?group_id=11
Open LO and Tools|Extension Manager|Add - browse to the folder where you
saved the .oxt double-click to install.


-- 
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: Libre "Help" file in Windows 7

[Dave Sergeant]

On my Windows XP PC help is at 
c:\Program Files\Libre Office3.4\Basis\Help\en-GB
There is a large number of files and folders there.

Dave


On 29 Aug 2011 at 12:46, planas wrote:

> > A friend has installed Libre 3.4.2 on his Windows 7 computer.
> > He then installed the Libre Help file and Windows put it in Documents.
> > It does not work. Where should it be?
> 
> There is a default location for the help file that is used. I tried to
> locate a setting to remap the help files to another location but did not
> find one (on Linux). The simplest is to reinstall and accept the
> defaults. 


http://www.davesergeant.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] Libre "Help" file in Windows 7

[planas]

Tink

On Mon, 2011-08-29 at 04:15 -0700, Tinkerer wrote: 

> A friend has installed Libre 3.4.2 on his Windows 7 computer.
> He then installed the Libre Help file and Windows put it in Documents.
> It does not work.
> Where should it be?

There is a default location for the help file that is used. I tried to
locate a setting to remap the help files to another location but did not
find one (on Linux). The simplest is to reinstall and accept the
defaults. 

> BTW. I am a Mac user.
> 
> Tink.
> 
> --
> View this message in context: 
> http://nabble.documentfoundation.org/Libre-Help-file-in-Windows-7-tp3292418p3292418.html
> Sent from the Users mailing list archive at Nabble.com.
> 



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

[libreoffice-users] How to disable the mail-merge-wizard in LibreOffice?

[Claus Berghammer (Bugzilla)]

Hello LibreOffice Users,

I'm using a template with database-fields in it on a regularly basis, but don't 
want to print a mass-mailing. Currently I have to click NO every time again, 
when I am printing this document. In OOo it was possible to disable that 
Dialogue by adding some lines to Writer.xcu, but this file doesn't exist any 
more in current LibO Versions.

So, does anybody know how to disable that Dialogue in LibO?

Sincerely, Claus Berghammer

--
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: import data from FileMaker Pro?

[Alexander Thurgood]

Le 29/08/11 13:40, Paul Hochbaum a écrit :

Hi Paul,


> 
> do you have any idea, how to import data from FileMaker Pro databases in 
> order to convert them into a libre database?
> 

For the data, I have used CSV or SYLK in the past.
For the structure, export to *.BAS or *.MER (if those options are still
available) and then correct to fit the constraints accepted by Base.

Bear in mind that multi-valued fields, a favorite with FMPro
users/developers, are not directly transferable as these are not
supported by the HSQLDB backend engine.

Also, I seem to recall that the binary image fields of FMPro are not
importable either.

Date fields require validation/verification before importing into Base -
FMPro seemed to use non-standard date representation (but that would be
a general recommendation anyway, whatever the database).

Boolean fields can have 3 states in LO Base, True, False and Unset (i.e.
undetermined).

Multiple keys, if you have them, can sometimes be problematic.

Your field names should avoid extended latin characters, spaces and
punctuation such as question marks for best results. Such freedom of
choice is of course allowed in FMPro (or it was, unless Apple has
changed the way FMPro works).


Alex


-- 
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] 2Q -- WollMux for LibreOffice? -- Archives area?

[webmaster for Kracked Press Productions]

I Google-ed that extension and there was a lot of "talk" of issues with 
that extension and OOo.  I then went to the OOo extension site.  It 
seems that searching for "WollMux" list nothing now.



On 08/29/2011 06:24 AM, Tom Davies wrote:

Hi :)
The Nabble 'forum' is one way of viewing threads from the mailing list
http://nabble.documentfoundation.org/Users-f1639498.html
and there is a search feature at the top-right.

LibreOffice is just beta-testing it's own Extensions Web-page and there will be
an announcement about it soon to invite everyone to test it out.  It doesn't
have all the extensions as they are just being added but it might be worth
looking through
http://extensions-test.libreoffice.org

The OpenOffice.org site is very temperamental.  People are working hard to fix
it but until then just keep clicking on "Try again" until the page loads
successfully.  It's not ideal which is one reason why LibreOffice are going to
have it's own page.
Regards from
Tom :)





From: Russell Wilson
To: LibreOffice User Gp
Sent: Mon, 29 August, 2011 6:28:13
Subject: [libreoffice-users] 2Q -- WollMux for LibreOffice? -- Archives area?

The WollMux extension is listed on the extensions site but clicking on it leads
to a page missing error.

When downloading and trying to install it from a third party, it says it's
unable to be installed due to OOo not being installed.



Will there be a version available for LO?

Is there an archives site where such basic questions can be searched?  The
mailing list signon doesn't mention any archives area.

bw
Russell J. Wilson
Dunedin, New Zealand

'




--
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] Problem with data conversion

[webmaster for Kracked Press Productions]

Would you be willing to download/install 3.3.4 from 
http://www.libreoffice.org/download/?
I do not use the repository version, and I use Ubuntu 64bit 10.04.  You 
would need to install in via the terminal, but 
http://www.libreoffice.org/get-help/installation/linux/ will walk you 
through this.  No need to uninstall anything either.


I wonder if adding the language packs could help you?  You will need to 
go to 3.3.4, unless someone has archived the "nl - Nederlands" pack for 
3.3.3.  I do not understand Asian characters, so I do not know if there 
is a Mandarin language pack listed.


You could also try this Dutch dictionary and see it it works.
http://libreoffice-na.us/English/add-on-dictionaries-large-list/Dutch_spelling_and_hyphenation_Dictionary--nl-dict-v2.00g2010-09-22.oxt

As for the characters showing in LibreOffice - I am taking a guess here 
- could it be something to do with the default font you are using for 
LO's Calc?  Format > Character should place you to the dialog to set 
your default font.  I would make sure your font is set for the same one 
you use in the other applications.  As someone who has worked with 
collecting fonts [over 100,000 of them over the years] I find that many 
do not have some of the non-English characters that are common in other 
languages. I would make sure you use a good Unicode font [like Arial 
Unicode] and see if the problem goes away.


On 08/29/2011 04:22 AM, James Wilde wrote:

Can't think of a better subject line.

This is about the Ubuntu repository version of LibO running under Ubuntu 11.04 
linux.  The repository version is described as follows:

LibreOffice 3.3.3
OOO 330m 19 (Build:301)
LibreOffice 3.3.3.1 Ubuntu package 1.3.3.3ubuntu2

I have been testing Gnucash on linux, and in particular the ability to export 
data to an html file and read that into other programs, specifically 
LibreOffice Calc.  The whole process went excellently with one small exception: 
the translation of the Swedish characters, å, ä and ö (and of course the 
capitals, Å, Ä and Ö which I have not tested).

Instead of seeing each of the three letters, in each case I saw two characters, 
Ã￥, for example instead of å.  I checked the three characters in a hex editor, 
and found the following:

å was represented by C3A5 in other applications, but as C383C2A5 in LibO
ä was represented by C3A4 in other applications, but as C383C2A4 in LibO
ö was represented by C3B6 in other applications, but as C383C2B6 in LibO

I checked the original data in Gnucash, the intermediary form in the html file 
and the contents of content.xml in LibO.  The first two had the short form, 
LibO had the second form.

I have also checked the same information in Windows, although I have not yet 
used a hex editor in Windows.  Both Excel and LibO Calc imported the data 
correctly, or rather, displayed it correctly.

Before I report this as a bug, I'd like to be sure it's not something I'm 
missing in my configuration.  All programs are set to use UTF-8, insofar as one 
can set it in the program rather than in the operating system.

A late thought occurs to me.  I use LibO Writer for writing Mandarin and have 
set 'Enabled for Asian languages' under Languages.  Can this have affected the 
way LibO translates the non-English characters?  Although LibO has actually 
_added_ two bytes to the characters.

Regards

//James





--
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: CURRENT_DATE or TODAY default date in Base

[Andreas Säger]

The Base GUI is too stupid to do that trick. It all depends on the database
you are actually using. 
For the embedded HSQLDB type of database that is:

menu:Tools>SQL... 
ALTER TABLE "My Table" ALTER COLUMN "My Date" DATE DEFAULT CURRENT_DATE NOT
NULL

You may leave out NOT NULL or you may unckeck Edit>Database>Advanced: "Form
checks for required fields". Otherwise you get a form errors about missing
data.

--
View this message in context: 
http://nabble.documentfoundation.org/CURRENT-DATE-or-TODAY-default-date-in-Base-tp3292686p3292724.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] New to Group, and so checking on Browser Plug-in

[webmaster for Kracked Press Productions]

My question is:  Why are you reading them online instead of downloading 
them?  Even though I have 24/7 broadband access, I still prefer download 
my documents then read the offline.


"full books takes ages" - not for broadband.  Most seem to be under 20MB.

The "graying" is something I hate, and is doing this more and more for 
sites with Firefox [FF 3.6.20 on Ubuntu-64bit]


On 08/29/2011 08:35 AM, Tom Davies wrote:

Hi :)
If you open the manuals/guides by doing a right-click and then "open in a new
tab" then you can give it plenty of time to open.  The full books take ages to
download but the individual chapters should only take a couple of minutes.
Where the web-pages normally appear, ie inside the tab, will be grey until the
chapter/book has downloaded.


Are you using Internet Explorer or Firefox?
Regards from
Tom :)





From: Russell Wilson
To: LibreOffice User Gp
Sent: Mon, 29 August, 2011 3:33:25
Subject: [libreoffice-users] New to Group, and so checking on Browser Plug-in

Trying to use LO 3.4.2 on Win 7 x64 and can't get browser plug-in to work --
been trying to read some of the LO manuals on line, so program/browser seems to
fail "half-way" --  screen gets half-greyed out (with white in other half of
window where od should be viewable but nothing to read!) -- thankfully pressing
back arrow enables previous page view, where document can be saved easily enough
-- not a big issue overall, compared to many others, but a pain none the less.

bw to all
Russell J Wilson
Dunedin, New Zealand




--
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] CURRENT_DATE or TODAY default date in Base

[John Mullen]

Hi Guys,

I'm trying to set a default date ( CURRENT_DATE or TODAY ) ie,  Todays date
into a date field in a Base Form with no luck.

Also tried to enter it into the table as a default date - no luck.

Please advise if this is a known bug and if there is a workaround.

Best regards

John



-- 
Cheapest mobile tariffs - GUARANTEED 

"I train people to make money" 

"Action always beats inaction" - Robert T. Kiyosaki

-- 
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: import data from FileMaker Pro?

[Andreas Säger]

http://help.filemaker.com/app/answers/detail/a_id/7700/~/installing-odbc-and-jdbc-for-filemaker-11

This is not a question of file formats. You can connect FileMaker to Base
like you can connect it to MS Query or MS Access.

--
View this message in context: 
http://nabble.documentfoundation.org/import-data-from-FileMaker-Pro-tp3292542p3292647.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] Dictionaries installed but not available

[Guy Voets]

2011/8/29 Rogier F. van Vlissingen :
> I've installed a dictionary (Dutch) and it appears to be available in
> tools/language settings/writing aids, but it's not available when I try to
> set the language of a document? What gives?
>
Hello Rogier,

Did you define the language of the document, either in its style
(Format>Styles (Control-T)) or in direct formatting
(Format>Character>Font>Language) ?
When the dictionary is properly installed, it should have a v-sign
next to it in the list of languages in Font-Language (as well as in
the preferences page you mention >language settings>languages>standard
language

The language is a characteristic of the Character (letter in Dutch)
and can be defined for a single word, a sentence, a paragraph or an
entire text.

Hope thie helps - or else try to explain more in detail what you do/whathappens.
-- 
Guy
using LibO 3.4.2 on a iMac Intel DualCore Lion
-- please reply only to users@global.libreoffice.org --
Dodoes can't afford to have headaches

-- 
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] New to Group, and so checking on Browser Plug-in

[Tom Davies]

Hi :)
If you open the manuals/guides by doing a right-click and then "open in a new 
tab" then you can give it plenty of time to open.  The full books take ages to 
download but the individual chapters should only take a couple of minutes.  
Where the web-pages normally appear, ie inside the tab, will be grey until the 
chapter/book has downloaded.  


Are you using Internet Explorer or Firefox?
Regards from
Tom :)





From: Russell Wilson 
To: LibreOffice User Gp 
Sent: Mon, 29 August, 2011 3:33:25
Subject: [libreoffice-users] New to Group, and so checking on Browser Plug-in

Trying to use LO 3.4.2 on Win 7 x64 and can't get browser plug-in to work -- 
been trying to read some of the LO manuals on line, so program/browser seems to 
fail "half-way" --  screen gets half-greyed out (with white in other half of 
window where od should be viewable but nothing to read!) -- thankfully pressing 
back arrow enables previous page view, where document can be saved easily 
enough 
-- not a big issue overall, compared to many others, but a pain none the less.

bw to all
Russell J Wilson
Dunedin, New Zealand

-- 
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] import data from FileMaker Pro?

[yahoo-pier_andreit]

Il 29/08/2011 13:40, Paul Hochbaum ha scritto:

Hello,

do you have any idea, how to import data from FileMaker Pro databases in order 
to convert them into a libre database?


try in filemaker pro the export function, in the past it had a lot of 
options, i remember i used "SYLK" and other, i think comma separated 
value can be managed by calc and base



--
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] strikethrough in draw

[Andre]

Hi all,
it seems like a simple question, but maybe not. In Draw, I want to strikethrough
the text of a connector shape. I can choose the option from the
context/character menu of the shape but nothing happens on the screen. Same with
underlining. Has anyone experienced this and knows a solution?
Thanks. André


-- 
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-documentation] RE: [libreoffice-users] new to list - and "final showing markup" question

[Tom Davies]

Hi :)
To add to Dennis' answer.  

How about giving your editor the link for downloading LibreOffice?  It is 
likely 
that an increasing number of writers will be using Writer so you will be doing 
him a favour.  


Definitely make a copy somewhere safe (a back-up copy) before making such major 
changes.
Regards from
Tom :)




- Original Message 
> From: Dennis E. Hamilton 
> To: users@global.libreoffice.org
> Cc: LibreOffice Documentation 
> Sent: Mon, 29 August, 2011 4:26:36
> Subject: [libreoffice-documentation] RE: [libreoffice-users] new to list - 
> and 
>"final showing markup" question
> 
> This could be hard, it's not likely to be easy.  The simpler the manuscript  
>format, the easier this will be.
> 
> I may be giving you more than you need,  but maybe the documentation folks 
> can 
>make use of this in some way too.
> 
>   - Dennis
> 
>  1. FINAL SHOWING MARKUP
> 
> "Final Showing Markup" is a  Track Changes option in Microsoft Office.  (The 
>other options are Original,  Original Showing Markup, and Final).  Final 
>Showing 
>Markup appears to be  the default setting.  "Final Showing Markup" shows how 
>the 
>document will  appear when all changes are accepted, and what the changes are 
>that leave it in  that shape.  This option has been available in all versions 
>of 
>Microsoft  Word *since* Office 2000.
> 
> What that means, when using Word, is that  insertions are marked by 
> underlining 
>but that deletions don't show in the  text.  Instead, deletion points are 
>linked 
>to balloons in the margin that  show what was deleted.  (In case you were 
>wondering, Original Showing  Markup has the insertions in marginal balloons 
>and 
>deletions are strikeouts in  the text.)
> 
> There is a description of this at 
> .
> 
>   2. IN-LINE ONLY CHANGES - ALL THAT LIBREOFFICE HAS
> 
> In Microsoft Office,  there is also a kind of tracked-changes presentation 
>where both insertions  (colored and underlined usually) and deletions 
>(different 
>color, with  strikethrough usually) are all in the running text.  This is 
>accomplished  by turning off the balloon feature.
> 
> In Libre Office, this is the *only*  way that tracked changes can be shown.  
> If 
>you look at Tools | Options |  LibreOffice Writer | Changes you will see what 
>is 
>under your control.
> 
>  3.  THE GOOD NEWS
> 
>   3.1 If, with the final draft you are being asked to  review, set the 
> Changes 
>options to something your editor is asking to see, such  as Insertions 
>Underlined and in Light Blue color.  Deletions with  Strikethrough and Red 
>color.  Changed attributes Underlined Double and  Color Magenta 4 or so.  I 
>don't know if he wants to see change marks, but  you can leave them on the 
>left 
>margin and black.
> 
>   3.2 IN FACT,  these setting apply to the software being used to view the 
>document.  The  settings don't travel with the document.  A reviewer will see 
>their  settings applied as if that is what you used.  You do have to turn on  
>Record and Show in the Edit | Changes ... menu though.
> 
>   3.3 IF YOU  ARE LUCKY, your editor will open the document for Review with 
>Final Showing  Markup and will see exactly what is being expected.  You might 
>warn the  editor that the setting might have to be selected after opening the 
>document in  Word.
> 
>  4. THE BAD NEWS
> 
>   4.1 I don't know if you have been  turning back change-marked documents, or 
>receiving change-marked  documents.  If you have, you probably know how 
>careful 
>you have to  be.
> 
>   4.2 To put it politely, interoperability of change-tracking  across formats 
>is not terrific.  Extensive changes and rearrangements can  be messed up 
>something also when there is a conversion between  formats.
> 
>   4.3 CAREFUL, SMALL STEPS SHOULD WORK.  I assume your  manuscript is not 
>complex.  So long as you are down to correcting typos and  short wordings, you 
>should be fine.  Instead of making a change between two  paragraphs or across 
>other mixes of materials (list items, text flowing across  images, table 
>rows), 
>keep the changes small.  Make multiple small changes,  rather than big ones 
>that 
>span units of text.  This works best if your  document is not done against an 
>exotic template and has rich features as well as  text.
> 
>   4.4 CONFIRM IF YOU CAN.  If you have a Word viewer, you  might be able to 
> see 
>if the change-tracking goes across all right.  If  saving as .doc and then 
>reopening it in LibreOffice looks fine, you are probably  all right too.  (But 
>you might still be all right but unable to confirm it  if round trip to .doc 
>and 
>back into LibreOffice deviates in some  way.)
> 
> 
> 
> -Original Message-
> From: Jack Wallen [mailto:jlwal...@monkeypantz.net] 
> Sent:  Sunday, August 28, 2011 17:17
> To: users@global.libreoffice.org
> Subject:  [libreoffice-users] new to list - and "final showing markup"  
>question
>

[libreoffice-users] import data from FileMaker Pro?

[Paul Hochbaum]

Hello, 

do you have any idea, how to import data from FileMaker Pro databases in order 
to convert them into a libre database?

Thx,
Paul

H-2045 Törökbálint
Tükörhegy utca 6.
E-Mail: h...@baum.hu
Tel.: +36 20 956 09 96
Fax: +36 23 890 770




-- 
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] Dictionaries installed but not available

[Rogier F. van Vlissingen]

I've installed a dictionary (Dutch) and it appears to be available in  
tools/language settings/writing aids, but it's not available when I try to  
set the language of a document? What gives?


--
Using Opera's revolutionary email client: http://www.opera.com/mail/

--
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] Libre "Help" file in Windows 7

[Tinkerer]

A friend has installed Libre 3.4.2 on his Windows 7 computer.
He then installed the Libre Help file and Windows put it in Documents.
It does not work.
Where should it be?
BTW. I am a Mac user.

Tink.

--
View this message in context: 
http://nabble.documentfoundation.org/Libre-Help-file-in-Windows-7-tp3292418p3292418.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

[libreoffice-users] Re: Linked Cell says True instead of Showing the value

[Andreas Säger]

Am 29.08.2011 09:13, nvrk wrote:

Do you think that this could be a cell format problem?
nvsoar


Could be. Nobody can tell without any data nor formulas from the 
original poster. Unlike Excel, the boolean data type is just a subtype 
of the decimal type. The number format "BOOLEAN" displays any non-zero 
number as TRUE and all the rest as FALSE. In Excel there is a separate 
boolean data type, so TRUE and FALSE are never equal to any number.



--
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] 2Q -- WollMux for LibreOffice? -- Archives area?

[Tom Davies]

Hi :)
The Nabble 'forum' is one way of viewing threads from the mailing list
http://nabble.documentfoundation.org/Users-f1639498.html
and there is a search feature at the top-right.

LibreOffice is just beta-testing it's own Extensions Web-page and there will be 
an announcement about it soon to invite everyone to test it out.  It doesn't 
have all the extensions as they are just being added but it might be worth 
looking through
http://extensions-test.libreoffice.org

The OpenOffice.org site is very temperamental.  People are working hard to fix 
it but until then just keep clicking on "Try again" until the page loads 
successfully.  It's not ideal which is one reason why LibreOffice are going to 
have it's own page.
Regards from
Tom :)





From: Russell Wilson 
To: LibreOffice User Gp 
Sent: Mon, 29 August, 2011 6:28:13
Subject: [libreoffice-users] 2Q -- WollMux for LibreOffice? -- Archives area?

The WollMux extension is listed on the extensions site but clicking on it leads 
to a page missing error.

When downloading and trying to install it from a third party, it says it's 
unable to be installed due to OOo not being installed. 



Will there be a version available for LO?

Is there an archives site where such basic questions can be searched?  The 
mailing list signon doesn't mention any archives area.

bw
Russell J. Wilson
Dunedin, New Zealand

'

-- 
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: LO Impress 3.3.3 crashes Windows and Ubuntu

[stan]

UPDATE: The same problem now re-occurred with LO writer. Unfortunately,
although running through strace, no strace.log to be found on the system.



--
View this message in context: 
http://nabble.documentfoundation.org/LO-Impress-3-3-3-crashes-Windows-and-Ubuntu-tp3258408p3291282.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

[libreoffice-users] Re: Suggestions to PTB

[Twayne]

In news:j3ap2n$4u8$1...@dough.gmane.org,
Alexander Thurgood  typed:
> Le 26/08/11 19:14, Twayne a icrit :
>
> Hi Twayne,
>
>
>> But MS fixes their bugs and will continue to do so until
>> 2014 in my case. I am trying to get them to think about
>> the problem that lost them a lof of people in OOo, most
>> of which are still in LO, and if you read over to
>> Alexander's post to me, there seems to be no plans to
>> pick up the bugs and fix them. They're dangerously close
>> to repeating OOo's mistakes. LO is better IMO but what
>> it does not do is what it says it'll do.
>
> Oh bugs do get fixed, just not necessarily the ones that
> any given (sub)set of users might want fixing. An example
> : Base bugs - of the more than one hundred Base bugs
> declared on bugzilla since the inception of LibreOffice,

...

Alex,

Hope this gets to you; I've never had a lot of luck with responses to the 
List (I read gmane's NNTP).

ANYway, I don't disagree with anything you said, but  figured it wouldn't 
hurt to voice my opinions. Writer is what I use most right now and yeah, 
I've seen stats on Base but I'm a one at a time kind of person .
   Although I still think there is more that could be done I don't see any 
dead horses around, so my stick is still put away. From my vewpoint though, 
there needs to be a stop point where Writer et al are brought up to the 
point where 90%+ of the users can have a relatively bug-free environment and 
minimum, work-arounds pointed out for those that can't yet be fixed, for 
whatever reason.
   It would save exasperation on the part of your users and put a draw to 
the product that hasn't yet been seen. As an example, I don't believe it's a 
product that's ready for prime time at colleges or most businesses right 
now. I know of two around here who tried to implement LO and previously an 
OOo. They have since tossed it out and gone back to WP and MS respectively. 
A third one I know of is OK so far and not having any problems because they 
arean't asking it to do much more than secretarial jobs. That's only an 
experience of 3, but when you consider it, t must translate to many more. I 
only know this because I have business dealings with those three places. I 
might sound pretty negatve, but I want LO to become big time and I don't see 
how that can happen.

Thanks for listening!

Twayne` 




-- 
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: Re: strikethrough feature

[Twayne]

Hi Johnny,

Thanks for the comeback; it's handy to get slapped with a reminder now & 
then about English not being a poster's first language. It wasn't obvous to 
me at all so you're doing pretty darned good.
   I am of the opinion your "problem" is a small one but there are still 
some things that might help you out, so I'll address those where I can.

See Inline, please: some unneeded text trimmed for clarity:


In news:cado7t4e+d1zpcagmuh_w2-cwmhdr+trd2spbq59-pbkqjuz...@mail.gmail.com,
Johnny Rosenberg  typed:
> 2011/8/27 Twayne :
>>>
>>> This is the LibreOffice users' list. It's not a real
>>> support. We are
>>> just users who help each other out. You can ask
>>> questions and you can
>>> reply to other people's question if you like.

True. The NNTP news group at gmane.com contains the same messages as are in 
the List and as long as we remember to add the e-mail address to you, also 
shows up in the List. The newsgroup's full NNTP newsgroup-name is
gmane.comp.documentfoundation.libreoffice.user
if you'd like to compare it to the list.
   A real mail reader like OE6 or Mozilla Thunderbird and many others, also 
free, are best for reading newsgroups with. From the Headers of your post, 
you appear to be using Google to reach the newsgroups and that's probably 
the real source of any lost messages you mentioned.

>
> Well, I don't think my comment was meant for you, but
> maybe I totally misunderstand what you are saying here
> (English is of course not my native language, that's why
> it look very strange sometimes).

That's OK. Your post was positioned such that it looked like a post to me, 
though when you make posts, unless you say so, everyone can get and read 
your post and respond to it. It's not unusual to get responses from more 
than one person.

> I guess I should have written bcouldb instead of
> bshouldb or something, I don't know.

That's not a problem IMO, but here is something that IS important if view of 
your post here.
1. If English isn't your native language, then you should say so in your 
post so that the answers can be kept simpler and use more easily understood 
words.
2. Have you checked to see if there is a list of newsgroup in your native 
language? If so, that might be a better place to ask simple questions such 
as this one was.
   I suspect you have the answer you need by now, right?

> Anyway, I have always said that if someone is not
> subscribed it's not my problem that he or she doesn't
> receive my replies.

IMO (in my opinion), that's an error in your thinking. People not getting 
your responses should put up a mental flag for you that something is not 
right.
Also, when people are complaining that they don't get your response, 
especially if it's more than one person, then you should start by assuming 
there is a problem at your end. I suspect, but can't be sure of course, that 
it's Google messing you up; it usually is. There are a lot of people who 
won't accept mails from Google Groups and some won't accept ANYthing from 
Google. They even have rules set up that simply drop anything from Google.

Although I'm not sure how you're responding, if you respond to the mailing 
list, it will show up on NNTP (the gmane newsgroup). If you're using Google 
to read newsgroups, then I understand: delivery problems are the norm there 
and it's easy to let a response go astray, too. Google is simply not a good 
newsgroup reader. And the mailing list fills your Inbox wth mails that have 
nothing to do with your original post. In MY opinion, news readers are great 
for reading mail.

 People didn't like that kind of
> attitude, so now I changed that; I even added that
> address to the bTo:b field, to make sure that my reply
> would reach the right person.
> I guess I now need to find a third way of doing it, but
> I'm not sure what's left. Well, I know one thing: Not
> replying at all. That's quick and easy and doesn't annoy
> anyone. I think I'll go with that until I find something
> better. Thanks for your advice.

That's you choice, of course, but if you enjoy discussing problems and 
getting help from others, you'll find it very handy.

>
>>
>> No, not for me. I have more to do than scan mailing
>> lists looking for my post responses when I can have them
>> pointed out to me automatically and all grouped
>> together. When I have a question, I DO NOT CARE to see
>> other answers; I might if  I were a newbie and had lots
>> of time avalable, but I don't.
>> This is only my opinion, but some of the advice you gave
>> leaves a little to be desired.
>
> I'm not even sure it's right to call it advice. I just
> throw my crap
> at the nearest place, obviously.

If I understand what you mean, that's a mistake to do that. If you have a 
legitimate news reader, then amongst other things, you hace have it show you 
ONLY responses to you and nothing else, organize your original message on 
top with all the responses underneath it in the order received or any other 
way you'd lik

[libreoffice-users] Re: Re: strikethrough feature

[Twayne]

Hi Johnny,

Thanks for the comeback; it's handy to get slapped with a reminder now & 
then about English not being a poster's first language. It wasn't obvous to 
me at all so you're doing pretty darned good.
   I am of the opinion your "problem" is a small one but there are still 
some things that might help you out, so I'll address those where I can.

See Inline, please: some unneeded text trimmed for clarity:


In news:cado7t4e+d1zpcagmuh_w2-cwmhdr+trd2spbq59-pbkqjuz...@mail.gmail.com,
Johnny Rosenberg  typed:
> 2011/8/27 Twayne :
>>>
>>> This is the LibreOffice users' list. It's not a real
>>> support. We are
>>> just users who help each other out. You can ask
>>> questions and you can
>>> reply to other people's question if you like.

True. The NNTP news group at gmane.com contains the same messages as are in 
the List and as long as we remember to add the e-mail address to you, also 
shows up in the List. The newsgroup's full NNTP newsgroup-name is
gmane.comp.documentfoundation.libreoffice.user
if you'd like to compare it to the list.
   A real mail reader like OE6 or Mozilla Thunderbird and many others, also 
free, are best for reading newsgroups with. From the Headers of your post, 
you appear to be using Google to reach the newsgroups and that's probably 
the real source of any lost messages you mentioned.

>
> Well, I don't think my comment was meant for you, but
> maybe I totally misunderstand what you are saying here
> (English is of course not my native language, that's why
> it look very strange sometimes).

That's OK. Your post was positioned such that it looked like a post to me, 
though when you make posts, unless you say so, everyone can get and read 
your post and respond to it. It's not unusual to get responses from more 
than one person.

> I guess I should have written bcouldb instead of
> bshouldb or something, I don't know.

That's not a problem IMO, but here is something that IS important if view of 
your post here.
1. If English isn't your native language, then you should say so in your 
post so that the answers can be kept simpler and use more easily understood 
words.
2. Have you checked to see if there is a list of newsgroup in your native 
language? If so, that might be a better place to ask simple questions such 
as this one was.
   I suspect you have the answer you need by now, right?

> Anyway, I have always said that if someone is not
> subscribed it's not my problem that he or she doesn't
> receive my replies.

IMO (in my opinion), that's an error in your thinking. People not getting 
your responses should put up a mental flag for you that something is not 
right.
Also, when people are complaining that they don't get your response, 
especially if it's more than one person, then you should start by assuming 
there is a problem at your end. I suspect, but can't be sure of course, that 
it's Google messing you up; it usually is. There are a lot of people who 
won't accept mails from Google Groups and some won't accept ANYthing from 
Google. They even have rules set up that simply drop anything from Google.

Although I'm not sure how you're responding, if you respond to the mailing 
list, it will show up on NNTP (the gmane newsgroup). If you're using Google 
to read newsgroups, then I understand: delivery problems are the norm there 
and it's easy to let a response go astray, too. Google is simply not a good 
newsgroup reader. And the mailing list fills your Inbox wth mails that have 
nothing to do with your original post. In MY opinion, news readers are great 
for reading mail.

 People didn't like that kind of
> attitude, so now I changed that; I even added that
> address to the bTo:b field, to make sure that my reply
> would reach the right person.
> I guess I now need to find a third way of doing it, but
> I'm not sure what's left. Well, I know one thing: Not
> replying at all. That's quick and easy and doesn't annoy
> anyone. I think I'll go with that until I find something
> better. Thanks for your advice.

That's you choice, of course, but if you enjoy discussing problems and 
getting help from others, you'll find it very handy.

>
>>
>> No, not for me. I have more to do than scan mailing
>> lists looking for my post responses when I can have them
>> pointed out to me automatically and all grouped
>> together. When I have a question, I DO NOT CARE to see
>> other answers; I might if  I were a newbie and had lots
>> of time avalable, but I don't.
>> This is only my opinion, but some of the advice you gave
>> leaves a little to be desired.
>
> I'm not even sure it's right to call it advice. I just
> throw my crap
> at the nearest place, obviously.

If I understand what you mean, that's a mistake to do that. If you have a 
legitimate news reader, then amongst other things, you hace have it show you 
ONLY responses to you and nothing else, organize your original message on 
top with all the responses underneath it in the order received or any other 
way you'd lik

[libreoffice-users] Problem with data conversion

[James Wilde]

Can't think of a better subject line.

This is about the Ubuntu repository version of LibO running under Ubuntu 11.04 
linux.  The repository version is described as follows:

LibreOffice 3.3.3
OOO 330m 19 (Build:301)
LibreOffice 3.3.3.1 Ubuntu package 1.3.3.3ubuntu2

I have been testing Gnucash on linux, and in particular the ability to export 
data to an html file and read that into other programs, specifically 
LibreOffice Calc.  The whole process went excellently with one small exception: 
the translation of the Swedish characters, å, ä and ö (and of course the 
capitals, Å, Ä and Ö which I have not tested).

Instead of seeing each of the three letters, in each case I saw two characters, 
Ã￥, for example instead of å.  I checked the three characters in a hex editor, 
and found the following:

å was represented by C3A5 in other applications, but as C383C2A5 in LibO
ä was represented by C3A4 in other applications, but as C383C2A4 in LibO
ö was represented by C3B6 in other applications, but as C383C2B6 in LibO

I checked the original data in Gnucash, the intermediary form in the html file 
and the contents of content.xml in LibO.  The first two had the short form, 
LibO had the second form.

I have also checked the same information in Windows, although I have not yet 
used a hex editor in Windows.  Both Excel and LibO Calc imported the data 
correctly, or rather, displayed it correctly.

Before I report this as a bug, I'd like to be sure it's not something I'm 
missing in my configuration.  All programs are set to use UTF-8, insofar as one 
can set it in the program rather than in the operating system.

A late thought occurs to me.  I use LibO Writer for writing Mandarin and have 
set 'Enabled for Asian languages' under Languages.  Can this have affected the 
way LibO translates the non-English characters?  Although LibO has actually 
_added_ two bytes to the characters.

Regards

//James


-- 
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: Spreadsheet 3.4.2 Bug

[Cor Nouws]

Alexander Thurgood wrote (29-08-11 09:10)

There is a bug is in the print preview. It should always display anything
printable. That is either the used ranges of all sheets or the collection of
explicitly defined ranges. Currently it shows the used/defined range of the
current sheet only.


I seem to recall that there is already an issue for that, but I could be
wrong.


Could be
  Bug 32826 - Printing in Preview mode causes all sheets to be printed
  Bug 33155 - Wrong pages names in "Page Break Preview" [FIXED]
?


--
 - Cor
 - http://nl.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

[libreoffice-users] Re: Calc row filter extraction

[Olivier Bietzer]

Yes, I do agree

But when there is only one table, Calc will do the job, no ?

No need to use a hammer to slam a fly...

Regards from Olivier

Le 28/08/2011 21:12, Andreas Säger a écrit :

What you do in that spreadsheet would be a 100% database task. The data pilot
is Calc's most database-ish tool.

http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/DataPilot
http://user.services.openoffice.org/en/forum/download/file.php?id=8592

--
View this message in context: 
http://nabble.documentfoundation.org/Calc-row-filter-extraction-tp3207632p3291045.html
Sent from the Users mailing list archive at Nabble.com.



--
---
Olivier Bietzer


--
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] Linked Cell says True instead of Showing the value

[nvrk]

Do you think that this could be a cell format problem?
nvsoar
On Aug 28, 2011 5:34 AM, "Johnny Rosenberg"  wrote:
> 2011/8/28 Tom Davies :
>> Hi :)
>> Even just copy&pasting the equation into a reply to this thread might
help ;)
>> Regards from
>> Tom :)
>
> Might help but not necessarily, I think. Depends on where the problem
> is. It's not always where it seems to be…
>
>
> Kind regards
>
> Johnny Rosenberg
> ジョニー・ローゼンバーグ
>
>>
>>
>> 
>> From: Johnny Rosenberg 
>> To: users@global.libreoffice.org
>> Sent: Sun, 28 August, 2011 11:52:49
>> Subject: Re: [libreoffice-users] Linked Cell says True instead of Showing
the
>> value
>>
>> 2011/8/28 Jack Cambel :
>>> What should I do when a linked value says True instead of the value it
is
>>>supposed to reference or compute? I have a vlookup function that works
partialy,
>>>the cell it is supposed to reference says true instead of the value it
supposed
>>>to say. The cell it is supposed to reference is linked to a number field
form.It
>>>works partially because some other values are derived from this and they
turn
>>>out fine, still I have "True" where it should have a value.
>>>
>>> Thanks,
>>> Jack
>>
>> Can you upload an example file somewhere and give us the link here?
>> That would make it a lot easier to answer your question.
>>
>>
>> Kind regards
>>
>> Johnny Rosenberg
>> ジョニー・ローゼンバーグ
>>
>> --
>> 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

[libreoffice-users] New to Group, and so checking on Browser Plug-in

[Russell Wilson]

Trying to use LO 3.4.2 on Win 7 x64 and can't get browser plug-in to work -- 
been trying to read some of the LO manuals on line, so program/browser seems to 
fail "half-way" --  screen gets half-greyed out (with white in other half of 
window where od should be viewable but nothing to read!) -- thankfully pressing 
back arrow enables previous page view, where document can be saved easily 
enough -- not a big issue overall, compared to many others, but a pain none the 
less.

bw to all
Russell J Wilson
Dunedin, New Zealand

-- 
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: Spreadsheet 3.4.2 Bug

[Alexander Thurgood]

Le 27/08/11 22:15, Andreas Säger a écrit :

Hi Andreas,

> This is the intended behaviour as it used to be specified for OOo, and
> Nicolás document behaves perfectly normal :
> "Default print range" is a sheet's used range unless you define anything
> anywhere in the document.

Yes, indeed, as I have stated in his bug report.


> There is a bug is in the print preview. It should always display anything
> printable. That is either the used ranges of all sheets or the collection of
> explicitly defined ranges. Currently it shows the used/defined range of the
> current sheet only.

I seem to recall that there is already an issue for that, but I could be
wrong.

Alex.


-- 
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] 2Q -- WollMux for LibreOffice? -- Archives area?

[Russell Wilson]

The WollMux extension is listed on the extensions site but clicking on it leads 
to a page missing error.

When downloading and trying to install it from a third party, it says it's 
unable to be installed due to OOo not being installed. 


Will there be a version available for LO?

Is there an archives site where such basic questions can be searched?  The 
mailing list signon doesn't mention any archives area.

bw
Russell J. Wilson
Dunedin, New Zealand

'

-- 
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] Problems using VLOOKUP in Libreoffice Calc

[Gérard FARGEOT]

Hello,



> Message du 29/08/11 01:18
> De : "minnesotauser" 
> A : users@global.libreoffice.org
> Copie à : 
> Objet : [libreoffice-users] Problems using VLOOKUP in Libreoffice Calc
> 
> I have two columns set up like so:

a | 1
b | 2
c | 3

I want to be able to use a number from column B and have the text from
column A displayed.
But when I put {=vlookup(B4,A1:B3,1,0)} in cell A4, and {=max(B1:B3)} in B4
(minus the brackets for both), I get back, correctly, 3 for the max, but
#N/A for the VLOOKUP.
Putting in the letters a, b, or c in B4 correctly returns the number it's
next to, so it seems like only the first column in the array is searched.

Is it possible to flip the way the columns are searched?
Thanks for any help.


VLOOKUP search in the 1st column of the array, so you can't get a result in a 
left column.
Use INDEX and MATCH for this :
=INDEX(A1:A3,MATCH(B4,B1:B3,0))

Gérard
-- 
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