Hello Peru,

My team and I have done an initial review of this forum thread, and I have a few questions for you on this matter, as I am a little unsure of a few things on this. Can you please provide some information on the following?

1. You mentioned a “modal window” in your description – is the IgxSpreadsheet within one of your modal windows, or is the modal window just something you are opening in response to actions on the spreadsheet, and it is cutting off the filter dialog / context menu of the spreadsheet?

2. Which “window” are you trying to configure the opening position in point 1 of your original description? Are you referring to the drop-down menu or context menu that happens when you click the icon at the top of the cell? I cannot quite tell from your screenshot.

3. Regarding your point 2 in that the sorting is not working for you, I cannot reproduce the sorting not working in the example you linked. If I right click one of the cells and choose one of the sort options, this works on my end. Being that I can see in the screenshot that you have drop-downs in the header though, this lead me to believe that perhaps the sample there had been modified in some way? Can you detail the changes that you made?

Hello Peru,

I have been investigating into your most recent requirements in this case, and I have some information for you.

Regarding setting a particular row as the header row of the table in a Worksheet, this will by default be the first row in the region that you define. If there is no data in the first row of the region you define, which is the case with the Worksheet you provided with the “A1:C11” region, this will generate default column headers, which I believe is the behavior you are seeing. If you wanted row 3 to be the header, you would need to ensure that is the first row in the region (“A3:C11”).

Regarding dynamically calculating and setting the region, I would recommend utilizing the following code, as this should help you, assuming you want the entirety of the data region to be part of the table:

    let sheet = this.spreadsheet.activeWorksheet;

    let startCell: WorksheetCell;

    let endCell: WorksheetCell;

    let rows = sheet.rows();

    for (let row of rows) {
      let cells = row.cells();

      for (let cell of cells) {
        if(cell.value != null){
          if(startCell == null){
            startCell = cell;
          }

          endCell = cell;
        }
      }
    }

sheet.workbook.cellReferenceMode = CellReferenceMode.R1C1;

let address = "R" + (startCell.rowIndex + 1) + "C" + (startCell.columnIndex + 1) + ":R" + (endCell.rowIndex + 1) + "C" + (endCell.columnIndex + 1);

sheet.tables().add(address, true);

The loop in that code may make you believe that you will be looping through all possible rows and columns in the Worksheet, but this is not the case – the Worksheet only registers the cells and rows that have been modified in some way. For example, in the case of your Worksheet, I am seeing some null-value cells, which leads me to believe that they had been modified in some way prior to saving the file.

Regarding “hasHeaderRow” not existing on the WorksheetTable, you are correct – this does not exist, but the table does have an isHeaderRowVisible property that you can set to prevent the headers from being visible.

Hello Peru,