EPPlus usage
Commercial use (I have a commercial license)
Environment
Windows 11
Epplus version
8.6.3
Spreadsheet application
Excel
Description
If the OutLineSummaryBelow and OutLineSummaryRight properties on the Worksheet are not explicitly set, the initial values are incorrect.
Example:
using var package = new ExcelPackage();
var worksheet = package.Workbook.Worksheets.Add("Table1");
worksheet.Cells["2:5"].EntireRow.Group();
worksheet.Cells["C:E"].EntireColumn.Group();
worksheet.Cells["A10"].Value = ws.OutLineSummaryBelow;
worksheet.Cells["A11"].Value = ws.OutLineSummaryRight;
As you can see, the cells A10 and A11 contain the value False even though the summary is displayed at the bottom and on the right, respectively, in Excel.
I haven't tried it, but you'll probably need to call this:
return GetXmlNodeBool(“d:sheetPr/d:outlinePr/@summaryBelow”, true);
or
return GetXmlNodeBool(“d:sheetPr/d:outlinePr/@summaryRight”, true);
EPPlus usage
Commercial use (I have a commercial license)
Environment
Windows 11
Epplus version
8.6.3
Spreadsheet application
Excel
Description
If the
OutLineSummaryBelowandOutLineSummaryRightproperties on the Worksheet are not explicitly set, the initial values are incorrect.Example:
As you can see, the cells
A10andA11contain the valueFalseeven though the summary is displayed at the bottom and on the right, respectively, in Excel.I haven't tried it, but you'll probably need to call this:
return GetXmlNodeBool(“d:sheetPr/d:outlinePr/@summaryBelow”, true);or
return GetXmlNodeBool(“d:sheetPr/d:outlinePr/@summaryRight”, true);