Spreadsheet - Defined Name for Formulas

4 posts, 0 answers
  1. Lee
    Lee avatar
    20 posts
    Member since:
    Jun 2014

    Posted 06 May Link to this post

    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

  2. T. Tsonev
    Admin
    T. Tsonev avatar
    2772 posts

    Posted 10 May Link to this post

    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
  3. UI for ASP.NET MVC is VS 2017 Ready
  4. Derek
    Derek avatar
    3 posts
    Member since:
    May 2016

    Posted 20 May in reply to Lee Link to this post

    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

  5. T. Tsonev
    Admin
    T. Tsonev avatar
    2772 posts

    Posted 23 May Link to this post

    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
Back to Top
UI for ASP.NET MVC is VS 2017 Ready