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.
88 lines
3.5 KiB
C#
88 lines
3.5 KiB
C#
using System;
|
|
using ClosedXML.Excel;
|
|
using NUnit.Framework;
|
|
using DocumentFormat.OpenXml;
|
|
|
|
namespace ClosedXML_Tests.Excel
|
|
{
|
|
/// <summary>
|
|
/// Summary description for UnitTest1
|
|
/// </summary>
|
|
[TestFixture]
|
|
public class ExtensionsTests
|
|
{
|
|
[Test]
|
|
public void FixNewLines()
|
|
{
|
|
Assert.AreEqual("\n".FixNewLines(), Environment.NewLine);
|
|
Assert.AreEqual("\r\n".FixNewLines(), Environment.NewLine);
|
|
Assert.AreEqual("\rS\n".FixNewLines(), "\rS" + Environment.NewLine);
|
|
Assert.AreEqual("\r\n\n".FixNewLines(), Environment.NewLine + Environment.NewLine);
|
|
}
|
|
|
|
[Test]
|
|
public void DoubleSaveRound()
|
|
{
|
|
Double value = 1234.1234567;
|
|
Assert.AreEqual(value.SaveRound(), Math.Round(value, 6));
|
|
}
|
|
|
|
[Test]
|
|
public void DoubleValueSaveRound()
|
|
{
|
|
Double value = 1234.1234567;
|
|
Assert.AreEqual(new DoubleValue(value).SaveRound().Value, Math.Round(value, 6));
|
|
}
|
|
|
|
[TestCase("NoEscaping", ExpectedResult = "NoEscaping")]
|
|
[TestCase("1", ExpectedResult = "'1'")]
|
|
[TestCase("AB-CD", ExpectedResult = "'AB-CD'")]
|
|
[TestCase(" AB", ExpectedResult = "' AB'")]
|
|
[TestCase("Test sheet", ExpectedResult = "'Test sheet'")]
|
|
[TestCase("O'Kelly", ExpectedResult = "'O''Kelly'")]
|
|
[TestCase("A2+3", ExpectedResult = "'A2+3'")]
|
|
[TestCase("A\"B", ExpectedResult = "'A\"B'")]
|
|
[TestCase("A!B", ExpectedResult = "'A!B'")]
|
|
[TestCase("A~B", ExpectedResult = "'A~B'")]
|
|
[TestCase("A^B", ExpectedResult = "'A^B'")]
|
|
[TestCase("A&B", ExpectedResult = "'A&B'")]
|
|
[TestCase("A>B", ExpectedResult = "'A>B'")]
|
|
[TestCase("A<B", ExpectedResult = "'A<B'")]
|
|
[TestCase("A.B", ExpectedResult = "A.B")]
|
|
[TestCase(".", ExpectedResult = "'.'")]
|
|
[TestCase("A_B", ExpectedResult = "A_B")]
|
|
[TestCase("_", ExpectedResult = "_")]
|
|
[TestCase("=", ExpectedResult = "'='")]
|
|
[TestCase("A,B", ExpectedResult = "'A,B'")]
|
|
[TestCase("A@B", ExpectedResult = "'A@B'")]
|
|
[TestCase("(Test)", ExpectedResult = "'(Test)'")]
|
|
[TestCase("A#", ExpectedResult = "'A#'")]
|
|
[TestCase("A$", ExpectedResult = "'A$'")]
|
|
[TestCase("A%", ExpectedResult = "'A%'")]
|
|
[TestCase("ABC1", ExpectedResult = "'ABC1'")]
|
|
[TestCase("ABCD1", ExpectedResult = "ABCD1")]
|
|
[TestCase("R1C1", ExpectedResult = "'R1C1'")]
|
|
[TestCase("A{", ExpectedResult = "'A{'")]
|
|
[TestCase("A}", ExpectedResult = "'A}'")]
|
|
[TestCase("A`", ExpectedResult = "'A`'")]
|
|
[TestCase("Русский", ExpectedResult = "Русский")]
|
|
[TestCase("日本語", ExpectedResult = "日本語")]
|
|
[TestCase("한국어", ExpectedResult = "한국어")]
|
|
[TestCase("Slovenščina", ExpectedResult = "Slovenščina")]
|
|
[TestCase("", ExpectedResult = "")]
|
|
[TestCase(null, ExpectedResult = null)]
|
|
public string CanEscapeSheetName(string sheetName)
|
|
{
|
|
return StringExtensions.EscapeSheetName(sheetName);
|
|
}
|
|
|
|
[TestCase("TestSheet", ExpectedResult = "TestSheet")]
|
|
[TestCase("'Test sheet'", ExpectedResult = "Test sheet")]
|
|
[TestCase("'O''Kelly'", ExpectedResult = "O'Kelly")]
|
|
public string CanUnescapeSheetName(string sheetName)
|
|
{
|
|
return StringExtensions.UnescapeSheetName(sheetName);
|
|
}
|
|
}
|
|
}
|