Neuigkeiten zu JavaScript / HTML5

Zugriff auf Tabellenkalkulationsdaten aus anderen Arbeitsblättern

April 30, 2024
Arbeitsblattübergreifende Berechnungen vereinfachen komplexe Vorgänge, verbessern die Effektivität der Datenanalyse und erleichtern eine fundierte Entscheidungsfindung.

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

Nahtloses Navigieren zwischen Zellen innerhalb von Auswahlen

April 26, 2024
Handsontable 14.3 ermöglicht es erfahrenen Grid-Benutzern, mithilfe von Tastaturkürzeln schnell zwischen bestimmten Zellen innerhalb einer Auswahl zu wechseln.

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.

Nutzen Sie die granulare Zugriffskontrolle mit Nextcloud

April 25, 2024
Mit ONLYOFFICE Nextcloud Connector v9.1 können Sie Überprüfungs-, Kommentar- und benutzerdefinierte Filterberechtigungen für Nextcloud Talk-Dateien und solche mit öffentlichem Zugriff festlegen.

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.

Anpassen Ihres Arbeitsbereichs mit Docking-Steuerelementen

April 24, 2024
UI-Suiten mit Docking-Funktionalität ermöglichen Benutzern die Personalisierung ihre Arbeitsbereichs durch intuitive Anordnung des Drag-and-Drop-Fensters.

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

Übersichtliche Gestaltung von Rastern

April 24, 2024
Durch das Ausblenden von Spalten können Benutzer ihre Rasteransicht anpassen, indem sie irrelevante Daten vorübergehend entfernen, um eine effizientere Analyse zu ermöglichen.

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