Excel - SetSelection

Ben Campbell
Ben Campbell Customer
Third Anniversary 10 Comments Name Dropper
in Platform

Hello,

I am trying to use the SetSelection formula in Excel to control multiple layouts (Board v9). The following formula works: =SetSelection("Finance","Year=2018") but when I try and change the entity to Fiscal Year it fails. I thought it might be because Fiscal Year is technically a custom time entity or because there is a space, but I am not able to use Month either. However, I have tried some non-time entities (with spaces) and that does work.

 

Any ideas?

Thanks 

Answers

  • Ben Campbell
    Ben Campbell Customer
    Third Anniversary 10 Comments Name Dropper

    Current testing Board v10.1.3 and =SetSelection no longer valid

  • Björn Reuber
    Björn Reuber Employee, Community Captain
    500 Likes Fourth Anniversary 100 Comments 5 Answers

    Hi,

     

    tested both (SetSelection and SetSelectionWithRefresh) in 10.1.4 and both functions are working.

    Please keep in mind to use the correct seperators (according to your regional settings) and to refresh the screen, when using SetSelection.Furthermore please use the Code and not the Description of the Entity

    For Testing I used following statement: =SetSelection("Echo";"Year=2011") or =SetSelectionWithRefresh("Echo";"Year=2012"), =SetSelectionWithRefresh("Echo";"Month=201202")

     

    regards

    Björn

  • Samuele Marchetto
    Samuele Marchetto Active Partner
    Third Anniversary 100 Likes 10 Comments 5 Up Votes

    Excel formulas in Board 10.1 works fine. I think your problem is due to old Board version. I had similar problems with Board 8 and I used the macro to update data:

     

    obj.Select "Finance", "Fiscal Year=2017", ActiveSheet

     

    Bye

  • Matthew Brown
    Matthew Brown Customer
    10 Comments Name Dropper Level 200: Building A Planning Solution in Board Level 100: Foundations of Building in Board

    I'm in 14 now and excel doesn't recognize formulas like this when I try and put it next to a layout. Am I missing something?

    =SetSelection("dbname", "Fiscal Year=", M5)

  • Björn Reuber
    Björn Reuber Employee, Community Captain
    500 Likes Fourth Anniversary 100 Comments 5 Answers

    hello @Matthew Brown

    I assume the Selection you want to apply is in M5, correct?

    Have you tried to use

    =SetSelection("dbname", "Fiscal Year= "&M5) ?

    Please keep also in mind, that using SetSelection the screen won't refresh automatically, for this you need the formula SetSelectionWithRefresh

    Regards

    Björn

Categories