scale" ticked in error?
I trust this helps.
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
Li
ound to be defective. Hence
the current out-of-band publication.
... but for the most part they stick to holding patches back until
the next Tuesday.
Er, the next *Patch* Tuesday.
I suspect it's more to do with rebooting, ...
Exactly so.
Brian Barker
--
For unsubscribe instru
instead of ordinary Paste. In the Paste Special dialogue, remove the
tick from "Paste all" if necessary, and ensure that Numbers is ticked
but Formulas is not ticked.
I trust this helps.
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
you searched for "free web hosting services"?)
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
he tick from "Paste all" if
necessary, and then ensure that Numbers is ticked but Formulas is not
ticked. (Note that freezing the result of a formula into a plain
value in this way is something you *can* do using Paste Special... .)
I trust this helps.
Brian Barker
--
For unsubscr
ersion. Thanks for the correction. Apologies.
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 a
rs indeed to be Tahoma, but can be reset.
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/
At 13:08 01/04/2013 +0100, Brad Rogers wrote:
Tone of voice is difficult to convey via the written word.
Oh, indeed!
As a result misinterpretation is understandable.
Quite so: no criticism intended.
Brian Barker
--
For unsubscribe instructions e-mail to: users+h
At 11:50 01/04/2013 +0100, Brad Rogers wrote:
On Mon, 01 Apr 2013 04:11:06 +0100 Brian Barker wrote:
So the interesting paradox is that the one message to which the
label was not added was your present one!
What paradox?
That the only way to prevent the list adding the label was to include
"[LO-users]"?
Consider yourself lucky: I'm a subscriber to
"[HounslowCentralNorthandEast-Freecycle]"!
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-lis
words, what is preserved in the document is merely
the name of the author of each change, not any colours - which are
then determined by the options for the current user.
You may like to experiment to confirm that this is true for your arrangements.
I trust this helps.
Brian Barker
the correction whilst
keeping your original typing if you go to Edit | Undo (or Ctrl+Z)
immediately you see the change.
3. If you really want to disable this completely, remove the tick
from Tools | AutoCorrect Options... | Options | Apply border.
I trust this helps.
Brian Barker
--
Import window to
control how values are interpreted.
But you probably knew that ...
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wi
lect
the value next below when there is no exact match.
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/Netiquett
now in C10, in fact.)
In B1, enter:
=VLOOKUP(A1;C$1:D$9;2)
and fill down column B.
Voilà!
This even works with column A values not being
sorted, as you have asked. All that is required
is that column C should be sorted - and that is no problem, of course.
I trust this helps.
Brian Bark
alues either on screen or on
printout, you can avoid this is various ways:
o You can hide the relevant columns.
o You can move them out of your print ranges.
o You can move them to other sheets.
I trust this helps.
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoff
u are hoping to achieve, I'm sure there will
be people willing to help. I look forward to that!
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines +
o not need to be
immediately visible or to print along with the
values you do need to see. It may not even be
necessary to create new columns, if the
conditions they need to contain could be derived
directly from whatever is their source.
I trust this helps.
Brian Barker
--
For uns
do want. It's generally
better to explain carefully exactly what you are trying to do.
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
ion or the formula from
working, of course, so the result should show up, but as 0 or 1 (what
is actually stored) instead of FALSE or TRUE.
I converted that column to Boolean and Viola!!
Er, who she?
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.or
n place
of the',' but no luck!
Again, what happened?
Remember that the point of EXACT() is to test the *exact* similarity
of the two strings, so an extra space somewhere or even a trailing
space in one string will make them different, as will case differences.
I trust this helps.
B
her cells the only way?
Well, yes: that's what I did. As you take the formula apart, you
will begin to see what it does and how. No, I don't see any clever
way to analyse a formula. Fundamentally, I think you need the
formula's author to explain how it works - which is
suggestion now is a straw man.
Everyone will have giggled at your original suggestion ("I tend to
distrust freeware") in the context of the mailing list for a freeware
product. Mine was just the obvious throw-away response. Remember the
advice: when in a hole, stop digging
";X1)+1
and in the required cell:
=MID(X1;X2;FIND("'#";X1)-X2)
The regular expression in the SEARCH() function matches a slash
followed by any number of characters (at least one) not including a
slash followed by your single-quote hash-mark combination,
effectively finding the be
t it out of
the way - outside your print range - or even on a separate sheet.
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
work if you have no other reason to change
the page style or even no reason to insert the page break. Simply
insert a "section" to contain your two-column material. The section
itself, rather than the page style, can be given the two-column property.
I trust this helps.
Brian B
At 14:03 15/03/2013 +, Tom Davies wrote:
... but i tend to distrust freeware ...
You'd better avoid LibreOffice, then.
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubs
At 12:05 13/03/2013 -0700, Tom Davies wrote:
Ideally text written into the box on page 1 would automatically flow
into the box on the next page ...
Help | frames;linking. Or LibreOffice 3.6 Writer Guide p 122 "Linking frames".
I trust this helps.
Brian Barker
--
For u
converts that blank to zero explicitly.
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.document
phs and of
paragraph styles. Right-click in your text and go to each of
Paragraph... and Edit Paragraph Style... . You may find the rogue
spacing in either of those places.
I trust this helps.
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Prob
e removed the
extraneous material before publishing the document and in any case
that it is probably improper for them to require the form's users to
purchase a specific commercial product (Word) in order to be able to
use it straightforwardly.
I trust this helps.
Brian Barker
--
For u
At 13:22 27/02/2013 +, Pierre Masci wrote:
... i thought that i needed to go to the first cell of the column,
for the last step. In fact i didn't.
It's always best to ask the real question - not the small bit that
you think you need but might not!
Brian Barker
--
For u
will be pretty useless with sparse data.
Note that you can move about in similar ways using combinations of
Ctrl plus the other three arrow keys.
I trust this helps.
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffi
It is often possible to solve a problem by doing something in a
different way from how you first imagine. If an apparently simple
problem does not have an obvious solution, that may be a hint that
you are going about things in the wrong way.
Brian Barker
--
For unsubscribe i
D$2;"")
In H4, enter:
=IF(D4="Y";G4*D$2;"")
In each case, fill these formulae down the column.
I trust this helps.
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-h
can check which parts of
your document are styled as "Converted1" and which - if any - as
"Default" and insert your headers or footers appropriately.
I trust this helps.
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http:
At 14:47 21/02/2013 -0500, James Knott wrote:
Brian Barker wrote:
(And anyway, if you are estimating, a metre *is* a yard!)
Or more closely, 40" or precisely 39.37".
Sorry, but you have delusions of precision. The claim I was
commenting on was that *estimating* (not my word)
time
estimating a meter or kilometer.
Children throughout the world can do it. Even you could! You'll
never do it until you determine to do so; the only problem is that
you haven't yet tried.
(And anyway, if you are estimating, a metre *is* a yard!)
Brian Barker
--
For unsubscribe
e example A2, A3,A5,A6 would all be true).
Er, that's 2, 3, 6, and 7.
The solution that was provided to me before was:
=NOT(ISERROR(TEXT("regression",A2)))
Close but no cigar! What I suggested at the time (8 February) was
=NOT(ISERROR(FIND("regression";A2)))
for B2 a
s the international standard.
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:
tries to catch up.
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:
At 14:36 20/02/2013 -0500, Tim Lungstrom wrote:
Europe A4 size
Perhaps that should be
"everywhere-in-the-world-except-the-United-States-and-Canada A4 size".
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffi
$5;C2)
and fill this down the column.
With this version, you will need to format column D as Percent. If
you preferred, you could add *100 to the formula and format the
column as Number.
I trust this helps.
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffic
oftware provide an explicit
reading mode for use in reading, not editing,
documents? Possibly. Meanwhile, if you want something close to this
behaviour in Writer, here's your workaround: just click the Edit File
button in the Standard toolbar to toggle on this behaviour.
I trust this hel
At 08:50 14/02/2013 -0500, Nobody Noname wrote:
On 2013-02-14 1:23 AM, Brian Barker wrote:
At 20:14 13/02/2013 -0500, Pete Bonly wrote:
Does Calc have some kind of method to subdivide individual cells?
[...] By starting with multiple rows or multiple columns (or
both?) and merging some of
ng to find it in the archives!
He probably doesn't need to ...
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
to your problem ones in order to start this process.
I trust this helps.
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http
em to; later versions of Microsoft
Office have dropped this idea but allow you to pin items already on
the recent files menu so that they do not drop off.
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/maili
At 08:39 11/02/2013 +0800, Conly Honly Donly wrote:
2013/02/10 10:42 PM, Brian Barker:
At 21:36 10/02/2013 +0800, Conly Honly Donly wrote:
I think I have found a bug.
I'm not so sure.
This potential bug may affect printing, e.g. producing blank pages
because the page count does not
.
In any case, is this the reason why this may be an unusual request?
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.o
he same selection on the fly through the
Options... button in the Print dialogue.
I trust this helps.
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines +
e and
name a new one.
Your new bitmap will now be available in Calc, but you may have to
close and reopen your spreadsheet document before it appears.
I trust this helps.
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.or
At 08:45 08/02/2013 -0800, Joel Madero wrote:
On Fri, Feb 8, 2013 at 8:06 AM, Johnny Rosenberg wrote:
2013/2/8 Brian Barker:
At 14:05 07/02/2013 -0800, Joel Madero wrote:
I have enabled regular expressions in
LibreOffice settings but still am unable to
get this one to work. Here is my line
should get TRUE or 1 if
N200 is exactly "*regression*" and FALSE or 0 otherwise.
There are a number of functions which allow regular expressions (see
the help text), but "=" is not one of them.
I trust this helps.
Brian Barker
--
For unsubscribe instructions
At 17:12 06/02/2013 -0500, Jay Lozier wrote:
Maybe psst a feature request in Bugzilla?
No need to be secretive about it: go ahead and post it!
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing
neither. It sounds as
if you have Extended tips; you might be happier with just Tips.
I trust this helps.
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting
quired to insert the
names in column A in the correct places for the scheme to work, he
would have done all the work already.
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
P
e your
next update. All that is necessary is that you have an exactly
complete set of the formulae in the range of column D - in whatever order.
Is that any better?
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/g
result values, and then sort those values
instead. The sort would otherwise have no effect on the formulae in column C.
I trust this helps.
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how
that (simpler) formula work for you? (I put spaces around the
plus signs only for ease of reading; you may want to edit them out again.)
Does the same happen in newer versions of Calc?
Your original formula produces Error 508, which quite correctly
observes that the brackets are mism
).
o Now double-click the dummy equation. The Math window opens at the
foot of the window and you can edit the equation's definition -
removing it entirely and replacing it with your own.
I trust this helps.
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libr
ether this will handle your DD.MM. may depend on your
locale setting. Otherwise, something such as
=DATE(RIGHT(Xn;4);MID(Xn;4;2);LEFT(Xn;2))
ought to work.
Alternatively, does this point you in the right direction to create a macro?
I trust this helps.
Brian Barker
--
For unsubscribe inst
ecessarily.
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/Neti
At 16:10 30/01/2013 -0500, Taang Zomi wrote:
I did all you said above, and I got all the results.
Good-oh!
The second suggestion is an effective workaround for you, then:
typing F, o, r, Enter is hardly any longer than f, n, F3 would have been.
Brian Barker
--
For unsubscribe
mall note window saying "Formula Numbering" appear?
o Whilst the small window is displayed, press Enter.
o Does the dummy numbered equation now appear?
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.
Text.
o Ctrl+F3 is "AutoText": it opens the AutoText dialogue, which enable
you to do much more. You can even invoke AutoText entries that way,
but it is a long-winded way of doing so!
The error behind F3 should be taken care of.
There is no error that most of us can see.
Bria
eve what he needs. He was having difficulty with that.
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.
have (mis)interpreted the instructions as meaning that
you should hold down the Fn key and then press F3, the error message
you quote is exactly what you would see. On this type of keyboard,
you need to type "f", type "n", and then hold down the Fn key whilst
pressing F3.
Br
Then you take your finger away from the "f" key and briefly press
the "n" key instead.
o Now you will see the required result "fn" in your document.
I trust this helps.
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Proble
x27;' not found" - in other
words, AutoText seems to be failing to pick up the shortcut "fn" in
the first place.
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsu
At 15:38 29/01/2013 -0500, Taang Zomi wrote:
I just started a new Writer document, typed fn and then pressed F3,
and got the same message:
I don't understand. Did you type a space (or anything else) after
the "fn"? You mustn't do that!
Brian Barker
--
For unsubs
At 11:51 29/01/2013 -0500, Taang Zomi wrote:
On Mon, Jan 28, 2013 at 12:30 AM, Brian Barker wrote:
At 18:04 27/01/2013 -0500, Taang Zomi wrote:
In LibreOffice 3.3 Math Guide (0700MG33-MathGuide3.3.odt), on p.
14, the following is written:
*Numbering equations*
Equation numbering is one of
lick the equation to open the Math
window at the bottom of the window, where you can remove the dummy
equation's definition and replace it with your own.
I trust this helps.
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http:/
d then set
the character properties that you want in the Drop Caps character style.
You could alternatively create your own character style(s), of
course. But that's true of all the predefined styles.
I trust this helps.
Brian Barker
--
For unsubscribe instruction
ter. For "alignc" (align centre) read
"alignl" (align left).
Attachment: Left Justification in Stacked Scalable Braces.odt (16K)
Attachments are removed by the list processor before your message is
distributed, so no-one will have seen this.
I trust this helps.
Brian
At 13:44 23/01/2013 +0100, Kolbjørn Stuestøl wrote:
Den 23.01.2013 07:29, skreiv Brian Barker:
At 22:57 22/01/2013 +0100, Kolbjørn Stuestøl wrote:
Is there any way to find the first occurrence
of a number less (or greater) than a given
number in an unsorted array or a column?
Example: A1:A31
;^)
I trust this helps.
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
es, one per line, in the Entries
box. (The other tabs provide facilities for restricting possible
entries as well as setting an error message.) Now you will see your
desired entries if you either use right-click | Selection List... or
click the down arrow next to the current cell.
I tru
alc,
and so on.
I trust this helps.
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List arch
that he cannot
be correct to question your claim until you have posted a proof of
your belief - in other words a proof of your original claim.
;^)
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/maili
oves the empty paragraphs
left by the previous process.
o Go to Edit | Select All (or press Ctrl+A) and use the Apply Style
window again to reset your paragraph style appropriately (to Default?).
I trust this helps.
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.lib
me before you print on each
occasion. To do this, go to Tools | Cell Contents > | Recalculate
(or just press F9).
I trust this helps.
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/ho
set a Right tab
stop at the right text margin.
This is useful anywhere - not just in headers and footers. Indeed,
this is how your table of contents works.
I trust this helps.
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems?
l versions of the lists. And that's just
as clearly not what the questioner did. (Nomail is mentioned at the
web site only in a footnote.) The questioner's problem was - as
described - the well-known behaviour of his Gmail account ...
Brian Barker
--
For unsubscribe instruction
need to
update the table. Go to Tools | Update >, and then choose from
Current Index (if your cursor is in the table of contents), All
Indexes and Tables, or Update All.
I trust this helps.
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreof
his Gmail account, which has this interesting feature - of archiving
the returned copies of his own messages to lists.
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscri
er connected to anything).
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
Lis
the footnote text and paste it as required.
The text of all the footnotes will be concatenated into a single
piece of text and will lose all connection to the original footnote
markers - but this is in the nature of what you will be trying to
achieve using Paste Special... in any case, of
cument needs to be fresh ;-)
That's not true. But in any case, you are presumably suggesting that
a fresh document would anyway be necessary with your round-the-houses
route via other software.
Again, you are very welcome to go the long way around if you
prefer. You will not be the only pe
your other programs cope only with CSV files? Not spreadsheet
document files?
I trust this helps.
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting gui
At 12:24 21/12/2012 -0600, Anne Noname wrote:
On Fri, Dec 21, 2012 at 10:11 AM, Brian Barker wrote:
Use of Edit | Paste Special... | Unformatted text (or Ctrl+Shift+V
| Unformatted text) in LibreOffice is all that is required. No
need for Notepad or any other separate software.
The
ointing out
(perhaps for other readers' benefit) that this is an unnecessarily
complicated technique. Use of Edit | Paste Special... | Unformatted
text (or Ctrl+Shift+V | Unformatted text) in LibreOffice is all that
is required. No need for Notepad or any other separate software.
n dialogue, click
Options... and again change the selection in the drop-down list for
"Caption order"..
I trust this helps.
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/maili
u can then sort by those cells after sorting by street name) or
else keep the cells as they are but extract the number part into a
separate cell (which you can hide if you prefer) and then sort by those cells.
I trust this helps.
Brian Barker
--
For unsubscribe instructions e-mail t
At 06:06 20/12/2012 +, Tom Davies wrote:
At 04:18 20/12/2012 +, Brian Barker wrote:
At 00:14 20/12/2012 +0800, Nobody Noname wrote:
... there is a thing that, if we cannot strictly to define as a
BUG, is, at least, a "defect" regarding the right typography. I
mean the b
r OpenOffice or LibreOffice to become layout
software as well as word processing software. I have no idea whether
its developers would wish to do this.
I trust this helps.
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoff
done this, it should be a simple matter to apply
conditional formatting - probably depending on the original source
cells, not the target cells - to your harvested values in the target cells.
I trust this helps.
Brian Barker
--
For unsubscribe instructions e-mail to: us
uldn't a better solution be to construct your database so that you
didn't need to represent this thrice-inappropriate date value?
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/ho
eplace.
Incidentally, one tick mark is feet; two is inches.
I trust this helps.
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wik
At 16:35 12/12/2012 -0500, Carl Paulsen wrote:
Restart the software or reboot the computer sometimes helps these
odd glitches.
You mean that you didn't try this before asking your question?!
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Pro
1101 - 1200 of 1406 matches
Mail list logo