Incorrect usedRange property

[Ignacy Mielniczek]

Hello,

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

[Sangeetha Priya Murugan]

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