I have a worksheet with a little over 20000 lines. The first column has a class which I have sorted the data by.
I would like to group the rows under each class. Doing this using the Data/Group menu option works, however, trying to do this over 20000 lines will drive me insane.
I am able to write a macro to identify the range of rows to be grouped. I just cannot find the macro function to invoke the group action.
Thanks in advance.
Build ID: 1:5.2.7-1+deb9u7
CPU Threads: 8; OS Version: Linux 4.9; UI Render: default; VCL: gtk3;
Locale: en-AU (en_AU.UTF-8); Calc: group