Spreadsheet: Clicking on a cell

[richhill]

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!

[Cybb20]

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

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 -