-
1.
公开(公告)号:US20240070382A1
公开(公告)日:2024-02-29
申请号:US16599895
申请日:2019-10-11
Applicant: Dayal Family LLC
Inventor: Sandeep Dayal
IPC: G06F17/24 , G06F16/903 , G06F17/27
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.
-
公开(公告)号:US20190251158A1
公开(公告)日:2019-08-15
申请号:US16005469
申请日:2018-06-11
Applicant: Microsoft Technology Licensing, LLC
Inventor: Neil Blunt Toronto , Advait Sarkar , Christian Mendel Canton , Andrew Donald Gordon , Benjamin Edward Rampson , Johnny Campbell , Anusha Iyer
IPC: G06F17/24
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.
-
公开(公告)号:US20190243891A1
公开(公告)日:2019-08-08
申请号:US15826282
申请日:2017-11-29
Applicant: Bediako George
Inventor: Bediako George
CPC classification number: G06F17/246 , G06F17/2205 , G06F17/2276
Abstract: Spreadsheets are collections of cells. Special directives may be attached to cells in order to instruct a computing process on how to generate, manipulate, and arrange spreadsheet cells. These directives can be associated with, attached to, or embedded within spreadsheets or spreadsheets cells. Directives are applied according to a directive convention. Application of these directive will allow new spreadsheets to be created at another time and on another computing platform.
-
公开(公告)号:US20190220510A1
公开(公告)日:2019-07-18
申请号:US16368289
申请日:2019-03-28
Applicant: Oracle International Corporation
Inventor: PRASAD KULKARNI , DEEPAK SHARMA
CPC classification number: G06F17/246 , G06Q10/06
Abstract: 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.
-
公开(公告)号:US20190212878A1
公开(公告)日:2019-07-11
申请号:US15868831
申请日:2018-01-11
Applicant: Microsoft Technology Licensing, LLC
Inventor: Carlos Otero
IPC: G06F3/0481 , G06F17/30 , G06F3/0484 , G06F17/24
CPC classification number: G06F3/0481 , G06F3/04842 , G06F16/252 , G06F16/27 , G06F16/289 , G06F17/2288 , G06F17/246 , G06Q10/101
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.
-
公开(公告)号:US20190187962A1
公开(公告)日:2019-06-20
申请号:US16254155
申请日:2019-01-22
Applicant: Thomas Stachura
Inventor: Thomas Stachura
CPC classification number: G06F8/38 , G06F8/30 , G06F8/34 , G06F17/214 , G06F17/246 , G06F17/248
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.
-
公开(公告)号:US20190065457A1
公开(公告)日:2019-02-28
申请号:US16173453
申请日:2018-10-29
Applicant: Microsoft Technology Licensing, LLC
Inventor: John Campbell , Carlos Augusto Otero
CPC classification number: G06F17/246 , G06F3/0484 , G06F9/452 , G06Q10/101 , H04L65/403 , H04L65/4038 , H04L65/602 , H04L65/80
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.
-
8.
公开(公告)号:US20180315122A1
公开(公告)日:2018-11-01
申请号:US16029231
申请日:2018-07-06
Applicant: CFPH, L.L.C.
Inventor: John P. Bartolucci
CPC classification number: G06Q40/04 , G06F17/246
Abstract: Systems and methods for providing a customizable spreadsheet application interface for an electronic trading system or market data source. A customizable spreadsheet application using the application interface according to the invention may be executed or stored either at the client or at a server. In either case, a user is preferably provided with an spreadsheet interface that allows the user to implement a real time electronic trading model. The trading model may preferably be used to trade in the electronic trading system without additional user intervention.
-
公开(公告)号:US20180253413A1
公开(公告)日:2018-09-06
申请号:US15658218
申请日:2017-07-24
Applicant: Palantir Technologies Inc.
Inventor: Eliot Ball , Dustin Janatpour , Nicholas White
CPC classification number: G06F17/246 , G06F8/40 , G06F8/427 , G06F17/211 , G06F17/245 , G06F17/2705
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).
-
10.
公开(公告)号:US20180239749A1
公开(公告)日:2018-08-23
申请号:US15439341
申请日:2017-02-22
Applicant: Microsoft Technology Licensing, LLC
Inventor: Dmitry Zusman , Aleksandr Malyshev
IPC: G06F17/24 , G06F3/0481 , G06F9/48
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.
-
-
-
-
-
-
-
-
-