Diff for OpenDocument spreadsheets

Loïc Grenié loic.grenie at gmail.com
Tue Sep 20 16:59:14 UTC 2011

2011/9/20 NoOp <glgxg at sbcglobal.net>:
> On 09/20/2011 01:50 AM, Loïc Grenié wrote:
>>     Hi,
>>     I've two spreadsheets which are very similar. I'd like to know
>> what the differences
>>   are. Is there a tool similar to "diff" for OpenDocument spreadsheets ?
> ...
> They are zip files. You can extract them and then compare the .xml files.

    Of course. The problem is that it's difficult to understand where the
  changes took place (which sheet(s), which cell(s)). I'd like to have a
  list, similar to what diff gives:

--- question.ods
+++ answer.ods
@@-alpha.C1 +alpha.C1

   (maybe not exactly that, but something similar). In that case the
  diff tells me that the two spreadsheets differ in sheet alpha, cell C1,
  that the first has a formula
  =SOLVE(Universal.problem->life&&universe&&everything) and the
  second a number 42.



More information about the ubuntu-users mailing list