Row "Hidden" property giving wrong value

Posted by: nchalla on 12 November 2017, 7:20 am EST

  • Posted 12 November 2017, 7:20 am EST


    The Row "Hidden" property is always false even though the row is hidden in Excel file. But the Row height was coming as zero (0).

    Example Code:
    IWorksheet worksheet = workbook.Worksheets[0];
    worksheet.Protection = false;
    worksheet.Range["A1:A3"].Value = 121;
    string str = string.Empty;
    var range = worksheet.GetUsedRange();
    for(var i = 0; i < range.Rows.Count; ++i) {
    str += i + "-" + range.Rows[i].Hidden + "\n";
  • Replied 13 November 2017, 1:08 am EST


    This is the designed behavior of Spread.Services. After importing the Excel file the hidden rows height is set to 0 knowingly. You would need to set the height to a number other than 0 to make it visible.

    Deepak Sharma
  • Replied 13 November 2017, 4:00 am EST

    Thanks. What is the use of "Hidden" property then? According to your documentation, it says "Gets or sets the property which specifies whether rows or columns should be hidden."

  • Replied 13 November 2017, 11:59 pm EST


    I will discuss this issue with the development team and let you know the possible reason for keeping this behavior.
    I will let you know as soon as I get any update on this.

    Deepak Sharma
  • Replied 14 November 2017, 12:08 am EST


    The tracking id for this issue is #249834

    Deepak Sharma
  • Replied 1 September 2018, 6:23 am EST

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels