Release notes for MBS Xojo XL Plugin

These are changed in the plugin part. Please also check changes for LibXL.

26.0 - 13rd January 2026

  • Added SetPassword method for XLBookMBS class to read encrypted Excel workbooks.
  • Updated LibXL to version 5.0.1.

25.5 - 18th November 2025

  • Updated to Xcode 26.0.

25.2 - 6th May 2025

  • Added AddTable, ApplyFilter, SetBorder, TableByIndex and TableByName methods to XLSheetMBS class.
  • Added XLTableMBS class.
  • Updated LibXL to version 4.6.
  • Updated to Xcode 16.3 with the newer clang and stdc++ library.

25.1 - 11th March 2025

  • Changed SetLicenseKey in XLBookMBS class to raise exception if you pass invalid license, e.g. Windows license on macOS, instead of ignoring it.

25.0 - 14th January 2025

  • Added RemoveAllPhonetics and CoreProperties methods to XLBookMBS class.
  • Added RowFormat and ColFormat functions to XLSheetMBS class.
  • Added XLCorePropertiesMBS class.
  • Improved XL.Initialize to log the version of LibXL loaded in the trace log.
  • Updated LibXL to version 4.5.0.
  • Updated to Xcode 16.2.

24.5 - 12th November 2024

  • Updated to Xcode 16.0.

24.4 - 17th September 2024

  • Fixed a crash in AddConditionalFormatting method in XLSheetMBS class.
  • Fixed a crash in WriteStyledText method in XLSheetMBS class.
  • Updated LibXL to version 4.4.0.
  • Updated XL plugin for Linux 32-bit to use version 4.3 of LibXL.
  • Upgraded all linux compilers to newer versions. Requires GLIBCXX_3.4.26 now for Scintilla.

24.3 - 9th July 2024

  • Fixed a problem with XLBookMBS when using conditional formatting.
  • Updated plugin SDK for Xojo 2024r2.
  • Updated to Xcode 15.4.

24.2 - 14th May 2024

24.1 - 12th March 2024

  • Improved documentation to better list constants. More in table views now.
  • Improved linking of linux libraries to do more stripping of unused code to save 33 MB in total.

24.0 - 16th January 2024

  • Updated to Xcode 15.2.
  • Updated Visual Studio to version 2022.
  • Improvements for Xojo 2023r4.

23.5 - 7th November 2023

  • Enabled fortified source checks for libc on Linux.
  • Updated to Xcode 15.0.

23.4 - 12th September 2023

  • Updated Plugin SDK to version 2023r2.

23.3 - 18th July 2023

  • Added AddFormatFromStyle method for XLBookMBS class.
  • Added Table, SetRowPx and SetColPx methods for XLSheetMBS class.
  • Updated LibXL to version 4.2.

23.2 - 9th May 2023

  • Added HyperlinkIndex function to XLSheetMBS class.
  • Updated LibXL to version 4.1.2.

23.1 - 7th March 2023

  • Updated LibXL to version 4.1.
  • Added AddSelectionRange, GetActiveCell, GetTabRgbColor, RemoveSelection, SelectionRange and SetActiveCell to XLSheetMBS class.
  • Added IsWriteProtected method to XLBookMBS class.
  • Added TabColor, DefaultRowHeight and GetTabRgbColor method to XLSheetMBS class.
  • Updated XL Plugin to include library for Windows 64-bit ARM.
  • Removed 32-bit plugin parts for macOS. We now require Xojo 2017r3 or newer to load plugins on macOS.

23.0 - 17th January 2023

  • Added missing return value for AddIgnoredError function in XLSheetMBS class.

22.3 - 12th July 2022

  • Updated LibXL to version 4.0.3.

22.1 - 15th March 2022

  • Updated Xcode to version 13.2.1.

22.0 - 18th January 2022

  • Updated LibXL to version 4.0.1.

21.5 - 16th November 2021

  • Added XLFormControlMBS class and related methods.
  • Added AddSort method to XLAutoFilterMBS class.
  • Added IsAutoFilter function to XLSheetMBS class.
  • Updated LibXL to version 4.0.
  • Updated plugin SDK for Xojo 2021r3.
  • Updated Xcode to version 13.1.

21.3 - 12th July 2021

  • Updated Xcode to version 12.5.1.

21.2 - 18th May 2021

21.1 - 9th March 2021

  • Improved text conversion performance internally for getting text as UTF16 or UTF32. This is used in all plugin parts and speeds up XLSheetMBS and DynaPDFMBS classes a lot!
  • Updated LibXL to version 3.9.4.
  • Updated to Xcode 12.4.

21.0 - 19th January 2021

  • Added plugins for iOS and Apple Silicon.
  • Updated to Xcode 12.3.

20.5 - 17th November 2020

  • Added CopyColumn method for XLSheetMBS class.
  • Added ReadValue method to XLSheetMBS class.
  • Updated LibXL to version 3.9.2.
  • Reduced usage of deprecated SDK functions.
  • Updated to newer plugin SDK.

20.4 - 15th September 2020

  • Updated to Xcode 10.6.
  • Upgraded Visual Studio from 2008 to 2019 and rebuild everything. See blog post.

20.3 - 21st July 2020

  • Added FirstFilledCol, FirstFilledRow, LastFilledCol and LastFilledRow properties to XLSheetMBS class.
  • Added templateFont parameter for AddFont method in XLRichStringMBS class.
  • Added WriteStringAsNumber method to XLSheetMBS class.
  • Updated LibXL to version 3.9.1.
  • All MBS Xojo Plugins compile for Apple Silicon, so we are ready.
  • Upgraded examples to use 64-bit targets. This was made automatically to enable 64-bit targets, HiDPI and dark mode for all projects. Thanks to Arbed!

20.2 - 12th May 2020

  • Added StyledText functions for XL Plugin.
  • Added XLRichStringMBS class to work on rich text in Excel documents.
  • Updated LibXL to version 3.9.
  • Updated plugin SDK to version for Xojo 2020r1

20.1 - 10th March 2020

  • Fixed a problem with returning dates in Xojo which affects XLBookMBS.UnpackDate function and others.
  • Checked plugins for Windows XP compatibility. All load except the built-in CubeSQL library.

20.0 - 14th January 2020

  • Added ColWidthPx and RowHeightPx to XLSheetMBS class.
  • Updated LibXL to version 3.8.8.
  • Updated Xcode to version 11.3.
The biggest plugin in space...