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