Essential Studio for Universal Windows Platform Release Notes
Calculate
Features
- #119434, #133890, #153524 - Provided support for array formula calculation like Excel.
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 valueNoBackground
, if show background in print layout view option is disabled and valid background is defined. In this case make use of new propertyWordDocument.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 theIsMaxCross
property to false, to add secondary axis on the left side. - The types
Diagonl_Up
,Diagonl_Down
,From_Corner
andFrom_Center
ofOfficeGradientStyle
enumeration are now deprecated. The new typesDiagonalUp
,DiagonalDown
,FromCorner
andFromCenter
are added to replace these deprecated types. - The property
NumberSufix
ofWListLevel
class is now deprecated. The new propertyNumberSuffix
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.
NuGet
Features
- Added NuGet support for SfSmithChart and SfImageEditor controls.
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.
- #185705, 183560 - Text is now preserving properly, when converting particular XPS document to PDF.
- #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. - #183375 - Exception will not be thrown when converting a particular XPS Document to PDF.
- #182417 - Annotation are now removing properly from
PdfLoadedPage
. - #188040 - Preservation issues will no longer occurs while drawing JPEG images.
- #188375 - Exception will no longer occurs while loading the particular XFA document.
- #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 inPdfFreeTextAnnotation
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
- #185022 - Added the support to change the tab order of the form fields.
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
Features
- #182254 - Added support to render picture bullets while converting the PowerPoint slide to image.
- #182254 - Added support to render the image with color transformations (Black and white - 25%, 50% and 75%) while converting the PowerPoint slide to image.
- #178015 - Added support to render the image with gray scale while converting the PowerPoint slide to image.
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 theIsMaxCross
property to false, to add secondary axis on the left side. - The types
Diagonl_Up
,Diagonl_Down
,From_Corner
andFrom_Center
ofOfficeGradientStyle
enumeration are now deprecated. The new typesDiagonalUp
,DiagonalDown
,FromCorner
andFromCenter
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.
- #185046 - System argument exception is no longer thrown while converting slide to image.
- #184967 - Argument out of range exception will not be thrown while cloning a PowerPoint slide with pie chart.
- #182963 -
FontSize
property ofFont
class will now return the correct value. - #185046 -
ArgumentException
will not be thrown while converting the PowerPoint slide to image. - #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
toPictureFill
. - #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.
SfCellGrid
Bug Fixes
- #180504 - Null Reference exception no longer thrown when compare the border brush with null value.
SfChart
Bug Fixes
-
#184969 – SideBySide(ColumnSeries, BarSeries, StackingColumnSeries, etc.,) series will be rendered properly while having one data with non-SBS series.
-
#186061 –
EnableClipping
property will work properly forTextAnnotation
. -
#186076 –
GridLines
will be rendered properly, while changing its visibility dynamically. -
#185138 – SideBySide series will be rendered properly when binding
LineSeries
X-Axis to SBS Series X-Axis. -
#132272 –
Adornment
labels will be updated properly when changingitemsSource
dynamically forRangeSeries
. -
#149882, #156728 –
SfChart
,Zooming
andpanning
performance was improved in UWP mobile. -
#188800 -
ChartToolTip
will be updated properly while hovering on last data point inLineSeries
. -
#189818 - NullReferenceException will no longer be thrown, when clearing
Sparkline
data source. -
#189351 -
Trendlines
will be rendered properly for non-indexed data. -
#189680 - TypeInitializationException will no longer be thrown, when initializing
ChartSeries
without adding in chart.
Features
-
Provided support to showing or hiding
AccumulationSeries
segments, when the corresponding legend items are clicked. -
Provided axis StartAngle support for
CircularSeries
(Polar and Radar). - Provided
Animation
support for the following series: - Improved default
adornment
label performance while providing large data points.
SfCircularGauge
Breaking Changes
-
Labels, ticks, range, and range pointer were dependent of on Scale. i.e. if the scale’s
RadiusFactor
is reduced, other elements will be moved with relative to theScale
. Now, this issue has been fixed. -
LengthFactor
value as 1 forNeedlePointer
was not working dynamically and default value was rendering. Now, this issue has been fixed. -
Default space in
prefix
andpostfix
labels has been removed.
SfComboBox
Bug Fixes
- #189790 - Now
SelectedItem
updated properly while select an item using mouse.
SfDataGrid
Features
- #187048 - Provided support to load different
ItemsSource
for each row inGridComboBoxColumn
throughItemsSourceSelector
property - #185826 - Provided support for read-only mode in editing through
IsReadOnly
property where user can enter edit mode and can’t input text. - #175085 - Provided support for
AutoGenerateColumnsMode.SmartReset
inDetailsViewDataGrid
to retain valid columns and it’s the data operations settings when changingItemsSource
. - #131467 - Provided built-in support to drag and drop the rows.
Bug fixes
- #189231 -
Deadlock Exception
will no longer thrown while adding new row usingAddNewRow
with multiple view.
SfDiagram
Bug Fixes
- #189578 – Symbol/Shape will be completely visible in Stencil.
Features
- Provided
HitPadding
support to customize the hit area of the Node and Group. - Provided
Delete
constraint for Node, Group and Connector to decide whether it is removable. - Provided
Dynamic
constraint for Port to establish connection at a relative point on Node’s boundary. - Provided support to create parallel connection using
DockPort
. - Provided option to find the overlapping objects using
GetOverlappingObjects
method. - Provided option to find nearest obstacle-free location using
GetCollisionFreeLocation
method. - Provided option to add a port while establishing connection with node or connector at runtime.
- Provided support to customize the appearance and alignment of the
QuickCommands
. - Provided option to reduce the number of pages by customizing origin of the Page.
- Provided interaction events for
Port
andAnnotation
. - Provided support to print the diagram along with
PageBackground
Breaking Changes
- We have added
Commands
property inISelector
. - We have added
Info
property inIPageSettings
. - We have added
HitPadding
property inINode
. - We have modified the ControlTemplate of the
Selector
to provideQuickCommands
support. - We have added
PreviewSettings
property inIGraph
. - We have deprecated
DragOverNode
,DragOverConnector
,DragOverNodePort
andDragOverConnectorPort
properties fromRunTimeConnectionIndicator
class.
SfDockingManager
Feature
- #F130588 - Provided support to customize the Tabbed Window Background and Foreground in
SfDockingManager
.
SfGantt
Features
- #182180 - IsHeader property has been added in
TaskDetail
to determine whether this task is a parent task.
SfKanban
Bug Fixes
-
#189404 -
CardTapped
event will no longer be raised while scrolling the content of theKanbanColumn
. -
#185264 – Catastrophic failure will no longer occur, when an element is dragged over the
Kanban
control.
SfMaps
Bug Fixes
- # 186631 – Maps will not crop at the bottom and render properly even while adding Map headers.
SfMenu
Bug fixes
- #190684 -
SfMenu
will no longer crash while navigate to sub items by keyboard navigation keys.
SfPdfViewerControl
Bug Fixes
- #185367 - Setting AllowHyperlinkNavigation property to false will work as expected.
- #184234 - Application will no longer crash when the window is resized.
- #184604 - Application will no longer crash when PDF documents are loaded and unloaded repeatedly.
- #186627 - Text elements will now be selected properly using SfPdfViewer.
- #184604 - NullReferenceException will no longer be thrown while navigating between the XAML pages.
- #185288 - PDF document will be displayed in SfPdfViewer, even if ViewMode is set to FitWidth and IsThumbnailView is set to False.
- #184078 – Annotations will never be duplicated when changing the parent of PDF viewer.
- #187106 – No more memory leak occurs in PDF viewer after unloading the PDF document
- #187335 – Argument exception will no longer been thrown while clicking the links in the attached PDF document.
SfPivotChart
Bug fixes
- #189243 - SfPivotShared package can be created or generated in release mode.
SfPivotClient Preview
The SfPivotClient control supports browsing multidimensional data that is organized in the form of dimensions, measures, named sets, and KPIs in a cube format. You can visualize the results in graphical (PivotChart) and tabular (PivotGrid) formats. The control can also be used to create and edit reports on the fly that are stored for later use.
Bug fixes
- #189243 - SfPivotShared package can be created or generated in release mode.
Features
- Layout for mobile view has been provided.
- Implemented label and value filtering along with sorting like in Microsoft Excel.
SfPivotGrid
Bug fixes
- #189243 - SfPivotShared package can be created or generated in release mode.
Features
- #164163 - Implemented label and value filtering along with sorting like in Microsoft Excel.
- Top summary layout is now supported in PivotGrid.
- Provision to disable grouping bar header areas has been done.
- Provided support to maintain expanded and collapsed fields (State Persistence) in PivotGrid.
- Provision to change the properties of calculation item dynamically has been done.
- Provided an option to show the calculation fields in row headers.
SfReportViewer
Features
- #187493 - Provided option to export report as CSV document in Report Viewer.
Bug Fixes
-
#184964 - Now, paper orientation applied properly for report.
-
#189709 - Resolved zooming issue while printing the report in UWP report viewer.
SfRichTextBoxAdv
Features
- #131913, #175243, #186034 - Added support to view and modify the Right-to-Left contents such as text, table, paragraph and list.
- #137783, #149291 - Added support for drag and drop contents within the control.
- #187534 - Added
EnableCopyIcon
property inSfRichTextBoxAdv
class to enable or disable built-in copy icon. - Added
StorageFile
or file uristring
parameter types support forInsertPicture
method inSelectionAdv
class to insert the picture at cursor position in addition toStream
orbyte[]
parameter types.
Bug Fixes
- #184764 -
ArgumentOutOfRangeException
will be no longer thrown when typing text in Mobile device. - #185160 -
COMException
will be no longer thrown when custom template is used forSfRichTextBoxAdv
control. - #188103 -
StackOverflowException
will be no longer thrown when inserting large size image in nested table. - #188105 -
ArgumentOutOfRangeException
will be no longer thrown when editing text in document containing more than one paragraphs within field code. - #188194 - Style values specified within single quotes are now preserved properly while opening HTML.
- #188522 - Borders values are now properly exported in HTML with all cultures.
- #188522 - Text inside table is now displayed properly after modifying table properties.
- HTML tags font, strike and attributes font-size, line-height, padding are now preserved properly while loading HTML.
SfSchedule
Bug Fixes
- #189815- Now, radial menu expanding properly while tapping the Schedule appointment.
- #187655- Now, selection text color of appointment works properly.
Improvements
- Added
Appointments
property inCellTappedEventArgs
to get appointment collection in the touch events.
SfSmithChart Preview
A new Smith chart control has been added that is useful for visualize high frequency circuit data.
Key Features
- Visualization of the impedance and admittance of a transmission line.
- Representation of data with line series and various types of markers.
- Data label support for better readability.
- Interactive tooltip support.
- Interactive legend.
- Customizable colors.
SfTabControl
Bug fixes
- #188562 – Visibility of Scroll Buttons in Tab Panel now updated properly based on
TabScrollButtonVisibility
of SfTabControl.
SfTreeGrid
Features
- #180714 – Provided support for freeze columns (non-scrolling columns) on the right, like in Excel using
FooterColumnCount
property. - Provided support for stacked header rows, which are unbound header rows that can span multiple rows and columns to group one or more header cells.
SfTreeNavigator
Bug fixes
- #189037 - Items will be loaded properly, when
ItemSource
is updated dynamically. - #189177 -
HierarchicalDataTemplate
will work properly, when loaded from theXamlReader
.
SfSpreadsheet
Features
- #119434, #133890, #153524 - Provided support for array formula calculation like Excel.
VS-Extensions
Features
- Added Syncfusion Troubleshooter support for Syncfusion UWP applications.
XlsIO
Features
- #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 inIOleObject
class. - The properties
EvenPage
andFirstPage
of typeIPage
are added inIPageSetup
class. - The properties
LeftHeader
,CenterHeader
,RightHeader
,LeftHeaderImage
,CenterHeaderImage
,RightHeaderImage
are added inIPage
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.
- #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. - #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.
- 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 theSetColumnWithPixels
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
inBorders
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()
.