Creating instance of ControlShape causes Calc to freeze

Creating a macro - Writing a Script - Using the API

Creating instance of ControlShape causes Calc to freeze

Postby Scrumdidlyumptious » Wed Feb 13, 2013 1:35 pm

nw
Last edited by Scrumdidlyumptious on Thu Feb 14, 2013 8:56 am, edited 1 time in total.
LibreOffice 3.6
Windows 7
User avatar
Scrumdidlyumptious
Banned
 
Posts: 8
Joined: Wed Jan 30, 2013 11:30 am

Re: Creating instance of ControlShape causes Calc to freeze

Postby Villeroy » Wed Feb 13, 2013 5:18 pm

What is a c.s.s.drawing.ControlShape and what is it supposed to do on a spreadsheet?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27109
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

t

Postby Scrumdidlyumptious » Wed Feb 13, 2013 7:04 pm

p
Last edited by Scrumdidlyumptious on Thu Feb 14, 2013 8:57 am, edited 1 time in total.
LibreOffice 3.6
Windows 7
User avatar
Scrumdidlyumptious
Banned
 
Posts: 8
Joined: Wed Jan 30, 2013 11:30 am

Re: Creating instance of ControlShape causes Calc to freeze

Postby Villeroy » Wed Feb 13, 2013 10:16 pm

A sheet has a drawpage, a draw page has a collection of database forms, a form can have form controls and subforms for database access. Buttons on a sheet are form controls.

Much better, more spreadsheet-ish:
Code: Select all   Expand viewCollapse view
=HYPERLINK("vnd.sun.star.script:Library.Module.MyURLTarget?language=Basic&location=user&row="&ROW(); "Push Me!") [together with some button-like cell style]

This "sheet button" can pass additional arguments to its macro (e.g. the row argument in the above example) and it can be copied like any other spreadsheet cell.

Code: Select all   Expand viewCollapse view
Sub MyURLTarget(sURL$)
nRow = getRowNumber(sURL)
... whatever ...
End Sub
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27109
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

o

Postby Scrumdidlyumptious » Wed Feb 13, 2013 10:52 pm

p
Last edited by Scrumdidlyumptious on Thu Feb 14, 2013 8:57 am, edited 1 time in total.
LibreOffice 3.6
Windows 7
User avatar
Scrumdidlyumptious
Banned
 
Posts: 8
Joined: Wed Jan 30, 2013 11:30 am

Re: Creating instance of ControlShape causes Calc to freeze

Postby Villeroy » Wed Feb 13, 2013 10:54 pm

Sorry, did you ever work with Calc or do you try to hack upon something you do not even know?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27109
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Macros and UNO API

Who is online

Users browsing this forum: Zizi64 and 5 guests