Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I try to fix the selection fields on each sheet of my file .qvw
I have thought about doing a right click on the selection field and check "always a selected value" so that when I close and then open my document, selection is not moving, thought it does not answer (well partially.... only on sheet number 1) to my problem. Indeed, the selection fields that I want to fix are not the same from one sheet to another.
Someone can help me?
Thank you in advance,
Prees
u can use book mark for that..
The easiest solutions is to use bookmarks. Use a bookmark for each sheet. Then add actions to the OnActivate and OnLeave triggers of the sheets. The action for the OnActivate trigger is an Apply Bookmark action to apply the relevant bookmark for the sheet. Use the OnLeave trigger in combination with a Replace Bookmark action to store the selections to the sheet bookmark on leaving the sheet.
Ok thank you, it works when I use a bookmark for each sheet.
But what is the OnActivate and OnLeave triggers of the sheets ? Did you screenshots for example ?
Ok thank you.
Right click a sheet and choose Properties to open the properties window of the sheet. Then go to the Triggers tab. You'll see two buttons that you can click to add actions to the triggers. When you click on one of the buttons a dialog opens where you can add actions to the trigger. Click the Add button. Then choose Bookmark in the left side listbox. Next choose Apply Bookmark (for the OnActivateSheet trigger) or Replace Bookmark (for the OnLeaveSheet trigger. Finally enter the bookmark id of the relevant bookmark. Click the OK buttons of the dialogs to apply the changes you've made.
I want to make a bookmark for each sheet but it does not work. I realize that the bookmark I created is active for all the leaves and it's not what I wanted to do ... I would like to select a specific time period for one sheet, just one.
See my post above.