radSpreadSheet Cell name

Miss leah
Miss leah used Ask the Experts™
on
In radSpreadSheet how can I set a cell value by its name? meaning excel cell "B1" for example
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Kyle AbrahamsSenior .Net Developer

Commented:
From:
https://demos.telerik.com/aspnet-ajax/spreadsheet/examples/disableenablecells/defaultcs.aspx
and
https://docs.telerik.com/devtools/aspnet-ajax/controls/spreadsheet/client-side-programming/objects/spreadsheetrange


ClientSide:
 var spreadsheet = $find("<%= RadSpreadsheet1.ClientID %>");
        var range = spreadsheet.get_activeSheet().get_range("B1");
        range.set_value(23.05);   

Open in new window


ServerSide:
I would try setting the active cell if it's not readonly.  Then modify the cell value from there.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial