Worksheet row size auto reduces if source data used in calculation is reduced


Version: 2025b

Type: Bug Fixes

Category: Data Handling

Subcategory: Worksheet

Jira: ORG-30686


In older versions, after deleting input data still leaves a lot of empty rows in output column and will accumulate file size.

To see the issue:

  1. In worksheet, fill column A with 1 million numbers (rows), e.g. run col(1)=data(1,1E6) in Script window.
    ? The workbook size will be 10MB.

  2. Set Column B formula as A+1. The workbook size becomes 19MB.

  3. Select row 10 to end in column A and press Delete
    ==> Data are deleted in both column A and B but the empty rows still exists so workbook size is still 19MB.

Same issue if column is used in other worksheets. If saving project, the file size will be big and recalculation will be slow.

Fixed in Origin 2025b.