| Class / Patent application number | Description | Number of patent applications / Date published |
|---|
| 715219000 | Particular calculation of cell content | 61 |
| 20090019350 | METHOD AND SYSTEM FOR PROCESSING ELECTRONIC TABLE DATA BASED ON TIME SEQUENCE - A method for processing electronic table data based on a time sequence comprises: after receiving processing request information for calculating a data object with a time attribute, reading basic period information in an electronic table, calculating result data according to calculation manner information in the processing request information, and determining a basic period contained in each calculation result data and a writing position of the calculation result data in the electronic table; and generating a computing formula for calculating the basic period contained in the calculation result data, calculating the data object by using the computing formula, and writing the calculation result data generated after calculation into the electronic table according to a requirement of the processing request information. A system for processing electronic table data based on a time sequence comprises: a position determination module and a calculation module. | 01-15-2009 |
| 20090044092 | Preventing the inclusion of a reference to a host cell in a formula - Preventing the inclusion of a reference to a host cell in a formula to avoid a circular reference in the formula is disclosed. In some embodiments, an indication of a selection or an attempted selection of a host cell into which a formula is being entered is received wherein the selection or attempted selection is made by a user via a user gesture associated with adding to a formula a reference to a selected cell or range of cells with respect to which the user gesture is made, and a reference to the host cell is not inserted into the formula in response to the indication. In some embodiments, a host cell is not allowed to be selected. | 02-12-2009 |
| 20090083615 | Spreadsheet Fields in Text - A system architecture integrates spreadsheet functionality into text. The architecture allows insertion of discrete individual fields, referred to as “free floating fields”, inline with normal textual sentences. In an HTML document, for example, the free floating fields are elements constructed along with text elements and rendered together as an integrated document. Once rendered, the free floating fields present contents that resemble normal text consistent with the surrounding text. The free floating fields offer spreadsheet functionality, including the ability to handle complex formulas, reference values in a separate free floating field or table, and automatically recalculate the formulas when a source value changes. | 03-26-2009 |
| 20090113284 | CALCULATION OF SPREADSHEET DATA - A workbook includes a spreadsheet having cells arranged in columns and rows. The cells include input cells and output cells. The output cells include a formula to be calculated. Calculation of the spreadsheet is divided into multiple tasks. The tasks are assigned among computing nodes within a computing cluster for concurrent calculation of the spreadsheet. | 04-30-2009 |
| 20090125796 | SYSTEM, MULTI-TIER INTERFACE AND METHODS FOR MANAGEMENT OF OPERATIONAL STRUCTURED DATA - The invention provides a computer implemented, methods, systems, software program devices, and a Multi-Tier Graphical Interface level General User Interface (GUI) screen designed to support data integration processes for IT and Subject Matter Experts User access and use of structured data sources. The software enables create, extract, transform, programs, processes, and load data integration application Data Integration Application (Composite Object)s through an object based software design enabling efficient and rapid retrieval, processing, and positioning of structured data directly from one or multiple data sources to the required formats, processes, and application support at the skills set levels of the user. The software is a command and processes design for Data Integration Application (Composite Object) that can be transaction oriented, recurring process, as well as periodic The software is an open, data oriented system design for rapid generation and support of Data Integration Application (Composite Object)s using a Multi-Tier three dimensional graphical interface design for cell based data applications. The Data Integration Application (Composite Object) are compiled, independent object applications residing in an object library designated by the user/user IT organization. The compiled data application object are run on the organization's existing computing systems under standard compute processing procedures as either independent applications or in support of the organizations ongoing business/operational requirements for data use requirements. | 05-14-2009 |
| 20090235154 | Method, system, and apparatus for providing access to workbook models through remote function calls - A method, system, and apparatus are provided for exposing and calling workbook models via remote function calls. According to the system, a client computer executes a spreadsheet program for creating a workbook model. The workbook model may be published to a server computer along with data defining a function name and the cells that should be used as inputs and outputs to the model. The system also includes a server computer that receives and responds to remote function calls directed toward workbook functions. When a function call is received at the server computer for a workbook function, the server computer populates the cells in the workbook identified as inputs with input parameters received with the function call and recalculates the workbook. The data contained in the output cells is then returned as a reply to the remote function call. | 09-17-2009 |
| 20090271693 | ASYNCHRONOUS USER DEFINED FUNCTIONS - A framework for enabling users to create User Defined Functions (UDFs), which can run simultaneously without using multiple calculation threads, is provided. A calculation engine continues a remainder of calculation operations independent of a pending asynchronous function upon starting to run the asynchronous function without waiting to receive a result. The result value is introduced to the computation at a later time during the calculation cycle, when it is received or completed by the calculation engine. When the results are received, downstream operations such as dependent functions are calculated without changing a flow of dependencies within the operations. | 10-29-2009 |
| 20090271694 | AUTOMATED DETECTION OF NULL FIELD VALUES AND EFFECTIVELY NULL FIELD VALUES - Disclosed are systems for, and methods of, automatically detecting and treating field values of a particular field as null field values in records of a database. The system and method provide automatic treatment of these field values as null field values by calculating a critical frequency for the field. Based on the critical frequency of the field, the system and method treats field values that occur more than the critical frequency of the field as null field values and treats field values that occur less than the critical frequency as non-null field values. | 10-29-2009 |
| 20090282326 | Process for obtaining a result between a first numerical value and a second numerical value which are separated by a common character in a spreadsheet - A process for obtaining a result between a first numerical value and a second numerical value which are separated by a common character using a formulas in a plurality of cells of a spreadsheet is provided. If a user selects, copies and pastes a data from an application software to the spreadsheet, and the data have the common character between the two numerical values, the result is obtained using the formulas in the plurality of cells without utilizing a worksheet program for converting text to column. If the user selects, copies and pastes a new data from the application software to the spreadsheet, with this process the result is obtained using less instructions in the spreadsheet than the worksheet program to convert text to column. | 11-12-2009 |
| 20090319880 | UTILIZING SPREADSHEET REFERENCES WITH GROUPED AGGREGATE VIEWS - Various technologies and techniques are disclosed for utilizing spreadsheet references with grouped aggregate views. A grouped aggregate view feature enables a user to create a grouped aggregate view of data. A calculation feature enables the user to calculations for the grouped aggregate view of data that are based upon relative or absolute references to data in the grouped aggregate view. Input is received from a user to write a calculation within a first cell in a grouped aggregate view. Input is received from the user to select a second cell to reference when writing the calculation. The user is presented with available references that are relevant to data contained in the second cell. Input is received from the user to select one of the available references that are relevant for the second cell. The selected one of the available references is placed into the first cell. | 12-24-2009 |
| 20100083090 | Context sensitive computations - 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. | 04-01-2010 |
| 20100107048 | DOCUMENT PROCESSOR AND DOCUMENT PROCESSING METHOD - A document processing apparatus includes a spreadsheet unit which processes, in a spreadsheet sheet format, a document described in a markup language. The spreadsheet unit includes: a display unit which displays, in a spreadsheet format, data which is contained in a document and which is described in a tag set defined for a spreadsheet; and an editing unit which inserts, into the spreadsheet, data which is contained in the document and which is described in a tag set that differs from the tag set for the spreadsheet. | 04-29-2010 |
| 20100169759 | SYSTEMS AND METHODS TO CREATE A MULTIDIMENSIONAL EXPRESSION CALCULATED MEMBER IN A SPREADSHEET CELL - According to some embodiments, a system, method, means, and/or computer program code are provided to facilitate use of a spreadsheet application to access information stored in a multidimensional data source. Some embodiments include receiving, at an analyzer module, a change indication from the spreadsheet application. The change indication may be, for example, associated with a spreadsheet formula of the spreadsheet application entered by a user into a spreadsheet cell. In response to the change indication, the spreadsheet formula may be translated into a multidimensional expression calculation associated with the multidimensional data source. The spreadsheet formula in the spreadsheet cell may then be automatically replaced with information associated with the multidimensional expression calculation. | 07-01-2010 |
| 20100180189 | INFORMATION PROCESSING METHOD AND APPARATUS, PROGRAM, AND STORAGE MEDIUM - An information processing method comprises the steps of: inputting an input information of a multi-dimensional array; calculating an accumulated information value corresponding to a position of each element of the input information; and holding the accumulated information value in a buffer having a size of predetermined bits, wherein in the holding step, when an accumulated information value calculated in the calculating step overflows with respect to the size, a part not more than the predetermined bits of the calculated accumulated information value is held as the accumulated information value. | 07-15-2010 |
| 20100251091 | AUTOMATED DYNAMIC DIFFERENTIAL DATA PROCESSING - A request for differential data relative to a first data element within a group of data elements is received via a user input device. A first differential data value for each of the group of data elements relative to the first data element is calculated. The first differential data value for each of the group of data elements relative to the first data element are displayed on a display in response to the received request. This abstract is not to be considered limiting, since other embodiments may deviate from the features described in this abstract. | 09-30-2010 |
| 20100262900 | UTILIZING SPREADSHEET USER INTERFACES WITH FLOWSHEETS OF A CPI SIMULATION SYSTEM - A simulation system includes at least one processor configured to execute a computer program product, stored upon a storage medium. The computer program product includes a spreadsheet application, a process simulation application, and an integration tool (e.g., eSim), where the spreadsheet application and the process simulation application are discrete, stand alone products. The process simulation application can simulate chemical processes using at least one flowsheet, which models a general flow of chemical plant processes and equipment. The integration tool can map process simulation application objects and properties to spreadsheet application objects, can convey information between mapped objects, can perform case management functions, and can perform orchestrated calculation functions. | 10-14-2010 |
| 20100293450 | SYSTEM AND METHOD FOR SIMULATING DISCRETE FINANCIAL FORECAST CALCULATIONS - A method is provided for creating a simulated spreadsheet. The method includes receiving information from a simulated spreadsheet template, separating the simulated spreadsheet template from information within the simulated spreadsheet template, storing the simulated spreadsheet template and the corresponding information separately, calculating any calculable information within the information by using spreadsheet formula syntax, and presenting a simulated spreadsheet that includes the calculated information. | 11-18-2010 |
| 20110016379 | System and Methodology for Data Processing Combining Stream Processing and Spreadsheet Computation - A system and methodology for data processing combining stream processing and spreadsheet computation is described. In one embodiment, a system for data processing combining stream processing and spreadsheet computation comprises: one or more Cloudscale Stream Processors (CSPs), a Cloudscale-enabled spreadsheet, a web services architecture, and one or more data sources. Each CSP takes a set of streams of input data and outputs a set of streams of data. Each stream is a time-ordered stream of files which when concatenated together comprise the stream. The Cloudscale-enabled spreadsheet is used to provide a wide range of complementary capabilities that together with the CSPs provides a comprehensive and powerful data processing architecture. | 01-20-2011 |
| 20110022939 | Structure oriented graphical patchwork application environment - A graphical application developing and managing environment is described capable of representing and editing program modules using multiple display formats, which include embedding source code written in a functional language into a spreadsheet-like format. Methods are described for enabling the sharing of program modules by defining standardized interfaces into program modules and existing documents and by centrally locating module definitions. A patchwork mechanism is described requiring only basic spreadsheet editing skills on behalf of the user, enabling a user of the environment to connect external documents and program modules into a new program application. The invention allows complicated programming and simple end user programming to be achieved within a unified environment and allows the execution of program modules and tracing of variables simultaneously with the writing of a program application. The invention defines methods for representing the various parts of a source code, defining a program application, along with the application icon as determined by a user creating the application and thereby making parts of the source code accessible to end-users for run-time execution. | 01-27-2011 |
| 20110055681 | PARSER, CODE GENERATOR, AND DATA CALCULATION AND TRANSFORMATION ENGINE FOR SPREADSHEET CALCULATIONS - A system including spreadsheet sheets, makes calculations and data transformations, which is available through a programming interface, and conforms to the grammar and syntax of a target software development language is presented. The system includes an Object Model with Data Structures representing entities involved in spreadsheets. The system includes a Parser and Code Generator that extracts data from a body of spreadsheet data, instantiates instances of Data Structures of the Object Model to represent the spreadsheet data, parses the data and formulas contained in the cells of the spreadsheets, iterates through the instantiated instances of the Data Structures, and generates source code that performs the calculations and data transformations embodied in the spreadsheet data. The system includes a Calculation Engine with software base classes that implement the common structural and data access features of spreadsheet data, and further implement the operations of common spreadsheet functions and operators. | 03-03-2011 |
| 20110087954 | DATA ANALYSIS EXPRESSIONS - Methods and systems are disclosed for receiving and processing data analysis expressions. A particular method includes receiving a data analysis expression at a pivot table of a spreadsheet. The data analysis expression is executed for a particular cell of the pivot table by determining a context associated with the particular cell, calculating a value of the data analysis expression based on the context, and outputting the calculated value at the particular cell. | 04-14-2011 |
| 20110167330 | DYNAMICALLY FILTERING AGGREGATE REPORTS BASED ON VALUES RESULTING FROM ONE OR MORE PREVIOUSLY APPLIED FILTERS - Methods, systems, and computer program products dynamically filter an aggregate report based on values resulting from one or more filters previously applied to the aggregate report. A method involves maintaining a collection of filters to be applied in a designated evaluation order to the aggregate report, applying a first filter to the aggregate report, and evaluating values in the aggregate report to produce aggregate values resulting from applying the first filter. The method also involves applying a next filter to the aggregate report and evaluating the aggregate values in the aggregate report resulting from applying the first filter therein producing aggregate values resulting from applying the next filter to the aggregate report. Additionally, the method involves displaying the aggregate report wherein evaluating values resulting from previously applying any filter to the aggregate report involves evaluating visual values displayed in the aggregate report after each previous filter has been applied. | 07-07-2011 |
| 20110191665 | SYSTEM AND METHOD FOR DYNAMIC DATA ACCESS IN A SPREADSHEET WITH EXTERNAL PARAMETERS - In one aspect, the present invention relates to utilizing a spreadsheet by defining a parameter external to the spreadsheet and associating the parameter with the spreadsheet to define a parameterized workbook. In one embodiment, this utilization further comprises storing a location of the spreadsheet and storing the name of the parameter in the same storage module as the location. In another embodiment, it includes defining a result external to the spreadsheet, the result referencing one or more cells within the spreadsheet. In another embodiment, this utilization further comprises receiving a value for the parameter and generating the result based at least in part on the value and the spreadsheet. In another embodiment, it further comprises associating a type with the parameter. The type can define a range of values or attributes associated with the parameter. | 08-04-2011 |
| 20110276870 | CALCULATION OF SPREADSHEET DATA - A workbook includes a spreadsheet having cells arranged in columns and rows. The cells include input cells and output cells. The output cells include a formula to be calculated. Calculation of the spreadsheet is divided into multiple tasks. The tasks are assigned among computing nodes within a computing cluster for concurrent calculation of the spreadsheet. | 11-10-2011 |
| 20110314365 | DECOMPILING LOOPS IN A SPREADSHEET - The present invention extends to methods, systems, and computer program products for decompiling loops in a spreadsheet. Embodiments of the invention detect loops by walking a dependency graph on a spreadsheet. As nodes are encountered, sequences of the same formulas are looked for in a normalized representation of the spreadsheet (e.g., R1C1 notation). When the same formulas are identified, the formulas may represent a loop. The spatial structure of the cells is analyzed to determine which cells are to be stored in arrays and which cells can be loop carried dependencies. | 12-22-2011 |
| 20120072820 | Systems and Computer Program Products for Conducting Multi-Window Multi-Aspect Processing and Calculations - A data processing system comprises an object manager maintaining two or more uniquely named objects in an object repository, each of the two or more uniquely named objects comprising at least a formula and a value, the value being determined by the formula, a graphical user interface displaying two or more windows, each of the two or more windows corresponding to exactly one named object of the two or more uniquely named objects and displaying within the each window one or more of the name, formula, and value associated with the exactly one named object, and a calculation engine for determining the value of each object responsive to changes in the formula or value of any of the two or more uniquely named objects. | 03-22-2012 |
| 20120110428 | SPREADSHEET MODEL FOR DISTRIBUTED COMPUTATIONS - A spreadsheet model is employed to facilitate distributed computations. Spreadsheets and cells are generalized to correspond to arbitrary data sources that can be remote from each other, among other things. Functions can be specified with respect to these arbitrary data sources to produce combinations of data or mashups, for example, wherein changes initiate re-computation with respect to dependent data sources. | 05-03-2012 |
| 20120117454 | PREVENTING THE INCLUSION OF A REFERENCE TO A HOST CELL IN A FORMULA - Preventing the inclusion of a reference to a host cell in a formula to avoid a circular reference in the formula is disclosed. In some embodiments, an indication of an attempted user gesture for inserting into a formula being entered into a host cell a reference to the host cell is received, and the attempted user gesture for inserting a reference to the host cell is disallowed to prevent a circular reference from being inserted into the formula being entered into the host cell. | 05-10-2012 |
| 20120137204 | AUTOMATIC SPREADSHEET VALIDATION - A spreadsheet validation method may provide a validation input value to an input field of a computer spreadsheet application and identify a calculated result from an output field of the computer spreadsheet application. The result is calculated based on a formula associated with the output field and the formula uses the validation input value as an input. Further, the calculated result may be compared to an expected validation output value. | 05-31-2012 |
| 20120144284 | SYSTEMS AND METHODS TO PROVIDE DYNAMIC LOCAL MEMBERS ASSOCIATED WITH AN ADD-IN FOR A SPREADSHEET APPLICATION - According to some embodiments, a system, method, means, and/or computer program code are provided to facilitate use of a spreadsheet application to access information stored in a multidimensional data source. Some embodiments include determining, at an add-in module, that a local member is to be attached to an attachment element of a report generated based on the multidimensional data source. The add-in module may receive a refresh indication from the spreadsheet application and dynamically update a reference in a spreadsheet cell based on a change associated with the attachment element. | 06-07-2012 |
| 20120192052 | HYBRID CLIENT/NETWORK SERVICE APPLICATION INTEGRATION - A client application uses a network service to perform calculations involving non-local data. A client application performs calculations relating to local data and the network service performs calculations relating to the non-local data. For example, a client spreadsheet application sends a command to the network service for performing calculations in a spreadsheet workbook that use data that is non-local to the client spreadsheet application. The calculation engine of the network service performs the calculations for the workbook relating to the non-local data and sends the results of the calculations back to the client application. The client application integrates the results received from the network service with any locally calculated results performed by the client application. | 07-26-2012 |
| 20130055058 | Animation for Recalculating Formulas, Sparklines and Conditional Formatting in an Electronic Document - Animation for the recalculation of formulas in a spreadsheet may be provided. A user interface may be displayed on a computer for updating formula output values. The computer may then receive an update of formula input values in a formula utilized for generating the formula output values. The computer may then animate a display the formula output values being replaced with recalculated formula output values based on the received update. Animation for sparklines and conditionally formatted content in a spreadsheet may also be provided. A user interface may be provided for displaying sparklines and conditionally formatted content in the spreadsheet. The computer may then receive an update of one or more values associated with the sparklines and the conditionally formatted content. The computer may then animate a change in the display of the sparklines and the conditionally formatted content based on the received update. | 02-28-2013 |
| 20130067305 | COMPLEX FUNCTION GENERATOR - A method of creating a user defined function (UDF) in a data processing application program comprising inserting a formula into the application program; assigning a UDF identifier to said formula; and storing said UDF identifier in a complex function generator configured to call said formula responsive to a reference to said UDF identifier in the application program. | 03-14-2013 |
| 20130104020 | Drag and Drop Always Sum Formulas - Inserting a formula at a location on a content surface in a user interface is provided. A user interface showing a status bar which includes one or more predetermined calculations may be displayed on a computer. The computer may receive a selection of a predetermined calculation from the status bar in the user interface. The selected predetermined calculation may then be dragged from the status bar and inserted at a drop location on the content surface in the user interface. The computer may then automatically generate a formula corresponding to the selected predetermined calculation in the user interface. | 04-25-2013 |
| 20130346844 | CHECKING AND/OR COMPLETION FOR DATA GRIDS - Checking and/or completing for data grids is described such as for grids having rows and columns of cells at least some of which contain data values such as numbers or categories. In various embodiments predictive probability distributions are obtained from an inference engine for one or more of the cells and the predictive probability distributions are used for various tasks such as to suggest values to complete blank cells, highlight cells having outlying values, identify potential errors, suggest corrections to potential errors, identify similarities between cells, identify differences between cells, cluster rows of the data grid, and other tasks. In various embodiments a graphical user interface displays a data grid and provides facilities for completing, error checking/correcting, and analyzing data in the data grid. | 12-26-2013 |
| 20140157098 | SYSTEM FOR THE INTERACTION AMONG SPREADSHEETS OVER NETWORKS - By means of this system, the interaction among spreadsheets is completely integrated within the Spreadsheet Management System whereas it does not require the usage of other tools supporting the communication over a network such as web browsers, mailers, and file transfer clients. The interaction is implemented by the Enabling Platform, integrated within the Spreadsheet Management System, and by the Service Platform, located on a computing system that can be reached over the Internet or on a different private network making the Service Platform's intervention not visible to users. | 06-05-2014 |
| 20140164897 | Constraint-Choice-Action Matrix for Decision Making: Apparatus and Method - The present invention is an apparatus and method for constructing a Constraint-Choice-Action Matrix for making decisions based on constraints. Columns (in one matrix orientation) state conditions. The column header presents a partial boolean expression. Such variable expression may be any object or type, e.g., a number, string, or list. An entry in a cell, selected using a GUI pick-list, combines with the column header, to complete the boolean expression. The set of boolean expressions in a row may be combined into an action boolean statement. If that statement evaluates to true, some action, represented as a row header, is recommended or executed. The matrix is applied to an instance of a context domain, for decision-making. The context domain may be represented in a model representing an instance of that domain (e.g., a product specification for configuration of a machine) in data and rules. | 06-12-2014 |
| 20140173402 | TABLE MANIPULATION - A computer system receives a request to combine tabular data of a first table with tabular data of a second table. The computer system creates a profile for the second table indicating organization of types of data within the second table. The computer system determines a placement for at least one data element of the tabular data of the first table, into the second table, such that the placement agrees, to at least a specified confidence level, with the organization of types of data within the second table indicated by the profile. The computer system adds the at least one data element to the second table based on the determined placement. | 06-19-2014 |
| 20140173403 | TABLE MANIPULATION - A computer system receives a request to combine tabular data of a first table with tabular data of a second table. The computer system creates a profile for the second table indicating organization of types of data within the second table. The computer system determines a placement for at least one data element of the tabular data of the first table, into the second table, such that the placement agrees, to at least a specified confidence level, with the organization of types of data within the second table indicated by the profile. The computer system adds the at least one data element to the second table based on the determined placement. | 06-19-2014 |
| 20140237340 | DYNAMIC LOADING OF TABULAR DATA - Dynamic data loading of tabular data includes identifying a plurality of formulas within tabular data of a document, wherein the tabular data is arranged in cells. Using a processor, a hierarchy for the tabular data is determined according to cell dependencies defined in the formulas. Each of a plurality of different portions of the document is sent from a first computing system to a second computing system in an order determined from the hierarchy. | 08-21-2014 |
| 20140337704 | SYSTEM AND METHOD FOR CONVERTING BETWEEN DATA FORMATS - A system and a method for converting between data formats converts air flow data from a thermal simulation tool into a format readable by a DC power analyzing tool. Air flow data associated with the locations of certain points on a printed circuit board are taken and an EXCEL document including Main, Data, and Final worksheets is created. The data to be converted is obtained, and the data imported into the Data worksheet. Parameters in the Main worksheet to set an analysis area of the printed circuit board are set, and air flow data associated with the analysis areas from the Data worksheet are obtained and divided into groups, according to the parameters set in the Main worksheet. An equivalence value for each group of data is calculated and the equivalence values are saved in the Final worksheet for reading by the DC power analyzing tool. | 11-13-2014 |
| 20140372854 | Smart Selection Engine - A smart selection engine is provided. The smart selection engine may run in the context of a spreadsheet application on any device, service, or general endpoint capable of running the spreadsheet application. The smart selection engine reduces the cognitive load and complexity for performing spreadsheet operations by clearly presenting the user with easy to use and understand options that are big, simple, and lend themselves nicely to natural user interfaces, touch enabled devices, and devices with small displays as well as with graphical user interfaces, larger displays, and traditional input devices. By making contextually based suggestions, the smart selection engine reduces or eliminates the need for the user to be aware of the available operations or how to perform the operations. Further, the smart selection engine improves the consistency and efficiency of working with a spreadsheet. | 12-18-2014 |
| 20150019945 | SYSTEMS, METHODS AND MACHINE READABLE MEDIUMS FOR DEFINING AND EXECUTING NEW COMMANDS IN A SPREADSHEET SOFTWARE APPLICATION - Systems, methods and machine-readable mediums for defining and executing new commands in a spreadsheet application are provided. A method may include receiving a declaration command in a first spreadsheet cell. The declaration command identifying a command name for the new command and operations performed for the command name based on a plurality of second spreadsheet cells. A system may include a processor programmed to evaluate the declaration command in the first spreadsheet cell according to the instructions stored in a storage device, receive the command name and at least two parameters identifying at least one input spreadsheet cell and at least one output spreadsheet cell of the spreadsheet application, create a new command for the spreadsheet application, and evaluate the new command as identified by the command name in a second spreadsheet cell for execution. The computer readable mediums provide instructions to cause the processor to perform the operations above. | 01-15-2015 |
| 20150019946 | INTEGRATED, CONFIGURABLE, SENSITIVITY, ANALYTICAL, TEMPORAL, VISUAL ELECTRONIC PLAN SYSTEM - An integrated, configurable, sensitivity, analytical, temporal, visual system for an electronic plan system including stored in a memory and configured to be executed by one or more processors. The programs include instructions to generate: an electronic plan including one or more row descriptors each including a plurality of row descriptor properties, one or more column descriptors each including a plurality of column descriptor properties, one or more cells mapped to one of the row descriptors by a unique row descriptor identifier and to one of the of one of the column descriptors by a unique column descriptor identifier, and each of the one or more cells including a numeric formula or a user-defined formula that references one or more other cells. An interpreter is configured to read each formula of the one or more cells and determine dependency data associated with each cell. A calculation engine responsive to the interpreter is configured to determine a numeric value of each of the one or more cells, and a sensitivity analyzer responsive to a configurable user-initiated change to a value of a start cell is configured to activate the calculation engine to calculate the value of dependent cells affected by said change and visually highlight the dependent cells affected by the change in a predetermined sensitivity format. | 01-15-2015 |
| 20150019947 | Multi-Client Collaboration to Access and Update Structured Data Elements - Tools and techniques for providing multi-client collaboration to access and update structured data elements are disclosed. Client systems may present user interfaces that provide libraries of published data elements that are available for collaboration. The clients may request selected data elements, while referencing unique identifiers associated with the selected data elements. Those clients that publish data elements for collaboration by others may present user interfaces that provide representations of candidate structured data elements, and receive selections of those data elements chosen for publication. The publishing clients may then send the selected data elements for publication. The client systems may interact with servers or collaboration services, which may receive structured data elements that the clients have published for access by others. The servers may define respective unique identifiers for the published data elements, and may send the structured data elements and corresponding unique identifiers to various client systems. | 01-15-2015 |
| 20150113378 | TECHNIQUES TO PRESENT A DYNAMIC FORMULA BAR IN A SPREADSHEET - Various embodiments are generally directed to techniques and apparatuses to present a dynamic formula bar in a spreadsheet application. Some embodiments are particularly directed to presenting a dynamic formula bar in a spreadsheet application that may improve usability in particular with large display sizes and/or touchscreen interfaces. In one embodiment, for example, an apparatus may comprise a processor circuit and a spreadsheet user interface (UI) component executing on the processor circuit to present a grid comprising cells arranged in rows and columns. The spreadsheet UI component may include a formula bar interface component operative to display a formula bar UI element adjacent to a first cell in response to receiving a control directive selecting the first cell. Other embodiments are described and claimed. | 04-23-2015 |
| 20150293894 | INTEGRATED, CONFIGURABLE, SENSITIVITY, ANALYTICAL, TEMPORAL, VISUAL ELECTRONIC PLAN SYSTEM - An integrated, configurable, sensitivity, analytical, temporal, visual system for an electronic plan is generated. An interpreter is configured to read each formula of the one or more cells in the plan and determine dependency data associated with each cell. A calculation engine responsive to the interpreter is configured to determine a numeric value of each of the one or more cells, and a sensitivity analyzer responsive to a configurable user-initiated change to a value of a start cell is configured to activate the calculation engine to calculate the value of dependent cells affected by said change and visually highlight the dependent cells affected by the change in a predetermined sensitivity format. | 10-15-2015 |
| 20150309980 | A FRAMEWORK FOR ENABLING USER-DEFINED FUNCTIONS - A computer program product for use in conjunction with a spreadsheet application program comprises a framework having a library of defined functions. The spreadsheet application is, in use, executed in a first process in memory on a computer and the function is, in use, held in a second process, which second process is independent of the first process. The or each user defined function is adapted to be called from a cell in the spreadsheet application, the function being evaluated or executed in the second process to return a value which is shown in the cell. This reduces the memory footprint of the application and results in a more stable computer system. | 10-29-2015 |
| 20150347373 | REPRESENTATION OF PEOPLE IN A SPREADSHEET - A spreadsheet includes a native spreadsheet object that represents a person. The person object may be used within a spreadsheet just as any other spreadsheet objects are utilized. For example, the person object may be integrated with spreadsheet formulas and other spreadsheet objects such as charts, tables, pivot tables, sheets, and the like. Spreadsheet formulas may perform operations specific to a person object (e.g. send message, get contact information, get status, get other person specific information, sort, and the like). Common actions may be associated with the person object, such as initiating communication with the person represented by the person object (e.g. phone call, email, text message, collaboration invite, and the like). Social networking information may also be associated with a person object. For example, social networking posts may be included within a spreadsheet, a user may post to a social network from the spreadsheet, and the like. | 12-03-2015 |
| 20150378977 | SYSTEM AND METHOD FOR OPERATING A COMPUTER APPLICATION WITH SPREADSHEET FUNCTIONALITY - The present invention provides a method for operating a computer application with spreadsheet functionality. The method comprising receiving one or more inputs in one or more cells by the spreadsheet application, parsing the received inputs for the one or more cells of the spreadsheet, constructing a dependency graph for the one or more parsed input cells, evaluating at least one of the one or more parsed input cells based on one or more criteria in the dependency graph, reconstructing the dependency graph until all of the one or more input cells are evaluated, and returning an output to the spreadsheet application. | 12-31-2015 |
| 20150378978 | SUMMARY DATA AUTOFILL - Technologies are described herein for summary data autofill. A device executes an application program configured to receive data input. The application program may determine a portion of the data may be aggregated or conducive to being summarized. Upon the detection of a user input of additional data into a document having data contained therein, the application program may display a suggested complete summary of the data. An input may be received to accept the suggested complete summary, whereby the manner in which the suggested complete summary is displayed may be changed to indicate the acceptance of the suggested complete summary. A confidence level that the suggested complete summary is a correct summary of the data may be determined. The confidence level may be adjusted based on further input of data or additional data. | 12-31-2015 |
| 20150378980 | DATABASE MANAGEMENT SYSTEM BASED ON A SPREADSHEET CONCEPT DEPLOYED IN AN OBJECT GRID - A method for interacting with a database stored in an object grid is described. The database is given attributes of a spreadsheet. Elements stored in the database are represented and addressed as cells of a spreadsheet. Cells can store data objects, including formulas, and executable scripts. The spreadsheet can evaluate formulas, carry out the program instructions of executable scripts, and perform complex event processing. Interaction with the spreadsheet is accomplished through the use of structured data messages which include instructions, spreadsheet and cell addressing and, optionally, data elements. | 12-31-2015 |
| 20150378981 | REFERRING TO CELLS USING HEADER CELL VALUES - Referring to cells using header cell values is disclosed. In some embodiments, a header cell value of a header cell is allowed to be used to refer to one or more other cells that are associated with the header cell. The header cell may be included in a header row or column included in a table. A header row cell value may be employed to refer to one or more other cells in a corresponding column, and a header column cell value may be employed to refer to one or more other cells in a corresponding row. | 12-31-2015 |
| 20160004684 | VALIDATION OF FORMULAS WITH EXTERNAL SOURCES - A method validates a formula within a spreadsheet. A formula type, of an identified formula from a spreadsheet, is identified. A database of known accurate formulas, whose type matches a formula type of the identified formula within the spreadsheet, is identified and located. A determination is made as to whether the identified formula from the spreadsheet matches a known accurate formula from the database. In response to the identified formula from the spreadsheet failing to match the known accurate formula from the database, a predefined action is initiated. | 01-07-2016 |
| 20160026616 | PRESENTING DATASET OF SPREADSHEET IN FORM BASED VIEW - A dataset of a spreadsheet is presented in a form based view. The dataset is detected in the spreadsheet. The dataset is configurable for presentation as a form. The dataset is converted into the form. Rows of the dataset are allocated as entries of the form. Cells of a row are allocated as elements of an entry. The form is presented in a form view. Controls are presented to provide an edit operation, a delete operation, a create operation, among others to allow interactivity with the dataset in the form. | 01-28-2016 |
| 20160041964 | System and Method for Providing Calculation Web Services for Online Documents - Embodiments of the present disclosure provide a method and system for providing additional functionality, including web functionality, to one or more online documents. Specifically, embodiments described herein include receiving a selection of a range of data to be used in a web extension and binding the selection of the range of data to the web extension. Once the data is bound, the binding is stored in a remote computing device. In response to the detection of the interaction with the bound range of data, the bound range of data is sent to the remote computing device where the bound range of data is updated based on the interaction. The updated data is then sent to the web extension to enable the web extension to be updated with the newly received data. | 02-11-2016 |
| 20160085738 | Cloud-Based Parallel Computation Using Actor Modules - A cloud-based computing system is described herein for executing an application using an actor model programming paradigm. The computing system provides plural actor modules that correspond to activated instantiations of at least one actor module type. In one implementation, at least a subset of the actor modules have counterpart user interface (UI) interaction units, presented via a client-side application module, through which an end user may interact with the subset of the plural actor modules. The computing system also includes functionality for parallelizing computations performed by an actor module, receiving input information from external sources, associating an aggregate item (having plural entry items) with a single actor module, and so on. | 03-24-2016 |
| 20160092424 | CLIENT SIDE CALCULATIONS - A computer-implemented method can include creating an adhoc grid responsive to a user request, adding an extra row to the adhoc grid responsive to another user request, entering into the extra row a cell formula specified by the user, and saving the adhoc grid as a SmartForm. | 03-31-2016 |
| 20160117309 | TOKEN REPRESENTATION OF REFERENCES AND FUNCTION ARGUMENTS - A token representation of references and function arguments is disclosed. In some embodiments, an indication that a formula is being entered into a cell is received, and references and/or function arguments in the formula, if any, are represented as tokens. Each token comprises an atomic user interface object. In various embodiments, references are rendered as reference tokens and function arguments are rendered as argument tokens and/or mode tokens. | 04-28-2016 |
| 20160132481 | DATA ANALYSIS EXPRESSIONS - Methods and systems are disclosed for receiving and processing data analysis expressions. A particular method includes receiving a data analysis expression at a pivot table of a spreadsheet. The data analysis expression is executed for a particular cell of the pivot table by determining a context associated with the particular cell, calculating a value of the data analysis expression based on the context, and outputting the calculated value at the particular cell. | 05-12-2016 |
| 20190147031 | Methods And Systems For Connecting A Spreadsheet To External Data Sources With Ordered Formulaic Use of Data Retrieved | 05-16-2019 |
