how to use columnCount member and scrollMode set like infinitive

Hi,

Let me explain my case. I try to set spreadsheet control with just 10 columns to avoid horizontal scrolling, for that I used the property columnCount = 10 but this works just if I set the property scrollMode = normal. 

The thing is that I need to use scrollMode like infinitive because I need set the property allowVirtualScrolling like true because I'm using that to create some stuffs like dropdowns on demand and for that I'm using virtual scrolling and avoid that spreadsheet work very slowly.

Any suggestions about how to set the columns number (for my case just 10 columns) without set the property scrollMode = normal?

I'm working with the version 17.1.0.38.

Thanks and regards!


1 Reply

SD Saranya Dhayalan Syncfusion Team May 15, 2020 05:03 AM UTC

Hi Josue, 
 
Thank you for contacting Syncfusion support 
 
We have checked your reported issue, we suggest you set scollMode is normal and set maximum rowcount and set columnCount as 10. Please find the below code snippet: 
 
<body ng-controller="SpreadsheetCtrl"> 
    <div id="Spreadsheet" e-rowcount=100000 e-columncount=10 ej-spreadsheet e-scrollsettings-allowscrolling="true" e-scrollsettings-scrollmode="Normal" e-scrollsettings-height="400" e-scrollsettings-width="50%"></div> 
</body> 
 
<script> 
    var syncApp = angular.module("defaultApp", ["ngRoute", "ejangular"]); 
    syncApp.controller('SpreadsheetCtrl', function ($scope, $rootScope) { 
    }); 
</script> 
</html> 
 
 
For your convenience we have prepared a sample. Please find the below sample link 
 
 
Please check the above sample and get back to us if you need further assistance on this. 
 
Regards, 
Saranya D 


Loader.
Up arrow icon