C#

using System;
using System.Text.RegularExpressions;

namespace ThrowAway
{
  public class TMain
  {
    [STAThread]
    public static void Main()
    {
      Regex compiled1 = new Regex( "(a(b)+)+", RegexOptions.Compiled );
      Regex compiled2 = new Regex( "(a(b)+)+", RegexOptions.Compiled );
      Regex noncompiled1 = new Regex( "(a(b)+)+" );
      Regex noncompiled2 = new Regex( "(a(b)+)+" );
      Console.WriteLine( compiled1 == compiled2 );              // Writes False
      Console.WriteLine( compiled1.Equals( compiled2 ) );       // Writes False
      Console.WriteLine( compiled1 == noncompiled1 );           // Writes False
      Console.WriteLine( compiled1.Equals( noncompiled1 ) );    // Writes False
      Console.WriteLine( noncompiled1 == noncompiled2 );        // Writes False
      Console.WriteLine( noncompiled1.Equals( noncompiled2 ) ); // Writes False
    }
  }
}

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 />