The formula =CELL('color') returns 1 in a cell that has been formatted such that the Negative numbers red option has been selected on the Numbers tab of the Format ▸ Cells dialog.Returns a value indicating whether negative values are formatted in color in the cell (1=formatted in color, 0=not formatted in color). With the formula located in cell A1, =CELL('col') returns 1.Returns the column number of the cell (column A is 1, column B is 2, and so on). The above examples assume the default setting of Calc A1 for the Formula syntax menu in the Tools ▸ Options ▸ LibreOffice Calc ▸ Formula dialog ( LibreOffice ▸ Preferences ▸ LibreOffice Calc ▸ Formula on macOS). =CELL('address' Sheet2.E7) returns $Sheet2.$E$7.With the formula located in cell A1, =CELL('address') returns $A$1.Returns the absolute address of the cell. All examples on this page have been tested in the English (USA) locale but behaviour may be different in other locale settings.ĭescription of valid Info Type argument strings The content of the following two tables includes aspects that are dependent on locale, such as number and date formats. Where Reference specifies multiple cells, CELL returns information for the top left of those cells. A reference to a cell range (for example, D6:E12).If Reference is omitted, information is returned for the cell in which the formula is located. Reference is a reference to the cell for which information is to be returned. More detail about each of these options is given in the table below. Info Type is case-insensitive and must correspond to one of the following permitted options – 'ADDRESS', 'COL', 'COLOR', 'CONTENTS', 'COORD', 'FILENAME', 'FORMAT', 'PARENTHESES', 'PREFIX', 'PROTECT', 'ROW', 'SHEET', 'TYPE', or 'WIDTH'. Info Type is a text string, or a reference to a cell containing a text string, that determines the type of information to be returned. Returns a value whose type depends on the nature of the information requested. Provides requested information on location, formatting properties, or contents of a cell.

Err 522 openoffice calc