Thom Lamb
2cd6df6481
Establishes the foundational structure, core Excel functionality, and tooling. - Implements base components for cells, ranges, columns, and rows. - Integrates a custom calculation engine with a wide range of Excel functions. - Adds comprehensive support for styling, conditional formatting, data validation, comments, pictures, and charts. - Configures build setup, project metadata (NuGet), and developer guidelines. - Includes editor and Git attributes for consistent code style and line endings.
95 lines
2.9 KiB
C#
95 lines
2.9 KiB
C#
using ClosedXML.Excel;
|
|
using NUnit.Framework;
|
|
using System;
|
|
using System.Data;
|
|
using System.IO;
|
|
using System.Linq;
|
|
|
|
namespace ClosedXML_Tests.Excel
|
|
{
|
|
public class NumberFormatTests
|
|
{
|
|
[Test]
|
|
public void PreserveCellFormat()
|
|
{
|
|
using (var wb = new XLWorkbook())
|
|
{
|
|
var ws = wb.AddWorksheet("Sheet1");
|
|
|
|
var table = new DataTable();
|
|
table.Columns.Add("Date", typeof(DateTime));
|
|
|
|
for (int i = 0; i < 10; i++)
|
|
{
|
|
table.Rows.Add(new DateTime(2017, 1, 1).AddMonths(i));
|
|
}
|
|
|
|
ws.Column(1).Style.NumberFormat.Format = "yy-MM-dd";
|
|
ws.Cell("A1").InsertData(table);
|
|
Assert.AreEqual("yy-MM-dd", ws.Cell("A5").Style.DateFormat.Format);
|
|
|
|
ws.Row(1).Style.NumberFormat.Format = "yy-MM-dd";
|
|
ws.Cell("A1").InsertData(table.Rows, true);
|
|
Assert.AreEqual("yy-MM-dd", ws.Cell("E1").Style.DateFormat.Format);
|
|
}
|
|
}
|
|
|
|
[Test]
|
|
public void TestExcelNumberFormats()
|
|
{
|
|
using (var wb = new XLWorkbook())
|
|
{
|
|
var ws = wb.AddWorksheet("Sheet1");
|
|
var c = ws.FirstCell()
|
|
.SetValue(41573.875)
|
|
.SetDataType(XLDataType.DateTime);
|
|
|
|
c.Style.NumberFormat.SetFormat("m/d/yy\\ h:mm;@");
|
|
|
|
Assert.AreEqual("10/26/13 21:00", c.GetFormattedString());
|
|
}
|
|
}
|
|
|
|
[Test]
|
|
public void ReadAndWriteColumnNumberFormat()
|
|
{
|
|
using (var memoryStream = new MemoryStream())
|
|
{
|
|
using (var wb = new XLWorkbook())
|
|
{
|
|
var ws = wb.AddWorksheet();
|
|
var sourceColumn = ws.Column(1);
|
|
sourceColumn.Style.NumberFormat.Format = "0.000";
|
|
wb.SaveAs(memoryStream);
|
|
}
|
|
|
|
memoryStream.Position = 0;
|
|
|
|
using (var wb = new XLWorkbook(memoryStream))
|
|
{
|
|
var column = wb.Worksheets.Single().Column(1);
|
|
Assert.AreEqual("0.000", column.Style.NumberFormat.Format);
|
|
}
|
|
}
|
|
}
|
|
|
|
[Test]
|
|
public void XLNumberFormatKey_GetHashCode_IsCaseSensitive()
|
|
{
|
|
var numberFormatKey1 = new XLNumberFormatKey { Format = "MM" };
|
|
var numberFormatKey2 = new XLNumberFormatKey { Format = "mm" };
|
|
|
|
Assert.AreNotEqual(numberFormatKey1.GetHashCode(), numberFormatKey2.GetHashCode());
|
|
}
|
|
|
|
[Test]
|
|
public void XLNumberFormatKey_Equals_IsCaseSensitive()
|
|
{
|
|
var numberFormatKey1 = new XLNumberFormatKey { Format = "MM" };
|
|
var numberFormatKey2 = new XLNumberFormatKey { Format = "mm" };
|
|
|
|
Assert.IsFalse(numberFormatKey1.Equals(numberFormatKey2));
|
|
}
|
|
}
|
|
}
|