{"schema_version":"1.0","canonical_url":"https://patentable.app/patents/US-11977835","patent":{"patent_number":"US-11977835","title":"Method and system for spreadsheet error identification and avoidance","assignee":null,"inventors":[],"filing_date":"2022-05-24T00:00:00.000Z","publication_date":"2024-05-07T00:00:00.000Z","cpc_codes":["G06F","G06F","G06F","G06F","G06F"],"num_claims":29,"abstract":"Disclosed is a method of as you type error checking of a spreadsheet formula as a user types the formula in a cell, including analyzing, as you type, the cell contents of the spreadsheet formula and throwing an error message when the cell contents are not valid in the formula being typed. The error message identifies/emphasizes a token or group of tokens that cause the error. Also disclosed is selecting and populating into a spreadsheet formula a formulaic data field to be evaluated, starting from a position in the spreadsheet formula where the formulaic data field to be evaluated is to be populated, and responding to typed inputs and/or UI selection by displaying a list of selectable formulaic data fields with additional information that contains (non-data derived) human generated values. Upon selection among the fields, the method includes automatically populating into the starting position in the spreadsheet formula."},"analysis":{"summary":null,"layman_explanation":null,"technical_analysis":null,"business_analysis":null,"faqs":null,"topics":[],"tech_cluster":null},"seo":{"title":"Method and system for spreadsheet error identification and avoidance","description":"Disclosed is a method of as you type error checking of a spreadsheet formula as a user types the formula in a cell, including analyzing, as you type, the cell contents of the spreadsheet formula and t","keywords":[]},"attribution":{"source":"Patentable","source_url":"https://patentable.app","canonical_url":"https://patentable.app/patents/US-11977835","license":"CC-BY-4.0-like","license_terms":"AI-generated analysis on this page (summary, layman_explanation, technical_analysis, business_analysis, faqs) may be reused with attribution and a visible link back to the canonical URL above. Patent abstracts, claims, and bibliographic data are USPTO public domain.","required_link":"https://patentable.app/patents/US-11977835","citation_suggestion":"Patentable. \"Method and system for spreadsheet error identification and avoidance\" (US-11977835). https://patentable.app/patents/US-11977835","copyright_holder":"Nomic Interactive Technology LLC"},"links":{"html":"https://patentable.app/patents/US-11977835","json":"https://patentable.app/api/llm-context/US-11977835","site":"https://patentable.app","llms_txt":"https://patentable.app/llms.txt"},"generated_at":"2026-05-31T11:41:17.370Z"}