public void VerifyThatExpectedNumberFormatIsReturned()
{
var excelNumberFormatInfo = ExcelNumberFormatProvider.CreateExcelNumberFormatInfo(false, ".", ",");
Assert.AreEqual(".", excelNumberFormatInfo.NumberDecimalSeparator);
Assert.AreEqual(",", excelNumberFormatInfo.NumberGroupSeparator);
}
public void VerifyThatArgumentExceptionsAreThrown()
{
Assert.Throws <ArgumentException>(() => ExcelNumberFormatProvider.CreateExcelNumberFormatInfo(false, null, "."));
Assert.Throws <ArgumentException>(() => ExcelNumberFormatProvider.CreateExcelNumberFormatInfo(false, string.Empty, "."));
Assert.Throws <ArgumentException>(() => ExcelNumberFormatProvider.CreateExcelNumberFormatInfo(false, ".", null));
Assert.Throws <ArgumentException>(() => ExcelNumberFormatProvider.CreateExcelNumberFormatInfo(false, ".", string.Empty));
}
/// <summary>
/// Queries the appropriate <see cref="NumberFormatInfo"/> based on the decimal separator and thousands separator of the excel application
/// </summary>
/// <param name="application">
/// The current excel application object
/// </param>
/// <returns>
/// an instance of <see cref="NumberFormatInfo"/>
/// </returns>
private NumberFormatInfo QuerayNumberFormatInfo(Application application)
{
NumberFormatInfo numberFormatInfo = null;
if (application.UseSystemSeparators)
{
numberFormatInfo = ExcelNumberFormatProvider.CreateExcelNumberFormatInfo(true);
}
else
{
var decimalSeparator = (string)application.International(XlApplicationInternational.xlDecimalSeparator);
var thousandsSeparator = (string)application.International(XlApplicationInternational.xlThousandsSeparator);
numberFormatInfo = ExcelNumberFormatProvider.CreateExcelNumberFormatInfo(false, decimalSeparator, thousandsSeparator);
}
return(numberFormatInfo);
}
public void VerifyThatIfSystemSeparatorsAreUsedExpectedNumberFormatInfoIsReturned()
{
var excelNumberFormatInfo = ExcelNumberFormatProvider.CreateExcelNumberFormatInfo(true);
Assert.AreEqual(",", excelNumberFormatInfo.NumberDecimalSeparator);
}