R – WPF toolkit datagrid spreadsheet

datagridspreadsheettoolkitwpf

I would like to add excel spreadsheet functionality to the WPF toolkit datagrid, can this be done?

I am building a wpf client-server application and I want client tohave wpf toolkit datagrid cells which would behave like excel spreadsheet cells would behave… Meaning they would have formulas and such… just like the spreadsheet would.

I am trying to accomplish this without the usage of Farpoint datagrid product that i already use for a winforms client-server application.

Thanks.

Best Answer

Did you have a look at Clear Office? It is similar to farpoint but written in WPF. Very easy to use. No COM interop.

Related Solutions

WPF datagrid empty row at bottom

Sounds like you probably have CanUserAddRows set to true for the DataGrid. Just add

CanUserAddRows="false"

to the XAML.

C# – How to resize WPF DataGrid to fit its content

I just came out of the same problem where I had to give options in a data grid's column to fit its width as per the content of both header and cell. I used the following code:

private void FitToContent()
    {
        // where dg is my data grid's name...
        foreach (DataGridColumn column in dg.Columns)
        {
            //if you want to size your column as per the cell content
            column.Width = new DataGridLength(1.0, DataGridLengthUnitType.SizeToCells);
            //if you want to size your column as per the column header
            column.Width = new DataGridLength(1.0, DataGridLengthUnitType.SizeToHeader);
            //if you want to size your column as per both header and cell content
            column.Width = new DataGridLength(1.0, DataGridLengthUnitType.Auto);
        }
    }

Also I provided an option on columns to fit as per the display (datagrid's width). for that I used the same code above with the following minor change:

column.Width = new DataGridLength(1.0, DataGridLengthUnitType.Star);

FOR ALL COLUMNS : Make sure you keep HorizontalScrollVisibility to Auto.

Best Answer

Related Solutions

WPF datagrid empty row at bottom

C# – How to resize WPF DataGrid to fit its content

Related Topic