Query regarding spread sheet Rows height.

Posted by: shabeena-nazaveva-com on 8 September 2017, 3:21 pm EST

  • Posted 8 September 2017, 3:21 pm EST

    Hi Team,
    I have a query regarding spread sheet Rows height.

    Example:
    I have created a sheet in spread and selected 3 rows (19, 20 and 21 in [Fig.1]).Out of these three I have made height zero for 20th row (By dragging the row header).Now if I access the height property of the 20th row in my code then the height is coming as 20(See [Fig.2]).Please find the attachment and let me know the solution for this if any.

    [Fig.2]: In this 20th row height is coming as 20(Default value) in back end (code).







  • Replied 8 September 2017, 3:21 pm EST

    Hi Gina,

    As you mentioned in the image which you have sent.In that you are making height 0 for 19th row.But I can see that it didnt refelect anywhere in image.(No rows with height zero in your RowHeight.png image).

    And my issue is like I am making height zero for 20th row by dragging the rowheader not by setting it to zero in any property or anywhere.And when am trying to get or access the height of the 20th row then in spread its showing zero but in back end or in code that particular 20th row height is coming 20.Means if you can see in [Fig.2] that 20th row is not visible,after 19th row 21st row is there.Because I made 20th row height as zero.But for same in back end 20th row height is coming as 20 everytime.Hope you understand the issue,let me know if you want any more detail or explanation in that.

    And also please let me know if it could be timing issue.


    Thanks,
    Shabeena
  • Replied 8 September 2017, 3:21 pm EST

    Hi,

    I resized row 20 so that it was not visible (notice row 20 in the image). Row 19 in code is the correct index for row 20 since the row numbers are 0 based. The code in the image returns the height of the row, it does not set it. Do you have a few lines of code of how you are getting the row height?

    -Gina
  • Replied 8 September 2017, 3:21 pm EST

    Hi,

    I tried the code in the image and I did get 0. It could be a timing issue. Are you checking the height in a Spread event?

    -Gina

  • Replied 8 September 2017, 3:21 pm EST

    Hi,

    I also feel that may be it is timing issue.
    Can you please try one more scenario:

    -Export some excel without changing the row height.
    -After Exporting go to the path where you export or save the excel.
    -Open excel and now make 20th row is zero by dragging rowheader.(Place where you have saved the Excel)
    -Now Import that excel and check what is the height of the 20th row.And also check whether the 20th row is visible after importing the excel or not.

    Thanks,
    Shabeena
  • Marked as Answer

    Replied 8 September 2017, 3:21 pm EST

    Hello,

    It appears this is a bug, so I have submitted it to the developers for further investigation. It seems to be a problem with the way Spread is importing Excel files that have rows with row heights of 0.

    The tracking number for your reference is 144969.

    I will update you as soon as I hear anything.

    Regards,
    Kevin
  • Replied 8 September 2017, 3:21 pm EST

    Hi,

    Thanks Kevin for Update.
Need extra support?

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

Learn More

Forum Channels