| View previous topic :: View next topic |
| Author |
Message |
SomeoneHere OOo Enthusiast

Joined: 28 Oct 2005 Posts: 116 Location: Boston, Massachusetts USA
|
Posted: Thu Dec 08, 2005 10:59 am Post subject: Viewing cell on the screen |
|
|
| Is there a way to make it so that when you select a cell the GUI of calc will follow? Basically I need to convert a lotus 123 file. The only way that I know of doing it is trying to figure out how the lotus works and write macros to accomadate. But I was wondering if I assign a button to a macro and the purpose of the macro is to jump say for example 12 columns to the right. I know I could get the cell with getcellbyposition but that does not make the interface jump to that cell. I hope you understand what I am trying to say and any help would be greatly appreciated. |
|
| Back to top |
|
 |
pitonyak Administrator


Joined: 09 Mar 2004 Posts: 3618 Location: Columbus, Ohio, USA
|
Posted: Thu Dec 08, 2005 1:43 pm Post subject: |
|
|
the current controller supports the following methods:
| Code: | VOID setActiveSheet ( OBJECT )
VOID setFirstVisibleColumn ( LONG )
VOID setFirstVisibleRow ( LONG ) |
_________________ --
Andrew Pitonyak
http://www.pitonyak.org/oo.php |
|
| Back to top |
|
 |
SomeoneHere OOo Enthusiast

Joined: 28 Oct 2005 Posts: 116 Location: Boston, Massachusetts USA
|
Posted: Fri Dec 09, 2005 5:04 am Post subject: |
|
|
| thanks for the help that was exactly what I needed for the view but I do have another question how can I change the active cell so that not only is the view on the page but the active cell is set so the user can just write in information? Thanks for all the help |
|
| Back to top |
|
 |
pitonyak Administrator


Joined: 09 Mar 2004 Posts: 3618 Location: Columbus, Ohio, USA
|
Posted: Fri Dec 09, 2005 11:55 am Post subject: |
|
|
Have you tried
| Code: | | ThisComponent.CurrentController.Select(oCell) |
_________________ --
Andrew Pitonyak
http://www.pitonyak.org/oo.php |
|
| Back to top |
|
 |
SomeoneHere OOo Enthusiast

Joined: 28 Oct 2005 Posts: 116 Location: Boston, Massachusetts USA
|
Posted: Fri Dec 09, 2005 4:17 pm Post subject: |
|
|
| thanks I will have to give that a try. I just wanted to thank everyone that has helped me with any questions I have had. I am greatly appreciative and glad to have a place to go to get this help. |
|
| Back to top |
|
 |
|