ExcelExportCommentTestWithComment.cs

[Test]
public void ExcelExportCapturesCommentsWithFunnyCharacters()
{
	var transaction = new Transaction
	{
		Comment = "\u0001"
	};
	
	var transcationExportBuilderUnderTest = new TransactionExportBuilder();

	transcationExportBuilderUnderTest.AddTransaction(transaction);
	var excelExport = transcationExportBuilderUnderTest.BuildExcelFile();
	
	var actualComment =
		excelExport
			.GetWorkbook("Export")
			.GetColumn("Comment")
			.GetDataInCellAtRow(1);

	// Unicode 0001 is not valid in the XML 1.0 grammar as per https://www.w3.org/TR/xml/#charsets
	Assert.AreEqual(actualComment, "\u0001");
}