We will be migrating from Ask to Discourse on the first week of August, read the details here
Hello :D
I am struggling to write a macro to add / subtract the value of 1 to / from cell B2 when the push button is released.
That is what I have so far for the macro code for the "+" button. Does somebody have an idea how to make it work?
Thank you in advance! Sophie
Hello @cybersurfer5000
Probably you should not bother with writing macro and use Spin Button for such a task:
Insert -> Form Control -> Spin Button
Draw Spin Button where necessary
Right click on Spin Button and select Control option
Under Data tab write desired cell address into Linked cell... field (B2 in your case)
Under General tab adjust Value min, Value max, Default value, Increment/decrement value if needed.
Toggle Design mode off and test created button
Hello,
though I fully support @SM_Riga's solution, here's a code snippet (no error handling, no cell reference as parameter, just the idea how it could be done) which does what you want:
Sub CellValueIncrement()
Dim oSheet As Object
Dim oRange As Object
Dim oCell As Object
Dim iCurVal As Integer
Dim iNewVal As Integer
oSheet = ThisComponent.CurrentController.ActiveSheet
oRange = oSheet.getCellRangebyName( "B2" )
oCell = oRange.getCellByPosition(0,0)
iCurVal = oCell.value
iNewVal = iCurVal + 1
oCell.Value = iNewVal
End Sub
Tested using LibreOffice:
Version: 6.4.4.2, Build ID: 3d775be2011f3886db32dfd395a6a6d1ca2630ff
CPU threads: 8; OS: Linux 4.12; UI render: default; VCL: kf5;
Locale: en-US (en_US.UTF-8); UI-Language: en-US, Calc: threaded
@Opaque, is there a comprehensive overview of all the syntax that's available for LibreOffice? I found the OpenOffice Basic programmer's guide that contains some, but not all of the syntax, i.e. oSheet syntax is not described. LibreOffice's help website link text will probable explain how to all the syntax but I have a hard time finding what I am looking for, unless I already know the syntax, but not how to correctly use it. E.g. I didnt know the oSheet syntax, hence I would not have searched for it. I hope I explained myself well.
.g. I didnt know the oSheet syntax
There is no oSheet syntax. It is the name defined within the macro (see dim statement) for the object and set to ThisComponent.CurrentController.ActiveSheet. Hence you need to look for methods and properties of ...ActiveSheet while oSheet is just a shortage for ThisComponent.CurrentController.ActiveSheet
Asked: 2020-05-24 08:36:03 +0200
Seen: 251 times
Last updated: May 24 '20
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
This is not a
mathquestion (formula editor) but acalcone (spreadsheet). Please retag your question with the link above.I can edit the tags by using the "retag" button, however I cannot save changes. Please advice.
You need to hit the
Returnkey twice. I've done it for you.