| View previous topic :: View next topic |
| Author |
Message |
ewicttvh08
General User
Joined: 08 Feb 2009
Posts: 41
|
 Posted: Thu Feb 26, 2009 2:59 am Post subject: [SOLVED] Openoffice and Progress - Cell position |
 |
|
Hi,
I'm looking to find a way to put a random cell (f.e. C5)
at the top-left corner (where normally A1 is).
By that I mean I don't want to copy the content,
but I just want that a random cell can be the first
visible cell on my spreadsheet...
I don't know how to realise this!
I hope someone can help me?
Default situation:
_____________________
|____|__A__|__B__|__C__|
|_1__|_____ |_____|_____|
|_2__|_____ |_____|_____|
|_3__|_____ |_____|_____|
What I want:
______________________
|____|__C__|__D__|__E__|
|_5__|_____|_____ |_____|
|_6__|_____|_____ |_____|
|_7__|_____|_____ |_____|
And this without losing any cells or content...
Thanks!
Maarten
_________________
openoffice 3.0.0
Openedge Progress version (10.1A - win 32 bit)
Last edited by ewicttvh08 on Thu Feb 26, 2009 6:23 am; edited 1 time in total |
|
| Back to top |
|
 |
uros
Super User
Joined: 22 May 2003
Posts: 601
Location: Slovenia
|
| Posted: Thu Feb 26, 2009 5:28 am Post subject: |
|
|
Hi Maarten!
With StarBasic:
| Code: | oController = ThisComponent.currentController
oController.setFirstVisibleColumn(2)
oController.setFirstVisibleRow(3)
|
Uros |
|
| Back to top |
|
|
ewicttvh08
General User
Joined: 08 Feb 2009
Posts: 41
|
| Posted: Thu Feb 26, 2009 6:23 am Post subject: |
|
|
Hi,
thanks a lot for your reply.
This example works like I want!
Thank you,
Maarten
_________________
openoffice 3.0.0
Openedge Progress version (10.1A - win 32 bit) |
|
| Back to top |
|
|
|
