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
As far as I can tell, no. If it were an option there would be a setting
for it in Tools -> Options -> OpenOffice.org Calc -> General.
To CPH and Mr. Pitonyak: R1C1 addressing is just an alternative
nomenclature for specifying cells. Instead of cell D3 you would have
cell R3C4. In a way it makes a lot more sense as it's more consistent.
Quick, how many columns lie between column T and column CJ? You can do
the math, but it's not convenient.
The R1C1 style seems particularly suited to calculated indirect cell
referencing at least insofar as its somewhat easier to think about
things that way.
There is an outstanding issue:
http://www.openoffice.org/issues/show_bug.cgi?id=20857
that deals with this. The status is STARTED, which is encouraging, with
the target being OOLater (meaning whenever they get around to it).
Now that 2.0 is officially out the door, this might be something we
could expect on a minor release? Or would it have to wait for 3.0?
Rod
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
