Embed excel sheet WPF App

Hi Xavier,

Thank you for your interest in Syncfusion products.

It is not possible to embed an excel sheet in a WPF Window. But you can make use of a GridView to view and edit the document (and save it back). Please refer to the sample in the location below that explains viewing the contents in a GridView:

My Documents\Syncfusion\EssentialStudio\7.1.0.30\WPF\XlsIO.WPF\Samples\3.5\WindowsSamples\Data Management\Compute Specific Formula\

Regards,
Geetha

Geetha,
Thanks for your quick reply.

My requirement is,
User should be able to edit the value in few cells, based on these value the other cells(which should not be editable) value should be calculated (formula will be stored in database). Is it possible using GridControl? and in GridControl whether the Rows/Columns can be grouped (like we do in MS excel)

Please provide sample code with Gridcontrol

Thanks,
Xavier

Hi Xavier,

Thanks for using Syncfusion Products.

Yes, You can use our Cell-oriented GridControl for showing an excel-like sheet. With our new released version, we have a sample that shows an Excel-UI Grid, which shows UI like an Excel sheet. Please download it and check out the samples,

http://www.syncfusion.com/downloads/latestversion/default.aspx

The GridControl has extensive support for Formula cells too. You can parse any Excel formula using Formula CellType. There are lots of default CellTypes that comes with the GridControl. Please check it out and let me know if you want any details on using this.

Thanks,
Fahad
Grid.WPF Team
Syncfusion Inc.,

Thanks for your Fahad,
Now I am able to set the FormulaCell for the grid, which dynamically calculates the value.
Is it possible in this grid to Expand/Collapse rows (like in TreeView control) by clicking on "+/-" sign in a row.

Any help is greatly appreciated.

Hi Xavier,

Thanks for the details. Yes, you could make the Grid have +/- symbols appear like the Tree Control. You would have to override the cell renderers and provide custom logic on your grouping. If you have the source code version, then you could check the GridTreeControl that emulates this behavior. Let me know if you want any specific requirements of this code that needs to be elaborated.

Thanks,
Fahad
Grid.WPF Team
Syncfusion Inc.,

Thanks Fahad,
I had a look at the sample in the source code version. It has the dynamic binding (user not allowed to edit)
What we need is this,
1. User should be edit few cells in the grid, but some cells has the formula those values based on the value in the editable cell (like in MS Excel) and the formula cell should be read only(user should not edit that)
2. User can group some rows or columns like in MS Excel

Please guide me in right direction which control i can use both "formulacell" end collapse/expand functionality.

Let me know if you have some sample on this.

Hi Xavier,

Thanks for the details. We have created a Direct-trac incident for you. We would be following up on that. Please let me know if you want any more details.

Thanks,
Fahad
Grid.WPF
Syncfusion Inc.,