// simpleTableCalculation.jsx  
  
if (app.selection[0].parent.constructor.name == "Cell"){  
	var myTable = app.selection[0].parent.parent;  
	var myLastCol = myTable.columns.length-1;  
	var myLastRow = myTable.rows.length-1;  
	var mySum = 0;  
	for (k = 0; k < myLastRow; k++) {  
		 mySum += (myTable.columns[myLastCol].cells[k].contents.replace(",", "."))*1  
	}  
	myTable.columns[myLastCol].cells[myLastRow].contents  = digitFormatter(mySum); 
}  
 
function digitFormatter(x) { 
	// Quelle: http://www.dcljs.de/faq/antwort.php?Antwort=rechnen_runden#6 
	var k = (Math.round(x * 100) / 100).toString(); 
	k += (k.indexOf('.') == -1)? '.00' : '00'; 
	var p = k.indexOf('.'); 
	return k.substring(0, p) + ',' + k.substring(p+1, p+3); 
} 

// simpleBilling.jsx   
  
var MWST = 16/100;  
if (app.selection[0].parent.constructor.name == "Cell"){   
	var myTable = app.selection[0].parent.parent;   
	var myLastCol = myTable.columns.length-1;   
	var myLastRow = myTable.rows.length-1;   
	var mySum = 0;   
	for (k = 0; k < myLastRow-2; k++) {   
		 mySum += (myTable.columns[myLastCol].cells[k].contents.replace(",", "."))*1   
	}   
	myTable.columns[myLastCol].cells[myLastRow-2].contents  = digitFormatter(mySum);   
	myTable.columns[myLastCol].cells[myLastRow-1].contents  = digitFormatter(mySum*MWST);   
	myTable.columns[myLastCol].cells[myLastRow].contents  = digitFormatter(mySum*MWST + mySum);   
}  
 
function digitFormatter(x) {  
	// Quelle: http://www.dcljs.de/faq/antwort.php?Antwort=rechnen_runden#6  
	var k = (Math.round(x * 100) / 100).toString();  
	k += (k.indexOf('.') == -1)? '.00' : '00';  
	var p = k.indexOf('.');  
	return k.substring(0, p) + ',' + k.substring(p+1, p+3);  
} 

var MWST = 16/100; 

 
// simpleBilling.jsx    
   
var MWST = 16/100;   
if (app.selection[0].parent.constructor.name == "Cell"){    
	var myTable = app.selection[0].parent.parent;    
	var myLastCol = myTable.columns.length-1;    
	var myLastRow = myTable.rows.length-1;    
	var myStunden = myTable.columns.item(3).contents; 
	var myNetto = myTable.columns.item(4).contents; 
	var mySum = 0;    
	var myPrice = 0; 
	for (k = 0; k < myLastRow-2; k++) {    
 
		 myPrice = (((myTable.columns.item(3).cells[k].contents))*((myTable.columns.item(4).cells[k].contents))); 
 
		 myTable.columns.item(3).cells[k].contents = digitFormatter(myTable.columns.item(3).cells[k].contents); 
		 myTable.columns.item(4).cells[k].contents = digitFormatter(myTable.columns.item(4).cells[k].contents); 
 
		 myTable.columns[myLastCol].cells[k].contents  = digitFormatter(myPrice) + " EUR";    
		 mySum += (myTable.columns[myLastCol].cells[k].contents.replace(",",  "."))*1   ; 
 
	}    
	 
	myTable.columns[myLastCol].cells[myLastRow-2].contents  = digitFormatter(mySum) + " EUR";    
	myTable.columns[myLastCol].cells[myLastRow-1].contents  = digitFormatter(mySum*MWST) + " EUR";    
	myTable.columns[myLastCol].cells[myLastRow].contents  = digitFormatter(mySum*MWST + mySum) + " EUR";    
}   
 
  
function digitFormatter(x) {   
	// Quelle: http://www.dcljs.de/faq/antwort.php?Antwort=rechnen_runden#6   
	var k = (Math.round(x * 100) / 100).toString();   
	k += (k.indexOf('.') == -1)? '.00' : '00';   
	var p = k.indexOf('.');   
	return k.substring(0, p) + ',' + k.substring(p+1, p+3);   
} 

var myString = '123,45'; 
var myNum = Number( myString.replace(",", ".") ); 

var myNum = 123.45; 
var myString = String( myNum).replace(".", ",");