A new version of the JavaScript spreadsheet library "SpreadJS V15J" with abundant Excel compatible functions such as printing, searching and replacing will be released on March 24th!

GrapeCity Co., Ltd. (Headquarters: 3-1-4 Murasakiyama, Izumi-ku, Sendai City, President: Naoyuki Baba) will release a new version "V15J" of "SpreadJS" to support business application development in March 2022. It will be released on the 24th (Thursday).

SpreadJS is a JavaScript product that realizes a Microsoft Excel (R) -like UI for web applications. It is sold by a one-year flat-rate subscription method, and the initial cost is 165,000 yen (10% tax included) for one development license and 660,000 yen (10% tax included) for one distribution license (1 domain). The renewal price for the development license and distribution license after the second year will be 165,000 yen (10% tax included) for both licenses.

SpreadJS V15J released

SpreadJS has a component "Ribbon Container" that can realize a ribbon menu, formula bar, and status bar on a Web application in addition to an Excel-like spreadsheet, and you can easily design a sheet with the same operation feeling as Excel. The application "SpreadJS Designer" is installed.

By using these, you can instantly realize a screen with a UI and functionality like Excel.

The new version "V15J" has many functions compatible with Excel in this "Ribbon Container" and "SpreadJS Designer". For example, you can now display the search / replace dialog using the [Ctrl] + [F] shortcut keys, and make detailed print settings from the file menu or page layout tab. In addition, we have added a function that allows you to divide text data and a function that deletes duplicate data.

In addition, the "pivot table" that can aggregate and analyze huge amounts of data supports the slicer function. It is possible to easily extract the necessary data with an intuitive and easy-to-understand operation.

In addition, it is equipped with a function that allows you to set the style for each column or row of the sheet. By changing the background color and font color for various actions from the system user, such as when editing or selecting the specified row / column, or when hovering the mouse, you can expect to improve the visibility of the data. .. This feature is a new feature unique to SpreadJS that Excel does not have.

■ For details on SpreadJS, see the web page.

https://www.grapecity.co.jp/developer/spreadjs

■ New features of SpreadJS V15J

[Enhanced functions of Ribbon Container / SpreadJS Designer]

・ Search / replace with shortcut keys

Press [Ctrl] + [F] to display the "Find and Replace" dialog, where you can find or replace any string in the worksheet or the entire workbook. With the optional function, it is also possible to specify more detailed narrowing conditions such as search location, search target, "case-sensitive" and "exact match".

[Ribbon Container / SpreadJS Designer Enhancements] Search / Replace

·printing

You can print using the [File] menu with the same operation feeling as Excel. A "Page Layout" tab has been added to the ribbon menu, allowing you to set printing margins, paper orientation, paper size, print range, page breaks, and more. It also supports the display of the page setup dialog.

[Ribbon container / SpreadJS designer enhancement] Printing

・ Automatic division of text data

You can use a dedicated dialog to split a string separated by commas, tabs, spaces, etc. and display it in individual cells.

[Ribbon container / SpreadJS designer enhancement] Automatic division of text data

-Automatic deletion of duplicate data

Added the function to automatically delete duplicate data found in the selection.

[Ribbon container / SpreadJS designer enhancement] Automatic deletion of duplicate data

[New features and enhancements of pivot table]

・ Slicer

Supports the "slicer" function of the pivot table. By using this function, you can intuitively narrow down the pivot table data using the filter panel on the sheet.

[New features and enhancements of pivot table] Slicer

・ Aggregate items

In addition to the summary field, it has an "aggregate item" function. You can aggregate any content of the pivot table on an item-by-item basis.

[New features and enhancements of Pivot Table] Aggregate items

[New features of spreadsheets]

It is possible to set the style according to the state of the row or column.

You can set row / column styles for mouse hover, edit, active, select, edit, insert, and validation disabled states to improve the visibility of the data on the sheet. ..

Spreadsheet styling

■ New features of SpreadJS V15J

https://www.grapecity.co.jp/developer/spreadjs/release/15

■ Company profile

Company name: GrapeCity Co., Ltd. [GrapeCity inc. Abbreviation: GrapeCity]

Date of establishment: May 1980

Capital: 90 million yen

Representative name: Directly to Baba

Corporate site: http://www.grapecity.co.jp

Business: Development and sales of software development support tools

https://www.grapecity.co.jp/developer

Development and sales of business improvement solutions

https://www.grapecity.co.jp/enterprise

Development and sales of business management software for school corporations

https://leyser.jp/

Various video production and studio provision

http://www.winestudios.com

Development and sales of infant English education solutions

https://grapeseed.com/jp

Development and sales of software for social welfare facilities

https://www.serve.jp

Domestic office: Headquarters 3-1-4 Murasakiyama, Izumi-ku, Sendai City / Kanto Branch / Kansai Branch /

Kita-Kanto Sales Office / Metropolitan Area Sales Office / Kyushu Sales Office

Overseas offices: USA / China (Shanghai / Xian) / India / Vietnam / Korea /

Malaysia / Myanmar

-Microsoft and Windows are registered trademarks or trademarks of Microsoft Corporation in the United States and other countries.

-GrapeCity and SpreadJS are registered trademarks or trademarks of GrapeCity Co., Ltd.

-Other product names mentioned are registered trademarks or trademarks of each company.