vp-get-formulas

vp-get-formulas is a command for coding agents from Ganbin/4d-development-skill. It costs 0 tokens per session (418 once invoked), scanned C, original, MIT.

A spreadsheet command that retrieves formulas from a selected range in a 4D View Pro area. It returns the formulas arranged by row and cell.

In plain words
What is it for?
Use it to collect formulas from a range, including formulas across multiple rows and columns.
Why use it?
It lets code inspect the calculations stored in cells instead of reading only their displayed results.

Command

Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

agentmods
npx agentmods add commands/ganbin/4d-development-skill/vp-get-formulas
Clone the repo
git clone --depth 1 https://github.com/Ganbin/4d-development-skill

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for vp-get-formulas

README.md
[![agentmods](https://agentmods.dev/badge/commands/ganbin/4d-development-skill/vp-get-formulas.svg)](https://agentmods.dev/commands/ganbin/4d-development-skill/vp-get-formulas)
Your own site
<a href="https://agentmods.dev/commands/ganbin/4d-development-skill/vp-get-formulas"><img src="https://agentmods.dev/badge/commands/ganbin/4d-development-skill/vp-get-formulas.svg" alt="Measured on agentmods" height="20"></a>
Per session 0 Only the description is in the session, so the agent can decide to use it. The body loads when it is invoked.
When invoked 418 The whole file, excluding the scripts and references it only reads on demand.
Security scan C 1 finding. Scan, not verified.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5 $0.00000 $0.00418
Opus 5 $0.00000 $0.00209
Sonnet 5 $0.00000 $0.00084
Haiku 4.5 $0.00000 $0.00042

Measured 3d ago against content hash bf7729df2329, method: parsed. Prices are Anthropic first-party input rates as of 2026-08-30, from the pricing page.

Security

Grade C, and why

vp-get-formulas scanned grade C with 1 finding against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 3d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Hidden instructionshighPrompt injection

Directives inside HTML comments, invisible characters or bidirectional overrides are read by the model and not by the person reviewing the file.

<!-- REF #_method_.VP Get formulas.Syntax -->
docs/ViewPro/commands/vp-get-formulas.md · 48 lines

What it actually says

VP Get formulas ( rangeObj : Object ) : Collection

Parameter Type Description
rangeObj Object -> Range object
Result Collection <- Collection of formula values

Description

The VP Get formulas command retrieves the formulas from a designated rangeObj.

In rangeObj, pass a range whose formulas you want to retrieve. If rangeObj designates multiple ranges, the formula of the first range is returned. If rangeObj does not contain any formulas, the command returns an empty string.

The returned collection is two-dimensional:

  • The first-level collection contains subcollections of formulas. Each subcollection reprensents a row.
  • Each subcollection defines cell values for the row. Values are text elements containing the cell formulas.

Example

You want to retrieve the formulas in the Sum and Average columns from this document:

You can use this code:

$formulas:=VP Get formulas(VP Cells("ViewProArea";5;1;2;3))
//$formulas[0]=[Sum(B2:D2),Average(B2:D2)]
//$formulas[1]=[Sum(B3:D3),Average(B3:D3)]
//$formulas[2]=[Sum(B4:D4),Average(C4:D4)]

See also

VP Get formula VP Get values VP SET FORMULAS VP SET VALUES

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 3d ago First seen · 48 lines · 0 tokens per session scan C bf7729df2329

Subscribe to this mod's changes

vp-get-formulas is a command published in the GitHub repository Ganbin/4d-development-skill (9 stars, last pushed 6mo ago), licensed MIT. It costs nothing until one of its globs matches a file; then it loads 418 tokens. A static security scan graded it C with 1 finding (hidden instructions). No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-31.