Bryce Schober wrote:
On 10/21/05, CPHennessy <[EMAIL PROTECTED]> wrote:
On Fri October 21 2005 20:09, Bryce Schober wrote:
Does Calc not support R1C1-style referencing?
It supports both absolute and relative cell references. have a look at "Help"
-> "Contents" for more info. Otherwise have a look at
http://documentation.openoffice.org
This doesn't answer my question. R1C1 is a completely different style
of range addressing that excel supports. It looks like "R3C8:R6C9",
meaning "include cells in the 3rd to 6th rows and the 8th to 9th
columns, inclusive". I also don't see it mentioned in the
excel-to-calc migration document.
--
Bryce Schober
Actually Bryce, he might have answered your question, you just don't
know it. Let me clarify...
1. You are obviously an EXPERT user of Excel. I think that you know this
program very well. I am pretty sure of this, because I took a look at
one of your previous questions and noticed that you used something like
an array formula, that I have seen before but have not really used.
2. I suspect that you are using terms that may be specific to Excel (or
refering to features that OOo does not support). In the other question
that you posed, you also used a term that I did not know but guessed
that it might be similar to other things that OOo can do, but I am not
certain. If you are simply using terms that an OOo user will not
recognize, then your best bet is to take a look at the user's guide and
the online help and search for similar terms.
CPH was recommending that you take a look at the documentation project
to find the Calc documentation, which should answer your question.
Hopefully, however, someone on the list will know the answers to these
difficult questions that you have :-)
Luckily, you proided an explanation on what this means.... I will now
guess at an answer, since I do not know how you use what you just
explained....
I think that no, you can not use referencing in the style that you just
mentioned. I almost hesitate to say this.... You can do something
similar with this:
=SUM(A22:B24)
but I think that you are WAY beyond simple things such as this. Hmmmm,
ponder ponder ponder..... There are some very esoteric commands that you
can use in Calc where you send things such as row and column and convert
them into other things such as addresses or use them in indirect
addressing. Do you mean these type of built in functions? I assume the
answer to this is no as well.
So, realize that although, off hand, I would say the answer to your
question is no, I would have said the same thing about Excel so my
opinion is only worth what you paid for it.... Nothing at all. I need to
go to bed.
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.sxw
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info: http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
