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.