Page 1 of 1
Comparing files for changes
Posted: Mon Aug 11, 2008 3:57 pm
by lodilefty
If you use Open Office:
Edit - Compare Documents
brings up a list of changes from another version, allowing you to accept/reject each change [see screenshot]
There are also Change Tracking options....
Yeah, I know: everybody but me knew about this
Posted: Mon Aug 11, 2008 6:55 pm
by Rafiki
lodilefty wrote:Yeah, I know: everybody but me knew about this
I know I didn't; thanks for the tip, lodi
Posted: Mon Aug 11, 2008 7:03 pm
by arsan
Can excel do this also?
Seems very useful...
Posted: Mon Aug 11, 2008 8:03 pm
by Pocus
same questions as Arsan...
Posted: Mon Aug 11, 2008 9:44 pm
by lodilefty
I had to go find a computer with Excel on it...
Excel in Office 2003 has a "Compare Side by side with..." that tiles two spreadsheets and synchonizes the scrolling between them. It doesn't highlight changes [at least I can't get it to], so you have to use your Mark 1 eyeball to see differences...
It also seems that there are 3rd party addins available [for a fee?] to do this.....
Posted: Tue Aug 12, 2008 12:18 pm
by jastaV
Have to try it, too!
Seems to be a powerful tip.
Great work Lodilefty
Posted: Tue Aug 12, 2008 6:14 pm
by jastaV
lodilefty wrote:I had to go find a computer with Excel on it...
Excel in Office 2003 has a "Compare Side by side with..." that tiles two spreadsheets and synchonizes the scrolling between them. It doesn't highlight changes [at least I can't get it to], so you have to use your Mark 1 eyeball to see differences...
It also seems that there are 3rd party addins available [for a fee?] to do this.....
Have Office 2003 Italian version!
The feature here described by lodilefty is activable by the
"Confrontare cartelle di lavoro affiancate" option.
In English it could be translated as "Compare worksheet side by side"!
I'm trying to activate and usint it now!
Posted: Tue Aug 12, 2008 6:33 pm
by jastaV
I verified Docs comparison works as reported!
You can compare two Excel docs or even two CSV docs!!!!!
...and, that is very interesting, you can compare an Excel doc with a CSV docs although syncronous scrolling seems not to work!