![]() ![]() ![]() 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. But if you do it like this, it will adjust each formula to match the current cell as you require.Returns information about the address, formatting or contents of a cell.ĬELL(info_type cell_ref) returns information about the cell cell_ref. I found the only thing that worked for me was to drag top-left to bottom-right across the cells, and then enter the value of the bottom right cell in the formula (in this case 'F13'). 'F13') is also not particularly logical, the cell you have to put in here depends on how you dragged out the selection on the cells before selecting 'conditional formatting'. ![]() So to match the word 'yes' anywhere in a cell's text content, you could use: The open office help says that COUNTIF uses regular expressions for matching the text - hence the '.*' before and after the 'P' (when looking for cells that only contain an exact phrase match i've had mixed success with a straight "P" test - it seems to work in conditional formatting formulas, but not in cells). This tests for the character 'P' anywhere in the text of each cell in turn. I'm sure there must be an easier way, but here's what I came up with to test a cell to see if it contains a text string value in conditional formatting: ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |