Search results for query: *

It was the CAMERA tool. I didn't think about customizing the tool bar. Thanks to both Skip and Combo. - RayTheOtherRay <>< "I was going to change my shirt, but I changed my mind instead." - Winnie the Pooh

I didn't know specifically how to title this question. Years ago, when I was teaching MicroSoft Excel, I recall a feature that allowed the user to select a cell or range of cells. When the user created an instance of this control, it referenced the selected cells and displayed them in the...

I came across a strange phenomenon when I published an Excel PivotChart as a Web Page. When I filtered the PivotChart, and the values were above .82, the area above the Category Axis from 0 to .82 was empty. The columns of the chart started at .82 and were drawn up to their respective values...

Thanks vongrunt! That was exactly what I wanted! Thanks again! RayTheOtherRay <>< "I was going to change my shirt, but I changed my mind instead." - Winnie the Pooh

I've been looking at Books Online and have found only the LOG() function (natural logarithm) and the LOG10() function (logarithm base 10). In the following section of BOL... Comparing LOG and LOG10 The LOG function returns the natural logarithm for the given float expression. Natural...

My Cold Fusion sources suggested that I use relative addressing on the location.href property in order to ensure that I was not jumping to different server domains in my page shifting process. <form> <input type = "button" Value = "Changes" name = "Changes" onClick =...

This may be of those problems that cannot be answered from any one platform as there are two types of code involved, but one of them is javascript, thus, I'll try here first. Our Information Portal on the intranet is an interface produced with Cold Fusion code. This code calls upon existing...

After some research, I find that the cryptic numbers at the end of each entry in the cookie file were not the problem. It would be academically satisfying to "know the code" concerning the subsequent numbers, but they were not the culprits in my problem. My problem was caused by a parsing...

I've been reading through the results of a search for the phrase "cookie text" and will now come right out and ask my question. I'm manipulating a file of cookies in IE that are meant to pass the settings of the current page on to the next page to produce similar filtering. I nave been...

Reporting back after much searching. I've found the functionality to do what I need to do from within the OWC object. I'm using JavaScript, so I'll post my own answer, anyway... // code to trap the SelectionChange event // SelectionChange occurs when the user // clicks on a different...

Dan, As for the newgroups mentioned above, there seem to be lots of questions posted, but less activity in the answer category than here. I find most of my help there in searching the archives. Hope this helps! Ray <>< "I was going to change my shirt, but I changed my mind instead." - Winnie...

Hi Dan! The code is definitely cutting off. I posted only a portion of the XML string to illustrate what is generated by Excel when you publish to a web page. When I said that the "wizarded" code was monstrous and ugly, I wasn't kidding. I pasted just the <param... statement into an MSWord...

Hi Dan (and anyone else)! Further input here. The object is created from an xml string as follows... <param name=XMLData value="&lt;!--[if gte mso 9]&gt;&lt;xml xmlns:v=&quot;urn:schemas-microsoft-com:vml&quot;&#13;&#10; xmlns:o=&quot;urn:schemas-microsoft-com:office:office&quot;&#13;&#10...

Hi Dan! The code for the OWC is monstrous and ugly, but I'll try to synopsize it for you. The following code is generated automatically as a result of publishing an Excel sheet (in this case containing a PivotTable and PivotChart) as a web page... <!--[if !excel]>&nbsp;&nbsp;<![endif]-->...

I have a web page published from Excel that contains a PivotChart and a PivotTable in the form of Office Web Components. I would like to capture the coordinates of a mouse click and utilize those coordinates in a method of the Chart component. I have been successful in trapping a click on the...

I found the answer. Within a series of If statments, I had one condition with "=" instead of "==". It was making an assignment and changing my value, thus skewing the expected results. Thanks! Ray <>< "I was going to change my shirt, but I changed my mind instead." - Winnie the Pooh

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...

The error is not occurring where I thought. When the page was republished, the ID of the pivot table object changed and therefore, my initial reference was invalid. Thanks! Ray <>< "I was going to change my shirt, but I changed my mind instead." - Winnie the Pooh

I have two web pages. Both are published from Excel Pivot Tables and Charts. I have added similar javascript code (the cookie functions and calls are identical, only the cookie names and values differ). The getCookie call works in the first page, but renders "object expected" in the second...

tsuji, I thanked you on the other post, but I will here, as well. Below is the code that worked. <input type = "button" value = "In Search of..." name = "InSearchOf" onClick = "var pt = document.getElementById('PivotTable'); var pv = pt.ActiveView; var pa =...