« Rounding Numbers to Thousands and Millions | Main | Converting text to dates »
February 16, 2005
Basic Functions : CELL
A basic function that retrieves information on a specified cell - in particular the formatting.The syntax is CELL(INFO_TYPE; REFERENCE)
Info_type is the character string that specifies the type of information. The character string is always in English. Upper or lower case is optional.
Reference is the position of the cell to be examined. If Reference is a range, the cell moves to the top left of the range. If Reference is missing, OpenOffice.org Calc uses the position of the cell in which this formula is located. Microsoft Excel uses the reference of the cell in which the cursor is positioned.
The examples below show the different type of information that can be obtained for a cell
Posted by Dave at February 16, 2005 05:27 AM