Numeric/Date Format Conversion Issues

JIRA	Summary	Detail
ORG-8972	GUI not convert numeric format to date format	In 9.0, using column property to change numeric to date format is not working well. In 9.1, user can convert the format by setting Column Format first to be Text, and then set to Date.

Set Column Value Related

JIRA

Summary

Details

ORG-8692

Formula with row indexing i failed to expand range

If there is row indexing i in Set Column Values dialog and when user enters more rows in source column, the Set Column Values doesn't update to have new values in new rows. Fixed in 9.1.

E.g. Fill Column A with row numbers. Set Column B's Value as col(A)[i]*4. Make sure Recalculation Mode is Auto. Add more rows in the worksheet and enter more values in new rows. new rows in Col(B) will not be filled. If Set column B's Value is col(A)*4, no such problem.

ORG-6080

Set Column Value not Updated When Containing Values From Column Label

In 9.0, when Set Column Value using values from column labels, changing the labels does not trigger to Recalculate. In 9.1, it fixes this. @AUL = 0 to turn this off.

ORG-8237

Not remove value if reference column not existing

In 9.1, it will output error message "Invalid column name" if column is not existing.

Worksheet Manipulation

JIRA Summary Detail

ORG-8696 Categorical setting for locked column A locked column should not be allowed to be set as categorical. This problem exists since version 8.0 at least.

ORG-8209

Clear Worksheet fails if Some Analysis Was on Part of a Column

This bug existed since Origin 9.0 SR1. Fixed now.

Easy way to reproduce it:

New a workbook and fill row number to it.
Highlight partial range in col(B).
Open Linear Fit dialog, click OK directly to make a fit.
Active source data sheet, select menu Worksheet: Clear Worksheet.

==> Data in report sheet and flat sheet is not cleared.

ORG-8207

Error to Sort Worksheet with One Row

If worksheet only contains one row, the following commend to sort worksheet by column would report error. In 9.1, it fixes this.

wsort bycol:=2;

ORG-8873

Reduced Row Issues When Data Contains Null

In 9.0 when use Worksheet: Reduce Rows: Delete Rows with Missing Value, it deletes missing value but not for null data. In 9.1, it fixes.

ORG-9028 XYZ Gridding: Regular Method Not Working Well for Large Dataset When converting a large dataset to matrix using XYZ Gridding: Regular Method, even the data is evenly distributed, it would report error. In 9.1, it's fixed.