No this has not been implemented. The Excel Workbook is meant for saving and loading Excel workbook files and so the worksheetcell value will not accept a value that cannot be serialized to that format which is why you got an exception when you tried to set your custom object type. Similarly the spreadsheet is a control for displaying and editing our Excel Workbook and so the editor used for in-place editing needs to be able to edit multiple types of values (e.g. formulas, numbers, dates, percent, fraction, plain text, formatted text, errors, etc). Perhaps it might be better to use a grid control (e.g. XamDataGrid) where you can control the data type for the column and control the elements used to display and edit that value (e.g. using a TemplateField).

Hi,

Is this functionality available in current version?

Hello guypld,

I am just checking if you have any further questions on this matter. Please do not hesitate to let me know if you do.

Hello guypld,

After working on the functionality that you are trying to achieve and doing some research, the to place a UserControl in the cells of the XamSpreadSheet has been determined to be a new product idea. You can suggest new Product Ideas for future versions (or vote for existing ones) at http://ideas.infragistics.com.

Steps to create your idea:

1.            Log into the Infragistics Product Ideas site at http://ideas.infragistics.com (creating a new login if needed).

2.            Navigate to the product / platform channel of your choice (e.g. WPF, Windows Forms, ASP.NET, HTML5 / Ignite UI, iOS / NucliOS, etc.)

3.            Add your product idea and be sure to be specific and provide as much detail as possible.

•             Explain the context in which a feature would be used, why it is needed, why it can’t be accomplished today, and who would benefit from it. You can even add screenshots to build a stronger case. Remember that for your suggestion to be successful, you need other members of the community to vote for it. Be convincing!

•             [CASE: “Reference case [case number], FORUMS: “Include a link to this thread”] in your idea so product management will be able to look back at this case. 

The benefits of submitting the product idea yourself include:

-              Direct communication with our product management team regarding your product idea.

-              Notifications whenever new information regarding your idea becomes available.

Additional benefits of the Product Idea system include:

-              Ability to vote on your favorite product ideas to let us know which ones are the most important to you.  You will have ten votes for this and can change which ideas you are voting for at any time.

-              Allow you to shape the future of our products by requesting new controls and products altogether.

-              You and other developers can discuss existing product ideas with members of our Product Management team.

The product ideas site allows you to track the progress of your ideas at any time, see how many votes it got, read comments from other developers in the community, and see if someone from the product team has additional questions for you.

Thank you for contacting Infragistics.

Hi,

I just want to replace each cell with my own User Control and bind it to the Cell Value.

Take this for example:

xamSpreadsheet1.Workbook.Worksheets[0].Rows[0].Cells[0].Value

Value is an Object, so it can be get Int32 and Strings, but when I'm trying to assign to it my own class (with ToString override) its not working and I get exception

("Additional information: XamSpreadsheet.MyPoint is not a supported cell value type.").

So I'm asking if its possible to change the Cells to be cutom user control (and not the default textbox), and make it bind to a custom class (to be the Cell Value).

Thanks!