Hi There,
We are developing a WPF application with the following requirements,
1. The Microsoft Excel like User Interface needed
2. Few cells user should be allowed to enter values, and other cells should not allowed to edit since those are formula cells (values of those cells should calculate automatically, like in MS Excel)
3. A row can have few child rows it should be collapsable/expandable by user.
4. Also if user click on the header of the column (or some link near by column header) from the behind that column two/three more columns should side out (of course there should be an option to slide in)
5. All these values (including formula for the read only cells) should be from database, and after user done his/her change should be able to save the changed data back to database.
I tried this first using Syncfusion's GridControl (with FormulaCell as cell type) it does n't have the collapse/expand of rows/column. The with GridTreeControl that doesn't allow the user to edit the cells.
Please see this link for more info (
http://www.syncfusion.com/support/forums/xlsio-wpf/80752/embed-excel-sheet-wpf-app) It would be better if you give some lights on how do we implement the expand/collapse of rows/columns in the GridControl. Please reply ASAP. Sample code would really help us.
Thanks in advance,
Xavier
