Is there a way to hide the column letters and row numbers?

Question

In a Spreadsheet control, is there a way to turn off the row numbers and column letters so that only the actual cell area is visible?EJ2 - Javascript - 19.2.0.44

Aravinthan Seetharaman · Answer

Hi John, 
 
Thanks for contacting Syncfusion Support. 
 
We have checked your query. We can able to achieve your requirement by using showHeaders property as false in Spreadsheet. Please refer the below code snippet and sample 
 




 
let spreadsheet: Spreadsheet = new Spreadsheet({ 
  sheets: [ 
    { 
      showHeaders: false, 
      name: 'Car Sales Report', 
      ranges: [{ dataSource: (dataSource as any).defaultData }], 
      rows: [ 
        { 
          index: 30, 
          cells: [ 
            { 
              index: 4, 
              value: 'Total Amount:', 
              style: { fontWeight: 'bold', textAlign: 'right' } 
            }, 
            { formula: '=SUM(F2:F30)', style: { fontWeight: 'bold' } } 
          ] 
        } 
      ], 
    } 
  ], 
  } 
]}) 
 
 
Sample: https://stackblitz.com/edit/bqkbge  
 
Could you please check the above details, and get back to us if you need assistance on this. 
 
Regards, Aravinthan S