I am using Aspose.Excel component for few of our web based report in ASP.NET. There is a typical requirement to display few float values in 1.00, 2.30 etc format. If I send float value to excel report it converts them to 1, 2.3 . I can acive this by sending text values, but in that case all cells are marked with some green triangle saying “error in cell” which looks bad. Is there any way to format a cell in Aspose.Excel in C#.
Looking forward your response
To format a cell, please check http://www.aspose.com/wiki/Default.aspx/Aspose.Excel/ .
Could you please post your file here to show those green triangle errors?