Hi. I got a spreadsheet that consists of a column that has more than 100 entries. that column gets updated almost everyday and i need to find differences. i need to see which lines have been added. It is created in OpenOffice.

Edit->Changes->record
Edit->Changes->Show

is this you need?

see here,
http://sawaal.ibibo.com/computers-an...ce-462540.html

That is really nice and handy.
the thing is that this file has been created from many people inside my company and i cannot keep track.Once a week i have to take the two versions of the files and spot the differences. is there any easy way with functions of something similar?

If you want multiple people to author come content, how about setting up a local mediawiki?

Some time ago I found a little utility to convert OpenOffice documents from any known format to any known output format (known means by openoffice): unoconv. You can find it here. Debian packages are also available. Using this command line utility you can convert your spreadsheet into CSV and then compare it with a previous version using your favorite tools to compare text files (diff, comm, and so on).

Suppose you have a SpreadSheet named test.xls. You can simply do
and you will end up with a CSV file named test.csv, ready for comparison with a previously created CSV. This can be useful to achieve this task in a completely automatic way, using a simple shell script and eventually a cron job.

OK. i got the csv. Now what are the commands to find the differences between the column A and column B?

Can you post an example of a CSV file?