| Line 7: |
Line 7: |
| | *The information about the cell can be the contents,size, formatting etc. | | *The information about the cell can be the contents,size, formatting etc. |
| | *<math>type</math> specifies what type of information we want. | | *<math>type</math> specifies what type of information we want. |
| − | *<math>references</math> is the cell we want to retrieve information. | + | *<math>reference</math> is the cell we want to retrieve information. |
| − | *<math>references</math> is optional. | + | *<math>reference</math> is optional. |
| − | *If <math>references</math> is omitted, the last cell that was changed will be taken | + | *If <math>reference</math> is omitted, the last cell that was changed will be taken |
| | | | |
| | {| class="wikitable" | | {| class="wikitable" |
| Line 22: |
Line 22: |
| | |- | | |- |
| | | "col" | | | "col" |
| − | | | + | | Column number of the cell. |
| | | | |
| | |- | | |- |
| | | "color" | | | "color" |
| − | | | + | | Returns 1 if the color is a negative value; Otherwise it returns 0. |
| | |- | | |- |
| | | "contents" | | | "contents" |
| − | | | + | | Contents of the upper-left cell. |
| | |- | | |- |
| | | "filename" | | | "filename" |
| − | | | + | | Filename of the file that contains reference. |
| | |- | | |- |
| | | "format" | | | "format" |
| − | | | + | | Number format of the cell. See example formats below. |
| | |- | | |- |
| | | "parentheses" | | | "parentheses" |
| − | | | + | | Returns 1 if the cell is formatted with parentheses; Otherwise, it returns 0. |
| | |- | | |- |
| | | "prefix" | | | "prefix" |
| − | | | + | | Label prefix for the cell. |
| | + | * Returns a single quote (') if the cell is left-aligned. |
| | + | * Returns a double quote (") if the cell is right-aligned. |
| | + | * Returns a caret (^) if the cell is center-aligned. |
| | + | * Returns a back slash (\) if the cell is fill-aligned. |
| | + | * Returns an empty text value for all others |
| | |- | | |- |
| | | "protect" | | | "protect" |