To the list: Did anyone else get a receipt request from this post? Can
the list server be configured to suppress/cancel receipt requests?
To as2799269: PLEASE, PLEASE DO !NOT! send a message to a list server
with a receipt request, !EVER!.
On 05/27/2010 12:51 PM, as2799...@sapo.pt wrote:
Johnny Rosenberg wrote:
Well, everybody here seems to talk a lot about the importance of following
the international standards, such as the IEC/ISO 26300:2006, but how many of
you type date and time the ISO 8601 way (that is -MM-DD for date and
HH:MM:SS for time, with a few variations)?
Emelyn Gilmore wrote:
Please tell me how to GET OUT of this program.
I saw a couple other people responded telling how to exit the OpenOffice
program; but I wondered if maybe you meant something completely different:
Are you asking how to be removed from this mailing list?
To
NoOp wrote:
On 12/13/2007 12:01 PM, Ernesto Mallea wrote:
Dear OpenOffice representative,
In this webside: http://www.officebestdeal.com/, are selling ( and I
did buy) a link to download your free programs renamed OpalOffice.
They said they are authorized to cahrge as your distributor. Is
Well said.
Per wrote:
3. Sell the MS Office original CDs to someone who is stupid enough to
buy it.
Personally I donĀ“t think that OpenOffice.org is getting more users by
telling them how stupid they are if they use Microsofts OS and/or the
Office-suite. If someone wants to have two
Just out of curiosity, do you consider that Excel handles it better? Or
some other tool? Perhaps it's worth a bug submission?
Joe Smith wrote:
...
The whole cell data type (numeric vs. string) issue is a huge stumbling
block for Calc users. You try explaining why things like this happen,
I don't know if this will accomplish exactly what you are thinking of:
In a spreadsheet, you can hide arbitrary rows and/or columns. So let's
say your sheet extends from cell A1 to cell H44. You can hide all
columns I through IV and all rows 45 through 65536. All that will be
left visible
of course...
Jonathan Knight wrote:
What a brilliant idea! You know for a lot less trouble, I could just
stick a piece of tape down the montior to cover up those cents! :-)
- Original Message
From: kevin johnston [EMAIL PROTECTED]
To: users@openoffice.org
Sent: Saturday
The fundamental restriction is that a cell in a spreadsheet can contain
a value or it can contain a formula. A single cell cannot contain both a
value and a formula using that value to construct a *different* value
for display.
But I have an idea. I don't claim it's pretty, and I won't be
Wayne Briggs wrote:
Hi
I am using Open Office Org. version 2.3 (free version).
My problem is if I left click on a cell and then navigate using the up/down,
left/right arrows on the key board. I get the numbers 2 or 6 or 8 being
randomly dropped from time to time in cells. If I had
Bert Severijn wrote:
- Original Message -
From: Jack Carpenter
To: Bert Severijn
Sent: Tuesday, November 27, 2007 6:28 PM
Subject: Impress
I am on the mailing list but every time I send out requesting an answer I might
as well be sending it to a black hole. I notice you are into
Sorry, Andrew, the list server strips off attachments. You'll have to
post the file to the web and just send a link.
Andrew Sharp wrote:
I see that some linux versions come with a working MSAccess connection,
such as Mandriva 2007, but the default download from the OOo website
isn't among
LOWELL BAGLEY wrote:
this program Oo2.1 ERRORS,cannot be REMOVED and wont let me INSTALL newer
version Oo2.3,it also
keeps wanting me to register over again,though I have done so,thought
of donating but FIRST I
would have to get it RIGHT,ANY help to resolve this would be
APPRECIATED? I'm
Mathias Bauer wrote:
Hi Kevin,
kevin johnston wrote:
I'm seeing a bizarre behavior and I'm stumped: Calc can read in a
spreadsheet, display it, edit it, but cannot write it out.
there are two know situations where OOo has problems saving files:
- the file belongs to a remote resource
I'm seeing a bizarre behavior and I'm stumped: Calc can read in a
spreadsheet, display it, edit it, but cannot write it out.
I'm running OOo 2.3 on Windows XP (*when* will I learn?).
I have lots and lots of disk space, and the directory is not write
protected. This is definitely not the
The offset function does this. You can specify distance
up/down/left/right from the current cell, and you can also specify range
extent from that starting point.
Holger Obst wrote:
Hi,
I'm looking for a solution with relative cell reference in ods. Is there a
way to set the cell
Henrik Sundberg wrote:
2006/8/18, CPHennessy [EMAIL PROTECTED]:
Microsoft Office 2007 Beta because better Qualitity.
I guess that it really depends on how you measure and what you measure.
tHE spel cheking Qualitity?
/$
Thank you Henrik! I haven't laughed that hard in a while.
Steve Prentice wrote:
This doesn't really help, but why do you have only one account across
all the machines? To me that doesn't make sense. Why wouldn't
everyone have their own and then they can save their stuff safely
from everyone else...
Because they are 4 years old ...
Well,
This question has been showing up a lot lately. I don't know the answer,
but it sounds like a bug.
What OO version? What OS? Do you have multiple versions of OO installed?
Has this *always* happened ever since you installed OO, or did it just
start recently?
larry wrote:
Every time I
Yes, you can password protect OO documents. I read (on this email list)
that OO encryption is stronger than MS, but I have no personal experience.
Norm Leaf wrote:
I have previously used Microsoft Office 2000, and with their program I used
password to prevent someone from opening personal
Please consider subscribing to this email list, so that you don't risk
missing answers to your question. Send a blank email to
mailto:[EMAIL PROTECTED] You will get a confirmation email
back from the list, just ReplyTo that and you should be subscribed.
Later you can unsubscribe if you aren't
FYI:
There's been a lot of activity on this thread, and I just wanted
everyone who's interested to know that there is an Issue for it: 5991.
It has 25 votes so far, but the more the merrier, eh?
As far as I can tell, only *registered* users can vote (or submit their
own issues). Go to
The general answer is not directly. But there is a workaround.
There are four scenarios, based on two conditions:
1. The source data is scattered, but it is in a region that is
*otherwise empty* except for the data that you want to copy
*AND*
The destination is a currently-empty area.
-
If you click Already Registered, it should stop bothering you. You
don't really have to register, you can lie. People do it all the time,
although obviously since you're a lawyer I can't name names.
You must be a registered user to submit or vote for issues (bugs), but
otherwise it's not
The use of period vs comma as the decimal separator is a language
setting. If you change the separator character manually, you will find
that your number changes to a text string of digit characters, and you
won't be able to perform arithmetic on it. What you need to do is change
the number
You must first select the cell range that you want to sort before trying
to Sort. If you've already done that, then the Sort function is also
available under Data-Sort. I always do it this way, in fact I took the
button off my toolbar to save space. But I just added it back, and for
me it does
Most of the people who receive mail at users@openoffice.org are exactly
that: Users. People who use the program, and devote some of their spare
time to try to help other people who (want to) use the program.
We (well, most of us, anyway) are not professionally employed in any
connection with
Peter, since you said you were having difficulty subscribing, I've
copied you directly.
I've used the second method drag to adjacent cell then back again many
times. Let's see if we can figure out where it goes wrong for you.
First, I'm running OOo version 2.0.2 on Windows XP; don't still
Johnny, I understand all that you've said about changing base point. I
don't know if it's possible to make OOo remember the base point you
selected. But here's a completely different method that *might*
accomplish what you want.
Select your shape, whatever it is. F4, change the base point,
I've seen this message, but I've never figured out the root cause. I've
seen it with files created by OOo, and I've seen it with files created
by other programs. As far as I can tell, it is a Windows problem and not
an OOo problem.
Now, as to fixing it: It is possible, but no single method
This may be completely irrelevant to your situation, if so I'm sorry for
wasting your time.
I used to see gradually increasing response times until I changed the
Tools - Options - Memory - Undo Number of Steps. I think I had set it
to a really high number at one time, like 100+, I've changed
The one advice I see a lot on this mailing list is to be sure to exit
the QuickStarter of the old version before installing a new version.
You shouldn't have to uninstall the old version, unless you just want
to. Multiple versions can live side by side quite happily. But if you
really want to
I have a strong overall negative attitude about Jonathon's whole fear
and threat tone. But I can overcome it. The best course to achieve any
useful results is to confine ourselves to the facts.
Jonathon, can you provide a short explanation of a11y and section
508? What do these regulations
So let's say, just for example, cell A1 contains numeric 123, and cell
B1 contains formula =A1.
Are you saying that you can select cell A1, Copy, select cell A2, Paste,
and now cell B1 contains formula =A2?
This does not happen for me. (Windows XP, OOo2.0.2) Or have I misunderstood?
Shane
In a Regular Expression search, if [:space:] and [:digit:] only work
with + or * or {}, it's a bug.
[:space:] by itself, all alone, should recognize exactly one white
character.
Square brackets enclose a character class. A character class is a list
of atoms. An atom is a matchable entity.
As far as I can tell, from the documentation and my own experiments, OOo
does not save backreferences from the search pattern to use in the
replacement pattern.
Even in a Regular Expression *search*, the *replacement* expression is
not a regular expression, it's a simple text string.
I've
I don't know anything about index entries, but it *is* possible to
make the little yellow notes display - at least, in Calc.
Select a cell that has a note, right click, and there is a Show Note
choice.
The note attached to that cell will now display all the time, it doesn't
depend on the
I saw in response to another recent post:
If you are comfortable with some hacking you have 2 options :
...
2) save the file in ODT format (turning off the Size optimisation for
XML option in Tools - Options - Load/Save - General, then
unzipping the ODT file, and edit the contents.xml file to
I just had a strange thing happen:
I have a pretty big spreadsheet (.ods): 3 pages x 250,000 cells in each,
plus maybe 50,000 graphic objects (simple rectangles). But it used to
open in OOo Calc 2.0.2 in about 1.5 minutes, and I can live with that.
But sometime yesterday (not sure exactly
G. Roderick Singleton wrote:
On Sun, 2006-06-25 at 18:39 -0500, kevin johnston wrote:
I just had a strange thing happen:
I have a pretty big spreadsheet (.ods): 3 pages x 250,000 cells in each,
plus maybe 50,000 graphic objects (simple rectangles). But it used to
open in OOo Calc 2.0.2
into the space of the deleted cells. I don't
see the Don't Shift option you mentioned on 2.0.2, though. That would
be just like pressing the backspace key, anyway, wouldn't it?
Matt
On Fri, 2006-06-09 at 01:21 -0500, kevin johnston wrote:
If I understood the question, I think it *is* possible
If I understood the question, I think it *is* possible to delete a
single cell, or any rectangle of cells:
Mouse select a range of cell; Right mouse click - Delete cells; choose
one of the Shift Left, Shift Up, or Don't Shift options.
There is no way to leave a hole in the sheet, but if you
Andrew Douglas Pitonyak wrote:
kevin johnston wrote:
I think this is probably a stupid Windows question more than it really
has anything to do with OOo, but...
I have a spreadsheet, I made a copy of it with the Windows Explorer
(the file manager/browser thing), which automatically names
I think this is probably a stupid Windows question more than it really
has anything to do with OOo, but...
I have a spreadsheet, I made a copy of it with the Windows Explorer
(the file manager/browser thing), which automatically names the copy
Copy of file. I tried to rename the copy, and I
Don't put the question marks in the expression. What you want is just
[:space:][:space:][:space:][:space:][:space:][:space:][:space:][:space:].
A question mark means match this character 0 times or 1 time only.
What is happening for you is that for every space character in your
document, one
45 matches
Mail list logo