mouseup

[chollera]

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 (e-mail address removed). So if's there's a lit candle
for this, I'd appreciate a short email.

- scorpdaddy

 

[Jon Peltier]

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

 

[chollera]

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