TrimPath Forum

--- /tmp/trimpath/spreadsheet_engine.js 2005-02-13 05:17:35.000000000 +1100
+++ spreadsheet_engine.js       2007-05-03 09:59:46.000000000 +1000
@@ -39,7 +39,8 @@
             COUNT : function(values) { return fold(values, COUNT2, 0); },^M
             SUM : function(values) { return fold(values, SUM2, 0); },^M
             MAX : function(values) { return fold(values, MAX2, theNumber.MIN_VALUE); },^M
-            MIN : function(values) { return fold(values, MIN2, theNumber.MAX_VALUE); }^M
+            MIN : function(values) { return fold(values, MIN2, theNumber.MAX_VALUE); },^M
+           IF : function(cond, then, or) { return (cond ? then : or); }^M
         },^M
         calc : function(cellProvider, context, startFuel) {^M
             // Returns null if all done with a complete calc() run.^M
@@ -177,6 +178,7 @@
 ^M
     // Parse formula (without "=" prefix) like "123+SUM(A1:A6)/D5" into JavaScript expression string.^M
     var parseFormula = TrimPath.TEST.parseFormula = function(formula, dependencies) { ^M
+       formula = formula.replace(/;/g, ","); // turn function separators into something callable^M
         var arrayReferencesFixed = formula.replace(/\$?([A-Z]+)\$?([0-9]+):\$?([A-Z]+)\$?([0-9]+)/g,^M
             function(ignored, startColStr, startRowStr, endColStr, endRowStr) {^M
                 var res = [];^M