-1

I'm working on react excel add-in and have a requirement to unhide the hidden rows. this is working fine with range.rowHidden=false.

but the problem here is that grouped rows also expand.

group

How to fix this issue?

Any kind of help much be is appreciated.

Rajath
  • 2,611
  • 8
  • 27
  • 43

1 Answers1

0

Rajath, the Outlining feature in Excel is using the Hide/Unhide feature to hide and show rows and columns within a group. If you choose to unhide rows/columns in a collapsed group, then those rows/columns will become visible regardless of the expanded/collapsed state of the group. I don't think there is a way to work around this behavior.

Jakob Nielsen-MSFT
  • 504
  • 2
  • 8
  • Yes Jakob, you're right even though I have done enough research on that but couldn't find the solution. This is the user-requested feature that I'm currently working on. Anyhow thanks for your response. – Rajath Oct 31 '22 at 16:38