Black line after calling the FreezePanes method

<!–[if gte mso 10]> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:Arial; mso-bidi-theme-font:minor-bidi;}

<![endif]–>

Hi,

We use the version 7.0.3.2 of Aspose.Cells and we perform Freeze Panes action on Excel which works fine but after applying this action the black line is drawn under the “frozen area”.

We call:

worksheet.FreezePanes(11, 0, 11, worksheet.Cells.Columns.Count);

Please see the attached excels before and after. Is it possible to remove this line?

Kind Regards,

Yevgeny.

Hi,

"worksheet.FreezePanes(11, 0, 11, worksheet.Cells.Columns.Count);"

This code will freeze the complete 12th row. If you could perform the same operation in MS Excel: "e.g In MS Excel 2007 in cleaned.xlsx file's first sheet, Click on Cell A12, Click View(Menu), click Freeze Panes button/icon and then click "FreezePanes" option", you will get the same result, the similar black (frozen) line would be appeared in the 12 row (up to the end of column in the worksheet). So, Aspose.Cells works the same way as MS Excel does. If you don't want this frozen line, please remove your line of code or use Unfreeze function, see the document for reference:
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/freeze-panes.html

If you still have any confusion regarding FreezePanes, please perform your operation (freezing panes operation) on cleaned.xlsx file in MS Excel manually, resave the file and post it here, we will tell you how to do it with Aspose.Cells APIs.

Thank you.



Thank you for the answer. Apparently it is the default behavior of MS Excel, so it’s not a bug.