Zum Inhalt
HALOWERK

Technische Prüfungen & Formate

F TD2000 DOCUMENTS 07 / excel dynamic array spill region occupancy and blocker binding

Reconstruct a computed dynamic array spill region and every physical blocker before applying worksheet writes.

POST https://detect.halowerk.com/v1/F-TD2000-DOCUMENTS-07/excel-dynamic-array-spill-region-occupancy-and-blocker-binding

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": [
        "spreadsheetSpill"
      ],
      "properties": {
        "spreadsheetSpill": {
          "type": "object",
          "additionalProperties": false,
          "required": [
            "data",
            "claim"
          ],
          "properties": {
            "data": {
              "type": "object",
              "additionalProperties": false,
              "required": [
                "anchor",
                "values",
                "sheet_rows",
                "sheet_columns",
                "cells",
                "merged",
                "tables"
              ],
              "properties": {
                "anchor": {
                  "type": "array",
                  "items": {
                    "type": "integer",
                    "minimum": 0,
                    "maximum": 1048575
                  },
                  "maxItems": 2,
                  "minItems": 2
                },
                "values": {
                  "type": "array",
                  "items": {
                    "type": "array",
                    "items": {
                      "anyOf": [
                        {
                          "type": "number",
                          "minimum": -1000000000000,
                          "maximum": 1000000000000
                        },
                        {
                          "type": "string",
                          "maxLength": 256,
                          "minLength": 0
                        },
                        {
                          "type": "boolean"
                        }
                      ]
                    },
                    "maxItems": 64,
                    "minItems": 1
                  },
                  "maxItems": 64,
                  "minItems": 1
                },
                "sheet_rows": {
                  "type": "integer",
                  "minimum": 1,
                  "maximum": 1048576
                },
                "sheet_columns": {
                  "type": "integer",
                  "minimum": 1,
                  "maximum": 16384
                },
                "cells": {
                  "type": "array",
                  "items": {
                    "type": "object",
                    "additionalProperties": false,
                    "required": [
                      "row",
                      "column",
                      "kind"
                    ],
                    "properties": {
                      "row": {
                        "type": "integer",
                        "minimum": 0,
                        "maximum": 1048575
                      },
                      "column": {
                        "type": "integer",
                        "minimum": 0,
                        "maximum": 16383
                      },
                      "kind": {
                        "enum": [
                          "empty",
                          "value",
                          "formula"
                        ]
                      }
                    }
                  },
                  "maxItems": 256,
                  "minItems": 0
                },
                "merged": {
                  "type": "array",
                  "items": {
                    "type": "array",
                    "items": {
                      "type": "integer",
                      "minimum": 0,
                      "maximum": 1048575
                    },
                    "maxItems": 4,
                    "minItems": 4
                  },
                  "maxItems": 32,
                  "minItems": 0
                },
                "tables": {
                  "type": "array",
                  "items": {
                    "type": "array",
                    "items": {
                      "type": "integer",
                      "minimum": 0,
                      "maximum": 1048575
                    },
                    "maxItems": 4,
                    "minItems": 4
                  },
                  "maxItems": 32,
                  "minItems": 0
                }
              }
            },
            "claim": {
              "anyOf": [
                {
                  "type": "null"
                },
                {
                  "type": "object",
                  "additionalProperties": false,
                  "required": [
                    "status",
                    "blockers",
                    "spill_range",
                    "cells"
                  ],
                  "properties": {
                    "status": {
                      "enum": [
                        "spilled",
                        "#SPILL!"
                      ]
                    },
                    "blockers": {
                      "type": "array",
                      "items": {
                        "type": "object",
                        "additionalProperties": false,
                        "required": [
                          "kind",
                          "row",
                          "column"
                        ],
                        "properties": {
                          "kind": {
                            "enum": [
                              "sheet_edge",
                              "occupied",
                              "merged",
                              "table"
                            ]
                          },
                          "row": {
                            "type": "integer",
                            "minimum": 0,
                            "maximum": 1048640
                          },
                          "column": {
                            "type": "integer",
                            "minimum": 0,
                            "maximum": 16447
                          }
                        }
                      },
                      "maxItems": 321,
                      "minItems": 0
                    },
                    "spill_range": {
                      "type": "array",
                      "items": {
                        "type": "integer",
                        "minimum": 0,
                        "maximum": 1048640
                      },
                      "maxItems": 4,
                      "minItems": 4
                    },
                    "cells": {
                      "type": "array",
                      "items": {
                        "type": "object",
                        "additionalProperties": false,
                        "required": [
                          "row",
                          "column",
                          "value"
                        ],
                        "properties": {
                          "row": {
                            "type": "integer",
                            "minimum": 0,
                            "maximum": 1048575
                          },
                          "column": {
                            "type": "integer",
                            "minimum": 0,
                            "maximum": 16383
                          },
                          "value": {
                            "anyOf": [
                              {
                                "type": "number",
                                "minimum": -1000000000000,
                                "maximum": 1000000000000
                              },
                              {
                                "type": "string",
                                "maxLength": 256,
                                "minLength": 0
                              },
                              {
                                "type": "boolean"
                              }
                            ]
                          }
                        }
                      },
                      "maxItems": 4096,
                      "minItems": 0
                    }
                  }
                }
              ]
            }
          }
        }
      }
    }
  }
}

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 →