Row "Hidden" property giving wrong value

Row "Hidden" property giving wrong value

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

• 

  nchalla

  • Post Options:
  • Link
    Copy

  Posted 12 November 2017, 7:20 am EST

  Hi,

  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:

  workbook.Open("Workbook.xlsx");
              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";
              }
  

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 13 November 2017, 1:08 am EST

  Hello,

  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.

  Thanks,
  
  Deepak Sharma

• 

  nchalla

  • Post Options:
  • Link
    Copy

  Posted 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.”

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 13 November 2017, 11:59 pm EST

  Hello,

  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.

  Thanks,
  
  Deepak Sharma

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 14 November 2017, 12:08 am EST

  Hello,

  The tracking id for this issue is #249834

  Thanks,
  
  Deepak Sharma

• 

  travisbowmaster

  • Post Options:
  • Link
    Copy

  Posted 1 September 2018, 6:23 am EST