I want add buttons on a spreadsheet to show pre-defined areas of the spreadsheet on the screen
I run linux mint and windows7 on a dual boot system. The spreadsheets were compiled in microsoft office97. I can get some of the microsoft VBA converted to run in LibreOffice calc but am having trouble with:
“Private Sub CommandButton1_Click()
ActiveWorkbook.CustomViews(“Name”).Show
End Sub”
as I can’t figure out the LibreOffice equivalent to CustomViews
Please edit your question to indicate: O/S, LO version, and a link / screenshot that clearly illustrates the Excel feature. Thanks.
The only thing I can find to do is to open - record a macro, select a cell half way down the area you want, stop recording and save the macro which looks like this:
sub cars
rem ----------------------------------------------------------------------
rem define variables
dim document as object
dim dispatcher as object
rem ----------------------------------------------------------------------
rem get access to the document
document = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")
rem ----------------------------------------------------------------------
rem dispatcher.executeDispatch(document, ".uno:DefineDBName", "", 0, Array())
rem ----------------------------------------------------------------------
dim args2(0) as new com.sun.star.beans.PropertyValue
args2(0).Name = "DbName"
args2(0).Value = "cars"
dispatcher.executeDispatch(document, ".uno:SelectDB", "", 0, args2())
rem ----------------------------------------------------------------------
dim args3(0) as new com.sun.star.beans.PropertyValue
args3(0).Name = "ToPoint"
args3(0).Value = "$T$8"
dispatcher.executeDispatch(document, ".uno:GoToCell", "", 0, args3())
end sub
Assign the macro to a button which when clicked will take you to the correct row but not the columns. You then need to scroll across the columns to find the area you are looking for. Not as simple as Xcel but at least though, half the work is done for you.