4D 20 R7 comes with a new version of SpreadJS, v17.1, and a Ribbon update that is compatible with it. Let’s discover the new features this new version offers to help accelerate your 4D View Pro development.
Move/Insert Column or Row by Dragging Headers
Columns and rows can now be moved or inserted by dragging the headers. This can be enabled by setting the allowDragHeaderToMove enumeration of the spread options to row, column, or both. This can also be enabled in the Ribbon:
Chart Enhancements
Waterfall Charts
A new chart type has been added to 4D View Pro: the Waterfall chart. This shows a running total as values that are added or subtracted. These values are arranged as columns with positive and negative values and are color-coded to distinguish between the two. The initial and final columns are typically aligned against the horizontal axis, whereas the intermediate values are typically floating columns.
Smooth Lines Format for Line Charts
Line charts in 4D View Pro now support formatting with smooth lines.
Inserting Charts with Multi-Selections
Similar to Excel, 4D View Pro now supports inserting charts using multi-selections. In addition to selecting a continuous area of data, you can now also press the Ctrl key to select multiple, non-contiguous areas to create a chart.
These ranges can be specified in multiple ways, and 4D View Pro will create the chart accordingly:
Sparkline Enhancement
Lollipop Variance Sparkline
The new Lollipop Variance Sparkline lets you show absolute and relative variances in a dataset. It is similar to a bar chart but reduces the display space by using lines instead of rectangles. As a result, they are more useful when dealing with large amounts of data.
Workbook Enhancements
Additional Paste Special Options
4D View Pro now supports even more paste special options, including:
- Comments – Paste only comments
- Validation – Paste only data validation rules
- All using Source theme – Paste all cell contents in the same worksheet theme
- All except borders – Paste all cell contents and formatting except for the borders
- Column Widths – Paste the width of one copied column or range of columns
- Formulas and Number Formats – Paste only formulas and all number formatting options
- Values and Number Formats – Paste only values and all number formatting options
Sheet Tabs Style Support
Sheet tabs now support styles that the user can set. The style includes the text style, background color, and icon.
TopRowChanged/LeftColumnChanged Event Enhancement
The TopRowChanged and LeftColumnChanged events now support pixel scrolling. Before this change, the entire row or column would have to be scrolled before the event would fire, but now it will fire and provide the scrolling status for any change in the scrolling when pixel scrolling is enabled.
Distributed Horizontal Alignment
4D View Pro now supports Distributed Horizontal Alignment for text. This is simple for the center alignment, except it will also wrap text automatically.
Preserve Last Excel Sort State
When importing Excel files, 4D View Pro now preserves the sort condition so that it is not lost.
Demo | HSpreadJS Documentationelp
Conclusion
With the 4D 20 R7 release, 4D View Pro now includes SpreadJS version 17.1, bringing new features such as enhanced chart types (Waterfall charts and smooth lines for line charts), multi-selection for chart insertion, improved Sparkline types, and further workbook and alignment enhancements. This update streamlines 4D View Pro development, offering improved functionality and performance.
Need more information? Take a detailed look at these SpreadJS v17.1 advances, and share your experience on the 4D forum.