Hi there, just noticed that my e-mail was turned to a flat text file, hence the coloring got lost. As described in the text the cells that differ from the SearchValue (1) are: B1, B4, C3, C4, which do not differ from the search value at all. (Trying to emphasize them in the table below by placing the number between two asterisks.)
The cells that differ are instead: B2, B3, C1, C2. ---rony P.S.: It is as if the returned cells are the inverse of their respective column cells, i.e. those cells per column, that do not differ; as if after the first column was processed some switch causing the inverse result to be wrongly reported. On 09.07.2010 13:08, Rony G. Flatscher wrote: > Hi there, > > 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" > > The result is as follows (directly copied from the spreadsheet): > > > 1 *1* 2 > 1 2 2 > 1 2 *1* > 1 *1* *1* > Search value: 1 > > > > Sheet1.B1;Sheet1.B4;Sheet1.C3:C4 > > > > Now, the result of "queryColumnDifferences" surprises me, as I would > have expected the cells containing the value "2" to be returned from > "queryColumnDifferences", rather four cells are returned that > column-wise indicate those cells that have a matching value with the > search value, rather than those cells that have different values (i.e. > "B2:B3" and "C1:C2"). > > Is this the intended behaviour of this method? > <http://api.openoffice.org/docs/common/ref/com/sun/star/sheet/XCellRangesQuery.html#queryColumnDifferences> > states: > > "...All cells which are different to this comparison cell will be > returned." > > [Using the method "queryRowDifferences" will return all (!) cells in > the given range!] > > All of this is OOo 3.2.1 running under Windows XP SP3. > > Can someone shed some light on this (I did not find any issues linked to > queryColumnDifferences in the issue tracker) ? > > ---rony > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
