I am using your product through LogiXML 9 to populate an Excel Template. This report used to work with the prior release, but now I encounter the following error
Message: Error in Cell: P561-Invalid formula:"=SUMIF(#REF!:OFFSET(T562,-1,0),1,#REF!:OFFSET(P562,-1,0))". |
Source: Aspose.Cells |
Stack Trace: at Aspose.Cells.ਾ.ి(Cell ) at Aspose.Cells.Cell.set_Formula(String value) at Aspose.Cells.Cell.(UInt16 ਜ, Int32 ௯, UInt16 ) at Aspose.Cells.Cells.DeleteRows(Int32 rowIndex, Int32 rowNumber) at Aspose.Cells.Cells.DeleteRow(Int32 rowIndex) at rdExcelTemplate.rdExcelTemplate.a() at rdExcelTemplate.rdExcelTemplate.subMakeExcel(XmlElement xmlTemplateDefinition, XmlDocument xmlDataSource) at rdServer.rdTemplate.sBuildTemplateReport(XmlDocument xmlSettings) at rdServer.ResponseBuilder.BuildResponse() |
I am using the SUMIF function to calculate group and grand totals for a few columns. The "REF1" used to point to the starting lines of the data set.
Any suggestions?
Thanks,
Troy