Re: [libreoffice-users] How to.. sort a table in 3 columns

2015-10-16 Thread Brian Barker
link frames so that material will flow naturally between them. Select the first frame, click the Link Frames button in the Frame toolbar, and click in the second frame. Repeat for further frames. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.

Re: [libreoffice-users] Libre Writer - Line Spacing - not appearing as single space

2015-10-15 Thread Brian Barker
h style *will* overrule the style and change the spacing. So the techniques that you say failed you would have worked (even though not an ideal solution). I'm delighted that you are happy, of course - but it would be nice to know what was *really* happening. Brian Barker -- To unsubscribe

Re: [libreoffice-users] Libre Writer - Line Spacing - not appearing as single space

2015-10-14 Thread Brian Barker
text is in either a section or a table cell and that these have been protected by the author. But that doesn't fit your description, since in those cases the menu items you describe should either be greyed out or missing. I trust this helps. Brian Barker -- To unsubscribe e-mail t

Re: [libreoffice-users] Re: Installing Libreoffice in Ubuntu

2015-10-10 Thread Brian Barker
At 18:52 10/10/2015 -0400, Felmon Davis wrote: suggesting someone avoids commenting is not the same as silencing them. It's asking for their silence. but like you, I want to hear different perspectives. Good-oh! Brian Barker -- To unsubscribe e-mail to: users+unsubscr

Re: [libreoffice-users] Re: Installing Libreoffice in Ubuntu

2015-10-10 Thread Brian Barker
at the highest level. Oh, but despots and dictators don't. Brian Barker -- 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://wiki.documentfoundation.org/Netiquette

Re: [libreoffice-users] Percentage with bracket as negative

2015-10-07 Thread Brian Barker
ur first example. The VALUE() function converts this text to a number, interpreting the parentheses as indicating negative values. Dividing by 100 creates the real value required - to be properly displayed when formatted as Percent. I trust this helps. Brian Barker -- To unsubscr

Re: [libreoffice-users] Fwd: Undeliverable: introducing my self and a gift for appreciation to you:

2015-10-07 Thread Brian Barker
At 18:52 07/10/2015 +0200, James Wilde wrote: *From:* Postmaster <postmas...@binero.se> <mnasrinkhaks...@gmail.com> The email account that you tried to reach does not exist. How embarrassing! :*( What's embarrassing - that you simply got the address wrong?

Re: [libreoffice-users] introducing my self and a gift for appreciation to you:

2015-10-07 Thread Brian Barker
that someone called variously either Nasrin or Zahra is likely to be a she, not a he! ;^) Brian Barker -- 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] I Would Like to Learn a Macro Language LO 5.0

2015-10-05 Thread Brian Barker
and the sound effects! Brian Barker -- 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://wiki.documentfoundation.org/Netiquette List archive: http

Re: [libreoffice-users] finding fonts used in libreoffice writer docs

2015-10-04 Thread Brian Barker
Regular expressions". o Click Format... . o On the Font tab, select the relevant font. Leave Typeface and Size blank. o OK. o Click Find or Find All. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/ge

Re: [libreoffice-users] Calc cell formats

2015-10-02 Thread Brian Barker
understand, why it has to convert all those simple numbers to dates. It doesn't: it does this only because you ask it to. (And there's no "conversion", only different representation - which means that you can set everything right by correcting the cell format, without changing the u

Re: [libreoffice-users] blurred display

2015-10-02 Thread Brian Barker
... | LibreOffice | View | Graphics output | Use Anti-Aliasing (if these exist for your system). I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting

Re: [libreoffice-users] page subtotals

2015-09-25 Thread Brian Barker
a running total to appear (as "carried forward") at the bottom of each page and the same value to appear (as "brought forward") at the top of the next? Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-he

Re: [libreoffice-users] Fwd: Same bug in Fresh and Still

2015-09-23 Thread Brian Barker
find this problem goes away. I trust this helps. Brian Barker -- 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://wiki.documentfoundation.org/Netiquette List archive

Re: [libreoffice-users] copy cell format

2015-09-18 Thread Brian Barker
k Insert. o Select the appropriate sheet to insert and the required position in the target document. o OK. o Delete unwanted material as above. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/m

Re: solved: Re: [libreoffice-users] page numbering oddity

2015-09-15 Thread Brian Barker
:-) to use a double-page spread all through, ... Oh, indeed! Brian Barker -- 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://wiki.documentfoundation.org/Netiquette

Re: [libreoffice-users] page numbering oddity

2015-09-15 Thread Brian Barker
killer is that I can't find an obvious way to fix things up manually ... Can you tinker with the page styles or create your own to achieve what you need? What does each page style have for its Next Style? What do they have for "Page layout" under "Layout settings" on their Pag

Re: [libreoffice-users] LO 5 Documentation

2015-09-14 Thread Brian Barker
y freeware Adobe Reader) will allow addition of notes, comments, sticky notes, stamps, even audio, as well as formatting such as highlighting. Just what you need. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-he

Re: [libreoffice-users] LO 5 Documentation

2015-09-14 Thread Brian Barker
At 13:58 14/09/2015 -0400, Dave Boland wrote: ... would it be worth going to the bother of printing the 4.2 docs for Calc and Base? Why print them? Do you have access to a computer? If so, you can search the documentation and read it on your display! Brian Barker -- To unsubscribe e

Re: [libreoffice-users] Conditional Formatting On Date

2015-09-13 Thread Brian Barker
odify your original formulae to read: =+STYLE(IF(WEEKDAY(CURRENT();2)>5;"Green")) I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guid

Re: [libreoffice-users] Style a text value if a value is present, after a vlookup

2015-09-12 Thread Brian Barker
. If you want the style to depend on the result of (i.e. the value in the cell itself), you can use something like: =(STYLE(IF(CURRENT()=;;))) I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help

Re: [libreoffice-users] Mysterious line in document (see image)

2015-09-12 Thread Brian Barker
see the eight coloured handles. o Press Delete or Backspace. Removing a section preserves its contents. In the other two cases, if the entity contains text that you wish to keep, you will need to cut or copy that text and paste it outside the entity before deleting it. I trust this helps. Brian Bar

Re: [libreoffice-users] LibreOffice 5.0 does not open

2015-09-12 Thread Brian Barker
.com/en-gb/windows/help/learn-how-to-install-windows-xp-service-pack-3-sp3 . I trust this helps. Brian Barker -- 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] 12 instances of the same sheet

2015-09-03 Thread Brian Barker
whose contents controlled the function calls elsewhere. But there is another trick that will help. Use Shift+click or Ctrl+click on the sheet tabs to select multiple sheets. Changes that you make whilst multiple sheets are selected apply to all those sheets. I trust this helps. Brian Barker

Re: [libreoffice-users] Making two rows of a table into a Header

2015-09-01 Thread Brian Barker
into a single table. (Use Table | Merge Tables or right-click | Merge Tables.) Better still, create them that way in the first place. o Go to Table | Table Properties... | Text Flow | Text Flow. Tick "Repeat heading" and set "The first __ rows" to 2. I trust this helps. Brian Barker

Re: [libreoffice-users] Remove all paragraph and other formatting except for character attributes eg italics, bold etc

2015-08-29 Thread Brian Barker
this helps. Brian Barker -- 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://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global

Re: [libreoffice-users] Restoring default menus and tool bars

2015-08-26 Thread Brian Barker
? How do I get rid of the Save As icon as it is not needed, and confusing (steps 1, 2, 3, ...)? 1. Click the down-arrow at the right end of the Standard toolbar and choose Visible Buttons . 2. Click Save As... to toggle the button on or off. 3. Er, twiddle your thumbs? I trust this helps. Brian

Re: [libreoffice-users] Calc- how to edit a link to a file

2015-08-18 Thread Brian Barker
inappropriately - losing its leading file:/// - and confused LibreOffice. I trust this helps. Brian Barker -- 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] Re: WordPad

2015-08-13 Thread Brian Barker
a very nice program; ... You are (I believe) a list moderator. Would it not be more helpful to release genuine messages such as this to the list - to allow others to reply - rather than simply replying to them yourself? Brian Barker -- To unsubscribe e-mail to: users+unsubscr

Re: [libreoffice-users] Re: WordPad

2015-08-13 Thread Brian Barker
At 03:03 14/08/2015 +0100, Tom Davies wrote: On 14 August 2015 at 02:12, Brian Barker wrote: At 11:54 13/08/2015 -0500, Anne Noname wrote: From: Peter Pullman peterpull...@hotmail.com Date: Thu, 13 Aug 2015 07:07:53 -0700 (MST) I tried to put the contents of a WordPad document in a file

Re: [libreoffice-users] Writer prints table in reduced size

2015-08-12 Thread Brian Barker
... button on the General tab. Either setting could cause the effect you describe. I trust this helps. Brian Barker -- 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] Text Justification Formatting Not Maintained in Libreoffice Writer Master File?

2015-08-06 Thread Brian Barker
Guide, particularly the reference to templates. If you change the Default paragraph style in whatever template you used so that it has left rather than centre alignment, you may find matters easier to control. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr

Re: [libreoffice-users] Symbol in e-mail message

2015-08-04 Thread Brian Barker
- including interviews with the band itself. So you shouldn't dismiss it too easily. Brian Barker -- 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] Symbol in e-mail message

2015-08-04 Thread Brian Barker
the Christian cross, the swastika, the Union Jack and a two-headed Ouroboros Brian Barker -- 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] going to the previous and next page in writer.

2015-08-01 Thread Brian Barker
with keyboard shortcuts, of course, at Tools | Customise... | Keyboard. They are in the Navigate category. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting

Re: [libreoffice-users] Replace normal font with superscript of only a portion of a term

2015-07-29 Thread Brian Barker
for superscripting. I trust this helps. Brian Barker -- 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://wiki.documentfoundation.org/Netiquette List archive: http

Re: [libreoffice-users] Replace normal font with superscript of only a portion of a term

2015-07-29 Thread Brian Barker
At 19:39 29/07/2015 +0900, Thomas Blasejewicz wrote: On 2015/07/29 16:09, Brian Barker wrote: Search for TM and replace with TM (no quotes). Put the cursor in the Replace with field and click Format... . Under Position, select Superscript. You might not want to Replace All, or you will change

Re: [libreoffice-users] Calc. extract values

2015-07-28 Thread Brian Barker
name;D2:D2000) I trust this helps. Brian Barker -- 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://wiki.documentfoundation.org/Netiquette List archive: http

Re: [libreoffice-users] Returning to the previous position in a document after reopening [was: Question about LO Writer ...]

2015-07-26 Thread Brian Barker
to Restore last view settings when reopening documents. I suspect this applies only to those documents in the recently used list, but you can also configure how many documents that contains. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http

Re: [libreoffice-users] Calc Paste Special Defaults

2015-07-26 Thread Brian Barker
to retain your template row in its original position, hold down Ctrl+Alt instead as you release the mouse. I trust this helps. Brian Barker -- 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] Returning to the previous position in a document after reopening [was: Question about LO Writer ...]

2015-07-26 Thread Brian Barker
WordPerfect is still available. Brian Barker -- 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://wiki.documentfoundation.org/Netiquette List archive: http

Re: [libreoffice-users] Calc Paste Special Defaults

2015-07-25 Thread Brian Barker
, I suppose you might want to select something under Options, Operations, or Shift cells - but not that often, surely? Otherwise, why not use ordinary Paste (Edit | Paste, right-click | Paste, or Ctrl+V) instead? I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr

Re: [libreoffice-users] Question about LO Writer and complex documents

2015-07-24 Thread Brian Barker
surely cannot believe that it is at all difficult to create and edit text documents with mixed page orientations in LibreOffice? Brian Barker -- 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] writer: repeat a cell content (string) in a cell or in text

2015-07-22 Thread Brian Barker
! There is no particular need for this value to be in a table cell where it appears. I trust this helps. Brian Barker -- 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: repeat a cell content (string) in a cell or in text

2015-07-21 Thread Brian Barker
At 15:45 21/07/2015 +0100, Mike Scott wrote: On 21/07/15 14:41, Brian Barker wrote: Yes: create what you need in a spreadsheet and copy and paste the required cell range into your text document. It will appear as a table but will function like the spreadsheet section that it is. Or embed

Re: [libreoffice-users] writer: repeat a cell content (string) in a cell or in text

2015-07-21 Thread Brian Barker
that they treat only numbers... It seems so. any suggestion? Yes: create what you need in a spreadsheet and copy and paste the required cell range into your text document. It will appear as a table but will function like the spreadsheet section that it is. I trust this helps. Brian Barker

Re: [libreoffice-users] Can I Edit Spell-check Word List

2015-07-20 Thread Brian Barker
. Brian Barker -- 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://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users

Re: [libreoffice-users] Re: Empty Rulers in Draw

2015-07-19 Thread Brian Barker
At 20:36 19/07/2015 -0700, Al Nuwer wrote: On 7/19/2015 8:18 PM, Brian Barker [via Document Foundation Mail Archive] wrote: At 19:49 19/07/2015 -0700, Al Nuwer wrote: I started a new file in Draw where the rulers looked OK - had inch increments displayed. I later opened it to continue work

Re: [libreoffice-users] Empty Rulers in Draw

2015-07-19 Thread Brian Barker
or mile. I trust this helps. Brian Barker -- 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://wiki.documentfoundation.org/Netiquette List archive: http

Re: [libreoffice-users] VAR, STDEV, CHISQ.INV

2015-07-08 Thread Brian Barker
- which is probably the smallest floating-point value your system can represent without underflow. Have you compared the results produced from your data by equivalent normal formulae in a spreadsheet cell? Do you mean CHISQ.INV and not CHISQINV? Brian Barker -- To unsubscribe e-mail

Re: [libreoffice-users] Conditional formatting question

2015-07-03 Thread Brian Barker
, enter INDIRECT($CROW())=3 - or perhaps INDIRECT($CROW())0 . o For Cell Style, select your cell style with the appropriate background colour (or click New Style... and create a style on the fly). o OK. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr

Re: [libreoffice-users] Link Paste Special in Calc

2015-06-24 Thread Brian Barker
this is various ways, including perhaps setting the cell format to #. I trust this helps. Brian Barker -- 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] Preventing the display of #VALUE! in a spreadsheet

2015-06-21 Thread Brian Barker
an additional column or row containing the modified values. o Alternatively, you can test for the presence of a genuine number using the ISNUMBER() function. So =IF(AND(ISNUMBER(D10),ISNUMBER(K10),D10K10),D10-K10,) should do what you need. I trust this helps. Brian Barker -- To unsubscribe e

Re: [libreoffice-users] Preventing the display of #VALUE! in a spreadsheet

2015-06-21 Thread Brian Barker
,D10-K10,) That seems to do the job ... I fancy you mean =IF(COUNT(D10,K10)=2,D10-K10,) - with a comma, not a minus sign. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting

Re: [libreoffice-users] Date Field and Page Number Field not showing text and numbers in Footer

2015-06-21 Thread Brian Barker
about messed up, but you have simply toggled the display of field names. Go to View | Field Names (or press Ctrl+F9) to toggle it back again. I am looking forward to the help given me by the kind, knowledgeable fellow members. I trust I've been sufficiently kind and knowledgeable! Brian Barker

Re: [libreoffice-users] Drawing object styles

2015-06-21 Thread Brian Barker
is its boundary and because it has no end there is nowhere to which to attach the arrow! If you create an object that has a line which is not closed on itself - a line, an arc, and so on - and apply the style, you will see the arrow. I trust this helps. Brian Barker -- To unsubscribe e-mail

Re: [libreoffice-users] Inserting RTF on Template, bug?

2015-06-14 Thread Brian Barker
At 15:30 14/06/2015 -0300, Leonardo M. Ramé wrote: On 14/06/15 15:17, Brian Barker wrote: Your template contains a definition of paragraph style P1 including style:tab-stops / and later the reference to it: text:p text:style-name=P1 / . I'm guessing that this is why the first paragraph

Re: [libreoffice-users] Inserting RTF on Template, bug?

2015-06-14 Thread Brian Barker
.) o Construct a new (emptier?) template without the presumably unwanted paragraph style definition. Is this a bug? Don't know. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing

Re: [libreoffice-users] LOOKUP with 2 values in 2 columns

2015-06-08 Thread Brian Barker
that column if you prefer, so it does not need to display or print. To harvest the title, use: =VLOOKUP(E1F1;Mainlist.C1:H999;2;0) To harvest the composer: =VLOOKUP(E1F1;Mainlist.C1:H999;3;0) and so on . I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr

Re: [libreoffice-users] Copying text from one document to another with different formatting

2015-06-05 Thread Brian Barker
the material. Either: o Go to Edit | Paste Special... and select Unformatted text. Or: o Use Ctrl+Shift+V and select Unformatted text. Or: o Use Ctrl+Alt+Shift+V. The material will inherit the formatting of its surroundings in the target area. I trust this helps. Brian Barker -- To unsubscribe e-mail

Re: [libreoffice-users] Print Document Directly do not use the default printer? (Linux)

2015-06-03 Thread Brian Barker
with that character. At least under Windows, these sort before other alphabetic or numeric names and can be relied on to be readily accessible. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how

Re: [libreoffice-users] Print Document Directly do not use the default printer? (Linux)

2015-06-03 Thread Brian Barker
the motions of doing so), and save the empty document as a template. If you wished, you could even make this your default template. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how

Re: [libreoffice-users] Autorecovery not working

2015-05-31 Thread Brian Barker
it was in. I trust this helps. Brian Barker -- 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://wiki.documentfoundation.org/Netiquette List archive: http

Re: [libreoffice-users] autoformat question

2015-05-31 Thread Brian Barker
completely, remove the tick from Tools | AutoCorrect Options... | Options | Apply numbering - symbol: *. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting

Re: [libreoffice-users] Autorecovery not working

2015-05-31 Thread Brian Barker
and the temporary files? I doubt that makes any difference. I trust this helps. Brian Barker -- 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] open files automatically

2015-05-27 Thread Brian Barker
No, he doesn't want it at start-up, it seems, but instead when he starts LibreOffice. But something like this as a desktop shortcut or menu item (not in the start-up folder) is no doubt ideal. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http

Re: [libreoffice-users] LO Writer - rtf

2015-05-27 Thread Brian Barker
corrupted - in other words, with much of your formatting destroyed? Wouldn't it be more straightforward to remove whatever formatting is not required before saving (a copy of?) the document? If you want no formatting, save as Text. I trust this helps. Brian Barker -- To unsubscribe e-mail

Re: [libreoffice-users] open files automatically

2015-05-27 Thread Brian Barker
all the document files together (using Edit | Select All or Ctrl+A?), and (3) press Enter to open all the documents (whether or not LibreOffice is already running). I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http

Re: [libreoffice-users] Re: cannot select multiple words in impress

2015-05-25 Thread Brian Barker
will not want, of course. You could choose always to click and drag slightly, so that Undo would always serve your purpose. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how

Re: [libreoffice-users] rogue multi-line spacing

2015-05-22 Thread Brian Barker
the properties of the existing previous paragraph.) I trust this helps. Brian Barker -- 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://wiki.documentfoundation.org/Netiquette

Re: [libreoffice-users] Libre Writer - default font

2015-05-22 Thread Brian Barker
any document that you want to retain its formatting in a file format that permits this. How about .odt? I trust this helps. Brian Barker -- 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] cannot select multiple words in impress

2015-05-22 Thread Brian Barker
by word instead of character by character. The questioner points out that this useful technique works in Writer but not in Impress. Brian Barker -- 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] Can't change font color in LO 4.[4].3 (Linux)

2015-05-15 Thread Brian Barker
At 05:24 15/05/2015 +0100, Brian Barker wrote: At 11:19 15/05/2015 +0800, Min Hsien wrote: I found I can not change font color in LO 4.[4].3 under Linux. The procedure is: (1) Open Writer or Calc. (2) Type some words in Writer or Calc. (3) Select the words and change the color of words. (4

Re: [libreoffice-users] how to make formulas permanently case sensitive?

2015-05-15 Thread Brian Barker
At 07:58 15/05/2015 +0100, Mike Scott wrote: On 14/05/15 10:55, Brian Barker wrote: At 20:32 12/05/2015 +0200, Honly Wonly wrote: Am 12.05.2015 um 19:53 schrieb Brian Barker: At 12:45 12/05/2015 +0200, Honly Wonly wrote: I need, of course, formulas to be case sensitive. This can be set

Re: [libreoffice-users] Show full content of a cell when selected [Calc]

2015-05-15 Thread Brian Barker
, click the Target in Document button, expand Range names, select the name, and then click Apply, Close, Apply, and Close. If you now double-click the original cell, the oversize text will be displayed. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr

Re: [libreoffice-users] Writer Translation Tool

2015-05-15 Thread Brian Barker
/translator/. I trust this helps. Brian Barker -- 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://wiki.documentfoundation.org/Netiquette List archive: http

Re: [libreoffice-users] Can't change font color in LO 4.[4].3 (Linux)

2015-05-14 Thread Brian Barker
, but will nevertheless be marked as the chosen colour and will still print or export as PDF correctly. If you also have Use system colours for page previews ticked, Page Preview will also be affected; otherwise Page Preview will show the correct colour. I trust this helps. Brian Barker

Re: [libreoffice-users] how to make formulas permanently case sensitive?

2015-05-14 Thread Brian Barker
At 20:32 12/05/2015 +0200, Honly Wonly wrote: Am 12.05.2015 um 19:53 schrieb Brian Barker: At 12:45 12/05/2015 +0200, Honly Wonly wrote: I need, of course, formulas to be case sensitive. This can be set in the options for calc. The option is not saved permanently and every time I open

Re: [libreoffice-users] how to make formulas permanently case sensitive?

2015-05-12 Thread Brian Barker
is the reliable way to go. And it's quite easy: the EXACT() function comes to your aid. Instead of using =IF(A1=X;...) use =IF(EXACT(A1;X);...) This will match X but not x irrespective of the option setting. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr

Re: [libreoffice-users] Filter to display only lines containing character string?

2015-04-30 Thread Brian Barker
expressions ticked - where xyz is the required string. Find All will highlight all paragraphs containing xyz. I trust this helps. Brian Barker -- 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] Libre Calc - moving text in cell + comparison chart

2015-04-26 Thread Brian Barker
/Calc_and_Excel is written for OpenOffice and may or may not be helpful. It's part of OpenOffice's Migration Guide. I trust this helps. Brian Barker -- 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] time and date difference

2015-04-24 Thread Brian Barker
this helps. Brian Barker -- 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://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org

Re: [libreoffice-users] selecting cells in calc sheet

2015-04-24 Thread Brian Barker
. Let's imagine your data is in column A, starting in A1. In B3, insert: =AVERAGE(A1:A3)-30 and fill down the column. If you want to suppress the display in B cells for which there is not yet an A-cell vale, try something like: =IF(A3=0;;AVERAGE(A1:A3)-30) I trust this helps. Brian Barker

Re: [libreoffice-users] open files

2015-04-23 Thread Brian Barker
). Otherwise, you can set associations individually and manually. See http://windows.microsoft.com/en-GB/windows-8/choose-programs-windows-uses-default . I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org

Re: [libreoffice-users] [LibreOffice Writer] Table with alternat[]e row color

2015-04-20 Thread Brian Barker
answer! Brian Barker -- 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://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org

Re: [libreoffice-users] Table with alternat[]e row color

2015-04-20 Thread Brian Barker
earlier message was wrong. And I replied as I assumed that, unlike me, you had made this method work and I was genuinely interested to know how. I thought this list was one where everyone (expert or novice) shared for the benefit of all. Of course it is! Let's not change that. Brian Barker

Re: [libreoffice-users] [LibreOffice Writer] Table with alternat[]e row color

2015-04-19 Thread Brian Barker
. o It's probably much easier to set up formatting such as this before you insert your data. If necessary, you should be able to copy any existing material and paste it into a new, formatted table. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr

Re: [libreoffice-users] Function names with primes

2015-04-19 Thread Brian Barker
) is shorthand for df(x)/dx. Some Americans (or others) able to explain this to a non American? Sorry: I'm only an other. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how

Re: [libreoffice-users] Table with alternat[]e row color

2015-04-19 Thread Brian Barker
At 20:21 19/04/2015 -0700, James E Lang wrote: From: Brian Barker: The automatic way to colour spreadsheet rows alternately is to use Conditional Formatting and create a formula using the ROW() function to determine the oddness or evenness of the row number and control the background

Re: [libreoffice-users] CALC

2015-04-19 Thread Brian Barker
not to see the indication, I'd suggest royal blue correcting fluid ... I trust this helps. Brian Barker -- 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] Font versus Character Substitution

2015-04-17 Thread Brian Barker
. Brian Barker -- 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://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global

Re: [libreoffice-users] Drawing arrows in Writer.

2015-04-16 Thread Brian Barker
create whatever you need in a Draw or Impress document and easily copy-and-paste it into a text document. The resulting arrow can still be manipulated in the text document. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http

Re: [libreoffice-users] styles and formatting

2015-04-15 Thread Brian Barker
on the Styles and Formatting button in the sidebar (at the right of the window) or on the menu button at the top of the sidebar menu and select Styles and Formatting. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http

Re: [libreoffice-users] Re: database2spreadsheet

2015-04-07 Thread Brian Barker
At 16:06 07/04/2015 +0200, Honly Wonly wrote: Am 23.03.2015 um 18:28 schrieb Brian Barker: At 17:01 23/03/2015 +0100, Honly Wonly wrote: Am 16.03.2015 um 18:07 schrieb Andreas Säger: Am 16.03.2015 um 15:57 schrieb Honly Wonly: Creating LO documents directly would be nice and might have

Re: [libreoffice-users] Fwd: [tdf-discuss] Printing problem in LibreOffice Development Build

2015-04-07 Thread Brian Barker
At 20:10 07/04/2015 +0200, James Wilde wrote: ... (s)he is not registered Looks decidedly a she to me: http://stackoverflow.com/users/4264377/glefani-misoles . Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get

Re: [libreoffice-users] transfer user profile to new computer

2015-04-06 Thread Brian Barker
trust this helps. Brian Barker -- 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://wiki.documentfoundation.org/Netiquette List archive: http

Re: [libreoffice-users] FEATURE REQUEST -- for the Sort options in Calc

2015-03-28 Thread Brian Barker
to be sorted. Brian Barker -- 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://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org

Re: [libreoffice-users] LibreOffice Sort Bug ?

2015-03-27 Thread Brian Barker
%. Brian Barker -- 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://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global

Re: [libreoffice-users] Calc, selecting from a list ? vlookup maybe ?

2015-03-24 Thread Brian Barker
simplify what you need to do as the original list is edited: you would need just to repeat the sort, without the subsequent copying. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing

Re: [libreoffice-users] Re: database2spreadsheet

2015-03-23 Thread Brian Barker
, select Unformatted text in the Paste Special dialogue. I trust this helps. Brian Barker -- 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://wiki.documentfoundation.org

<    1   2   3   4   5   6   7   8   9   10   >