ListSheet

ListSheet turns your everyday markdown lists into a live, calculating spreadsheet. Write a simple label = expression line and get instant sums, budgets, checklists, and formula results — right inside your notes, with full Bangla/Bengali support built in.

✨ Why People Love It

• 🧮 Real formulas, not just totals — Sum, Avg, Min, Max, Count, Mid, First, Last, plus math functions (sin, cos, sqrt, LCM, GCD) and full operators (+ - * / % ^)
• ✅ Checkbox-aware calculations — totalCheck(), totalUnCheck(), and name lookups only count what's actually ticked
• 🔀 Conditional logic — If(condition, true, false) with == != and or not, including nested conditions for grading, alerts, and status checks
• 🎯 One-shot dot notation — grab a single value instantly with ParentName.ChildName, no separate lookup needed
• 🌐 Bangla/Bengali native — Bengali digits, currency, and labels are recognized automatically, no extra setup
• 🔤 Text + numbers together — combine strings and values in one formula, e.g. "Total: " + Sum(Budget)
• 🔒 Safe by design — a purpose-built formula engine (no raw code execution) keeps your notes secure
• 📋 Live everywhere — results update inline as you type, plus a dedicated side panel with one-click JSON export

Release

V1.0.0

V1.0.0 is latest release of listsheet series.

Migration From ClistCalc to Listsheet

ClistCalc and ListSheet are following same syntex. Both support bulletlist,checklist,nested list. ListSheet extends for supporting number list. There is great difference between parsing. Because ListSheet use new engine for it. Previously, ClistCalc use note with regex to find out list. So, sometimes token or regex mistake like suffix,prefix are generally happend. But, ListSheet use different technique here. It reads your markdown first then every list convert in a obj with separating Suffix,prefix or others. So, when calculation you only get value from list. Also when any list item have no value it ignoring that to avoid errors as null. Below FAQ section you get more answer and work process.

So, migrate from CListCal to listsheet is easier and recommend. They both use same functions like Sum,Avg,..etc and Conditions If(condition,true,false).

[!Important] CListCalc plugin will officially disconnect after August 30,2026.

How It Works

1. Write lists in your note (bullet, numbered, or checkbox).
2. Open a ```listsheet ``` block to write formulas.
3. Results appear inline in your note and in the side panel.

Tip: Supports both English and Bengali (বাংলা) digits and labels.

Three Types of Lists

ListSheet reads three list styles from your notes.

1. Bullet List

Simple bullet points. Use - or *.

- Apples = 50
- Oranges = 30
- Mangoes = 20

Nested bullet list:

- Fruits
  - Apples = 50
  - Oranges = 30
- Vegetables
  - Carrots = 15
  - Potatoes = 10

2. Numbered List

Ordered items. Use 1. 2. or Bengali ১. ২.

1. Rent = 5000
2. Food = 3000
3. Transport = 1500

Nested numbered list:

1. Income
   1. Salary = 20000
   2. Freelance = 8000
2. Expenses
   1. Rent = 5000
   2. Bills = 2000

3. Checkbox List

Checkable items. Use - [ ] for unchecked and - [x] for checked.

- [x] Milk = 80
- [x] Bread = 60
- [ ] Butter = 120

Only checked items are counted in formulas (unless the parent is checked — then all children count).

Nested checkbox list:

- [x] Groceries
    - [x] Milk = 80
    - [ ] Eggs = 50
    - [x] Bread = 60

Duplicate Parent Names

If two or more lists share the same parent name, ListSheet follows a rule to decide what to do.

The Rule

You can change this rule in Settings → ListSheet → Duplicate section handling.

Example — Merge (default)

- Expenses
    - Rent = 5000
    - Food = 3000

- Expenses
    - Transport = 1000
    - Bills = 500

With Merge, both lists combine into one Expenses object:

Total = Sum(Expenses)   ← sees Rent + Food + Transport + Bills = 9500

Example — Unique

With Unique, each list stays separate:

Total1 = Sum(Expenses)     ← Rent + Food = 8000
Total2 = Sum(Expenses #2)  ← Transport + Bills = 1500

Tip: Use Merge when you want all items from repeated sections to count together. Use Unique when you need to treat each block independently.

⚠️ Warning: Accessing Simple List Items by Name

This is one of the most common mistakes. Read carefully.

The Problem

When you write a flat list (items without any parent item above them), ListSheet stores all those items under the section heading — not under the item names themselves.

## My Section

- Apple = 50
- Orange = 30
- Mango = 20

Here, Apple, Orange, and Mango are stored inside My Section. You cannot call them by name directly in a formula.

❌ Total = Apple + Orange   ← This will NOT work
✅ Total = Sum(My Section)  ← This works
✅ One   = My Section.Apple ← This works (dot notation)

No Heading? Use default

If your flat list has no heading above it, ListSheet saves it under the key default.

- Rent = 5000
- Food = 3000

❌ Total = Rent + Food          ← Will NOT work
✅ Total = Sum(default)         ← Works
✅ MyRent = default.Rent        ← Works (dot notation)

When Direct Access DOES Work

Direct name access works only when an item has nested children (it becomes its own top-level key):

- Expenses         ← becomes a top-level key named "Expenses"
    - Rent = 5000
    - Food = 3000

✅ Total = Sum(Expenses)       ← Works
✅ MyRent = Expenses.Rent      ← Works

Rule of thumb: If your item has children → access it by its name. If it has no children → access it via its heading or default.

Suffix and Prefix

List item values can have extra text before or after the number. These are called prefix and suffix.

Syntax

- Item name = [prefix] number [suffix]

Examples

- Price = $ 250 USD
- Rent  = ৳ 5000 taka
- Score = approx 87 marks
- Tax   = 15 %

In each case, ListSheet separates the value from the surrounding text:

The prefix and suffix appear as labels in the panel display, but they are not part of the calculation.

Text in Expressions

You can use text (strings) directly in your formulas using double quotes.

Syntax

name = "your text"
name = "Hello " + OtherValue
name = Value + " kg"

Examples

Label    = "Total Cost"
Message  = "Score is " + Score
Unit     = Weight + " kg"
Full     = "Name: " + "Ahmed"
Suffix = "Suffix "+ 19*20
Prefix = 18*8+" Prefix"
Nested = "Suffix "+78*7+" Prefix"

You can also mix text and numbers with +. As soon as one side is text, the result becomes text too.

Note: Only + works with text. Using -, *, / on text values will give an error.

Formulas

Write formulas inside a ```listsheet ``` block. Each line follows this pattern:

name = expression

Aggregate Functions

Checkbox Functions

Math Functions

Operators

Dot Notation

Access a single child item directly:

result = ListName.ChildName

Example:

Budget

• Expenses - Rent = 5000 - Food = 3000

MyRent = Expenses.Rent

Conditions

Use If() to return different values based on a condition.

Syntax

name = If(condition, valueIfTrue, valueIfFalse)

Comparison Operators

Logical Keywords

Examples

Basic If:

Score

• Score
  • Marks = 75

Result = If(Score.Marks>= 50, "Pass", "Fail")

With and:

Stats

• Example
  • Age = 20
  • Score = 85

Status = If(Example.Age >= 18 and Score >= 60, "Eligible", "Not eligible")

With or:

Alert = If(Example.Score < 30 or Example.Score > 100, "Invalid", "Valid")

With not:

Check = If(not Score == 0, "Has score", "No score")

Nested If:

Grade = If(Example.Score >= 90, "A", If(Example.Score >= 75, "B", If(Example.Score >= 60, "C", "F")))

Full Example

Monthly Budget

• Income

  • Salary = 20000
  • Freelance = 5000

• Expenses

  • Rent = 6000
  • Food = 3500
  • Transport = 1000

• Shopping

  • Clothes = 2000
  • Shoes = 1500

TotalIncome  = Sum(Income)
TotalExpense = Sum(Expenses)
ShopSpent    = Sum(Shopping)
Balance      = TotalIncome - TotalExpense - ShopSpent
Status       = If(Balance > 0, "Surplus", "Deficit")
ItemsBought  = totalCheck(Shopping)

Mind Map Table

FAQ

Q: Do suffix and prefix cause problems in calculations?

No. ListSheet builds a data object from your lists before doing any math. Each item is broken into separate fields: label, value, prefix, suffix, type, and more. When a formula runs, it only uses the value field — the prefix and suffix are completely ignored in calculations.

So writing ৳ 5000 taka or just 5000 makes no difference to the result.

- ItemA = $ 200 USD     ← value used in calc: 200
- ItemB = 300           ← value used in calc: 300

Total = Sum(MyList)     ← result: 500 (prefix/suffix ignored)

Q: Can I use a suffix or prefix in a formula result?

No. Formula results display only their computed value. If you want a unit label in the output, add it as a text string:

Result = Sum(MyList) + " USD"

Q: What if my item has no number at all?

Items without a number (labels-only) have a value of null. Aggregate functions like Sum() skip them automatically.

Settings

Go to Settings → Community Plugins → ListSheet.

Commands