On Wed, 21 Jan 2004 23:35:25 +0530, "komal" <[EMAIL PROTECTED]>
said:
> Hi
>
> 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?
Hi komal,
You could try this.... save your spreadsheet containing data (1000
rows,30 columns) as a csv text file. (provided you only want the data
and not the formatting). Then use a utility like awk to filter out
alternate rows of data into another text file (say text1.txt). Now it
is as simple as importing that into your spreadsheet. (I think Insert
--> External Data) will do the trick.
hope this helps
Ravi
--
http://tinyurl.com/2zb5k
--
http://www.fastmail.fm - I mean, what is it about a decent email service?
-------------------------------------------------------
The SF.Net email is sponsored by EclipseCon 2004
Premiere Conference on Open Tools Development and Integration
See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
http://www.eclipsecon.org/osdn
_______________________________________________
linux-india-help mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/linux-india-help
