Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
mouseup
Trying to do the ol MouseUp thing. XY in screen coordinates, blah
blah. I can get the xy relative to the window. I went thru the API calls, finding windows, some enumerations (because the class names weren't quite like in the posts) etc. Got it. Woohoo. The location of the chart in the window depends on zoom, and 2 scrolls. ChartArea.Left seems stuck at 4. I can zoom in and scroll the chart way off to the left and still get 4. It should be like - 250, but I get 4. I saw the post on the uLong bug for big values. Is it a bug that I can't get negative values? In fact, I haven't found any of the Excel properties that change when zooming and scrolling. Except zoom and scroll. I suppose. So I'll use those right? Well I can find the zoom parameter alright. But I can't find the scroll ticks to manually interpret the location of the chart in the window. Now I'm not using a chart on a worksheet. The chart has its own tab in the workbook. But I ought to be able to find the scroll tick count somewhere right? ARRRGH. I'm about to abandon this. The correct email address isn't the one in the profile. Its . So if's there's a lit candle for this, I'd appreciate a short email. - scorpdaddy |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
mouseup
ChartArea.Left is the position of the ChartArea within the Chart sheet. It
doesn't vary with zoom or scroll. I have been down this road. It is a long road, and I am convinced that at least at my level of expertise, it is a dead end street. I do not know how to convert the mouse event XY coordinates to chart client coordinates in a chart sheet, unless you have set ChartSizesWithWindow to true (Tools menu Options Chart tab). This prevents scrolling, of course, but it allows you to convert mouse motions to usable coordinates. In their wisdom, Microsoft has removed the ChartSizesWithWindow setting from Excel 2007 (it will always be false), so a bundle of existing applications will become obsolete when their owners upgrade Excel. Poof! - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ wrote in message ups.com... Trying to do the ol MouseUp thing. XY in screen coordinates, blah blah. I can get the xy relative to the window. I went thru the API calls, finding windows, some enumerations (because the class names weren't quite like in the posts) etc. Got it. Woohoo. The location of the chart in the window depends on zoom, and 2 scrolls. ChartArea.Left seems stuck at 4. I can zoom in and scroll the chart way off to the left and still get 4. It should be like - 250, but I get 4. I saw the post on the uLong bug for big values. Is it a bug that I can't get negative values? In fact, I haven't found any of the Excel properties that change when zooming and scrolling. Except zoom and scroll. I suppose. So I'll use those right? Well I can find the zoom parameter alright. But I can't find the scroll ticks to manually interpret the location of the chart in the window. Now I'm not using a chart on a worksheet. The chart has its own tab in the workbook. But I ought to be able to find the scroll tick count somewhere right? ARRRGH. I'm about to abandon this. The correct email address isn't the one in the profile. Its . So if's there's a lit candle for this, I'd appreciate a short email. - scorpdaddy |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
mouseup
Hey - Thanks Jon!
It seems it shouldn't be so tough. Scrollbars is a hidden member of the chart. Let me at 'em. But alas. I believe it is a dead end. The sizes with window does seem to fix it though, for now. - Scorpdaddy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|