LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 02-03-2009, 01:52 AM   #1
binary_dreamer
Member
 
Registered: Feb 2006
Distribution: debian squeeze
Posts: 199

Rep: Reputation: 31
compare spreadsheets


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.
 
Old 02-03-2009, 03:41 AM   #2
tshrinivasan
Member
 
Registered: Jan 2006
Location: Chennai, Tamil nadu, India
Distribution: Debian Etch Testing
Posts: 117

Rep: Reputation: 16
Edit->Changes->record
Edit->Changes->Show

is this you need?

see here,
http://sawaal.ibibo.com/computers-an...ce-462540.html
 
Old 02-03-2009, 04:02 AM   #3
binary_dreamer
Member
 
Registered: Feb 2006
Distribution: debian squeeze
Posts: 199

Original Poster
Rep: Reputation: 31
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?
 
Old 02-03-2009, 04:14 AM   #4
tshrinivasan
Member
 
Registered: Jan 2006
Location: Chennai, Tamil nadu, India
Distribution: Debian Etch Testing
Posts: 117

Rep: Reputation: 16
If you want multiple people to author come content, how about setting up a local mediawiki?
 
Old 02-03-2009, 04:22 AM   #5
colucix
LQ Guru
 
Registered: Sep 2003
Location: Bologna
Distribution: CentOS 6.5 OpenSuSE 12.3
Posts: 10,509

Rep: Reputation: 1983Reputation: 1983Reputation: 1983Reputation: 1983Reputation: 1983Reputation: 1983Reputation: 1983Reputation: 1983Reputation: 1983Reputation: 1983Reputation: 1983
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
Code:
unoconv -f csv test.xls
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.
 
Old 02-03-2009, 04:35 AM   #6
binary_dreamer
Member
 
Registered: Feb 2006
Distribution: debian squeeze
Posts: 199

Original Poster
Rep: Reputation: 31
OK. i got the csv. Now what are the commands to find the differences between the column A and column B?
 
Old 02-03-2009, 04:44 AM   #7
colucix
LQ Guru
 
Registered: Sep 2003
Location: Bologna
Distribution: CentOS 6.5 OpenSuSE 12.3
Posts: 10,509

Rep: Reputation: 1983Reputation: 1983Reputation: 1983Reputation: 1983Reputation: 1983Reputation: 1983Reputation: 1983Reputation: 1983Reputation: 1983Reputation: 1983Reputation: 1983
Quote:
Originally Posted by binary_dreamer View Post
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?
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Learning Spreadsheets daniell Linux - Newbie 10 11-04-2008 02:38 PM
oleo/sc spreadsheets mugsy Linux - Software 0 06-17-2006 06:51 AM
Need to set up online interactive spreadsheets. sdolin Linux - Newbie 1 04-13-2006 03:33 PM
Why is charting in spreadsheets so poor? adamis Linux - Software 7 12-03-2004 10:32 PM
OpenOffice.org/StarOffice Spreadsheets rm6990 Linux - Software 2 09-21-2004 09:20 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 09:29 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration