Lambda Boss 0.1.3

Lambda Boss 0.1.3

Bug Fixes

• LET to LAMBDA editor no longer crashes on installed builds — the 0.1.2 installer was missing GongSolutions.WPF.DragDrop.dll, so opening the editor threw a FileNotFoundException. The DLL is now shipped alongside the other managed assemblies (#108).

Requirements

• 64-bit Excel (Microsoft 365 or Excel 2019+)
• Windows 10/11
• .NET 6 Desktop Runtime (bundled in installer)

Installation

Download and run LambdaBoss-0.1.3-Setup.exe. The installer will:

• Install to %LOCALAPPDATA%\LambdaBoss
• Install .NET 6 Desktop Runtime if needed
• Register the add-in with Excel automatically

Lambda Boss 0.1.2

Lambda Boss 0.1.2

What's New

• Edit Lambda command — new ribbon button that expands a =MyLambda(args...) call in the active cell back into an equivalent =LET(...), so you can tweak a registered LAMBDA and re-save it via LET to LAMBDA (#99, #105).
• Commands mode in the popup — type / in the Lambda picker to fuzzy-search actions (LET to LAMBDA, Edit Lambda, Load Library, Settings) and run them with Enter (#100).
• LET to LAMBDA authoring improvements:
  • Reorder input parameters with up/down buttons, a drag handle, or Alt+Up / Alt+Down (#97, #102).
  • Mark inputs as Optional — the generated LAMBDA wraps them with IF(ISOMITTED(param), <default>, param) so callers can omit the argument (#98).
  • Ctrl+Enter saves and Esc cancels in the editor (#102).
  • Cell references in excluded inputs and optional defaults are absolutised, so registered Names work correctly when invoked from cells other than the original source (#105).
• New NTH lambda — NTH(arr, n) returns the Nth element of a flattened array as a scalar, with negative n counting from the end. Pairs well with REGEXEXTRACT, TEXTSPLIT, FILTER, and UNIQUE (#90).

Requirements

• 64-bit Excel (Microsoft 365 or Excel 2019+)
• Windows 10/11
• .NET 6 Desktop Runtime (bundled in installer)

Installation

Download and run LambdaBoss-0.1.2-Setup.exe. The installer will:

• Install to %LOCALAPPDATA%\LambdaBoss
• Install .NET 6 Desktop Runtime if needed
• Register the add-in with Excel automatically

Lambda Boss 0.1.1

Lambda Boss 0.1.1

First public release — an Excel add-in for browsing, loading, and authoring reusable LAMBDA functions sourced from GitHub.

What's New

Library browser

• Load Library ribbon button opens a floating, searchable browser of available LAMBDAs.
• Fuzzy subsequence search ranks matches as you type — e.g. revarr finds REVERSEARRAY.
• LAMBDA descriptions are surfaced inline in the search results so you can scan what each one does without clicking in.
• Loaded LAMBDAs are installed as workbook-scoped defined names via the Excel Name Manager, so they're ready to use as soon as you dismiss the popup.

Library sources

• GitHub source — point at any repo containing a lambdas/ tree of .lambda files and _library.yaml manifests.
• Local directory source — ideal for developing and testing your own LAMBDAs before pushing.
• Source caching — repos are cached locally so the browser opens fast after the first load; Refresh re-fetches on demand.
• Per-library prefix rewriting so you can pull array.REVERSEARRAY into myprefix.REVERSEARRAY without clashing with other libraries.

LET to LAMBDA converter

• LET to LAMBDA ribbon button converts the active cell's =LET(...) formula into a workbook-scoped LAMBDA definition, extracting parameters and registering it in the Name Manager.

Bundled LAMBDA library

25 LAMBDAs across four categories, with full test coverage:

• Array (11) — BICOL, BIROW, CONTAINS, CUMSUMGRID, EXPANDDIMENSIONS, MAXOCCUR, MAXOF, MINOCCUR, MINOF, NTHOCCURRENCE, REVERSEARRAY
• Maps (9) — ARROWMOVES, CELLTOPOS, DEFAULTARROWS, DEFAULTMOVEDELTAS, GRIDAREA, GRIDLOOKUP, KNIGHTDELTAS, MOVECELL, POSTOCELL
• String (4) — CHARQ, CONSECGROUPS, EXPLODE, REVERSESTRING
• Math (1) — CIRCPOS

Every LAMBDA is self-documenting: call it with no arguments (or use ISOMITTED-driven help mode) to get a built-in usage reference directly in the grid.

Settings & updates

• Settings ribbon panel for managing repository sources and preferences.
• Built-in update checker — the ribbon surfaces an Update Available button when a newer release is published on GitHub.

Requirements

• 64-bit Excel (Microsoft 365 or Excel 2019+)
• Windows 10/11
• .NET 6 Desktop Runtime (bundled in installer)

Installation

Download and run LambdaBoss-0.1.1-Setup.exe. The installer will:

• Install to %LOCALAPPDATA%\LambdaBoss
• Install .NET 6 Desktop Runtime if needed
• Register the add-in with Excel automatically