Skip to main content

UnaXL v20260731 (Release)

ยท 3 min read

This release adds custom filters and consolidated save confirmations, helps the add-in remember your sign-in and tenant state, reduces screen flicker during data writes, and resolves several filter, grid, and named-range issues.


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

Filters & Save Experienceโ€‹

  • Custom Filters โ€” Added support for custom filters built from dimension queries, giving users more flexibility when defining filter sets.
  • Consolidated Save Confirmations โ€” Saving now shows one combined "data saved" message and one combined SQL trigger message instead of a separate popup per matrix query. Added English, French, and Romanian translations.

Sign-In & Tenant Experienceโ€‹

  • Ribbon Reflects Sign-In State โ€” Ribbon buttons (Get Data, Send Data, Hide/Show Row, Hide/Show Column, etc.) now disable automatically when signed out, making it clear when data actions aren't available. "Show Task Pane" always stays enabled so users can sign in.
  • Remembers Your Tenant โ€” The add-in now remembers your last-used tenant per workbook, with a device-level fallback, so you don't need to reselect it every session.
  • Auto-Refresh Toggle โ€” A new ribbon toggle automatically refreshes data after Send Data completes, optionally including after related SQL triggers finish.

Performance & Architectureโ€‹

  • Reduced screen and named-range flickering during data writes by consolidating Excel sync operations into fewer batch calls.

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

Filtersโ€‹

  • Dimension Query Filters Now Selectable โ€” Fixed an issue where filters created from a Dimension Query didn't appear in the Model Query Editor's Add Member list, so they couldn't be inserted into a grid query.
  • Cleaner Filter & Grid Deletion โ€” Deleting a filter or grid no longer leaves behind orphaned named ranges or stale formatting. Adding a second filter to an already-filtered cell now shows a warning instead of silently overwriting the first.

Grids & Named Rangesโ€‹

  • New Worksheet Grids Now Appear โ€” Fixed an issue where a grid created on a newly added worksheet didn't show up in the "Grids on this sheet" panel.
  • Named Ranges Resize Correctly โ€” Editing a grid to return more or fewer rows now resizes its named range to match, instead of leaving it stuck at the old size.
  • Accurate Get/Send Data Messages โ€” Toasts now describe what actually happened (for example, "no grid found" or "saving is disabled for this grid") instead of generic success/failure messages.
  • Reliable Named Range Tracking โ€” Named ranges are now tracked by a stored ID rather than by name, so renaming or moving a range no longer breaks filter or grid refresh.
  • Add Row/Column Fix โ€” Fixed newly added rows or columns not displaying when the "Include Empty" option is disabled on a grid.

Sign-In & Sessionsโ€‹

  • Fixed Immediate Sign-Out After Login โ€” Resolved an issue where some customers were signed out immediately after signing in, caused by overlapping session-expiry checks firing false logouts.

Add-inโ€‹

  • Reduced Exposed URL from Dialogs โ€” Dialog title bars no longer display the full query string, including the access token, improving privacy and security.
  • Text Measures Save Correctly โ€” Fixed text-type measures (such as v_notes) not saving when data was added via drag-and-drop or pasted JSON.

Maintenanceโ€‹

  • Bumped the Office Add-in manifest version to 1.0.0.4 so previously merged manifest changes are picked up by cached Excel clients.