Creating instance of ControlShape causes Calc to freeze

[Scrumdidlyumptious]

nw

[Villeroy]

What is a c.s.s.drawing.ControlShape and what is it supposed to do on a spreadsheet?

[Scrumdidlyumptious]

p

[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

[Scrumdidlyumptious]

p

[Villeroy]

Sorry, did you ever work with Calc or do you try to hack upon something you do not even know?