at the time.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
back to the original cell.
o Momentarily release the mouse before dragging the cell as required.
Or:
o Click the cell.
o Shift+click the cell.
o Drag the cell as required.
I trust this helps.
Brian Barker
-
To unsubscribe, e
.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
document text into a new ordinary document. The material appears as
sections, but it again easy to remove these (to merge the material,
that is, not to delete it) either in the master document or later in
the ordinary one.
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
.) Yes: you can copy and paste a formula into
multiple cells at once or you can fill it down a column or
whatever. See any beginner's guide to spreadsheets or Chapter 2 of
the Calc Guide.
I trust this helps.
Brian Barker
the row height as well as the page margins, you will be
able to match your label format. Make test prints on plain paper and
hold up to the light with your label stock to check registration as
you make adjustments.
I trust this helps.
Brian Barker
attached show a small red square - the
comment indicator - at the top right of the cell.
o Go to View | Navigator or press F5.
o Expand Comments.
o Double-click the individual comments to select the host cells.
I trust this helps.
Brian Barker
see, yes: they are generally called Comments but
occasionally (confusingly?) referred to as Notes.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e
, or ranges that contain
your data to be copied, everything should work. If necessary, import
your new data into a separate sheet and then select the significant
range to copy to your required destination.
I trust this helps.
Brian Barker
a styles list.
Your point is that - very sensibly - you eschew the use of those
buttons precisely because they do not relate to styles but create
local formatting; instead you use styles for these purposes.
Brian Barker
subject header suggests: you are handling a spreadsheet
document in the Calc component of Apache OpenOffice.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional
At 08:35 30/05/2015 +0100, Rory O'Farrell wrote:
On Thu, 16 Jul 2015 04:25:50 -0500 Al Noni wrote:
I am using Apache office ...
Interestingly, this message wasn't sent from the future (as is
claimed here) but on 24 March (and received answers then).
Brian Barker
of Tools | Options is
OpenOffice | Preferences.
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
want to experiment with saving the document as
HTML or exporting it as PDF. If you open these in your favourite
browser or PDF viewer, you may have the facility to copy all the text
and paste it back into a text (Writer) document.
I trust this helps.
Brian Barker
shortcut for this function:
o Ctrl+V: ordinary Paste
o Ctrl+Shift+V: Paste Special (brings up the dialogue including
Unformatted text)
o Ctrl+Alt+Shift+V: Paste Unformatted Text
(Thank you for the pointer to this, which I had not been aware of and
will find useful!)
I trust this helps.
Brian
is of the Visible Buttons drop-down for the Formatting
toolbar. The Paste button is instead in the Standard toolbar (and you
should find it appears by default and does not need to be selected).
I trust this helps.
Brian Barker
Text Area Only, and Double-click to
edit Text. You may want to see if these can help.
Is there any illumination anywhere in the tutorials?
There is quite a bit about this buried in Chapter 3 of the Impress Guide.
I trust this helps.
Brian Barker
the
other sheets that you need to print. Do this for each sheet by
selecting its relevant parts and then going to Format | Print Ranges | Add.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr
character formatting. Go to
Format | Character... | Font Effects, and tick Hidden.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h
modification,
either with or without a password.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
that they are replaced by genuinely empty
ones), won't the problem go away?
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h
At 15:31 23/07/2015 -0600, Larry Gusaas wrote:
On 2015-07-23, 3:16 PM James Knott wrote:
On 07/23/2015 01:23 PM, Brian Barker wrote:
But surely this is unnecessarily complicated advice? Read the
Apple support article at http://support.apple.com/kb/HT5290 for
details. There is no point
it from
Gatekeeper.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
indows hides extension to file names, so you won't see
what is happening. To use the second technique above, you would need
(at least temporarily) to turn on the display of extensions in Windows.
I trust this helps.
Brian Barker
---
d may well be
considered malware. Instead, just be patient and note the legend at
the top of the page that reads "Your download will start shortly...".
After a few seconds, it will.
Brian Barker
-
To unsubscribe, e-
ice, using the existing downloaded file.
o Re-enable your anti-virus software.
o (Only then) reconnect your system to the network.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.
("Keyview for Lotus"),
from which you may be able to copy and paste the view into OpenOffice. See:
ftp://ftp.lotus.com/pub/lotusweb/product/smartsuite/Kvlotus.exe
or
http://keyview-for-lotus.software.informer.com/download/
I trust this helps.
Br
will want to
investigate the use and effects of styles.
Another possibility is that the last paragraph of
the existing material on the rogue page has a page break after.
I trust this helps.
Brian Barker
-
To unsubscribe, e
t one, then I don't understand it. Do you
perhaps here mean the sum of values but in the first question you
meant the count of the values? In that case, the solutions are
similar; the equivalent to the COUNT() function that omits values in
hidden rows is SUBTOTAL(2;...).
I t
greying out of the
menu item: instead, using it invokes an error message.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
set an
alternative template, go to File | Templates | Organise... . Click
Commands; if you see Reset Default Template , click it and select
Spreadsheet. In a new document, does that make a difference?
I trust this helps.
Brian Barker
page is numbered "3", the third page "5", and so on? There are ways to do that.
The information I am trying to print in this manner comes as an
attachment of an e-mail.
I don't see that the source
At 11:19 08/12/2015 -0700, Jonly Donly wrote:
Microsoft is the distributor of Office 360.
Are you (and is a previous contributor) thinking of Office 365?
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr
8.
How do I find my version of windows and how can i install the update?
You may have downloaded a 64 bit for a 32 bit machine.
Surely there is no 64-bit version for Windows?
Brian Barker
-
To unsubscribe, e-mail: users
l prevent existing
corruption creating new problems.
o Institute a proper regime of making regular, frequent back-up
copies of all your work on a separate, external device.
o Meanwhile, start re-sourcing or re-creating your document.
Sorry this is not more helpful.
I t
Formatting window.
o Double-click the new page style to apply it to appropriate pages.
o Save the document.
But are you sure you cannot teach your new printer to accept the old
arrangement?
I trust this helps.
Br
uot; entries [10:18:31 15 Feb 2015 GMT+00].
2 "Virus" entries [02:31:07 17 Oct 2014 GMT+00].
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
sticks, so if you selected it but then didn't cancel
it after you finished your search, it will have remained ticked.
Remove the tick and you should be able to Replace All again.
I trust this helps.
Brian Barker
-
To unsu
it working for
times when I have to replace a lot of the same thing.
Have tried to click on "Find All" first. "Replace All" is only
selectable if it has found multiple instances found.
Sorry, but that'
ided
printer, you can suppress this by removing the tick at Tools |
Options... | OpenOffice Writer | Print | Other | Print automatically
inserted blank pages. You will discover this when you create test
prints on waste paper before actually printing on your label stock.
I trust this helps.
le. Remember that, when you are creating a table and
get to the Insert Table dialogue at Table | Insert > | Table..., you
can more simply remove the tick from Border under Options there.
I trust this helps.
Brian Barker
-
ells - or suitable merged cells. You can also enter a header at
Format | Page... | Header | Edit... and similarly for a footer. I
don't see why any of these should move around.
I trust this helps.
Brian Barker - privately
At 06:47 12/01/2016 -0500, Linda Hull wrote:
You have always come through with beautiful simple answers that take
the kinks out of doing things.
How kind!
Thanks so MUCH!
No probs!
Brian Barker
-
To unsubscribe, e-mail
o and fix this problem.
No problem: someone shouldn't.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
on the column of random numbers.
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
;cell content" and the explanation there of "Search in"
and "Formulae", what went wrong? Oh, or "Finding and replacing
formulas or values" in Chapter 2 of the Calc Guide?
I trust this helps.
Brian Barker
-
T
see
the problem experienced by Linux users. Mind you, the solution is obvious ...
;^)
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h
, scroll, edit the
documents, and so on independently and simultaneously. That's just
like the separate windows you would see from separate instances of the program.
What else are you expecting?
Brian Barker
ust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
.
o If desired, use Show Comment from the context menu in the cell
again to toggle off the display of the comment.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
unless it is also included in a
print range.
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
ect the style and click OK.
o Double-click the text and replace it with your own text.
o Press Esc to exit text edit mode.
o Adjust the text shape using the Fontwork Shape button in the
Fontwork toolbar (which appears automatically).
o Etc.
I trust this helps.
Brian Bar
At 13:53 30/05/2016 -0400, Julian Thomas wrote:
On May 30, 2016, at 06:43, Brian Barker wrote:
o Click on the Fontwork Gallery button in the toolbar.
That's in the bottom toolbar!
I indicated (but you've removed) that you need to toggle on the
Drawing toolbar, and yes: it appears
... . On the General tab, under Print, for Document
select Handouts and for "Slides per page" select 3.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional comman
At 21:03 16/01/2016 +1100, Richard Beeston wrote:
4 branches of House of windows and internet
Why lag behind with Windows 11 when you can have Windows 12:
http://tinyurl.com/zgo44e5 ?
;^)
Brian Barker
-
To unsubscribe
| Format
Cells... . On the Font Effects tab the font colour is identified by
name and on the Background tab the background colour is highlighted
with a border in the colour palette and named below it.
I trust this helps.
Brian Barker
save the documents (even under the same name) with the
option ticked. The rogue copies can then be deleted, of course.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
you establishing this today!
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
- better still - the Paragraph Style formatting dialogue.
(You will want to learn about and use styles in order to use
OpenOffice effectively.)
In fact, you can make this change by searching for $ and replacing
with \n\n - but please don't ever do this!
I trust this helps.
Brian Barker
-
sary sheet
reference, so will not do what you need.
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
users.
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
works.
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
of the whole shape. How could
anything leave this plane - unless you have a special pen which will
somehow write in the air above your sheet of paper, or a computer
which can write in the air in front of the display?
Any pointers please?
Perhaps define your problem more clearly?
I t
At 12:58 29/02/2016 +1300, David Rivers wrote:
Brian Barker wrote:
At 19:19 27/02/2016 +1100, Keith Bainbridge wrote:
I'm trying to draw a diamond shape with 2 opposing angles equal,
one angle 72 degrees and its opposite 60 degrees.
By "diamond", I'm assuming that you mean
and choose "DDE
link". Your spreadsheet material will become a table in the text
document and it will be updated as you edit the source spreadsheet.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: user
makes sense that upgrading will not have
affected matters.
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
nuinely empty cells, just
ensure that "Allow blank cells" is ticked in the Validity dialogue.
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
my Source were not formatted as text beforehand.
My point was that you *should* do this if you want to avoid your
apostrophes being misinterpreted.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.
ffice" and "Differences in Use between Writer and Word".
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
uot;try" this? If you had genuinely rotated a graphic, the
result would surely have been different. How are you viewing the
rotated photo - again in your camera or its software?
There should be a better way!
See above.
I t
ragraph style to your headings. When you decide to underline your
headings, modify the style and bingo: all the headings are underlined
(or whatever) at a stroke. This is also more reliable: you are less
likely to miss a heading. Time spent learning about styles is quickly
repaid in the facilitie
("T") in the Drawing toolbar and drag the
(modified) cursor to create the box.
o Enter the text.
You can drag to resize or reposition the text box and can adjust the
formatting of the text in the usual way.
I trust this helps.
first row
or drag down relevant cells in any column. The appropriate rows will
be repeated in all columns.
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
t containing
(parts of?) a Microsoft Excel document file. The user clearly has a
corrupted file, with his or her operating system falsely seeing an
unused area of disk included in the file.
Brian Barker
-
To unsubscribe, e-
At 17:56 03/03/2016 +1100, Keith Bainbridge wrote (privately):
On 28 February 2016 at 16:48, Brian Barker wrote:
At 19:19 27/02/2016 +1100, Keith Bainbridge wrote:
I'm trying to draw a diamond shape with 2 opposing angles equal,
one angle 72 degrees and its opposite 60 degrees. I figured I
e! Unless you were silly enough to
tick "Current document only" (when this is clearly not what was
wanted), Tools | Options... | OpenOffice Writer | Basic Fonts
(Western) | Default sets the default for this and future docume
t;Number of pages" select the required number.
The easiest way is to save the file as an Excel-file, put in into an
Office Excel program ...
If you prefer to use Microsoft Excel, you are very welcome to do so,
of course. Alternatively, you could learn to use OpenOffice.
I t
In either case, the "Copy table" panel appears. Select the required options.
o Repeat as necessary for other data blocks, creating other tables.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: user
ttings and software versions that - despite my confident belief - I
do not guarantee what I've suggested.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional comman
e was so easy. This program fights everything
I try to do.
1. If Microsoft Office was easy, that may have been because you spent
some time learning it. OpenOffice deserves the same courtesy and will repay it.
2. It's good that everyone has a choice of software.
I trust this helps.
At 06:57 20/05/2016 -0700, Ron Patterson wrote:
On 5/20/2016 12:00 AM, Brian Barker wrote:
At 22:26 19/05/2016 -0700, Ron Patterson wrote:
I have a column in my spread sheet ...
May I respectfully suggest that your problem may be that this is
not your spreadsheet but someone else's
rue and 0 otherwise. Summing those 1s effectively counts them and
gives you the result you need.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional comman
.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
he Subject header). As I mentioned before,
this is not only discourteous to others but is also unhelpful to you:
your message will be buried in the existing thread and may well not
be seen by anyone not interested in the earlier topic.
I trust this helps.
Br
At 10:23 04/05/2016 -0700, Girvin R. Herr wrote:
On 05/03/2016 08:53 PM, Brian Barker wrote:
At 21:42 03/05/2016 -0400, John Caruso wrote:
I have given up on OO because I could not get grid lines in Calc
4.1.2, I found an old copy of office10 and installed it and now I
get grid lines in Excel
want to
use the web site contact as suggested: communityt...@sourceforge.net .
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
... .
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
.
The discussion of the function of spreadsheet grid lines and how and
when they are printed or not will surely have been of interest to
other subscribers. The thread continued helpfully in that way: I was
reminded of something I hadn't found and I imagine others may have been, too.
Brian Barker
lphabetically: you can leave it unsorted and tick the "Sort entries
ascending" box on the Criteria tab in the Validity dialogue.
o In any case, there would be nothing to stop you sorting this list
separately if you wished - without sorting any rows or surro
At 22:38 31/07/2016 -0400, Doug McGarrett wrote:
On 07/31/2016 06:23 PM, Brian Barker wrote:
At 07:36 01/08/2016 +1000, Richard Beeston wrote:
I need to write a thesis and the requirement is to have double
line spacing ...
Second, you should let your institution know that the world
data from the new sheet 3.
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
ccurrences of the words that you probably need to
retain spelled out.
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
, not "at the time".
You should find it under tools.
Er, he won't, you know! You are now also telling him to look in the
wrong place.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For
documents - exported to PDF.
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
aragraphs that require different line spacing.
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 20:54 31/07/2016 -0400, Brian Meadows wrote:
On Mon, 01 Aug 2016 00:45:46 +0100, Brian Barker wrote:
Are you sure that your book publisher will want to print hearts and
diamonds symbols in red in otherwise black text in your book?
Absolutely certain. It's the third volume of three
At 10:48 01/08/2016 -0400, Jeffrey Deutsch wrote:
And only switched over to Word -- that is, to OpenOffice ...
I think both Microsoft and Apache would be interested to read that
you found Word in OpenOffice. Did you also find Writer in Microsoft Office?
;^)
Brian Barker
why this is necessary: a little experimentation confirms
my impression that simply copying and pasting material from one
document to another automatically carries with it necessary styles.
Brian Barker
-
To unsubscribe, e
: OpenOffice does not include a mail client!
I also work with a financial company. You should check us out ...
With this level of misunderstanding on the part of its staff, would
this be wise?
Brian Barker
-
To unsubscribe
201 - 300 of 656 matches
Mail list logo