1eSkip wrote: ↑Sat Apr 20, 2024 3:43 am
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:
1eSkip wrote: ↑Sat Apr 20, 2024 3:43 am
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
karolus wrote: ↑Sat Apr 20, 2024 7:32 am
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.
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).