Thanks for considering Aspose.
I think I have already answered a few those, please check: http://www.aspose.com/Community/Forums/thread/102203.aspx
I specify the related urls for all your queries here as well, kindly check them:
- Allow User to delete and insert Columns.
- Allow User to insert, delete rows.
Aspose.Grid.Web provides a context menu which has these options. Alternatively you may do it programmatically using the API of Aspose.Grid.Web.i.e. WebCells.DeleteRow(s), WebCells.DeleteColumn methods. Also check: http://www.aspose.com/Wiki/default.aspx/Aspose.Grid/DeleteRowsColumns.html
and for inserting rows /columns, please check wiki topic:
- Allow user to search and replace (multiple).
Yes you may do it, Aspose.Grid.Web offers the related options in its context menu just like MS Office env. Please right-click on the gridweb control at runtime and you may have Find.... Replace Dialog boxes.
Please check: http://www.aspose.com/wiki/default.aspx/Aspose.Grid/SearchingAndReplacing.html
- Allow Dropdown List for specific columns and cells.
If you mean to say AutoFilter feature, Aspose.Grid.Web offers this feature. Please check the related demo: http://www.aspose.com/Products/Aspose.Grid/Demos/Filter/AutoFilter.aspx
Well, Aspose.Grid.Web allows to define dropdowns through data validations only, please check: http://www.aspose.com/Products/Aspose.Grid/Demos/common/dataValidation.aspx
- Allow to mark fixed /stationary/frozen Rows & Columns
Please check the url: http://www.aspose.com/wiki/default.aspx/Aspose.Grid/AGWFreeze.html
and also check the online demos: http://www.aspose.com/Products/Aspose.Grid/Demos/common/FreezePaneCustom.aspx
- Allow users to format data (interger (01, 12,) , decimal (1.2, 0.02, 0.40), date (MM/DD/YYYY)
Please check the wiki topic: http://www.aspose.com/Wiki/default.aspx/Aspose.Grid/FormattingCells.html#NumberFormat
Also you may check the folowing demos:
Please check the folowing demo:
Note: the featured demos http://www.aspose.com/Products/Aspose.Grid/Demos/ are automatically installed when you install using control's Aspose.Grid.MSI installer and you may open the installed asp.net solutions opening into VS.NET.