Set Row Height - Big Spreadsheets -Bestway?

Posted by: pbright-fp on 8 September 2017, 2:21 pm EST

  • Posted 8 September 2017, 2:21 pm EST

    i'm new to this component so sorry in advance... 


    Is there a way to set the row height on all the cells after loading a file without having to loop through every row.  This is a perfromace issue on spreadsheets with alot of data...50K rows... and we have some like that  LOL


    just trying to learn the best way from the start..


    Thanks...


     

  • Replied 8 September 2017, 2:21 pm EST

    Or is there a way of determining what rows are actually viewable on the users screen.... then when that screen changes resize the rows that are only viewable... smoke and mirrors but thin it only effects the records on screen and should occur fast...
  • Replied 8 September 2017, 2:21 pm EST

    How about a new Property off the Row.... "AutoSizeViewableRows"  then as the user scrolls through the datat the component auto sizes only the rows in view...  that should fast...
  • Replied 8 September 2017, 2:21 pm EST

    Hello,

    To set the height of the rows after loading a file, we have to loop through the rows and then set the height accordingly.

    However, to determine the rows viewable on the screen, we can use GetViewportTopRow which gets the top row of cells of the specified viewport row for the activesheet and GetViewportBottomRow which gets the bottom row of cells of the specified viewport row for the active sheet and then try setting the height of the rows in that viewable area only.

    Please find the attached sample for the same and notice that for rows out of viewable area height is not set accordingly.

    Thanks.

     


    2010/05/RowHeight.zip
  • Replied 8 September 2017, 2:21 pm EST

    THANKS!!!!!
Need extra support?

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

Learn More

Forum Channels