Lambrary 0.2.0-beta.10
======================

IntelliSense for the named LAMBDA functions you write in Excel -
parameter hints, descriptions, autocomplete, and a tool to browse
and document your LAMBDAs.

This is a closed beta. Please don't redistribute this file.


What's new in 0.2.0-beta.10
---------------------------
  - Rename or delete a LAMBDA from inside Lambrary. Right-click a
    function in Browse, or use the buttons in its detail view. Renaming
    carries its documentation to the new name (Excel updates every
    formula that calls it); deleting removes the function and its
    documentation together, warning you first if other functions call it.
  - Documentation follows a renamed LAMBDA. If you rename a function in
    Excel's Name Manager, Lambrary re-attaches its documentation to the
    new name automatically the next time it scans the workbook. Anything
    it can't match automatically (e.g. docs written before this version)
    is offered for you to re-assign or remove.


What's new in 0.2.0-beta.9
--------------------------
  - Share a LAMBDA with a link. In Browse (or a LAMBDA's detail view),
    click Share to get a lambrary.com link that carries the function,
    its documentation, and any helper LAMBDAs it uses. The link is a
    readable documentation page on its own and works for 30 days.
    Sharing uploads the selected LAMBDA(s) to lambrary.com so others can
    import them; nothing else is sent.
  - Import from a link. A new "Import from link" button on the Lambrary
    tab brings a shared library into your workbook - you confirm first,
    nothing existing is overwritten without asking, and the imported
    function opens for review.
  - A Help button on the Lambrary tab opens a short guide without
    leaving Excel, with a link to the full illustrated guide online.
  - Export Docs now offers two formats - HTML (to read) and Lambrary
    library (JSON) (to re-import). The Markdown option was removed.
  - Stability fixes from a code review of the parts that touch Excel
    most directly: a couple of rare crashes around the IntelliSense
    overlays and the autocomplete watcher, and a small memory leak.
  - The Browse Description column now stretches to fill the window, and
    the Verbose Logging button has an icon.


What's new in 0.2.0-beta.8
--------------------------
  - Lambrary can now update itself. It checks the website about once a
    day for a newer build; when one exists, an Update button appears on
    the Lambrary tab. It downloads the new version, verifies it, and
    swaps it in the next time you start Excel. A short "What's new"
    summary appears after an update. This is the only feature that makes
    a network call - turn it off any time with the Check for Updates
    toggle.
  - The value list now filters as you type. Start typing a value and the
    list narrows to matching entries; pressing Tab or Enter (or clicking)
    replaces what you typed instead of adding to it - so typing "sp" and
    choosing "spread" gives "spread", not "spspread".
  - Closing a Lambrary window with Escape now returns you to the window
    underneath it (the values dialog back to the lambda editor, the
    editor back to Browse) instead of jumping to the worksheet. Focus
    returns to Excel only when the last Lambrary window closes.
  - Fix: an unexpected internal error is now recorded in the diagnostic
    log instead of failing silently, so problems are easier to diagnose.


What's new in 0.2.0-beta.7
--------------------------
  - Import Library checks the file first: a report lists anything that
    will be skipped or lose detail, and a "Copy report for your AI"
    button gives you a correction request to paste back to the
    assistant that produced the file.
  - After a JSON export, Lambrary offers to copy an AI documentation
    prompt plus the exported file to the clipboard - one paste into
    any AI assistant.
  - The Browse window closes with Escape.
  - Fix: Export Docs works for workbooks stored on OneDrive/SharePoint.
    Previously it failed with "You can't open this location" because the
    save dialog tried to open the cloud URL as a folder.
  - Fix: Import Library accepts JSON wrapped in markdown code fences,
    the way AI assistants typically return it. Unreadable files now get
    an error naming the exact line and column of the JSON problem.
  - Fix: importing an AI-generated library no longer errors when a
    parameter is missing its name.
  - Fix: the "unsaved changes" indicator in the lambda detail window
    showed garbled characters.


What's new in 0.2.0-beta.6
--------------------------
  - Share your LAMBDA library as a file. Export Docs now offers a
    "Lambrary library (JSON)" format that carries the formulas too, and
    the new Import Library button (Lambrary tab) reads one back into any
    workbook - pick the LAMBDAs you want, dependencies come along
    automatically, and nothing is overwritten without asking.
  - Fix: the likely root cause of a crash that could close Excel
    instantly while typing a formula. The error reporting was also
    hardened so any future crash records its cause in the diagnostic log.
  - In the documentation grids, a row now grows while you type or paste
    a multi-line entry (including when you press Enter for a new line),
    instead of only after leaving the cell.
  - The key that shows/hides the parameter description while you edit a
    formula is now configurable (Lambrary tab -> Settings -> Toggle key).
    F1 stays the default.


What's new in 0.2.0-beta.5
--------------------------
  - Fix: Lambrary no longer crashes Excel if it hits an unexpected error
    while reading a formula - the error is caught and logged instead.
  - High-DPI displays: every Lambrary window and tooltip now renders
    crisply at Windows display scaling above 100% (e.g. 150% or 200%).
    Previously much of the UI was undersized or clipped at higher scales.
  - The Browse window drops the separate documentation URL column.
    Ctrl+click a LAMBDA's name to open its documentation, as before.


What's new in 0.2.0-beta.4
--------------------------
  Fixes for using Lambrary with more than one workbook open - especially
  when the same LAMBDA name exists in several of them.
  - IntelliSense now follows the workbook you're working in, so a LAMBDA
    with the same name in another open workbook no longer shadows it or
    shows the wrong description.
  - Function descriptions show reliably as you arrow up and down the
    autocomplete list - including in a second workbook and after
    importing LAMBDAs.
  - Choosing a parameter's value list with a second workbook open no
    longer jumps you back to the first workbook.


What's new in 0.2.0-beta.3
--------------------------
  - Import LAMBDAs (and their documentation) from another open
    workbook or add-in: Lambrary tab -> Browse LAMBDAs -> Import...
  - Documentation written in the Advanced Formula Environment (AFE)
    is now imported automatically when a workbook opens.
  - Add a documentation URL to a LAMBDA, then Ctrl+click its name in
    the Browse window to open it.
  - Fix: the version shown in About and the diagnostic log.


What's in this zip
------------------
  Lambrary64.xll   The add-in (64-bit Excel). One self-contained file.
  README.txt       This file.


Requirements
------------
  - Windows 10 or 11 (not Mac, Web, or mobile Excel).
  - 64-bit Excel with LAMBDA support: Microsoft 365 or Excel 2024.
    Excel 2019 / 2021 don't have LAMBDA. On 32-bit Excel? Email me.


Install (about two minutes)
---------------------------
  1. If you haven't already: right-click the ZIP you downloaded ->
     Properties -> tick "Unblock" -> OK, THEN extract. Unblocking the
     zip first means the .xll comes out ready to load.

  2. Open Excel -> File -> Options -> Add-ins.

  3. At the bottom: Manage: Excel Add-ins -> Go...

  4. Browse... -> select Lambrary64.xll -> OK. Make sure it's ticked.

  5. OK. A "Lambrary" tab appears in the ribbon.

  Lambrary isn't code-signed, so Excel or Windows may warn about an
  unverified publisher. That's expected for the beta - choose
  "Run anyway" / "Trust".


First test
----------
  1. Formulas -> Name Manager -> New. Name: Test.
     Refers to: =LAMBDA(x, x*2). OK.
  2. In a cell, type  =Test(  and pause - a hint shows the parameter x.
  3. Lambrary tab -> Browse LAMBDAs to see and document your LAMBDAs.


Reporting bugs
--------------
Email support@lambrary.com with:
  - what you were doing when it broke,
  - your Excel version (File -> Account -> About Excel),
  - the Lambrary version (Lambrary tab -> About),
  - and the diagnostic log: Lambrary tab -> Diagnostics ->
    Open Log Folder, then attach the file.

The log records only what Lambrary did - counts and structural
flags, never your formulas, names, or data.

Thanks for testing.
- Jeremy
