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
-=SOLVE(Universal.problem->life&&universe&&everything)
+42
(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.
Thanks,
Loïc
More information about the ubuntu-users
mailing list