Collapsed rows

Aspose.Cells Product Family
1

Dear all,

We are currently facing the following problem, we have a excel sheet with some groups of row. We want aspose to show part of them collapsed an the other groups open.

When we save the excel with some groups collapsed, the aspose renders the collapsed row as hidden, and does not allow to open the closed groups. The open groups can be opened and closed as usual.

Why does this happens? It should just show the rows collapsed and allow to open them, right?

See attached a simple example.

Regards,

Nelson Ruivo

2

Hi Nelson,

Thanks for pointing it out.

We will figure it out soon.

Thank you.

3

Hi,

We have found this problem. We will fix it soon. Thank you.

4

Please try the attachment dll v2.0.0.2002. This dll fixed the problem that the grid can't expand the collapsed rows when import an excel file.

And this version also supports saving excel2007 format files.

5

Dear Henry,

I tested your dll with our file and it's possible to open the grouped rows, but they are shown as hidden rows, and the contents are not availlable.

Regards,

Nelson Ruivo

6

Hi,

We will check it and get you back soon.