We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Incorrect usedRange property


I would like to report a bug where the sheet has an incorrect value of usedRange, when the cells are filled in a certain order.

UsedRange is:

"rowIndex": 0,
"colIndex": 0

when we omit the first cell, we insert the data into the next ones, and in the last step we complete the first cell.

If we start filling the sheet from the first cell or it is not the last filled cell then usedRange will show the correct value.

I am using the Spreadsheet v. 19.4.56.

PS. I have attached screenshots of the cell filling order and the usedRange result.

Best Regards,

Ignacy Mielniczek

Attachment: usedRange_f84b116b.zip

1 Reply

SP Sangeetha Priya Murugan Syncfusion Team November 17, 2022 04:52 AM

Ignacy, we have resolved the usedRange issue in our later release and it is properly working now. So, we suggest you to use our latest version 20.3.56 to resolve the reported issue on your end. Please find the sample in the latest version.

Sample Link: https://stackblitz.com/edit/angular-n5gms1?file=app.component.html,app.component.ts

Live Chat Icon For mobile
Up arrow icon