[libreoffice-users] How to use the Tradutor extension

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 Tra

Re: [libreoffice-users] Publishing a Dictionary

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

Re: [libreoffice-users] Table Breaks in Writer

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 a

Re: [libreoffice-users] Re: spacing after punctuation

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] Download fails

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

[libreoffice-users] Publishing a Dictionary

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

Re: [libreoffice-users] spreadsheet - sum one column based on the value of other

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 multipli

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

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 arriv

Re: [libreoffice-users] Re: spacing after punctuation

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 m

Re: [libreoffice-users] spreadsheet - sum one column based on the value of other

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

Re: [libreoffice-users] Re: spacing after punctuation

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] Re: spacing after punctuation

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

Re: [libreoffice-users] Grouping objects in Draw

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 cop

Re: [libreoffice-users] Grouping objects in Draw

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 lar

Re: [libreoffice-users] spreadsheet - sum one column based on the value of other

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] Table Breaks in Writer

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

Re: [libreoffice-users] Table Breaks in Writer

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 happe

Re: [libreoffice-users] Download fails

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

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

Re: [libreoffice-users] Table Breaks in Writer

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 seem

[libreoffice-users] open a file in CMIS from the command line

Executing LibreOffice from the command line is often useful (ie launching the exe from a browser) 1) How can we open a document in LibreOffice using CMIS protocol using the command line? ie : soffice.exe -cmis "//sub.domain.com:443/cmis/Nouveau%20Texte%20OpenDocument.odt" 2) Does the CMIS serve

[libreoffice-users] RE: [tdf-discuss] Who copies from who the cloud legend?‏

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.

Re: [libreoffice-users] spreadsheet - sum one column based on the value of other

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 o

Re: [libreoffice-users] spreadsheet - sum one column based on the value of other

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 f

Re: oops! Re: [libreoffice-users] Re: [libreoffice-users] Fedena 2.3.4 is Now Available

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

[libreoffice-users] Grouping objects in Draw

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

[libreoffice-users] Re: Base: How to Duplicate a Record

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 us

Re: [libreoffice-users] spreadsheet - sum one column based on the value of other

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 val

Re: [libreoffice-users] spreadsheet - sum one column based on the value of other

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

[libreoffice-users] spreadsheet - sum one column based on the value of other

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

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

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

Re: [libreoffice-users] Re: spacing after punctuation

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

[libreoffice-users] Re: Chart, Custom Menu Problems in LibreOffice 4.0.5

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] Automatic Capitalization of First Word

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 To: users@global.libreoffice.org Sent: Satur

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 t

Re: [libreoffice-users] Re: spacing after punctuation

On Sun, 08 Sep 2013 09:36:29 +0100 Brian Barker 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 appe

[libreoffice-users] Chart, Custom Menu Problems in LibreOffice 4.0.5

After upgrading LibreOffice from 3.6.7.2 to 4.0.5, I got strange appearances in the charts of a spreadsheet file I've had since the start of this year (see attachments, if they're allowed). In three of the four charts, the numbers of one or both axes are unexpectedly inclined about 30 degrees;

Re: oops! Re: [libreoffice-users] Re: [libreoffice-users] Fedena 2.3.4 is Now Available

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

Re: [libreoffice-users] Re: spacing after punctuation

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 app

Re: [libreoffice-users] Table Breaks in Writer

-- Forwarded message -- From: e-letter Date: Sun, 8 Sep 2013 08:49:34 +0100 Subject: Re: [libreoffice-users] Table Breaks in Writer To: Robert Burnett Cc: users@global.libreoffice.org On 07/09/2013, Robert Burnett wrote: > > Problem, I use writer and have a 2 page document that