ENHANCED INTEGRATION OF SPREADSHEETS WITH EXTERNAL ENVIRONMENTS

    公开(公告)号:US20240070383A1

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

    申请号:US17898321

    申请日:2022-08-29

    CPC classification number: G06F40/18 G06F9/54

    Abstract: An enhanced integration of spreadsheet environments and external environments is disclosed herein that allows users to enter non-native statements directly into the cells of a worksheet so that external resources can be applied with respect to their values. In addition, a security model is disclosed whereby external functions referenced in the cells of a worksheet are executed in the context of a runtime environment that is secured apart from the spreadsheet application that hosts the worksheet. Various enhancements to the user experience are also disclosed that allow users to enter non-native statements in line with respect to the functional syntax that forms the basis of spreadsheet formulas.

    SPREADSHEET TABLE TRANSFORMATION
    62.
    发明公开

    公开(公告)号:US20240054284A1

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

    申请号:US18382901

    申请日:2023-10-23

    CPC classification number: G06F40/18 G06F16/2246 G06F40/30

    Abstract: Implementations of the present disclosure provide a solution for spreadsheet table transformation. In this solution, one or more header areas and a data area of a spreadsheet table are detected. A hierarchical structure of each of the header areas is determined by analysis of cell merging and/or indents in the header area, and/or a function relationship between data items in corresponding cells of the data area. The spreadsheet table can be transformed to a relational table based on recognition of the hierarchical structure of the header area. In this way, by facilitating understanding of header structures based on the header hierarchy, it is possible to achieve automated transformation from spreadsheet tables to relational tables.

    Spreadsheet-based software application development

    公开(公告)号:US11893366B2

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

    申请号:US17881790

    申请日:2022-08-05

    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.

    Multiple datapoint formats in spreadsheets

    公开(公告)号:US11893343B2

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

    申请号:US17521568

    申请日:2021-11-08

    Inventor: Derek Liddell

    CPC classification number: G06F40/18 H04L67/04

    Abstract: Systems, methods, and software are disclosed herein that allow multiple values to be stored and referenced individually in a spreadsheet or table cell. In an implementation, an application identifies a format of a cell in a spreadsheet with a format having multiple data points. The application receives multiple values corresponding to the multiple data points and stores each value of the multiple values in the cell as a separately referenceable value with respect to each other value of the multiple values. In some implementations, formulas in other cells or sub-routines can reference an individual one of the values in the cell.

    ABILITY TO ADD NON-DIRECT ANCESTOR COLUMNS IN CHILD SPREADSHEETS

    公开(公告)号:US20240037325A1

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

    申请号:US17876327

    申请日:2022-07-28

    CPC classification number: G06F40/18 G06F16/221 G06F16/282

    Abstract: Example embodiments facilitate augmenting a client-side worksheet of a spreadsheet with context information retrieved from non-direct ancestor worksheets of the client-side worksheet. A spreadsheet plug-in enables retrieval of the context information from a server system, e.g., cloud-based database, via one or more web services. In a specific embodiment, the context information represents one or more data dimensions, e.g., worksheet columns, retrieved via the server system form one or more remote databases and populated into one or more non-direct ancestor worksheets (e.g., grandparent worksheets, great grandparent worksheets, etc.). Then those data dimensions are displayed in the client-side descendant worksheet. The user can now efficiently edit the worksheet while viewing relevant context information in the worksheet.

    CONTEXTUAL ANSWER GENERATION IN SPREADSHEETS
    67.
    发明公开

    公开(公告)号:US20240028822A1

    公开(公告)日:2024-01-25

    申请号:US18226013

    申请日:2023-07-25

    Applicant: Google LLC

    Inventor: Gökhan Bakir

    CPC classification number: G06F40/18 G06F16/9538

    Abstract: A method includes receiving, via a user interface of a client device, a request to populate one or more cells of a plurality of cells of a document having a tabular structure, wherein the one or more cells correspond to a first attribute pertaining to a first column header and a first object pertaining to a first row header; analyzing the request and one or more additional cells corresponding to one or more additional attributes and one or more additional objects of the document to obtain contextual information for the request; generating a query based at least in part on the contextual information; initiating an execution of the query to obtain a response using one or more data sources; and causing the user interface to be modified to populate the response in the one or more cells corresponding to the first attribute and the first object.

Patent Agency Ranking