Skip to main content

UnaXL v20260717 (Release)

ยท 2 min read

This release brings Get Data and Send Data directly into the UnaXL ribbon, improves workbook performance through consolidated data storage, and resolves several filter and embedded webview issues.


New Features & Major Enhancements ๐Ÿš€โ€‹

Architectureโ€‹

  • Workbook settings are now stored holistically and loaded into memory at startup, reducing the number of Excel refreshes required during a session and improving load performance on an ongoing basis.
  • The add-in has been structurally reworked to avoid mutating unrelated interacting elements, which was previously triggering excessive Excel refreshes and causing instability.

Get Data & Send Dataโ€‹

  • Ribbon Access โ€” Get Data and Send Data are now available directly from the UnaXL ribbon, making it faster to pull and push data without navigating through menus.
  • SQL Script Triggering โ€” Send Data can now trigger SQL scripts automatically, allowing custom logic to run as part of the data write-back process.
  • Full Workbook Refresh โ€” Get Data now refreshes the entire workbook in a single action, rather than requiring each sheet to be updated individually.
  • Formula Protection โ€” Get Data no longer overwrites cells that contain formulas, protecting custom calculations built on top of retrieved data.

Performanceโ€‹

  • Improved workbook performance by consolidating hidden-sheet storage and reducing the number of sync round-trips required during data operations.
  • Legacy tenant sheet storage has been migrated to a new consolidated format, laying the groundwork for continued performance improvements to the Excel Add-in.

Fixes & Improvements ๐Ÿ› ๏ธโ€‹

Filtersโ€‹

  • Filter Trigger Removed โ€” Triggering updates on changing filters was causing issues when multiple filters were used and doing unnecessary screen refreshes.
  • Filter Toggle Fix โ€” Fixed an issue where toggling filters on and off did not behave as expected.

Add-inโ€‹

  • Column Formatting โ€” An option to apply formatting based on the first cell in a column is now available and can be enabled in configurations.
  • Webview Interaction Fix โ€” Fixed drag-and-drop and text-selection issues inside embedded Office webviews, along with a related Trigger popup configuration fix.
  • Text Measure Support โ€” v_notes and other text-type measures can now be saved and retrieved, enabling text-based data to be used alongside numeric measures.
  • Manifest Updates โ€” Manifest updates ensure the new Get Data and Send Data ribbon buttons appear reliably across environments.