Essential Studio for Xamarin.Forms Release Notes

v14.2.0.26
June 24, 2016

Calculate New

The Calculate is an independent class library that allows you to provide extensive calculation support to your business objects. Also it provides support to parse and evaluate the expression or formulas with 400+ predefined functions. Some of the key features are below,

  • Parses and evaluates the Excel based formulas and equations.
  • Named ranges, dynamic references, array formulas and formula dependencies are supported.
  • Supports cross sheet references (can work with multiple sheets).
  • Supports custom functions with n-number of optional arguments.
  • Culture-sensitive decimal separator and argument separator.
  • It also supports Indexer method for calculation.

DataSource Preview

A new data source control has been added. DataSource is a non UI component that consumes raw data and processes data manipulation operations such as sorting, filtering and grouping

Key Features

  • Grouping
  • Sorting
  • Filtering

DocIO

Features

  • #147526 – Added Read and Write support for WordprocessingML documents.

Bug fixes

  • #151174 - Relative position properties are now preserved properly while opening and saving the Word DOCX format document.
  • #155024 - ArgumentOutOfRangeException is no longer thrown while saving the Word document with charts.
  • #154762 - Text box internal margins are now preserved properly while saving the Word DOCX format document.
  • #154762 - Cell width for the table containing misaligned cells are now preserved properly in Word to HTML conversion.
  • #154762 - Line breaks are now preserved properly during Word to HTML conversion.
  • #153445 - Check box size and size type is now properly preserved during Word to HTML conversion and vice versa.
  • #154702 - IndexOutOfRangeException is no longer thrown while executing Mail merge using DocIO.
  • #154730, * #154864 - Null reference exception is no longer thrown while retrieving bookmark content.
  • #156444 - OLE object is now properly preserved while opening a particular DOCX format document.
  • #155252 - Checkbox size is now properly preserved in Word to HTML conversion.
  • #152738 – Text contents are now preserved properly while resaving a particular DOCX format document
  • #156982 - Page orientation now preserved properly while modifying and resaving the Word document.
  • #155820 - Consecutive text with same format are now properly preserved as single span element in Word to HTML conversion
  • #153104 - Section break issue has been resolved in DOCX conversion
  • #156622 - File corruption issue after resaving the Word document as Doc format is resolved
  • #156372 - TOC paragraph’s formatting is now preserved properly.
  • #157924 - Field code is now retrieved properly while accessing WField.FieldCode property.
  • #154988 - The words count in the document will be updated properly
  • #154681 – Chart title text is now preserved properly without formatting loss while modifying and resaving the Word document.
  • #156461 – IndexOutOfRangeException is no longer thrown while resaving the RTF document.
  • #156651 – Title field is now preserved properly while updating document fields.
  • #156713 – Symbols are now preserved properly while resaving a particular DOCX format document.
  • #157702 – DocIO toolbox icon is now shown properly in Visual Studio toolbox filter.
  • #158331 – WCharacterFormat.ClearFormatting() is now clears the formatting properly.
  • #158521 - File corruption issue while opening the generated DOCX document in Word 2007 application.

PDF

Features

  • Support for inserting pages from an existing document into a new document or another existing document has been added.
  • IDisposable interface has been implemented for PdfDocument object.
  • Support for toggling the visibility of form fields when printing has been added.

Bug Fixes

  • #157655 - Application no longer crashes when the device language is set to Hebrew.
  • #157204 - Top border style of PdfGrid is now preserved as expected when applying dotted line.
  • #156812 - Unexpected second page is no longer added when drawing PdfGrid.
  • #156541 - Image added to the PDF is now visible.
  • #154918 - Exception is no longer thrown while parsing layers in the PDF document page.
  • #154931 - NullReferenceException is no longer thrown while loading the specific PDF document.
  • #153969 - List box items are now visible when selecting multiple values.
  • #151146 - Characters are now properly preserved while flattening the form fields.
  • #153027 - Dollar symbol is now preserved correctly when flattening the PDF form.
  • #151146 - Text is now properly aligned when flattening form fields.
  • Exception is no longer thrown while removing named destinations in an existing PDF document.
  • Text is now preserved properly while flattening the button field.

Presentation

Features

  • #155426 - Added support to add and modify hyperlinks in PowerPoint slide.
  • #157587 - Added support to access the “SlideID” associated with each slides in PowerPoint presentation.
  • Added support for setting custom slide size in PowerPoint presentation
  • Added support for setting background images with “Stretch” and “Tile” options in PowerPoint presentation

Bug Fixes

  • #156159 - “NullReferenceException” will be no longer thrown while opening the PowerPoint presentations modified using Open XML SDK
  • #155884 - “NullReferenceException” will be no longer thrown while opening a PowerPoint presentation edited with Open XML SDK
  • #154813 - “NullReferenceException” will be no longer thrown while opening a PowerPoint presentation generated by b2xTranslator(3rd party tool)
  • #156191 - “KeepSourceFormatting” paste option will now work properly while merging two PowerPoint presentation
  • “ParseException” will be no longer thrown while serializing a pie chart
  • “ArgumentNullReferenceException” will be no longer thrown while the “MinusIRange” property of the chart is null
  • “Smooth line chart” will no longer change into “Straight line chart” while resaving the PowerPoint Presentation
  • Line thickness will no longer change while setting the line color.
  • “NotSupportedException” will be no longer thrown while opening the PowerPoint presentation with “Clustered bar chart”
  • “Date axis” in charts are now preserved properly while resaving the PowerPoint presentation
  • “ArgumentException” will be no longer thrown while resorting the chart series formats.
  • “Index Out of Range Exception” will be no longer thrown while parsing the PowerPoint presentation with “Line chart”
  • Secondary axis in “Bar chart” is now preserved while resaving a PowerPoint presentation.
  • “Stock chart” will no longer change into “Line Chart” while resaving the PowerPoint presentation.
  • Now the BuiltInDocumentProperty - “NoteCount” is updated properly while resaving the PowerPoint presentation
  • “BarShapeTop” property of 3D-chart types is now preserved properly while resaving the PowerPoint presentation
  • Chart title is now preserve as same as in input file while resaving the PowerPoint presentation
  • “SerieNameLevel” and “CategoryLabelLevel” properties of chart are now preserved properly while resaving the PowerPoint presentation.

SfAutoComplete

Features

  • DataTemplate support has been provided for dropdown items.

Bug Fixes

  • #157846 - Suggestion value not binding with Text property issue has been fixed.

SfBarcode

Bug Fixes

  • #155707 - Now, Barcode Background color dynamic change is working properly
  • #155985 - QR Code generates wrong QRCode when scanned issue has been fixed.

SfCalendar

Bug Fixes

  • #157839 - Inline event issue with AllDay property has been fixed.
  • #155898,#156371,#157573 - Calendar Tapped event not getting fired has been fixed.
  • #157479 - Issue with Inline event not getting updated dynamically has been fixed.
  • #157475 - Issue with Inline event getting Toggled event in WinPhone8.1 has been fixed.
  • #157213,#157475 - Issue with Inline event not displaying color has been fixed.
  • #155530 - Issue with Selected Date text color in Calendar has been fixed.
  • #156088 - Scrolling issue inside scroll view has been fixed.
  • #156261,#156248 - MoveToDate binding issue has been fixed.
  • #156219 - CalendarTapped EventArgs issue has been fixed.
  • #156261 - SelectedDate not working in WinRT,WinPhone8.1 and UWP has been fixed.
  • #156090 - Scrolling issue in Inline Event items has been fixed.
  • #155153 - Refresh issue with Inline event when added dynamically has been fixed.
  • #153647,#154856,#156371 - Calendar crash issue has been fixed.

Breaking changes

  • In “SelectionChanged” event, the previous arguments “SelectionRange” has been Changed to “DateAdded” and “DateRemoved” collections which will hold the date collections of Previous and Selected dates.

SfCarousel

Features

  • Now Linear view mode has been provided in carousel.

  • DataTemplate support has been provided for carousel items.

Bug Fixes

  • #155943 - SelectionChanged event not getting fired in Windows platform has been fixed.

SfChart

Features

  • 10 types of Technical Indicators have been added.

  • Step area series has been added.

  • Now you can customize the spacing between two columns and bars.

  • Now GetActualIntervalType method is available in DataTimeAxis to get the actual interval type of the axis.

  • Enhanced the Candle series with Doji and Hollow support.

Bug fixes

  • #157401 - Now chart is responsive while zooming with customized DataTimeAxis interval.

  • #157759 - Now the trackball label is visible for stacking series which contains negative values.

  • #157066 - Now ScrollView works properly when the Chart added as its child.

  • #156063 - The issue with SelectedDataPointIndex is not resetting properly when you change the ItemsSource has been fixed.

  • #156337 – ChartLabelStyle's LabelFormat is working properly in chart axis now.

  • #156337 - Now Tooltip's LabelFormat is working properly.

  • #F124346 - Issue with SideBySideSeriesPlacement using DataTimeAxis has been fixed.

Breaking changes

  • The default value of Spacing property in all the column and bar type series has been changed to 0 from 0.2.

  • Previously, the Candle and OHLC series colors applied based on the current data point close and open values. Now, the colors applied based on the close values of previous and current data points.

SfCircularGauge

Bug Fixes

  • #123972 - Now, RangePointer Offset is working properly.
  • #157161 - Now, CircularGauge labels displaying properly for negative scale values.
  • #123423 - CircularGauge alignment issue has been in Xamarin.Android
  • #124128 - Now, Size issue in CircularGauge (WinRT) has been fixed.

SfDataGrid

Features

  • #155632 - Support to customize the cells border has been provided
  • #155581 - Support to Unbound column has been provided
  • #156250 - Support to scroll to a row and/or column index programmatically has been provided.
  • #145829 - Support to expand or collapse groups in runtime has been provided.
  • # Support to displaying multi-line text for the record cells in its columns.
  • # Support to perform the sorting operation either on single tap or double tap.
  • #F123971 Support for PagerDisplayMode to customize the display modes of SfDataPager has been provided.
  • #F123971 Support for customizing the appearance of the SfDataPager has been provided.
  • Support for double click event has been provided

Bug fixes

  • #156779 - Pull to refresh is not working while having row count less than view port size has been fixed
  • #157070 - SfDataGrid left border goes beyond rows and cannot be hidden in Xamarin.Forms UWP has been fixed
  • #157254 - OnDemandPaging not working in Xamarin.Forms has been fixed
  • #F124298 - Exporting grid to excel creates additional one row has been fixed.
  • #154832 - DataGrid`s items are not scrolling inside the ScrollView in Android has been fixed.
  • #153571 - Default row background color is not cleared when applying custom style before the grid is loaded has been fixed.
  • #155428 - Alignment issue in header cells when setting more than one GravityFlags has been fixed.
  • #155322 - SfDataGrid crashes when setting RowDefinition height as “Auto” for the parent Grid has been fixed.
  • #155010 - SfDataGrid crashes when clearing item source and adding items to the same collection when grouping is enabled has been fixed.

Breaking Changes

  • SfDataPager.AccentBackground property has been marked as Obsolete. Use SfDataPager. AppearanceManager property instead.
  • GridColumn.TextWrapping property has been marked as obsolete. use GridColumn.LineBreakMode property instead.
  • SfDataGridLongPressedEventHandler has been renamed to GridLongPressedEventHandler
  • SfDataGridTapEventHandler has been renamed to GridTappedEventHandler
  • SfDataGridViewCreatedEventHandler has been renamed to GridViewCreatedEventHandler

Known issues

  • Deploying SfDataGrid in Windows Phone and WinRT platforms will not work with Xamarin NuGet greater than 1.5.1.6471 due to cyclic layout calls in the Framework. This is a known issue and has been [reported as a bug] (https://bugzilla.xamarin.com/show_bug.cgi?id=36328) in Bugzilla and is being worked by Xamarin. Hence this version of SfDataGrid does not support Windows Phone and WinRT platforms. In case, if you prefer to run the SfDataGrid with 1.5.1.6471 version of NuGet, please contact our support team to get custom assemblies.

SfLinearGauge

Bug Fixes

  • #156977 - Displaying wrong scale and pointer values while setting negative numbers has been fixed.

SfMaps

Bug fixes

  • #124182 – Selection event is not triggered issue has been fixed.
  • #156985 - UnSelection is not working issue has been fixed

Feature

  • #152977 - DataTemplate support has been provided for Map Markers.

SfNavigationDrawer Preview

NavigationDrawer control is an interactive slide panel that pops on flip gesture. An elegant way to pop out the slide content from any of the four sides.

Key Features

  • Position
  • Transition

SfPullToRefresh New

The PullToRefresh Control is an interactive content panel that allows users to pull down to refresh or load content in a view.

Key Features

  • Customizable Refresh content
  • Various transition modes

SfRating

Bug Fixes

  • #157831 - Control appearing blurred in high resolution device issue has been fixed.

SfRotator

Features

  • DataTemplate support has been provided for rotator items.

Bug Fixes

  • #157502 - Exception while scrolling the last image in Rotator has been fixed.

SfSchedule Preview

Features

  • #155309 - Provided Support for MonthInlineAppointmentTapped Event.

Bug Fixes

  • #157807, #157538 - Now, AppointmentCollection is updated dynamically
  • #155735, #155736 - Now, ScheduleView is changed properly in Picker
  • #155735, #155736, #156594, #123876, #124028, #124027 - Now, ScheduleAppointmentCollection is added properly while dynamically added in VisibleDatesChangedEvent
  • #156421 - Now, AllDayAppointment when set into WeekView working properly
  • #124246 - Restricting ScheduleView when reaching Minimum and Maximum display date issue has been fixed.
  • #124129 - Now, Spanned ScheduleAppointment rendered properly in High density devices.
  • #156307 - Schedule Appointment StartTime and EndTime differs in WeekView when FirstWeekOfDay applied issue has bee fixed
  • #124087 - Time zone issue when tap on the Schedule issue has been fixed (Android)
  • #157122, #124107 - Appointment rendering issue when the duration is lesser than 30 minutes issue has been fixed (Android)

SfTreeMap

Feature

  • #152977 - DataTemplate support has been provided for Treemap items.

XlsIO

Features

  • #156955 - Table formula support has been added.
  • #154319 - Support for new Excel 2016 functions has been added.
  • Support for importing data into Excel from ExpandoObject objects has been added.
  • Support for Text, Date and Dynamic filters has been added.
  • Replace operation has been enhanced with customized options.
  • Incremental formula (row wise and column wise) support has been added.
  • Support is provided for number format in conditional formats.

Bug fixes

  • #152796 - Ambiguity problem while accessing name of the chart through IChartShape is resolved.
  • #154096 - File corruption issue after resaving the file is resolved.
  • #154123 - NullReferenceException is no longer thrown while parsing chart series data points.
  • #154057 - ParseException is no longer thrown while parsing a workbook generated from EPPlus.
  • #153772 - Number format will no longer change inside ImportArray() method when it is passed as a parameter.
  • #150880, #151503 - FormulaValue is now updated properly after updating the formula.
  • #154138 - ParseException is no longer thrown while applying subtotal in German culture.
  • #157717, #153917 - Performance issue while applying styles for existing workbook is resolved.
  • #154858 - ArgumentException is thrown when a formula length exceeds 255 in .XLS format is resolved.
  • #155657 - ArgumentOutOfRangeException is thrown while calling SaveAs() multiple times for .XLS file is resolved.
  • #155966 - Misplaced text issue while increasing check box height is resolved.
  • #154499, #156771 - Issues with custom IconSet in the conditional formats are fixed.
  • #156319 - ArgumentException is no longer thrown while copying between different worksheets.
  • #155690 - Issue with horizontal page break collection of worksheet returning empty is resolved.
  • #156017 - Comment property is now available in named range and is no longer removed while saving.
  • #156144- File gets corrupted when inserting rows after table header row is fixed.
  • #154964, #155881, #156893, #158255- Application no longer hangs while setting formulas to a range.
    ** #155864 - Performance issue while opening a sheet with larger data validations is fixed.
  • #153515 - Issue with ForeColor of chart is resolved.
  • #156893, #158283 - Performance issue while applying styles by cells is resolved.
  • #155488 - Issue with column style being removed on save is resolved.
  • #158045 - Time validation is not set properly when the range has number format is resolved.
  • #156920 - XmlException is no longer thrown while opening the Excel workbook with pictures.
  • #157158 - NotSupportedException is no longer thrown while reading the SparklineGroup.
  • #155880 - Issue with number formats of axis labels when source linked is resolved.
  • #157275 - Issue with calculated fields not added in the pivot table data fields is resolved.
  • #153772, #158045 - Number format is not proper while importing array to the worksheet is resolved.
  • #158336 - NullReferenceException thrown while auto fitting the copied range is handled.
  • #154681 - Text formatting issue in chart and legend titles are resolved.
  • #155881 - Border is not updated properly is resolved.
  • #155434 - DivideByZeroException is no longer thrown while importing DataTable with DDE link formula.
  • #156583 - File is no longer corrupted when saving a workbook with two tables.
  • #154915 - Issues with label separation from axis line in charts are resolved.
  • #155903 - Issue with charts due to incorrect formula number values is resolved.
  • #155355, #155784 - Issues with custom text settings in data labels are resolved.
  • #158494 - Normal style formatting preservation issue in RTF to RTF conversion is resolved.
  • #156929 - Issues with individual data point border in series in charts are resolved.
  • #156929 - Issue with legend icon color on invert color applied series is resolved.
    Formula range is not updated while referring value form different worksheet is resolved.
    Issue with copying or moving a table between different worksheets is resolved.
    NullReferenceException is no longer thrown while accessing RTF text.
    OverflowException will no longer occur while setting cell reference as formula.
    ArgumentOutOfRangeException is no longer thrown while setting empty string to IMigrantRange.
    ArgumentOutOfRangeException is no longer thrown when opening the excel file.
    GetRowHeightInPixels() method now returns proper row height on opening a file.
    Row values are updated properly after DeleteRow().
    SerieType property of chart is now properly updated on resaving XLSX file.
    Auto-fitting rows now returns proper row height.
    IsSummaryRowBelow flag in subtotal is now working properly.
    Issues in display text for pre-defined currency number formats are resolved.
    NullReferenceException for pivot source range while importing is handled.