Issue with group functionality

21 views
Skip to first unread message

Vincent Fayolle

unread,
Nov 5, 2025, 3:19:08 PM (6 days ago) Nov 5
to openpyxl-users
Hello users,

I don't find any place to communicate on a bug ? What is the good way ?

Here is the issue : If I use the plan mode, and group lines (groups and subgroups) the property hidden=True does not works on the subgroups.

Example (you will see on the generated excel file that it's fine for groups but not subgroups (with have a minus instead of plus in groupping)

Thanks for your help to send this issue somewhere.

Vincent

from openpyxl import Workbook

wb = Workbook()
ws = wb.active
ws.title = "Example"

for i in range(1, 50):
    ws[f"A{i}"] = f"Ligne {i}"


ws.row_dimensions.group(start=2, end=25, outline_level=1, hidden=True)
ws.row_dimensions.group(start=27, end=50, outline_level=1, hidden=True)
ws.row_dimensions.group(start=3, end=14, outline_level=2, hidden=True)
ws.row_dimensions.group(start=16, end=25, outline_level=2, hidden=True)



wb.save("c:/temp/example_group.xlsx")

Charlie Clark

unread,
Nov 6, 2025, 4:56:03 AM (5 days ago) Nov 6
to openpyxl-users
On 5 Nov 2025, at 21:19, Vincent Fayolle wrote:

> Hello users,

Hi Vincent,

> I don't find any place to communicate on a bug ? What is the good way ?

Use the bug tracker: https://foss.heptapod.net/openpyxl/openpyxl/-/issues

Charlie Clark

--
Charlie Clark
Managing Director
Clark Consulting & Research
German Office
Sengelsweg 34
Düsseldorf
D- 40489
Tel: +49-203-3925-0390
Mobile: +49-178-782-6226
Reply all
Reply to author
Forward
0 new messages