Shulou(Shulou.com)06/03 Report--

We are pleased to announce that SpreadJS, a pure front-end Excel tabular control, has officially launched a new version of V12, which includes many heavyweight features and new requirements from customers, such as support for shapes and rich text, new chart types, and more updates in detail.

Shapes (Shapes): add built-in or custom shapes in SpreadJS as needed

SpreadJS V12 has implemented many Excel-like built-in shapes, such as lines, rectangles, arrows, and flowcharts, to add more detail and visualization to your front-end interface, and these built-in shapes can be imported and exported seamlessly.

(figure: SpreadJS V12 built-in shape)

You can also customize the shape you need with the new ability provided by SpreadJS V12, and all shape properties can be set to formulas, which means that your shape can change as the data changes, thus greatly improving the effect of your front-end interface. The following example is an example of using custom shapes to implement an insurance claims interface

(figure: SpreadJS V12 Custom shape-Insurance claims example)

Rich text format (RichText Formatting): contains different text formats in the same cell

With rich text formatting, users can now add bold, italic, font and all basic formatting to a single cell!

(figure: SpreadJS V12 rich text format)

Added chart types: radar (Radar), rising sun (Sunburst) and tree (Treemap)

With rich text formatting, users can now add bold, italic, font and all basic formatting to a single cell! These new charts (also available in Excel) have full SpreadJS online tabular editor support, and you can seamlessly import and export Excel files that contain these charts.

A radar map (Radar) displays multivariable observations with any number of variables; it is usually used to express personality characteristics.

(figure: new radar map (Radar) for SpreadJS v12)

The rising Sun Map (Sunburst) shows hierarchical data from the root node (center) outward to a lower hierarchy. The segment of the inner circle is the parent of the segment of the outer circle, which is within the angular scanning range of the parent. The rising sun map is ideal for showing how a category or level (ring) can be broken down into its approximate proportion.

In the following example, the world population is represented by continents, regions, and countries, and distinguished by colors. As a result, the distribution of the population immediately became clear:

(photo: new rising Sun Map (Sunburst) in SpreadJS v12)

The tree diagram (Treemap) shows the hierarchical information combined with the relative amount. They are especially useful if your application has space constraints and you need to draw thousands of data points using many entities defined in the tables in the worksheet.

The following is a chart of the world population shown in a tree chart:

(figure: SpreadJS v12 New Tree (Treemap))

Added Sparkline type: bar code (Barcode)

By setting the mini chart type, you can easily render the bar code you need in the cell. SpreadJS V12 already supports QRCode, EAN-13, EAN-8, Codabar, Code39, Code93, Code128, GS1_128, Code49, PDF417, DataMatrix.

Chart animation effect

Create new seamless load and update animations for bar, bar, line and pie charts with SpreadJS to make your dashboard really shine.

(figure: SpreadJS v12 added Chart Animation)

Accurate selection of Class Excel

The new feature of Excel allows the user to select a range and then deselect specific cells. This feature has been added to SpreadJS.

(figure: precise selection of new class Excel in SpreadJS v12)

About the city of grapes:

Empowered developer! Founded in 1980, Grape City Group is the world's leading software and service provider integrating development tools, business intelligence solutions, and management system design tools. Xi'an Grape City is its branch in China, providing software research and development services to the global market, and providing international advanced development tools, software and R & D consulting services for the informatization of Chinese enterprises. Grape City's controls and software products have won many awards at home and abroad, and have been widely used by hundreds of thousands of enterprises, schools and government agencies around the world.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.