Limit Columns in Spreadsheet

[David Aberl]

Hi,

I wanted to ask, if it is possible, to limit the Columns in the Spreadsheet Component to only inlcude only a specific number of columns.

That would be great to enforce a specific structure in the Spreadsheet while maintaining the Editation and Formatting possibilities.

Thanks & Best regards,

David

[Janakiraman Sakthivel]

Hi David Aberl,  

  

Thank you for contacting Syncfusion support.  

  

We have checked your reported query and we need to validate more on this. So, we will update you the further details on October 1^st, 2021. We appreciate your patience until then.  

  

Regards,  

Janakiraman S.  

[Janakiraman Sakthivel]

Hi David Aberl, 

 

Thank you for your patience. 

 

We have checked your reported requirement and we are able to set the column limit in the spreadsheet. By setting the isFinite property as true in scrollSettings and set colCount properties in sheet property as like in the below code example. 

 

Code Example: 

<ejs-spreadsheet #default [openUrl]="openUrl" [saveUrl]="saveUrl" [scrollSettings]="{ isFinite: true }"> 

        <e-sheets> 

            <e-sheet name="Car Sales Report" colCount="2"> </e-sheet> 

        </e-sheets> 

    </ejs-spreadsheet> 

 

Documentation Link: https://ej2.syncfusion.com/angular/documentation/spreadsheet/scrolling/#finite-scrolling-with-defined-rows-and-columns 

 

Note: If you don’t need of empty space at the right, you need to set the width of the spreadsheet based on the total column width. Spreadsheet control rendered based on the width of the element div. 

 

Could you please check the above details and get back to us, if you need any further assistance on this. 

 

Regards,  

Janakiraman S.