.
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
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
ke clear
in private correspondence. For me to point out
that, in respect of the original user's problem
at least, OpenOffice happens not to be "limited"
can in no way be characterised as tribalism.
Please take care that you understand the relevant
attitudes before making
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
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
are reinterpreted, just as they
would be if the data was entered afresh. So a text value "1000" is
treated as if you had typed 1000, in other words as the number one
thousand, not the four text characters.
Brian Barker
-
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
also some strange effects caused by cell protection
which may be causing confusion.
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
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
have been
placed elsewhere, perhaps even on another sheet.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
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
--
's not my experience or, I imagine, anyone
else's. I don't know exactly what you can be
doing to cause this. Oh, you are not saving your
document in the foreign Microsoft .xls format,
are you? I'm not sure that would be the culprit,
but it can cause problems. As Joyce
dates. You may have to handle some of
this manually. But I still don't know why you
want your text values converted to numbers, as
you cannot sensibly sort "2-3" within numbers.
Where exactly do you expect it to appear?
I trust this helps.
Brian Barker
umbers, you can sort them
all as text. That means that "2.1" sorts between "2-3" and "2/3" -
oh, and "3" sorts after "20" and "200", because "3" sorts after "2".
Is that what you want?
What do you consider "c
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
ult of your failure
to solve your problem in OpenOffice. And if you are happy using
Microsoft Office, I'm not sure what help you are requesting from the
OpenOffice Users list. (And you don't have to remove OpenOffice in
order to install and use Microsoft Office
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
I got the following error.
BASIC syntax error.
Function not allowed within a procedure.
What am I doing wrong?
I'm guessing you should delete the two lines you quote above. But I'm
no expert - and others, including Mr
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
At 21:49 08/05/2020 +0200, Hagar Delest wrote:
Le 07/05/2020 à 23:43, Brian Barker a écrit :
At 22:21 07/05/2020 +0200, Hagar Delest wrote:
What's this kind of mail address that is invalid???
OP is outlook_c9a92ba9c18dd...@outlook.com
See
https://support.microsoft.com/en-ie/office/ou
tlook-for-windows-90ed7938-7f21-4cb5-a69d-a3b79ea4eafd
.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
e you want it to appear,
+ Drag the button to the appropriate position,
+ Or click the "-" and "+" buttons as desired to increase or
decrease the zoom factor.
o Right-click the "Zoom percent" display in the corner
want filled - including your original
cell. Go to Edit | Fill > | Down.
o For more complex requirements, select the entire range and use Edit
| Fill > | Series... .
I trust this helps.
Brian Barker
-
To unsubscribe,
1 - 100 of 755 matches
Mail list logo