I have multiple pages containing Pivot Tables and Pivot Charts published from Excel. The main makeup of each page is an XML string containing all the information about the Office Web Component objects that are produced from the published Excel file.
I am adding JavaScript code after the published material to manipulate the properties of the OCW objects to filter as I would like. I have also added a "Memorize" button to create cookies based on current filtering values as a result of user interaction.
When I refresh the page, or open another page with the same filtering elements, I have JavaScript code to read the cookies and utilize those values to set the filtering to match the "memorized" values.
The problem that I am having is that, even though the code seems to be reading the cookies properly (based on alerts throughout the code), the final filtering seems to revert back to the previous incarnation of the page.
Could this be due to the previous version of the opened page being stored in some "temporary" space and being used instead of my freshly filtered version?
If so, how do I clear the cached(?) version and reload completely fresh? I believe I may be getting into some new territory (for me) in web pages.
Thanks in advance!
Ray <><
"I was going to change my shirt, but I changed my mind instead." - Winnie the Pooh
I am adding JavaScript code after the published material to manipulate the properties of the OCW objects to filter as I would like. I have also added a "Memorize" button to create cookies based on current filtering values as a result of user interaction.
When I refresh the page, or open another page with the same filtering elements, I have JavaScript code to read the cookies and utilize those values to set the filtering to match the "memorized" values.
The problem that I am having is that, even though the code seems to be reading the cookies properly (based on alerts throughout the code), the final filtering seems to revert back to the previous incarnation of the page.
Could this be due to the previous version of the opened page being stored in some "temporary" space and being used instead of my freshly filtered version?
If so, how do I clear the cached(?) version and reload completely fresh? I believe I may be getting into some new territory (for me) in web pages.
Thanks in advance!
Ray <><
"I was going to change my shirt, but I changed my mind instead." - Winnie the Pooh