JavaScript / HTML5 News

Support Diverse Cell Types in Your Spreadsheet Apps

February 27, 2024
Enhance the flexibility and insights derived from your data with dedicated cell types for numbers, dates, formulas, and more.

Using varied cell types in spreadsheets enhances organization, efficiency, and clarity. Text-based cells streamline labeling and categorization, while numeric cells enable calculations and analysis. Date and time cells simplify the tracking of schedules and deadlines. Formulas automate complex computations, and logical cells support conditional formatting and decision-making processes. This diversity in cell types optimizes data representation and manipulation, making your spreadsheets more powerful and versatile tools.

Several JavaScript spreadsheet controls offer support for different cell types, including:

  • Telerik Spreadsheet for jQuery offers a variety of cell types including numeric, text, date, and boolean, along with the ability to define custom cell types and formatting.
  • SpreadJS by MESCIUS supports pre-defined cell types such as text, number, date, and formula, as well as custom cell types with user-defined formatting and validation rules.
  • Jspreadsheet Pro provides a range of built-in cell types including numeric, text, date, time, formula, and hyperlink, plus user-defined cell types with custom formatting and validation.
  • Syncfusion Spreadsheet includes various cell types such as general, number, currency, percentage, date, time, and formula, as well as custom cell types with tailored behavior.

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

Compare JavaScript Spreadsheet Controls

Highlight Trends in Grid Data with Sparklines

February 26, 2024
jQWidgets v19 lets you integrate sparklines into your grids, providing a quick and insightful way to visualize trends and patterns in your data.

jQWidgets is a comprehensive JavaScript UI framework offering a robust collection of over 60 widgets, themes, and utilities for building professional-grade, cross-platform web applications. Built on jQuery, HTML5, and CSS, it provides extensive functionality including data grids, charts, navigation, input validation, and more. jQWidgets simplifies web development, ensuring your applications work seamlessly across desktop browsers, tablets, and smartphones.

The jQWidgets v19 release introduces support for integrating sparklines directly into jqxGrid. These miniature charts, plotted directly within grid cells, provide a quick and insightful way to visualize trends and patterns in your data without requiring additional charting libraries. This enhancement significantly bolsters jqxGrid's data visualization capabilities, allowing you to create more informative and engaging data presentations.

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

jQWidgets is licensed per developer and is available as a Perpetual license 1 year support and maintenance. See our jQWidgets licensing page for full details.

Learn more on our jQWidgets product page.

Improve Document Accessibility in Your Node.js Apps

February 23, 2024
GroupDocs.Conversion for Node.js via Java V24.2 can now convert tagged DOCX files to tagged PDF, ensuring information integrity across formats.

GroupDocs.Conversion for Node.js via Java is a powerful document conversion API designed to seamlessly integrate with your JavaScript applications. It empowers you to effortlessly convert between over 50 document and image formats, including popular Microsoft Office and OpenDocument files, PDFs, and various image types. This Java-based solution eliminates the need for third-party tools, offering a convenient and efficient way to handle document conversions directly within your Node.js projects.

The GroupDocs.Conversion for Node.js via Java V24.2 release adds the ability to convert tagged DOCX files to tagged PDF. This feature ensures the accurate transfer of semantic structure, including headings, paragraphs, tables, and other essential elements, from DOCX to PDF. This empowers users with disabilities to leverage screen readers and other assistive technologies effectively, promotes content clarity and comprehension, and safeguards crucial information during format changes, making your documents accessible.

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

GroupDocs.Conversion for Node.js via Java is offered as Developer Small Business, Developer OEM, Site Small Business and Site OEM licenses catering to a range of business needs. Licenses are perpetual, and include 1 year of support and maintenance. Subscription renewals are also available. See our GroupDocs.Conversion for Node.js via Java licensing page for full details.

GroupDocs.Conversion for Node.js via Java is available in the following products:

Add Drill-Through Charts to Your Web Application

February 23, 2024
JavaScript drill-through charts empower users to easily navigate multiple layers of data and hone in on specific data points.

ActiveReportsJS is a reporting tool for web applications that allows developers and report authors to easily design and display reports within their applications. With a wide range of features, such as drill-down, runtime data filtering, and parameter-driven reports, as well as compatibility with popular frameworks, ActiveReportsJS simplifies the process of creating and managing reports.

In this blog post, MESCIUS Technical Engagement Engineer Joel Parks shows you how to utilize ActiveReportsJS to incoporate charts into your JavaScript report, and bind your chart data together through the use of parameterized drill-through navigation, allowing your users to easily traverse between them. Steps include:

  • Creating a report and binding a data source
  • Adding subreport parameters
  • Building line and stacked column charts
  • Setup drill-through navigation between reports
  • Loading the report into a JavaScript application

Read the complete blog now, and start adding drill-through chart functionality to your JavaScript report using ActiveReportsJS.

ActiveReportsJS is licensed on an annual subscription or perpetual basis and is available as a Single Deployment License for non-commercial use, and as a Single Domain License or Unlimited Domain License for commercial and/or SaaS use. See our ActiveReportsJS licensing page for full details.

For more information, visit our ActiveReportsJS product page.

Highlight Trends with React Spreadsheet Sparklines

February 22, 2024
Embed compact charts within spreadsheet cells to visually highlight essential insights and simplify data interpretation.

Sparklines are miniature charts embedded within the cells of a spreadsheet. Their compact size allows for dense visualizations, revealing trends and patterns in large datasets without sacrificing valuable screen space. Placed directly beside their corresponding data, they facilitate immediate comparisons and insights, enhancing understanding and communication. Their flexible nature allows for diverse chart types, from lines highlighting trends to columns showcasing comparisons, making them adaptable to various data presentations.

Here are some React spreadsheet controls that offer sparkline functionality:

  • SpreadJS by MESCIUS is a powerful JavaScript spreadsheet solution, with full support for React, offering dynamic sparkline charts for visualizing trends and data patterns efficiently.
  • Jspreadsheet Pro is an advanced data grid solution that offers sparkline charts to gain instant insights from trends, exceptions, and comparisons for concise data visualization.
  • Infragistics Spreadsheet React (part of Infragistics Ignite UI) allows you to render line, area, column, and winloss sparklines within cells, enhancing data analysis capabilities.

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

Compare React Spreadsheet Controls