//-------------------------------------------------------------------//
private static object ExcelDateArray2QMonth(Array a)
{
var dim1 = a.GetLength(0);
if (a.Rank == 1)
{
var res = new QMonth[dim1];
for (var i = 0; i < dim1; i++)
{
res[i] = (QMonth)ExcelDate2QMonth(a.GetValue(i));
}
return(res);
}
var dim2 = a.GetLength(1);
var r = new object[dim2]; //two dimensional array
for (var i = 0; i < dim2; i++)
{
var elem = new QMonth[dim1];
for (var j = 0; j < dim1; j++)
{
elem[j] = (QMonth)ExcelDate2QMonth(a.GetValue(j, i));
}
r[i] = elem;
}
return(r);
}
public void testQMonthFromString()
{
Assert.AreEqual(new QMonth(-60), QMonth.FromString("1995.01m"));
Assert.AreEqual(new QMonth(-54), QMonth.FromString("1995.07m"));
Assert.AreEqual(new QMonth(0), QMonth.FromString("2000.01m"));
Assert.AreEqual(new QMonth(66), QMonth.FromString("2005.07m"));
Assert.AreEqual(new QMonth(120), QMonth.FromString("2010.01m"));
Assert.AreEqual(new QMonth(int.MinValue), QMonth.FromString(null));
Assert.AreEqual(new QMonth(int.MinValue), QMonth.FromString(""));
Assert.AreEqual(new QMonth(int.MinValue), QMonth.FromString("0Nm"));
}
