JavaScript / HTML5 News

Highlight Data that Meets Specific Conditions

February 2, 2024
Conditional formatting visually highlights key spreadsheet data points, trends, and anomalies, accelerating analysis and decision-making.

Conditional formatting in spreadsheets automates the visual highlighting of cells or ranges based on predefined criteria. This functionality aids data analysis by rapidly drawing attention to specific values, ranges, or text entries. By employing color scales, gradients, or text changes, conditional formatting helps users identify patterns, exceptions, and trends within large datasets, streamlining the interpretation and communication of key insights.

Several JavaScript spreadsheet controls offer conditional formatting including:

  • Telerik Spreadsheet jQuery (part of Kendo UI) allows customizable cell formatting, including number, date/time, styles, and conditional formatting by setting a color and a condition to the format string.
  • SpreadJS by MESCIUS (formerly GrapeCity) supports conditional formatting in cells with several conditional rule types to choose from such as average, cell value, duplicate, formula, specific text and more.
  • Infragistics Spreadsheet Angular (part of Infragistics Ignite UI) allows you to conditionally format the background and font settings of cells in a worksheet based on predefined criteria such as average, blank, value, or date.
  • Syncfusion Spreadsheet JavaScript (part of Syncfusion Essential Studio Enterprise) lets you highlight a cell or a range of cells with a certain color based on applied conditions, and showcases data with data bars, color scales, and icon sets.

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

Compare JavaScript Spreadsheets

Build Finance and Trading Apps in JavaScript

February 1, 2024
LightningChart JS Trader is a new JavaScript charting library that offers high-performance, real-time data, and comprehensive technical analysis.

LightningChart JS Trader is a comprehensive charting solution specifically designed for building high-performance financial and trading applications in JavaScript. It equips developers with a rich set of financial charts, over 100 technical indicators for in-depth analysis, and 30+ drawing tools for visual annotations. Additionally, a fully featured datagrid with sparkline support allows for organized data management and display. This combination empowers developers to create interactive and visually engaging trading dashboards, charting tools, and other financial applications with high performance and extensive customization options.

LightningChart JS Trader features include:

  • Advanced Technical Charts: Supports various 2D and 3D chart types like line charts, OHLC bar charts, OHLC candle-stick charts, mountain charts, geo map charts, and more, all customizable for in-depth analysis.
  • Extensive Indicator Library: Over 100 built-in technical indicators like Moving Average Convergence-Divergence (MACD), Bollinger Bands, High Low Bands, and custom indicator creation capabilities.
  • Drawing Tools: 30+ tools for visual annotations, trendlines, Fibonacci retracements, and geometric shapes for clear chart interpretation.
  • Customization: Extensive customization options for charts, indicators, and the entire user interface to match your specific application needs.
  • Performance: Optimized for real-time data handling and smooth rendering, even with complex charts and large datasets.

LightningChart JS Trader is licensed per developer, per application, per year. The annual license includes technical support and product updates for one year. To continue using the software you will need to renew your license each year. There are three editions to choose from; Basic, Plus and Ultimate which offer different levels of functionality and distribution rights. See our LightningChart JS Trader Licensing page for full details.

For more information, visit our LightningChart JS Trader product page.

Edit Office Files Online Directly within Redmine

January 30, 2024
ONLYOFFICE Redmine connector v3.0.0 allows you to edit a wide range of additional formats including DOCM, DOTM, DOTX, XLSM, and XLTM.

ONLYOFFICE Docs Enterprise Edition with Redmine Connector combines an online document editor with a seamless integration for Redmine, the Ruby on Rails-based project management hub. This allows teams to create, view, edit, and collaborate on spreadsheets, presentations, and text files online, directly within Redmine, boosting efficiency and eliminating the need for file switching.

ONLYOFFICE Redmine connector v3.0.0 expands the list of file formats that are available for editing. Previous releases supported DOCX, XLSX, PPTX, DOCXF and OFORM, but the latest update allows you to use ONLYOFFICE Docs directly within Redmine, to edit DOCM, DOTM, DOTX, XLSM, and XLTM files. The following formats may also be opened for editing by checking them in the format settings, though please note that data loss may occur due to format restrictions: EPUB, FB2, HTML, ODT, OTT, RTF, TXT, CSV, OTS, ODS, and ODP.

To see a full list of what's new in v7.5.1 (3.0.0), see our release notes.

ONLYOFFICE Docs Enterprise Edition with Redmine 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 Redmine connector licensing page for full details.

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

Add Tablix to Your JavaScript Reporting Application

January 23, 2024
Combine the benefits of tables and matrices to organize and present complex data in a structured, easily understandable format.

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.

A Tablix is a versatile report item that acts as a unified platform for displaying data in table, matrix (cross-tab), and list formats. It offers a flexible layout grid with nested rows and columns, allowing you to structure data for easy analysis and visualization. This empowers you to present detailed information, group data by categories, and summarize key metrics, all within a single report element.

In this blog, MESCIUS Technical Engagement Engineer Joel Parks shows you how to use ActiveReportsJS to add a Tablix control to your JavaScript report. Steps include:

  • Adding a Data Source and Tablix control to your report
  • Binding a Data Source and assigning Rows, Columns, Values, and Totals
  • Formatting the Tablix Cells layout

Read the full blog and give your users the ability to create flexible reports with the ability to adapt to changing data conditions.

Export and Share Grid Data with Ease

January 22, 2024
Foster seamless data exchange by leveraging the widely-supported CSV format for your Angular grid exports.

CSV export functionality in a grid control empowers users to seamlessly bridge the gap between interactive visualization and in-depth analysis. By exporting the displayed data as a readily importable CSV file, users gain immediate access to a familiar format compatible with diverse spreadsheet tools. This feature promotes efficient data extraction, facilitating further analysis, report generation, and data sharing, all directly from the convenience of the grid interface.

Several Angular grid controls support exporting to CSV, such as:

  • Wijmo FlexGrid (part of Wijmo by MESCIUS) allows you to transform your Angular data tables into clean, ready-to-analyze CSV files with seamless export options.
  • Handsontable by Handsoncode empowers rapid data analysis with seamless, flexible CSV export from your Angular grids.
  • Ignite UI Angular Grid (part of Infragistics Ignite UI) lets you effortlessly export your grids to clean, analysis-ready CSV files in a single click.
  • Syncfusion Grid control for JavaScript (part of Syncfusion Essential Studio Enterprise) allows you to capture Angular grid data effortlessly in CSV format for straightforward sharing.

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

Compare Angular Grid Controls