Essential Studio for Xamarin.Forms Release Notes

v15.4.0.17
November 10,2107

SfChart

Features

  • #F129977, F130999, F135617, I163250, I181775, I187676 – The chart control now supports annotations. It displays metadata about a chart or series at a specific point in the plotting area.

  • #F131629, I156914, I183768, I184533 - Axis crossing feature is used to change the location where the x-axis crosses the y-axis and vice-versa in the chart control.

  • #F130589, I180073, I183817 - Corner radius support has been provided for all bar type series.

  • #I183817 - Now, the axis label can be customized with rounded corner background.

  • #I184533 - Start angle support for polar and radar charts feature allows you to set angle for the axis.

  • #F132881, F142906, I179279, I183352, I189705 – Now, support has been provided to wrap legend items based on the available size of the chart.

Enhancements

  • #F137790, I149292 - An event has been added to handle the tap event in axis labels.

  • #I164594 - Now, visibility of single pie segment can be collapsed by using the corresponding legend items in toggle action.

  • #I148403, I149024, I149067 – Now, AutoScrollingDelta feature can be shown from first set of data.

Bug Fixes

  • #I190424 – Now, tooltip label position will render properly.

  • #I188981 – Issue on data marker label style text color has been fixed.

  • #I163247 – Now, tooltip will not hide while changing the orientation of the device.

  • #I186500 – Animation will work properly while changing the layout size dynamically.

  • #I189386 – Issue on exporting the chart when the background color is set has been fixed.

  • #I188334 - Chart header will be visible while changing BindingContext dynamically in Xamarin.Forms UWP.

  • #I189861 - Chart color will be applied properly for upgraded version of Xamarin.Forms UWP.

General

  • Now all the controls are compatible with .NET Standard 1.0 and above.

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.

NuGet

Features

  • Added NuGet support for SfImageEditor control in Xamarin UWP platform.

  • Added .NET Standard support for Xamarin.Forms platform NuGet packages.

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.

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.

SfAutoComplete

Breaking Changes

  • SfAutoComplete UI has been changed. The AutoComplete Search box view has been changed to rounded-edge corners.
  • AutoCompleteSource has marked as Obsolete. Instead of use DataSource.

Bug Fixes

  • #188394 - Now, the delay is reduced when loading our control and also improved the performance of SfAutoComplete.
  • #188786 - Now Scrolling the Suggestion list works correctly.
  • #190002 - When clicking clear button, it erases the value entered correctly and binding of Text property works correctly
  • #190912 - SelectionChanged event works correctly irrespective of CaseSensitive words.
  • #188580 - Now, SfAutoComplete works correctly when changing the Orientation
  • #133346 - Now binding works correctly in SfAutoComplete without filling it by DataSource

Features

  • SfAutoComplete Performance has been improved when using large number of collections in DataSource in Android
  • Provided get and set support for SelectedValue property in Xamarin.Forms.

SfCalendar

Bug Fixes

  • #189882 – Now,SelectedDate binding is working fine when NavigateToMonthOnInActiveDatesSelection property is true.
  • #182948 - Custom Calendar InlineView is appeared properly in Android.
  • #132525,#187232 - Now,NullableSelectedDate is working fine when it is defined in the constructor.
  • #185932 - Vertical and Horizontal scrolling is working fine while selecting MinDate (today date) after selecting date.
  • #182948 - Custom inline view is visible properly.

SfCircularGauge

Features

  • # 132899 – Provided support for Pointer Animation Duration Change.

Bug Fixes

  • # 186713 – Ranges will render properly when binding its start and end values inside the Async method in CircularGauge.

  • # 186937 – Now ranges can be added and removed dynamically in CircularGauge.

  • # 184907 – Now minor ticks will render properly with default value for offset.

  • # 185851 – Now circular gauge will not throw null exception when it is used inside the relative layout in Xamarin.Forms iOS.

  • # 185061 – Now range pointer will render properly with default value for offset.

  • # 183743 – Now circular gauge will render properly in release mode with Linking option enabled.

  • # 189278 – Now circular gauge will align center in grid.

  • # 188833 – Now Last label is visible if the interval exceeds the end value in SfCircularGauge .

  • # 186401 – Now Ranges and scales will not stretch when changing the device orientation in Carousel page

Breaking Changes

  • Now load time animation is working properly in Android and iOS.

  • RangePointer Thickness was drawn at half of the given value in iOS. Now, this issue has been fixed.

  • In Xamarin.Forms for UWP, 1 was considered as center and 0 was considered as the edge for the Offset values. It is vice versa in iOS and Android. This has been fixed for ticks, range, and range pointer.

  • In Xamarin.Forms for UWP, labels, ticks, range, and range pointer were dependent on Scale. i.e. if the scale’s RadiusFactor is reduced, other elements will be moved with relative to the scale. Now, this issue has been fixed.

  • In Xamarin.Forms for UWP, LengthFactor value as 1 for NeedlePointer was not working dynamically and default value was rendering. Now, this issue has been fixed.

  • In Xamarin.Forms for UWP, default space in prefix and postfix labels has been removed.

SfDataGrid

Bug fixes

  • #186559 - Last few columns not coming in view while scrolling with ScrollingMode.Line issue has been fixed.
  • #184838 - InputTransparent property not working for SfDataGrid issue has been fixed.
  • #188635 - Exception when SfDataGrid is loaded with more number of switch columns has been fixed.
  • #177747 - Edited last row is now correctly shown in the view along with the keyboard view in Samsung S8+ device.
  • #189852 - Selected items are now updated correctly on refreshing the underlying collection twice at runtime.
  • #189417 - Now, scrolling effect will be smoother in Xamarin.Forms.iOS, when column sizer is set to Auto.
  • #190573 - SfDataPager.PageSize can now be set after the SfDataPager.Source property and the page number buttons will be displayed based on the page size value.
  • #186747, 190911 - Now, keyboard will collapse correctly when the cell gets unfocused.

Enhancements

  • #187260 - Support provided to export data grid to a specific page or specific position in the PDF document.
  • #183743 - Linker settings compatibility for Xamarin.Forms.Android and Xamarin.Forms.iOS has been provided.
  • #182082, 188918 - The border color of the header cells can be customized for all the modes of grid line visibility.
  • #174781- The font attributes of the grid columns can be customized as Bold, Italic or None.
  • #180308 - The template column performance has been improved by optimizing the visual tree.
  • #130876 - Provided support for getting the new value and old value in GridCurrentCellEndEditEventArgs.
  • #179577 - Built-in data virtualization support has been provided which can be enabled by setting the SfDataGrid.EnableDataVirtualization property.
  • #189412 - Support to customize the editing of GridSwitchColumn based on AllowEditing property has been provided.
  • Support for hosting the SfDataGrid inside SfPullToRefresh control has been provided.
  • Data pager has been visually improved with customizable options and scrolling effects.
  • Support to query a range of rows programmatically has been provided.

Features

  • #F125365, 162246, 162554, 164527, 175018, 187811 - Support for grouping more than one columns programmatically has been provided.
  • Support to customize the cell style and row style through events has been provided. Using this events row and cells can be customized conditionally based on data.
  • Support for customizing the caption summary rows by loading a DataTemplate has been provided.
  • Support for animating sort icon and group icon has been provided which can be achieved by writing a custom DataGridStyle.

SfDateTimeRangeNavigator

Bug Fixes

  • #189311 - ViewRangeStart and ViewRangeEnd will work properly in all the time zones in iOS.

SfDiagram preview

The diagram control can be used to create different types of diagrams such as flow charts, use case diagrams, workflow process diagrams, and more. Also, this control allows you to build applications for creating or editing diagrams interactively.

Features

  • Nodes, connectors, ports: Elements used to compose a diagram.
  • Layouts: Arrange nodes in a tree-like structure based on the relationship between them.
  • Undo/redo: Reverse or re-apply recent changes.
  • Stencil: Holds a list of symbols that is displayed over a diagram.
  • Serialization: Save the current state of the diagram, and load it back when needed.
  • Interaction: Selection, zooming, and panning.

SfDigitalGauge

Bug Fixes

  • #183743 – Now digital gauge will render properly in release mode with Linking option enabled.

SfImageEditor

Features

  • # 187749,190329 – Provided support for Aspect Ratio for cropping an image.

Bug Fixes

  • # 188538 – Now Saving the flipped image will save the correct image.

  • # 190329 – Now NullReference Exception will not throw in SfImageEditor.

  • # 185256, 187476 – Now ImageSaved event will return the image stream with current changes.

  • # 185256 – Now image will be saved with its actual size in Image Editor Android.

SfLinearGauge

Features

  • #186748 – Provided support for changing SymbolPointer Position.

Bug Fixes

  • #183743 – Now linear gauge will render properly in release mode with Linking option enabled.

  • #189737 – Now linear gauge ScaleBar will apply properly.

SfListView

Features

  • #162069, #171258, #171653, #174733, #178959, #179581, #180083, #130684, #188841, #133528 - Provided support for item reordering by drag and drop the item either on long press or from drag indicator view.
  • #171728, #174491, #175867, #177236, #177788, #130224 - Provided support to load more data at runtime automatically or manually when end of the list is reached.
  • #130003 - Provided support to animate the selection and swipe actions.
  • Provided DataTemplateSelector support for header, group header and footer item.

Enhancements

  • #186614, #132382, #133611 - Provided support for ScrollStateChanged event to notify the scrolling state changes.
  • #189145, #183191 – Sorting and grouping performance has been improved in Android.
  • #132103 - Provided support to notify the swipe view reset using SwipeReset event.

Bug Fixes

  • #186720, #188045, #188424, #188699, #132752 - Item’s size are now updated properly when font or content size of child element is changed at runtime on AutoFitMode.
  • #186311, #190347 - Items are now updated properly when navigate back to SfListView after changing the ItemsSource from another page.
  • #132931, #188898 - ItemHolding event is no longer triggered while swiping an item slowly.
  • #189081 - ScrollToRowIndex is now scrolled to specified index when programmatically scrolling to the same index again.
  • #189986 - Swipe view is no longer overlaps with list view item and layouts properly on AutoFitMode.
  • #190210 - Items are now rendered in the view properly when loaded inside ContentPresenter on AutoFitMode.
  • #189780 - Scrolls to last item properly when passing the last item index in ScrollToRowIndex method.
  • #186720 – Total extent is now updated properly when item size decreased at runtime on AutoFitMode.
  • #133326, #190582 - Scroll is no longer bounces back when items are scrolled for the first time.
  • #132137, #191107, #190009, #191608 – Null reference exception is no longer thrown when measuring the size of an item in AutoFitMode.
  • #185572 – Mouse wheel scrolling is now works properly in UWP.

SfNavigationDrawer

Bug Fixes

  • #188971 - Now Background image get shown inside ContentView of SfNavigationDrawer in Android.

SfNumericTextBox

Bug Fixes

  • #188523 – Now,content inside SfNumericTextBox get shown correctly in Android.
  • #190532 - SfNumericTextBox control works correctly inside Navigation page when using prism in iOS.
  • #188985 – Now,SfNumericTextBox works correctly when entering single digit in iOS.
  • #189039,189419- Now MaximumDecimalDigit works correctly in SfNumericTextBox in iOS.
  • #133395 - Now, edit mode in SfNumericTextBox works correctly when using inside SfDataGrid in Android.

Features

  • Localization support is provided for Return button’s text in SfNumericTextBox

SfNumericUpDown

Breaking Changes

  • SfNumericUpDown UI has been changed. The SfNumericUpDown box view has been changed to rounded-edge corners.

Bug Fixes

  • #189635 - Now, SfNumericUpDown allows restricting the value entering which iOS greater than value set to Maximum in iOS.
  • #186581 - Now, Text inside SfNumericUpDown shown correctly irrespective of FontSize in Android.
  • #190510 - MaximumDecimalDigit works correctly in SfNumericUpDown in iOS
  • #186447 - Now comma get shown in the Value returned from SfNumericUpDown for specific cultural localization in Android.

Features

  • Localization support is provided for Return button’s text in SfNumericUpDown

SfPdfViewer

Features

  • #183497 - Provided support for setting the ViewMode (Fit-To-Width, Fit Page and Default) in SfPDfViewer Xamarin.Forms UWP (Desktop).
  • #168332, #168786, #168837, #168788, #127588, #170402, #175316, #179008, #161126, #168788, #180793, #176128 - Provided supports for Text markup annotations (highlight/underline/strikeout).
  • #188400, #188936 - Provided support to set maximum Zoom percentage.

Bug Fixes

  • #186798 - Application will no longer crash while performing text search operations.
  • #186613, #186795 - Application will no longer crash while scrolling through the pages of large PDF document.
  • #186611 - Application will no longer crash if GoToPage method is called immediately after loading PDF in Xamarin.Forms Android.
  • #183743 - SfPdfViewer control will no longer throw exception while deploying the application when Linker behavior option is set to Link all assemblies.
  • #188627, #190003, #190446 – Exception with “There can only be one UIMenuController instance.” will no longer thrown while navigating between the pages in which PDF viewer has been included.
  • #184957 - Pinch zoom action will maintain center position properly.

SfPicker

Bug Fixes

  • #189970 - Now, Background color of picker is also applied to the footer.
  • #189449 - Now, SelectedIndex property is updated dynamically in Android.
  • #188279 - Text color of SelectedItem is applied correctly when the selected index has changed dynamically.
  • #188694 - SelectedItem property is working correctly.
  • #188235 - Now, SelectionChanged event’s arguments holds current selected item.
  • #188243 - Given SelectedItem value is only selected in android.
  • #188170 - ColumnHeaderTextFontSize Property is working in android.

Features

  • Support provided for default binding mode of SelectedItem and SelectedIndex as Two-way.

SfPullToRefresh

Enhancements

  • Provided support to host the SfDataGrid control as pullable content to refresh the data programmatically or through interaction.

SfRadialMenu

Bug Fixes

  • #188595 - Now, SfRadialMenu works correctly when using Image file inside the SfRadialMenu items.
  • #188372 - Now CenterButton works correctly for opening and closing the SfRadialMenu and delay has been reduced for opening and closing the SfRadialMenu.

SfRangeSlider

Breaking Changes

  • SfRangeSlider UI has been changed. The thickness of the slider is reduced.

Bug Fixes

  • #188659 - Now, SfRangeSlider Thumb can be drag to the Minimum Value in Android

SfRating

Bug Fixes

  • #188907, #132864 - Performance of SfListView scrolling has been improved while adding more number of SfRating controls.

SfRotator

Bug Fixes

  • #184077 - Now, selected view has been updated based on selected index in iOS.
  • #188101 - Now, Rotator works fine with EnableAutoPlay property as true.

Breaking changes

  • DataSource property of SfRotator has been marked as obsolete, instead use ItemsSource property to set the collection for rotator.

SfSchedule

Bug Fixes

  • #F132889 - Now, Schedule week number string will be localized properly in Xamarin.Forms(UWP).
  • #188890 - Now, Schedule appointments renders properly when added appointments in descending order in Xamarin.Forms(iOS).
  • #185414 - Now ScheduleAppointmentCollection gets cleared properly while deleting the appointments in Xamarin.Forms(Android and iOS).
  • #F132489,I188798,I191633,I191345 - Schedule loading performance has been improved.
  • #184553,185910 - Now,Schedule appointments loading performance has been improved in Xamarin.Forms(Android,iOS).
  • #188729 - Now, Schedule appointment custom view render properly with Xamarin.Forms package version 2.4.0.280 or above in Xamarin.Forms(iOS).
  • #185648 - Now, custom view render properly while adding in onMonthCellLoaded event with Xamarin.Forms package version 2.4.0.280 or above in Xamarin.Forms(Android).
  • #189335 - Now, CellTapped event works properly while tapping on the Non-Accessible Block.
  • #189595 - Added Appointments property in CellTappedEventArgs to get appointment collection in touch events.

Features

  • Support for loading custom font to customize schedule labels has been provided.
  • Programmatic date selection and selected date support has been provided.
  • Provided support to customize the number of appointment indicators displayed in month cell.
  • Provided support to scroll to particular time in day, week and work week views.

Improvements

  • Added Appointments property in CellTappedEventArgs to get appointment collection in the touch events.

Breaking Changes

  • The below APIs are marked as obsolete and alternate APIs has been provided. Refer the below table for the obsolete APIs and new APIs.
APIs marked as Obsolete New APIs
SfSchedule.CellStyle.TextStyle SfSchedule.CellStyle.FontFamily SfSchedule.CellStyle.FontSize SfSchedule.CellStyle.FontAttributes
SfSchedule.AppointmentStyle.TextStyle SfSchedule.AppointmentStyle.FontFamily SfSchedule.AppointmentStyle.FontSize SfSchedule.AppointmentStyle.FontAttributes
SfSchedule.HeaderStyle.TextStyle SfSchedule.HeaderStyle.FontFamily SfSchedule.HeaderStyle.FontSize SfSchedule.HeaderStyle.FontAttributes
SfSchedule.ViewHeaderStyle.DayTextStyle SfSchedule.ViewHeaderStyle.DayFontFamily SfSchedule.ViewHeaderStyle.DayFontSize SfSchedule.ViewHeaderStyle.DayFontAttributes
SfSchedule.ViewHeaderStyle.DateTextStyle SfSchedule.ViewHeaderStyle.DateFontFamily SfSchedule.ViewHeaderStyle.DateFontSize SfSchedule.ViewHeaderStyle.DateFontAttributes
SfSchedule.MonthViewCellStyle.TextStyle SfSchedule.MonthViewCellStyle.FontFamily SfSchedule.MonthViewCellStyle.FontSize SfSchedule.MonthViewCellStyle.FontAttributes
SfSchedule.MonthInlineViewStyle.TextStyle SfSchedule.MonthInlineViewStyle.FontFamily SfSchedule.MonthInlineViewStyle.FontSize SfSchedule.MonthInlineViewStyle.FontAttributes
SfSchedule.WeekNumberStyle.TextStyle SfSchedule.WeekNumberStyle.FontFamily SfSchedule.WeekNumberStyle.FontSize SfSchedule.WeekNumberStyle.FontAttributes

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 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.
  • #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 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().