This project has moved. For the latest updates, please go here.

Error: Cannot access TotalsRow if ShowTotals property is false

Aug 18, 2011 at 8: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

 (templatePath);

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 https://skydrive.live.com/?cid=1bb8850b7f4a9f68&sc=documents&id=1BB8850B7F4A9F68%21185# 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?

Thanks,

Jahedur Rahman

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