Treat missing as blank Improvements
Category: Data Handling
Subcategory: Workbook and Worksheet
Missing values will show as blank in worksheet.
When importing excel file with empty cells, or copy and paste data with empty cells from Excel,
Before Origin 2019, when copying some data with blank rows above it and pasting it to new column, blank rows were removed. In Origin 2019, they are kept.
If there are empty cells above the data, below data or within data range, click on it, status bar shows <i1:, >i2:, or nothing correspondingly. These empty cells will not be included in calcuation, statistics.
When selecting a cell outside the data bound, status bar will show "<i1: "(begin) or ">i2: "(end).
Worksheet cell background color show differently if outside i1 i2 by default. There is a checkbox Indicate unused cells with a shaded background in Workbook Properties dialog. System variable @COR determines the darkening intensity.
i1 starts from 1st row unless set otherwise.
Delete data on last row will shrink data size (i2 updates)
Ctrl+delete to add missing value to a cell, in cases that user wants to make sure each column has same length.