Range indexes are always zero-based, that is, the index 0 points to the first row or column of the table.īy name It is possible to address a cell range over its name in A1:B2 notation as it would appear in the application. The index is zero-based, that is, the index 0 means the first row or column of the table.īy position Addresses of cell ranges consist of indexes to the first and last row, and the first and last column. Cell addresses consist of a row index and a column index.
![openoffice conditional formatting row over cell openoffice conditional formatting row over cell](https://usermanual.wiki/Openoffice-Org/OpenofficeOrgOpenoffice32CalcGuide777740.1118677903/asset-3e.png)
Example: CELL('SHEET' Sheet3.D2) returns 3 assuming Sheet3 is the third sheet. SHEET CELL() returns the number of the referenced sheet. ROW CELL() returns the number of the referenced row. Example: CELL('COL' D2) returns 4, as D is the fourth column. The interface .XCellRange provides methods to access cell ranges and single cells from a cell range.Ĭells are retrieved by their position. CELL() returns the number of the referenced column. The reference in the condition C4 in a conditional formatting, entered in cell A7, is stored in a tRefN. if cell contains text 'leave' the cell should have red fill (also if the cell contains 'half day leave' or 'full day leave' the cell should have red fill ( basically even if the cell contains the word leave with many other words it. The methods in .XSheetCellRange are:Ĭom::sun::star::table::XCell getCellByPosition( long nColumn, long nRow)Ĭom::sun::star::table::XCellRange getCellRangeByPosition( long nLeft, long nTop,Ĭom::sun::star::table::XCellRange getCellRangeByName ( string aRange)Ĭom::sun::star::sheet::XSpreadsheet getSpreadsheet() .row and column) store them in the same format. I have to fill the cell color red if the cell contains specific text through conditional formatting in calc.
![openoffice conditional formatting row over cell openoffice conditional formatting row over cell](https://www.lifewire.com/thmb/RyIoFBuy-w-vNYdCzVjMOm7XCL8=/1600x870/filters:no_upscale():max_bytes(150000):strip_icc()/22-openoffice-calc-basic-spreadsheet-tutorial-10fa048119794a3db1c2248ca441694b.jpg)
It provides access to cells of the range and sub ranges, and is supported by the spreadsheet and sub-ranges of a spreadsheet. streamlabs mobile not connecting gaussian mixture model python github 0. Conditional Formatting Table Rows Based off a Cell Value that contains IF Function The IF function may not be relevant, however, I want to add conditional formatting to an entire table row based off the corresponding value in the B column so that way every time we enter a new row of data, the IF function is carried over as well as the. The interface .XSheetCellRange is derived from .XCellRange.