Noticias sobre JavaScript / HTML5

Acceda a datos de hojas de cálculo desde otras hojas de cálculo

Abril 30, 2024
Los cálculos entre hojas de trabajo simplifican las operaciones complejas, mejoran la eficacia del análisis de datos y facilitan la toma de decisiones informadas.

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

Navegue de forma fluida entre celdas dentro de selecciones

Abril 26, 2024
Handsontable 14.3 permite a los usuarios de cuadrículas experimentados moverse rápidamente entre celdas específicas dentro de una selección utilizando métodos abreviados de teclado.

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.

Utilice control de acceso granular con Nextcloud

Abril 25, 2024
ONLYOFFICE Nextcloud Connector v9.1 permite establecer permisos de revisión, comentario y filtro personalizado para archivos de Nextcloud Talk y archivos de acceso público.

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.

Personalice su espacio de trabajo con controles de acoplamiento

Abril 24, 2024
Las suites de interfaz de usuario con funcionalidad de acoplamiento permiten a los usuarios personalizar su espacio de trabajo a través de una disposición intuitiva de ventanas mediante arrastrar y soltar.

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

Reduzca el desorden visual en sus cuadrículas

Abril 24, 2024
La ocultación de columnas permite a los usuarios personalizar su vista de cuadrícula eliminando temporalmente los datos irrelevantes para un análisis más eficiente.

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