JavaScript / HTML5のニュース

他のワークシートからスプレッドシートデータへのアクセス

4月 30, 2024
ワークシート間の計算により、複雑な操作の簡素化、データ分析の有効性の強化、情報に基づいた意思決定が容易になります。

Cross-worksheet calculations involve using formulas within spreadsheet applications to reference and manipulate data across multiple worksheets within the same workbook. This allows you to consolidate and analyze information from various sections of your spreadsheet without consolidating it into a single worksheet. The ability to carry out such calculations simplifies complex operations enhances the efficiency and effectiveness of data organization and analysis.

Several React spreadsheet components support cross-worksheet calculations, including:

  • Telerik Spreadsheet React (part of KendoReact) offers your applications seamless cross-worksheet formula support, enhancing productivity by enabling consolidated analysis across your spreadsheets.
  • Wijmo FlexSheet (part of Wijmo by MESCIUS) supports nearly 100 formulas and facilitates dynamic inter-sheet operations, allowing users to efficiently perform calculations and manage data across worksheets within your React applications.
  • Syncfusion Spreadsheet JavaScript (part of Syncfusion Essential Studio Enterprise) provides your React projects with cross-worksheet formula capabilities so you can leverage data from various sheets for comprehensive analysis and dynamic calculations.
  • Infragistics Spreadsheet React (part of Infragistics Ignite UI) features a powerful React spreadsheet component with built-in cross-worksheet formula functionalities, enabling you to efficiently combine and analyze data from separate sheets.

For an in-depth analysis of features and price, visit our comparison of React spreadsheet components.

Compare React Spreadsheet Components

選択範囲内のセル間をシームレスに移動

4月 26, 2024
Handsontable 14.3を使用すると、経験豊富なグリッドユーザーは、キーボードショートカットを使用して選択範囲内の特定のセル間をすばやく移動可能

Handsontable is a JavaScript library designed to help developers build interactive data grids into their web applications. Offering a familiar spreadsheet-like interface, it allows users to edit, sort, and filter data with ease. Highly customizable and compatible with popular frameworks like React and Angular, Handsontable empowers developers to build robust data manipulation features into their web applications.

Handsontable 14.3 adds a new feature to streamline navigation within pre-selected cells. Power users and those accustomed to Tab navigation can now leverage arrow keys or the mouse for selection, then efficiently move between the chosen cells using Tab/Shift+Tab for horizontal movement and Enter/Shift+Enter for vertical movement. Editing remains intuitive, as typing any character initiates editing even within dropdown or date cells.

To see a full list of what's new in version 14.3.0, see our release notes.

Handsontable is licensed per developer and is available as an Annual or Perpetual license with 1 year support and maintenance. See our Handsontable licensing page for full details.

For more information, visit our Handsontable product page.

Nextcloudによるきめ細かなアクセス制御の活用

4月 25, 2024
ONLYOFFICE Nextcloud Connector v9.1では、Nextcloud Talkファイルとパブリックアクセスのファイルのレビュー、コメント、カスタムフィルターの権限を設定可能

ONLYOFFICE Docs Enterprise Edition with Nextcloud Connector combines an online document editor with a seamless integration for Nextcloud, which is a open-source, on-premises content collaboration platform. This allows teams to create, view, edit, and collaborate on spreadsheets, presentations, and text files online, directly within Nextcloud, boosting efficiency and eliminating the need for file switching.

The ONLYOFFICE Nextcloud Connector v9.1 release (available as part of ONLYOFFICE Docs Enterprise Edition with Nextcloud Connector v8.0.1) brings enhanced security and granular control for developers working with public document sharing and Nextcloud Talk. Advanced access permissions for reviewing, commenting and custom filtering are now available for files with public access and for files created within the Nextcloud Talk app. These permissions ensure that external collaborators can contribute without compromising document integrity or security. It also promotes a more structured and controlled environment for real-time collaboration, ensuring that contributions are tracked and managed effectively according to the roles defined by the document owner.

To see a full list of what's new in ONLYOFFICE Docs Enterprise Edition v8.0.1 with Nextcloud Connector v9.1, see our release notes.

ONLYOFFICE Docs Enterprise Edition with Nextcloud Connector is licensed per server and is available as an annual license with 1 year of support and updates, or as a perpetual license with 3 years of support and updates. See our ONLYOFFICE Nextcloud connector licensing page for full details.

For more information, see our ONLYOFFICE Nextcloud connector product page.

ドッキングコントロールでワークスペースをカスタマイズ

4月 24, 2024
ドッキング機能を備えたUIスイートにより、ユーザーは直感的なドラッグアンドドロップウィンドウ配置でワークスペースをカスタマイズ可能

Docking controls are a user interface element that allows users to organize and customize the layout of an application's windows. These controls typically function by enabling users to drag-and-drop windows or panes to different positions on the screen, or to attach them to the edges of the main application window. This functionality provides several benefits, including increased efficiency by allowing users to arrange windows in a way that suits their workflow, improved organization by keeping relevant windows grouped together, and better screen real estate utilization by enabling users to resize and position windows for optimal viewing.

Several React UI suites feature a docking component including:

  • Infragistics Ignite UI empowers developers with customizable docking layouts for complex and data-rich UIs.
  • jQWidgets offers a docking framework for building user-configurable dashboards with drag-and-drop functionality.
  • Smart HTML Elements facilitates the creation of intuitive UIs with a docking component that promotes flexible window management.
  • SmartClient by Isomorphic Software provides a docking solution that enables users to personalize their workspace layouts.

For an in-depth analysis of features and price, visit our React UI Suites comparison.

Compare React UI Suites

グリッドの視覚的な煩雑さを軽減

4月 24, 2024
列を非表示にし、ユーザーは無関係なデータを一時的に削除してグリッドビューをカスタマイズして、より効率的な分析が可能

Hiding columns in a grid allows for a more focused data display by selectively removing irrelevant or less important information from the user's view. This functionality improves data clarity, particularly for grids with a large number of columns. By hiding specific columns, users can concentrate on the most important data points, reducing clutter and improving overall user experience.

Several jQuery Grid controls offer the ability to hide columns including:

  • DevExtreme HTML5 JavaScript Data Grid (part of DevExtreme Complete by DevExpress) empowers users to selectively hide columns for a focused data view.
  • Kendo UI for jQuery Grid (part of Kendo UI by Telerik) enables column hiding to prioritize relevant information and minimize clutter.
  • Syncfusion Grid control for JavaScript (part of Syncfusion Essential Studio Enterprise) facilitates hiding columns to enhance clarity and user experience with large datasets.
  • Ignite UI jQuery Grid (part of Infragistics Ignite UI) allows you to customize the grid by hiding columns for a streamlined data presentation.

For an in-depth analysis of features and price, visit our jQuery Grid controls comparison.

Compare jQuery Grid Controls