I'm testing out Aspose.Cells as a replacement for Officewriter; I already own Aspose.Words, and it is great. I've pretty much gotten Aspose.Cells to work with my reporting system, except for this one issue. At this point, if you can help me out with this, we'll definitely be making the purchase.
DataTable is being used to populate a template excel sheet that has been converted from the Officewriter formatting (pretty simple global replace of "%%=" with "&="). Import works great, everything is as expected, except that the formulas which are "pushed" down occasionally work, and occasionally do not work. The odd thing is that it is always the same cells' formulas which do or do not work, and I can't see any discernable difference between them--and they all worked in Officewriter.
DataSet Data = this.GetData();//SP Call
WorkbookDesigner wbDesigner = new ac.WorkbookDesigner();
wbDesigner.Open( templatePath );
int currentTableIX = 2;
int maxTableIX = Data.Tables.Count;
while ( currentTableIX < maxTableIX )
currentTable = Data.Tables[currentTableIX];
currentTable.TableName = "D" + currentTableIX;
wbDesigner.SetDataSource( currentTable );
wbDesigner.Process( false );
wbDesigner.Save( filePath );
C# Code Notes:
-The first two datatables are used for something else not shown here.
-In this example, there are two datatables returned of note (D2 and D3 as named in the template).
-D2 has multiple rows, D3 only ever has one row.
-The functions overlap D2-based cells, but not the D3-based cell.
-I will attach both the template and the resultant output file (with financial data stripped).
Thanks in advance,