Page 1 of 1

Creating instance of ControlShape causes Calc to freeze

PostPosted: Wed Feb 13, 2013 1:35 pm
by Scrumdidlyumptious
nw

Re: Creating instance of ControlShape causes Calc to freeze

PostPosted: 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

PostPosted: Wed Feb 13, 2013 7:04 pm
by Scrumdidlyumptious
p

Re: Creating instance of ControlShape causes Calc to freeze

PostPosted: 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   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

o

PostPosted: Wed Feb 13, 2013 10:52 pm
by Scrumdidlyumptious
p

Re: Creating instance of ControlShape causes Calc to freeze

PostPosted: 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?