. : http://uneex.lorien.cs.msu.su/static/GnumericDoc_ru/r1272.html
: Mon Sep 26 12:35:55 2011
: Tue Oct 2 07:04:39 2012
: koi8-r

:
ADDRESS

ADDRESS

Name

ADDRESS -- 

Synopsis

ADDRESS(row_num,col_num[,abs_num,a1,text])

Description

ADDRESS .

@abs_num = 1 , ADDRESS . @abs_num =2, ADDRESS . @abs_num = 3, ADDRESS . @abs_num = 4, ADDRESS . @abs_num > 4, ADDRESS #NUM!.

@a1 - , . @a1 TRUE , ADDRESS A1, .. $D$4. ADDRESS R1C1, .. R4C4.

@text .

@row_num < 1 @col_num < 1, ADDRESS #NUM!.

Examples

ADDRESS(5,4) "$D$5".

ADDRESS(5,4,4) "D5".

ADDRESS(5,4,3,FALSE) "R[5]C4".

See also