Creating instance of ControlShape causes Calc to freeze

edit this topic's initial post · Post by **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?

Post by **Scrumdidlyumptious** » Wed Feb 13, 2013 7:04 pm

edit this topic's initial post · Post by **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

=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

Post by **Scrumdidlyumptious** » Wed Feb 13, 2013 10:52 pm

edit this topic's initial post · Post by **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?

Creating instance of ControlShape causes Calc to freeze

Creating instance of ControlShape causes Calc to freeze

Re: Creating instance of ControlShape causes Calc to freeze

t

Re: Creating instance of ControlShape causes Calc to freeze

o

Re: Creating instance of ControlShape causes Calc to freeze