Unstack/Pivot Table Improvements

(ORG-3656)

Better Support of Other Columns in Unstack

(ORG-4606)

When unstacking columns in a worksheet, "other columns" were not handled properly in previous version.

Origin 9.1 introduce options to handle data in other columns properly

• Matching Longest Group (same operation as 90)
• Combining All Groups

Pivot Table Improvements

Pivot table is improved to have proper logic when handling the cases for combining smaller values

Improve Sorting Order Issues in Pivot Table (ORG-8280)

• Sort results by Row/Column Totals does not work correctly if row/column total is not output.
• Sort labels ascending as the secondary sort sequence when total values are equal.
• Sort by numeric value when source data is Month/Day of Week format.