# Calculate Auto Update On Cell Change - C#

Spreadsheet SDK sample in C# demonstrating ‘Calculate Auto Update On Cell Change’

##### Program.cs
``````using System;
using System.Collections.Generic;
using System.Text;
using System.IO;

namespace Calculations
{
class Program
{
static void Main(string[] args)
{

// Get decimal separator. Decimal separator depends from locale.

// Get list separator. List separator depends from locale.

// Set starting row
int rowNumber = 1;

// Example on SIN() function in formula
sheet.Cell(rowNumber, 0).Value = "SIN(30)";
sheet.Cell(rowNumber, 1).Value = "=SIN(30)";

rowNumber += 2;

// Example on COS() function in formula
sheet.Cell(rowNumber, 0).Value = "COS(30)";
sheet.Cell(rowNumber, 1).Value = "=COS(30)";

rowNumber += 2;

// Example on TAN() function in formula
sheet.Cell(rowNumber, 0).Value = "TAN(30)";
sheet.Cell(rowNumber, 1).Value = "=TAN(30)";

rowNumber += 2;

// Example on ATAN() function in formula
sheet.Cell(rowNumber, 0).Value = "ATAN(0" + dsep + "5)";
sheet.Cell(rowNumber, 1).Value = "=ATAN(0" + dsep + "5)";

rowNumber += 2;

// Example on ATAN2() function in formula
sheet.Cell(rowNumber, 0).Value = "ATAN2(0" + dsep + "3" + lsep + "0.1)";
sheet.Cell(rowNumber, 1).Value = "=ATAN2(0" + dsep + "3" + lsep + "0.1)";

rowNumber += 2;

// Example on ASIN() function in formula
sheet.Cell(rowNumber, 0).Value = "ASIN(0" + dsep + "5)";
sheet.Cell(rowNumber, 1).Value = "=ASIN(0" + dsep + "5)";

rowNumber += 2;

// Example on ACOS() function in formula
sheet.Cell(rowNumber, 0).Value = "ACOS(0" + dsep + "5)";
sheet.Cell(rowNumber, 1).Value = "=ACOS(0" + dsep + "5)";

rowNumber += 2;

// Example on EXP() function in formula
sheet.Cell(rowNumber, 0).Value = "EXP(5)";
sheet.Cell(rowNumber, 1).Value = "=EXP(5)";

rowNumber += 2;

// Example on SQRT() function in formula
sheet.Cell(rowNumber, 0).Value = "SQRT(5)";
sheet.Cell(rowNumber, 1).Value = "=SQRT(5)";

rowNumber += 2;

// Example on LN() function in formula
sheet.Cell(rowNumber, 0).Value = "LN(5)";
sheet.Cell(rowNumber, 1).Value = "=LN(5)";

rowNumber += 2;

// Example on LOG10() function in formula
sheet.Cell(rowNumber, 0).Value = "LOG10(5)";
sheet.Cell(rowNumber, 1).Value = "=LOG10(5)";

rowNumber += 2;

// Example on SUM() function in formula
sheet.Cell(rowNumber, 0).Value = "SUM(5" + lsep + "3)";
sheet.Cell(rowNumber, 1).Value = "=SUM(5" + lsep + "3)";

rowNumber += 2;

// Example on PRODUCT() function in formula
sheet.Cell(rowNumber, 0).Value = "PRODUCT(5" + lsep + "3)";
sheet.Cell(rowNumber, 1).Value = "=PRODUCT(5" + lsep + "3)";

rowNumber += 2;

// Example on VAR() function in formula
sheet.Cell(rowNumber, 0).Value = "VAR(5" + lsep + "3)";
sheet.Cell(rowNumber, 1).Value = "=VAR(5" + lsep + "3)";

rowNumber += 2;

// Example on VARP() function in formula
sheet.Cell(rowNumber, 0).Value = "VARP(5" + lsep + "3)";
sheet.Cell(rowNumber, 1).Value = "=VARP(5" + lsep + "3)";

rowNumber += 2;

// Example on STDEV() function in formula
sheet.Cell(rowNumber, 0).Value = "STDEV(5" + lsep + "3)";
sheet.Cell(rowNumber, 1).Value = "=STDEV(5" + lsep + "3)";

rowNumber += 2;

// Example on STDEVP() function in formula
sheet.Cell(rowNumber, 0).Value = "STDEVP(5" + lsep + "3)";
sheet.Cell(rowNumber, 1).Value = "=STDEVP(5" + lsep + "3)";

rowNumber += 2;

// Example on AVERAGE() function in formula
sheet.Cell(rowNumber, 0).Value = "AVERAGE(50" + lsep + "30)";
sheet.Cell(rowNumber, 1).Value = "=AVERAGE(50" + lsep + "30)";

rowNumber += 2;

// Example on MIN() function in formula
sheet.Cell(rowNumber, 0).Value = "MIN(50" + lsep + "30)";
sheet.Cell(rowNumber, 1).Value = "=MIN(50" + lsep + "30)";

rowNumber += 2;

// Example on MAX() function in formula
sheet.Cell(rowNumber, 0).Value = "MAX(50" + lsep + "30)";
sheet.Cell(rowNumber, 1).Value = "=MAX(50" + lsep + "30)";

rowNumber += 2;

// Example on PI() function in formula
sheet.Cell(rowNumber, 0).Value = "PI()";
sheet.Cell(rowNumber, 1).Value = "=PI()";

rowNumber += 2;

// Example on ABS() function in formula
sheet.Cell(rowNumber, 0).Value = "ABS(-5)";
sheet.Cell(rowNumber, 1).Value = "=ABS(-5)";

rowNumber += 2;

// Example on RAND() function in formula
sheet.Cell(rowNumber, 0).Value = "RAND()";
sheet.Cell(rowNumber, 1).Value = "=RAND()";

rowNumber += 2;

// Example on MOD() function in formula
sheet.Cell(rowNumber, 0).Value = "MOD(10" + dsep + "8" + lsep + "2)";
sheet.Cell(rowNumber, 1).Value = "=MOD(10" + dsep + "8" + lsep + "2)";

rowNumber += 2;

// Example on INT() function in formula
sheet.Cell(rowNumber, 0).Value = "INT(10" + dsep + "8)";
sheet.Cell(rowNumber, 1).Value = "=INT(10" + dsep + "8)";

rowNumber += 2;

// Example on SIGN() function in formula
sheet.Cell(rowNumber, 0).Value = "SIGN(10" + dsep + "8)";
sheet.Cell(rowNumber, 1).Value = "=SIGN(10" + dsep + "8)";

rowNumber += 2;

// Example on ROUND() function in formula
sheet.Cell(rowNumber, 0).Value = "ROUND(10" + dsep + "862456" + lsep + "4)";
sheet.Cell(rowNumber, 1).Value = "=ROUND(10" + dsep + "862456" + lsep + "4)";

rowNumber += 2;

// Example on RADIANS() function in formula

rowNumber += 2;

// Example on DEGREES() function in formula
sheet.Cell(rowNumber, 0).Value = "DEGREES(3" + dsep + "14)";
sheet.Cell(rowNumber, 1).Value = "=DEGREES(3" + dsep + "14)";

rowNumber += 2;

// Example on LEN() function in formula
sheet.Cell(rowNumber, 0).Value = "LEN(\"Bytescout\")";
sheet.Cell(rowNumber, 1).Value = "=LEN(\"Bytescout\")";

rowNumber += 2;

// Example on MID() function in formula
sheet.Cell(rowNumber, 0).Value = "MID(\"Bytescout\"" + lsep + "5" + lsep + "5)";
sheet.Cell(rowNumber, 1).Value = "=MID(\"Bytescout\"" + lsep + "5" + lsep + "5)";

rowNumber += 2;

// Example on NOW() function in formula
sheet.Cell(rowNumber, 0).Value = "NOW()";
sheet.Cell(rowNumber, 1).Value = "=NOW()";

rowNumber += 2;

// Example on DATE() function in formula
sheet.Cell(rowNumber, 0).Value = "DATE(2009" + lsep + "1" + lsep + "2)";
sheet.Cell(rowNumber, 1).Value = "=DATE(2009" + lsep + "1" + lsep + "2)";

rowNumber += 2;

// Example on TIME() function in formula
sheet.Cell(rowNumber, 0).Value = "TIME(1" + lsep + "1" + lsep + "2)";
sheet.Cell(rowNumber, 1).Value = "=TIME(1" + lsep + "1" + lsep + "2)";

rowNumber += 2;

// Example on SECOND() function in formula
sheet.Cell(rowNumber, 0).Value = "SECOND(\"18:45:02\")";
sheet.Cell(rowNumber, 1).Value = "=SECOND(\"18:45:02\")";

rowNumber += 2;

// Example on MINUTE() function in formula
sheet.Cell(rowNumber, 0).Value = "MINUTE(\"18:45:02\")";
sheet.Cell(rowNumber, 1).Value = "=MINUTE(\"18:45:02\")";

rowNumber += 2;

// Example on HOUR() function in formula
sheet.Cell(rowNumber, 0).Value = "HOUR(\"18:45:02\")";
sheet.Cell(rowNumber, 1).Value = "=HOUR(\"18:45:02\")";

rowNumber += 2;

// Example on YEAR() function in formula
sheet.Cell(rowNumber, 0).Value = "YEAR(NOW())";
sheet.Cell(rowNumber, 1).Value = "=YEAR(NOW())";

rowNumber += 2;

// Example on MONTH() function in formula
sheet.Cell(rowNumber, 0).Value = "MONTH(NOW())";
sheet.Cell(rowNumber, 1).Value = "=MONTH(NOW())";

rowNumber += 2;

// Example on DAY() function in formula
sheet.Cell(rowNumber, 0).Value = "DAY(NOW())";
sheet.Cell(rowNumber, 1).Value = "=DAY(NOW())";

rowNumber += 2;

// Example on WEEKDAY() function in formula
sheet.Cell(rowNumber, 0).Value = "WEEKDAY(NOW())";
sheet.Cell(rowNumber, 1).Value = "=WEEKDAY(NOW())";

rowNumber += 2;

// Example on FALSE in formula
sheet.Cell(rowNumber, 0).Value = "FALSE";
sheet.Cell(rowNumber, 1).Value = "=FALSE";

rowNumber += 2;

// Example on TRUE in formula
sheet.Cell(rowNumber, 0).Value = "TRUE";
sheet.Cell(rowNumber, 1).Value = "=TRUE";

rowNumber += 2;

// Example on AND() function in formula
sheet.Cell(rowNumber, 0).Value = "AND";
sheet.Cell(rowNumber, 1).Value = "=AND(10>1" + lsep + "10<100)";

rowNumber += 2;

// Example on OR() function in formula
sheet.Cell(rowNumber, 0).Value = "OR(10>1" + lsep + "10<100)";
sheet.Cell(rowNumber, 1).Value = "=OR(10>1" + lsep + "10<100)";

rowNumber += 2;

// Example on NOT() function in formula
sheet.Cell(rowNumber, 0).Value = "NOT(1+1=2)";
sheet.Cell(rowNumber, 1).Value = "=NOT(1+1=2)";

rowNumber += 2;

// Example on ISNA() function in formula
sheet.Cell(rowNumber, 0).Value = "ISNA(NA())";
sheet.Cell(rowNumber, 1).Value = "=ISNA(NA())";

rowNumber += 2;

// Example on NA() function in formula
sheet.Cell(rowNumber, 0).Value = "NA()";
sheet.Cell(rowNumber, 1).Value = "=NA()";

rowNumber += 2;

// Example on ISERROR() function in formula
sheet.Cell(rowNumber, 0).Value = "ISERROR(1/0)";
sheet.Cell(rowNumber, 1).Value = "=ISERROR(1/0)";

rowNumber += 2;

// Example on ROW() function in formula
sheet.Cell(rowNumber, 0).Value = "ROW()";
sheet.Cell(rowNumber, 1).Value = "=ROW()";

rowNumber += 2;

// Example on COLUMN() function in formula
sheet.Cell(rowNumber, 0).Value = "COLUMN()";
sheet.Cell(rowNumber, 1).Value = "=COLUMN()";

rowNumber += 2;

// Example on COUNT() function in formula
sheet.Cell(rowNumber, 0).Value = "COUNT(B1:B10)";
sheet.Cell(rowNumber, 1).Value = "=COUNT(B1:B10)";

rowNumber += 2;

// Example on COUNTA() function in formula
sheet.Cell(rowNumber, 0).Value = "COUNTA(B1:B10)";
sheet.Cell(rowNumber, 1).Value = "=COUNTA(B1:B10)";

rowNumber += 2;

// Example on COUNTA() function in formula
sheet.Cell(rowNumber, 0).Value = "IF(1=1" + lsep + "TRUE" + lsep + "FALSE)";
sheet.Cell(rowNumber, 1).Value = "=IF(1=1" + lsep + "TRUE" + lsep + "FALSE)";

rowNumber += 2;

// Example on COUNTA() function in formula
sheet.Cell(rowNumber, 0).Value = "NPV(10%" + lsep + "10000" + lsep + "1000" + lsep + "2000" + lsep + "300)";
sheet.Cell(rowNumber, 1).Value = "=NPV(10%" + lsep + "10000" + lsep + "1000" + lsep + "2000" + lsep + "300)";

try
{
System.IO.File.Delete("output.xls");
}
catch (Exception ex)
{
}