Worksheet (ORG-6133)
Sparkline Improvements (ORG-7319)
Histogram and Box chart as Sparkline (ORG-8263)
Log10 X and Y support (ORG-7319)
Choose Column:Add or Update Sparklines...
Add Graph as Sheet (ORG-8797)
Right click sheet tab and choose Add Graph as Sheet... from the context menu. Creates a new sheet and adds one graph to a single worksheet cell.
Double click on the embedded graph to open an editable graph window. Note that th editable graph window has an arrow-like button in the upper right corner (in place of the usual Windows "delete" button). To exit the editable window and preserve customizations, click this arrow button. This closes the editable window and pushes updates back to the embedded graph.
Right click and choose Restore Window to delete the embedded graph and break the link to the original graph window.
Generate Patterned Data (ORG-7792)
Fill Column with patterened/random numbers, patterened/random date/time values, patterened or random set of strings.
Set Column Value Improvements (ORG-9021)
Formula column label row (ORG-6669)
User can right click workbook title and choose View: Formula to turn the formula on.Then type formula directly using the same syntax as used in Set Column Values dialog. E.g. col(B)-col(A), sin(col(A)), i*2, etc.
User can also open Set Column Values as before to set formula. The formula label row will update.
User can also uncheck Options: Direct Edit Formula Cell, and then choose Options: Formula Text... to type in some explanation of the formula, in cases like formula is complicated, etc.
Support subrange notation in Formula (ORG-9044)
E.g. enter StdDev(col(A)\[i-5:i+5]) in Formula to do running statistics
More built-in Functions added – todo (ORG-8781 ORG-7697 ORG-8945)
Different moving average functions are added under F(X): Statistics: menu.
E. g. Exponential Moving Average, Modified Moving Average, Triangular Moving Average, Weighted Moving Average
Keep Text option (ORG-8555)
In the past, if there are text in some data rows of a column, Set column value will change them into missing values.
Set Multiple Column Values (ORG-8554)
Select Multiple contiguous columns and choose Set Multiple Column Values context menu.
Use wcol(j) or cell(i,j) to refer to selected columns, e.g.
Example 1: Set Column B, C and D to be log10 of their original values.
Example 2: Set Whole Sheet2 to be all Values in Sheet1 times 10.
Reduce Columns (ORG-8538)
Choose Worksheet: Reduce Columns... menu.
We also added reduce by merged values option in Reduce Rows dialog.
Sort Column by Values in Column Label Rows - (ORG-8340)
You can sort worksheet columns by information in column label rows. From the main menu, choose Worksheet: Sort Columns by Label...
Column Filter Improvements (ORG-6064)
Copy Column To and Save Filter Info. in Operation (ORG-6078)
Sometimes user may want to change filter conditions and want to plot the graphs for each filter conditions. User can use Copy Columns To context menu to copy the columns to elsewhere and save the filter condition within the copied data. Then plot graph from it.
Then if user changes original worksheet's filter conditions, it will not affect the copied data and its graph.
Row index i support in condition (ORG-7975)
Stack/Unstack/Pivot Table Improvements (ORG-3656)
More Copy Column options (ORG-7937)
Select a column and right-click >
- Copy (Formula): Copy Set Column Value settings
- Copy (Label Rows): Copy Column Rows
- Copy (Formula and Label Rows): Copy both Set Column Value Settings and Label Rows
