lahelper.blogg.se - Openoffice calc absolute reference

For example CELL("WIDTH" D2) returns the width of column D - but if column D is then made wider, the value returned will not update until the contents of D2 are changed.

CELL() returns information captured when the target cell was last updated.

PARENTHESES CELL() returns 1 if the format code contains an opening bracket (, otherwise 0. () (brackets) at the end = there is an opening bracket in the format codeĬOLOR CELL() returns 1, if negative values have been formatted in color, otherwise 0.

(Minus) at the end = negative numbers are formatted in color Example: the number format #,#0.0 returns ,1 and the number format 00.000% returns P3 D1 = MMM-D-YY, MM-D-YY and similar formats In the above formats, the number of decimal places after the decimal separator is given as a number. S = exponential representation, for example 1.234+E56 P = percentage PROTECT CELL() returns the status of the cell protection for the cell.įORMAT CELL() returns text that indicates the number format: PREFIX CELL() returns text that indicates the alignment of the referenced cell, as: The unit is the number of zeros (0) that fit into the column in the default text and the default size. WIDTH CELL() returns the width of the referenced column. V (value) signifies a number, or the result of a formula as a number L (label) signifies text, or the result of a formula as text TYPE CELL() returns text that indicates the type of cell contents: Example:ĬELL("CONTENTS" D2) returns the contents of cell D2 (or 0 if D2 is empty). Examples:ĬELL("COORD" Sheet3.D2) returns $C:$D$2.ĬONTENTS CELL() returns the contents of the referenced cell, without any formatting. Examples:ĬELL("FILENAME" D2) returns ' file:///X:/dr/myfile.ods'#$Sheet1, if the current document is X:\dr\myfile.ods and the formula is on Sheet1.ĬELL("FILENAME" 'X:\dr\myfile.ods'#$Sheet1.D2) returns ' file:///X:/dr/myfile.ods'#$Sheet1.ĬOORD CELL() returns the complete cell address in Lotus (TM) notation, as text. 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.