Hi Niklas, On 09.07.2010 18:16, Niklas Nebel wrote: > 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. Ah, that explains it, thank you very much for your help !
---rony --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
