Treat missing as blank Improvements

Version: 2019

Type: Features

Category: Data Handling

Subcategory: Workbook and Worksheet

Jira: ORG-14837

  • 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.