On 07/09/10 13:08, Rony G. Flatscher wrote:
Using the interface "http://api.openoffice.org/docs/common/ref/com/sun/star/sheet/XCellRangesQuery" the range "A1:C4" is compared with the value in cell "B5 (4,1)" (value "1") using the "queryColumnDifferences" method of the range, supplying the address of the cell "4,1" as an argument. The resulting XSheetCellRanges is then used to colorize the cells in red, and also its method getRangeAsAddresses is used to display the cell ranges in a human readable form in "A7"
Each column of the range is compared to a cell in the same column and the row of the parameter. They are not all compared to the same value.
Niklas --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org