Creating instance of ControlShape causes Calc to freeze
- Scrumdidlyumptious
- Banned
- Posts: 8
- Joined: Wed Jan 30, 2013 11:30 am
Creating instance of ControlShape causes Calc to freeze
nw
Last edited by Scrumdidlyumptious on Thu Feb 14, 2013 8:56 am, edited 1 time in total.
LibreOffice 3.6
Windows 7
Windows 7
Re: Creating instance of ControlShape causes Calc to freeze
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 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
- Scrumdidlyumptious
- Banned
- Posts: 8
- Joined: Wed Jan 30, 2013 11:30 am
t
p
Last edited by Scrumdidlyumptious on Thu Feb 14, 2013 8:57 am, edited 1 time in total.
LibreOffice 3.6
Windows 7
Windows 7
Re: Creating instance of ControlShape causes Calc to freeze
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:
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.
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]
Code: Select all
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 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
- Scrumdidlyumptious
- Banned
- Posts: 8
- Joined: Wed Jan 30, 2013 11:30 am
o
p
Last edited by Scrumdidlyumptious on Thu Feb 14, 2013 8:57 am, edited 1 time in total.
LibreOffice 3.6
Windows 7
Windows 7
Re: Creating instance of ControlShape causes Calc to freeze
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 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice