Excel - SetSelection

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

Find more posts tagged with

Accepted answers

All comments

Ben Campbell

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

Alexander Kappes

Dear Ben,

SetSelection is working fine in 10.1.3 and also in each other BOARD Release.

I was also able to use the Fiscal Year without any problem.

My general suggestion will be using the Excel Formular Assistant to create the SetSelection or SetSelectionWithRefresh Statement. In my opinion it´s much more easier

Hope it helps

regards

Alex

Björn Reuber

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

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

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

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