Re: [libreoffice-users] calc: method to subdivide individual cells

2013-02-13 Thread Brian Barker
to your problem ones in order to start this process. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http

Re: [libreoffice-users] Feature Request

2013-02-12 Thread Brian Barker
but allow you to pin items already on the recent files menu so that they do not drop off. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http

Re: [libreoffice-users] Page count does not match visible pages

2013-02-10 Thread Brian Barker
the Options... button in the Print dialogue. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org

Re: [libreoffice-users] [Writer] Current page value?

2013-02-10 Thread Brian Barker
. (And I-speak-your-links software for blind users says not map but here, here, here ...!) It sounds as if your book is attempting to teach people to turn the page for a continuation of the text. But I hope not. In any case, is this the reason why this may be an unusual request? Brian Barker

Re: [libreoffice-users] Page count does not match visible pages

2013-02-10 Thread Brian Barker
At 08:39 11/02/2013 +0800, Conly Honly Donly wrote: 2013/02/10 10:42 PM, Brian Barker: At 21:36 10/02/2013 +0800, Conly Honly Donly wrote: I think I have found a bug. I'm not so sure. This potential bug may affect printing, e.g. producing blank pages because the page count does not look

Re: [libreoffice-users] Custom Bitmap for Chart Wall?

2013-02-09 Thread Brian Barker
, but you may have to close and reopen your spreadsheet document before it appears. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines

Re: [libreoffice-users] IF w/ Regular Expression

2013-02-08 Thread Brian Barker
* and FALSE or 0 otherwise. There are a number of functions which allow regular expressions (see the help text), but = is not one of them. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help

Re: [libreoffice-users] Comments and images in shared spreadsheets.

2013-02-06 Thread Brian Barker
At 17:12 06/02/2013 -0500, Jay Lozier wrote: Maybe psst a feature request in Bugzilla? No need to be secretive about it: go ahead and post it! Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing

Re: [libreoffice-users] Moving pop up help box position when using menus

2013-02-03 Thread Brian Barker
or neither. It sounds as if you have Extended tips; you might be happier with just Tips. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting

Re: [libreoffice-users] Calc SUM Error 502 - How to add results of three IF formulae?

2013-02-02 Thread Brian Barker
versions of Calc? Your original formula produces Error 508, which quite correctly observes that the brackets are mismatched. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing

Re: [libreoffice-users] VLOOKUP Problem

2013-02-02 Thread Brian Barker
values instead. The sort would otherwise have no effect on the formulae in column C. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines

Re: [libreoffice-users] VLOOKUP Problem

2013-02-02 Thread Brian Barker
that is necessary is that you have an exactly complete set of the formulae in the range of column D - in whatever order. Is that any better? Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how

Re: [libreoffice-users] VLOOKUP Problem

2013-02-02 Thread Brian Barker
A in the correct places for the scheme to work, he would have done all the work already. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http

Re: [libreoffice-users] Re: Numbering Questions

2013-02-01 Thread Brian Barker
the dummy equation. The Math window opens at the foot of the window and you can edit the equation's definition - removing it entirely and replacing it with your own. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http

Re: [libreoffice-users] Numbering Questions: (2) or (1)?

2013-01-31 Thread Brian Barker
this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@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

Re: [libreoffice-users] Macro to Convert Date in Text Format to Date in Date Format (Spreadsheet)

2013-01-31 Thread Brian Barker
this will handle your DD.MM. may depend on your locale setting. Otherwise, something such as =DATE(RIGHT(Xn;4);MID(Xn;4;2);LEFT(Xn;2)) ought to work. Alternatively, does this point you in the right direction to create a macro? I trust this helps. Brian Barker -- For unsubscribe instructions e

Re: [libreoffice-users] Re: Numbering Equations

2013-01-30 Thread Brian Barker
difficulty with that. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@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

Re: [libreoffice-users] Re: Numbering Equations

2013-01-30 Thread Brian Barker
: it opens the AutoText dialogue, which enable you to do much more. You can even invoke AutoText entries that way, but it is a long-winded way of doing so! The error behind F3 should be taken care of. There is no error that most of us can see. Brian Barker -- For unsubscribe instructions

Re: [libreoffice-users] Re: Numbering Equations

2013-01-30 Thread Brian Barker
, press Enter. o Does the dummy numbered equation now appear? Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org

Re: [libreoffice-users] Re: Numbering Equations

2013-01-30 Thread Brian Barker
At 16:10 30/01/2013 -0500, Taang Zomi wrote: I did all you said above, and I got all the results. Good-oh! The second suggestion is an effective workaround for you, then: typing F, o, r, Enter is hardly any longer than f, n, F3 would have been. Brian Barker -- For unsubscribe

Re: [libreoffice-users] Re: Numbering Equations

2013-01-29 Thread Brian Barker
At 11:51 29/01/2013 -0500, Taang Zomi wrote: On Mon, Jan 28, 2013 at 12:30 AM, Brian Barker wrote: At 18:04 27/01/2013 -0500, Taang Zomi wrote: In LibreOffice 3.3 Math Guide (0700MG33-MathGuide3.3.odt), on p. 14, the following is written: *Numbering equations* Equation numbering is one

Re: [libreoffice-users] Re: Numbering Equations

2013-01-29 Thread Brian Barker
At 15:38 29/01/2013 -0500, Taang Zomi wrote: I just started a new Writer document, typed fn and then pressed F3, and got the same message: I don't understand. Did you type a space (or anything else) after the fn? You mustn't do that! Brian Barker -- For unsubscribe instructions e-mail

Re: [libreoffice-users] Re: Numbering Equations

2013-01-29 Thread Brian Barker
to be failing to pick up the shortcut fn in the first place. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org

Re: [libreoffice-users] Re: Numbering Equations

2013-01-29 Thread Brian Barker
the f key and briefly press the n key instead. o Now you will see the required result fn in your document. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe

Re: [libreoffice-users] Re: Numbering Equations

2013-01-29 Thread Brian Barker
the instructions as meaning that you should hold down the Fn key and then press F3, the error message you quote is exactly what you would see. On this type of keyboard, you need to type f, type n, and then hold down the Fn key whilst pressing F3. Brian Barker -- For unsubscribe instructions e-mail

Re: [libreoffice-users] Left Justification in Stacked Scalable Braces

2013-01-27 Thread Brian Barker
. For alignc (align centre) read alignl (align left). Attachment: Left Justification in Stacked Scalable Braces.odt (16K) Attachments are removed by the list processor before your message is distributed, so no-one will have seen this. I trust this helps. Brian Barker -- For unsubscribe

Re: [libreoffice-users] Drop Caps Character Style in Writer

2013-01-27 Thread Brian Barker
the character properties that you want in the Drop Caps character style. You could alternatively create your own character style(s), of course. But that's true of all the predefined styles. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h

Re: [libreoffice-users] Numbering Equations

2013-01-27 Thread Brian Barker
at the bottom of the window, where you can remove the dummy equation's definition and replace it with your own. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe

Re: [libreoffice-users] First occurrence of a negative number in a column

2013-01-22 Thread Brian Barker
. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@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

Re: [libreoffice-users] Selection List editing

2013-01-16 Thread Brian Barker
provide facilities for restricting possible entries as well as setting an error message.) Now you will see your desired entries if you either use right-click | Selection List... or click the down arrow next to the current cell. I trust this helps. Brian Barker -- For unsubscribe

Re: [libreoffice-users] Recent Documents list

2013-01-14 Thread Brian Barker
, and so on. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@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

Re: [libreoffice-users] Footer: How to align chapter title to the left and page number to the right

2013-01-08 Thread Brian Barker
a Right tab stop at the right text margin. This is useful anywhere - not just in headers and footers. Indeed, this is how your table of contents works. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http

Re: [libreoffice-users] Changing time format in Calc header

2013-01-08 Thread Brian Barker
on each occasion. To do this, go to Tools | Cell Contents | Recalculate (or just press F9). I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting

Re: [libreoffice-users] [Writer] Regular expressions

2013-01-08 Thread Brian Barker
to reset your paragraph style appropriately (to Default?). I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http

Re: [libreoffice-users] Re: [Writer] Regular expressions

2013-01-08 Thread Brian Barker
be correct to question your claim until you have posted a proof of your belief - in other words a proof of your original claim. ;^) Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how

Re: [libreoffice-users] Sorry about my double Post

2013-01-04 Thread Brian Barker
of the lists. And that's just as clearly not what the questioner did. (Nomail is mentioned at the web site only in a footnote.) The questioner's problem was - as described - the well-known behaviour of his Gmail account ... Brian Barker -- For unsubscribe instructions e-mail to: users+h

Re: [libreoffice-users] Table of contents and page numbers

2013-01-03 Thread Brian Barker
the table. Go to Tools | Update , and then choose from Current Index (if your cursor is in the table of contents), All Indexes and Tables, or Update All. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http

Re: [libreoffice-users] Styles and regular expression in libreoffice

2012-12-22 Thread Brian Barker
the footnotes will be concatenated into a single piece of text and will lose all connection to the original footnote markers - but this is in the nature of what you will be trying to achieve using Paste Special... in any case, of course. I trust this helps. Brian Barker -- For unsubscribe

Re: [libreoffice-users] Styles and regular expression in libreoffice

2012-12-22 Thread Brian Barker
to anything). Brian Barker -- For unsubscribe instructions e-mail to: users+h...@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

Re: [libreoffice-users] caption numbering positioning

2012-12-21 Thread Brian Barker
the selection in the drop-down list for Caption order.. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http

Re: [libreoffice-users] Styles and regular expression in libreoffice

2012-12-21 Thread Brian Barker
readers' benefit) that this is an unnecessarily complicated technique. Use of Edit | Paste Special... | Unformatted text (or Ctrl+Shift+V | Unformatted text) in LibreOffice is all that is required. No need for Notepad or any other separate software. Brian Barker -- For unsubscribe

Re: [libreoffice-users] Styles and regular expression in libreoffice

2012-12-21 Thread Brian Barker
At 12:24 21/12/2012 -0600, Anne Noname wrote: On Fri, Dec 21, 2012 at 10:11 AM, Brian Barker wrote: Use of Edit | Paste Special... | Unformatted text (or Ctrl+Shift+V | Unformatted text) in LibreOffice is all that is required. No need for Notepad or any other separate software

Re: [libreoffice-users] Styles and regular expression in libreoffice

2012-12-21 Thread Brian Barker
;-) That's not true. But in any case, you are presumably suggesting that a fresh document would anyway be necessary with your round-the-houses route via other software. Again, you are very welcome to go the long way around if you prefer. You will not be the only person to do so. Brian Barker

Re: [libreoffice-users] Calc: Text Columns Not Quoted When Saving .csv

2012-12-21 Thread Brian Barker
cope only with CSV files? Not spreadsheet document files? I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http

Re: [libreoffice-users] [Calc] Data sorting

2012-12-20 Thread Brian Barker
by those cells after sorting by street name) or else keep the cells as they are but extract the number part into a separate cell (which you can hide if you prefer) and then sort by those cells. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h

Re: [libreoffice-users] typographic freaks: footnotes not vertically aligned to last line of body text in following page (as in good typographic style)

2012-12-19 Thread Brian Barker
to become layout software as well as word processing software. I have no idea whether its developers would wish to do this. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how

Re: [libreoffice-users] typographic freaks: footnotes not vertically aligned to last line of body text in following page (as in good typographic style)

2012-12-19 Thread Brian Barker
At 06:06 20/12/2012 +, Tom Davies wrote: At 04:18 20/12/2012 +, Brian Barker wrote: At 00:14 20/12/2012 +0800, Nobody Noname wrote: ... there is a thing that, if we cannot strictly to define as a BUG, is, at least, a defect regarding the right typography. I mean the behavior

Re: [libreoffice-users] copying formats in Calc

2012-12-16 Thread Brian Barker
this, it should be a simple matter to apply conditional formatting - probably depending on the original source cells, not the target cells - to your harvested values in the target cells. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h

Re: [libreoffice-users] Value '0000-00-00' can not be represented as java.sql.Date

2012-12-16 Thread Brian Barker
solution be to construct your database so that you didn't need to represent this thrice-inappropriate date value? Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting

Re: [libreoffice-users] Curly apostrophe

2012-12-13 Thread Brian Barker
is feet; two is inches. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@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

Re: [libreoffice-users] Formulas in Calc not showing results

2012-12-12 Thread Brian Barker
the resulting csv file with LO (or anything else I have on hand). A CSV file is plain text, so you can certainly open it as a spreadsheet with LibreOffice Calc or as text with LibreOffice Writer. Remember that when you save as CSV, only the active sheet is saved. I trust this helps. Brian Barker

Re: [libreoffice-users] Formulas in Calc not showing results

2012-12-12 Thread Brian Barker
of this is formatting the cell as Text before you enter the formula. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http

Re: [libreoffice-users] Formulas in Calc not showing results

2012-12-12 Thread Brian Barker
At 16:35 12/12/2012 -0500, Carl Paulsen wrote: Restart the software or reboot the computer sometimes helps these odd glitches. You mean that you didn't try this before asking your question?! Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems

Re: [libreoffice-users] Losing own messages [was Re: Pdf import]

2012-12-05 Thread Brian Barker
At 09:00 05/12/2012 +, Tom Davies wrote: At 03:03 05/12/2012 +, Brian Barker wrote: At 15:19 04/12/2012 -0500, Felmon Davis wrote: I notice one cannot see one's own posts; is it possible to switch this on? Your problem is not with the LibreOffice list, but with your mail provider

Re: [libreoffice-users] Chart Range Entire Column

2012-12-05 Thread Brian Barker
data row, including your new data. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org

Re: [libreoffice-users] Losing own messages [was Re: Pdf import]

2012-12-04 Thread Brian Barker
delivering the message. If you'd like to view your message, you can find it in Sent Mail or All Mail. It can be argued that this practice is unhelpful. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org

Re: [libreoffice-users] Calc formula for US Thanksgiving date

2012-12-03 Thread Brian Barker
;11;3)) or for the date value: =DATE(Xn;11;29)-WEEKDAY(DATE(Xn;11;3)) In each case, Xn is the cell with the relevant year. In the second case, the result cell will have to be appropriately formatted in order to display as you will wish. I trust this helps. Brian Barker -- For unsubscribe

Re: [libreoffice-users] messages returned

2012-11-24 Thread Brian Barker
in a little over 120 words. That's quite a high concentration. I hesitate to point this out, but that word is a feature of certain types of spam. (My first attempt to send this, without the editing, has - not surprisingly - also not reached the list.) Brian Barker -- For unsubscribe

Re: [libreoffice-users] [Ten questions]

2012-11-23 Thread Brian Barker
At 02:53 23/11/2012 -0500, Felmon Davis wrote: On Fri, 23 Nov 2012, Brian Barker wrote: At 08:23 22/11/2012 -0500, Virgil Aonly wrote: The fact that the original questioner on this thread had to ask how to disable so many autocorrect features, I think, proves my point. No - it just shows

Re: [libreoffice-users] [More questions - but some the same as before]

2012-11-23 Thread Brian Barker
of topics that you can easily look up. You should get used to using the embedded Help facility and obtain and peruse the Writer Guide. (Oh look: I said that on 21 November, too!) You may also want to look for local courses on the subject. I trust this helps. Brian Barker -- For unsubscribe

Re: [libreoffice-users] [More questions - but some the same as before]

2012-11-23 Thread Brian Barker
At 12:51 24/11/2012 +0900, Dr. R. O Stapf wrote: On 2012-11-24 12:24, Brian Barker wrote: I have no idea how many users are subscribed this list but let's just say arguendo there are 10. If each of us 10 users contributed just 5 tasks they performed regularly in LW (and how those tasks

Re: [libreoffice-users] [Ten questions]

2012-11-22 Thread Brian Barker
by reflowing the text to fit. I type a new value into a spreadsheet cell, the program *changes* all the cells with formulae depending on it - without my going near them! If you don't want a program to make any automatic changes, you probably want a typewriter. ;^) Brian Barker -- For unsubscribe

Re: [libreoffice-users] Ending a document

2012-11-21 Thread Brian Barker
to imagine a document without that empty paragraph without offending against your requirement for matching indicators. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe

Re: [libreoffice-users] [Ten questions]

2012-11-21 Thread Brian Barker
be evidence of didactic success! Brian Barker -- For unsubscribe instructions e-mail to: users+h...@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

Re: [libreoffice-users] Calc: copying values from a cell containing an array formula

2012-11-21 Thread Brian Barker
of the array of results. (Hide it if you wish.) o Copy from that range of cells instead of from the array formula. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how

Re: [libreoffice-users] [Ten questions]

2012-11-20 Thread Brian Barker
the embedded help system. Or both. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List

[libreoffice-users] Re: Commands available for users@global.libreoffice.org

2012-11-19 Thread Brian Barker
At 12:38 19/11/2012 +0200, Nobody Noname wrote: This automatic text should include the address to post messages. Er, could that be it - there in the subject line of the message? ;^) Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http

Re: [libreoffice-users] how to make a superscript +?

2012-11-16 Thread Brian Barker
to have to quote the plus sign: a^{+} . I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org

Re: [libreoffice-users] Problem with End-notes

2012-11-15 Thread Brian Barker
and Formatting button in the Formatting toolbar, or press F11). Click the Character Styles button. Right-click Endnote anchor and select Modify... | Position. Under Position, select Normal. (Also make any other desired changes.) I trust this helps. Brian Barker -- For unsubscribe

Re: [libreoffice-users] Anchoring images and inserting pages.

2012-11-14 Thread Brian Barker
can drag the anchor to an alternative paragraph or character (as the case may be). I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines

Re: [libreoffice-users] Auto changes on a new spreadsheet set for next year

2012-11-12 Thread Brian Barker
At 14:42 12/11/2012 +, Paul Stear wrote: On Thursday 08 Nov 2012 14:19:22 Brian Barker wrote: At 11:45 08/11/2012 +, Paul Stear wrote: I have the same spreadsheet set I use each year. The new spreadsheet for 2013 will need to reference fields in the 2012 spreadsheet. For the past

Re: [libreoffice-users] extension or program for book printing?

2012-11-12 Thread Brian Barker
: o Create text frames at each location. o Select the first frame - so you see the eight coloured handles. o Click the Link Frames button in the Frame toolbar. o Click in the second frame. o Repeat for further linked frames. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail

Re: [libreoffice-users] Auto changes on a new spreadsheet set for next year

2012-11-08 Thread Brian Barker
in the INDIRECT() function, which provides the necessary conversion. So the formula which works is =INDIRECT('file:///home/fred/Generation Readings-A1-1.ods'#$Jan.A68) I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http

Re: [libreoffice-users] LO to .doc with background image?

2012-11-07 Thread Brian Barker
- where the original image file does not exist separately at the same absolute file path. Try unticking that box. (But I'm not sure that will make any difference.) I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http

Re: [libreoffice-users] Searchable PDFs from Graphite fonts

2012-10-30 Thread Brian Barker
At 11:05 30/10/2012 +1100, Jonathan Schultz wrote: The text in the ODT reads This is the official version. while the text in the PDF reads This his the offichial vershion. Can anyone suggest why this is happening ... Perhaps your PDF reader has had one tipple too many? ;^) Brian Barker

Re: [libreoffice-users] Fonts

2012-10-28 Thread Brian Barker
the font of all sheets in your template separately. 2. Any new sheets you create in a spreadsheet created from the new template will still have the original default font, not your new modified font. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org

Re: [libreoffice-users] Fonts

2012-10-28 Thread Brian Barker
At 06:19 29/10/2012 +0100, Jean-Baptiste Faure wrote: No, if you use styles. Funny how you didn't mention them! Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting

Re: [libreoffice-users] Circular references

2012-10-26 Thread Brian Barker
. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@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

Re: [libreoffice-users] Libre Writer - Opening plain text documents to desired font

2012-10-21 Thread Brian Barker
! Brian Barker -- For unsubscribe instructions e-mail to: users+h...@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

Re: [libreoffice-users] Inserting a code for today's date

2012-10-19 Thread Brian Barker
is that at Insert | Fields you will see a Date entry - but this is actually the Date (fixed) variety, not the (variable) Date that you need. So ignore that and proceed to Other... . I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http

Re: [libreoffice-users] Libre Writer - Opening plain text documents to desired font

2012-10-19 Thread Brian Barker
text file the new text (Writer) document would be created from your new modified default template, but - perhaps perversely - it appears to be opened using the original default default template, ignoring your desired change. I trust this helps (though I doubt it does). Brian Barker

Re: [libreoffice-users] Libre Writer - Opening plain text documents to desired font

2012-10-19 Thread Brian Barker
such .odt documents does not impose Preformatted Text paragraph style on anything, of course. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http

Re: [libreoffice-users] LibreOffice Writer Find Replace format broken

2012-10-18 Thread Brian Barker
or Size.) Is that what you are doing? The format attribute of the Replace with text appears to be remembered; did you perhaps for some reason click No Format and cancel your italics the day before yesterday? I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h

Re: [libreoffice-users] Integer part of a number

2012-10-15 Thread Brian Barker
is positive, that's no different from =INT(C3) Brian Barker -- For unsubscribe instructions e-mail to: users+h...@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

Re: [libreoffice-users] Integer part of a number

2012-10-15 Thread Brian Barker
At 12:38 15/10/2012 +0100, Tom Davies wrote: ... but Pertti's answer deals with unexpectedly wrong counts. It does nothing of the sort, of course. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing

Re: [libreoffice-users] Re: Integer part of a number

2012-10-15 Thread Brian Barker
not match the definition above - and indeed for non-negative C3 is identically zero! Try =0 instead. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines

Re: [libreoffice-users] Re: Integer part of a number

2012-10-15 Thread Brian Barker
At 16:08 15/10/2012 +0200, Andreas Säger wrote: Am 15.10.2012 10:45, Brian Barker wrote: At 10:49 15/10/2012 +0300, Pertti Rönnberg wrote: On 14.10.2012 12:20, Gilles SICHE wrote: could anyone tell me which formula I should use for the integer part of a cell to be shown in another cell

Re: [libreoffice-users] Re: Integer part of a number

2012-10-15 Thread Brian Barker
At 10:34 15/10/2012 -0400, James Knott wrote: Andreas Säger wrote: Am 15.10.2012 10:45, Brian Barker wrote: At 10:49 15/10/2012 +0300, Pertti Rönnberg wrote: On 14.10.2012 12:20, Gilles SICHE wrote: could anyone tell me which formula I should use for the integer part of a cell to be shown

Re: [libreoffice-users] Re: Integer part of a number

2012-10-15 Thread Brian Barker
At 16:36 15/10/2012 +0200, Andreas Säger wrote: Am 15.10.2012 16:20, Brian Barker wrote: At 14:42 15/10/2012 +0200, Andreas Säger wrote: Am 15.10.2012 09:49, Pertti Rönnberg wrote: if value in cell c3 is /_less than_/ '1' then d3 shall be '0', else (-- if c3 is '1' or bigger then -- ) use

Re: [libreoffice-users] List of Fonts in Use in a Document

2012-10-15 Thread Brian Barker
document. Open this in your favourite PDF reader, which should be able to tell you which fonts have been embedded. Does that give you a reliable list? I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org

Re: [libreoffice-users] Re: Integer part of a number

2012-10-15 Thread Brian Barker
At 11:56 15/10/2012 -0400, James Knott wrote: Brian Barker wrote: Now you are assuming (1) that negative election results are possible, I was just posting in reference to comment about negative numbers and not the original post. That makes your suggestion (of applying ABS() to the values

Re: Fwd: Re: [libreoffice-users] Integer part of a number

2012-10-15 Thread Brian Barker
in the very first reply (before any of my comments). Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette

Re: [libreoffice-users] Extract Text From PPT

2012-10-11 Thread Brian Barker
| Export as PDF... to create a PDF copy. o Open the PDF copy in your favourite PDF reader and save as text from there. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how

Re: [libreoffice-users] Calc question - paste special

2012-10-09 Thread Brian Barker
on the value in cell A1. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@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

Re: [libreoffice-users] Re: using \t in regular expression replace

2012-10-08 Thread Brian Barker
with field is then not interpreted properly. Hence the need for the workaround. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http

Re: [libreoffice-users] regexp function

2012-10-08 Thread Brian Barker
be an easier way ... I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@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

Re: [libreoffice-users] using \t in regular expression replace

2012-10-07 Thread Brian Barker
At 11:08 07/10/2012 +0200, Johnny Rosenberg wrote: 2012/10/7 Brian Barker: At 20:24 06/10/2012 -0400, Dan Lewis wrote: On 10/06/2012 05:09 PM, Cor Nouws wrote: I was trying to use \t to replace e.g a paragraph ending with a tab. So find $ replace with \t That does not work. At first I did

Re: [libreoffice-users] using \t in regular expression replace

2012-10-06 Thread Brian Barker
break itself, which - in the view of LibreOffice's regular expressions - does not exist as a separate entity. There is no simple way to match and replace paragraph breaks, I think. (You can match and replace Shift+Enter line breaks - using \n.) I trust this helps. Brian Barker

Re: [libreoffice-users] name of pdf export

2012-10-05 Thread Brian Barker
be the same as the file name) there. I often copy the file name from the General tab to the Description tab and edit off the extension. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help

Re: [libreoffice-users] Help with Scoring Bi-nominal Responses

2012-09-18 Thread Brian Barker
*. Such a column could be hidden if you prefer. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org

<    7   8   9   10   11   12   13   14   >