syncfusion-dotnet-calculate

Q: How do I install syncfusion-dotnet-calculate?

Run npx skills add https://github.com/syncfusion/document-sdk-skills --skill syncfusion-dotnet-calculate in your project. The skills CLI detects the agents you use and copies the skill into the right folder. For Claude Code you can also place the skill folder at ~/.claude/skills/syncfusion-dotnet-calculate/ (personal) or .claude/skills/syncfusion-dotnet-calculate/ (project).

by syncfusionBackend & APIs

Implements the Syncfusion dotnet Calculate Library for parsing and evaluating formulas using CalcEngine, ICalcData, CalcQuickBase, and ExcelLikeComputations. Supports formula computation, custom functions, cross-sheet references, and XlsIO formula evaluation. Trigger when implementing formula calculations, expression parsing, workbook formula evaluation, or custom function registration.

Installs: 74
Last 24h: —
Trending rank: —
Security: Not audited

Install

Works with every agent the skills CLI supports.

npx skills add https://github.com/syncfusion/document-sdk-skills --skill syncfusion-dotnet-calculate

01
Install
Run the command in your project. The CLI asks which agents to install for.
02
Describe the task
Ask your agent for something this skill covers. It loads syncfusion-dotnet-calculate automatically when relevant.
03
Review the result
The agent follows the SKILL.md steps, scripts and references bundled with the skill.

SKILL.md

The instructions your agent reads when the skill is triggered.

Syncfusion dotnet Calculate

Overview

Parses and evaluates formulas using the Syncfusion dotnet Calculate. It generates C# code to enable interactive formula calculation functionality, including expression parsing, dependency resolution, and runtime evaluation of calculated values.

Quick Start Examples

Example 1

User: "Show me how to Parse and Compute the formulas using the CalcEngine"

Result: C# code generated to parse and compute the formula

Example 2

User: "Add custom formula to the calculate control to compare two strings"

Result: C# code generated to create a custom function

Generate C# Code for the User's Project (default)

Trigger keywords: "code", "snippet", "how to write", "Program.cs", "show me", "sample", "example code", "generate code for", "NuGet", "add to project", "integrate", "implementation", "usage example", "API example", "compute formula", "evaluate expression", "calculate result", "parse formula", "register variable", "cross-sheet formula", "use CalcQuickBase", "use CalcEngine", "use ICalcData", "compute with cell references", "auto calc", "refresh calculations", "reset keys", "format result", "region settings", "custom function", "user-defined formula", "register function", "LibraryFunctions", "ExcelLikeComputations", "iterative calculation", "suspend calculations", "supported formulas", "list formulas", "ParseAndCompute", "parseAndComputeFormula".

STEP 1 — Analyze User Request

Read the user’s request and extract the feature keywords.
If relevant reference/*.md files exist, use them as the only source of truth for generating code.
If no matching reference file exists, generate code using the samples in references/getting-started.md.

STEP 2 — Consent & Destination Gate (MUST ASK BEFORE ANY FILE ACTIONS)

Before generating or writing anything, ask the user:

I'm ready to generate your Syncfusion Calculate sample.

Where should I place it?
1) Create a new Form file in the skill's "output" folder (recommended for quick tryout)
2) Add or modify an existing file in your project (please provide the full file path; choose append or replace)
3) Say "Just show me the code" to get the snippet here without modifying any files.

Rules

Do NOT proceed until the user selects an option or says "Just show me the code."
If the user refuses file modifications:
- Only show the C# code in chat
- No file creation or changes
For Option 2 only: Before generating code, check if the project has the prerequisites from references/getting-started.md (Prerequisites and Setup Requirements section). If missing, ask user consent and add them.

STEP 3 — Generate Code (Strict Reference-Only Rules)

ALWAYS use the sample code structure from the "Minimal code" section in getting-started.md as the base template for Calculate creation.
Use APIs exactly as shown in references/*.md (e.g., getting-started.md, Xlsio.md).
Never invent APIs or guess behavior.
If the feature is not documented in any reference file, inform the user that it is unavailable.

STEP 4 — Apply Changes (Only After Consent)

Option A — Create New File in Skill’s Folder

Create a folder named output/ at the skill root (if it does not already exist).
Default filename: CalculateSample.cs
If the file already exists, ask: "A file named 'CalculateSample.cs' already exists. Overwrite, append, or use a different name?"
Wait for the user’s decision before writing anything.
Write the generated C# content.

Option B — Modify a File in the User’s Project

Ask: "Which file should I modify? Provide the COMPLETE file path (e.g., D:\Project\program.cs)"
Wait for explicit confirmation.
If the user only replies with “2” (option number) and no path → ask again.
Never guess or infer file paths.
Once confirmed, apply the requested change (overwrite or append).

Option C — Show the Code Only

Display the generated C# code in chat.
Do NOT create or modify any files.

Code References

All templates and feature snippets live in references/*.md. Each file is a focused snippet the agent combines when generating samples.

Flow: Always start with references/getting-started.md (Prerequisites and Setup Requirements section), then merge matched feature snippets. If no feature keywords match, return only the basic sample.

File	Contents
getting-started.md	Prerequisites, NuGet package setup, Program.cs configuration, minimal code examples for CalcQuickBase and ICalcData, cross-sheet references, culture settings, quick reference table
calcquickbase.md	ParseAndCompute method, register variables with square bracket notation, compute expressions and built-in formulas, AutoCalc for automatic recalculation, RefreshAllCalculations, ResetKeys method, key properties and methods, indexer-based access
icalcdata.md	ICalcData interface implementation, SetValueRowCol/GetValueRowCol methods, WireParentObject method, ValueChanged event, complete implementation example, integration with CalcEngine, cross-sheet references, data grid integration
calcengine.md	ParseFormula method, ComputeFormula method, ParseAndComputeFormula method, cross-sheet references with RegisterGridAsSheet and CreateSheetFamilyID, region/culture settings (ParseDecimalSeparator, ParseArgumentSeparator), error strings, supported built-in formulas by category
customfunction.md	LibraryFunction delegate, custom function creation, registration with CalcEngine, examples (CustomMin, CustomMax, ApplyDiscount, CalculateGrade, CompoundInterest), RemoveFunction method, managing library functions, error handling, best practices
xlsio.md	XlsIO integration, ExcelEngine initialization, enable/disable sheet calculations (EnableSheetCalculations/DisableSheetCalculations), set and compute values at runtime, suspend calculations during bulk updates (CalculatingSuspended), CalculatedValue property, table formulas, complete workflows, error handling
overview.md	400+ predefined functions across categories, supported environments and platforms, non-UI component architecture, formula types supported, function categories reference, typical use cases, integration with XlsIO
parse-compute.md	ParseFormula method and RPN conversion, ComputeFormula method for stack-based evaluation, ParseAndComputeFormula combined approach, operator precedence and parsing order, error handling and error strings, formatting computed results (decimal, percentage, currency), performance optimization
operators.md	Formula operators and their precedence, supported operators in calculations
namedranges.md	Named ranges support for simplifying complex formulas
performance.md	Performance optimization techniques and best practices

Rules

Use Only Reference Snippets
- Generate code exclusively from the Markdown files under references/
- Do not invent/guess/include any properties, events, API methods, component names, or parameters not present in references/*.md
NO FILE MODIFICATIONS WITHOUT PERMISSION
- Never create or modify files/folders in user workspace without explicit user selection and confirmation.
Unsupported Feature Handling
- If the user requests a feature with no corresponding snippet in references/*.md, respond with: That feature is not currently supported by the Syncfusion Calculate Library.
- Suggest the closest supported features only if they have snippets
- Explicitly list unsupported items and do not synthesize code for them
Validation Before Write
- Re-validate before writing that all code blocks originate from references/*.md files
- If validation fails, stop and inform the user

FAQ

What does the syncfusion-dotnet-calculate skill do?

How do I install syncfusion-dotnet-calculate?

Run npx skills add https://github.com/syncfusion/document-sdk-skills --skill syncfusion-dotnet-calculate in your project. The skills CLI detects the agents you use and copies the skill into the right folder. For Claude Code you can also place the skill folder at ~/.claude/skills/syncfusion-dotnet-calculate/ (personal) or .claude/skills/syncfusion-dotnet-calculate/ (project).

Which AI agents can use syncfusion-dotnet-calculate?

Any agent that supports the open Agent Skills format (a folder with a SKILL.md file), including Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, Windsurf, Cline, OpenCode and more.

Is syncfusion-dotnet-calculate safe to install?

No partner security audit is available yet. Skills can run commands and scripts, so read the SKILL.md and any bundled files before installing.

Who maintains syncfusion-dotnet-calculate?

It is published by syncfusion in syncfusion/document-sdk-skills. It has 74 recorded installs.