[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: Tobias Schäfer <tobiasschaefer_at_gmx.de>
Date: 2007-05-04 20:18:24 CEST

On Tuesday 01 May 2007 00:09, Jared Silva wrote:
> cytrynski@web.de wrote:
> > I have extended the Excel diff script (.vbs) that was created by Suraj
> > Barkale. In the new version the cells in the first worksheet of
> > workbook 1, that are different to the cells in the first worksheet of
> > workbook 2, are marked in red. Therefore it is much easier to find the
> > differences in the side-by-side view. I have tested the script in Excel
> > 2003 and it works fine. I use conditional formatting to mark the cells
> > that are different. This method is very fast (I tested several ways).
> > The script also works with two Excel workbooks that are dragged&dropped
> > to the script's icon in the Windows Explorer. I hope you enjoy it!
>
> I have some concerns with your script updates.
>
> The use of "xObject" in lines 13 and 26 break the script for me.
>
> "Dummy_for_Comparison" should be hidden (Format > Sheet > Hide).
>
> The script update should run on the entire Workbook, not just the first
> Sheet.
>
> The script update should activate (display) the same Sheet in each file.
>
> The script update changes the base file(s). The file(s) should be
> marked as unchanged (saved).

Jared, could you provide a patch to fix your concerns? A patch would be as
welcome as all your previous bugfixes :-)

Tobias

-- 
       ___
  oo  // \\      "De Chelonian Mobile"
 (_,\/ \_/ \     TortoiseSVN
   \ \_/_\_/>    The coolest Interface to (Sub)Version Control
   /_/   \_\     http://tortoisesvn.net
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tortoisesvn.tigris.org
For additional commands, e-mail: users-help@tortoisesvn.tigris.org
Received on Fri May 4 20:19:18 2007

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