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
. 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
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
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
.
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
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 +
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
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
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
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
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
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
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
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
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
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.
)
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
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 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.
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
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
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:
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.[...]
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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_
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:
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
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 +
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
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
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
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
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
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
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
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
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)
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
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-
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.
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'
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
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
. 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
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
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
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
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
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
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
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
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
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
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
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
-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
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
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.
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
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
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
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
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
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:
- 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
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
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
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
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
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
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/
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
, 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
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
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
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
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
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 +
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
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
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
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
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
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
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
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
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
1001 - 1100 of 1406 matches
Mail list logo