Zum Inhalt
HALOWERK

Technische Prüfungen & Formate

F TD2000 DOCUMENTS 01 / xlsx shared formula master mixed a1 reference reconstruction

Reconstruct shared cell formulas from masters while preserving absolute references and quoted strings.

POST https://detect.halowerk.com/v1/F-TD2000-DOCUMENTS-01/xlsx-shared-formula-master-mixed-a1-reference-reconstruction

Eingaben

Felder des veröffentlichten Eingabeschemas
FeldTypPflichtBeschreibung
artifactobjectJa
Vollständiges Eingabeschema anzeigen
{
  "type": "object",
  "additionalProperties": false,
  "required": [
    "artifact"
  ],
  "properties": {
    "artifact": {
      "type": "object",
      "additionalProperties": false,
      "required": [
        "sharedFormulas"
      ],
      "properties": {
        "sharedFormulas": {
          "type": "object",
          "additionalProperties": false,
          "required": [
            "data",
            "claim"
          ],
          "properties": {
            "data": {
              "type": "object",
              "additionalProperties": false,
              "required": [
                "masters",
                "cells"
              ],
              "properties": {
                "masters": {
                  "type": "array",
                  "items": {
                    "type": "object",
                    "additionalProperties": false,
                    "required": [
                      "si",
                      "cell",
                      "range",
                      "formula"
                    ],
                    "properties": {
                      "si": {
                        "type": "integer",
                        "minimum": 0,
                        "maximum": 10000
                      },
                      "cell": {
                        "type": "string",
                        "maxLength": 12
                      },
                      "range": {
                        "type": "string",
                        "maxLength": 28
                      },
                      "formula": {
                        "type": "string",
                        "maxLength": 1000
                      }
                    }
                  },
                  "minItems": 1,
                  "maxItems": 32
                },
                "cells": {
                  "type": "array",
                  "items": {
                    "type": "object",
                    "additionalProperties": false,
                    "required": [
                      "cell",
                      "si"
                    ],
                    "properties": {
                      "cell": {
                        "type": "string",
                        "maxLength": 12
                      },
                      "si": {
                        "type": "integer",
                        "minimum": 0,
                        "maximum": 10000
                      }
                    }
                  },
                  "minItems": 1,
                  "maxItems": 64
                }
              }
            },
            "claim": {
              "anyOf": [
                {
                  "type": "null"
                },
                {
                  "type": "object",
                  "additionalProperties": false,
                  "required": [
                    "cells"
                  ],
                  "properties": {
                    "cells": {
                      "type": "array",
                      "maxItems": 4096,
                      "items": {
                        "type": "object",
                        "additionalProperties": false,
                        "required": [
                          "cell",
                          "formula"
                        ],
                        "properties": {
                          "cell": {
                            "type": "string",
                            "maxLength": 20000
                          },
                          "formula": {
                            "type": "string",
                            "maxLength": 20000
                          }
                        }
                      }
                    }
                  }
                }
              ]
            }
          }
        }
      }
    }
  }
}

Originalschema öffnen

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

Alle Endpunkte dieses Hubs →