![]() ![]() Examples:ĬELL("ADDRESS" Sheet3.D2) returns $Sheet3.$D$2.ĬELL("ADDRESS" 'X:\dr\test.ods'#$Sheet1.D2) returns ' file:///X:/dr/test.ods'#$Sheet1.$D$2.įILENAME CELL() returns the file name and the sheet number of the referenced cell, as text. Example:ĬELL("SHEET" Sheet3.D2) returns 3 assuming Sheet3 is the third sheet.ĪDDRESS CELL() returns the absolute address of the referenced cell, as text. SHEET CELL() returns the number of the referenced sheet. ROW CELL() returns the number of the referenced row. Example:ĬELL("COL" D2) returns 4, as D is the fourth column. The information returned depends on the (case insensitive) text string info_type, which can be set as follows:ĬOL CELL() returns the number of the referenced column. Returns information about the address, formatting or contents of a cell.ĬELL(info_type cell_ref) returns information about the cell cell_ref. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |