# Spreadsheet Custom Number Format Display Reconstructor

> Spreadsheet Custom Number Format Display Reconstructor is a paid API for AI agents from detect.halowerk.com, paid per call via x402, $0.003/call, status unknown (last checked 2026-11-17).

Reconstructs the display string a spreadsheet application would show for a given cell value and custom number/date format string.

## Facts

- Endpoint: POST https://detect.halowerk.com/v1/F-TD2000-DOCUMENTS-07/ssf0112-spreadsheet-custom-number-date-display-reconstruction?utm_source=zero.xyz
- Price: $0.003/call
- Payment: x402
- Status: unknown
- Last checked: 2026-11-17
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/spreadsheet-custom-number-format-display-reconstructor-d54f9788
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_8Fi3jZwYafNnx1dOUi4SS

Status and success rate cover calls made through Zero and Zero's own probes. Third-party monitors may report differently.

## How to call it through Zero

Zero handles the 402 payment challenge and records the run. With the Zero CLI installed (`npm i -g @zeroxyz/cli`):

```sh
zero fetch --capability spreadsheet-custom-number-format-display-reconstructor-d54f9788 -d '<json body>'
```

Example prompt: Format the spreadsheet cell value 44927 using the custom number format 'DD-MMM-YYYY' with the 1904 date system disabled, and tell me exactly what display string the spreadsheet would show.

## When to prefer this

Use this endpoint when you need to faithfully reconstruct the exact display string a spreadsheet application (Excel, LibreOffice, Google Sheets) would render for a cell given its raw value and custom format code — especially for date/time, currency, percentage, or custom numeric formats. Prefer this over generic number formatting libraries when you need high fidelity to spreadsheet-specific format string syntax (including color, conditional, and locale-aware formats) and want to verify or audit existing formatted claims.

## Known failure modes

- Invalid or unsupported number format string returns an error or empty formatted result
- Cell value out of allowed range (-1e12 to 1e12) is rejected with a validation error
- More than 64 cells in a single request exceeds the maxItems limit and is rejected
- Malformed JSON input (missing required fields like date1904 or cells) returns a 400-level error
- Ambiguous format strings may produce unexpected output not matching a specific spreadsheet application's behavior

## How this service works

Reconstruct spreadsheet display strings from supplied values and explicit custom number formats.

## Output

Returns an array of formatted cell display strings (one per input cell), each with the reconstructed text the spreadsheet application would render and a boolean indicating whether the format is a date format. Also returns the formatter version used.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "artifact": {
   "type": "object",
   "required": [
    "spreadsheetNumberFormat"
   ],
   "properties": {
    "spreadsheetNumberFormat": {
     "type": "object",
     "required": [
      "data",
      "claim"
     ],
     "properties": {
      "data": {
       "type": "object",
       "required": [
        "date1904",
        "cells"
       ],
       "properties": {
        "cells": {
         "type": "array",
         "items": {
          "type": "object",
          "required": [
           "value",
           "format"
          ],
          "properties": {
           "value": {
            "anyOf": [
             {
              "type": "number",
              "maximum": 1000000000000,
              "minimum": -1000000000000
             },
             {
              "type": "string",
              "maxLength": 2048,
              "minLength": 0
             },
             {
              "type": "boolean"
             }
            ]
           },
           "format": {
            "type": "string",
            "maxLength": 1024,
            "minLength": 1
           }
          },
          "additionalProperties": false
         },
         "maxItems": 64,
         "minItems": 1
        },
        "date1904": {
         "type": "boolean"
        }
       },
       "additionalProperties": false
      },
      "claim": {
       "anyOf": [
        {
         "type": "null"
        },
        {
         "type": "object",
         "required": [
          "formatter_version",
          "cells"
         ],
         "properties": {
          "cells": {
           "type": "array",
           "items": {
            "type": "object",
            "required": [
             "formatted",
             "is_date_format"
            ],
            "properties": {
             "formatted": {
              "type": "string",
              "maxLength": 12000,
              "minLength": 0
             },
             "is_date_format": {
              "type": "boolean"
             }
            },
            "additionalProperties": false
           },
           "maxItems": 64,
           "minItems": 0
          },
          "formatter_version": {
           "type": "string",
           "maxLength": 32,
           "minLength": 1
          }
         },
         "additionalProperties": false
        }
       ]
      }
     },
     "additionalProperties": false
    }
   },
   "additionalProperties": false
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/spreadsheet-custom-number-format-display-reconstructor-d54f9788/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from detect.halowerk.com](https://www.zero.xyz/host/detect.halowerk.com/llms.txt)
