open-webui/functions

Fork 0

mirror of https://github.com/open-webui/functions.git synced 2026-11-05 01:38:16 +00:00

[PR #15] Add Bilig WorkPaper formula readback tool #15

New issue

Open

opened 2026-10-18 14:07:32 +00:00 by bsakaguchi · 0 comments

bsakaguchi commented

2026-10-18 14:07:32 +00:00

Owner

📋 Pull Request Information

Original PR: https://github.com/open-webui/functions/pull/15
Author: @gregkonush
Created: 5/24/2026
Status: 🔄 Open

Base: main ← Head: codex/bilig-workpaper-action

📝 Commits (1)

ae4927e feat: add Bilig WorkPaper formula readback tool

📊 Changes

2 files changed (+204 additions, -0 deletions)

View changed files

➕ functions/tools/bilig_workpaper_formula_readback/README.md (+57 -0)
➕ functions/tools/bilig_workpaper_formula_readback/main.py (+147 -0)

📄 Description

Summary

Add an Open WebUI Tools implementation for Bilig WorkPaper formula readback.
Include a short README with install steps, default endpoint, and a sample prompt.
Keep the tool dependency-light: Python stdlib HTTP plus Pydantic valves.

Why

This gives Open WebUI users a small spreadsheet-backed calculation tool: write one input cell, recalculate formulas through a Bilig WorkPaper endpoint, and return verified JSON readback. The default endpoint uses the public Bilig forecast demo, and valves let admins point it at their own Bilig service.

Bilig also has a first-party Open WebUI setup page for the broader agent path, including native Streamable HTTP MCP and mcpo bridge options:
https://proompteng.github.io/bilig/open-webui-workpaper-mcp.html

Validation

python3 -m py_compile functions/tools/bilig_workpaper_formula_readback/main.py
git diff --check -- functions/tools/bilig_workpaper_formula_readback
rg -n "bilig|Bilig|WorkPaper" functions/tools/bilig_workpaper_formula_readback -S
npm view @bilig/workpaper version
npm exec --yes --package @bilig/workpaper@latest -- bilig-evaluate --door agent-mcp --json

npm view @bilig/workpaper version returned 0.154.0.

The current public Bilig evaluator returned verified: true with package versions @bilig/workpaper@0.154.0 and xlsx-formula-recalc@0.154.0. It verifies tool discovery, Inputs!B3 mutation, formula readback 60000 -> 96000, JSON persistence, restored readback, and restart readback.

Original local smoke against the Open WebUI tool endpoint path also returned verified=true, editedCell=Inputs!B3, and after.expectedArr=120000 after setting Inputs!B3 to 0.5.

_{🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.}

## 📋 Pull Request Information **Original PR:** https://github.com/open-webui/functions/pull/15 **Author:** [@gregkonush](https://github.com/gregkonush) **Created:** 5/24/2026 **Status:** 🔄 Open **Base:** `main` ← **Head:** `codex/bilig-workpaper-action` --- ### 📝 Commits (1) - [`ae4927e`](https://github.com/open-webui/functions/commit/ae4927eebc84d3fb2af4e55bdb1f714ba5d5f6ec) feat: add Bilig WorkPaper formula readback tool ### 📊 Changes **2 files changed** (+204 additions, -0 deletions) <details> <summary>View changed files</summary> ➕ `functions/tools/bilig_workpaper_formula_readback/README.md` (+57 -0) ➕ `functions/tools/bilig_workpaper_formula_readback/main.py` (+147 -0) </details> ### 📄 Description ## Summary - Add an Open WebUI `Tools` implementation for Bilig WorkPaper formula readback. - Include a short README with install steps, default endpoint, and a sample prompt. - Keep the tool dependency-light: Python stdlib HTTP plus Pydantic valves. ## Why This gives Open WebUI users a small spreadsheet-backed calculation tool: write one input cell, recalculate formulas through a Bilig WorkPaper endpoint, and return verified JSON readback. The default endpoint uses the public Bilig forecast demo, and valves let admins point it at their own Bilig service. Bilig also has a first-party Open WebUI setup page for the broader agent path, including native Streamable HTTP MCP and `mcpo` bridge options: https://proompteng.github.io/bilig/open-webui-workpaper-mcp.html ## Validation ```bash python3 -m py_compile functions/tools/bilig_workpaper_formula_readback/main.py git diff --check -- functions/tools/bilig_workpaper_formula_readback rg -n "bilig|Bilig|WorkPaper" functions/tools/bilig_workpaper_formula_readback -S npm view @bilig/workpaper version npm exec --yes --package @bilig/workpaper@latest -- bilig-evaluate --door agent-mcp --json ``` `npm view @bilig/workpaper version` returned `0.154.0`. The current public Bilig evaluator returned `verified: true` with package versions `@bilig/workpaper@0.154.0` and `xlsx-formula-recalc@0.154.0`. It verifies tool discovery, `Inputs!B3` mutation, formula readback `60000 -> 96000`, JSON persistence, restored readback, and restart readback. Original local smoke against the Open WebUI tool endpoint path also returned `verified=true`, `editedCell=Inputs!B3`, and `after.expectedArr=120000` after setting `Inputs!B3` to `0.5`. --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>

bsakaguchi added the

pull-request

label

2026-10-18 14:07:32 +00:00

No labels

pull-request

No milestone

No project

No assignees

1 participant

Notifications

Due date

The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference

open-webui/functions#15

No description provided.

Rows
Columns