Zum Inhalt
HALOWERK

Technische Prüfungen & Formate

F TD2000 DOCUMENTS 01 / xlsx cellis priority stop if true style resolution

Resolve competing cellIs formatting rules by priority, differential property and stopIfTrue.

POST https://detect.halowerk.com/v1/F-TD2000-DOCUMENTS-01/xlsx-cellis-priority-stop-if-true-style-resolution

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": [
        "conditionalFormats"
      ],
      "properties": {
        "conditionalFormats": {
          "type": "object",
          "additionalProperties": false,
          "required": [
            "data",
            "claim"
          ],
          "properties": {
            "data": {
              "type": "object",
              "additionalProperties": false,
              "required": [
                "cells",
                "rules"
              ],
              "properties": {
                "cells": {
                  "type": "array",
                  "items": {
                    "type": "object",
                    "additionalProperties": false,
                    "required": [
                      "cell",
                      "value"
                    ],
                    "properties": {
                      "cell": {
                        "type": "string",
                        "maxLength": 12
                      },
                      "value": {
                        "type": "number",
                        "minimum": -1000000000,
                        "maximum": 1000000000
                      }
                    }
                  },
                  "minItems": 1,
                  "maxItems": 64
                },
                "rules": {
                  "type": "array",
                  "items": {
                    "type": "object",
                    "additionalProperties": false,
                    "required": [
                      "priority",
                      "range",
                      "operator",
                      "values",
                      "style",
                      "stop_if_true"
                    ],
                    "properties": {
                      "priority": {
                        "type": "integer",
                        "minimum": 1,
                        "maximum": 10000
                      },
                      "range": {
                        "type": "string",
                        "maxLength": 28
                      },
                      "operator": {
                        "enum": [
                          "between",
                          "equal",
                          "greater",
                          "less"
                        ]
                      },
                      "values": {
                        "type": "array",
                        "items": {
                          "type": "number",
                          "minimum": -1000000000,
                          "maximum": 1000000000
                        },
                        "minItems": 1,
                        "maxItems": 2
                      },
                      "style": {
                        "type": "object",
                        "additionalProperties": false,
                        "properties": {
                          "font": {
                            "type": "string",
                            "maxLength": 64
                          },
                          "fill": {
                            "type": "string",
                            "maxLength": 64
                          },
                          "border": {
                            "type": "string",
                            "maxLength": 64
                          },
                          "number_format": {
                            "type": "string",
                            "maxLength": 64
                          }
                        }
                      },
                      "stop_if_true": {
                        "type": "boolean"
                      }
                    }
                  },
                  "minItems": 0,
                  "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",
                          "matched_priorities",
                          "style"
                        ],
                        "properties": {
                          "cell": {
                            "type": "string",
                            "maxLength": 20000
                          },
                          "matched_priorities": {
                            "type": "array",
                            "maxItems": 4096,
                            "items": {
                              "type": "integer"
                            }
                          },
                          "style": {
                            "type": "object",
                            "additionalProperties": false,
                            "properties": {
                              "font": {
                                "type": "string",
                                "maxLength": 64
                              },
                              "fill": {
                                "type": "string",
                                "maxLength": 64
                              },
                              "border": {
                                "type": "string",
                                "maxLength": 64
                              },
                              "number_format": {
                                "type": "string",
                                "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 →