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

2012-12-12 Thread Brian Barker
her possible cause 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/ Po

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

2012-12-12 Thread Brian Barker
la results if they are being created, I can't even open 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 C

Re: [libreoffice-users] Chart Range Entire Column

2012-12-05 Thread Brian Barker
extends from your first data row to your last, dummy 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 guidelin

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 pro

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

2012-12-04 Thread Brian Barker
error 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.libre

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

2012-12-03 Thread Brian Barker
AY(DATE(Xn;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 --

Re: [libreoffice-users] messages returned

2012-11-24 Thread Brian Barker
lural) three times 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

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] [More questions - but some the same as before]

2012-11-23 Thread Brian Barker
tware). As you will have seen, few people are willing to set about one-to-one teaching 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

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] [Ten questions]

2012-11-22 Thread Brian Barker
am now *changes* what I had 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. ;^)

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

2012-11-21 Thread Brian Barker
py 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/h

Re: [libreoffice-users] [Ten questions]

2012-11-21 Thread Brian Barker
The frustration may 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/Neti

Re: [libreoffice-users] Ending a document

2012-11-21 Thread Brian Barker
hat is. It would be possible 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-list

Re: [libreoffice-users] [Ten questions]

2012-11-20 Thread Brian Barker
k) Where do I find the answers to these questions? Download the Writer Guide or study 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-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
ar 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.documen

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

2012-11-15 Thread Brian Barker
s and Formatting (or click the Styles 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

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] How to move a sum of all worksheet in one summary to a new spreadsheet

2012-11-11 Thread Brian Barker
ordinary Paste. In the Paste Special dialogue, untick "Paste all" if necessary, and then ensure that Numbers is ticked but Formulas is *not* ticked. I hope this is clear ... Yup. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.

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

2012-11-08 Thread Brian Barker
a cell reference to the other spreadsheet file. But the trick you need is available 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"

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

2012-11-07 Thread Brian Barker
stem - e.g. your client's - 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...@gl

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

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

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

2012-10-26 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.

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

2012-10-21 Thread Brian Barker
at template. This is unexpected (by me, at least) but true! 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://wi

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

2012-10-19 Thread Brian Barker
ited them.) Opening 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 gui

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

2012-10-19 Thread Brian Barker
hat when you open your plain 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

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

2012-10-19 Thread Brian Barker
n 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...@globa

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

2012-10-18 Thread Brian Barker
(You don't need to select a Font 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

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

2012-10-15 Thread Brian Barker
So, what is the best way for Gilles to continue? Using INT(), as was suggested 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-hel

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: [libreoffice-users] List of Fonts in Use in a Document

2012-10-15 Thread Brian Barker
on of your 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.libre

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 &#x

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 in

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
s is getting sillier! This formula does 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-list

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

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

Re: [libreoffice-users] Extract Text From PPT

2012-10-11 Thread Brian Barker
s. o Go to File | 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/maili

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

2012-10-09 Thread Brian Barker
uot;" and does not depend 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.

Re: [libreoffice-users] regexp function

2012-10-08 Thread Brian Barker
e | Enable regular expressions in formulas. But there must 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 + m

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

2012-10-08 Thread Brian Barker
place 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 guidelin

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
not match the paragraph 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

Re: [libreoffice-users] name of pdf export

2012-10-05 Thread Brian Barker
(which can 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.or

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

2012-09-18 Thread Brian Barker
ed to add in the formula in T*. 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/ P

Re: [libreoffice-users] Entering numbers as text in Calc (single quote)

2012-09-15 Thread Brian Barker
nded to suppress the interpretation as a number and is retained literally as part of the text. I do have the problem with finding "Custom Quotes" as an option. There a "Localize Options" that show options for quotes though. Apologies! You are quite right: I was talking rubbis

Re: [libreoffice-users] Entering numbers as text in Calc (single quote)

2012-09-15 Thread Brian Barker
as two separate actions, so you can achieve what you need by undoing the second action and leaving just the first. Immediately after you type the quote mark (and see the correction), go to Edit | Undo - or, more easily, press Ctrl+Z - and you will see the quote mark changed back to a straight

Re: [libreoffice-users] Re: not create a dot file in same folder as document when opening it for viewing

2012-09-11 Thread Brian Barker
o so [when viewing is all that is required]?" This is a sensible question. Try setting the document file to "read-only" in the operating system before you open the file. That may achieve what you ask. I trust this helps. Brian Barker -- For unsubscribe instru

Re: [libreoffice-users] calc - message in cell

2012-09-09 Thread Brian Barker
rust 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.libreof

Re: [libreoffice-users] Date will not format or sort when imported into calc (ods)

2012-09-01 Thread Brian Barker
ial... (or right-click | Paste Special... or Ctrl+Shift+V) instead of ordinary Paste; in the Paste Special dialogue, ensure "Paste all" is not ticked and then that Formulas is not ticked (but "Date & time" is) as well. I trust this helps. Brian Barker -- For unsubscri

Re: [libreoffice-users] Re: Find and replace graphics

2012-08-31 Thread Brian Barker
l you discover what works for you - perhaps "Formatted text [RTF]" or just "Unformatted text". Apply your own formatting to the new text in the document. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

Re: [libreoffice-users] Re: 3.6 calc page preview problem

2012-08-27 Thread Brian Barker
At 14:02 27/08/2012 -0700, Paul Morgan wrote: Brian Barker wrote Do you have a print range defined on your new sheet? Once a print range is defined anywhere, only material within print ranges is printed (or exported to PDF). So no other sheet will print unless you define print ranges

Re: [libreoffice-users] 3.6 calc page preview problem

2012-08-27 Thread Brian Barker
ed anywhere, only material within print ranges is printed (or exported to PDF). So no other sheet will print unless you define print ranges (possibly encompassing entire sheets) on those sheets. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@glob

Re: [libreoffice-users] Reply settings on this list have changed

2012-08-12 Thread Brian Barker
emphasis). The author of a message, of course, is not the list. 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.documentfoun

Re: [libreoffice-users] formatting

2012-08-10 Thread Brian Barker
At 16:31 10/08/2012 -0700, Andrew Brager wrote: The answer suddenly dawned on me. I believe it was Brian Barker that actually provided the solution to my problem, so he gets 90% of the credit. As he suggested to me, create a template. I think that might work for you too. If he's wi

Re: [libreoffice-users] Can't Sum() time measurements

2012-08-09 Thread Brian Barker
h is presumably what you would want. But if you format the result cell as Time, the calculation adds 18 hours to the first time - which, in truth, is 6 p.m. on that first day - which gives noon on the following day. If you suppress the date element, you will see just 12:00:00, which may not be what y

[libreoffice-users] Re: register true origins

2012-08-07 Thread Brian Barker
ot;accurately placed", and as an adverb "precisely" or "exactly". So "register true" can mean "align exactly" or "precise alignment". (There's nothing about baselines - but we're talking about vertical alignment, so what else cou

Re: [libreoffice-users] "insufficient user rights" if I change the filename

2012-08-06 Thread Brian Barker
along with millions of others with properly functioning operating systems - will not be able to help you. 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: paragraph marks

2012-08-06 Thread Brian Barker
ollar sign to the end of a paragraph. So ^$ matches an empty paragraph. 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.documentfoun

Re: [libreoffice-users] Forcing a paragraph onto odd numbered pages

2012-08-01 Thread Brian Barker
followed, it is that chapters are made to start on a recto - a right-hand, odd-numbered page. 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] "insufficient user rights" if I change the filename

2012-08-01 Thread Brian Barker
-saves; ... No: that will be a different place! The first folder is governed by your e-mail application, but this one by LibreOffice. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-

Re: [libreoffice-users] pdf creation issue on a single file?

2012-07-31 Thread Brian Barker
At 15:53 31/07/2012 +0200, Hylton Conacher wrote: On 31/07/12 03:03, Brian Barker wrote: You have a print range defined on sheet 20 of 24 ... My heartfelt thanks on resolving the issue of non export of tabs in a PDF. Your solution and instructions on how to remove worked flawlessly. I have

Re: [libreoffice-users] Re: convert to pdf - failing

2012-07-30 Thread Brian Barker
e as PDF using a virtual PDF printer. 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 Li

Re: [libreoffice-users] pdf creation issue on a single file?

2012-07-30 Thread Brian Barker
to Export as PDF as to Print itself. Remove the print range from the rogue sheet (Format | Print Ranges > | Remove) and everything is hunky-dory. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.

Re: [libreoffice-users] re-merging a master document

2012-07-29 Thread Brian Barker
At 13:32 29/07/2012 -0400, Bill Drescher wrote: Is there a way to have the master document merge the subdocuments again without closing and opening it ? Try Tools | Update > | Links (or Tools | Update > | Update All). I trust this helps. Brian Barker -- For unsubscribe instructions

Re: [libreoffice-users] Re: LibO 3.6.0.2 - Calc: date notation

2012-07-26 Thread Brian Barker
part first, shouldn't that be not "2000 years" but "0002 years"? ;^) 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://wik

Re: [libreoffice-users] Bullets / Numbering in L O

2012-07-25 Thread Brian Barker
At 23:26 25/07/2012 -0400, George E Noon wrote: I'll also try removing the toolbar with the numbers & bullets control on it... For what it's worth, that won't help you at all: that's merely removing the (simplest) means of applying the unwanted functionality manually.

Re: [libreoffice-users] Bullets / Numbering in LO

2012-07-25 Thread Brian Barker
it. Incidentally, another easy workaround is just to use Edit | Undo (or Ctrl+Z) *immediately* you see the unwanted correction occur. This will remove the correction and leave exactly what you typed. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: us

Re: [libreoffice-users] Re: Can I populate a whole row in Spreadsheet by importing from Database into only one cell?

2012-07-24 Thread Brian Barker
estination table horizontally, you will just have to modify that formula - to COLUMN()-2 or whatever. 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: New Zealand connection, was Fw: Re: [libreoffice-users] now can Purchase a NA-DVD

2012-07-24 Thread Brian Barker
scientific community? (The delay on the double journey to and from a geostationary satellite is about a quarter of a second.) Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscrib

Re: [libreoffice-users] Restore Separate Navigator Window?

2012-07-22 Thread Brian Barker
n, but somewhere on the grey area around the buttons and around the main panel - between the buttons or around the edge. o With focus on the Navigator window, press Ctrl+Shift+F10. Both these techniques should toggle the window between floating and docked. I trust this helps. Brian Barker

Re: [libreoffice-users] Can I populate a whole row in Spreadsheet by importing from Database into only one cell?

2012-07-21 Thread Brian Barker
la summing the assigned values and subtracting the result from the original (fixed) value in the other table. This way, the cell(s) will show running totals as points are assigned. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

Re: [libreoffice-users] [3.5.3.2/Calc] Display drop-down list in all cells in column?

2012-07-17 Thread Brian Barker
entire column - before you use Data | Validity... | Criteria | Allow | List. 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: CALC-Need an easier way to do the following -

2012-07-15 Thread Brian Barker
At 15:59 15/07/2012 -0700, Andreas Säger wrote: Vertically: =A1+MOD(ROW(A1);2) Horizontally: =A1+MOD(COLUMN(A1);2) Do you perhaps mean: Vertically: =A1+MOD(ROW(A1)-1;2) Horizontally: =A1+MOD(COLUMN(A1)-1;2) Brian Barker -- For unsubscribe instructions e-mail to: users+h

Re: [libreoffice-users] CALC-Need an easier way to do the following -

2012-07-15 Thread Brian Barker
formula with the "-1" modified. 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/Netiq

Re: [libreoffice-users] Re: [3.5.3.2/Calc] Multiply percentage with fraction?

2012-07-09 Thread Brian Barker
t may be so. But it *is* what your questioner may have meant. 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.or

Re: [libreoffice-users] any standard fonts offering old style numbers???

2012-06-10 Thread Brian Barker
t full height. See http://fontfeed.com/archives/figuring-it-out-osf-lf-and-tf-explained/ . 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-unsu

Re: [libreoffice-users] Re: Font Problems on OS X

2012-06-07 Thread Brian Barker
At 23:06 07/06/2012 +0100, Tom Davies wrote: I don't think we have a "Public Domain" in the UK [...] and i don't think we have "fair use" either. Is your ambition to be wrong on all counts? Brian Barker -- For unsubscribe instructions e-mail to: users+h...@g

Re: [libreoffice-users] Re: Is 3.5.4 ready for business users?

2012-06-03 Thread Brian Barker
. You are implying that a file with a .docx extension but actually in .doc format will be happily opened by Microsoft Word - that Word will simply interpret the contents and ignore the inappropriate extension, that is. Sadly for your theory, that appears not to be the case. Brian Barker

Re: [libreoffice-users] Re: Is 3.5.4 ready for business users?

2012-06-03 Thread Brian Barker
At 19:03 03/06/2012 +, Felmon Davis wrote: On Sun, 3 Jun 2012, Brian Barker wrote: At 18:14 03/06/2012 +, Felmon Davis wrote: I am curious: what happens if one just changes the file extension from .doc to .docx? Roughly the same as if you call your cat Rover. sorry I cut the thread

Re: [libreoffice-users] Re: Is 3.5.4 ready for business users?

2012-06-03 Thread Brian Barker
At 18:14 03/06/2012 +, Felmon Davis wrote: I am curious: what happens if one just changes the file extension from .doc to .docx? Roughly the same as if you call your cat Rover. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http

Re: [libreoffice-users] Re: Calc: Search & Replace Within A Column

2012-05-26 Thread Brian Barker
At 15:43 26/05/2012 +0200, Miguel Angel wrote: El 26/05/12 12:41, Brian Barker escribió: At 17:14 25/05/2012 +0200, Miguel Angel wrote: Maybe the mistake is in search for 0.000, it can't be found, because a 0.000 is always saved as 0, nonsignificant zeroes to the right/left of decimal

Re: [libreoffice-users] Re: Calc: Search & Replace Within A Column

2012-05-26 Thread Brian Barker
ot; but *always* stored? 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 Lis

Re: [libreoffice-users] Re: DocX

2012-05-13 Thread Brian Barker
At 21:18 13/05/2012 +0300, Dotan Cohen wrote: Are you suggesting that the compatibility packs update the Word | Powerpoint | Excel Viewers? Yes. 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: IPad?

2012-05-13 Thread Brian Barker
d how, but they will know that you broke their document! 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/Netiq

Re: [libreoffice-users] Re: DocX

2012-05-13 Thread Brian Barker
as similarly modified, to open, display, and print documents in the newer formats too. 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: Email more than one .doc file

2012-05-08 Thread Brian Barker
ail-client. Mine couldn't handle it and i don't think Outlook would either. For what it's worth, you think wrongly: you can do this in Outlook. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-

Re: [libreoffice-users] how add new alphabetic and numeric for generate in CALC?

2012-05-07 Thread Brian Barker
-case letter. Alternatively, you could make a list of the sixty-two characters; suppose these are in A1 to A62. Then =INDIRECT("A"&INT(1+RAND()*62)) will create a single random character from the set. This may give you a start; I trust it helps. Brian Barker -- For unsubscrib

Re: [libreoffice-users] caption editing

2012-05-07 Thread Brian Barker
aining the first frame, which is slightly messy. But yes: the numbering works and this is another workaround. Brian Barker PS: Apologies that my mail client refuses to reproduce your L-stroke. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Prob

Re: [libreoffice-users] caption editing

2012-05-07 Thread Brian Barker
n, but the next illustration will repeat the same number (and any later illustrations have numbers one too small), and any later drawings will in general have wrong numbers too. That's why there is a problem. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libre

Re: [libreoffice-users] caption editing

2012-05-07 Thread Brian Barker
f necessary, press F9 to update the fields to renumber the illustrations automatically. 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 guidelin

Re: [libreoffice-users] predefined text to paste / insert

2012-05-02 Thread Brian Barker
ptions, ensure "Use replacement table" is ticked.) In your document, now just type "#c" etc. and watch the fun! I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/maili

Re: [libreoffice-users] How do I switch off auto html on Libre Office spreadsheets

2012-04-30 Thread Brian Barker
managed to kill it with MS - how do I do this with Libre Office? Remove the tick from Tools | AutoCorrect Options... | Options | URL Recognition. 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] Open Office Locked Document, On Its Own?

2012-04-25 Thread Brian Barker
ot be present in the transferred copy of the folder. 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.documentfound

Re: [libreoffice-users] first line indents in .odt vs .doc in LO 3.5.2.2. on Win7

2012-04-16 Thread Brian Barker
, leaving the formatting until the content was settled, and then apply necessary formatting later. Use styles and this could be quick. And you may be able then to distribute what you need as PDF. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h

<    8   9   10   11   12   13   14   15   >