Feature requests for RadSpreadSheet

[ColinBlakey]

Note sure this is the correct place but I can't seem to find a feature request page in the website so...

Currently we use the Telerik WPF RadGridView to provide an editable grid of data for end users. We have had to add code to provide psuedo row grouping and Excel like navigation, cell formatting is problematic as it only appears that you can specify a 'format' for the column. So our users want an Excel like grid with no row numbers, specific column headers, individual cell formatting and row grouping.

So it looks like the new RadSpreadsheet would provide a better solution (both currently and in the long run) for us but we need the ability at a minimum to ....

1) Hide the row/column headers
2) Protect cells/rows/columns

Nice to have
3) Row grouping (we can probably fake it just like we do in the grid until it's implemented in the control)

I know you cannot specify a timeframe but this is my 10 cents worth of request to move these feature nearer to the top of the list.

Thanks

Colin

[Deyan]

Hello Colin,

First of all I would like to thank you for you interest in our RadSpreadsheet control!

Before going straight to you feature requests, I would like to point out some basic differences between RadGridView and RadSpreadsheet, as these controls are semantically different. While RadGridView is designed to present bound data, RadSpreadsheet is dedicated to operating with files and is not intended to support bound scenarios.

For example, if you have a data table that contains three integer columns and ten rows and you would like to present and bind these 30 numbers to a control, then I encourage you to try RadGridView.

On the other side, if your application utilizes xlsx files and needs to provide the users with Excel like experience, RadSpreadsheet is the right control. 

Now to you feature requests:

1. Currently RadSpreadsheet does not support hiding of row/column headers. We are going to add this to our feature requests list, so I hope this will soon be available.
2. We have already added cells protection in our feature request list and I hope that it will soon be implemented as well.
3. Rows' grouping is also a feature that is already in our future implementation plans.

I hope this sounds good to you! If you have any other questions or concerns please do not hesitate to contact us again!

Regards,
Deyan
the Telerik team

[ColinBlakey]

Hi Deyan.

I understand the differences between the controls, I guess my issue is that we need a hybrid of the two. I've included a screen shot of our hybrid grid for which I was looking to possibly switch out for the spreadsheet control. First, we need to have Excel like navigation, this is what our users (tax users) expect and are used to (the rest of our app is a lot older and uses a COM grid that was tweaked to provide this type of navigation). While I've implemented it in the Telerik RadGridView it's not 100% reliable (it's trying to override most of the default behaviors, so not unexpected), perhaps though my code is not 100%. Second, we need control of cell formatting, not just at the column level, looking at the example, you can see the cell's highlighted in red need to show 2 decimal places for rounding purposes, for the rest of the data we do not need or want to show 2 decimals, unfortunately with the grid I can't get the Post Balancing row to show 2 decimal places when the formatting is to only show 2 decimal places when there are fractions (i.e. it applies to the whole column, so most of the time it should be suppressed). Next the data in blue is data bound, and there can be many more lines of data that is and the calculations at the end, are stored back into the database. Underlined in green are my attempts at row grouping, clicking the buttons, collapses the rows below.

Ideally what I would like is a databound spreadsheet template. Excel navigation as standard, all calculations pre-defined, cell formatting pre-defined, multiple databound areas (blue in my screenshot), hideable row numbers, hideable.changeable column headers, row grouping. Whilst this may be somewhat specialized, I would think that anyone working in the financial software world (where Excel is the go to app for users) would like to be able implement something like this. This is where I see the value in the spreadsheet control, if I want to deal with Excel spreadsheets directly I'm more likely to use Excel and write an addin for it (which we have done).

Thanks

Colin

[Deyan]

Hello Colin,

Thank you for getting back to us with such detailed description on your scenario!

Unfortunately, we currently cannot offer you an easy solution which fully satisfies your scenario's requirements. However, I can assure you that we understand the importance of this scenario and we will take it into account when making our future implementation plans.

Thank you again for contacting us! Do not hesitate to write back to us if you have additional feedback.

Regards,
Deyan
the Telerik team

[Marcus]

Hello Deyan,
searching the forum I found this post. I have the same requirements as Colin for hiding row/column headers. Is it possible in the current SpreadSheet to achive this?

Thanks in advance

Marcus

[Petya]

Hi Marcus,

In Q3 2014 we introduced functionality allowing you to hide the row and column headings, as well as the gridlines in RadSpreadsheet. Check the related help article for more information on the topic.

Let us know if you have other questions.

Regards,
Petya
Telerik

 

 

[Marcus]

Hi Petya

your tipp works fine.
But for sure I have a lot of questions using your spreadsheet-control. Pls see my other posts.

Thanks

Marcus