Can't read or edit cells after import when row height is ≤12.75 in Excel

Can't read or edit cells after import when row height is ≤12.75 in Excel

Posted by: raheem.mohdabdul on 12 May 2022, 6:59 am EST

• 

  raheem.mohdabdul

  • Post Options:
  • Link
    Copy

  Posted 12 May 2022, 6:59 am EST - Updated 3 October 2022, 2:58 am EST

  

  1400×933 83 KB

  Hi Wijmo Team,

  We have found a bug that is related to the import excel functionality of the wijmo grid. When the size of the actual excel file cell is less then ≤12.75 and we try to import that into the wijmo the output screen height cells appear to overlap and are illegible. Do you have plans to fix this issue? if yes, please provide the release date. If not, how can I fix this issue by myself?

• 

  sonu.pandey

  

  • Post Options:
  • Link
    Copy

  Posted 12 May 2022, 11:39 pm EST

  Hello,

  The behavior is expected as the imported excel cell’s size is smaller than the cells in the FlexGrid, which will also appear as per the imported excel file. Most of the styling is imported along with the data from the excel sheet.

  If you wish to adjust the cell heights to their default size you may call the autoSizeRows() method after the excel sheets get loaded. Please refer to the API link below for reference:

  https://www.grapecity.com/wijmo/api/classes/wijmo_grid.flexgrid.html#autosizerows

  Regards