Whitespace values being treated as null

[IainDM]

EPPlus usage

Personal use

Environment

Windows

Epplus version

8.4.2

Spreadsheet application

No response

Description

Here are the steps to reproduce it:

1. Create a workbook in Excel with cell A1 on the first sheet = " " (a space, or any whitespace)
2. Open the workbook in EPPlus and test A1.Formula. It will be ="" (empty string, not space).

It seems to be because the Formula setter trims the formula

if (value == null || value.Trim() == "")
{
Value = null;
return;
}

[JanKallman]

Thanks for reporting this. I'll investigate.

[JanKallman]

I cant replicate this issue. Having a workbook with the formula =" " in cell A1, seems to return the correct value...

    using (var package = OpenTemplatePackage("i2320-WhitesspaceFormula.xlsx"))
    {
        var ws = package.Workbook.Worksheets[0];
        Assert.AreEqual("\" \"", ws.Cells["A1"].Formula);
    }