Released: Apr 24, 2018

18.1 での更新項目

機能

• Excel Engine and Spreadsheet Features
  • Conditional Formatting - Spreadsheets now support the rendering of all the conditional formatting options available in Excel including Data Bars, Color Scales, and Icon Sets.
  • Worksheet Sorting and Filtering - You can now sort and filter your information outside of a table. You can define a single area, within the Worksheet, but outside of the table, and you can apply sorting and filtering.
  • List Validation - While Infragistics Ultimate UI for Window Forms already had list data validation in place, users had to know of the list's specifiers to type in the relevant data, since there wasn't a cell drop-down option. In this update a cell drop-down option has been added.
• Table Improvements
  • With Copy and Paste, you can now select an entire table, copy it to the Clipboard, and paste elsewhere to have a new copy of that selected table created. Also, when pasting in a Worksheet Table, the table will be automatically expanded to encompass the area of the paste function.
  • As for Editing, when you find yourself typing or editing immediately adjacent to the bottom or right edge of a Worksheet Table, the Table will be expanded.
  • Tab Navigation will navigate within the table, wrapping to either the next or previous row. Like Excel, the table will also be automatically expanded when tabbing from the last visible cell of the table.
  • When you have a total row or column highlight in Windows Forms, you can select the drop-down button to pick a common formula for the table.
  • For ContextMenu, some additional items were added, such as menu items for inserting and adding rows/ columns to a table, selecting rows/ columns of a table, toggling the total row, and converting a table to a range.
• Supported Functions - A number of additional popular functions are now supported, including SUM, CONCATENATE, and COUNTA, and a host of others through which you can easily scroll.
• Grid Events
  • Column AutoSizing with UltraGrid - The purpose of these events is to allow developers to modify or to override the AutoSize width of a column.
• Data Chart Controls
  • Scatter Series - Added four new types of scatter series to the UltraDataChart control.
    • Scatter Area Series: This data chart draws a colored surface based on a triangulation of X and Y data with a numeric value assigned to each point. This series is useful for rendering heat maps, magnetic field strength, or Wi-Fi strength in an office.
    • Scatter Contour Series: This chart draws colored contour lines based on a triangulation of X and Y data with a numeric value assigned to each point. This series is useful for rendering contour maps, changes in magnetic field strength or rendering an overlay on top of ScatterAreaSeries.
    • Scatter Polygon Series: This is a visual element that displays data using polygons. This type of series can render any shape. All you need to do is bind a List of List of Point objects or load a shapefile with polygons using the ShapefileConverter.
    • Scatter Polyline Series: This displays data using polylines. This scatter series is often used where rendering disconnected lines are required such as a network graph or multiple connections between scatter data points. This series has the same data requirements as ScatterPolygonSeries does, and it also can render data from shapefiles.