following example code + test file produces unexpected behavior:
- Code: Select all
using (MemoryStream outputStream = new MemoryStream())
{
Workbook workbook = new Workbook();
workbook.LoadFromFile("Test.xlsx");
workbook.Worksheets[0].SaveToStream(outputStream, ";", Encoding.UTF8);
Console.WriteLine(Encoding.UTF8.GetString(outputStream.ToArray()));
}
IF the formula in column B evaluates to a non-empty string, the generated CSV will render this string as expected.
If the formula in column B evaluates to an empty string, then the generated CSV will render the formula itself instead of an empty string.
Exptected output:
- Code: Select all
Row 1;ok
Row 2;
Generated output:
- Code: Select all
Row 1;ok
Row 2;"=IF(A2=""Row 1"",""ok"","""")"
KR,
Gerhard