Essential Studio for ASP.NET Core Release Notes

v15.4.0.17
November 10,2107

Revised September 14, 2017 - ASP.NET Core 2.0 support has been included.

Common

Features

  • Essential Studio for JavaScript components are now compatible with the latest version of jQuery 3.2.1

    Autocomplete

Features

  • Provided search indices support for multicolumn pop-up, display format and search fields in the multicolumn autocomplete control can now be differentiated.

Chart

Features

  • #163192, #168324, #177512 - Provided support for splitting the axis labels text and rendering it in multiple lines.
  • Provided automatic label format support, based on the interval type for dateTime and dateTime category axis.
  • Provided support for placing the data labels inside the chart area, if it exceeds.

    ComboBox preview

The ComboBox component allows the user to type a value or choose an option from the list of predefined options. When an arrow icon accompanied with this component is pressed, the dropdown displays a list of values, from which the user can select one.

Features

  • Data binding - Allows binding and accessing the list of items from local or server-side data source.
  • Grouping - Supports grouping of logically related items under a single or specific category.
  • Sorting - Supports sorting of list items in an alphabetical order (either ascending or descending).
  • Filtering - Allows filtering of list items based on a character typed in the component.
  • Templates - Allows customizing the list items, selected value, header, footer,category group header, and no records content.
  • Accessibility - Provided with built-in accessibility support that helps to access all the ComboBox component features through the keyboard, screen readers, or other assistive technology devices.

    DataManager

Features

  • #182124, #185678, #182077 - Feature that provides IN and NotIN filter operations for specifying multiple values in a WHERE filter.

  • #173861, #172869, #128852 - The anti-forgery token can be used to help protect the application against cross-site request forgery. It Generates a hidden form field (anti-forgery token) that is validated when the form is submitted

DateRangePicker

Features

  • New component DateRangePicker has been added in EJ ASP.NET Core that allows to pick date range value from a popup with two calendar interface or set of predefined date ranges in an application. It includes all the functionality of ejDateRangePicker since it is the server-side wrapper of ejDateRangePicker.

    Diagram

Features

  • #186185 - Support to define the maximum/minimum zoom level in the diagram control is added.
  • #130997 – Support to define the margin and alignment support for UserHandles  is added.
  • #150330, #176675 – Support to drag the port is added.
  • #143026, #146924, #160528 ,#161496, #127341 - Support to define the bi-directional connection in the hierarchical layout is added. 
  • #160398 - Support to drag the shape with label from symbol palette is added. 
  • #161866, #170911, #181495, #132746 - Support to reduce the size of an saved JSON data from diagram control is added.
  • #155435 - Support to disable the bridging for the connectors, when the bridging disabled connector overlaps the bridging enabled connectors is added.
  • #138994 - Interaction support for labels is added.

    DocIO

Features

  • #179888, #182242 - Added support to continue or restart list number while importing Word document.

Breaking Changes

  • WordDocument.Background.Type property will not return the value NoBackground, if show background in print layout view option is disabled and valid background is defined. In this case make use of new property WordDocument.Settings.DisplayBackgrounds to check whether show background in print layout view option is enabled or disabled.
  • #186150 - IsMaxCross property is set to true and secondary axis is added to the right side of the chart, while adding new secondary chart axis. You can set the IsMaxCross property to false, to add secondary axis on the left side.
  • The types Diagonl_Up, Diagonl_Down, From_Corner and From_Center of OfficeGradientStyle enumeration are now deprecated. The new types DiagonalUp, DiagonalDown, FromCorner and FromCenter are added to replace these deprecated types.
  • The property NumberSufix of WListLevel class is now deprecated. The new property NumberSuffix is added to replace this deprecated property.

Bug Fixes

  • #184513 - Formula fields are updated properly while calling UpdateDocumentFields() method.
  • #183656 - NullReferenceException will no longer thrown while closing a particular Word document.
  • #183819 - NullReferenceException will no longer thrown while setting WMergeField.FieldName property.
  • #184348 - NullReferenceException will no longer thrown while parsing a Word document which contains shapes.
  • #186310 - Paragraph is preserved properly while resaving a particular RTF document as DOC format document.
  • #187463 - KeyNotFoundException will no longer thrown while importing a particular Word document.
  • #184941 - Bulleted list is preserved properly while merging multiple documents.
  • #186150 - Document protection is preserved properly while resaving DOCX document to DOCX.
  • #184955 - The Word document is no longer corrupted while setting the DateTime value as chart data.
  • #188782 - ActualFormatType property will retrieve a proper value for all Word formats document.
  • #188160 - Shape is preserved properly while resaving a particular Word document.
  • #189107 - No longer hangs while parsing a particular Word document.
  • #188296, #188686 - Field results are updated properly while performing Mail merge in a particular Word document.
  • #189378 - ArgumentOutOfRangeException will no longer thrown while deleting a bookmark content from a particular Word document.
  • #183627 - Document background color is preserved properly while resaving a particular Word document.
  • #182050 - Page orientation is preserved properly while resaving a particular Word document.
  • #188048 - Tab preservation issue has been resolved while converting a particular Word document as HTML.
  • #187669 - IndexOutOfRangeException will no longer thrown while converting a particular Word document as HTML.
  • #176634, #179293, #184808, #189056 - Table grid’s column width is preserved properly while converting a particular HTML file to Word document.
  • #190219 - NotSupportedException will no longer thrown while opening a Word document which has an invalid OLE data path.
  • #189859 - Image will be preserved properly while converting a particular Word document as HTML.

Features

Kanban

Features

  • #161500, #166915, #174770, #F128835 - The Kanban control now supports drag-and-drop operations between the Kanban board and other controls.
  • #179568, #F131180 - Kanban empty columns can be rendered without binding a data source.

    FileExplorer preview

Features

  • #176007, #181140,#131117, #184911, #186743, #132492, #191252, #191201 – FileExplorer is an interface for managing the file system through any web application, we have provided the tag helper support for the file explorer component in the ASP.NET Core platform.

Key features

  • Windows explorer like functionalities and appearances
  • Handy file operations (copy, paste, move and delete)
  • File download and upload
  • File type restriction
  • Easy UI customization
  • Different layouts (grid, tile and large icons view)
  • Context menu support
  • Built-in image viewer support
  • Keyboard navigation
  • Right to Left alignment (RTL) support
  • Localization support

    Gantt

Features

  • #130742, #135990, #137692, #139699, #138782, #154668, #155383, #163693, #169303, #170767, #173652, #180270, #188056 - The Gantt control now provides support for resource allocation view. Using this view user can able to interpret the tasks occurring on same dates, overallocation of resources in a project.
  • #180223, #184466, #190826 - Now it is possible to display tasks with serial/sequence number based on the row order.
  • #130217, #137691, #190718- Now it is possible to select multiple rows and perform indent and outdent actions.
  • #183277 - Now it is possible to the filter the fields or columns in Gantt using public method.
  • The Gantt control now provides support for expanding and collapsing records at specific levels using public methods.
  • #185510 – Now the record dragged and dropped in the empty space below all the records will be added as the last record to the project.
  • #182758 – The Gantt control now provides support for changing week start day in month timescale mode.
  • #183565 – Now it is possible to format the font and other styles in PDF export.
  • #F131433 - New method has been implemented to change the Id field of the tasks. Now user can able to alter the task Id field with the key returned from SQL database when adding a new record, using this method.
  • #F132012, #185158 – Now the milestones in a project are positioned accordingly to the provided date and time values.
  • #185087 - Now the validation support has been provided for the predecessor values to ignore the incorrect entries.

Bug Fixes

  • #187014 - Issue with dependency line editing with predecessor validation in disabled state has been fixed.
  • #F132600 - Issue with date time calculation in task’s end date with day duration unit has been fixed.
  • #188190 - Issue with invalid predecessor value at initial load has been fixed.
  • #185563 – Issue with baseline date value format in cell edit and dialog edit actions has been fixed.
  • #184781 - Issue with displaying predecessor tab in add/edit dialog in KnockoutJS has been fixed.
  • #184466 - Issue with resource collection update in edit dialog has been fixed.
  • #189625 – Now it is possible to provide resource ID in string data type to the Gantt tasks.
  • #187014 – The predecessor validation issues at initial load has been fixed.

Pager

Features

  • New component Pager has been added in EJ ASP.NET Core that allows to navigate between pages which provides easy user interaction in an application.It includes all the functionality of ejPager since it is the wrapper of ejPager.

    PDF

Bug Fixes

  • #186604 - PDF document pages are no longer rotated, while merging a particular PDF document.
  • #186765 - Unexpected token error is no longer occurs, while loading particular document.
  • #185183 - The custom metadata added to PDF document is now displayed in custom window of PDF document properties.
  • #182001 - Form fields are not duplicated when load and save the PDF document.
  • #182438 - Named destinations are preserving properly while merging the particular PDF documents.
  • #183859 - The size of the Code128Barcode is now preserved properly.
  • #185884 - Empty page is not created, when merging particular PDF document.
  • #185722 - PDF document with Adobe flash is now merging properly.
  • #185460 - Attachment collection is not empty, when loading a particular PDF document.
  • #185098 - Exception no longer occurs when merging particular PDF document.
  • #184712 - The document keywords are not duplicated when using commas along with keyword.
  • #184488 - Null reference exception no longer occurs when signing existing PDF document.
  • #183595 - ArgumentOutOfRange exception is no longer occurs when importing pages from a particular PDF document.
  • #182417 - Annotation are now removing properly from PdfLoadedPage.
  • #188040 - Preservation issues will no longer occurs while drawing JPEG images.
  • #187013 - PDF layers count is now retrieving properly while loading the existing PDF document.
  • #175611 – Annotation appearance will be preserved properly in Foxit and Bluebeam PDF viewers.
  • #187909 - Exception no longer occur while loading particular PDF document.
  • #189070 - Null reference exception is no longer thrown while accessing cell padding property from PdfGridCellStyle.
  • #188406 - PDF document is no longer corrupted while drawing specific JPEG image into PDF.
  • Child grid cell padding preservation issue is no longer occur in PdfGrid.
  • Annotation transparency is preserving properly when set opacity value as zero.
  • PdfFormFields are now preserving properly while creating in PDF document.
  • Bookmarks are now created properly for particular document.
  • Metadata property is now updating properly when changing document information in PDF document.
  • TextMarkupColor is now preserving properly in PdfFreeTextAnnotation when loading the particular PDF document.
  • The text in the PdfGrid is now aligning properly within the provided space.
  • Signature fields are not duplicating when loading and saving the signed PDF.
  • Form fields are not empty when loading and saving the PDF document.
  • PdfPopupAnnotation is preserving properly after flattening.

Features

  • #151225,183708,124147,130391,131581 – Added support for creating secure PDF documents.
  • #153512,168944,179551,181064,181209,130391,131568 – Added support for drawing PNG images in PDF document.
  • #185022 - Added the support to change the tab order of the form fields.

PivotClient Preview

The pivot client control allows the visualization of both OLAP and relational data in pivot grids and pivot charts embedded within it. It also provides a UI option to drag fields, filter them, re-arrange them, and create pivot views at run time.

Features

  • Bind the control with relational data sources along with Microsoft Analysis Services databases and XML/A data sources.
  • Build OLAP/pivot reports by placing elements in different axes of the pivot client. Reports can be prepared on the fly.
  • Use the toolbar’s various options for exporting and manipulating the OLAP/pivot report such as add report, new report, remove report, etc.
  • Save reports for later use.
  • Apply localization.

Predictive Analytics

Bug Fixes

  • #187834- Resolved issues with “InlineTable” property in “MapValues” transformation.
  • #187928- Resolved issues with scoring procedure of expressions in PMML transformations.
  • #190249- Resolved issues with Multinomial Logistic Regression model scoring procedure.

    Presentation

Breaking Changes

  • IsMaxCross property is set to true and secondary axis is added to the right side of the chart, while adding new secondary chart axis. You can set the IsMaxCross property to false, to add secondary axis on the left side.
  • The types Diagonl_Up, Diagonl_Down, From_Corner and From_Center of OfficeGradientStyle enumeration are now deprecated. The new types DiagonalUp, DiagonalDown, FromCorner and FromCenter are added to replace these deprecated types.

Bug Fixes

  • #187206 - Data labels in the bubble chart is now added as expected while creating a chart in PowerPoint presentation.
  • #186544- Null reference exception is no longer thrown while creating a PowerPoint slide with SmartArt diagram.
  • #184264 - The PowerPoint presentation is no longer corrupted while setting the DateTime value as chart data.
  • #186100 - Guides are now preserved properly while creating a PowerPoint slide from an existing layout slide.
  • #186105 - Shape properties are now preserved properly while creating a PowerPoint slide from an existing layout slide.
  • #184967 - Argument out of range exception will not be thrown while cloning a PowerPoint slide with pie chart.
  • #182963 - FontSize property of Font class will now return the correct value.
  • #185237 - The shape name will be preserved like Microsoft PowerPoint, while creating new slide from an existing layout slide.
  • #185236 - The shapes in the footer will be preserved properly while creating new slide from an existing layout slide.
  • #188996 - Null reference exception will be no longer thrown while changing the slide background from SolidFill to PictureFill.
  • #188405 - Object disposed exception will be no longer thrown while saving the cloned PowerPoint presentations.
  • #188525 - Percentage symbols in the chart primary axis are now preserved properly while creating chart in PowerPoint slides.
  • #188081 - Now charts can be created using data from any worksheet of excel file in PowerPoint slides.
  • #188977 - Font color is now preserved properly in PowerPoint slides while retrieving it from the master slide.
  • #187656 - The font name and size are now preserved properly in PowerPoint slides while retrieving those from the master slide.

    SampleCreator

Features

  • #187830 - Added URL Adapter sample in ASP.NET Core Sample Creator.
  • Added Combo Box, File Explorer, Pivot Client samples in ASP.NET Core Sample Creator.

Schedule

Features

  • #148230, #163522 - Custom view has been enhanced to display different set of continuous date ranges or specific date collection.
  • #138564, #141079 - Support has been provided to export appointments to Excel format.
  • #185084 - Support provided to retain the scroll position, even after refreshing the entire layout.
  • #185976 - Support provided to auto-scroll the view when dragging an appointment to the edges.
  • #184777, #162291 - Printing option has been enhanced to print the appointments with its background color.

Bug fixes

  • #184594 - Edited recurrence appointments are saving correctly now, while using custom appointment window.
  • #183907 - The control layout is exporting properly to the PDF format now with the correct text display, while using the culture (bg-BG).
  • #186965 - Appointments in month view with multiple resources scenario, are exporting correctly to PDF format.

Slider

Features

  • Provided button support to increment and decrement the slider values.

SpellCheck preview

The SpellCheck control is used to find and highlight the misspell words. It shows possible suggestions through dialog mode and context menu mode to correct the misspell words.

Features

  • Highlights the error word based on the user customized style.
  • Ignores the alpha numeric, mixed case, upper case words and URL links.
  • Ignores the specific collection of words from the error word consideration using custom dictionary.
  • Displays the possible suggestions based on the user specified count.
  • Renders with optimal user interfaces for phone, tablet or desktop.
  • Allows to check the spelling on one or more HTML elements such as div, span, textarea and input elements.

    Spreadsheet

Features

  • #165067,#168989,#172008,#180430,#184577 - Provided support for cell styles customization.

  • #183747,#186738 - Provided support for performance improvement for formulas calculation on importing.

  • #F128298 - Provided support for Building common JSON for both getExportProps and saveAsJSON method.

Bug Fixes

  • #189113 - Provided support for select cells from another sheet while executing the formula.

  • #186209, #180749 - Provided support for add custom colors for Conditional formatting.

    TextBoxes

Features

  • #182613 - We have provided the option to allow the decimal places without any limit.

TreeGrid

Features

  • #135716, #139356, #141370, #158816, #158983, #174614, #182323 - The TreeGrid control now provides support for stacked column headers.
  • #181052, #188618 - The TreeGrid control now provides support for context menu for column headers.
  • #176047, #181564, #182301, #186835 - The TreeGrid control now provides support for excel type filtering menu for filtering column values.
  • #175845, #181564 - Now it is possible to filter the TreeGrid contents using toolbar filtering.
  • #186199 – Performance has been improved for expanding and collapsing all the records in TreeGrid with paging enabled.
  • #183545 – Support for double click event on TreeGrid rows has been implemented.
  • #183565 – Now it is possible to format the font and other styles in PDF export.

Bug Fixes

  • #188814 – Issue with rendering tooltip for extra-long cell values in TreeGrid has been fixed.
  • #188711 – Now the console error will no longer occur when rendering TreeGrid with empty datasource along with text wrapping support enabled.
  • #178281,186670 - Issue with browser right click action on TreeGrid header has been fixed.
  • #186325 - Now the pageSettings.totalRecordCount property will return proper value with server data source
  • #187692 - Issue with removing the column template script element from DOM, once destroying the control has been fixed.
  • #187224 - Issue with multiple TreeGrid exporting in excel has been fixed.
  • #183625 - Now the drop positions insertAbove, insertBelow and insertAsChild while dragging a row will be available in the rowDrag event arguments.

TreeView

Features

  • #184008 – Provided nested object support in TreeView fields. That helps to map the complex data from data source.

Breaking Changes

  • #182105 - In previous, when we pass a single node with a parentID and target to addNode method, the node will append to the parentID’s node and currently node will append in to the target.

    VS-Extensions

Features

  • #185136 - Alert message if packages unavailable in cache location while migrate ASP.NET Core Project.

XlsIO

Features

  • #177314, #180850, #F130852, #180995 - Security features are now supported in portable platform.
  • #156296, #F125729, #185873, #F57065 - Different odd and even page headers/footers, different first page headers/footers for worksheet and chart sheets are now supported in XlsIO.

Breaking Changes

  • #185530, #185561 - Exposed an API Name to get OLE object name in IOleObject class.
  • The properties EvenPage and FirstPage of type IPage are added in IPageSetup class.
  • The properties LeftHeader, CenterHeader, RightHeader , LeftHeaderImage, CenterHeaderImage, RightHeaderImage are added in IPage class to set text and images in the Even and First page headers/footers.

Bug fixes

  • #182915 - Issue with borders being cleared while merging cells is fixed.
  • #183016 - Issue with cell text casing while setting number format is fixed.
  • #183332 - Issue with conditional format is not preserved which has formula as another worksheet range, is fixed.
  • #183361 - Marker color gets changed on resave is fixed.
  • #183369 - Exception is no longer thrown on assigning the scatter chart category axis properties.
  • #183445 - Exception is no longer thrown while inserting rows in XLS format file.
  • #183738 - Performance issue while opening Excel file with multiple charts is fixed.
  • #183799 - Issue while setting print title rows for binary files is fixed.
  • #183807 - CopyTo() method is not working properly after applying AutoFilters is fixed.
  • #184328 - Exception is no longer thrown while applying data validation through ListOfValues property.
  • #184407 - Index out of range exception is thrown while setting RTF text is resolved.
  • #184407 - Key not found exception is thrown while setting RTF text is resolved.
  • #184540 - Binary Excel file gets corrupted while copying range with conditional formats is fixed.
  • #184569 - Cell value with comma character is changed while saving in CSV format is fixed.
  • #184894 - Exception is no longer thrown while adding IconSet multiple times.
  • #185139 - Argument exception is no longer thrown while copying worksheet with EMF images.
  • #185527 - Application hanging issue while opening the Excel file with table is resolved.
  • #184160 - Issue with incorrect margin values on resave is fixed.
  • #188856 - Issue with incorrect formula values when formulas contain unknown prefix is fixed.
  • #189191 - InvalidOperationException is thrown while saving Excel document with comments is fixed.
  • #189077 - Issue with InvertIfNegative in chart series data points is fixed.
  • #188263 - Issue with AutoFilterRange when AutoFilter collection is empty, is fixed.
  • #188856 - ReferToRange property now returns proper value for discontinued range.
  • #188787 - File is no longer corrupted while resaving Excel document with XML maps.
  • #188854, #190448 - Application hanging issue while opening Excel document with table AutoFilters is fixed.
  • #188687 - Exception is no longer thrown while adding worksheets after deleting named ranges.
  • #188620, #189263, #190029, #190818, #190866 - Formulas with external workbook reference gives incorrect formula string value is fixed.
  • #155547 - XlsIO memory consumption in row storage class has been reduced.
  • #183807, #187025 - CopyTo() method is working properly when AutoFilters are applied.
  • #187751 - External exception is no longer thrown while performing text AutoFit in a cell.
  • #186234 - Custom RGB tab color is no longer changed while resaving the Excel file in XlsIO.
  • #187234 - Issue with improper row height is resolved for the given Excel document.
  • #184407 - Exception is no longer thrown while setting RTF text.
  • #185577, #186951 - Rich-text is now properly set for complex RTF string.
  • #186451 - Date filter is now working proper in pivot table.
  • #186446 - UnKnownName exception is no longer thrown while opening CSV files.
  • #185221 - Exception is no longer thrown while opening Excel file with external workbook range in data validation formula.
  • #187026 - Exception is no longer thrown while resaving XLS file with table.
  • #187723 - Overflow exception is no longer thrown while accessing DisplayText for large numbers.
  • #185270 - Key not found exception is no longer thrown while copying range to another workbook multiple times.
  • #187025 - Text filter is now proper in XLSX document.
  • #187181, #187315 - Exception is no longer thrown while invoking IRange.BorderNone.
  • #185921 - File encoding is now correct while parsing zip file with Latin characters.
  • #186738, #187783 - DisplayText returns number value for cell reference formula in Portugal culture.
  • Sorting (descending order) is not working properly when filtering a column is fixed.
  • Issue with copy and paste of formatted cells is fixed.
  • Issue with IsBestFit property while accessing the SetColumnWithPixels method is fixed.
  • Stack overflow exception is no longer thrown while accessing RefersToRange property.
  • Argument exception is no longer thrown while copying one range to another range with styles.
  • Argument exception is no longer thrown when sorting filtered numbers in descending order.
  • The old and new cell values are validated on copy/paste through ValueChanged event.
  • AutoFit is now proper when text in the input file contains line feed and wrap text is set to false.
  • Performance issue in filtering when sheet has comments is fixed.
  • Exception is no longer thrown when coping the defined names between different workbooks.
  • Exception is no longer throw when cloning shape during AddCopy() method.
  • Exception is no longer thrown while accessing table range using formula token.
  • Calculated column formula is not updated during AddCopy() is fixed.
  • Null reference exception is no longer thrown while serializing conditional formats during AddCopy().
  • Issue with ColorRGB in Borders is fixed.
  • Exception is no longer thrown while parsing category labels with external range.
  • Exception is no longer thrown while updating sheet names in Worksheet.AddCopy().
  • Exception is no longer thrown while opening file with PieChart.
  • Exception is no longer thrown while copying conditional formats to another workbook.
  • The old and new cell values are validated on copy and paste operation through ValueChanged event.
  • Format exception due to pivot table data type is fixed.
  • XlsIO returns correct date for the number formats in German culture.
  • Exception is no longer thrown while opening an Excel document with stacked marker chart.
  • CellStyle.Font.RGBColor of a range now returns proper value.
  • DisplayText issue for number formats with ‘GMT’ is fixed.
  • Clearing contents in a merged cell doesn’t remove cell formatting.
  • Issue with incorrect display text for FormulaArrays is fixed.
  • ArgumentOutOfRangeException is no longer thrown while resaving Excel documents with duplicate cell style name.
  • Issue with hidden rows not being copied while using CopyTo() is fixed.
  • Formulas with improper sheet references are now proper on resave.
  • Image rotation will be preserved properly in Excel documents.
  • Issue with incorrect DisplayText value when a cell contains particular IF formula is fixed.
  • Exception is no longer thrown while opening a file with chart sheet.
  • Issue with calculated column formula on resave is fixed.
  • Exception is no longer thrown while cloning a workbook containing table formula using AddCopy().