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

  • Posted 12 May 2022, 6:59 am EST



    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?
  • Replied 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
Need extra support?

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

Learn More

Forum Channels