- Home
- Skills
- Data & Databases
- CalcReceipt — XLSX Formula Cache Verification
CalcReceipt — XLSX Formula Cache Verification
Refresh supported XLSX formula caches and get a source-linked report. Includes a temporary Python client. Free skill; your own separately metered CalcReceipt API access required.
Free
Works with the AI Agents you already use
CalcReceipt — XLSX Formula Cache Verification
Example session with this skill installed
Use the independently obtained, verified CalcReceipt standalone Python client with the original fictional two-sheet sample workbook. Keep the source workbook intact. Make one authorized processing request through RapidAPI using the privately configured subscribed key, save a new workbook and the complete calculation report, and show all ten typed formula-cache results. Identify stale and missing original caches, distinguish literal error-looking text from actual formula errors, report the source/output hashes and preservation findings, and state whether further review is required. Do not correct the intentional error or retry automatically.
- Read your context and instructions
- Compiled the calcreceipt
- Generated the document
Recorded calculation result
On November 1, 2026, the original fictional workbook completed through the earlier published standalone Python client and real RapidAPI gateway (HTTP 200). This records the earlier environment-key client/API workflow. It does not demonstrate the new optional key-file setup or an Agensi-connector invocation, and is not a customer testimonial.
Review required: Results!A6 deliberately returns the typed error #DIV/0!. The service reports it and does not repair the formula. Results!A9 returns ordinary string text #REF!; A5 returns an empty string. Missing original caches are not zero.
Download the complete artifacts: original fictional source, returned workbook, full JSON report, and verification record. Absolute local folder prefixes are omitted; these are the actual recorded artifact bytes at the pinned release commit.
| Artifact | Bytes | SHA-256 |
|---|---|---|
| Source XLSX | 1822 | cb48733830a433ec3c03b9081d42ded6efb40fc73d38fa43767a7dd2f69262d4 |
| Returned XLSX | 1861 | 884c3964028fcca52856865c3617e9694f77d3b32c4a6688ec1c3c2ea5c76ebf |
| Complete report | 4871 | c91cc77d9ae43bbc9f865eafaa306985421e4260c4f71d485de4b2530086b478 |
LibreOffice Calc reported 7.4.7.2. All ten caches changed: two stale numeric 999 caches and eight absent caches. All original formulas, nonformula inputs and untouched package members were verified preserved. There are no chart/drawing parts in this small sample. All ten outcomes follow; numeric and Boolean results are lexical strings.
| Cell | Original cache | Calculated kind | Calculated lexical value |
|---|---|---|---|
| Results!A1 | number: "999" | number | "12" |
| Results!A2 | number: "999" | number | "24" |
| Results!A3 | missing | string | "ready" |
| Results!A4 | missing | boolean | "1" |
| Results!A5 | missing | string | "" |
| Results!A6 | missing | error | "#DIV/0!" |
| Results!A7 | missing | number | "46327" |
| Results!A8 | missing | number | "0.3" |
| Results!A9 | missing | string | "#REF!" |
| Results!A10 | missing | string | "café" |
The first response headers arrived in 2.882 seconds; the report records 1.938 seconds of service processing. Three authorized fictional-fixture calls returned HTTP 200 with the free-plan remaining counter at 2, 1 and 0. The fourth attempt received the platform's explicit monthly HTTP 429. No retries, counter reset or paid self-upgrade occurred. This is no evidence of a paid sale, revenue or payout.
The client bytes used in that recorded demonstration were verified against SHA-256 70c97d23369a16ef7acad54f4d4901f8b620c64cdb37d95287264e85d3fbd10d. The first run used source commit 4f681f3c09e3d8b70ea2e9ddbd78a9653a569daf; the release source/artifacts are at 43238b27e46f002344a552416a4fe0d6646fbb93, with unchanged client bytes.
Complete original calculation report
{
"source_sha256": "cb48733830a433ec3c03b9081d42ded6efb40fc73d38fa43767a7dd2f69262d4",
"input_sha256": "cb48733830a433ec3c03b9081d42ded6efb40fc73d38fa43767a7dd2f69262d4",
"input_bytes": 1822,
"expanded_bytes": 2383,
"members": 6,
"worksheets": 2,
"populated_cells": 12,
"formula_cells": 10,
"original_missing_formula_caches": 8,
"unrefreshed_derived_parts": [],
"schema_version": "1.0",
"engine": "LibreOffice Calc",
"engine_version": "7.4.7.2",
"status": "calculated",
"output_sha256": "884c3964028fcca52856865c3617e9694f77d3b32c4a6688ec1c3c2ea5c76ebf",
"output_bytes": 1861,
"source_formulas_sha256": "ca22c8550b0e60544075a6855d1b4443943288214f7228b884d7da499aa25be8",
"formula_text_included": false,
"cache_changes": [
{
"sheet": "Results",
"cell": "A1",
"original_cache": {
"kind": "number",
"value": "999"
},
"calculated_cache": {
"kind": "number",
"value": "12"
},
"cache_changed": true
},
{
"sheet": "Results",
"cell": "A2",
"original_cache": {
"kind": "number",
"value": "999"
},
"calculated_cache": {
"kind": "number",
"value": "24"
},
"cache_changed": true
},
{
"sheet": "Results",
"cell": "A3",
"original_cache": {
"kind": "missing",
"value": null
},
"calculated_cache": {
"kind": "string",
"value": "ready"
},
"cache_changed": true
},
{
"sheet": "Results",
"cell": "A4",
"original_cache": {
"kind": "missing",
"value": null
},
"calculated_cache": {
"kind": "boolean",
"value": "1"
},
"cache_changed": true
},
{
"sheet": "Results",
"cell": "A5",
"original_cache": {
"kind": "missing",
"value": null
},
"calculated_cache": {
"kind": "string",
"value": ""
},
"cache_changed": true
},
{
"sheet": "Results",
"cell": "A6",
"original_cache": {
"kind": "missing",
"value": null
},
"calculated_cache": {
"kind": "error",
"value": "#DIV/0!"
},
"cache_changed": true
},
{
"sheet": "Results",
"cell": "A7",
"original_cache": {
"kind": "missing",
"value": null
},
"calculated_cache": {
"kind": "number",
"value": "46327"
},
"cache_changed": true
},
{
"sheet": "Results",
"cell": "A8",
"original_cache": {
"kind": "missing",
"value": null
},
"calculated_cache": {
"kind": "number",
"value": "0.3"
},
"cache_changed": true
},
{
"sheet": "Results",
"cell": "A9",
"original_cache": {
"kind": "missing",
"value": null
},
"calculated_cache": {
"kind": "string",
"value": "#REF!"
},
"cache_changed": true
},
{
"sheet": "Results",
"cell": "A10",
"original_cache": {
"kind": "missing",
"value": null
},
"calculated_cache": {
"kind": "string",
"value": "caf\u00e9"
},
"cache_changed": true
}
],
"changed_cache_count": 10,
"error_cells": [
{
"sheet": "Results",
"cell": "A6",
"error": "#DIV/0!"
}
],
"review_required": true,
"preservation": {
"original_formulas": true,
"non_formula_cells": true,
"other_package_parts_byte_identical": true
},
"warnings": [
"LibreOffice calculation results are not a guarantee of Microsoft Excel parity or business/financial correctness.",
"Only formula-cell caches were refreshed. Original formulas, other cell values and non-worksheet package parts were preserved.",
"A missing original cache is reported as missing, never converted to zero for comparison.",
"Numeric results are lexical strings from LibreOffice; date results retain the workbook numeric/date-format convention."
],
"elapsed_seconds": 1.938,
"network_boundary": {
"mode": "docker_network_none",
"interface_inventory": [
{
"name": "lo",
"ifindex": 1,
"flags_hex": "0x9",
"up": true,
"loopback": true
},
{
"name": "sit0",
"ifindex": 2,
"flags_hex": "0x80",
"up": false,
"loopback": false
}
],
"non_loopback_interfaces": [
"sit0"
],
"dormant_non_loopback_interfaces": [
"sit0"
],
"active_non_loopback_interfaces": [],
"non_loopback_routes": [],
"outbound_connect": "unreachable",
"ipv4_tcp_probe": "unreachable",
"ipv4_udp_probe": "unreachable",
"uno_local_pipe": "permitted"
}
}
Keep the original source. Review the intentional formula error before delivery; any corrected source needs a separate authorized request. Inspect all warnings and preservation findings. Calculation does not certify Excel parity, intended business logic, financial accuracy or rendered appearance.
sample.xlsx
PDF · document
Example file from a real run - the skill writes it into your workspace.
Connects securely to your tools. The creator never sees your data.
About this skill
Give your agent a supported XLSX and ask it to refresh the stored formula results, keep the original, and return a new workbook plus the calculation report. The agent runs the included Python client and flags errors or findings that need review.
Try this request
“Use CalcReceipt on this workbook. Keep the original, refresh supported formula results, and give me the new XLSX and full report. Flag formula errors and anything that still needs review.”
The agent confirms the selected workbook and authorization to upload it through RapidAPI before processing. Use a fictional workbook for a first compatibility check.
What you get
- A new workbook with supported formula-result caches refreshed; original formulas and nonformula cells are checked for preservation.
- A source-linked JSON report with changed or missing caches, typed formula errors, preservation findings and unresolved review items.
- Your unchanged original file. The agent handles the processing command and returns the new artifacts.
Before you start
Use an Agensi-connected agent with Python 3.10+, authorized shell/file/verified-HTTPS access, your own private RapidAPI application key and a separate active CalcReceipt subscription. No local LibreOffice, pip packages or additional Flamingo MCP bridge are required.
Cost, files and limits
The skill, client and setup source are free. API processing is separately metered; the skill includes no subscription or processing allowance. Review CalcReceipt access and current limits before use. Errors and deliberate retries can consume allowance.
Selected XLSX bytes pass through RapidAPI to the service. Origin cleanup does not remove RapidAPI's separate records, and host tmpfs may be swapped. Review privacy requirements before confidential uploads.
This refreshes supported cell caches; it does not certify Excel parity or intended business logic. Unsupported features such as macros, external data, tables/pivots and shared/array/spill formulas are rejected. Charts and drawings can retain stale derived caches. Review the complete report before relying on the workbook. Independent product; not affiliated with Agensi's XLSX Toolkit, Microsoft or LibreOffice.
Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Data & Databases.
Requires a separate RapidAPI subscription and Python 3.10+ execution through the included temporary client. Processing is metered by the provider. Does not fix logical formula errors.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before buying a skill.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
1 use
Times used to date
Free to use
No account required to browse
Trust & safety
Security scan
Security scan passed 14 days ago
- Free with an Agensi account
- Accounts
RapidapiCalcReceipt API subscription
- Software
Python 3.10+Terminal accessHTTPS accessRapidAPI key
Uses only the standard library. HTTPS needs a working trust store. Set RAPIDAPI_KEY privately; the CalcReceipt subscription is separate.
Permissions
Allowed Hosts
The included client runs unchanged from a temporary file. It reads the selected authorized XLSX and the named private API-key environment variable, uploads that file through the fixed RapidAPI gateway, and creates two new local output files. No automatic retries or upload merely from loading the skill. Keep original files; remove only temporary skill code. Processing is separately metered; no API allowance is included.