Zum Inhalt
HALOWERK

Technische Prüfungen & Formate

F TD2000 DOCUMENTS 08 / spreadsheet conditional dxf priority stopiftrue property cascade

Excel conditional formatting priority and stopIfTrue cascade. Reconstruct the fully typed result and compare its complete canonical SHA256 claim.

POST https://detect.halowerk.com/v1/F-TD2000-DOCUMENTS-08/spreadsheet-conditional-dxf-priority-stopiftrue-property-cascade

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": [
        "conditionalFormatting"
      ],
      "properties": {
        "conditionalFormatting": {
          "type": "object",
          "additionalProperties": false,
          "required": [
            "data",
            "claim"
          ],
          "properties": {
            "data": {
              "type": "object",
              "additionalProperties": false,
              "required": [
                "cells",
                "rules"
              ],
              "properties": {
                "cells": {
                  "type": "array",
                  "items": {
                    "anyOf": [
                      {
                        "type": "object",
                        "additionalProperties": false,
                        "required": [
                          "id",
                          "row",
                          "column",
                          "base_style",
                          "type",
                          "value"
                        ],
                        "properties": {
                          "id": {
                            "type": "string",
                            "minLength": 1,
                            "maxLength": 64,
                            "pattern": "^[A-Za-z_][A-Za-z0-9_.-]*$"
                          },
                          "row": {
                            "type": "integer",
                            "minimum": 1,
                            "maximum": 1048576
                          },
                          "column": {
                            "type": "integer",
                            "minimum": 1,
                            "maximum": 16384
                          },
                          "base_style": {
                            "$ref": "#/properties/artifact/%24defs/s0"
                          },
                          "type": {
                            "enum": [
                              "number"
                            ]
                          },
                          "value": {
                            "type": "number",
                            "minimum": -1000000000000,
                            "maximum": 1000000000000
                          }
                        }
                      },
                      {
                        "type": "object",
                        "additionalProperties": false,
                        "required": [
                          "id",
                          "row",
                          "column",
                          "base_style",
                          "type",
                          "value"
                        ],
                        "properties": {
                          "id": {
                            "type": "string",
                            "minLength": 1,
                            "maxLength": 64,
                            "pattern": "^[A-Za-z_][A-Za-z0-9_.-]*$"
                          },
                          "row": {
                            "type": "integer",
                            "minimum": 1,
                            "maximum": 1048576
                          },
                          "column": {
                            "type": "integer",
                            "minimum": 1,
                            "maximum": 16384
                          },
                          "base_style": {
                            "$ref": "#/properties/artifact/%24defs/s0"
                          },
                          "type": {
                            "enum": [
                              "string"
                            ]
                          },
                          "value": {
                            "type": "string",
                            "minLength": 0,
                            "maxLength": 512
                          }
                        }
                      }
                    ]
                  },
                  "minItems": 0,
                  "maxItems": 64
                },
                "rules": {
                  "type": "array",
                  "items": {
                    "type": "object",
                    "additionalProperties": false,
                    "required": [
                      "priority",
                      "ranges",
                      "condition",
                      "style",
                      "stop_if_true"
                    ],
                    "properties": {
                      "priority": {
                        "type": "integer",
                        "minimum": 1,
                        "maximum": 1000000
                      },
                      "ranges": {
                        "type": "array",
                        "items": {
                          "type": "array",
                          "items": {
                            "type": "integer",
                            "minimum": 1,
                            "maximum": 1048576
                          },
                          "minItems": 4,
                          "maxItems": 4
                        },
                        "minItems": 1,
                        "maxItems": 16
                      },
                      "condition": {
                        "type": "object",
                        "additionalProperties": false,
                        "required": [
                          "op",
                          "values"
                        ],
                        "properties": {
                          "op": {
                            "enum": [
                              "equal",
                              "notEqual",
                              "greaterThan",
                              "lessThan",
                              "greaterThanOrEqual",
                              "lessThanOrEqual",
                              "between",
                              "notBetween",
                              "containsText",
                              "notContainsText",
                              "beginsWith",
                              "endsWith"
                            ]
                          },
                          "values": {
                            "type": "array",
                            "items": {
                              "anyOf": [
                                {
                                  "type": "number",
                                  "minimum": -1000000000000,
                                  "maximum": 1000000000000
                                },
                                {
                                  "type": "string",
                                  "minLength": 0,
                                  "maxLength": 512
                                }
                              ]
                            },
                            "minItems": 1,
                            "maxItems": 2
                          }
                        }
                      },
                      "style": {
                        "$ref": "#/properties/artifact/%24defs/s0"
                      },
                      "stop_if_true": {
                        "type": "boolean"
                      }
                    }
                  },
                  "minItems": 0,
                  "maxItems": 32
                }
              }
            },
            "claim": {
              "anyOf": [
                {
                  "type": "null"
                },
                {
                  "type": "string",
                  "minLength": 64,
                  "maxLength": 64,
                  "pattern": "^[0-9a-f]{64}$"
                }
              ]
            }
          }
        }
      },
      "$defs": {
        "s0": {
          "type": "object",
          "additionalProperties": false,
          "required": [
            "font_bold",
            "font_italic",
            "font_color",
            "fill_color",
            "number_format"
          ],
          "properties": {
            "font_bold": {
              "anyOf": [
                {
                  "type": "null"
                },
                {
                  "type": "boolean"
                }
              ]
            },
            "font_italic": {
              "anyOf": [
                {
                  "type": "null"
                },
                {
                  "type": "boolean"
                }
              ]
            },
            "font_color": {
              "anyOf": [
                {
                  "type": "null"
                },
                {
                  "type": "string",
                  "minLength": 0,
                  "maxLength": 32
                }
              ]
            },
            "fill_color": {
              "anyOf": [
                {
                  "type": "null"
                },
                {
                  "type": "string",
                  "minLength": 0,
                  "maxLength": 32
                }
              ]
            },
            "number_format": {
              "anyOf": [
                {
                  "type": "null"
                },
                {
                  "type": "string",
                  "minLength": 0,
                  "maxLength": 64
                }
              ]
            }
          }
        }
      }
    }
  }
}

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 →