This is a migrated thread and some comments may be shown as answers.

Spreadsheet named rows or columns

3 Answers 183 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Brian
Top achievements
Rank 1
Brian asked on 24 May 2016, 07:14 PM
Is there a way to get a list of values in all cells that are in a named column or row.  Similar functionality to what is in spreadprocessing named ranges.

3 Answers, 1 is accepted

Sort by
0
Nencho
Telerik team
answered on 27 May 2016, 12:13 PM
Hello Brian,

I am not exactly sure about what exactly you are trying to achieve.However, you can get a range of cells, using the Client API of the control and get_input on the separate cells, in order to get the separate values.

Please refer to the following documentation, where these and other functions are listed:

http://docs.telerik.com/devtools/aspnet-ajax/controls/spreadsheet/client-side-programming/objects/spreadsheetrange

Regards,
Nencho
Telerik
Do you need help with upgrading your ASP.NET AJAX, WPF or WinForms projects? Check the Telerik API Analyzer and share your thoughts.
0
Brian
Top achievements
Rank 1
answered on 31 May 2016, 02:15 PM

is there a way to name the cell range, then use get_range to get the values using the name instead of A1 or A1:B3 as in your example?

0
Ivan Danchev
Telerik team
answered on 03 Jun 2016, 08:21 AM
Hello Brian,

The range cannot be named and also the get_range() method expects A1 or RC notation so it won't be able to return a valid range if you call it with an arbitrary string.

Regards,
Ivan Danchev
Telerik
Do you need help with upgrading your ASP.NET AJAX, WPF or WinForms projects? Check the Telerik API Analyzer and share your thoughts.
Tags
Spreadsheet
Asked by
Brian
Top achievements
Rank 1
Answers by
Nencho
Telerik team
Brian
Top achievements
Rank 1
Ivan Danchev
Telerik team
Share this question
or