Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / September 2006

Tip: Looking for answers? Try searching our database.

mouseup

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
chollera@sympatico.ca - 23 Sep 2006 07:09 GMT
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 scorpdaddy@hotmail.com.  So if's there's a lit candle
for this, I'd appreciate a short email.

- scorpdaddy
Jon Peltier - 23 Sep 2006 19:08 GMT
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
_______

> 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
[quoted text clipped - 22 lines]
>
> - scorpdaddy
chollera@sympatico.ca - 26 Sep 2006 05:07 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.