Method and System for Dynamic Naming of Component Expressions Within a Formula in a Cell in a Spreadsheet Application

    公开(公告)号:US20240070382A1

    公开(公告)日:2024-02-29

    申请号:US16599895

    申请日:2019-10-11

    Inventor: Sandeep Dayal

    CPC classification number: G06F17/246 G06F16/903 G06F17/2705

    Abstract: Methods and systems are provided for giving a name to an expression within a cell formula so that the said expression can be represented by the given name in all subsequent references within the cell formula in a spreadsheet application. In the edit mode, a user may enter any expression within a formula by its given name after defining it once anywhere in that formula. In the view mode, the cell formula may display all named expressions by their given names, with the definitions of the said names displayed as sub-formulas along with the computed value of the expressions. Features may be implemented as an add-in, a macro, a function, a direct modification of the spreadsheet application, or any combination thereof. Implementations may be used with electronic spreadsheet applications generally, including programs such as Microsoft Excel, Google Sheets, Lotus 123, but not limited to such.

    NATIVELY HANDLING APPROXIMATE VALUES IN SPREADSHEET APPLICATIONS

    公开(公告)号:US20190251158A1

    公开(公告)日:2019-08-15

    申请号:US16005469

    申请日:2018-06-11

    CPC classification number: G06F17/246 G06F3/04847

    Abstract: Technology is disclosed herein for handing approximate (or uncertain) values in spreadsheet applications. More specifically, the technology describes spreadsheet applications that support arrays or sets of approximate (or uncertain) values as native entities. An approximate (or uncertain) value may be the value of a cell of the spreadsheet that is resolvable by formula, charts and other functionalities. In some implementations, approximate values may include a range of data and a probability distribution that can be automatically created by the spreadsheet application, generated based on context, input by the user, etc. Because the approximate (or uncertain) value is natively available, it can be incorporated in a spreadsheet like other values. Additionally, the approximate (or uncertain) values can automatically propagate through a spreadsheet calculation to obtain a final approximate result. The techniques also describe various ways to represent uncertain values in cells and to visualize the probability distribution.

    DEPENDENCY-BASED PRESENCE FOR CO-AUTHORED DOCUMENTS

    公开(公告)号:US20190212878A1

    公开(公告)日:2019-07-11

    申请号:US15868831

    申请日:2018-01-11

    Inventor: Carlos Otero

    Abstract: In non-limiting examples of the present disclosure, systems, methods and devices for assisting with providing a dependency-based presence indication are presented. An indication that a first application instance of a co-authored file is active may be received. An indication that a second application instance associated with the co-authored file is concurrently active with the first application instance may be received. A data-modification indication that data affecting at least one object displayed on a user interface of a computing device executing the first application is being accessed by a second computing device executing the second application may be received. The at least one object may be caused to be highlighted on the user interface of the computing device executing the first application instance based on the received data-modification indication.

    Spreadsheet-Based Software Application Development

    公开(公告)号:US20190187962A1

    公开(公告)日:2019-06-20

    申请号:US16254155

    申请日:2019-01-22

    Inventor: Thomas Stachura

    Abstract: Aspects described herein may be used with local spreadsheet applications, web, and/or cloud-based spreadsheet solutions, to create complex custom software applications. Spreadsheets themselves lack the conceptual framework to be used as a platform tool to build custom or complex software applications. Using the methods and systems described herein using low-code/no-code techniques, a designer can create custom and/or complex software applications using one or more spreadsheets as the underlying blueprints for the software application. The resultant software application may be static/read-only, or may be interactive to allow users to dynamically add, delete, edit, or otherwise amend application data, e.g., via one or more online web pages or via a mobile application. Data transfer may be one-way or bi-directional between the blueprint spreadsheets and the resultant software application, thereby allowing amended data to be transferred from the software application back into spreadsheet form.

    APPLICATION/DOCUMENT COLLABORATION IN A MULTI-DEVICE ENVIRONMENT

    公开(公告)号:US20190065457A1

    公开(公告)日:2019-02-28

    申请号:US16173453

    申请日:2018-10-29

    Abstract: Application/document collaboration in a multi-device environment is provided. An application and associated document or other content, for example, a spreadsheet application and associated spreadsheet documents and content may be displayed on one or more endpoint display devices. A presenter may control the application/document from another device, for example, a smartphone, tablet-style computer, laptop computer, desktop computer, and the like. User interactions on the presenter control device may be reflected on the display device, including, document navigation, document editing, document entry, and the like. Document content may be previewed on the control device before it is sent to the display device. Document metadata and/or presenter notes/comments, etc., may be displayed only on the control device, but not on the display device, as desired by the presenter/user.

    AUTOMATIC TRANSLATION OF SPREADSHEETS INTO SCRIPTS

    公开(公告)号:US20180253413A1

    公开(公告)日:2018-09-06

    申请号:US15658218

    申请日:2017-07-24

    Abstract: Systems and methods are provided for automatically translating one or more electronic spreadsheets into scripts. One or more electronic spreadsheets containing data arrays and formula arrays may be accessed. The electronic spreadsheet(s) may implement various logic using the data arrays and the formula arrays. The range(s) of the formula arrays may be determined. The range(s) of the data arrays may be determined based on the range(s) of the formula arrays. Conversion ranges may be determined based on the range(s) of formula arrays and the range(s) of data arrays. One or more dependencies between the conversion ranges may be determined and used to generate source code modeling the logic implemented by the electronic spreadsheet(s).

    TECHNIQUES FOR ASYNCHRONOUS EXECUTION OF COMPUTATIONALLY EXPENSIVE LOCAL SPREADSHEET TASKS

    公开(公告)号:US20180239749A1

    公开(公告)日:2018-08-23

    申请号:US15439341

    申请日:2017-02-22

    CPC classification number: G06F17/246 G06F9/4843

    Abstract: The techniques described herein facilitate asynchronous execution of computationally expensive spreadsheet tasks and. In some embodiments, asynchronous calls to remote services for handling complex processing tasks such as, for example, complex calculations involving large data sets from one or more spreadsheets of a workbook are described. The handling can include generating a job including a data set from one or more spreadsheets and an instruction directing a remote service to asynchronously execute a computationally expensive spreadsheet task. Responsive to sending the remote service a request to perform the job, a persistent job identifier (ID) associated with the job is received by the spreadsheet application and embedded in (and/or otherwise associated with) at least one or more of the spreadsheets of the workbook. The job is then asynchronously executed by the remote service and the results are accessible from any client device having access to the workbook using the embedded or associated job ID.

Patent Agency Ranking