This project has moved and is read-only. For the latest updates, please go here.

Error: Cannot access TotalsRow if ShowTotals property is false

Aug 18, 2011 at 9:46 AM

hi, I am using ClosedXML for writing into my Excel templates. But I am encountering an error while instantiating the workbook object with below code:

var wb = new XLWorkbook


And the error is: "Cannot access TotalsRow if ShowTotals property is false"

The template  templatePath contains a Table in a worksheet but "Total Row" is not shown. When I check the check box to show this total row, the error is not raised. But I get this when the row is not shown.

The file is placed in my skydrive at and the file name is abc.xlsx.

I do not get this error for a few files though, but getting the same error for some more files having a table in this fashion.

Can anyone please let me know how to resolve this error?


Jahedur Rahman

Aug 18, 2011 at 4:20 PM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.