OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Spreadsheet: Clicking on a cell

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Macros and API
View previous topic :: View next topic  
Author Message
richhill
OOo Advocate
OOo Advocate


Joined: 16 Jun 2004
Posts: 418
Location: Mesa, AZ

PostPosted: Thu Aug 19, 2004 9:39 pm    Post subject: Spreadsheet: Clicking on a cell Reply with quote

I've set up mouse click handler in my spreadsheet and when mouse is clicked, I know the mouse X,Y coords.

How can I convert the X,Y mouse position to a cell position (A!, B! etc)

Thanks!
Back to top
View user's profile Send private message Visit poster's website
Cybb20
Super User
Super User


Joined: 02 Mar 2004
Posts: 1569
Location: Frankfurt, Germany

PostPosted: Fri Aug 20, 2004 11:21 am    Post subject: Reply with quote

Good question.
But probably it's not that easy, cause think of it:
What have the cells got to do with the XWindow system which is responsible for knowing where you have clicked the mousecursor? Cells are flexible in their size, so you cannot just compute it somehow.
Maybe there is some interface that might be able to use but as I am not skilled in Spreadsheets I don't know of it. Probably Andrew knows the answer to this Smile

One thing however I can say:
I had my difficulties with positioning shapes exactly where on has clicked on a drawing page with a MouseClickHandler and I asked all around but there was no solution to it.

Christian
_________________
- Knowledge is Power -
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Macros and API All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group