[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

Re: Excel diff script (extended version)

From: Jared Silva <jayrod_at_gmail.com>
Date: 2007-05-30 20:40:01 CEST

Stefan Kng wrote:
> kippspan wrote:
>
> > I've updated the script to work with Excel pre-2003 (see below). This is
> > similar to side-by-side comparison as it will horizontally tile two
> > workbooks. It is not the quite same because you have to scroll in both
> > workbooks.
>
> Great, thanks!
> But could you add a check in the script for the Excel-Version and then
> do the corresponding actions based on that version info? It's because we
> only have one diff script per file extension.

Kipp, here is an example of what Stefan is looking for (diff-doc.js)...

http://tortoisesvn.tigris.org/source/browse/tortoisesvn/trunk/contrib/other/diff-scripts/diff-doc.js?rev=8957&r1=8418&r2=8543

+ // Microsoft Office versions for Microsoft Windows OS
+ var vOffice2000 = 9;
+ var vOffice2002 = 10;
+ var vOffice2003 = 11;
+ var vOffice2007 = 12;

          // Compare to the base document
+ if (Number(word.Version) <= vOffice2000)
+ {
+ // Compare for Office 2000 and earlier
+ destination.Compare(sBaseDoc);
+ }
+ else
+ {
+ // Compare for Office XP (2002) and later
          destination.Compare(sBaseDoc, "", wdCompareTargetNew, true, true);
+ }

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tortoisesvn.tigris.org
For additional commands, e-mail: users-help@tortoisesvn.tigris.org
Received on Wed May 30 20:40:16 2007

This is an archived mail posted to the TortoiseSVN Users mailing list.