-
公开(公告)号:US20240070383A1
公开(公告)日:2024-02-29
申请号:US17898321
申请日:2022-08-29
Applicant: Microsoft Technology Licensing, LLC
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.
-
公开(公告)号:US20240054284A1
公开(公告)日:2024-02-15
申请号:US18382901
申请日:2023-10-23
Applicant: Microsoft Technology Licensing, LLC
Inventor: Haoyu Dong , Shi Han , Dongmei Zhang , Jennifer Michelstein Halberstam , Xiao Lyu
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.
-
公开(公告)号:US11893366B2
公开(公告)日:2024-02-06
申请号:US17881790
申请日:2022-08-05
Applicant: Thomas Stachura
Inventor: Thomas Stachura
IPC: G06F8/38 , G06F8/30 , G06F40/18 , G06F40/109 , G06F8/34 , G06F40/186
CPC classification number: G06F8/38 , G06F8/30 , G06F8/34 , G06F40/109 , G06F40/18 , G06F40/186
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.
-
公开(公告)号:US11893343B2
公开(公告)日:2024-02-06
申请号:US17521568
申请日:2021-11-08
Applicant: Microsoft Technology Licensing, LLC
Inventor: Derek Liddell
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.
-
公开(公告)号:US20240037325A1
公开(公告)日:2024-02-01
申请号:US17876327
申请日:2022-07-28
Applicant: Oracle International Corporation
Inventor: Xiameng Chen , Shaun Logan
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.
-
公开(公告)号:US11886456B2
公开(公告)日:2024-01-30
申请号:US17688558
申请日:2022-03-07
Applicant: SIGMA COMPUTING, INC.
Inventor: Jason D. Frantz , Julie L. Lemieux , Robert C. Woollen
IPC: G06F16/00 , G06F16/25 , G06F16/2457 , G06F16/21 , G06F40/18
CPC classification number: G06F16/252 , G06F16/212 , G06F16/24573 , G06F40/18
Abstract: Creating a model data set using a spreadsheet interface including generating the model data set using the spreadsheet interface and a first data source from a data warehouse, wherein the model data set is a reusable modeling layer comprising at least a portion of the first data source, and wherein generating the model data set comprises: creating a first worksheet using the spreadsheet interface and the first data source; receiving an indication that the first worksheet is a model data set; and generating model data set metadata for the first worksheet; and providing, as a second data source for a second worksheet, the model data set generated from the model data set metadata.
-
公开(公告)号:US20240028822A1
公开(公告)日:2024-01-25
申请号:US18226013
申请日:2023-07-25
Applicant: Google LLC
Inventor: Gökhan Bakir
IPC: G06F40/18 , G06F16/9538
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.
-
公开(公告)号:US20240005091A1
公开(公告)日:2024-01-04
申请号:US18217436
申请日:2023-06-30
Applicant: Google LLC
Inventor: Fernanda Viégas , Martin Wattenberg , Daniel Smilkov , James Wexler , Daniel Gundrum
IPC: G06F40/18 , G06F16/248 , G06F16/22 , G06F40/177 , G06F40/216 , G06F3/0482 , G06T11/20
CPC classification number: G06F40/18 , G06F16/248 , G06F16/2282 , G06F40/177 , G06F40/216 , G06F3/0482 , G06T11/206
Abstract: A method for generating a chart suggestion list using data present in a data table includes providing the data table, one or more data types of a plurality of cells of the data table and one or more statistics pertaining to the plurality of cells as input to a machine learning model to obtain one or more outputs indicating one or more chart types for the data table, and creating one or more suggested charts based on the indicated chart types. Each of the one or more suggested charts represents at least a subset of the data in the data table. The method also includes generating a chart suggestion list including at least one of the one or more suggested charts.
-
公开(公告)号:US20230419025A1
公开(公告)日:2023-12-28
申请号:US18340711
申请日:2023-06-23
Applicant: CANON KABUSHIKI KAISHA
Inventor: KIICHI HASEGAWA
IPC: G06F40/18 , G06F40/106 , G06V30/14
CPC classification number: G06F40/18 , G06F40/106 , G06V30/1444
Abstract: An image processing apparatus includes a reading unit configured to generate image data by reading an original, a reception unit configured to receive selection of a stored file from a user, an acquisition unit configured to acquire character information from the image data generated by the reading unit, and an execution unit configured to perform processing for inserting the character information acquired by the acquisition unit into the selected file.
-
公开(公告)号:US11816316B2
公开(公告)日:2023-11-14
申请号:US17224381
申请日:2021-04-07
Applicant: SPLUNK INC.
Inventor: Cory Eugene Burke , Katherine Kyle Feeney , Divanny I. Lamas , Marc Vincent Robichaud , Matthew G. Ness , Clara E. Lee
IPC: G06F17/00 , G06F3/04842 , G06F3/0482 , G06F16/22 , G06F16/242 , G06F16/248 , G06F16/25 , G06F16/951 , G06F16/2455 , G06F40/18 , G06V10/22 , G06F3/04847 , G06F9/451
CPC classification number: G06F3/04842 , G06F3/0482 , G06F3/04847 , G06F16/221 , G06F16/242 , G06F16/248 , G06F16/2455 , G06F16/252 , G06F16/951 , G06F40/18 , G06V10/22 , G06F9/451 , G06F16/2425
Abstract: In embodiments of statistics value chart interface cell mode drill down, a first interface displays in a table format that includes columns each with field values of an event field, and each column having a column heading of a different one of the event fields, and includes rows each with one or more of the field values, each field value in a row associated with a different one of the event fields, and having an aggregated metric that represents a number of events with field-value pairs that match all of the field values listed in a respective row and the corresponding event fields listed in the respective columns. A cell can be emphasized that includes one of the field values in a row that corresponds to one of the different event fields in a column, and in response, a menu displays options to transition to a second interface.
-
-
-
-
-
-
-
-
-