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

Error when diffing Excel files (new file has one additional worksheet)

From: Niemann, Hartmut <hartmut.niemann_at_siemens.com>
Date: Fri, 23 Oct 2015 12:09:12 +0000

Hello!

When diffing an excel file with its previous version, I got

Windows Scripting Host
Skript: ...Diff-Scripts\diff-xls.js
Zeile/Line 145
Fehler: Index auŸerhalb des gültigen Bereichs
(Error: Index out of range)
Code: 800A0009
Quelle: Laufzeitfehler in Microsoft JScript
(Source: Runtime error in Microsoft JScript)

The relevant portion is

// Mark differences in sNewDoc red
var length = objNewWorkbook.Worksheets.Count;
for (var i = 1; i <= length; i++)
{
    var objBaseWorksheet = objBaseWorkbook.Worksheets(i); <<<< line 145
    var objNewWorksheet = objNewWorkbook.Worksheets(i);

and in this case the new version has an additional worksheet which base does not have,
so last i = length (from objNewWorkbook) is out of range for objBaseWorkbook

I don't know this language and excel well enough to suggest a fix - who can repair this?

(I got this report from a coworker using 1.8.11, same here with 1.9.2)

Mit freundlichen GrüŸen
Dr. Hartmut Niemann

Siemens AG
MO MLT LM EN CCI 1
Werner-von-Siemens-Str. 67
91052 Erlangen, Deutschland
Tel.: +49 9131 7-34264
Fax: +49 9131 7-26254
mailto:hartmut.niemann_at_siemens.com

Siemens Aktiengesellschaft: Vorsitzender des Aufsichtsrats: Gerhard Cromme; Vorstand: Joe Kaeser, Vorsitzender; Roland Busch, Lisa Davis, Klaus Helmrich, Janina Kugel, Siegfried Russwurm, Ralf P. Thomas; Sitz der Gesellschaft: Berlin und München, Deutschland; Registergericht: Berlin Charlottenburg, HRB 12300, München, HRB 6684; WEEE-Reg.-Nr. DE 23691322

------------------------------------------------------
http://tortoisesvn.tigris.org/ds/viewMessage.do?dsForumId=4061&dsMessageId=3143594

To unsubscribe from this discussion, e-mail: [users-unsubscribe_at_tortoisesvn.tigris.org].
Received on 2015-10-23 14:09:39 CEST

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