Page 1 of 1
Creating instance of ControlShape causes Calc to freeze
Posted: Wed Feb 13, 2013 1:35 pm
by Scrumdidlyumptious
nw
Re: Creating instance of ControlShape causes Calc to freeze
Posted: Wed Feb 13, 2013 5:18 pm
by Villeroy
What is a c.s.s.drawing.ControlShape and what is it supposed to do on a spreadsheet?
t
Posted: Wed Feb 13, 2013 7:04 pm
by Scrumdidlyumptious
p
Re: Creating instance of ControlShape causes Calc to freeze
Posted: Wed Feb 13, 2013 10:16 pm
by Villeroy
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
=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
Sub MyURLTarget(sURL$)
nRow = getRowNumber(sURL)
... whatever ...
End Sub
o
Posted: Wed Feb 13, 2013 10:52 pm
by Scrumdidlyumptious
p
Re: Creating instance of ControlShape causes Calc to freeze
Posted: Wed Feb 13, 2013 10:54 pm
by Villeroy
Sorry, did you ever work with Calc or do you try to hack upon something you do not even know?