In OpenOffice.org with one of the documents open: Edit > Compare Documents ....
A revision dialog is then presented so that you can accept and reject changes. Cheers, Ian On Wed, 2007-01-24 at 11:40 +1300, Neil Stockbridge wrote: > i seek your aid in my quest to compare two OpenOffice spreadsheets. > like a fool, i forked the sheet and now i have two versions of the same > spreadsheet both containing modifications that i would like to keep. > > the .sxc files can be unzipped, to yield these files: > > content.xml META-INF meta.xml mimetype settings.xml styles.xml > > the XML is all on one line, so: > > sed -i 'y/>/\n/' *.xml > > ..puts those XML files into a more comparable form yet the actual > changes are swamped in a sea of formatting changes that i didn't make. > the sheets could be exported as CSV and compared but changes to formulae > would be missed. > > so is there a better way of comparing two spreadsheets? > > - neil >
