C#

James Gupta wrote:

Why not just comment out the wiring code?

mintguy wrote:

.Buttonclick only allows += and -= it doesn't allow you to reset the handlers without explicitly referencing them with -=.

<br />
private string excelSerialDateToDMY(int serialDate)<br />
{<br />
int nDay;<br />
int nMonth;<br />
int nYear;<br />
// Excel/Lotus 123 have a bug with 29-02-1900. 1900 is not a<br />
// leap year, but Excel/Lotus 123 think it is...<br />
if (serialDate == 60)<br />
{<br />
nDay    = 29;<br />
nMonth    = 2;<br />
nYear    = 1900;<br />
		<br />
return "29/02/1900";<br />
}<br />
else if (serialDate < 60)<br />
{<br />
// Because of the 29-02-1900 bug, any serial date <br />
// under 60 is one off... Compensate.<br />
serialDate++;<br />
}<br />
		<br />
// Modified Julian to DMY calculation with an addition of 2415019<br />
int l = serialDate + 68569 + 2415019;<br />
int n = ( 4 * l ) / 146097;<br />
l = l - ( 146097 * n + 3 ) / 4;<br />
int i = ( 4000 * ( l + 1 ) ) / 1461001;<br />
l = l - ( 1461 * i ) / 4 + 31;<br />
int j = ( 80 * l ) / 2447;<br />
nDay = l - ( 2447 * j ) / 80;<br />
l = j / 11;<br />
nMonth = j + 2 - ( 12 * l );<br />
nYear = 100 * ( n - 49 ) + i + l; <br />
return nDay+"/"+nMonth+"/"+nYear;<br />
}<br />
<br />
public bool inArray(object key, object[] array)<br />
{<br />
for (int c=0; c<array.Length; c++)<br />
{<br />
if (array[c].Equals(key))<br />
return true;<br />
}<br />
return false;<br />
}<br />
<br />
//main code snippet here<br />
string[] dateArray={"dd/mm/yyyy","[$-F800]dddd, mmmm dd, yyyy","dd/mm/yyyy;@","dd/mm/yy;@","d/m/yy;@","d.m.yy;@","yyyy-mm-dd;@","[$-809]dd mmmm yyyy;@","[$-809]d mmmm yyyy;@"};<br />
<br />
//Get a cell in the excel sheet and call it myCell<br />
//get the numberformat of the cell and call it myType<br />
//get the value of the cell<br />
<br />
//if the numberformat is of any of the know date formats then do this<br />
if (inArray(myType.ToString(),dateArray))<br />
{<br />
string retDate=excelSerialDateToDMY(Int32.Parse(myVal.ToString()));<br />
System.Globalization.CultureInfo culture = new System.Globalization.CultureInfo("en-GB");<br />
DateTime myDate = DateTime.Parse(retDate,culture,System.Globalization.DateTimeStyles.NoCurrentDateDefault);	<br />
return myDate.ToShortDateString();<br />
}<br />
//else just return the value of the cell<br />
else <br />
return myVal.ToString();<br />

<FONT color=Blue>string</FONT> strReturndata = <FONT color=Blue>string</FONT><FONT color=DarkBlue>.</FONT>Format<FONT color=DarkBlue>(</FONT>
<FONT color=Maroon>@"Index 2 Settings:</FONT>
<FONT color=Maroon>---------------------</FONT>
<FONT color=Maroon>Oxy = {0)</FONT>
<FONT color=Maroon>BPM= {1}</FONT>
<FONT color=Maroon>Note: Modifying the following 4 variables inhibit oxy display until the next [oxy NN] command</FONT>
<FONT color=Maroon>RAC=610</FONT>
<FONT color=Maroon>IRAC=1000</FONT>
<FONT color=Maroon>RDC=1024</FONT>
<FONT color=Maroon>IRAC=1024</FONT>
<FONT color=Maroon>Light Flash: Unit Under Test</FONT>
<FONT color=Maroon>AC=100%</FONT>
<FONT color=Maroon>AMB=0%</FONT>
<FONT color=Maroon>Make=Nellcor"</FONT>, XX, YY<FONT color=DarkBlue>)</FONT>;