Rows limitation and how to get to the end

[Serge DUDNIC]

Spreadsheet.

Is there a row number limitation?

How to get to the end of the data area?

In Excel, when I have some data, I press the Ctrl+DownArrow and I go to the last line of the available data.

I pasted some 15 thounsands lines in your demo spreasdsheet. and tried to go to the end. I didn't find a way.

The Ctrl+End combination seems to be buggy, as it works only when we mouse click on the sheet, and it does not go to the end of the data, but just scrolls down several lines....

[Sangeetha Priya Murugan]

Hi Serge, 

 

Thank you for contacting Syncfusion support. 

 

We have checked your reported issue and it can be achievable in our Spreadsheet, by binding the keyDown event in the spreadsheet created event as like as below. 

 

<ejs-spreadsheet id="spreadsheet" created="onCreated"> </ejs-spreadsheet>   

 

  function onCreated() { 

        var ssObj = ej.base.getComponent(document.getElementById('spreadsheet'), 'spreadsheet'); 

        ssObj.element.addEventListener("keydown", event => { 

            if (event.ctrlKey && event.keyCode == 35) { // for CTRL+End key 

                var actSheet = ssObj.getActiveSheet(); 

                var usedRange = actSheet.usedRange; 

                ssObj.goTo(actSheet.name + "!A" + usedRange.rowIndex.toString()); // to Navigate the last row of used range 

            } 

        }); 

    } 

 

For your convenience, we have prepared the sample based on our suggestion. In this sample, it will move the last row of the used range in the active sheet. Please find the link below. 

 

Sample Link: https://www.syncfusion.com/downloads/support/forum/164451/ze/SpreadsheetSample-1756338887  

 

However, we will consider this as an improvement, and it will be available in any of our upcoming releases. You can track the status of this defects using below link from our feedback portal,  

 

Feedback Portal Link: https://www.syncfusion.com/feedback/24256/need-to-provide-ctrlend-support-in-spreadsheet  

 

Could you please check the above sample and kindly get back to us, if you need further assistance on this? 

 

Regards, 

Sangeetha M