Re: [libreoffice-users] A feature, or ...?

2013-07-11 Thread Virgil Arrington
Once you apply your style, you can clear any direct formatting by selecting the text and hitting Ctrl-M. Everything should then snap to the style-controlled formatting. Virgil -Original Message- From: Jan Andersen Sent: Thursday, July 11, 2013 1:50 AM To: libreoffice Subject: Re:

Re: [libreoffice-users] Book-writing with Writer

2013-07-11 Thread Virgil Arrington
Okay, this is really spooky, or I'm just growing paranoid. Two days ago, I downloaded Scrivener. Yesterday, I clicked on the hipiers link suggested below. Today, I receive an email from Amazon suggesting I buy the book, Writers Tune-up Manual. Virgil -Original Message- From:

Re: [libreoffice-users] Book-writing with Writer

2013-07-11 Thread Tom Davies
Hi :) I think ani-privacy is an array of automated processes that is waaay out of anyone's control now.  Just click on the Spam button and let your filters learn what to block and what to accept.  People love to share intimate details of their life with everyone across the planet (Facebook,

Re: [libreoffice-users] Re: Libre Vs office

2013-07-11 Thread Tom Davies
Hi :) Thanks :)  I think that reinforces the point that Sigrid originally made.  I am often surprised how few people know about those 4 but then i didn't know about the Mac ones being almost identical.  So, thanks for that :D  Next time i am on my buddies Macbook i might be able to surprise him

Re: [libreoffice-users] Book-writing with Writer

2013-07-11 Thread Kracked_P_P---webmaster
hipiers.com does not send out spam emails, or it should not since the owner of the domain is against spam as much as we are. I do not know anything about Scrivener or its web site. Did you do a Google or Amazon search for writer info, a book search, or some other one that might make you

Re: [libreoffice-users] Liber office help with Excel library

2013-07-11 Thread Tom Davies
Hi :) Macros need to be translated into a less vulnerable language.  I think the version of Basic used in LibreOffice/OpenOffice is fairly similar and you might even get a few people helping you here if you can post the code to the list.  They might even help smooth out some rough spots to

[libreoffice-users] Calc bug?

2013-07-11 Thread Mark Stanton
I'm not a frequent Calc user, so this might be just plain wrong, however... With a very wide table I can (as is standard in most GUIs) go a page right (or probably left) at a time by clicking in the scrollbar between the end stop and the current position indicator. However, if the column

Re: [libreoffice-users] Re: Base DB Connections

2013-07-11 Thread Tom Davies
Hi :) I am impressed that this list was able to help you migrate your obvious talent so quickly.  Andrew's skills with macro programming are quite extreme so getting praise from him is impressive!  It is also great to see you use those new skills to help others on this list and help disseminate

Re: [libreoffice-users] Book-writing with Writer

2013-07-11 Thread Tom Davies
Hi :) Errr, just my own personal opinion of course and on a bad hair day Try watching Monty Python and the Holy Grail, particularly the scene with the peasants working in the field and claiming to be an autonomous collective and then admitting their lord was out to lunch.  Regards from Tom :) 

Re: [libreoffice-users] Auto-sort group of cells when any cell is modified/saved?

2013-07-11 Thread Tanstaafl
Thanks for your efforts Johnny, sorry I didn't reply sooner. We do actually add the data into a separate sheet already, then the sheet that we want to be sorted just references those cells for each Sales Rep. But... this all looks a bit too complicated/fragile for me to be comfortable with

[libreoffice-users] QA Triage Contest

2013-07-11 Thread Joel Madero
Hi All, So as you all know the contest is over and it was a great success. Just under 25% of the bug count dropped but substantially more bugs were triaged as we kept up with the daily demand on top of tackling older bug reports. This being said, there is no reason why we shouldn't continue

Re: [libreoffice-users] Auto-sort group of cells when any cell is modified/saved?

2013-07-11 Thread Errol Goetsch
Hi all You can get to a auto-sorted table in 4 steps without macros by using vlookup, hlookup, count, max and min. Ive sent Charles a working example for 20 salespeople over 12 months, where the duplicate list re-sorts as soon as the YTD total changes. I couldn't bear the thought of Charles

Re: [libreoffice-users] Auto-sort group of cells when any cell is modified/saved?

2013-07-11 Thread Tanstaafl
Thanks Errol, Trying to work out how it works as we speak... :) On 2013-07-11 10:58 AM, Errol Goetsch er...@xe4.org wrote: Hi all You can get to a auto-sorted table in 4 steps without macros by using vlookup, hlookup, count, max and min. Ive sent Charles a working example for 20 salespeople

Re: [libreoffice-users] Auto-sort group of cells when any cell is modified/saved?

2013-07-11 Thread Johnny Rosenberg
2013/7/11 Errol Goetsch er...@xe4.org: Hi all You can get to a auto-sorted table in 4 steps without macros by using vlookup, hlookup, count, max and min. Ive sent Charles a working example for 20 salespeople over 12 months, where the duplicate list re-sorts as soon as the YTD total changes.

Re: [libreoffice-users] Auto-sort group of cells when any cell is modified/saved?

2013-07-11 Thread Dave Barton
Johnny Rosenberg wrote: 2013/7/11 Errol Goetsch er...@xe4.org: Hi all You can get to a auto-sorted table in 4 steps without macros by using vlookup, hlookup, count, max and min. Ive sent Charles a working example for 20 salespeople over 12 months, where the duplicate list re-sorts as soon

[libreoffice-users] Re: Auto-sort group of cells when any cell is modified/saved?

2013-07-11 Thread ErrolG
Hi JohnnySheet 1 auto-sorts a numerical table using rank, vlookup and countif, sheet 2 uses hlookup, vlookup, countif, max and min.Sheet 1 simpler by far.The trick with both is sorting duplicate values. The solution involves using countif to identify duplicates, adding 1/frequency to the rank

[libreoffice-users] Re: QA Triage Contest

2013-07-11 Thread Nino Novak
Am 11.07.2013 16:36, schrieb Joel Madero: Hi All, So as you all know the contest is over and it was a great success. Just under 25% of the bug count dropped but substantially more bugs were triaged as we kept up with the daily demand on top of tackling older bug reports. Joel, can we see

[libreoffice-users] spelling correction

2013-07-11 Thread Walther Koehler
Salute, LO-fans, I have a problem with spell check: given: This is a rong sntence with man mistokes. spell check f7 marks with a red underline what should be changed. So far so well. but 1) When adding manually w before rong and pressing change, spell check will jump back to the start of the

Re: [libreoffice-users] Auto-sort group of cells when any cell is modified/saved?

2013-07-11 Thread Errol Goetsch
https://docs.google.com/file/d/0B6LXy9sguZVkSXVqdnBWd0tVWUk/edit?usp=sharing 2 ways to auto-sort a numerical table using simple formulae when cells in a totals column are modified On 2013/07/11 06:00 PM, Dave Barton wrote: Johnny Rosenberg wrote: 2013/7/11 Errol Goetsch er...@xe4.org: Hi

Re: [libreoffice-users] spelling correction

2013-07-11 Thread Fred James
Walther Koehler wrote: Salute, LO-fans, I have a problem with spell check: given: This is a rong sntence with man mistokes. spell check f7 marks with a red underline what should be changed. So far so well. but 1) When adding manually w before rong and pressing change, spell check will jump

Re: [libreoffice-users] spelling correction

2013-07-11 Thread Steve Edmonds
On 2013-07-12 05:21, Fred James wrote: Walther Koehler wrote: Salute, LO-fans, I have a problem with spell check: given: This is a rong sntence with man mistokes. spell check f7 marks with a red underline what should be changed. So far so well. but 1) When adding manually w before rong and

Re: [libreoffice-users] Libre Vs office

2013-07-11 Thread Jean-Baptiste Faure
Hi, Le 10/07/2013 07:43, Mukund Tavag a écrit : Hi, We are planning to use this LibreOffice, Can I get the exact commands comparison between LibreOffice and MS Office. Online Help (F1 key) could be useful here: tab Contents, Chapter Common Help Topics, the second section is LibreOffice and

Re: [libreoffice-users] spelling correction

2013-07-11 Thread Tom Davies
Hi :) Top left box of the spell-check dialogue-box shows the context of the spelling mistook.  It lets me edit in there and then i click the Change button.  I might be doing something rong there tho.  Who needs the w in rong anyway?  It's quite a quiet w and possibly over-rated.  Regard from

[libreoffice-users] .odt to .rtf ?

2013-07-11 Thread Helen
I agreed to edit (one time only) a local literary magazine comeing out soon. I have saved each of the documents (plays, poetry, etc.) and edited in LibreOffice. Before sending the files to the publisher, I've been saving them to .doc. The publisher emails to say that all the documents have weird

Re: [libreoffice-users] .odt to .rtf ?

2013-07-11 Thread James Knott
Helen wrote: The publisher emails to say that all the documents have weird formatting and strange characters. I thought recent version of Word used the new WTF format. ;-) Actually, I just checked LibreOffice on openSUSE and saw there is an RTF option. Check again. -- To unsubscribe

Re: [libreoffice-users] .odt to .rtf ?

2013-07-11 Thread Tim Lloyd
Hi Helen, what version of LO are you using? When I do as a save as in LO4.0.4.2 I can see .rtf 4th from bottom of the list of formats. Cheers On 07/12/2013 11:18 AM, Helen wrote: I agreed to edit (one time only) a local literary magazine comeing out soon. I have saved each of the documents

Re: [libreoffice-users] Book-writing with Writer

2013-07-11 Thread rost52
As a proud papa... I would open the document in Writer, select all and set styles to Default. Then create the styles I wanted and reformat the whole document. On 12.07.2013 01:17, Wolfgang Keller wrote: For example, several years ago, my 14 year old son challenged himself to type a 50,000 word

Re: [libreoffice-users] Book-writing with Writer

2013-07-11 Thread Jack Wallen
On 07/11/2013 10:00 PM, rost52 wrote: As a proud papa... I would open the document in Writer, select all and set styles to Default. Then create the styles I wanted and reformat the whole document. On 12.07.2013 01:17, Wolfgang Keller wrote: I'll reiterate this again -- if you're self

Re: [libreoffice-users] .odt to .rtf ?

2013-07-11 Thread Tom Davies
Hi :) Sometimes you have to scroll backward up the list above the starting point of the drop-down.  However, it is very unusual to hear of (or see) a .Doc getting malformed!  .DocXs go weird sometimes because each version of MSO does it slightly differently.  But even those shouldn't be

Re: [libreoffice-users] spelling correction

2013-07-11 Thread Walther Koehler
Am Donnerstag, 11. Juli 2013 schrieb Fred James: Walther Koehler wrote: Salute, LO-fans, I have a problem with spell check: given: This is a rong sntence with man mistokes. spell check f7 marks with a red underline what should be changed. So far so well. but 1) When