On Friday, October 21, 2005, 10:46:01 PM, Bryce Schober wrote: > 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".
Like the others have pointed out, there seems to be no "real" support for R1C1-addressing. But it seems to me, that there is a (quite clumsy) workaround. Nevertheless, it should work in most cases: You have to use a combination of the INDIRECT and ADDRESS functions. (Since I'm using the German version of OOo, I'm not totally sure if my translations of the function-names are correct, but I hope they'll point into the right direction at least.) So, to translate an Excel-like =SUM(R3C8:R6C9) to Calc, use =SUM(INDIRECT(ADDRESS(3;8) & ":" & ADDRESS(6;9))) Regards, Mark Kirchner -- ______________________________________________________________________ My OpenPGP-Key: http://www.mark-kirchner.de/keys/key-mk.asc Fingerprint: 583E 298D 8C0C 11C3 9882 5654 FEF6 675C 172C 073C --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
