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

Spreadsheet - Defined Name for Formulas

3 Answers 65 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Lee
Top achievements
Rank 1
Lee asked on 06 May 2016, 01:37 PM

I want to be able to use Defined Name when creating my spreadsheet so that I can use them in formulas.  IE instead of having to create a formula that is

= SUM(A1:A20)   I define A1 to A20 a name "Period1" and then I can do things like = SUM(Period1 Apples)  etc.  How do you create the Defined Names in the Spreadsheet and does the formulas then support this feature.  Also when exporting the spreadsheet to excel do the formulas and names export?

Thanks

Lee

3 Answers, 1 is accepted

Sort by
0
T. Tsonev
Telerik team
answered on 10 May 2016, 02:43 PM
Hi,

Defined names are currently not supported. We're working on them and they'll be enabled soon, hopefully in the upcoming Service Pack releases.

Regards,
T. Tsonev
Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
Derek
Top achievements
Rank 1
answered on 20 May 2016, 10:53 AM

Hi Lee

I have defined names in my sheets but you have to create them in Excel first, but widget support for creating the names would be optimal.

Regards

Derek

0
T. Tsonev
Telerik team
answered on 23 May 2016, 02:18 PM
Hi,

Indeed. I've created an issue on our public repo so you can track our progress here.

Regards,
T. Tsonev
Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
Spreadsheet
Asked by
Lee
Top achievements
Rank 1
Answers by
T. Tsonev
Telerik team
Derek
Top achievements
Rank 1
Share this question
or