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

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:

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

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/

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

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

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:

[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

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. 

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.

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

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

[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

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:

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

[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

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

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

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

[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

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

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

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

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

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,

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

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

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:

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

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

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

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

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

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

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

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

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

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,

[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