CheckBox disapears from default value in Excel table

[heurichjo]

EPPlus usage

Noncommercial use

Environment

Windows

Epplus version

8.4.2

Spreadsheet application

Excel

Description

If EPPlus is used to save an *.xlsm-File (empty VBA-Project), the CheckBoxes in Tables are removed as "default values" for new rows.

Initially the tables look the same, but when a new Line is added to the Table only the old Excel-File adds the CheckBoxes. It is not super consistent. In a real project of ours it works in one column, but not in another. Also I tested the small example with an *.xlsx-File and the issue did not occur.

[OssianEPPlus]

We are looking into this! Thanks for reporting the issue

[OssianEPPlus]

We're unable to reproduce your issue.

Generating the file from scratch in Epplus seems to work fine atleast. Here's a code sample:

using (var package = new ExcelPackage())
{
   
    var ws = package.Workbook.Worksheets.Add("VBA Example");
    package.Workbook.CreateVBAProject();

    var table = ws.Tables.Add(ws.Cells["B3:C4"], "Table1");
    table.ShowHeader = true;
    ws.Cells["B4:C4"].Value = false;
    ws.Cells["B4:C4"].Style.Checkbox = true;

    table.AddRow(1);
    //Adjust this if you wish/don't have a temp folder
    string myPath = "C:\\temp\\";

DirectoryInfo outputDir = new DirectoryInfo(myPath);
    package.SaveAs(new FileInfo(outputDir.FullName + @"CheckBoxExample.xlsm"));
}

It does seem to gray them out a bit which is a bit strange. But they're added with the add row and still clearly there.

Are you adding the rows via epplus or in excel itself? Are you importing an xlsx file and exporting .xlsm or are you generating the whole file in Epplus?

Details could speed your case up. Preferably a template file and a code-sample that reproduces the issue,

[OssianEPPlus]

Tried looking into this some more. Still unable to reproduce your case but to help you isolate the issue:

There are two components to checkboxes the Styling element. (Seen above as ws.Cells["B4:C4"].Style.Checkbox = true;)
And the Actual value of the cell it is placed on (see ws.Cells["B4:C4"].Value = false;)

You should verify that both exist for correct checkboxes. We are unsure how you are setting "default values" do you mean a Calculated Column Formula on the table column?
You CAN ensure the Value part of the checkboxes by setting the column formula like this:
table.Columns[0].CalculatedColumnFormula = "FALSE";

That should ensure new inserted rows on the first column have the False value at least