[KLUG Members] Spread sheet problem

[Adam Williams]

> I am using Open Office Calc.I have one sheet with 1000 rows and 30 column
> .Now some rows have red cell color and some have yellow.How to copy only red
> cell value to another sheet?

I've used -
=IF(((CELL("COLOR";D7))  AND  (D7 < 0));1;0)
- which returns 1 if the value is negative and the cell has been
formatted to show negative numbers as red.

Otherwise if that isn't sufficient UNO provides services like
UniqueCellFormatRanges that are available via Star Basic, Java, or the
UNO/CORBA bridge.  I've seen some really amazing stuff done via OO's API
and interfaces, but haven't had enough time to play with it
sufficiently.  You can do ANYTHING via their API.