Re: [libreoffice-users] Fixing Printing Paper Defaults

2013-08-13 Thread Brian Barker
l have default paragraph styles (perhaps Default or "Text body"?), and you can select a preferred font in each of those - or, indeed, in multiple paragraph styles. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.l

Re: [libreoffice-users] Can LO still read password protected documents?

2013-08-08 Thread Brian Barker
. Rolled back one version and I was able to read my documents again. Is it just me? Apparently not. I'm guessing, but is the problem https://bugs.freedesktop.org/show_bug.cgi?id=64916 (where there appears to be a workaround)? Brian Barker -- To unsubscribe e-mail to: users+uns

Re: [libreoffice-users] [Calc] how to make this formula more "compact"?

2013-08-08 Thread Brian Barker
t;:"&RIGHT(A1;2)) But that leads to what is perhaps a simpler version: =DATE(2013;MID(A1;3;2);MID(A1;6;2))+TIME(MID(A1;9;2);MID(A1;12;2);RIGHT(A1;2)) Again, you need to format the result cell to display the date and time as you wish to see them. I trust this helps. Brian Barker

Re: [libreoffice-users] [4.0/Win] Edit form?

2013-08-08 Thread Brian Barker
ument and posted it on a web site himself to make it available to list subscribers for testing and discussion. (I'm guessing he was originally sent it by e-mail.) We can't blame the originating company for that aspect of any difficulty. Brian Barker -- To un

Re: [libreoffice-users] Re: [4.0/Win] Edit form?

2013-08-08 Thread Brian Barker
. Many people, expecting a .docx file, will try to open it using File | Open... from within Microsoft Word. And they'll do that even with your PDF. But you knew that. It all reinforces what I said about your needing to educate your correspondents! Brian Barker -- To unsubscribe e-mai

Re: [libreoffice-users] [4.0/Win] Edit form?

2013-08-07 Thread Brian Barker
ormat, not the Letter format used by a very few non-standard countries. 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] Calc - Matching Up Text Fields

2013-08-04 Thread Brian Barker
At 09:07 03/08/2013 +0200, Errol Goetsch wrote: On 2013/08/03 02:12 AM, Brian Barker wrote: No - as you'll know, I wrote none of that. Please take care when replying not to misattribute contributions. I'm sorry for offending you Brian. Oh, not at all: absolutely no offence taken

Re: [libreoffice-users] Calc - Matching Up Text Fields

2013-08-02 Thread Brian Barker
At 12:23 02/08/2013 +0200, Errol Goetsch wrote: On Thu, Aug 1, 2013 at 12:27 AM, Brian Barker wrote: yes, left() or mid() is quicker if the contents are fixed. In Don's worse case scenario, where the bank's records have descriptions that are random, unpredictable in length and seq

[libreoffice-users] Fwd: Tavutus [= Hyphenation]

2013-08-02 Thread Brian Barker
From: Timo Kivelä (not subscribed) Hei Latasin OpenOffice version 4. Writer ei osaa t[a]vuttaa. "Käytettävissä olevat kielimoduulit" ikkuna on tyhjä, "Muokkaa" nappula on himmeänä, joten se ei toimi. Miten saan tavutuksen käyttöön? Kiitän vastauksesta jo etukäteen Timo Kivelä Or, in Engli

Re: [libreoffice-users] Fwd: Tavutus [= Hyphenation]

2013-08-02 Thread Brian Barker
At 16:25 02/08/2013 +0100, Brian Barker wrote: From: Timo Kivelä (not subscribed) Hei Latasin OpenOffice version 4. Writer ei osaa t[a]vuttaa. Aaargh! This message was originally sent to the Apache OpenOffice Users list. I forwarded the translation to this LibreOffice Users list by

Re: [libreoffice-users] Re: calc / numerical keypad

2013-08-01 Thread Brian Barker
l formatting controls the display of cell contents rather than the interpretation of values entered. As I said, I think it's the colon you are trying to obviate that is the key to achieving what you need - at least directly. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@g

Re: [libreoffice-users] calc / numerical keypad

2013-08-01 Thread Brian Barker
your data. Alternatively, you could put the data entry column somewhere out of the way - perhaps even on a separate sheet. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-li

Re: [libreoffice-users] Calc - Matching Up Text Fields

2013-07-31 Thread Brian Barker
f the relevant records, you can probably extract it using MID(); otherwise you may need to do a more complicated search through the text. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubs

Re: [libreoffice-users] Calc - Matching Up Text Fields

2013-07-31 Thread Brian Barker
at over for this purpose. In C1 enter =A1 and fill this down the list of entities: you now have a copy of the ID list to the right of the names - where they need to be. Now in D1 enter =VLOOKUP(F1;B$1:C$10;2;0) and fill that down column D. I trust this helps. Brian Barker -- To unsu

Re: [libreoffice-users] IT World

2013-07-31 Thread Brian Barker
was prepared, not when it was sent. But this is all rather off-topic ... 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.o

Re: [libreoffice-users] syllable hyphenation

2013-07-30 Thread Brian Barker
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://listarchives.

Re: [libreoffice-users] Re: Automatic sizing of documents in single window

2013-07-28 Thread Brian Barker
) 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://listarchives.libre

Re: [libreoffice-users] Dimensions [] working

2013-07-27 Thread Brian Barker
How do I fix this? Either suppress the table borders or else modify the row heights or page margins to allow for whatever borders you choose. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-he

Re: [libreoffice-users] Creating non-printable pages in Writer

2013-07-25 Thread Brian Barker
re will be no pages for the headers and footers to appear on and they will be suppressed too. Page Preview will correctly show the material to be printed - and yes: this works equally for exporting to PDF. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr.

Re: [libreoffice-users] CRITBINOM function description is wrong

2013-07-22 Thread Brian Barker
pond to the start of the distribution and be trivial. The original correspondent must be right: "greater than" is surely correct? Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsub

Re: [libreoffice-users] Augmented Matrix in Math

2013-07-21 Thread Brian Barker
At 19:26 21/07/2013 -0400, William Drago wrote: On 7/21/2013 4:03 PM, Brian Barker wrote: At 07:49 21/07/2013 -0400, William Drago wrote: On 7/20/2013 5:58 PM, William Drago wrote: I am trying to create an augmented matrix in LO Math. Never mind... It's done with 2 matrices as fo

Re: [libreoffice-users] Augmented Matrix in Math

2013-07-21 Thread Brian Barker
refer: [...] `mline` [...] 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] Re: Visible currency rounding

2013-07-20 Thread Brian Barker
ndard dictate that in straightforward calculations the result should not be rounded twice. This has been a particular problem with Java as it is designed to be run identically on different machines, special programming tricks have had to be used to achieve this with x87 floating point.[...]

Re: [libreoffice-users] Re: Visible currency rounding

2013-07-20 Thread Brian Barker
ent example of how this works. Using banker's rounding instead of "primary school mathematics teachers's rounding" on your figures, your first dividend, 0.56595, would round to 0.56, not 0.57 (with no change to the other figures), and the total of the rounded values would b

Re: [libreoffice-users] Re: Visible currency rounding

2013-07-19 Thread Brian Barker
the only exception is the case where the third fractional place is 5 and the second fractional place is even. In that case you need ROUNDDOWN(); in all other cases, ROUND() will do the job: =IF(AND(INT(MOD(ABS(Xn)*1000;10))=5;ISEVEN(Xn*100));ROUNDDOWN(Xn;2);ROUND(Xn;2)) (And yes: this works for

Re: [libreoffice-users] Cell references - apply formats too?

2013-07-19 Thread Brian Barker
At 06:44 19/07/2013 -0400, Charles Marcus wrote: On 2013-07-18 10:52 PM, Brian Barker wrote: What you can do, of course, is to set up another column or row in which you put suitable values which can then control conditional formatting of both the target cell and the referencing one. To

Re: [libreoffice-users] Cell references - apply formats too?

2013-07-18 Thread Brian Barker
n't quite do what I think the questioner is asking for. 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

Re: [libreoffice-users] Cell references - apply formats too?

2013-07-18 Thread Brian Barker
target cell and the referencing one. To change the background of both, you merely need to change the controlling values. These could even be colour names: "red", "green", and so on. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libr

Re: [libreoffice-users] Benford's Law

2013-07-18 Thread Brian Barker
At 21:03 18/07/2013 +, Toki "Jonathan" Kantoor wrote: On 07/15/2013 12:42 PM, Brian Barker wrote: ... don't stop being what they are after some arbitrary number of significant figures - whether it be one, three, or any other. At the fourth significant digit, 0 and 9 occu

Re: [libreoffice-users] Calc SYLK support error?

2013-07-18 Thread Brian Barker
olumn-letter-and-row-number form. It appears that Calc also needs its name on the first line. Try this: ID;PSCALC3 C;X1;Y1;K"Row 1" C;X1;Y2;K"Row 2" C;X1;Y3;K"Total" C;X2;Y1;K11 C;X2;Y2;K22 C;X2;Y3;K0;EB1+B2 E Will you need "CALC4" instead for on

Re: [OT] Re: [libreoffice-users] HSLQLDB syntax

2013-07-16 Thread Brian Barker
Advertisers use it when they claim their product is "new and improved" (which is a contradiction), meaning "newly improved". Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns

Re: [OT] Re: [libreoffice-users] HSLQLDB syntax

2013-07-16 Thread Brian Barker
At 16:15 16/07/2013 -0400, Felmon Davis wrote: On Tue, 16 Jul 2013, Brian Barker wrote: At 02:02 16/07/2013 -0400, Felmon Davis wrote: On Sun, 14 Jul 2013, Doug wrote: This is not an acronym. It can't be pronounced as a word. (See dictionary definition in URL below.) the definition

Re: [libreoffice-users] LO Freezing

2013-07-16 Thread Brian Barker
Writer | View | Display, and untick what you don't need there. But that's not per file, of course, but per user. 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-u

Re: [OT] Re: [libreoffice-users] HSLQLDB syntax

2013-07-16 Thread Brian Barker
rs of each of the successive parts or major parts of a compound term; [...] - I'm missing the part about being pronounced as a word. May I help? I think I can. It's right there in the second word of the definition: it says it's a *word*, so it'll be pronounced as, e

Re: [libreoffice-users] Puzzling table numbering

2013-07-16 Thread Brian Barker
y multiple columns in your page or in a section. 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.o

Re: [libreoffice-users] Benford's Law

2013-07-15 Thread Brian Barker
t the difference after, say, three digits? If so, there is equally no point in worrying that these later digits might be too right! Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscri

Re: [libreoffice-users] Benford's Law

2013-07-14 Thread Brian Barker
itial digit of Benford's Law variates: =1 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/Netiquett

Re: [libreoffice-users] Benford's Law

2013-07-14 Thread Brian Barker
At 21:01 14/07/2013 +, Toki "Jonathan" Kantoor wrote: On 07/13/2013 11:01 PM, Brian Barker wrote: Unless I misunderstand,the formula =10^RAND() should create random variates in the range (1,10) following the law. 10^RAND generates a set of random numbers that does _not_

Re: [libreoffice-users] Visible currency rounding

2013-07-14 Thread Brian Barker
arlier values and the rounded sum that you have already calculated in the bottom line. (There is no reason why the spreadsheet cannot calculate back up the column, of course.) I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http:

Re: [libreoffice-users] Benford's Law

2013-07-13 Thread Brian Barker
llowing the law. (Here's hoping you will not use this to create plausible fake scientific data!) 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 gui

Re: [libreoffice-users] Mailing list settings [was: constant crashes]

2013-07-02 Thread Brian Barker
ctive memory! There were (and are?) supporters of the current arrangement. I know, because I'm one. 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] Default font and size

2013-07-02 Thread Brian Barker
At 09:52 03/07/2013 +1200, Steve Edmonds wrote: On 2013-07-03 09:31, Brian Barker wrote: At 13:13 02/07/2013 -0700, John R. Sowden wrote: I am having a problem setting the default font in calc. This is usually not an issue, as I often start a new sheet from an existing sheet. But if I start

Re: [libreoffice-users] Default font and size

2013-07-02 Thread Brian Barker
At 23:56 02/07/2013 +0200, Regina Henschel wrote: Hi Brian, Brian Barker schrieb: At 13:13 02/07/2013 -0700, John R. Sowden wrote: I am having a problem setting the default font in calc. This is usually not an issue, as I often start a new sheet from an existing sheet. But if I start from

Re: [libreoffice-users] Default font and size

2013-07-02 Thread Brian Barker
in the required font - are good, of course. But you may like to check what happens if you start a new document using this template and then create new sheets within the document. I fear you may find that the font defaults back to Arial. I trust this helps. Brian Barker -- To unsubscr

Re: [libreoffice-users] Need help with page formatting please...

2013-07-01 Thread Brian Barker
At 09:42 01/07/2013 -0500, Al Vesper wrote: On Sun, Jun 30, 2013 at 9:32 PM, Brian Barker wrote: At 20:27 30/06/2013 -0500, Al Vesper wrote: I am trying to create mini cue cards, 3"x2.5", meaning I want to print two mini-cards on a 3x5 card which I will cut in half. I want the te

Re: [libreoffice-users] Need help with page formatting please...

2013-06-30 Thread Brian Barker
cut? Or is it in landscape format, waiting for a vertical cut? o Do you want to create multiple cards (multiple pairs of mini-cards) in a single file, or are you expecting to create a separate document file for each pair? Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@gl

Re: [libreoffice-users] Re: LO 4.0.3.3: 'Insert: Horizontal rule' is missing

2013-06-30 Thread Brian Barker
At 17:07 30/06/2013 +, Maurice Noname wrote: On Sat, 29 Jun 2013 16:57:05 +0100, Brian Barker wrote: If you want to make life easier, it may be useful to leave an empty paragraph before using the three-symbol technique to create a border. Then the border is attached to a further empty

Re: [libreoffice-users] Re: LO 4.0.3.3: 'Insert: Horizontal rule' is missing

2013-06-29 Thread Brian Barker
At 15:33 29/06/2013 +, Maurice Noname wrote: On Fri, 28 Jun 2013 14:44:49 +0100, Brian Barker wrote: you will see one of a variety of borders attached to the preceding paragraph. This line is a property of that paragraph, not an entity by itself My problem with those is they seem

Re: [libreoffice-users] LO 4.0.3.3: 'Insert: Horizontal rule' is missing

2013-06-28 Thread Brian Barker
graph. Again, the paragraph itself could be empty. 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/Netiq

Re: [libreoffice-users] Need header outside right margin

2013-06-26 Thread Brian Barker
g and set a suitable negative value for "After text". o Enter your header text and set it Align Right: it will spill over outside the page margins. Remember that your page margins need to be sufficiently narrow that the outdented header text is still within your (or your examiner's)

Re: [libreoffice-users] Style Question (Similar to Helen's, for Plays)

2013-06-26 Thread Brian Barker
o Set "Before text" to some suitable positive value. o Set "First line" to the corresponding negative value. For each speech, type the character name, press Tab, and then type the speech text. The Tab character will move the start of the text to the indented paragraph bou

Re: [libreoffice-users] styles for plays?

2013-06-26 Thread Brian Barker
a stroke. And yes: you could import such styles into any new document in the future or put them in an appropriate 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-

Re: [libreoffice-users] Need header outside right margin

2013-06-26 Thread Brian Barker
Default Formatting (or Ctrl+M) to remove this.) 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.

Re: [libreoffice-users] advanced notes question

2013-06-25 Thread Brian Barker
At 17:04 25/06/2013 +0200, Brian Bakker wrote: On 25/06/2013 16:41, Brian Barker wrote: At 15:31 25/06/2013 +0200, Brian Bakker wrote: I received a document (OpenOffice format) from someone who edited it using Micros[of]t software and inserted notes into the document. However, I don'

Re: [libreoffice-users] advanced notes question

2013-06-25 Thread Brian Barker
ation that LibreOffice certainly does have an "advanced notes feature" (http://www.libreoffice.org/features/writer/ - 10th paragraph) but can't find where to switch it on. LibreOffice now calls these "comments". Try View | Comments. I trust this helps. Brian Barker

Re: [libreoffice-users] Latest

2013-06-23 Thread Brian Barker
At 02:07 24/06/2013 +0200, Anthony Easthope wrote: So To which the answer, I suppose, is "So what?" (Sorry: couldn't resist!) 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] It would [not!] be a bug

2013-06-23 Thread Brian Barker
. If you want zero values here, you need to test for this error value and replace it with zero. You can do this using the ISNA() function, using something like: =IF(ISNA(VLOOKUP(Xn;;2;0));0;VLOOKUP(Xn;;2;0)) I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubsc

Re: [libreoffice-users] Writer page frame

2013-06-18 Thread Brian Barker
created. You may see a warning about this at the first step. 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.documentfound

Re: [libreoffice-users] [Calc LO] How to format numerous charts

2013-06-17 Thread Brian Barker
heet - and then replacing its data by pasting in the new material? 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.documen

Re: [libreoffice-users] LO Calc - [Missing tabs]

2013-06-17 Thread Brian Barker
rtical bar immediately to the left of the horizontal scroll bar - and drag it to the right. 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/ Postin

Re: [libreoffice-users] Re: Searching numbers between two values

2013-06-14 Thread Brian Barker
ed to want to exclude 60 (as well as 20) from your range to be summed. If so, you need ">=60" (three times), not ">60". Is there a simpler way to do it? Yes, there is. If the third parameter of SUMIF() - "SumRange" - is missing, the values found in the

Re: [libreoffice-users] Searching numbers between two values

2013-06-14 Thread Brian Barker
t;>20")-SUMIF('Num 2'.A1:Z99;">=60")+SUMIF('Num 3'.A1:Z99;">20")-SUMIF('Num 3'.A1:Z99;">=60") There may be neater solutions! I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@globa

Re: [libreoffice-users] Re: Searching numbers between two values

2013-06-14 Thread Brian Barker
At 08:52 14/06/2013 -0700, Pedro Noname wrote: Brian Barker wrote Are you sure? When I try this, COUNTIF() looks only at the first cell of your range (e.g. L1:L2), so would simply count values above 20 - wrongly including those above 60. You are correct. I apologize. Oh, thanks - but

Re: [libreoffice-users] Re: Searching numbers between two values

2013-06-14 Thread Brian Barker
u have the inequalities backwards, I think - but no matter.) Are you sure? When I try this, COUNTIF() looks only at the first cell of your range (e.g. L1:L2), so would simply count values above 20 - wrongly including those above 60. Brian Barker -- To unsubscribe e-mail to: users+u

Re: [libreoffice-users] Searching numbers between two values

2013-06-14 Thread Brian Barker
t;60)) Try: =COUNTIF('Num 1'.A1:Z99;">20")-COUNTIF('Num 1'.A1:Z99;">=60") =COUNTIF('Num 2'.A1:Z99;">20")-COUNTIF('Num 2'.A1:Z99;">=60") =COUNTIF('Num 3'.A1:Z99;">20")-COUNTIF('Num

Re: [libreoffice-users] Showing cell contents as text in calc. (Not evaluating the formula the text represents)

2013-06-13 Thread Brian Barker
each time to confirm the edit. 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://listarchive

Re: [libreoffice-users] Showing cell contents as text in calc. (Not evaluating the formula the text represents)

2013-06-12 Thread Brian Barker
tom quotes in the same column, you will see automatic suggestions and will need to Undo twice. So how to do what you require? Here are some workarounds: o Enter a space before the text. This will fool Calc! o Enter the formula =T("{=MMULT(MINVERSE(A14:R31),S14:S31)}") instead. I t

Re: [libreoffice-users] A function doesn't work on cell which is a link to another cell

2013-06-11 Thread Brian Barker
qually well with values in AE6 and so on drawn from another document file - as here in file2 from file1. Are you sure your formula in AD6 of file2 is correct? Does it work if you test it by (temporarily) inserting simple numbers into AE6 and so on in place of the references to file1? What

Re: [libreoffice-users] disable "save as" in odt document

2013-06-11 Thread Brian Barker
-opening the new file in LibreOffice? If you have the authority to forbid their doing that, your problem would be solved anyway. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Postin

Re: [libreoffice-users] Referencing data in a row based on content of cell value in column A?

2013-06-07 Thread Brian Barker
ere, as extracting the relevant number to use is probably the same as the original problem. 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 guideline

Re: [libreoffice-users] Re: LO Calc - Find in a column

2013-06-07 Thread Brian Barker
en all at once. If your computer doesn't do that, buy one that works! If you perhaps move away from the Find & Replace function and attend to the first occurrence found and to edit it in some way, then you may well lose the selection, of course - but you'd expect that.

Re: [libreoffice-users] font behavior in Calc

2013-06-06 Thread Brian Barker
you may have to send a small sample document to someone to examine. 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.do

Re: [libreoffice-users] Re: calc - hours of work in a month

2013-06-05 Thread Brian Barker
At 19:39 05/06/2013 +0200, Adam Noname wrote: On 05.06.2013 19:19, Brian Barker wrote: At 18:43 05/06/2013 +0200, Adam Noname wrote: I have two list of times in format HH:MM , : [...] Then I want to sum all differences. It is not hard = SUM(D2:D33) . It should be in [HH]:MM format to show

Re: [libreoffice-users] calc - hours of work in a month

2013-06-05 Thread Brian Barker
that: =ROUND(Xn*24) 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] Date problem in LO Calc 4.0.3.3

2013-06-05 Thread Brian Barker
At 09:02 05/06/2013 -0700, Spencer Graves wrote: On 6/4/2013 9:23 PM, Brian Barker wrote: At 16:41 04/06/2013 -0700, Spencer Graves wrote: When I copy a date from one LO spreadsheet to another, it changes. Much as you might be surprised by this, it is, I think, by design. Specifically, I

Re: [libreoffice-users] Date problem in LO Calc 4.0.3.3

2013-06-04 Thread Brian Barker
You will notice that two of the date origin choices are four years and two days apart. Er, that's indeed four years and one day if you allow for Microsoft Excel's false belief that 1900 was a leap year. I trust this helps. Brian Barker -- To unsubscribe e-mai

Re: [libreoffice-users] Duden Korrektor?

2013-06-01 Thread Brian Barker
the German language, originally published by Konrad Duden in 1880. So in this context, the "Duden Korrektor" will be a spelling checker based on this dictionary. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http:

Re: [libreoffice-users] Re: Array formulas: maximum value – two conditions

2013-05-31 Thread Brian Barker
- TRUE or FALSE - determines which of the other two arguments is used. That expression may often be a simple test, but the result of an AND() function is just as acceptable to IF(). I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems

Re: [libreoffice-users] What happened to autoformat option?

2013-05-31 Thread Brian Barker
rn off all autoformatting. That would be AutoCorrection. 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.documentfoun

Re: [libreoffice-users] Strange Page Setup/Printing Problem

2013-05-30 Thread Brian Barker
At 09:51 30/05/2013 -0400, Charles Marcus wrote: On 2013-05-30 9:33 AM, Brian Barker wrote: I'm guessing here, but Microsoft Office has only one place to define page and paper size, I think, whereas LibreOffice has two: you define page size in Format | Page... but paper size at File | Pr

Re: [libreoffice-users] Strange Page Setup/Printing Problem

2013-05-30 Thread Brian Barker
you go to Format | Page... | Page | Paper Format and select an appropriate size? If not, you are expecting LibreOffice to scale your printout automatically - or even to rotate it. But, as I say, I'm guessing. Printers are never straightforward! I trust this helps. Brian Barker -- To

Re: [libreoffice-users] countif() problem in calc

2013-05-30 Thread Brian Barker
places, but the calculation in K3 will use the values *as displayed* in I3 and J3, so will be limited to hundredths of a cent. That way, the comparison should be more reliable. An alternative may be to modify your formula in J3 to round the value to hundredths of a cent explicitly. I trust this

Re: [libreoffice-users] Re: How to extract a color from a text?

2013-05-29 Thread Brian Barker
colour was (sensibly) originally applied as a paragraph style, not if it was applied, say, as local character formatting. 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] Random listing of documents in window menu

2013-05-25 Thread Brian Barker
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] How to extract a color from a text?

2013-05-25 Thread Brian Barker
a character style with the captured colour, which you can apply to other text in the normal way. 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/ Post

Re: [libreoffice-users] Replying to users

2013-05-22 Thread Brian Barker
, you will only receive one of this message, even though the list is in the Cc. I imagine you will hear that this was not so. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Pos

Re: [libreoffice-users] assign templates in Calc

2013-05-21 Thread Brian Barker
ime). If you prefer, you can avoid this danger by leaving the source document closed and using the File... button in the Template Management panel to browse to and add the file to the list. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice

Re: [libreoffice-users] Bug with data validating

2013-05-21 Thread Brian Barker
out changing the value (really good) ... Again, the manual makes clear that "a validity rule is considered part of a cell's format". ... but doesn't validate data whether it is complying. See earlier comments. I trust this helps. Brian Barker -- To unsubscrib

Re: [libreoffice-users] LibreOffice Portable Writer changes my custom style?

2013-05-15 Thread Brian Barker
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/g

Re: [libreoffice-users] Untitled 1

2013-05-13 Thread Brian Barker
e original default, simply go to File | Templates > | Organize... | Commands | Reset Default Template | Text Document. There is no need to wreck your other settings and customisations. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@glob

Re: [libreoffice-users] Paste of Dates Incorrect in Calc

2013-05-12 Thread Brian Barker
to look at the documents themselves - or stripped down versions, showing just the problem. 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] How to center a pasted drawing?

2013-05-12 Thread Brian Barker
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://listarchives.l

Re: [libreoffice-users] Help with multiple indexes

2013-05-09 Thread Brian Barker
l changes". Now you will be able to select the index entries and use Tools | Sort... to sort them. You'll have to repeat the sorting each time you update the index, of course. Is that what you are supposed to do? I trust this helps. Brian Barker -- To unsubscribe e-m

Re: [libreoffice-users] Copy / Paste - Include Recorded Changes?

2013-05-08 Thread Brian Barker
come back in a state where the above technique will work. 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.document

Re: [libreoffice-users] Hide rows in a table in Writer

2013-05-06 Thread Brian Barker
At 00:50 07/05/2013 +0100, Tom Davies wrote: If the table is a spreadsheet (Calc) ... I wonder if the message subject gives us a clue about this ... Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists

Re: [libreoffice-users] Hide rows in a table in Writer

2013-05-06 Thread Brian Barker
that I know of. Workaround: o Save the document. o Delete the offending rows. o (Check the resulting changes to other parts of the document.) o Print. o Close the document, carefully *discarding* changes. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr

Re: [libreoffice-users] Paragraph styles (collaborating on documents)

2013-05-03 Thread Brian Barker
It's just that there is less of a problem if the last person is permitted to do whatever s/he wishes. Brian Barker -- For unsubscribe instructions e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsu

Re: [libreoffice-users] Paragraph styles (collaborating on documents)

2013-05-03 Thread Brian Barker
way to go: to develop and agree on the content separately from the format. The format is either locked down from the start or imposed separately at the end. That's what intelligent web authoring arrangements use, of course. Brian Barker -- For unsubscribe instructions e-mail to: user

Re: [libreoffice-users] Odd behavior using DATE() function in calc

2013-05-02 Thread Brian Barker
r. In that case, it is again your responsibility to build checks into the way you use the data. You can use the IF() function to detect inappropriate data and to create the error messages you desire. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@gl

Re: [libreoffice-users] Writer - Spacing

2013-05-01 Thread Brian Barker
or - better still - create a paragraph style with extra line spacing and apply this style to the relevant paragraphs. 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

<    6   7   8   9   10   11   12   13   14   15   >