Diff for OpenDocument spreadsheets
hideserted at gmail.com
Tue Sep 20 18:46:35 UTC 2011
On Tue, Sep 20, 2011 at 11:30 AM, NoOp <glgxg at sbcglobal.net> wrote:
> On 09/20/2011 09:59 AM, Loïc Grenié wrote:
> > 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
> > 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.
> I'm not familiar enough with 'diff' to help there. However one way to
> check the differences is to use meld and then compare the content.xml of
> each. For example; I did a simple .ods with only the number 1 in the
> first cell, saved it, changed the number to 2 and saved that as a
> different spreadsheet. I then extraced both and used meld to compare
> them side-by-side. Meld highlights the differences and I can see that in
> the first:
> <table:table-cell office:value-type="float" office:value="1
> and in the second:
> <table:table-cell office:value-type="float" office:value="2"
> Not as eloquent as diff, but might be worth a try.
> ubuntu-users mailing list
> ubuntu-users at lists.ubuntu.com
> Modify settings or unsubscribe at:
Given both the formula and the output it is my carefully considered opinion
that you need to consult with the mice.
Don't forget to bring your towel.
Accidental deaths by firearms account for less than 1% of the 30,000. There
are three times as many medical mistake deaths in the US than there are
accidental gun deaths. Perhaps we need safety locks on doctors and nurses?
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the ubuntu-users