origami.gratis

{
  "type": "object",
  "additionalProperties": false,
  "properties": {
    "title": {
      "type": "string",
      "maxLength": 200,
      "description": "The fold's heading (rendered as the h2) and the default sidebar label"
    },
    "eyebrow": {
      "type": "string",
      "maxLength": 80,
      "description": "The small label line above the heading, e.g. \"Q3 review\" (omit for none)"
    },
    "label": {
      "type": "string",
      "maxLength": 200,
      "description": "Sidebar/tab label (default: the title, trimmed to ~28 characters)"
    },
    "position": {
      "type": "integer",
      "minimum": 0,
      "description": "0-based insert index (default: the end)"
    },
    "columns": {
      "type": "array",
      "description": "Column definitions: [{ label, align?: \"left\"|\"right\"|\"center\", format?: { kind: \"general\"|\"number\"|\"currency\"|\"percent\"|\"date\"|\"text\", decimals?: int } }]",
      "items": {
        "type": "object"
      }
    },
    "rows": {
      "type": "array",
      "description": "Cells, row by row, as strings: [[\"Rent\",\"1200\"], …]. Leave a formula cell \"\" — the calc engine fills it",
      "items": {
        "type": "array"
      }
    },
    "currency": {
      "type": "string",
      "maxLength": 8,
      "description": "The PREFIX every currency-kind column prints, e.g. \"€\" or \"EUR\" or \"£\". It is printed LITERALLY, not resolved from an ISO code: \"EUR\" gives \"EUR1,234.50\" and \"€\" gives \"€1,234.50\". Default: the format library's own \"$\""
    },
    "formulas": {
      "type": "object",
      "description": "A1 cell -> formula, e.g. { \"D1\": \"=B1-C1\", \"B5\": \"=SUM(B1:B4)\" }"
    },
    "named": {
      "type": "object",
      "description": "Named outputs other blocks can reference, e.g. { \"grandTotal\": \"=B3\" }"
    },
    "totals": {
      "type": "object",
      "description": "A footer row: { \"on\": true, \"fns\": { \"1\": \"SUM\", \"2\": \"SUM\" } } — keys are COLUMN INDICES as strings, 0-based"
    },
    "kpis": {
      "type": "array",
      "description": "Cards pinned above the table: [{ \"name\": \"planTotal\", \"ref\": \"B5\" }] — name is an identifier, ref an A1 cell or a cellName",
      "items": {
        "type": "object"
      }
    },
    "cellFormats": {
      "type": "object",
      "description": "Per-cell format overrides by A1 reference, e.g. { \"B3\": { \"kind\": \"currency\" } }"
    },
    "caption": {
      "type": "string",
      "maxLength": 200,
      "description": "The line under the table (default: none)"
    }
  },
  "required": [
    "title",
    "columns",
    "rows"
  ]
}