Unplanned
Last Updated: 20 Apr 2021 08:06 by ADMIN
David M
Created on: 20 May 2016 16:33
Category: Spreadsheet
Type: Feature Request
32
Dynamically change the number of rows
Use case:
My app doesn't know how many rows of data the excel spreadsheet will be prior to upload.  I've defaulted to my maximum amount of 10,000 which will be normal for some, but overkill for others.  The ability to change the number of rows/columns to accommodate the size of the sheet after loading, would be a nice addition.  

As a workaround, I'm destroying and reloading the widget instance after the initial load.
7 comments
ADMIN
Ivan Danchev
Posted on: 20 Apr 2021 08:06

Hello,

Thank you for your suggestions. We will consider all of them.

Regards,
Ivan Danchev
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

serge
Posted on: 13 Apr 2021 08:43

I would add, there should be a possibility to auto-add the rows, if the current cell along with the pasted range "overflows" the existing row number.

 

Suppose I have 10 rows, I am in the last row, and I paste 10 000 rows from clipboard. The row number should increase to 10 009, and all the values should be pasted and available in the sheet.

Naveen
Posted on: 11 Jun 2020 11:21
Yes, this is must have feature in context of Excel functionalities. Please plan it in your next release.
Seuthes
Posted on: 29 Apr 2019 06:24

Totally agree to Steve.

A sheet should expand automatically, when a user fills the last rows. Such a behavior would also be nice for the columns.

Steve
Posted on: 27 Feb 2017 16:11
The workaround is a tad cumbersome, would be nice to be OOTB.  Kinda seems like a feature that was just missed nobody thought of it in testing, but really kinda needs to be here.

I would also really like the ability to specify a buffer, so like if I specify 20 as the buffer and the Datasource returns 1000, I then have 1020 rows in the sheet.
James
Posted on: 08 Nov 2016 05:33
You could use "insertRow" and "deleteRow" to get the correct rows back.

However, as always with major UI updates, put it into "batch":
{{{
.batch(function () {
   .. Code to insert/remove rows
        }, { layout: true });
}}}
ADMIN
T. Tsonev
Posted on: 04 Nov 2016 17:47
Hi,

The fromJSON method (http://docs.telerik.com/kendo-ui/api/javascript/ui/spreadsheet#methods-fromJSON) on the Workbook will create a sheet with the appropriate size to accommodate all records. 

Additionally, you don't need to re-create the whole Widget, just call `insertSheet` with the appropriate size.

Does this help?