formula
=SUMPRODUCT(MONTH(A1:A99)=8)
would also work.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
At 11:05 14/12/2012 -0500, James Knott wrote:
Brian Barker wrote:
Please help me. I often correspond in Czech language without
punctuations, using Open Office.
No: I didn't write that. Please take care when quoting. Thanks.
Brian Barker
that many (most? all?) touchpads can have
their sensitivity adjusted (via the Control Panel or
wherever). Turning down the sensitivity can solve this problem with
gentle, unintentional thumb dragging whilst retaining touchpad
functionality when you need it.
I trust this helps.
Brian Barker
that people brought up on
low-level approaches find it difficult to
transfer to higher-level ways of
thinking. Persevere, and you will like the ways of Writer!
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr
At 12:21 20/01/2013 -0500, Alan Boba wrote:
On Sun, Jan 20, 2013 at 11:53 AM, Brian Barker wrote:
At 11:10 20/01/2013 -0500, Helen Etters wrote:
On Sun, 20 Jan 2013 07:42:46 -0800 (PST), Eric Fenster wrote:
What chance Open Office will offer reveal codes à la Word Perfect?
This is the reason
is, to solve it where it was
caused. Anything else breaks the structure.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
or publisher what they need. The literary agent will likely be able
to advise you what a publisher would need.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional
copy the values in B
back over A (using Paste Special... to freeze the values), possibly
then deleting either column B or its contents.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr
-friendly?
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
At 00:28 22/02/2013 -0600, Jonly Bonly wrote:
On Fri, 22 Feb 2013 06:09:55 + Brian Barker wrote:
At 13:44 21/02/2013 -0600, Jonly Bonly wrote:
Because of the major foul-up of a couple of list members today by
sending out the complete addresses of everyone in the 'To' field, ...
Everyone
if they are influencing the
text. You could then solve the problem by modifying the style or styles.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e
..., browse to and
select your new template, and then use Commands | Set As Default Template.
The original default files could be stored separately in case you
want to go back.
They will be.
I trust this helps.
Brian Barker
as to where this formulas box may be?
No, only the same thought: it's exactly where I said! You are
looking in OpenOffice.org | View. You need to look (further down) in
OpenOffice.org Calc | View.
Brian Barker
-
To unsubscribe, e
of making this happen automatically for documents you
receive from others.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h
references to the relevant sheet from other sheets - so
you will need to check that.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h
highlighting all of the lines and deleting the
page break, but it doesn't work. Please help!
Check your Paragraph Style (F11) and see if the Insert box on the
Text flow tab is checked.
Are you perhaps thinking of a text (Writer) document - not the
questioner's spreadsheet?
Brian Barker
of the Status Bar (at the foot of the window) and select the
appropriate (named) bookmark from the context menu.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands
At 10:47 15/04/2013 -0700, Sam Warren wrote:
How can I format a book with the text only on the right hand pages?
Print single-sided.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr
it into the
required cells. He can copy and paste using the keyboard, of course
(Ctrl+C, Ctrl+V), and he can paste into multiple cells by selecting
the destination range first, using the arrow keys along with the Shift key.
I trust this helps.
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
At 16:01 21/06/2013 -0500, Dale Erwin wrote:
I don't think that n can be zero.
Oh, it can - as can x, y, z, or whatever! As is well known in
mathematics, a variable can take any value.
Brian Barker
-
To unsubscribe, e
-
what you need.
... and paragraph breaks with a space in front?
o As above but search for $ (no quotes) - that's space-dollar sign.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr
to run backward (from 1 to 0) you would
get Sigma 1 to 0 = 0 * 1 / 2 which evaluates to 0.
Depending on how you defined your function, you could choose to
include that as a permitted result. Apparently that's what the
questioner wants.
Brian Barker
this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
.
Meanwhile, those who have looked recently are doing it all the time!
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
At 06:17 23/06/2013 +0100, Rory O'Farrell wrote:
On Sun, 23 Jun 2013 05:08:25 +0100 Brian Barker wrote:
At 22:20 22/06/2013 -0400, Andrew Douglas Pitonyak wrote:
At 14:44 22/06/2013 -0400, Doug McGarrett wrote:
Now if OO and LO are so great, why can't they deal with curly
quotes
happened when you tested this yourself?
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
dream of using the product?
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
In the Paste Special dialogue, remove the tick from Paste all if
necessary and then ensure that Text, Numbers, or whatever are ticked
and that Formats is *not* ticked.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users
From: Timo Kivelä timo.kiv...@kolumbus.fi (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
.)
OpenOffice will rearrange the various
(double-sided) pages so that you can simply fold
the resulting stack of printed sheets into a brochure.
My thanks for an answer in Swedish if possibly
Sorry, but I do not write Swedish.
I trust this helps.
Brian Barker
access to a particular
PC in order to subscribe to a mailing list, of course. What is
necessary is to have access to the relevant e-mail account; any
someone making a malicious subscription may simply have obtained
access to the account password.
Brian Barker
it is located in the background! What now
?
In addition to using the Navigator (as has
already been explained), you can (at least
sometimes) select a background image using Ctrl+click instead of plain click.
I trust this helps.
Brian Barker
.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
/download/other-341.html .
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
At 10:11 24/09/2013 -0400, James Knott wrote:
Brian Barker wrote:
The legacy formats have never been the default format in any
version of OpenOffice.
Actually, he was quoting the 4.0 release notes.
What about the versions that predate ODF? What was their default
format? IIRC, full ODF
them.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
At 22:34 07/10/2013 +0700, Urmas Davian wrote:
1. Since when 2000 software is ancient?
Since about 2005?
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users
At 22:09 13/10/2013 +0200, Uwe Brauer wrote:
Brian == Brian Barker writes:
o Go to File | Templates | Organize..., open My Templates, and
select your new template.
o Click Commands | Set As Default Template, and Close.
When I click commands I do not see the option *save as default
template
to break line-moving. Using *linked* frames,
you can preserve the natural flow of text from frame to frame - and
from a frame on one page to a frame on another. See frames;linking
in the help text.
Brian Barker
of your second.
o Copy the new table and paste back into your text document, but
using Paste Special... | Formatted text [RTF].
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
be to
insert an extra column - perhaps temporarily - and to use ERRORTYPE()
to extract the number of any error. You could use Find Replace to
locate that.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr
, but how many paragraph styles are
you using? Perhaps at most one for the tables and another for the
separate text. You can change the font in those styles without
selecting anything.
I trust this helps.
Brian Barker
indenting on the Position tab of the Bullets and Numbering dialogue.
Arghhh!
I trust I've been able to remove a few consonants from your frustration.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr
portrait to landscape does OO
reformat for the setting?
No. (You may be guilty of Microsoft-Office-think.) But it does when
you change the page format at Format | Page... | Page | Orientation.
I trust this helps.
Brian Barker
would want to edit the spreadsheet and would then see any changes
appear automatically in your text document.
Horses for courses.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
or didn't get it when you did. In either case:
o Right-click in the table and go to Table... | Text Flow | Text
Flow. (Or use Table | Table Properties... .)
o Either remove the tick from Repeat heading (or add it) or adjust
the value for The first nn rows.
I trust this helps.
Brian Barker
The present hashtag problem ...
hashtag : n
... a word or phrase preceded by a hash mark,
used to denote the topic of a post
(Collins English Dictionary Complete and Unabridged)
Brian Barker
-
To unsubscribe, e-mail
done so, you will be able to select and sort the changed values.
I trust this helps.
Brian Barker
---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional
.
Brian Barker
---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
At 21:45 25/03/2014 +0100, Laurens Thissen wrote:
On [25 mrt.], at 17:24, Brian Barker wrote:
At 13:49 25/03/2014 +0100, Laurens Thissen wrote:
When I apply a filter in a Calc file, is it possible to see how
many records are filtered? I am unable to find an easy way to do
this in Calc
fairly easily. You may find it more productive
to set the tabs and fill characters in a
paragraph style instead of in direct paragraph formatting.
I trust this helps.
Brian Barker
---
List Conduct Guidelines: http://openoffice.apache.org/list
At the top right, select OpenOffice or Writer (or whatever).
o Under Functions | Category, select Insert.
o Under Function, select From File.
o Under Shortcut keys, choose your preferred shortcut.
o Click Modify and OK.
I trust this helps.
Brian Barker
---
List
At 20:51 16/04/2014 -0400, Julian Thomas wrote:
On 16 Apr 2014, at 19:51, Brian Barker wrote:
In any case, you can set your own keyboard shortcut.
o Go to Tools | Customize... | Keyboard (or wherever that is on a Mac).
o At the top right, select OpenOffice or Writer (or whatever).
o Under
with a paragraph
break; I don't see any way to avoid this. So in general you will
still need to type Backspace or to reposition the cursor
(left-arrow?) after inserting your character.
I trust this helps.
Brian Barker
---
List Conduct Guidelines: http
: no-one can explain what this does - not the help
text or even the manual.
I trust this helps.
Brian Barker
---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
that in the area of
styles it does.)
I trust this helps.
Brian Barker
---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h
do so. In
that case you may like to know that I notice you *can* sort on cell
colour in Excel (at least, you can in Excel 2010).
I trust this helps.
Brian Barker
---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe
or else the default for new documents: as you
would hope, it does not change existing documents.
I trust this helps.
Brian Barker
---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr
feature to drag and drop it to the toolbars...
Sorry: no drag and drop.
I trust this helps.
Brian Barker
---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
formatting, as a character style, or as a paragraph style. In each
case, these are available on the Font Effects tab of the respective dialogue.
I trust this helps.
Brian Barker
---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
search for tabs using \t - and so on.
I trust this helps.
Brian Barker
---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h
tab, choose Normal for Position.
I trust this helps.
Brian Barker
---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h
/template/featherlope-size-10
http://templates.openoffice.org/en/template/size-10-christmas-envelope-v2010a
Or you could just make your own and save it in My Templates.
I trust this helps.
Brian Barker
---
List Conduct Guidelines: http
on all this,
and others may be able to improve on my scheme or description.
I trust this helps.
Brian Barker
---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
about styles will
tell you how flexible they are.
Brian Barker
---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h
of
OpenOffice. What I think is unfortunate is that you should
misrepresent its powers to an audience (of perhaps thousands?) who
may be prepared to like it.
Brian Barker
---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
| Cell Contents | Recalculate (or pressing F9).
I trust this helps.
Brian Barker
---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail
processor as if it were
a typewriter. Their satisfaction should not be allowed to limit the
advancement of software and facilities that can be appreciated by others.
Brian Barker
---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
the
installation again.
I trust this helps.
Brian Barker
---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h
on its behalf.
Brian Barker
---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
affecting
other cells in any way.
I trust this helps.
Brian Barker
---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h
) into the lower window.
I trust this helps.
Brian Barker
---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h
the tick from Tools | AutoCorrect Options... | Options | Apply
numbering - symbol: *.
I trust this helps.
Brian Barker
---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
is not clear to me. Do you speak about a document which
is stored somewhere on our sites?
Surely the questioner means
https://wiki.openoffice.org/w/images/b/b6/Cover_lettertammieelgammal.odt ?
Brian Barker
---
List Conduct Guidelines: http
, the sensitive data was
visible in the document.
Brian Barker
---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h
the drop-down list.
o (Here's the important bit:) Set Page number to whatever you need
- 21 in your case.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e
cells.
o Use a text (Writer) document instead. A table may be useful.
o Use a spreadsheet but transfer the material to a text document for
final formatting.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users
of) the calculation facilities.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
be seeking a solution
to a similar problem; they too, of course, may equally be helped by
such advice.
But you are completely right about the need for respect and decorum.
Brian Barker
-
To unsubscribe, e-mail: users
are quite right about not being snide.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
At 16:47 18/06/2014 +0930, Tony Gallas wrote:
On 18/06/2014 3:34 PM, Brian Barker wrote:
At 11:24 18/06/2014 +0800, Hung Mark wrote:
I'm making a name label which I will finally cut the paper into
pieces and fold each piece of it in the middle into a reverse V
shape. I want to create text
unimpeachable, is surely of no help? I don't see any way to rotate a
frame (which can accept fields) in a text document; what am I
missing, please? You can create a text box or paste in one created in
Draw and you can rotate this, but then I find (as he suggests) that
you cannot insert the fields.
Brian
| General | Input settings.
o Against Press Enter to move selection (which should be ticked),
select Right instead of Down from the drop-down menu on the right.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users
, unfortunately not.
You could complain to the suppliers of the other program.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h
happens if you select the sheet and change the font? Or change
the font size to something smaller?
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e
or
wherever - before you attempt to work on it. Your correspondent may
have the same difficulty.
I had a look on the help but I don't find a solution.
There will be no help for the latter suggestion, as it has nothing to
do with OpenOffice.
I trust this helps.
Brian Barker
?
Yes. Go to Tools | AutoCorrect Options... | Options and remove the
tick from Apply numbering - symbol: *.
Alternatively, you could change your first initial so that it is no
longer a roman numeral!
I trust this helps.
Brian Barker
.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
At 16:30 03/07/2014 -0400, Julian Thomas wrote:
On 3 Jul 2014, at 13:57, Brian Barker wrote:
All you have to do is to create a header (or footer) in your page
style and then to insert all the frames into the header. Note that
all this does is to anchor the frames in the header: they can still
.
I was readily able to enter multiple labels on a single label sheet
with both Word and WordPerfect.
And now - I hope - with OpenOffice.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr
the original text.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
At 15:39 20/07/2014 -0400, Doug McGarrett wrote:
On 07/20/2014 02:34 PM, Brian Barker wrote:
Th[e]n you have been conned!
No, I haven't.
My comment was based only on what you *wrote*, of course, which was
The sort of thing you [sc. Mr Lambert] complain of is the reason
many of us have
. I Searched HP's web [s]ite and got a NOT
FOUND message. Are you sure that you typed the model number without an error.
See:
http://h10025.www1.hp.com/ewfrf/wc/product?product=3390947lc=encc=usdlc=enlang=encc=us
.
Brian Barker
automatically inserted - unless you choose to
prevent this. Have you perhaps set the entire spreadsheet to be
printed on one page? If so,
o Go to Format | Page... | Sheet | Scale.
o For Scaling mode, select Reduce/enlarge printout and for
Scaling factor 100%.
I trust this helps.
Brian Barker
trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
of the picture to enlarge it, but the resolution
will degrade as you do so. If what you end up with is unsuitable for
the use to which you wish to put it, you will need to source a higher
resolution graphic in the first place.
I trust this helps.
Brian Barker
At 10:14 30/07/2014 -0400, Doug McGarrett wrote:
I'd like to read the review, but nothing in this post leads me to it.
I think those four short lines you saw - full of error - *are* the review!
Brian Barker
.
o Under Commands, select From File.
o Click Add and Close.
o Use the arrow buttons to move the button around in the Standard
toolbar as preferred.
o Click OK.
... nor can I get the Pictures toolbar to open at all.
Go to View | Toolbars | Picture.
I trust this helps.
Brian Barker
the local character property.
Remember that you may prefer to do this through character styles or
paragraph styles.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
1 - 100 of 656 matches
Mail list logo