why the cell's border is overflowing which i selected in spreadsheet

Question

Hi, Why the cell's border is overflowing which i selected in spreadsheet. Waiting for an answer.Thanks.

Sangeetha Priya Murugan · Accepted Answer

Hi Jred,Based on your provided details, you have used Chinese text
in your application. And the line height of the Chinese text is greater than
the English text. So, we suggest you set the height of the rows by using the setRowHeight/setRowsHeight
methods to resolve the selection issue in your end.Code Block:

//Initialize Spreadsheet component
  var spreadsheet = new ej.spreadsheet.Spreadsheet({
    sheets: [
      {
        rows: [
          {
            cells: [
              {
                value: `紡撚一廠  ${2022}  年 ${8}月 份  紡絲一課 POY 生 產 月 報 表  (5533)`,
                style: {
                  fontSize: '26pt',
                },
                colSpan: 33,
              },
            ],
          },
          ..//
   
    ],
    created: function () {
      updateHeight();
    },
  });
   
  //Render initialized Spreadsheet component
  spreadsheet.appendTo('#spreadsheet');
  function updateHeight() {
    let rowCount = spreadsheet.getActiveSheet().usedRange.rowIndex + 1; // To get used
  range row count
    // Set the height for header row
    spreadsheet.setRowHeight(50, 0, 0);
    spreadsheet.setRowsHeight(25, ['2:' + rowCount.toString()]);
  }

For your convenience, we have prepared the sample based on
your provided codes with minimal data. In this we have set the height for used
rows by using setRowHeight and setRowsHeight methods. Please find the
link below.Sample Link: https://stackblitz.com/edit/rsyxyr-mggvct?file=index.js
API Links: https://ej2.syncfusion.com/documentation/api/spreadsheet/#setrowheight
https://ej2.syncfusion.com/documentation/api/spreadsheet/#setrowsheight
Documentation Link: https://ej2.syncfusion.com/documentation/spreadsheet/rows-and-columns#size

Sangeetha Priya Murugan · Answer

HI Jred,We have checked your reported issue by creating the sample
with different heights, free pane and filter applied sheets in both virtual and
non-virtual mode. And we haven’t faced any selection issue in our end. So,
before we proceed further, please share the below details.1.Please confirm whether you have faced this issue with
the imported excel file, if yes please share us the excel file with dummy
data.2.Whether you have faced this issue in non-virtual mode,
please share those details.3.Please share how you load data into the spreadsheet whether
using datasource property or any other way?4.what all are features you have applied into the
spreadsheet, share those details too.5.If possible, please share your spreadsheet rendering
and customization codes.6. Please share your exact issue replicable scenario with
video demonstration.Could you please check the above details and get back to us with
the above requested information, based on that we will check and provide you
with a better solution quickly.Regards,Sangeetha M

Jred · Answer

Hi

Sangeetha M, I communicate with MSSQL via JavaScript using AJAX to retrieve data. After obtaining the data, I reassemble it and place it in the 'rows' of a SpreadSheet. This includes configuring some merged cells. Finally, I append this object to the corresponding Div.Attachment: index_23ab5494.rar

Jred · Answer

HiIt's work! Thank you so much for your prompt and helpful response!

Sangeetha Priya Murugan · Answer

Hi Jred,We are happy to hear that you issue has been resolved. please feel free to contact us, if you need any further assistance on this.