Essential Studio ASP.NET MVC adds Pivot Table support

Syncfusion Essential Studio ASP.NET MVC includes lightweight controls to help you easily create rich, compelling Web and mobile applications. The suite’s UI offerings include a grid, charting, diagramming, scheduling, gauges, menus, a Rich-Text editor, a rotator, numerous buttons and a toolbar. On the reporting side it includes components that enable your applications to read and write Microsoft Excel, Word and Project files, to create and view PDF files and to display reports.

Updates in 2016 Volume 1

• Alternate Chunks in Word to PDF conversion - An alternate chunk is an anchor in a Word document for external content imported from a specified file. DocIO converts Word documents with alternate chunks to PDF files.
• Chart
  • Axis Crossing - Chart axes can be positioned anywhere within a chart area.
  • Column Spacing - Column width and spacing between columns can be customized.
  • Server-Side Exporting - A chart can be exported on the server side to a Word document, PDF document, Excel file, or image including SVG, JPG, GIF, PNG, and BMP formats.
  • Indexed Category Axis - A category axis can plot data points based on their index.
  • Chart Scrollbar - Charts can be smoothly panned with a scrollbar after being zoomed.
  • Multicolor Line Series - A line series can be plotted with different colors for each data point.
  • Multiple Pie and Doughnut Series - Multiple pie and doughnut series can be plotted in a chart.
  • Multiple Range Selection - Data points in a chart region can be selected through mouse or touch interactions and multiple regions can be selected.
• Diagram
  • Multiple Parent Layout - The organization chart and hierarchical tree layout now support nodes connected to multiple parents.
  • Printing - The diagram control supports printing documents with multiple pages.
  • Layout Bounds and Alignment - A layout can be aligned anywhere on the viewport or within any specific rectangular area.
  • Background Image - The diagram control supports to stretching or aligning background images anywhere in the drawing area.
• File Explorer Access Control - The file explorer has methods to assign permissions or access rights to specific users or groups of users. This component controls the ability of those users to view or make changes to the content of the file system.
• Gantt
  • Taskbar Templates - Taskbars can be customized with templates.
  • Row Drag and Drop - Rows can be reordered by dragging and dropping them to new positions.
  • Cell Selection - Single or multiple cells can be selected.
  • Column Options in Column Menu - Columns can be renamed, deleted, and added dynamically through different editing options.
  • Work Breakdown Structure - Tasks can be numbered sequentially to easily identify their levels.
• Grid
  • Row Reordering, Dragging and Dropping - By using a drag-and-drop operation, row data can be moved between multiple grids or to a custom control such as a form element or shopping cart.
  • Filter Bar Templates - A filter bar template can be used to define a unique UI filter to achieve custom data filtering.
  • Batch Row Deleting - With batch deleting, multiple rows in a grid can be selected and deleted.
• PDF
  • Named Destinations - Named destinations can be added in PDF documents for interactive navigation. Destinations and properties can also be edited in existing PDF documents.
  • Flattening Annotations - Annotations such as circle, rectangle, polygon, and text markup can be flattened to disable the editing capability.
  • Built-in Table Styles - With just a few lines of code, table styles similar to Microsoft Word can be added to PDF grids and light tables.
  • GS1-128 Barcode - GS1-128 barcodes can be added in the PDF document, and the API supports exporting a barcode as an image.
  • PDF Viewer - View and print PDF files without any dependency on Adobe.
• Pivot Grid
  • Client Side OLAP Data Source Support - The pivot grid control supports communicating with an OLAP data source from the client through XML/A connections.
  • State Persistence for Relational Data Source - The expand and collapse states of row and column headers are maintained during every UI interaction for relational data sources in the pivot grid.
  • Excel Exporting (Client Mode) - Pivot grid content rendered from both OLAP and relational data sources on the client end can be exported to Excel.
  • Number Format Support for Relational Data Source (Client Mode) - By setting the format option, pivot grid control values bound from relational data sources can be formatted for numbers, decimals, currencies, percentages, dates and times.
  • Write-Back Support for OLAP (Server Mode) - Values in the pivot grid control can be edited and a write-enabled cube can be updated at the back-end (SSAS) dynamically at run time.
• Predictive Analytics - Experimental support for PMML files generated by SAS has been added for the following models: Association rules, Clustering models, Neural networks, Regressions and Tree models.
• Presentation Notes - Allows notes to be added to slides (often called speaker notes) in a PowerPoint presentation. You can also allow the content of existing notes to be edited or deleted.
• Range Navigator
  • Range Scrollbar - A scrollbar can be used to drill down and select a range with a high level of precision.
  • Range Selection and Highlighting - Any interval in the range navigator can be highlighted when the mouse moves. Intervals can be selected by clicking and dragging the highlighted interval.
• Rich Text Editor (RTE)
  • Custom Lists - Ordered List and Unordered List styles can be customized with user defined options.
  • Table Resize - Resize tables and their columns and rows individually.
  • Zoom and Print - The rich text editor control allows users to zoom and print its content.
  • Find and Replace - The find-and-replace feature helps to search for and substitute a given keyword with content from the editor.
  • Context Menu - Editor menu options can be customized in the rich text editor control.
  • Keyboard Interaction Improvements - Enhanced keyboard interaction support is provided for all toolbar commands like Lowercase, Uppercase, Strike, Superscript, Subscript, Insert Image and Insert Video.
  • jQuery Validation - Query form validation support is enabled for the rich text editor.
• Schedule
  • Cell Formatting - Schedule control cells and almost all other sub-elements can be formatted or customized with user-specific styles.
  • Custom Resource Allocation - Different work hours and workdays can be defined individually for each resource available within the schedule control
  • Recurrence Editor - All recurrence-related information is accessible through a separate plug-in called the Recurrence Editor, making recurrence information available for individual usage or to be embedded directly into a customized appointment window.
  • Live Preview when Dragging and Resizing - When appointments are resized and dragged, a preview will indicate the new times covered by the appointment.
  • Exclude Dates from Previous or Upcoming Months - Dates from previous or upcoming months can be displayed or hidden.
• Spreadsheet
  • Data Binding with Batch Save - The spreadsheet control can now be used as a data-bound widget, allowing a data source to be bound to the control’s sheet or a range of cells. Changes will be sent back to the remote server or to an in-memory object.
  • Cell Binding - Predefine or override each cell in the spreadsheet control with a simple JSON object, which supports setting values, formulas, comments, hyperlinks, cell formats and number formats.
  • Pivot Table - Pivot table support has been added to summarize and analyze large amounts of data.
• Tree Grid
  • Paging - Rows can be displayed in a paged view.
  • Cell Selection - Single or multiple cells can be selected.
  • Column Options in Column Menu - Columns can be renamed, deleted, and added dynamically through different editing options.

About Syncfusion

Founded by industry experts in 2001, Syncfusion provides a broad range of enterprise-class software components and tools for the Microsoft .NET platform. Their award-winning .NET components and controls are designed to meet evolving development needs, whether working in Windows Forms, WPF, ASP.NET, ASP.NET MVC or Silverlight. Syncfusion strive for excellence in order to offer the very best value to customers - from small ISVs to Fortune 100 companies.