Attached is my excel with Smart Markers.
The upper set of data (static, no growing) has no formating problem, but the lower set of data is a growing one. For the lower set of data , if format is set to General, excel is generated without problem. However, whenever I add format to the cells (e.g. Previous Price column ) of the lower set of data, NullReferenceException occurs.
System.NullReferenceException was unhandled by user code
Message="Object reference not set to an instance of an object."
Source="Aspose.Cells"
StackTrace:
at Aspose.Cells.Font.set_Color(Color value)
at Aspose.Cells.Font.֝(Font ֞)
at Aspose.Cells.Style.Copy(Style style)
at Aspose.Cells.Cells.ݕ(Int32 ؇, Int32 ؈)
at Aspose.Cells.Cells.InsertRows(Int32 rowIndex, Int32 rowNumber)
at Aspose.Cells.ExcelDesigner.؆(Worksheet ֲ, Int32 ؇, Int32 ၠ, Int32 ၞ)
at Aspose.Cells.ExcelDesigner.ၝ(Worksheet ֲ, Cell ן, Int32 ၞ, Boolean ၟ)
at Aspose.Cells.ExcelDesigner.Process(Int32 sheetIndex, Boolean isPreserved)
at Savills.OVS.UI.AspNet.PropertyData_Flat_ExportFlat.Page_Load(Object sender, EventArgs e) in d:\SavillsOVS\UI Admin Site\PropertyData\Flat\ExportFlat.aspx.cs:line 81
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Here is my code:
outputDesigner.SetDataSource(p_BlockTable);
outputDesigner.Process(index, false); <-- error occurs here