[Solved] Macro button to hide/unhide rows in Calc

[1eSkip]

588 / 5.000
Vertaalresultaten
Vertaalresultaat
Good day everyone. I am trying to create a macro for a button to show or hide specific Rules for columns, I have already done this. But for rules. Can I find too little information? Who oh who would want and be able to help me. I would be gratefull.

this is what i tried. This is derived from my macro that hides a column via a button.

Code: Select all

REM ***** BASIC *****

sub toggle_Rows_1ePart
     doc = thisComponent
     sheet = doc.CurrentController.ActiveSheet
     rows = sheet.rows("14,15,16,17")
     rows.IsVisible = not rows.IsVisible
end sub

[robleyd]

Can I find too little information?

You may find Andrew Pitonyak's books on OO macros a useful resource.

[karolus]

Hallo

Select Range A14:A17
hit F12
choose [x]Rows
⇒ok

now you will find left of Row 14 a tiny Button to hide|unhide Rows 14 to 17


PS: working counterpart to your NOT working basic! … in python:

Code: Select all

def toggle_row_14_17(*_):
    doc = XSCRIPTCONTEXT.getDocument()
    sheet = doc.CurrentController.ActiveSheet
    rows = sheet[13:17, 0 ].Rows
    rows.IsVisible = not rows.IsVisible 

[DiGro]

You were almost there.

Try this one:

Code: Select all

Sub hideRows14_17()
oDoc=ThisComponent
oSheet=oDoc.CurrentController.ActiveSheet
myRange=oSheet.getCellRangeByPosition(,13,,16)
myRange.Rows.IsVisible=false
End Sub

Mind you getCellRangeByPosition takes as arguments (start_column,start_row,end_column,end_row) hence (,13,,16) Rows are zero based.

[JeJe]

Apart from the IDE help file, Pitonyak's free books, searching here - someone's usually already asked a similar question -
there is the MRI Object Inspector which is invaluable.

viewtopic.php?t=49294

this extension is too:

https://extensions.openoffice.org/en/pr ... -ide-tools

[MrProgrammer]

I am trying to create a macro for a button to show or hide specific Rules for columns, I have already done this. But for rules

This post seems to have been created by a language transation program. I will interpret it as:

I am trying to create a macro for a button to show or hide specific rows. For columns, I have already done this. Now I want to show or hide rows.

There is no need to learn the complex OpenOffice programming interface if you record a macro:
• Tools → Macros → Record
• Select the specific rows to show or hide using the Name Box
• Format → Rows → Show    or    Format → Rows → Hide
• Stop Recording
• Give your macro a name and save it.
[Tutorial] Favorite Recorded Calc Macros

For example, to show or hide rows 5 through 8 type A5:A8 in the Name Box and press Enter.

Record macros for each specific set of rows, one to hide and one to show. You can run your macros using Tools → Macros → Run or by using this tutorial. I would think creating a toolbar to run the macros is the best method for this situation.
[Tutorial] Binding a macro: Shortcut key, menu or toolbar

Select Range A14:A17
hit F12
choose [x]Rows
⇒ok

Select specific rows → Data → Group and Outline → Group → Rows → OK is another simple method which avoids the need to learn the OpenOffice programming interface. It creates + and - buttons on the left side of the screen which you can use to hide or show rows. Use the 1 above to hide all groups and the 2 to show all groups.


If this solved your problem please go to your first post use the Edit ☐ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.

[Lupp]

If, however, the questioner is eager to learn more about using the API in custom code:
Information that may change (here mainly the row range to be treated) should not be hard coded in a Sub if avoidable.
Any FormControl object like the PushButton in this case has a property .Tag which can be used to pass special information to the called code. For the UI (en) this property is circumscribed as "Additional information".
See attached example.

aoo111475ToggleVisibilityForRowRangesByClickingPushbuttons.ods

(21.13 KiB) Downloaded 12 times

[robleyd]

Cross posted at AskLibreOffice

If you cross post, as a courtesy please let us know that you have done so, otherwise it leads to several discussions and a waste of time because several identical answers may be posted by different users.

Edit: Solved - see the AskLibreOffice link