From f1639d27e22169c24d23fc89f4d9d678f096f6e9 Mon Sep 17 00:00:00 2001 From: Sup Yut Sum Date: Sat, 13 Apr 2013 08:09:49 +0800 Subject: [PATCH] Fix diff-xls.js error reported from http://tortoisesvn.tigris.org/ds/viewMessage.do?dsForumId=4061&dsMessageId=3053016 Based on TortoiseSVN revision 24102 Signed-off-by: Sup Yut Sum --- contrib/diff-scripts/diff-xls.js | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/contrib/diff-scripts/diff-xls.js b/contrib/diff-scripts/diff-xls.js index 79773f7a5..0ef12c2c9 100644 --- a/contrib/diff-scripts/diff-xls.js +++ b/contrib/diff-scripts/diff-xls.js @@ -175,6 +175,10 @@ for (var i = 1; i <= length; i++) { sFormula = "=INDIRECT(\"Dummy_for_Comparison" + i + "!\"&ADDRESS(ROW(),COLUMN()))"; } + var original_content = objNewWorksheet.Cells(1,1).Formula; + objNewWorksheet.Cells(1,1).Formula = sFormula; + sFormula = objNewWorksheet.Cells(1,1).FormulaLocal; + objNewWorksheet.Cells(1,1).Formula = original_content; objNewWorksheet.Cells.FormatConditions.Add(xlCellValue, xlNotEqual, sFormula); objNewWorksheet.Cells.FormatConditions(1).Interior.ColorIndex = 3; // 3:Red RGB(128,0,0) } -- 2.11.4.GIT