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, e-m
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...@openoffice.apache.org
For additional commands, e-mail
this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
o 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 rele
OpenOffice?
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
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.org
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 additiona
.
is 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
pearance 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
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 reverse of what you sugges
y 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 text.
I t
ge 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 th
ine breaks 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
f 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 additional commands, e-m
n 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
. 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 helps.
Brian Barker
are 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-mail: users-unsub
matted 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
s 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
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
OpenOffice 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
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.
Brian Barker
rical 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 unsubscribe, e-
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
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
ne 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
escape each of them with a backslash, a
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.
Brian Barker
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.
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 commands
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
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
wering 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
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
ducible. 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 upgrading, there is somet
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 to upgrade?
Brian Barker
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 Ba
rmat 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
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 Grenf
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
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
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 additional
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 commands, e-mai
o 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 additional c
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-mail: us
nOffice's advantages!
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
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 anyway.)
I trust this helps.
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
nu, 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
-
To
ext" 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
" 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
://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 unsubscribe, e-
tings 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
.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
, 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
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
---
ll 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
-
To unsu
remaining 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 trust this helps.
.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
don 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.apache.org
For additional comman
to be in 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
have 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.
Br
;\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 Barker
--
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
-
To unsubscribe, e-m
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. I don't k
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
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 commands, e
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
-
To unsubscrib
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 Pitonyak,
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
Horizontally 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
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 additional co
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
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 Barker
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-mail: users
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
not ticked in the P
a 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" option.
Br
of OpenOffice.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
y 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
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
le 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 unsubscribe, e-mail: users-unsubscr...@openoffi
ngside (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 helps.
Brian
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/outlook
-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
.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
ou 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 and select
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,
out what changes you keep, go to Edit
| Changes > | Accept or Reject... first, and deal with the changes
one by one. Then toggle recording off again at Edit | Changes > | Record.
I trust this helps.
Brian Barker
-
To un
Position the cursor in the cell immediately after the relevant text.
o Press the spacebar.
o Backspace over the space to delete it.
More generally:
o Select not the entire cell but the required text within that cell.
o Insert | Hyperlink.
o Etc.
I trust this helps.
Brian Barker
there a change in OpenOffice
that renders the above instructions invalid?
I think neither.
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
1 - 100 of 656 matches
Mail list logo
