Angular 新闻

突出显示符合特定条件的数据

2月 2, 2024
条件格式直观地突出显示了关键的电子表格数据点、趋势和异常情况，从而加快了分析和决策速度。

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

在 JavaScript 中构建金融和交易应用程序

2月 1, 2024
LightningChart JS Trader 是一个新 JavaScript 图表库，提供高性能、实时数据和全面技术分析。

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.

直接在 Redmine 中在线编辑 Office 文件

1月 30, 2024
ONLYOFFICE Redmine 连接器 v3.0.0 允许您编辑各种其它格式，包括 DOCM、DOTM、DOTX、XLSM 和 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.

将 Tablix 添加到您的 JavaScript 报表应用程序

1月 23, 2024
结合表格和矩阵的优势，以结构化、易于理解的格式组织和呈现复杂数据。

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.

轻松导出和共享网格数据

1月 22, 2024
通过利用广泛支持的 CSV 格式进行您 Angular 网格的导出来促进无缝数据交换。

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