Essential Studio for Xamarin.Forms Release Notes

v18.2.0.44
July 7, 2020

DocIO

Features

  • #266742 - Provided support to select the column range for bookmarks inside tables in Word documents using FirstColumn and LastColumn APIs.
  • #104484, #110940, #189107, #107422 - Provided support to preserve all the revisions of track changes information in a Word document.
  • #153866, #182754, #241820, #254156, #269877 - Provided support to encrypt and decrypt the Word document.
  • #168152, #179023, #201222, #211848, #214272, #219024, #214272, #248610, #253356, #256673, #275324, #277042 - Provided support for updating table of contents in a Word Document.
  • #102916, #237540, #260149 - Provided support for updating Sequence fields in a Word document.
  • #201860, #201718, #205172, #206374, #208660, #209182, #215558, #245097, #274078, #275710 - Provided support to preserve the mathematical equations (MathML) in the Word to PDF/Image conversion.
  • #272770 - Provided support to detect font from theme for the complex script characters in the Word to PDF/Image conversion.

Bug Fixes

  • #250042 - Paragraph style is now preserved properly while open and save the DOCX format Word document.
  • #267826 - Picture Watermark is now preserved properly while clone and merge the DOC format Word document.
  • #269662 - The NullReferenceException will no longer be thrown while closing the Word document.
  • #267398 - Table is now preserved properly while converting a Word document to PDF
  • #270030 - Bookmark is now preserved properly inside the Text content Control while open and save the DOCX format Word document.
  • #272560, #266791 - List numbers are now preserved properly while open and save the DOCX format Word document.
  • #271175 - List type is now set properly while parsing the HTML file.
  • #271988 - The NullReferenceException will no longer be thrown while opening a DOCX format Word document.
  • #F152998 - BeforeClearGroupFieldEventArgs now returns the proper merge field names while performing Mail merge in a Word document.
  • #271634 - The NullReferenceException will no longer be thrown while saving a DOCX format Word document.
  • #271695, #272438, #272430 - The NullReferenceException will no longer be thrown while performing Mail merge in a Word document.
  • #273310 - Left indent is now preserved properly while converting an HTML file to Word document.
  • #272621 - Table cell width is now preserved properly while converting a Word document to PDF.
  • #273378 - Background image is now preserved properly when converting a Word document to HTML file.
  • #274152 - Content control mapped text is preserved properly while converting a Word document to PDF.
  • #273378, #273856 - Background image is now preserved properly when converting RTF to DOCX format document.
  • #267834 - Table cell background is now preserved properly while Converting a HTML file to Word document.
  • #273858 - Text color is now preserved properly while resaving a Word document with background image.
  • #274432 - Protect Word document from editing is now preserved properly while resaving a DOCX format document.
  • #274414 - The NullReferenceException will no longer be thrown while opening a DOCX format document.
  • #274927 - GridSpan values of cell is now retrieved properly while opening a DOC format Word document.
  • #275320 - Invalid length for a base-64 char array or string exception will no longer be thrown while mapping a picture for picture content control in Word document.
  • #276788 - The InvalidOperationException will be no longer thrown while opening a RTF format document.
  • #276053 - LegalStyleNumbering will be preserved properly while resaving a DOCX format document.
  • #276105 - The OleObject of Link Field is now preserved properly while resaving a DOCX format document.
  • #275893 - The alternate chunk is now updated properly while converting a Word document to PDF.
  • #274393 - The NullReferenceException will no longer be thrown while replacing the bookmark content.
  • #277006 - Repeating section content control is now preserved properly while converting a Word document to PDF.
  • #277830 - Table cell borders are now preserved properly while resaving a RTF format document.
  • #272438, #273336 - The ArgumentOutOfRangeException will no longer be thrown while converting a Word document to PDF.
  • #266244 - Text is now preserved with proper alignment while converting a Word document to PDF.
  • #268875, #271698, #274381 - Hanging issue has been resolved while converting a Word document to PDF.
  • #268875 - Picture is now preserved properly while converting a Word document to PDF.
  • #270030, #271941 - Image is now preserved properly while converting a Word document to PDF.
  • #267958 - Text is now wrapped properly while converting a Word document to PDF.
  • #268928, #273361 - Text is now preserved properly while converting a Word document to PDF.
  • #272436 - Font substitution event OriginalFontName property will not return majorHAnsi while converting a Word document to PDF.
  • #272754 - Textbox is now preserved properly while converting a Word document to PDF.
  • #F152680, #274794, #279294 - Text is now preserved properly while converting a Word document to PDF.
  • #271667, #268266 - The NullReferenceException will no longer be thrown while converting a Word document to PDF.
  • #271333 - Bullet list is now preserved properly while converting a Word document to PDF.
  • #263739, #274914 - Text around the table is now wrapped properly while converting a Word document to PDF.
  • #F137285 - Image is now preserved properly while converting a Word document to PDF.
  • #274045 - Border is now preserved properly while converting a Word document to PDF.
  • #277180 - Arabic text is now preserved properly while converting a Word document to PDF.
  • #F154567 - The FormatException will no longer be thrown while converting a Word document to PDF.
  • #278496 - The footer content is now preserved properly while converting Word document to PDF.
  • #276330 - The Empty page preservation issue has been resolved while converting a Word document to PDF.
  • #274743 - Line alignment is now preserved properly while converting a Word document to PDF.
  • #274379 - The table is now preserved properly while converting a Word document to PDF.

PDF

Features

  • #268014 – Provided support to add cloud annotations in PDF document.
  • #269848 – Provided support to retrieve the exact boundaries of the highlight annotation in a PDF document.
  • #267968 – Added support to get the ColorSpace details for each page in an existing PDF document.
  • #264832 – Added support to remove the document modified date for an existing PDF document.
  • #273977 – Added support to provide options to validate the digital signatures in an existing PDF document.
  • #276918 - Added support to set the language for tagged PDF.
  • #276260 - Added support to validate the signature with the PSS algorithm.
  • #275396 - Added support to draw the text with the same baseline for different fonts.
  • #274224 - Added support to extend the margin when merging the PDF documents.

Bug Fixes

  • #271164 – Exception no longer occurs when saving the document after removing annotations.
  • #261704 – Bookmark will be reflected properly after removing bookmarks.
  • #259394 – Ink annotation will be preserved properly while flattening annotation.
  • #273970 – Modified date will be retrieved properly from the input PDF document.
  • #271463 – Exception no longer occurs when accessing layers from existing PDF document.
  • #274280 – Exception no longer occurs when creating tables concurrently
  • #272832 – Exception no longer occurs when removing layers from existing PDF document.
  • #272411 – Text will be preserved properly in Word to PDF conversion.
  • #272840 – Layer name will be changed properly in existing PDF document.
  • #251733 – Barcode background and quite zones will be preserved properly.
  • #271614 – Image will be preserved properly in Word to PDF conversion.
  • #266186 – Lines will be preserved properly in Word to PDF conversion.
  • #270437 – Form fields will be flattened properly in existing PDF document.
  • #246796 – Fields and special characters preserved properly while import and signing the PDF documents.
  • #269887 – PDF documents will be merged properly in different order.
  • #269711 – PDF document title will be preserved properly with Swedish characters on A1B conversion.
  • #269495 – Form field values will be preserved properly after disabling default appearance.
  • #269472 – ArgumentException no longer occurs when saving the PDF document.
  • #274606 – UriFormatException no longer occurs when converting HTML string to PDF in Linux docker.
  • #272045 – Auto tag will be work properly for PdfPageNumberField, PdfPageCountField, and PdfCompositeField.
  • #269907 – Exception no longer occurs when processing the PdfTemplates in Azure Durable Function.
  • #269961 – PdfGrid with column span and row span will pass the accessibility check on acrobat.
  • #246796 – Special characters will be preserved properly on form flattening.
  • #F152770 – Added support to set the border width to zero for grid cells.
  • PdfLoadedTextBoxField properly will be reflected properly in PDF document.
  • #278918 – The application hanging issue no longer occurs when importing pages from an existing PDF document.
  • #279519 – The text box fields will be removed properly in an existing PDF document.
  • #275636 – The dropdown field value will be preserved properly when flattening it.
  • #273970 – The modified date will be retrieved properly from the input PDF document.
  • #280499, I278376 – Null reference exception will no longer occur when saving a PDF document.
  • #154898 – GDI+ error no longer occurs when adding HTML styled text to the PDF grid.
  • #278376 – Exception no longer occurs when getting an annotation count.
  • #279341 – Bookmarks will be removed properly for a particular PDF document.
  • #278849 – The form fields flatten will be preserved properly in an existing PDF document.
  • #276260 – Signature validation will be working properly when checks twice.
  • #278317 – Bookmarks characters will be preserved properly when saving an existing PDF document.
  • #275413 – Exception no longer occurs when saving a PDF document.
  • #275975, 27597 – Certificate will be retrieved properly in the existing PDF document.
  • #267968 – Exception no longer occurs when retrieving ColorSpace from the existing PDF page.
  • #154858 – Exception no longer occurs when exporting form fields.
  • #277376, 273510 – The preservation issue no longer occurs when flattening form fields.
  • #275975 – The application hanging issue no longer occurs when validating the digital signature.
  • #275940 – Exception no longer occurs in Adobe reader when opening the imported annotation document.
  • #275947 – The NextPage property of the EndPageLayout event will be working properly in the PdfLightTable.
  • #274456 – Text will be preserved properly when setting expansion text to the PDF structure element.
  • #154141 – The preservation issue no longer occurs when drawing PdfGrid using DataSource.
  • #278348 – The file not found exception will no longer occur in the iOS platform.
  • #276988 – Exception will no longer occur when exporting form fields data in Xamarin.

Presentation

Features

  • #F149477, #272939 - Provided support to extract the embedded OLE Object data from the PowerPoint presentation.
  • #274076 - Exposed the OfficeChart API to gets the IOfficeChart instance of IPresentationChart.

Bug Fixes

  • #274637 - The PowerPoint presentation will no longer be corrupted while adding a cloned slide within section.
  • #273501 - Row and column span will be applied properly while saving the PowerPoint presentation.
  • #271751 - Table cell border will be applied properly while saving the PowerPoint presentation.
  • #279171 - The ArgumentException will no longer be thrown while opening the PowerPoint presentation with handout master.
  • #280471 - The FormatException will no longer be thrown while opening the PowerPoint presentation with custom geometry path.
  • #278512 - The IndexOutOfRangeException will no longer be thrown while opening the PowerPoint presentation with corrupted picture.
  • #278516 - The RTL text will be preserved properly while converting a PowerPoint Presentation to Image.

SfAccordion

Bug fixes

  • #I277429 - [iOS] Now, the height will be updated properly after rotating the screen in SfAccordion.

SfAutoComplete

Features

  • #262893,#271233 - Close button visible support has been provided when the token text is too long in SfAutoComplete.

SfAvatarView

Now, the AvatarView control supports WPF platform in Xamarin.Forms.

SfBadgeView

Bug fixes

  • #272587 - Rounded corner value is applied properly for single badge text.

SfButton

Features

  • [Android, iOS] Now, the button control allows you to disable the ripple effect.

Breaking changes

  • PressedBackgroundColor property in SfButton is marked as obsolete.

SfCarousel

Features

  • #258714 - Disable the touch interaction for carousel view not for child views support has been implemented in SfCarousel.

SfChart

Features

  • The chart control now supports the ErrorBar and BoxPlot chart types.
  • Now, the chart control supports to convert the chart to image as .png format.
  • The built-in method Animate provides a short way to animate series.

Bug fixes

  • #278464 - Now, the FormatException will no longer thrown when using the TrackballLabelCreated event with French culture.

Breaking Changes

  • [UWP]Now, the SaveAsImage method can save the image with the given name instead of the default Chart.jpg.

SfChat

Features

  • #263100 - Support has been provided to load more messages on demand, automatically and manually(by tapping load more button) when scrolling to top of the list of messages.
  • #151676, #266812 - Support has been provided to keep the keyboard open in view, even after a message is sent or focus is lost using the SfChat.ShowKeyboardAlways property.
  • Support has been provided to display a list of interactive cards with title, image and description as messages using the new CardMessage type.
  • SfChat.Scrolled event with arguments IsBottomReached and IsTopReached has been provided to notify scrolling in chat and to notify whether scrolling has reached the bottom or top of the chat.
  • Load custom templates as messages by writing custom TemplateSelector inherited from ChatMessageTemplateSelector and setting it to the SfChat.MessageTemplate property.
  • Support has been provided to restrict multi-line input from the users and to show a send button in the keyboard using SfChat.AllowMultilineInput property.
  • Support has been provided to load HyperlinkMessage as outgoing messages.

SfCircularGauge

Bug Fixes

  • #275244 - [Android] Image source can be loaded without case-sensitive for the marker pointer.
  • #271545 - [Android] Default scale and needle pointer added unnecessarily in some specified Android versions has been resolved.
  • #276424 – [UWP] NeedlePointer will position properly on window resizing.
  • #278088 – The Annotation will point to the correct value on placing inside the CarouselView.

SfComboBox

Features

  • #262893,#271233 - Close button visible support has been provided when the token text is too long in SfComboBox.

SfDataGrid

Breaking Changes

  • To provide support to cell selection, the existing SfDataGrid.SelectionController property’s type is changed from SelectionController to SelectionControllerBase.
  • The default parameter-less constructor of GridSelectionController has been removed. If writing custom selection controller, use constructor with SfDataGrid as parameter GridSelectionController(SfDataGrid) like this(public MyCustomSelectionController(SfDataGrid dataGrid) : base(dataGrid)). Refer UG link for code snippet.

Features

  • #279951, #246406 - The GridColumn.CellTextSize and GridColumn.HeaderCellTextSize properties now supports Xamarin.Forms.NamedSize enum values.
  • #151626 - Built-in support for dark and light theme has been provided for SfDataPager. Support has also been provided to write custom themes using predefined dynamic resource keys.
  • #218123, #269423, #152984 - Support has been provided to select individual cells or the entire row using SfDataGrid.SelectionUnit property.
  • #218123, #269423, #152984 - Support has been provided to select the entire column by tapping the column header using the SfDataGrid.AllowColumnSelection property.
  • #268405 : Support has been provided to await the programmatic selection methods SfDataGrid.ScrollToRowIndex(), SfDataGrid.ScrollToColumnIndex() and SfDataGrid.ScrollToRowColumnIndex().

SfExpander

Bug Fixes

  • #I276027 - Now, the NullReferenceException will no longer be thrown when tapping the SfExpander.

SfImageEditor

Bug Fixes

  • #273017 - [iOS] All the image formats are working fine when loading the control as well as cropping the image.
  • #151857 - The toolbar back button will not be shown and path is drawing properly when using the custom toolbar item.
  • #272867 - [Android] Cropping is working fine when cropping the image multiple times.
  • #153743 - [Android] Drawn path is positioned properly when the control is resized.
  • #154236 - [iOS] ToolbarItem icon can now be replaced dynamically.
  • #14681 - [iOS] Selected palette color will apply properly for pen sketching.
  • #280079 - [Android] Out of memory exceptions will no longer be thrown when editing the image.

SfLinearGauge

Bug fixes

  • #275782 - [Android] The annotation view will be rendered properly when using the BoxView with rotation angle.
  • #14881 – Gradient colors will apply evenly focusing on the center of the BarPointer in linear gauge.

SfListView

Bug fixes

  • #I252107, #I256876, #I257484, #I264516, #I267361 - [Android]Now, the listview items will no longer get disappeared in SfListView .

SfMaps

Bug Fixes

  • #254588 - [iOS] Pinching and panning the maps imagery layer, tiles are now panning smoothly without white space.
  • #274686 – MarkerSelected event will fire properly for sublayer.
  • #274871 – The NullReferenceException will no longer be thrown on binding a sublayer and performing page navigation.
  • #274679 - [Android] The shape layer tooltip will display correctly when zooming.
  • #153896 - [iOS] The NullReferenceException will no longer be thrown on selecting the shape even when the value for the model property is not set.
  • #257625 - [UWP] The performance of the maps is improved on performing zoom in and zoom out continuously.
  • #14976 - [iOS] Bubbles in the shape layer will position properly irrespective of enabling or disabling zoom and pan.
  • #278308 - Min and max zoom behaviors are now working as expected when zooming maps.
  • #278308 - [iOS] Polylines are now positioned properly when update points dynamically and change zoom level.

Features

  • #275244 - Provided virtualization support for Markers, when zooming and panning maps with large markers.

SfMaskedEdit

Bug fixes

  • #14645 - [iOS] Value property will update properly on clicking the “Clear” button.
  • #14713 - [UWP] Control will no longer crash on deleting the text.
  • #15171 - Control will return the actual value properly when setting a password character.

SfNumericTextBox

Bug fixes

  • #277209 – [iOS] The negative values can now be updated in SfNumericTextBox from keyboard.

  • #274088 – [iOS] Updated the border color of SfNumericTextBox equivalent to Xamarin.Forms entry control.

SfNumericUpDown

Bug fixes

  • #264615 – Up and down arrow buttons for SfNumericUpDown control can be customized with different colors now.

SfPdfViewer

Features

  • #259185, 280886, 280857 - The support for customizing the position of the handwritten signature has been implemented.
  • #243331, 266442 - [Android] The support for tile layer PDF page rendering has been implemented.
  • #144830 - The support to show or hide the built-in toolbar dynamically has been implemented.
  • #226899, 275376 - The support to enable or disable the annotation selection has been implemented.
  • #248106 - The support to load PDF asynchronously and cancel the asynchronous loading has been implemented.
  • #262487 - [Android, iOS] The support to load widget annotations that are not mapped to form fields has been implemented.
  • #267982 - Implemented API to notify when the XFA PDF is loaded.
  • #250329 - [Android] Improved the quality of handwritten signature after saving.

Bug Fixes

  • #268378 - [iOS] The PageChanged event now works properly.
  • #266247 - [UWP] Alert dialog for completion of the search operation is now displayed.
  • #267661 - [UWP] The PDF document no longer jumps to the first page when the signature field is tapped.
  • #268304 - The ZoomPercentage API now works properly in the PageByPage view mode.
  • #268304 - [UWP] Ink annotation can now be drawn using the stylus.
  • #269163 - [Android] The PDF document is now displayed.
  • #267982 - [iOS] The KeyNotFoundException will no longer occur when the PDF is long pressed.
  • #269136 - [UWP] Annotations are now exported using the ExportAsImage API.
  • #268304 - [UWP] The GoToPage API is now working when loading PDF from URL.
  • #152202 - The ZoomPercentage and offset APIs work properly in MVVM binding.
  • #268988 - [iOS] Bookmarks are now loading properly.
  • #268304 - [UWP] The ScrollToOffset API is now working properly.
  • #152426 - [Android] Application will no longer crash when unloading the PDF.
  • #271500 - [Android] Popup annotation will no longer be removed from the PDF after saving.
  • #152387 - [Android] Application crashes when loading or unloading the PDF continuously.
  • #269190 - [Android] Form fields will no longer disappear after zooming the PDF pages.
  • #270093 - [UWP] The Page count value will now be correct when reloading PDF after inserting or removing pages from it.
  • #270997 - [Android] PDF now fits the viewport in landscape mode.
  • #271164 - Application will no longer crash when saving the PDF.
  • #269779 - [UWP] The toolbar items are now updated properly in dark mode.
  • #269485 - [Android] Exception will no longer occur when loading and unloading the PDF.
  • #271539 - [Android] The Rectangle annotation will no longer be misplaced and resized when navigating bookmarks.
  • #153006 - [Android, iOS] Theme color will now be changed properly for toolbar.
  • #271940 – [Android] The long-pressed event will no longer be raised on adding annotation.
  • #270930 – [iOS] Annotations are now imported properly.
  • #270990 – The text box form field input is now saved properly.
  • #271424 – [UWP] The DoubleTapped event will now be raised in the single page view mode.
  • #271424 – The value of the TotalSearchInstance API will be cleared when the search operation is canceled.
  • #271424 - The value of the CurrentSearchInstance API will now be incremented on search next command.
  • #271610, 271041 – Checkboxes are now checked properly.
  • #271997 - [Android, iOS] Application will no longer crash when searching text in the PDF.
  • #271916 - [iOS] Application will no longer consume more memory when loading the PDFs.
  • #271601 - [Android] Application will no longer crash when loading the PDF multiple times in Android 5.0.
  • #152387 - [iOS] Application will no longer crash when loading and unloading the PDF continuously.
  • #269136 - [UWP] Annotations are preserved in images exported using the ExportAsImage API.
  • #274193 - [UWP] Application will no longer crash when exporting PDFs with stamp annotations using the ExportAsImageAsync API.
  • #273374 - Annotations can now be properly removed using the RemoveAnnotation API.
  • #269136 - [UWP] Background of the stamp annotations are now preserved properly in the images exported using the ExportAsImage API.
  • #274194 - [UWP] The stamp annotations are now preserved properly in the images exported using the ExportAsImage API.
  • #274342 - [iOS] Zooming and scrolling now works properly in the landscape orientation.
  • #270997 - [iOS] PDF pages are now visible in landscape orientation.
  • #270093 - [UWP] Page count is no longer displayed as 1 in the toolbar when the PDF is unloaded.
  • #247456 - [Android] Handwritten signature is no longer hidden by signature form field when the PDF is saved and reloaded.
  • #274866 - Text is now extracted properly using the ExtractText API.
  • #274229 - [UWP] Application will no longer crash when continuously removing pages.
  • #275857 - [iOS] Application will no longer freeze when loading the PDF.
  • #277161 - [iOS] THe popup annotation will no longer be removed while saving PDF.
  • #268837 - [Android] Cancel button in the signature pad will no longer be cropped.
  • #277764 - [Android] Application will no longer freeze when unloading.
  • #278020 - [iOS] Text in the text form field will no longer be truncated.
  • #276273 - [iOS] PDF page now fits the view port in single page view mode in landscape orientation.
  • #275601 - [iOS] PDF pages will no longer be zoomed out when the bookmark pane is visible.
  • #277155 - [iOS] Application will no longer crash when adding free text annotation.
  • #277431 - [iOS] PDF pages will no longer be visible outside the view port in single page view mode.
  • #277275 - The PageNumber property now works properly.
  • #277367 - [iOS] Text entry of the free text popup is no longer truncated by the device’s safe area.
  • #273725 - Document link annotation works now properly in PDF pages with crop box margins.
  • #154245, 278798, 154684 - [iOS] Application will no longer crash with the System.ObjectDisposedException in single page view mode.
  • #275376 - Border color of the form fields is now applied properly.
  • #276988 - [UWP] Application will no longer crash when exporting form fields.
  • #277834 - The DocumentLoaded event is now raised only after the PDF is completely loaded.
  • #277071 - [Android] Memory consumption for large PDF document has been improved.
  • #277931 - Signature in the PDF is now displayed properly.
  • #278494 - [iOS] Memory consumption for large PDF document has been improved.
  • #278828 - [iOS] Application will no longer crash when the PDF is loaded.
  • #270930 - Annotations are now imported properly.
  • #278348 - Application will no longer throw FileNotFoundException when saving the PDF.
    [Android, iOS] PDF pages can now be properly scrolled when the PDF viewer is placed in StackLayout.
    [UWP] Annotations are now removed properly when the ClearAllAnnotations API is called.
    [iOS] PDF now fits the view port in single page view mode in landscape orientation.
    [UWP] Selected text can now be properly highlighted using the context menu.
    [UWP] The text markup annotation will be selected when it is tapped when the annotation mode is on.
    [iOS] Annotations are now imported properly.
    [Android] The PDF document is now displayed properly.
    [iOS] Application will no longer crash when loading the PDF.

Breaking Changes

SfPopupLayout

Breaking Changes

  • To provide support to Xamarin.Forms.NamedSize enum values, the existing SfPopupLayout.PopupView.PopupStyle.HeaderFontSize property’s type is changed from int to double.

Features

  • #272147 : Support has been provided to refresh the popup, that is already open in view, for run-time value changes, size changes etc using the SfPopupLayout.PopupView.Refresh() method.
  • The SfPopupLayout.PopupView.PopupStyle.HeaderFontSize property now supports Xamarin.Forms.NamedSize enum values.

SfRotator

Features

  • #263302 - Provided the Refresh method for reloading the SfRotator thumbnail.

SfSchedule

Bug fixes

  • #I280163, #I273712 - [Android], [UWP]Now, When using the appointment template, the binding error will no longer occur in the Output window in SfSchedule.

SfSignaturePad (Preview)

The Xamarin.Forms Signature Pad control is used to capture and save signatures in an application. This control displays the drawing path that varies based on writing speed, providing a real pen effect.

Key features

  • Minimum and maximum width of a stroke can be customized.
  • Stroke color can be customized.
  • ImageSource format is supported.

SfTextInputLayout

Bug fixes

  • [UWP] Resolved SfTextInputLayout border not shown issue in Xamarin.Forms 4.6 version.

XlsIO

Features

  • #79793, #84408, #52130, #127002, #140449, #165919, #187729, #192039, #211086, #192225, #203009, #221785, #231111, #263880 - Read and write XLSB files is now supported.
  • #171164 -Support has been provided for comments in Excel to PDF conversion.
  • #276170 - The Weight property is exposed to get or set chart border width in decimal.
  • #270830 - The RenderBySheet property is exposed to get or set whether the PDF rendering to be done sheet-by-sheet.
  • Exporting Excel data as JSON is now supported.
  • Conversion of HTML tables to Excel worksheets is now supported.

Breaking Changes

  • #79793, #84408, #52130, #127002, #140449, #165919, #187729, #192039, #211086, #192225, #203009, #221785, #231111, #263880 - SaveAsXLSB is added as an enumeration value in ExcelSaveType to save the workbook into XLSB format.
  • #276170 - The Weight property in IChartBorder interface gets or sets the border line weight as number.
  • #278057 - The IsFormula property in IChartDataLabels interface and IChartTextArea interface gets or sets a value indicating whether this instance is a formula.
  • #270830 - The RenderBySheet property in ExcelToPdfConverterSettings class gets or sets a boolean value to indicate whether the PDF rendering to be done sheet-by-sheet or not.
  • #273273 - The Calculate() method of IWorksheet interface is now available in Portable to calculate all the formulas in a worksheet.
  • The ImportHtmlTable(String,Int32,Int32) method in IWorksheet interface and WorksheetImpl class imports HTML table of a HTML file into worksheet from the specified row and column.
  • The ImportHtmlTable(Stream,Int32,Int32) method in IWorksheet interface and WorksheetImpl class imports HTML table of a file stream into worksheet from the specified row and column.
  • The SaveAsJson(String) method in IWorkbook interface and WorkbookImpl class saves the workbook to a JSON file.
  • The SaveAsJson(String,Boolean) method in IWorkbook interface and WorkbookImpl class saves the workbook to a JSON file as schema.
  • The SaveAsJson(String,IRange) method in IWorkbook interface and WorkbookImpl class saves the worksheet to a JSON file.
  • The SaveAsJson(String,IRange,Boolean) method in IWorkbook interface and WorkbookImpl class saves the worksheet to a JSON file as schema.
  • The SaveAsJson(String,IWorksheet) method in IWorkbook interface and WorkbookImpl class saves the range to a JSON file.
  • The SaveAsJson(String,IWorksheet,Boolean) method in IWorkbook interface and WorkbookImpl class saves the range to a JSON file as schema.
  • The SaveAsJson(Stream) method in IWorkbook interface and WorkbookImpl class saves the workbook to a JSON file stream.
  • The SaveAsJson(Stream,Boolean) method in IWorkbook interface and WorkbookImpl class saves the workbook to a JSON file stream as schema.
  • The SaveAsJson(Stream,IRange) method in IWorkbook interface and WorkbookImpl class saves the worksheet to a JSON file stream.
  • The SaveAsJson(Stream,IRange,Boolean) method in IWorkbook interface and WorkbookImpl class saves the worksheet to a JSON file stream as schema.
  • The SaveAsJson(Stream,IWorksheet) method in IWorkbook interface and WorkbookImpl class saves the range to a JSON file stream.
  • The SaveAsJson(Stream,IWorksheet,Boolean) method in IWorkbook interface and WorkbookImpl class saves the range to a JSON file stream as schema.

Bug Fixes

  • #269069, #269181 - Named range index is now updated properly in ArrayFormula while copying two different worksheets.
  • #271034, #276058 - The ImportDataTable() method with preserve type is now working properly for decimal values in German culture.
  • #269362 - Exception will no longer be thrown on applying fill color to group shapes with chart.
  • #273596 - Exception is no longer thrown while opening Excel files with invalid named range.
  • #272551 - Excel file is no longer corrupted on re-saving the document with pivot table.
  • #264179 - Table location and cell values are now updated properly when refreshing a table.
  • #273303 - Exception is no longer thrown while applying borders to specific cells.
  • #267912 - Text in Textbox is now rendered properly in Excel-to-PDF conversion.
  • #267767 - Exception is no longer thrown while parsing Excel documents with chart.
  • #270176 - Exception is no longer thrown while setting invalid HTML string to a cell.
  • #264179 - Tables and its formatting are preserved in proper location after refreshing tables in Microsoft Excel.
  • #272331 - AutoFilter is now applied properly if the row above the filter range is merged.
  • #274309 - Exception is no longer thrown in Excel-to-HTML conversion with entire row merged.
  • #274125 - Timeout exception is no longer thrown while refreshing Excel tables.
  • #269448 - Sorting grand total column in pivot table is now correct.
  • #271999 - Performance is improved on rendering RTF text in Excel-to-PDF conversion.
  • #273303 - Exception is no longer thrown while applying border to specific cells.
  • #276286 - Number Format is no longer missed in whole column while re-saving an Excel file.
  • #274992 - Conditional formatting with relative formula is now applied properly in Excel-to-PDF conversion.
  • #275640 - Import from nested collections with class object is now working proper.
  • #278057 - Exception is no longer thrown while setting conditional formula in non-English cultures.
  • #275498 - Cell text is now proper in PDF when setting formula value using XlsIO.
  • #278259 - Setting a font to individual data label font is now proper.
  • #278644 - Data validation in alternative content is no longer missed in the output document while re-saving.
  • #278469 - Data table formula is now preserved on re-saving an Excel document.
  • #278601 - Column width is now working properly for Unicode text while applying autofit columns in Portable.
  • #F152563 - Performance is improved when data validation is applied to more number of rows and columns.
  • #F153527 - Exception is no longer thrown while creating ListObjects in Excel file that is already saved using XlsIO.
  • #F154230 - Chart title and data label text can now be set with a formula.
  • Issue with pivot table in-line formatting is fixed.
  • Textbox and autoshape fill color is now preserved properly while applying fill color to group shape.