Spreadsheet Context-Sensitive Computations for Formatted Data
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing spreadsheet applications fail to accurately handle formatted data types such as dates, durations, and currencies, leading to nonsensical or incorrect results due to internal representation issues and lack of unit consideration in computations.
Innovation Solution
Defining each data type (durations, dates/times, currencies) as distinct data types with associated semantics to specify permissible operations and unit handling, ensuring accurate and meaningful results by converting values to a common unit or executing operations on unitless values when units are ambiguous.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Device complexity
If formatted numbers are internally represented as plain numbers for simplicity, then device complexity is reduced, but measurement precision deteriorates leading to nonsensical computation results
Solution Approach 1:
The patent embeds unit information within the number structure itself. Each number is represented as a pair (value, unit) where the unit is nested inside the number representation. This allows the system to maintain simple numeric operations while preserving unit context, resolving the contradiction between representation simplicity and computation accuracy.
Solution Approach 2:
The patent introduces unit tags as intermediary elements between the numeric value and the computation process. These unit tags act as mediators that guide arithmetic operations, ensuring that computations respect unit semantics. The intermediary unit information prevents nonsensical operations while maintaining the simplicity of numeric storage.
2Adaptability or versatility
If all number formats are treated as the same data type for versatility, then adaptability is improved, but reliability deteriorates due to incorrect operations
Solution Approach 1:
The patent applies local quality by associating specific unit characteristics with each number based on its unit tag. Different unit types (currency, duration, date) have different local rules for permissible operations. This allows the system to maintain general versatility while enforcing local reliability constraints specific to each number format.
Solution Approach 2:
The patent changes the parameter space by adding unit tags to numbers, transforming them from simple values to structured entities with semantic properties. This parameter enrichment enables the system to distinguish between different number formats and apply appropriate operation rules, improving reliability without sacrificing versatility.
3Ease of operation
If unit information is ignored in computations for ease of operation, then ease of operation is improved, but measurement precision deteriorates
Solution Approach 1:
The patent implements self-service by enabling numbers to carry their own unit information intrinsically. Each number automatically knows its unit through the nested unit tag, eliminating the need for external unit tracking. This self-contained approach maintains operational simplicity while ensuring unit precision through automatic unit awareness.
Data Source
AI summary
Context sensitive computations in a spreadsheet application are disclosed. In some embodiments, semantics with respect to various spreadsheet operations are specified for each of a plurality of number formats in a spreadsheet application. The semantics associated with a particular number format specify behavior for values of that number format with respect to various spreadsheet operations.