Re: [libreoffice-users] HOW CAN I CONVERT A NUMBER IN LibreOffice CALC TO TEXT IN LibreOffice CALC?

2014-02-22 Thread Peter West
and insufferable. I know, I know. But my desire is to see all of this nonsense fade away into an easy-going environment of live and let live. Bakunin before Lenin, and classical small-l liberalism before either. Peter West And he said to them, Do you not yet understand? On 23 Feb 2014, at 7:41 am

Re: [libreoffice-users] Neat Writer Feature -- Relative Font Sizes

2014-02-13 Thread Peter West
TeX (and LaTeX) is one of those things I was always gunna learn to use. More power to you. -- Peter West What comes out of a man is what defiles him. On 14/02/2014 8:55 am, e-letter wrote: OK, fair enough but as a latex user, was amazed to read a claim that LO provides greater control

Re: [libreoffice-users] Truce

2014-02-06 Thread Peter West
What do you do with these guys? They can't help themselves. Libre? Ha. On 6/02/2014 9:06 pm, e-letter wrote: On 06/02/2014, Peter West li...@pbw.id.au wrote: When I see someone hinting, suggesting, urging or just plain bullying a top-poster to reform his or her bad habits, I'll buy

Re: [libreoffice-users] Re: low traffic lately?

2014-02-05 Thread Peter West
the argument? How can the discussion be read sequentially when bits of it have been deleted? -- Peter West For what does it profit a man if he gains the whole world and loses or forfeits himself? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http

[libreoffice-users] Truce

2014-02-05 Thread Peter West
we just let posters do their own thing? -- Peter West For what does it profit a man if he gains the whole world and loses or forfeits himself? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe

Re: [libreoffice-users] Re: low traffic lately?

2014-02-04 Thread Peter West
, please, top-post. Fellas, look in the mirror. On 4/02/2014 5:36 pm, pete nikolic wrote: On Tue, 04 Feb 2014 05:33:24 + Brian Barker b.m.bar...@btinternet.com wrote: At 09:58 04/02/2014 +1000, Peter West wrote: It mystifies me that some ossers become tossers on this particular topic

Re: [libreoffice-users] diff of 2 docx files

2014-02-04 Thread Peter West
not registered to this list, so please add me in CC. -- Peter West ...and a sword will pierce through your own soul also... -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines

Re: [libreoffice-users] Re: Removing Index Markers from Writer: a How-To

2014-02-04 Thread Peter West
could be done with earlier open office documents). Since LO can easily write and read fodt files, though, it really wasn't necessary to do any file format conversion, and I didn't bother spending the time to figure out how to do everything in one shot. Frank -- Peter West ...and a sword will pierce

Re: [libreoffice-users] Re: low traffic lately?

2014-02-04 Thread Peter West
This sent to me off-list. No further comment required. On 5/02/2014 12:24 am, Anthony Baldwin wrote: On 2/4/2014 2:59 AM, Peter West wrote: Why is, do you think, that people feel the need to apologise on this very list for bottom-posting? Because of my ad-hominem attacks? It must be, because

Re: [libreoffice-users] diff of 2 docx files

2014-02-04 Thread Peter West
On 4/02/2014 8:08 pm, Peter West wrote: If you write the files out as .fodt (Flat XML) files from within LO, you will have straight XML files to compare. Beyond that, you could get the tika-app.jar from the Apache Tika project, which will let you extract plain text from the .fodt files

Re: [libreoffice-users] Re: Removing Index Markers from Writer: a How-To

2014-02-04 Thread Peter West
D'uh! Thanks Frank. I've updated the script with that change. Attachments aren't accepted by this list, are they? What did you mean by post the shell script? Peter Peter West ...and a sword will pierce through your own soul also... On 5/02/2014 1:54 am, CVAlkan wrote: Peter: The actual

Re: [libreoffice-users] Re: low traffic lately?

2014-02-03 Thread Peter West
mailing lists for LibreOffice seem to use top-posting almost exclusively whereas many other Open Source projects bottom-post. LibreOffice is one of the gateway projects into the world of Open Source so it makes sense to guide people gently. -- Peter West ...and a sword will pierce through your

Re: [libreoffice-users] Re: Removing Index Markers from Writer: a How-To

2014-02-03 Thread Peter West
-- View this message in context: http://nabble.documentfoundation.org/Removing-Index-Markers-from-Writer-a-How-To-tp4094327p4094482.html Sent from the Users mailing list archive at Nabble.com. -- Peter West ...and a sword will pierce through your own soul also... -- To unsubscribe e-mail to: users

Re: [libreoffice-users] Re: Removing Index Markers from Writer: a How-To

2014-02-03 Thread Peter West
The file name goes at the end of the command, of course. On 4/02/2014 3:44 pm, Peter West wrote: Hi Frank, Finally got back to this. Can you check this for me against an .fodt file, please? perl -pi'orig_*' -e 's/text:alphabetical-index-mark text:string-value=[[:alpha:]]*//g' -- Peter

Re: [libreoffice-users] Where is the documentation for soffice command line execution?

2014-01-30 Thread Peter West
Thanks folks. soffice --help did the trick. On 29/01/2014 11:03 am, Peter West wrote: There are plenty of snippets on the web about using soffice command line for document conversion, for example, but I cannot find documentation. Looking for 'soffice' in the LO help file yields no results

[libreoffice-users] A word of warning about PDF text

2014-01-30 Thread Peter West
doubts. -- Peter West Other seed fell among thorns, and the thorns grew up and choked it... -- 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

Re: [libreoffice-users] Writer - Merging PDFs

2014-01-29 Thread Peter West
PDF or once all the PDFs are merged into one larger PDF? Thanks so much, Charles. -- Peter West Other seed fell among thorns, and the thorns grew up and choked it... -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help

Re: [libreoffice-users] Writer - Merging PDFs

2014-01-29 Thread Peter West
have to start from the beginning. Let me know how you go. On 30/01/2014 2:28 am, Cliff Scott wrote: ** Reply to message from Peter West li...@pbw.id.au on Wed, 29 Jan 2014 23:04:39 +1000 Peter, Could you explain off list how to do it with Preview? I've looked it over and there is no obvious way I

Re: [libreoffice-users] Re: low traffic lately?

2014-01-28 Thread Peter West
the list. The mail client must have something to do with it, as well; I use Thunderbird and have a Reply List option on this list, while on some others I do and some I don't. Dave -- Peter West ...for whoever exalts himself will be humbled, and whoever humbles himself will be exalted

[libreoffice-users] Where is the documentation for soffice command line execution?

2014-01-28 Thread Peter West
There are plenty of snippets on the web about using soffice command line for document conversion, for example, but I cannot find documentation. Looking for 'soffice' in the LO help file yields no results. Anyone have any idea? -- Peter West Other seed fell among thorns, and the thorns grew up

Re: [libreoffice-users] Removing Index Markers from Writer: a How-To

2014-01-28 Thread Peter West
the text substitutions 2) as above to re-establish the modified .odt file. Peter West Other seed fell among thorns, and the thorns grew up and choked it... On 29/01/2014 1:45 am, CVAlkan wrote: In previous posts, I described how Writer adds extra index markers when updating an Alphabetical Index

Re: [libreoffice-users] malfunzione

2014-01-25 Thread Peter West
Thanks Brad, I follow that, but that doesn't seem to be what the OP was saying. Peter West ...for he had healed many, and all who had diseases pressed upon him, to touch him. On 25 Jan 2014, at 9:53 pm, Brad Rogers b...@fineby.me.uk wrote: On Sat, 25 Jan 2014 09:27:33 +1000 Peter West li

Re: [libreoffice-users] malfunzione

2014-01-24 Thread Peter West
the page. You have the same number of columsn whether you start at 31 or 1. Is Guglielmo saying that the Excel sheet starts at 1? Or is he just asking how to move the column? Peter West ...for he had healed many, and all who had diseases pressed upon him, to touch him. -- To unsubscribe e-mail

[libreoffice-users] How to copy a frame with its text and sub-frame contents?

2014-01-22 Thread Peter West
. Having created one half, I now want to copy the lot, and place it in the second frame. How? Peter West Those who are well have no need of a physician, but those who are sick... -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help

Re: [libreoffice-users] How to copy a frame with its text and sub-frame contents?

2014-01-22 Thread Peter West
West Those who are well have no need of a physician, but those who are sick... On 22 Jan 2014, at 10:39 pm, Peter West li...@pbw.id.au wrote: I'm creating a flyer to be printed on an A4 sheet, which will then be cut in half, so I want identical contents on the top and bottom halves of the page

Re: [libreoffice-users] Re: having 2525 defined colors to choose from within LO

2014-01-19 Thread Peter West
For example, apropos an earlier discussion on this list, see http://www.numbertext.org/logo/librelogo.pdf p52 Color names. In 25 basic colours three duplicates: aqua+cyan, fuchsia+magenta and gray+grey. Peter West Those who are well have no need of a physician, but those who are sick

Re: [libreoffice-users] mail format

2014-01-18 Thread Peter West
systems, and Linux--the latter probably only by me!) --doug So your requirement is, quite literally, read-only. What's wrong with PDF? Peter West Those who are well have no need of a physician, but those who are sick... -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org

Re: [libreoffice-users] mail format

2014-01-18 Thread Peter West
crossed) you don't have round-tripping issues, with files going back and forward between different systems, accumulating edits as they go. Peter West Those who are well have no need of a physician, but those who are sick... On 19 Jan 2014, at 11:25 am, doug dmcgarr...@optonline.net wrote

Re: [libreoffice-users] Re: Connection to SQL database

2014-01-17 Thread Peter West
Peter West So his fame spread throughout all Syria... On 18 Jan 2014, at 4:19 am, Carl Paulsen carlpaul...@comcast.net wrote: Basically, I'm at a huge disadvantage b/c I don't understand ANY of the terms or tools. I'm watching a ton of videos and reading a ton of material. But being

Re: [libreoffice-users] mail format

2014-01-17 Thread Peter West
Hi Doug, I think the best solution to your problem is to buy a copy of Microsoft Office. Peter West So his fame spread throughout all Syria... On 18 Jan 2014, at 7:49 am, Doug dmcgarr...@optonline.net wrote: On 01/17/2014 04:00 PM, Tom Davies wrote: Hi :) Yes there is but it's

Re: [libreoffice-users] mail format

2014-01-17 Thread Peter West
Doug, About that standard: http://msdn.microsoft.com/en-us/library/dd946767(v=office.12).aspx How much longer do you think that a lowest common denominator format (97) will be generally used? Anyway, for the time being it's working, and you have your solution. Peter West Those who are well

Fwd: [libreoffice-users] Connection to SQL database

2014-01-16 Thread Peter West
table or tables in MySql that reflect the changes, selecting data from the originals CREATE TABLESELECT.; 3) use UPDATE to perfom any necessary modifications to the original data 4) export the table(s) as csv files. There is plenty of help out there for MySql users. Peter West So

Re: [libreoffice-users] Calc cross-sheet issue with COUNTIF and AVERAGEIF...

2014-01-06 Thread Peter West
Peter West Where is he who has been born king of the Jews? On 6 Jan 2014, at 6:11 pm, James E Lang jim+...@lang.hm wrote: This has been a most enlightening discussion. I am a big fan of open source software. That said, this discussion has shined a bright light on one of the most

Re: [libreoffice-users] Re: Label creation Q

2013-12-18 Thread Peter West
Too cranky, Brian. Mr Sowden thought table referred to a database table. Peter West For my yoke is easy, and my burden is light. On 19 Dec 2013, at 1:00 pm, Brian Barker b.m.bar...@btinternet.com wrote: At 15:10 18/12/2013 -0800, John R. Sowden wrote: I do not know what ya'all mean

[libreoffice-users] Calc: sumif question

2013-12-15 Thread Peter West
this if I could access the row() value for individual elements, either in a sumif or by means of a filter, but I don't know whether this is possible, and in the test I tried, it did not work. Can anyone suggest a way to do this? Peter West For my yoke is easy, and my burden is light

Re: [libreoffice-users] email notifications

2013-12-03 Thread Peter West
, not the norm. Peter West We have only five loaves here, and two fish. On 4 Dec 2013, at 2:06 am, Dave Howorth dhowo...@mrc-lmb.cam.ac.uk wrote: anne-ology wrote: not true. That'll be why there's a support article about the problem then, and numerous threads in forums. https

Re: Cost of MS Office relative to LO, was: Fwd: [libreoffice-users] Re: moving to new version of MS Office

2013-11-30 Thread Peter West
in the future, former MS executives will reveal that theft was a vital element in MS' strategy for their Office products during the world colonisation phase. Peter West ...he saw a poor widow put in two copper coins. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http

Re: [libreoffice-users] Re: Cost of MS Office relative to LO, was: Fwd: Re: moving to new version of MS Office

2013-11-29 Thread Peter West
very small and far away when viewed through MS goggles. Peter West ...he saw a poor widow put in two copper coins. On 30 Nov 2013, at 1:25 pm, Urmas davian...@gmail.com wrote: Virgil Arrington: I'm no fan of MS, and I'm sure I don't fully understand all of its business practices, but I

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

2013-11-28 Thread Peter West
. They're hidden formulas and such that could be turned on and off for viewing at will. That would be very useful. Peter West ...he saw a poor widow put in two copper coins. On 29 Nov 2013, at 7:00 am, A [via Document Foundation Mail Archive] ml-node+s969070n4085467...@n3.nabble.com wrote

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

2013-11-28 Thread Peter West
of complementary style types; paragraph, character, list. And yes, your discussion does help. Peter West ...he saw a poor widow put in two copper coins. On 29 Nov 2013, at 4:44 am, Brian Barker b.m.bar...@btinternet.com wrote: I still don't understand why you consider any of this a difficulty. If you