{"uid":"cap_8Fi3jZwYafNnx1dOUi4SS","slug":"spreadsheet-custom-number-format-display-reconstructor-d54f9788","name":"Spreadsheet Custom Number Format Display Reconstructor","description":"Reconstruct spreadsheet display strings from supplied values and explicit custom number formats.","url":"https://detect.halowerk.com/v1/F-TD2000-DOCUMENTS-07/ssf0112-spreadsheet-custom-number-date-display-reconstruction?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"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}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.003","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.003/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.003","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.003","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_K8Dz9WizPf9ynHTv0ZVja","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.003","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Reconstructs the display string a spreadsheet application would show for a given cell value and custom number/date format string.","exampleAgentPrompt":"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.","exampleUseCases":[{"title":"Audit Excel cell display values","prompt":"I have a spreadsheet with raw numeric cell values and their format codes — can you reconstruct what each cell would actually display, like '1,234.56' or '15-Jan-2023'? The date system is the standard 1900 mode."},{"title":"Validate custom currency format output","prompt":"What display string would a spreadsheet show for the value 1234567.89 with the custom number format '$#,##0.00_);[Red]($#,##0.00)'? The file doesn't use the 1904 date system."},{"title":"Reproduce legacy date formatting","prompt":"I'm migrating an old Mac Excel file that uses the 1904 date system — can you reconstruct what the cell value 35000 would display using the format 'M/D/YY h:mm AM/PM'?"}],"resultDescription":"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.","failureModes":["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"],"whenToPreferThis":"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.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-17T00:38:57.446Z","isFirstParty":false,"canonicalSlug":"spreadsheet-custom-number-format-display-reconstructor-d54f9788"}