HALOWERKTechnische Prüfungen & Formate
F TD2000 DOCUMENTS 07 / excel subtotal aggregate reference provenance visibility error ledger
Reconstruct reference-aware SUBTOTAL/AGGREGATE results without counting filtered, hidden or nested values incorrectly.
POST https://detect.halowerk.com/v1/F-TD2000-DOCUMENTS-07/excel-subtotal-aggregate-reference-provenance-visibility-error-ledgerEingaben
| Feld | Typ | Pflicht | Beschreibung |
|---|---|---|---|
| artifact | object | Ja |
Vollständiges Eingabeschema anzeigen
{
"type": "object",
"additionalProperties": false,
"required": [
"artifact"
],
"properties": {
"artifact": {
"type": "object",
"additionalProperties": false,
"required": [
"spreadsheetAggregate"
],
"properties": {
"spreadsheetAggregate": {
"type": "object",
"additionalProperties": false,
"required": [
"data",
"claim"
],
"properties": {
"data": {
"type": "object",
"additionalProperties": false,
"required": [
"mode",
"function_num",
"options",
"k",
"cells"
],
"properties": {
"mode": {
"enum": [
"SUBTOTAL",
"AGGREGATE"
]
},
"function_num": {
"type": "integer",
"minimum": 1,
"maximum": 111
},
"options": {
"type": "integer",
"minimum": 0,
"maximum": 7
},
"k": {
"anyOf": [
{
"type": "null"
},
{
"type": "number",
"minimum": 0,
"maximum": 1000000
}
]
},
"cells": {
"type": "array",
"items": {
"type": "object",
"additionalProperties": false,
"required": [
"type",
"value",
"filtered",
"hidden",
"nested"
],
"properties": {
"type": {
"enum": [
"number",
"text",
"boolean",
"blank",
"error"
]
},
"value": {
"anyOf": [
{
"type": "number",
"minimum": -1000000000000,
"maximum": 1000000000000
},
{
"type": "string",
"maxLength": 256,
"minLength": 0
},
{
"type": "boolean"
},
{
"type": "null"
}
]
},
"filtered": {
"type": "boolean"
},
"hidden": {
"type": "boolean"
},
"nested": {
"enum": [
"none",
"subtotal",
"aggregate"
]
}
}
},
"maxItems": 256,
"minItems": 0
}
}
},
"claim": {
"anyOf": [
{
"type": "null"
},
{
"type": "object",
"additionalProperties": false,
"required": [
"value",
"error",
"included_cell_indices",
"numeric_cell_indices"
],
"properties": {
"value": {
"anyOf": [
{
"type": "null"
},
{
"type": "number",
"minimum": -1000000000000000,
"maximum": 1000000000000000
}
]
},
"error": {
"anyOf": [
{
"type": "null"
},
{
"type": "string",
"maxLength": 256,
"minLength": 1
}
]
},
"included_cell_indices": {
"type": "array",
"items": {
"type": "integer",
"minimum": 0,
"maximum": 255
},
"maxItems": 256,
"minItems": 0
},
"numeric_cell_indices": {
"type": "array",
"items": {
"type": "integer",
"minimum": 0,
"maximum": 255
},
"maxItems": 256,
"minItems": 0
}
}
}
]
}
}
}
}
}
}
}Ergebnis & Dokumentation
Maschinenlesbare Dokumentation dieses Hubs
Quelle dieser Seite: der veröffentlichte HALOWERK-Katalog. Stand: 2026-11-01, 15:19 UTC.
Weitere Endpunkte dieses Hubs
- Technische Prüfungen & Formate0,003 USDC
aria concrete role property support closure
POSThttps://detect.halowerk.com/u/aria-concrete-role-property-support-closureA component API exporter needs properties that are unsupported or prohibited for its selected explicit ARIA role rather than losing them silently during conversion.
- Technische Prüfungen & Formate0,003 USDC
aria description author source precedence
POSThttps://detect.halowerk.com/u/aria-description-author-source-precedenceA description-metadata exporter needs which author ARIA source survives precedence and which competing source is overridden before transferring help text.
- Technische Prüfungen & Formate0,003 USDC
aria explicit concrete role token fallback
POSThttps://detect.halowerk.com/u/aria-explicit-concrete-role-token-fallbackBefore removing compatibility role tokens, a website migration agent needs which concrete source role survives the normative fallback order.