
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.
:max_bytes(150000):strip_icc()/18-openoffice-calc-basic-spreadsheet-tutorial-b4020c279c0f4a52826486fcfcf5124a.jpg)
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.
