Re: [libreoffice-users] Automatic Capitalization of First Word

2013-09-08 Thread Dave Barton
 Original Message  
From: Dale Erwin d...@casaerwin.org
To: users@global.libreoffice.org
Date: Sat, 07 Sep 2013 17:09:37 -0500

 I know I have done this before, but I can't remember now where I found
 the setting.  I would like to disable the capitalization of the first
 word in a sentence or paragraph.
 
 I am not sure if I am subscribed to this list.  I send an empty message
 to users+subscr...@global.libreoffice.org but I never received the
 confirmation mail.

Hi Dale,

What you are looking for is the: Format - AutoCorrect - AutoCorrect
Options... menu entry.

In the AutoCorrect dialog click the Options tab and untick/uncheck
the Capitalize first letter of every sentence.

Just in case you are not subscribed I have cc'd you with an small screen
capture attached.

Regards
Dave



-- 
To unsubscribe e-mail to: users+unsubscr...@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] Table Breaks in Writer

2013-09-08 Thread e-letter
-- Forwarded message --
From: e-letter inp...@gmail.com
Date: Sun, 8 Sep 2013 08:49:34 +0100
Subject: Re: [libreoffice-users] Table Breaks in Writer
To: Robert Burnett r...@artl.org.uk
Cc: users@global.libreoffice.org

On 07/09/2013, Robert Burnett r...@artl.org.uk wrote:

 Problem, I use writer and have a 2 page document that holds a table on each
 page.  As time passes the size of the table on page one changes so that rows
 end up in page two.  When this happens I do a table split and everything is
 fine.


By default, tables are created with the function 'split table' activated.

 The problem arises when I attempt to remove the gap/break between the
 tables, this occurs when I need to join the tables on page two.  The same
 problem albeit on page one occurs when I reduce the rows in the table on
 page one, the break rises from page two, so that I end up with a gap between
 two tables on the bottom of page one.  The table merge is greyed out, no
 other action works so I have to close the document, open the document in
 microsoft and all I do is, place the cursor in the gap and hit cut, gap gone
 and the two tables are now joined, on either page.


Replication: table 1 created with 40 rows, table 2 created with 20
rows. With the view of non-printed characters  (menu
bar|view|non-printing charachers (¶)), the paragraph break was removed
from between the two tables. Then both tables were selected (ctrl+a)
and merged (menu bar|table|merge tables). The navigator (f5) confirms
that table 1 merges with table 2 and only table 2 remains in the
document.

 How can I manage this in Libreoffice as it is embarrassing to have to close
 one software program and open another for such a simple task when other
 people are observing as it indicates a) I don't know what I am doing or b)
 libreoffice has a software issue.


Below is an example: copy the source code below and save to your
computer as an .fodt file (e.g. tabletest.fodt), the open the document
using LO. You should be able to follow the instructions above to
achieve a merged table.

The mailing list did not accept the source code, which has been posted
at 'pastebin': http://pastebin.com/raw.php?i=SHyuZyCY

-- 
To unsubscribe e-mail to: users+unsubscr...@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: spacing after punctuation

2013-09-08 Thread Brian Barker

At 12:49 07/09/2013 -0700, John Jason Jordan wrote:
In Writer, FrameMaker and the TeX family, a document consists of a 
continuous stream of text. If you insert additional text at the 
beginning, all the text moves down, including the creation of new 
pages at the end if necessary.


The other applications I mentioned are page layout applications. 
In a page layout application each page is a container. Everything 
that goes on a page goes into a graphics or a text frame. The frames 
never automatically move, regardless of how much stuff you add stuff 
to them. For text to flow from one page to the next there must be successive
frames on the pages and the frames must be linked. You can drag 
frames around, create new ones, change the size and shape, but a 
frame always stays precisely where you put it on a page. You can 
link text frames that are pages apart - think of a magazine where a 
story begins toward the front of the magazine, runs for a couple of 
pages, and then you see continued on page x.


Writer won't do everything, but you appear not to realise what it can 
do.  Writer has frames, which can indeed be anchored to pages, and 
have the sort of properties you describe.  It also allows linked 
frames.  The only restriction appears to be that linked frames must 
be in the same section.  Try it!  (See frames;linking in the help text.)


Brian Barker


--
To unsubscribe e-mail to: users+unsubscr...@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: oops! Re: [libreoffice-users] Re: [libreoffice-users] Fedena 2.3.4 is Now Available

2013-09-08 Thread Luuk

On 07-09-2013 20:33, Tom Davies wrote:

Hi :)
Fred has been looking into it a bit more but we still haven't worked out if it 
really is bad.  It's still looking like a good product but it is more 
comparable with these;

http://open-school.org/
http://akuraschools.org/
http://centresis.org/



Above three sites seem commercial, offering services on the web..

http://www.projectfedena.org/
Is opensource, WITH the option to download source
(which i think is important for opensource!)

Demo-site is here: http://www.projectfedena.org/demo



But i'm still guessing what this has to do with libreoffice ;)


--
To unsubscribe e-mail to: users+unsubscr...@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: spacing after punctuation

2013-09-08 Thread John Jason Jordan
On Sun, 08 Sep 2013 09:36:29 +0100
Brian Barker b.m.bar...@btinternet.com dijo:

Writer won't do everything, but you appear not to realise what it can 
do.  Writer has frames, which can indeed be anchored to pages, and 
have the sort of properties you describe.  It also allows linked 
frames.  The only restriction appears to be that linked frames must 
be in the same section.  Try it!  (See frames;linking in the help
text.)

Of course I was aware that Writer has frames that can be linked. Do you
use writer to lay out a magazine? Do you recommend that I do so?

-- 
To unsubscribe e-mail to: users+unsubscr...@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: spacing after punctuation

2013-09-08 Thread Brian Barker

At 07:23 08/09/2013 -0700, John Jason Jordan wrote:

Of course I was aware that Writer has frames that can be linked.


How strange, then, that you should suggest otherwise in your 
message!  (None of us can read your mind, of course.)



Do you use writer to lay out a magazine? Do you recommend that I do so?


Wow!  Did you read either of those claims in my message?  Or are you 
hoping no-one would notice your straw man?


Brian Barker


--
To unsubscribe e-mail to: users+unsubscr...@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] Automatic Capitalization of First Word

2013-09-08 Thread Tom Davies
Hi :)
It looks like you are not yet fully subscribed.  


The confirmation email often goes into junk or spam folders if it can't be 
found in your inbox. 

Sorry about that!
Regards from
Tom :)  






 From: Dale Erwin d...@casaerwin.org
To: users@global.libreoffice.org 
Sent: Saturday, 7 September 2013, 23:09
Subject: [libreoffice-users] Automatic Capitalization of First Word
 

I know I have done this before, but I can't remember now where I found 
the setting.  I would like to disable the capitalization of the first 
word in a sentence or paragraph.

I am not sure if I am subscribed to this list.  I send an empty message 
to users+subscr...@global.libreoffice.org but I never received the 
confirmation mail.

-- 
Dale Erwin
Jr. 28 de Julio 657, Depto. 03
Magdalena del Mar, Lima 17 PERU
http://leather.casaerwin.org


-- 
To unsubscribe e-mail to: users+unsubscr...@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
-- 
To unsubscribe e-mail to: users+unsubscr...@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: Chart, Custom Menu Problems in LibreOffice 4.0.5

2013-09-08 Thread V Stuart Foote
Jonathan,


Jonathan Levi wrote
 ... (see attachments, if they're allowed).

Attachments do not make it with posts, stripped out by mail list server by
design.

You can post with attachment  via Nabble interface:
Chart-Custom-Menu-Problems-in-LibreOffice-4-0-5
http://nabble.documentfoundation.org/Chart-Custom-Menu-Problems-in-LibreOffice-4-0-5-td4073460.html
  

But would be more helpful if you were to file a Bug report.   Read this
first: https://wiki.documentfoundation.org/BugReport

The guided  Bug Submission Agent (BSA)
https://www.libreoffice.org/get-help/bug/  is functional, you'd be
reporting against the calc component.

Or you can submit directly to TDF's LibreOffice Bugzilla instance hosted by
the Free Desktop Organization:
https://bugs.freedesktop.org  for the LibreOffice project. 

We'd need to know what OS you are using.  Specifics of the program used to
create the spread sheet with the mishandled charts/graphs and macro.  Any
other details of the behavior you see, versus what you expect. 

Screen shots are helpful, but to improve quality of the Bug report, 
attachment of the problem spread sheet--if possible (sensitive details
redacted)--is necessary.  Reason being that if issue can't be reproduced
with known conditions, it can't be corrected.  If all we have is a screen
shot--not much can be done with the issue.

Stuart




--
View this message in context: 
http://nabble.documentfoundation.org/Chart-Custom-Menu-Problems-in-LibreOffice-4-0-5-tp4073460p4073468.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@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: spacing after punctuation

2013-09-08 Thread Tom Davies
Hi :)
I think John was trying to describe Framemaker and how it differs from Writer.  
While Writer can use frames it is not the default way of using it.  Normally 
people just type straight into a document.  I think John is saying that 
Framemaker doesn't let people type in outside of frames.  

In some ways frames force greater control  but that level of control makes 
things less fluid and flexible.  So while it's great for desktop publishing it 
makes it difficult for normal word-processing.
Regards from 
Tom :)  





 From: Brian Barker b.m.bar...@btinternet.com
To: users@global.libreoffice.org 
Sent: Sunday, 8 September 2013, 15:39
Subject: Re: [libreoffice-users] Re: spacing after punctuation
 

At 07:23 08/09/2013 -0700, John Jason Jordan wrote:
Of course I was aware that Writer has frames that can be linked.

How strange, then, that you should suggest otherwise in your 
message!  (None of us can read your mind, of course.)

Do you use writer to lay out a magazine? Do you recommend that I do so?

Wow!  Did you read either of those claims in my message?  Or are you 
hoping no-one would notice your straw man?

Brian Barker


-- 
To unsubscribe e-mail to: users+unsubscr...@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
-- 
To unsubscribe e-mail to: users+unsubscr...@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: spacing after punctuation

2013-09-08 Thread Brian Barker

At 16:08 08/09/2013 +0100, Tom Davies wrote:

I think John was trying to describe Framemaker and how it differs from Writer.


Unsurprisingly, I was commenting on what he said (not what someone 
else thinks he was trying to do) and thinking of its effect on his 
large audience on this list.


Brian Barker


--
To unsubscribe e-mail to: users+unsubscr...@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] Download fails

2013-09-08 Thread Brian Barker

At 18:40 06/09/2013 +0100, Tom Davies wrote:

Ahh, i was wondering if it was some sort of manual or documentation.


So you were wrong, then?


Perhaps try downloading using some other web-browser other than IE?


If you don't like the colour of your front door, 
one solution is indeed to demolish your house and 
build a new one.  Or you can just repaint the 
front door.  Just rename .man to .msi.


... in the same way that Eskimos have a lot of 
different words meaning snow or ice whereas 
languages from hotter countries might not even have a word for it at all.


This is a hoax.  See Wikipedia: In fact, the 
Eskimo–Aleut languages have about the same number 
of distinct word roots referring to snow as 
English does   Buy yourself this for 
Christmas: http://tinyurl.com/snow-words .


Brian Barker


--
To unsubscribe e-mail to: users+unsubscr...@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] Table Breaks in Writer

2013-09-08 Thread Brian Barker

At 18:48 07/09/2013 +0100, Tom Davies wrote:

Most of us have both LO and MS Office on our systems.


We are the subscribers to this mailing list, right?  For the 
benefit of thousands of readers, should we correct this by saying 
that the idea that most users of LibreOffice also have Microsoft 
Office installed is pretty unlikely - indeed, bordering on the risible?


Brian Barker


--
To unsubscribe e-mail to: users+unsubscr...@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] spreadsheet - sum one column based on the value of other

2013-09-08 Thread Bruno Schneider
I have a spreadsheet with values that are categorized, for instance:

Name - Category - Value
lunch - food - 20
fuel - transportation - 100
dinner - food - 20
repairs - transportation - 200


Then I would like to have a sum of values for each category, such as:

food - 40
transportation - 300

Can anyone help with functions to make this per category sum?

-- 
Bruno Schneider

-- 
To unsubscribe e-mail to: users+unsubscr...@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] spreadsheet - sum one column based on the value of other

2013-09-08 Thread Jay Lozier
Bruno,

Assuming the headers are in row A and the data is in columns 1 thru use:

=sumid(c2:c5,food)


-Original Message-
From: Bruno Schneider boschnei...@gmail.com
To: users@global.libreoffice.org
Subject: [libreoffice-users] spreadsheet - sum one column based on the
value of other
Date: Sun, 8 Sep 2013 12:58:03 -0300


I have a spreadsheet with values that are categorized, for instance:

Name - Category - Value
lunch - food - 20
fuel - transportation - 100
dinner - food - 20
repairs - transportation - 200


Then I would like to have a sum of values for each category, such as:

food - 40
transportation - 300

Can anyone help with functions to make this per category sum?

-- 
Bruno Schneider



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

-- 
To unsubscribe e-mail to: users+unsubscr...@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] spreadsheet - sum one column based on the value of other

2013-09-08 Thread Brian Barker

At 12:58 08/09/2013 -0300, Bruno Schneider wrote:

I have a spreadsheet with values that are categorized, for instance:

Name - Category - Value
lunch - food - 20
fuel - transportation - 100
dinner - food - 20
repairs - transportation - 200


Let's assume these values are in A1 to C5 - so your values are in rows 2 to 5.


Then I would like to have a sum of values for each category, such as:

food - 40
transportation - 300


Let's put these two categories in column E - in E1 and E2.


Can anyone help with functions to make this per category sum?


One way to do this is to put in F1:
=SUMIF(B2:B5;E1;C2:C5)

If instead you put:
=SUMIF(B$2:B$5;E1;C$2:C$5)
you can even fill it down column F into F2, giving
=SUMIF(B$2:B$5;E2;C$2:C$5)

Another technique is to put in F1:
=SUMPRODUCT(B2:B5=E1;C2:C5)
or, again,
=SUMPRODUCT(B$2:B$5=E1;C$2:C$5)
so you can fill this down into F2.

How does this second method work?  Well, the test of equality gives a 
value which can be interpreted as a number: 1 for TRUE and 0 for 
FALSE.  Multiplying this by your value switches each value on or 
off in the sum.


I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscr...@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: Base: How to Duplicate a Record

2013-09-08 Thread Alexander Thurgood
Le 07/09/13 22:48, John Boyle a écrit :

Hi John,

 To Alex: How does that apply to Libre Office, or does it still?

To the extent that OO Basic and LO Basic are substantially the same, the
macro should work. Do note however, that LO4.1 changed the Basic
structure for a date compared to what is used in (A)OO, so if you had
dates to clone, you might possibly have to take account of that.

For the variant that doesn't require a macro (also discussed in the same
thread of the link I posted), it should work in the same way.


Alex



-- 
To unsubscribe e-mail to: users+unsubscr...@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] Grouping objects in Draw

2013-09-08 Thread Carl Paulsen
I have 3 objects I'd like to combine in Draw (one background image, 
another image over a portion of the background and one text block also 
over the background).  I'd like to somehow combine them into one object 
(used to be done by grouping them) that I can then copy and paste 
elsewhere and re-size as needed without having to separately resize each 
object.  I can't seem to make this happen.


I can't seem to select each object so as to group them.  I was able to 
select the background object (which extends beyond the edges of the 
other two objects) and selected Modify-Group, and they all seemed to 
become a part of some kind of group.  I can then copy and paste that 
group, but I can't re-size the group as a whole.


I essentially want to group each object into one so that it gets treated 
as if it were one object, not three.


Can anyone help?

Thanks,
--

Carl Paulsen

Dover, NH 03820


--
To unsubscribe e-mail to: users+unsubscr...@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: oops! Re: [libreoffice-users] Re: [libreoffice-users] Fedena 2.3.4 is Now Available

2013-09-08 Thread Fred James


Fred James wrote:

Luuk wrote:

On 07-09-2013 20:33, Tom Davies wrote:

Hi :)
Fred has been looking into it a bit more but we still haven't worked 
out if it really is bad.  It's still looking like a good product but 
it is more comparable with these;


http://open-school.org/
http://akuraschools.org/
http://centresis.org/



Above three sites seem commercial, offering services on the web..

http://www.projectfedena.org/
Is opensource, WITH the option to download source
(which i think is important for opensource!)

Demo-site is here: http://www.projectfedena.org/demo



But i'm still guessing what this has to do with libreoffice ;)

... to do with LibreOffice?  Nothing, obviously.
Side note ... daughter teaches at a university that uses Moodle ... 
hates it ... says it is painfully slow (your mileage may vary ... sigh)

Regards
Fred James




--
To unsubscribe e-mail to: users+unsubscr...@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] spreadsheet - sum one column based on the value of other

2013-09-08 Thread Fred James

Brian Barker wrote:

At 12:58 08/09/2013 -0300, Bruno Schneider wrote:

(omissions for brevity)


=SUMPRODUCT(B$2:B$5=E1;C$2:C$5)
so you can fill this down into F2.

How does this second method work?  Well, the test of equality gives a
value which can be interpreted as a number: 1 for TRUE and 0 for
FALSE.  Multiplying this by your value switches each value on or off
in the sum.

I trust this helps.

Brian Barker

Typo found :  switch the B's and C's so that the function reads:
=SUMPRODUCT(C$2:C$7,E1=B$2:B$7)
and it works.
Thanks ... I did enjoy that, and I learned something!
Regards
Fred James



--
To unsubscribe e-mail to: users+unsubscr...@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] spreadsheet - sum one column based on the value of other

2013-09-08 Thread Brian Barker

At 13:42 08/09/2013 -0400, Fred James wrote:

Brian Barker wrote:

=SUMPRODUCT(B$2:B$5=E1;C$2:C$5)
so you can fill this down into F2.


Typo found :  switch the B's and C's so that the function reads:
=SUMPRODUCT(C$2:C$7,E1=B$2:B$7)
and it works.


Er, there is no typo, just some confusion on your part.  The 
original formula works.  You have changed the test from X = Y to Y = 
X and the product X x Y into Y x X.  As any elementary mathematician 
knows, equality and multiplication are commutative, so these are the 
same thing: x = y and y = x are the same test; and 2 x 3 and 3 x 2 
are the same value!


Brian Barker


--
To unsubscribe e-mail to: users+unsubscr...@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: [tdf-discuss] Who copies from who the cloud legend?‏

2013-09-08 Thread theUser BL
Ok, for everyone who is interested, too, where the clud comes from:
I have asked on the AOO mailinglist and have become the answer.
http://mail-archives.apache.org/mod_mbox/openoffice-users/201309.mbox/raw/%3C522C7B3F.4010100%40t-online.de%3E

 it is the cloudCallout from presetShapeDefinitions.xml from ECMA-376.
 It is part of the standard specification of OOXML.

Greatings
theuserbl 
-- 
To unsubscribe e-mail to: users+unsubscr...@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] Table Breaks in Writer

2013-09-08 Thread Tom Davies
Hi :)
Hmm, i was really meaning the wider community rather than just people on this 
list.  With the rapid growth of LibreOffice it is highly likely that most 
people who have LibreOffice on their system are new to LibreOffice.  

Advice about migrations from FSF and other FOSS advocates often seems to 
suggest keeping whatever office suite a person already has and just add LO (or 
AOO).  Also because uninstallingreinstalling MS products is such a pain or 
because most office workers  have no idea how to uninstall stuff a lot of stuff 
just stays on the machine whether people use it or not.  For longer-term users  
those versions of MSO might be quite ancient, such as MS Office 2003 or 
earlier, because we haven't bothered to upgrade it.  [shrugs]

Recently OEMs have started putting trial versions of MSO on machines so that 
people have to pay an additional amount a month or so after starting to use 
their new machine but in the past it was really difficult to find and buy a 
machine that didn't have MSO pre-installed.  
Regards from
Tom :)  




 From: Brian Barker b.m.bar...@btinternet.com
To: users@global.libreoffice.org 
Sent: Sunday, 8 September 2013, 16:51
Subject: Re: [libreoffice-users] Table Breaks in Writer
 

At 18:48 07/09/2013 +0100, Tom Davies wrote:
Most of us have both LO and MS Office on our systems.

We are the subscribers to this mailing list, right?  For the 
benefit of thousands of readers, should we correct this by saying 
that the idea that most users of LibreOffice also have Microsoft 
Office installed is pretty unlikely - indeed, bordering on the risible?

Brian Barker


-- 
To unsubscribe e-mail to: users+unsubscr...@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
-- 
To unsubscribe e-mail to: users+unsubscr...@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] Download fails

2013-09-08 Thread Tom Davies
Hi :)
Getting a new web-browser is hardly similar to knocking the whole house down.  
It's more like just replacing the door rather than repainting it.  Hmm, it's 
not even that much because you can easily have 2 or more web-browsers on the 
same system and then just just which you feel like using at any particular 
moment.  

Yes, renaming the file-ending is easy for some of us but actually on a Windows 
machine it can be quite tough because the default settings are to hide those 
endings.  So renaming ends up with a file called 
blah.msi.man
except you don't see the .man so when the file keeps doing the same thing it's 
just not easy to see why.  

Going back to the analogy re-painting can be a pain because you have to either 
1.  leave a little border all around round the edge so that as the paint dries 
you can leave the door shut
2.  when you next try to open the door it's stuck and rips some of the paint 
off the edges but leaves other bits
3.  leave your door open to let your neighbours and passers-by in.  With 
oil-based gloss that's 24 hours.
So what initially seems the easiest and cheapest answer can easily turn out to 
be more of a pain (and more expensive if you nodded off and your neighbours 
nicked your stereo).  

Regards from 
Tom :)  





 From: Brian Barker b.m.bar...@btinternet.com
To: users@global.libreoffice.org 
Sent: Sunday, 8 September 2013, 16:45
Subject: Re: [libreoffice-users] Download fails
 

At 18:40 06/09/2013 +0100, Tom Davies wrote:
Ahh, i was wondering if it was some sort of manual or documentation.

So you were wrong, then?

Perhaps try downloading using some other web-browser other than IE?

If you don't like the colour of your front door, 
one solution is indeed to demolish your house and 
build a new one.  Or you can just repaint the 
front door.  Just rename .man to .msi.

... in the same way that Eskimos have a lot of 
different words meaning snow or ice whereas 
languages from hotter countries might not even have a word for it at all.

This is a hoax.  See Wikipedia: In fact, the 
Eskimo–Aleut languages have about the same number 
of distinct word roots referring to snow as 
English does   Buy yourself this for 
Christmas: http://tinyurl.com/snow-words .

Brian Barker


-- 
To unsubscribe e-mail to: users+unsubscr...@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
-- 
To unsubscribe e-mail to: users+unsubscr...@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] Table Breaks in Writer

2013-09-08 Thread Tom Davies
Hi :)  
Quite.  

For most people the answer is to shrug and pay the money because they are 
unaware of any other option and wherever they bought the machine from is 
unlikely to know either (or at least not admit to knowing).  



I just did a quick search for computers on Amazon (since it happened to be 
open due to someone else's post) and found about 3 out of the first 5 machines 
it listed claimed to have OpenOffice pre-installed, one of the machines was a 
chrome-book and the other just didn't seem to mention any programs bundled with 
the computer.  


So, things do seem to be improving a bit but i imagine MS will fight against 
that.  

Regards from 
Tom :)  





 From: James Knott james.kn...@rogers.com
To: users@global.libreoffice.org 
Sent: Sunday, 8 September 2013, 20:36
Subject: Re: [libreoffice-users] Table Breaks in Writer
 

Tom Davies wrote:
 Recently OEMs have started putting trial versions of MSO on machines so that 
 people have to pay an additional amount a month or so after starting to use 
 their new machine but in the past it was really difficult to find and buy a 
 machine that didn't have MSO pre-installed.  
 Regards from

A friend of mine got caught in that trap when she bought a new computer
a couple of years ago.  She called me up and asked how she could get
access to her documents.  OpenOffice to the rescue.
-- 
To unsubscribe e-mail to: users+unsubscr...@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] Table Breaks in Writer

2013-09-08 Thread James Knott
Tom Davies wrote:
 For most people the answer is to shrug and pay the money because they are 
 unaware of any other option and wherever they bought the machine from is 
 unlikely to know either (or at least not admit to knowing).  



 I just did a quick search for computers on Amazon (since it happened to be 
 open due to someone else's post) and found about 3 out of the first 5 
 machines it listed claimed to have OpenOffice pre-installed, one of the 
 machines was a chrome-book and the other just didn't seem to mention any 
 programs bundled with the computer.  


 So, things do seem to be improving a bit but i imagine MS will fight against 
 that.  

When I got a new Thinkpad, a couple of years ago, the first things I did
were:
1) Build a set of recovery discs.
2) Repartition and install Linux
3) Remove all the crapware from Windows, including that free MS Office.


-- 
To unsubscribe e-mail to: users+unsubscr...@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] spreadsheet - sum one column based on the value of other

2013-09-08 Thread Fred James

Brian Barker wrote:

At 13:42 08/09/2013 -0400, Fred James wrote:

Brian Barker wrote:

=SUMPRODUCT(B$2:B$5=E1;C$2:C$5)
so you can fill this down into F2.


Typo found :  switch the B's and C's so that the function reads:
=SUMPRODUCT(C$2:C$7,E1=B$2:B$7)
and it works.


Er, there is no typo, just some confusion on your part.  The 
original formula works.  You have changed the test from X = Y to Y = X 
and the product X x Y into Y x X.  As any elementary mathematician 
knows, equality and multiplication are commutative, so these are the 
same thing: x = y and y = x are the same test; and 2 x 3 and 3 x 2 are 
the same value!


Brian Barker
Sorry ... yes: x=y is the same as y=x, but when testing the original 
function the results were incorrect.  Switching the b's and c's made the 
function return the correct results.  Assumption (on my part):

the first part (C$2:C$5) is the column of values to be summed
the second part (E1=) is the value we want to match in the third part
the third part (B$2:B$5) is the column/range of values to be 
matched by the second part

¿Sí?
So if we used column B for the first part we would be trying to sum 
labels/text, and if we used C in the third part, we would be trying to 
match labels/text to numbers?


Or did I miss something?

In any case, I must thank you for pointing to this solution ... it is 
great ... I really enjoyed this.

Regards
Fred James



--
To unsubscribe e-mail to: users+unsubscr...@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] Grouping objects in Draw

2013-09-08 Thread Girvin Herr

Carl,
If you can select all the objects you want to group, which seems to be 
the case if you can then move them, try right-clicking on the selected 
group and then use the Group option in the popup to make them a group.


If, on the other hand, you want to select an object or more within the 
larger background object without selecting the larger object, then you 
must put the larger object on another layer and make the layer 
unchangeable.  Look up layers in the manual to see how to do this.  I 
had the latter problem and couldn't see how to select the smaller object 
I wanted to move without selecting the larger object it was on top of.  
This forum set me straight about layers and I was then able to select 
the smaller object without selecting the underlying larger object.


Hope this helps.
Girvin Herr



On 09/08/2013 10:32 AM, Carl Paulsen wrote:
I have 3 objects I'd like to combine in Draw (one background image, 
another image over a portion of the background and one text block also 
over the background).  I'd like to somehow combine them into one 
object (used to be done by grouping them) that I can then copy and 
paste elsewhere and re-size as needed without having to separately 
resize each object.  I can't seem to make this happen.


I can't seem to select each object so as to group them.  I was able to 
select the background object (which extends beyond the edges of the 
other two objects) and selected Modify-Group, and they all seemed to 
become a part of some kind of group.  I can then copy and paste that 
group, but I can't re-size the group as a whole.


I essentially want to group each object into one so that it gets 
treated as if it were one object, not three.


Can anyone help?

Thanks,



--
To unsubscribe e-mail to: users+unsubscr...@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] Grouping objects in Draw

2013-09-08 Thread Regina Henschel

Hi Carl,

Carl Paulsen schrieb:

I have 3 objects I'd like to combine in Draw (one background image,
another image over a portion of the background and one text block also
over the background).  I'd like to somehow combine them into one object
(used to be done by grouping them) that I can then copy and paste
elsewhere and re-size as needed without having to separately resize each
object.  I can't seem to make this happen.

I can't seem to select each object so as to group them.  I was able to
select the background object (which extends beyond the edges of the
other two objects) and selected Modify-Group, and they all seemed to
become a part of some kind of group.  I can then copy and paste that
group, but I can't re-size the group as a whole.


If you can group them but not re-size, it might be, that one of the 
objects is protected. Enter the group, click an object, open 
positionsize dialog on tab positionsize, and look at section 
'Protect'. Examine all objects this way.





I essentially want to group each object into one so that it gets treated
as if it were one object, not three.

Can anyone help?


Kind regards
Regina


--
To unsubscribe e-mail to: users+unsubscr...@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: spacing after punctuation

2013-09-08 Thread Virgil Arrington
If it helps, and I doubt it will, as a member of the larger audience, I 
fully understood what John was describing based on what he had written, 
which is exactly as Tom represented it.


Virgil

-Original Message- 
From: Brian Barker

Sent: Sunday, September 08, 2013 11:44 AM
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Re: spacing after punctuation

At 16:08 08/09/2013 +0100, Tom Davies wrote:
I think John was trying to describe Framemaker and how it differs from 
Writer.


Unsurprisingly, I was commenting on what he said (not what someone
else thinks he was trying to do) and thinking of its effect on his
large audience on this list.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscr...@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



--
To unsubscribe e-mail to: users+unsubscr...@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: spacing after punctuation

2013-09-08 Thread Toki Kantoor
On 09/07/2013 06:08 PM, Bruce Byfield wrote:

 No, they're not, actually. You don't find publishers using MS Word files, 
 which are simply not up to the job.

I don't know what publishers you are looking at, but all of the
publishers whose submission guidelines I've read, have requested files
in MS Doc file format. (FWIW, I've read over the submission guidelines
of over 100 publishers in the last year.)

 I think the avoidance of true small caps and old style numbering has more to 
 do with the practice of font creators, most of whom omit these features.

That might be true for FLOSS font creators. It is not true for the
foundries whose fonts are in the 4+ digit price range.

jonathon
-- 
LibreOffice in a Multi-Lingual Environment.

-- 
To unsubscribe e-mail to: users+unsubscr...@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] spreadsheet - sum one column based on the value of other

2013-09-08 Thread jorge
Hi all:

Why not use the pilot table (Dinamic table) ? If you don't know How ? ,
let me to know and I will try to help you.

Regards,

Jorge Rodríguez 



El dom, 08-09-2013 a las 17:29 +0100, Brian Barker escribió:
 Name - Category - Value
 lunch - food - 20
 fuel - transportation - 100
 dinner - food - 20
 repairs - transportation - 200
 
 
-- 
Atentamente,

Jorge Rodríguez


-- 
To unsubscribe e-mail to: users+unsubscr...@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: spacing after punctuation

2013-09-08 Thread Bruce Byfield
On 09/07/2013 06:08 PM, jonathon wrote:

I don't know what publishers you are looking at, but all of the
publishers whose submission guidelines I've read, have requested files
in MS Doc file format. (FWIW, I've read over the submission guidelines
of over 100 publishers in the last year.)

You missed the context, which was the format publishers use for layout and 
which they asked contracted writers to submit in -- not the format they accept 
for submissions.

 I think the avoidance of true small caps and old style numbering has more 
to  do with the practice of font creators, most of whom omit these features.

That might be true for FLOSS font creators. It is not true for the
foundries whose fonts are in the 4+ digit price range.

That's a very rareified category of fonts. Look at Adobe and other popular 
foundries, and you'll find that including small caps and old style numbering 
are rare enough that, when a typeface does include them, they are major 
selling points.

-- 
Bruce Byfield 604-421-7189 (on Pacific time)
blog: https://brucebyfield.wordpress.com
website: http://members.axion.net/~bbyfield/

-- 
To unsubscribe e-mail to: users+unsubscr...@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] Automatic Capitalization of First Word

2013-09-08 Thread Dale Erwin

On 9/8/2013 9:54 AM, Tom Davies wrote:

Hi :)
It looks like you are not yet fully subscribed.


The confirmation email often goes into junk or spam folders if it can't be 
found in your inbox.

Sorry about that!
Regards from
Tom :)


I think I'm subscribed now.  The confirmation mail finally arrived, and 
today I received over 30 messages from the list.


--
Dale Erwin
Jr. 28 de Julio 657, Depto. 03
Magdalena del Mar, Lima 17 PERU
http://leather.casaerwin.org


--
To unsubscribe e-mail to: users+unsubscr...@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] Publishing a Dictionary

2013-09-08 Thread Dale Erwin
I have compiled a bilingual dictionary and am having lots of trouble 
trying to format it in LO Writer as well as in AOO Writer.  What I want 
to accomplish is having a field at the top of the page, left justified 
on left pages (even numbered) and right justified on right pages (odd 
numbered).  On left pages, this field would contain the first word on 
that page and on right pages, this field would contain the last word on 
that page.  This is quite common for dictionaries of all types.


Unfortunately, the header cannot be used for this short of having a 
separate style for every page in the book (over 300).  I have also tried 
putting these search words on the first text line of the page and then 
beginning the text two or three lines below that.  Then, if any 
modification results in an additional line, every subsequent page must 
be modified.


Maybe I'm missing something.  If anyone knows of a solution to this, I 
would certainly appreciate knowing about it.


--
Dale Erwin
Jr. 28 de Julio 657, Depto. 03
Magdalena del Mar, Lima 17 PERU
http://leather.casaerwin.org


--
To unsubscribe e-mail to: users+unsubscr...@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] spreadsheet - sum one column based on the value of other

2013-09-08 Thread Brian Barker

At 16:19 08/09/2013 -0400, Fred James wrote:

Brian Barker wrote:
Er, there is no typo, just some confusion on your part.  The 
original formula works.  You have changed the test from X = Y to Y 
= X and the product X x Y into Y x X.  As any elementary 
mathematician knows, equality and multiplication are commutative, 
so these are the same thing: x = y and y = x are the same test; and 
2 x 3 and 3 x 2 are the same value!


Sorry ... yes: x=y is the same as y=x, but when testing the original 
function the results were incorrect.


We cannot know how, of course - but you must have tested it 
incorrectly!  (I tested it, too.)



Switching the b's and c's made the function return the correct results.


But you haven't just done that: the comparison is still between the 
Bs and the E (though reversed) and the product is still between the 
B/E switch and the Cs (though also reversed).



Assumption (on my part):
the first part (C$2:C$5) is the column of values to be summed
the second part (E1=) is the value we want to match in the third part
the third part (B$2:B$5) is the column/range of values to be 
matched by the second part


Yes: this also works - but there is no need to modify the original 
formula.  Your chosen order of parts is not necessary for the formula 
to work.  I'm not finding fault with your formula, but you are - 
incorrectly - with mine!


So if we used column B for the first part we would be trying to sum 
labels/text, and if we used C in the third part, we would be trying 
to match labels/text to numbers?


No!  In my original formula, the E value was still compared with the 
Bs and the product made between the resulting switch and the Cs.



Or did I miss something?


Obviously yes: please go back and read my version again!

In any case, I must thank you for pointing to this solution ... it 
is great ... I really enjoyed this.


Good-oh!  I have to say that SUMPRODUCT() had not been the first 
thing I'd think of in situations such as this - but I picked up the 
powerful technique from experts on this and similar lists.


Brian Barker


--
To unsubscribe e-mail to: users+unsubscr...@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] Download fails

2013-09-08 Thread Brian Barker

At 20:48 08/09/2013 +0100, Tom Davies wrote:
Yes, renaming the file-ending is easy for some of us but actually on 
a Windows machine it can be quite tough because the default settings 
are to hide those endings.  So renaming ends up with a file called 
blah.msi.man except you don't see the .man so when the file keeps 
doing the same thing it's just not easy to see why.


The original questioner says OK, that works, thanks.


... re-painting can be a pain ...


I suggest you try frontdoorpaint-us...@somewhereorother.com.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscr...@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] Table Breaks in Writer

2013-09-08 Thread Brian Barker

At 20:30 08/09/2013 +0100, Tom Davies wrote:
Hmm, i was really meaning the wider community rather than just 
people on this list.


No-one would guess that you meant we to mean that!

Recently OEMs have started putting trial versions of MSO on machines 
so that people have to pay an additional amount a month or so after 
starting to use their new machine ...


So after a month they would either purchase Microsoft Office and not 
need LibreOffice or else install LibreOffice and no longer have a 
functioning copy of Microsoft Office?  In neither case would they have both ...


Brian Barker


--
To unsubscribe e-mail to: users+unsubscr...@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: spacing after punctuation

2013-09-08 Thread Brian Barker

At 17:35 08/09/2013 -0400, Virgil Arrington wrote:

If it helps, and I doubt it will, ...


Ho, ho!  You are so unsure of your own position?

... as a member of the larger audience, I fully understood what John 
was describing based on what he had written, ...


As did we all, I'm sure.  But what he wrote wasn't a fair comparison.


... which is exactly as Tom represented it.


Well, he said I think John was trying to describe Framemaker and how 
it differs from Writer.  (It happens that this was wrong anyway: the 
original claim contrasted Writer and Framemaker on the one hand 
against page layout applications on the other.)  The original 
message put Writer in one group, in which a document consists of a 
continuous stream of text. If you insert additional text at the 
beginning, all the text moves down, including the creation of new 
pages at the end if necessary.  No mention of frames.  Then there 
was the other group of page layout software, in which each page is a 
container. Everything that goes on a page goes into a graphics or a 
text frame.  Everything is frames.


The impression was clearly given that Writer didn't do frames.  The 
original poster has assured us he knows that Writer can handle 
frames, so what is left to discuss, please?  My concern was not you - 
I'm confident you know the facts already! - or him, but the thousands 
of other list subscribers out there who could have been persuaded to 
believe that Writer wouldn't do linked frames.  That would be a pity.


Brian Barker


--
To unsubscribe e-mail to: users+unsubscr...@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] Publishing a Dictionary

2013-09-08 Thread Toki Kantoor
On 09/09/2013 02:10 AM, Dale Erwin wrote:

 What I want to accomplish is having a field at the top of the page,
left justified on left pages (even numbered) and right justified on
right pages (odd numbered). On left pages, this field would contain the
first word on that page and on right pages, this field would contain the
last word on that page.

Create a page style for the left hand page, and a different page style
for the right hand page.

To get the first word defined on the page into the header, requires:
* The defined word to be the only word on the line;
* The defined word is on the first line of the new page;

If it is acceptable to have the last defined word of the previous page
being in the header, then the only requirement is that the defined word
be the only word on the line.

I don't know how to get the last defined word into the header of the
page.  :(

If you want to use a running heading for the defined word, you can do
so, but at the expense of having an apparently blank line between each word.

 Maybe I'm missing something.  If anyone knows of a solution to this, I
 would certainly appreciate knowing about it.

It is theoretically possible to write a macro to place the first defined
word and last defined word of the page, into the header field of the
page. I can't offer any help to that end, though.

jonathon
-- 
LibreOffice in a Multi-Lingual Environment.

-- 
To unsubscribe e-mail to: users+unsubscr...@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 use the Tradutor extension

2013-09-08 Thread LeroyTennison
I have:

installed it
restarted LibreOffice 3.5
changed the default language to Spanish (Spain) for a documen
tsaved the document afterward
opened the document
set the language to English (which is what it is written in)
highlighted different common words
changed the language to Spanish
clicked Translate
Nothing happens

Any help would be appreciated.  If a different translation program would be
better I'm open to that as well.



--
View this message in context: 
http://nabble.documentfoundation.org/How-to-use-the-Tradutor-extension-tp4073514.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@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