.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
all Rosetta 2, which enables such
hardware to run applications built for Intel processors.
Brian Barker
--
This email has been checked for viruses by Avast antivirus software.
www.avast.com
-
To unsubscribe, e-mail: users-unsub
? Am I going to loose
some of my files and not be able to recover them?
thanks in advance for helping me.
Brian
Sent from Windows Mail every time
tion project. The ASF will very occasionally send out
messages relating to the Foundation to contributors and members, such as
this one.]
Brian Proffitt
VP, Marketing & Publicity
VP, Conferences
A few weeks ago I posted about my Open Office kept crashing when I tried
to do a search from the search box and you sent me the shortcut keys to
do a search but I seem to have misplaced the email. Could you please
sent it again.
Thanks.Brian Lake
erent from oo
What you "think" is not helpful to others. It takes only seconds to
confirm that OpenOffice does not have an IIF() spreadsheet function -
which you could have done.
Brian Barker
-
To unsubscribe
).
now if manually generate, say, random data in Calc, and try to chart
it... it works fine, any which way
Those are probably numbers.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@ope
helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
At 11:50 26/03/2023 +1000, Ponly Conly Sonly wrote:
Dear Brian,
You have initiated broader discussion, so I shall respond.
No: actually I didn't do that at all.
Your "Are you perhaps for some reason prejudiced
against OpenOffice?" sounds like an equivalent
of my father&
inst OpenOffice?
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
.13, as I read some people might have
issues on brand new updates I always wait a little until I update as well.
Time to update?
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache
and this would have selected all
the existing material before immediately replacing it with what you
continued to type.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For addi
there a problem with the new up grade ?
No - at least, not as simple a bug as your description would suggest!
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional
le and effective formatting device in
text documents even when the appearance of a
table (and therefore its borders) are not what is required.
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
, you can open documents of various
types - text, spreadsheet, presentation - within it. And, contrary to
what you say, you can transfer or link results from one type of
document to another.
If there is any difference in this matter between commercial and open
source software, it is surely the r
oid this by using Edit | Paste
Special.. (or Ctrl+Shift+V) instead of ordinary Paste and choosing
"Unformatted text" in the Paste Special dialogue. That way, the
pasted material inherits the language property of surrounding t
ct a
particular range of cells to print unless you meant that to happen
regardless of any defined Print Range.
So all you need to do is to remove the unwanted Print Range, by going
to Format | Print Ranges > | Remove.
I trust this helps.
Brian Barker
-
aks in the
spreadsheet text: these will become intercalated paragraph breaks in
the text document.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mai
percentage in one of two ways: either simply format your results
column C as Percent, or use
=(B3-F$1)/F$1*100 instead.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For addi
a date. In addition,
interpretation can change the format of a cell.
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
text. But there is a simple workaround if you now have
text values. Just change your formula to
=B4-VALUE(A4)
The VALUE() function will force the program to reinterpret the text
value to an actual date value before performing the subtraction.
I trust this
nOffice takes care of sorting the pages of the
document so that they print in such a way that the stack of sheets
can be folded into a properly sequenced booklet.
I trust this helps.
Brian Barker
-
To unsubscribe, e-ma
Is there a way to recover unsaved files without having back up please.
Thanks Brian Hiller
quot;Unformatted text" in the Paste
Special dialogue. Your border will disappear.
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
hes user
profiles - is simply not the experience of millions of other users.
If it were, there would be countless complaints every time a new
version was released. You may want to investigate what is wrong with
your system or what you are doing wrong to cause this unusual problem.
Brian Bar
At 23:15 05/07/2022 +0100, David Deeks wrote:
Sorry Brian, I was just being courteous - I thought if I included
everyone with my follow-up query it would look like I was doubting
your expertise!
Oh, it's perfectly OK to doubt my expertise.
... everything now seems to be hunky dory.
At 17:26 04/07/2022 +0100, David Deeks wrote:
ATTN Brian Barker?
I trust others are permitted to offer assistance?
Here is where I have hit the problem. I am
attaching a copy of the full spreadsheet as it
usually is, sorted on columns A,I,B ...
and the same spreadsheet but with column I
Brian if I remember correctly!
Could that be me?!
But I have now had the problem occur again with the cell formatting
appearing to be consistent. I am attaching a copy of a spreadsheet
with data sorted by column I. The cells in this column all identify
their category/format as 'Text/@&#
enOffice on the main
Microsoft Office site?
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
l to place the pay rate in a cell of
its own and then refer to that in your formulae. That way, any change
of pay rate (I'm guessing you may hope for those?) will require
changing one cell instead of wholesale reconstruction of formulae.
I trust this helps
the three numerical strings, still as text
items. Then you can concatenate these and convert them to a number
using the VALUE() function. Again, apply your desired format.
I trust this helps.
Brian Barker
-
To unsubsc
e the punctuation appear as if by magic. A suitable cell
format does that - and entering data that way is less prone to error
in the formatting. Isn't that what cell formatting is all about?
As Brian stated, Entering the way you want are not numeric values, but text.
An alternative way that cr
pping zeroes will never be needed.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
leading zeroes in any of
the three groups - which can certainly occur in the final group.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h
self the significance of someone else having
exactly twice your phone number - or of your number being even and
your friend's odd. You can set alignment independently of this anyway.
If you really wanted those peculiar asterisks, you would have to
esca
u probably seek already
exists, in the form of the Format Paintbrush in the Standard toolbar.
You can easily use this to copy cell formatting (including font
colour) from one cell to others. Any unwanted format properties
carried over could then be reset, of course.
I trust this helps.
Br
e material.
This technique will preserve relationships defined by formulae in
your spreadsheet elsewhere than for your problem range.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.
ember that OpenOffice is a collaborative project, so you
might be invited to do some of the work yourself.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional com
pside down.
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.
(Oh, and it is "sought" that you mean, not "sort".)
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
Tools | AutoCorrect Options... | Options
- in particular, from "Apply numbering - symbol: *".
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
r profile is powering off the computer
before it has completed properly shutting down.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
ar,
those tomatoes I bought yesterday - oh, and my document files.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
similarly not
reproducible. It would be useful to see a sample document showing the
problems. And she needs to enable the thesaurus, or perhaps to
recognise that misspelled or (in particular) long words may have no
synonyms in the thesaurus.
Again, if you are seeing problems after
to
explain why it doesn't occur for me and for
millions of other users. There must be something
wrong with how you upgrade. I'm guessing, but is
the problem that you have the Quickstarter
running whilst you attempt t
cell
formats (which is what he *should* have been doing). That could
happen only if the original entry had been as text into such a
foolishly-formatted cell. Occam's razor tells us not to assume two
such mistakes!
Brian Barker
---
click | Format Cells...) and set the format to
DD/MM/ (or MM/DD/) instead - which is more easily selected as
one of the sample Date formats, exemplified as 31/12/1999 (or 12/31/1999).
I trust this helps.
Brian Barker
--
At 22:55 28/06/2021 +0100, David Deeks wrote:
Thanks very much for your explanation re the Text to Columns facility Brian.
No probs!
To answer your question
For many years I have done reviews for a music
magazine and the values are quality ratings (1-5
"stars") for vinyl recor
At 15:35 28/06/2021 +0100, David Deeks wrote:
Thanks for this Brian - feeling suitably
admonished here for not being specific enough
particularly as I spent my working life designing computer business systems!
Oh, I was not trying to be critical.
I don't require them to be numbers p
At 11:30 28/06/2021 +0100, David Deeks wrote:
Thanks very much Brian - almost completely sorted!
I have a few exceptions where the contents of the field are not
simple numbers. They indicate a small range thus e.g. 2-3, 3-4, or
an either/or thus e.g. 2/3, 3/4.
In both cases they show the
At 17:22 27/06/2021 -0700, Chuck Spalding wrote:
On Sun, Jun 27, 2021 at 3:46 PM Brian Barker wrote:
At 22:49 27/06/2021 +0100, David Deeks wrote:
I have discovered that I have some part-columns of figures in Calc
that do not sort properly, and have identified that, unlike other
numbers in
ions as default.
o OK.
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
have been 64-bit since version 4.1.0 -
which was released more than seven years ago. And the current version
is 4.1.10, not 4.1.8.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For addit
e Big Sur 11.4"? Isn't it
likely that the questioner just hasn't dealt with Gatekeeper?
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional comma
to bring up the
Clipboard window, showing the items available.
Or you could volunteer to add this facility to OpenOffice.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additio
culty with installing and using a new version,
solve that problem separately or seek help to do so.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mai
sed some of OpenOffice's advantages!
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
At 13:09 03/05/2021 +0100, Brian Barnard wrote:
Subject: Excel equivalent
It is a mistake to think that any software product is the equivalent
of any other. OpenOffice's spreadsheet function ("Calc") is not
offered as an equivalent of Microsoft Excel. It would be equall
In your spreadsheet handler I recently tried to edit a column of literals
(all numeric) but your find and replace would not replace the
characters that I entered with the new ones. In the same column were
alphabetic literals and I could replace these with no problem. As a result
of this I have ha
want the
same settings, so doesn't ask. When you use File | Save As..., you
need to tick "Edit filter settings" at the foot of the Save As
dialogue to stimulate the dialogue you need.
I trust this helps.
Brian Barker
--
wn menu, select Microsoft Access.
o Next >>.
o In Step 2, browse to and open the connection.
o Save your *new* database.
o See the original tables now accessible in your new database.
I trust this helps.
Brian Barker
---
as text" is ticked.
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
fully" interpreting your input!
How do we stop it from doing this?
Simple: go to Tools | Options... | OpenOffice Writer | Table | Input
in tables, and remove the tick from "Number recognition".
I trust this helps.
Brian Barker
---
this helps.
Brian Barker - privately
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
see
https://cwiki.apache.org/confluence/display/OOOUSERS/AOO+4.1.9+Release+Notes .
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
not be in work mode, but Access is
Microsoft's name for its database program. OpenOffice's component is
called Base!
I retried three times, ...
Just give the right answer.
Brian Barker
-
To
e settings on your system to modify this behaviour.
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
this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
w one, strongly
suggesting that the newer version is not to blame.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
t;soft returns" does not clarify
where paragraphs begin and end. Surely it is more
helpful to use self-explanatory language? Why
should anyone recommend OpenOffice users to use
unhelpful terms apparently promulgated by Microsoft?
Brian Barker
-
to all paragraphs (possibly
only partially) included in the selection. Don't select anything:
just put the cursor somewhere in the required paragraph.
Understanding that will help you see what is happening.
Brian Barker
---
ining ink.
There is at least one other, far more complicated possibility,
involving your OpenOffice text not being black (perhaps white) but
appearing legible in the editing screen because of high contrast or
similar settings in Windows. But you'd probably know if you had arranged that.
I tr
e document.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
r changes
and wish to abandon them and return to your previous version.
(And neither of these are a replacement for a proper back-up regime,
of course.)
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.ap
French.
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
e given it none.
Pls tell what can I do to solve this.
Just choose a different name for your function, one not already in use.
PS: the answer to your second question is very much the same.
I trust this helps.
Brian Barker
--
"\t" (no quotes) in "Search for" and "\n" (no quotes) in
"Replace with".
o Click More Options and ensure "Regular expressions" is ticked.
o Replace All.
o Select the entire table.
o Copy and paste into your spreadsheet.
I trust this helps.
Brian B
e to be aware of the possibility
of using Edit | Paste Special... (or Ctrl+Shift+V) instead of
ordinary Paste and selecting "Unformatted text" in the Paste Special dialogue.
I trust this helps.
Brian Barker
-
o Copy and paste into the spreadsheet.
I'm guessing that by "soft return" you mean that you want the
original address lines to remain as separate lines within the
spreadsheet cell containing that address. You can insert such line
breaks using Ctrl+Enter in the spreadsheet cell.
At 11:00 13/10/2020 -0400, Dan Lewis wrote:
On 10/13/20 08:31, Brian Barker wrote:
At 08:10 13/10/2020 -0400, Dan Lewis wrote:
On 10/12/20 21:33, Paul R. Morin wrote:
When do you plan to or do you plan to have the spell checker work
on Open Office 4.[1.7]? Open Office is a great app but the
oblem be corrected?
Er, what problem, please? Spelling checking works for me and for
millions of others. Why not for you?
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional comman
al version of Microsoft
Office - using the correct procedure, of course. This would not
prevent his choosing to purchase a licence for and installing
Microsoft Office if he ever wished to do so.
I trust this helps.
Brian Barker
At 17:40 18/08/2020 -0400, David Stuhr wrote:
Hello Brian,
I had time today to copy the Basic macro code in the link provided
today into a test spreadsheet. I pasted the code between "Sub Main"
and "End Sub". I then saved the macro. When I attempted to compile
the macro
hancements at the same place as you report
bugs: https://bz.apache.org/ooo/ . See also
https://wiki.openoffice.org/wiki/QA/HowToFileIssue .
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For
-and-links-from-a-hyperlink-in-openoffice
- which includes a function CELL_URL() which appears to provide what you need.
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For
ntally button in the Formatting
toolbar (or press Ctrl+E).
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
be bothered to discover the reason for frequent crashes, they
need to do so explicitly. They'd be better off solving the problem, of course.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For add
helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
crashes or power outages. In these circumstances an offer is made,
when OpenOffice is next started, to recover editing changes made in
the aborted session as far as possible.
Brian Barker
-
To unsubscribe, e-mail: users
To do it now:
o Go to Tools | Options... | OpenOffice Base | Databases.
o Click New... and browse to your database.
o Give your database a registered name.
Now it should appear under Database in the Labels dialogue.
I trust this help
know that
Ctrl+PageDown moves to the next sheet (and so on) - and Ctrl+PageUp
the other way. If your version of Linux interferes with this, you may
be able to set alternative keyboard shortcuts.
I trust this helps.
Brian B
sing Paste Special (or Ctrl+Shift+V) instead of ordinary paste.
o In the Paste Special dialogue, untick Paste All if necessary and
ensure that only Formats is selected.
I trust this helps.
Brian Barker
-
To unsubscribe, e-m
that formula down the new column.
o If desired, select the new column, copy (or cut) it, and paste it
back over the original data - but using Paste Special... (or
Ctrl+Shift+V) instead of normal Paste and ensuring that Formulae is
no
PDF virtual printer installed on your
Windows system. That's wise, since creating a PDF version of your
document via the Print dialogue and a virtual printer provides
facilities not available via the built-in Export as PDF..., such as
OpenOffice's "Brochure" op
OpenOffice.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
jority of users (such as the original questioner, who uses
Windows 10) won't necessarily see this.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
rt of OpenOffice
and you cannot assume others will have it.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
uot;Search term" box.
o Click Find.
If your JRE is working, you will see some results - or possibly a "No
topics found" message.
If a JRE is not selected, you will see an "Enable JRE" error message.
(You can toggle it on the
e built-in help text and the documentation available at the web
site. For the latter, start at
https://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/OOo3.3_User_Guide_Chapters
.
I trust this helps.
Brian Barker
-
To u
ongside (or instead of) My
Templates. (That's no hardship!) Just go to Commands | New, which
will create a new folder called Untitled (or similar) and then
overtype the (already selected) name to change it to whatever you want.
I trust this help
1 - 100 of 792 matches
Mail list logo
