Abstract: Server-side custom actions are associated with data fields. The data fields are associated with multiple rows of a client-side spread sheet. The server-side custom actions are defined by one or more web services. Input is received into the data fields of the client-side spread sheet. The input from the data fields is transmitted in a single request to the one or more web services. Results of the server-side custom actions are received. The results are displayed in the client-side spread sheet.

Abstract: Tests are transmitted from a client device to server-side software located on a server device. Results of the tests are received from the server-side software. An authentication sub-flow is selected, based on results of the tests, from a plurality of authentication sub-flows enabling a client-side program to operate on cloud-based data associated with server-side software. Client authentication is facilitated for the client-side program to operate on the cloud-based data using the selected authentication sub-flow. The cloud-based data is operated on from the client-side program using the client-authentication.

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.

Abstract: Example embodiments facilitate extending client-side software functionality to leverage server-side functionality, such as server-side business logic implementing custom actions and accessible to a specialized add-in to the client-side software, e.g., a client-side spreadsheet. An example method includes exposing one or more parameters of server-side logic in a client-side spreadsheet, wherein the server-side logic includes code for implementing one or more software actions; providing input to one or more spreadsheet fields corresponding to the one or more parameters, there by allocating one or more values to the one or more parameters; detecting user selection of a User Interface (UI) control for using the server-side logic to implement the one or more software actions; and sending the one or more values to the server-side logic via one or more web services, thereby providing the one or more values as input to the server-side logic.

Abstract: An example method facilitates authenticating a client-side program, such as a spreadsheet, for access to and use of protected server-side data and/or functionality provided via a web service, such as a REpresentational State Transfer (REST) service or Application Programming Interface (API). The example method uses an add-in or plugin to the spreadsheet (which may run on a mobile device, desktop computer, other client system) to interrogate, negotiate with, or otherwise test or poll the web service to be accessed, so as to determine an authentication method used by the web service when authenticating clients; and to implement an authentication flow in accordance with the authentication method, thereby facilitating authentication of the spreadsheet for interaction with the web service in accordance with permissions associated with the authenticated client software, i.e., spreadsheet.

Abstract: A client-side spreadsheet with client-side worksheets is constructed. The constructing includes structuring worksheet relationships between the client-side worksheets of the client-side spreadsheet in accordance with data object relationships of data objects of a server-side data structure. A determination is made that an operation has been selected for performing on data of at least one of the client-side worksheets. User input operative to initiate performance of the at least one of the client-side worksheets is detected. Implementation of the operation is initiated in accordance with the worksheet relationships and the data object relationships.

Abstract: Example embodiments facilitate orchestrating changes of data made (and/or actions specified for execution) in a client-side program with changes of corresponding data made in one or more server-side data objects. An example method includes structuring one or more worksheet relationships between one or more worksheets of a client-side spreadsheet in accordance with one or more data object relationships of one or more data objects of a server-side data structure; determining that one or more operations have been selected for performing on data of one or more of the worksheets; detecting user input operative to initiate performance of the one or more operations; and initiating implementation of the one or more operations (e.g., CRUD (Create, Read, Update, Delete) operations) in accordance with the one or more worksheet relationships and the one or more data object relationships (e.g., hierarchical relationships).

Abstract: Implementations generally relate to a spreadsheet add-in that provides data entry validation. As described in more detail herein, the spreadsheet add-in integrates a spreadsheet-based table component with a remote web service. The spreadsheet add-in uses web service metadata to validate data that a user enters into the spreadsheet. The spreadsheet add-in provides immediate feedback on errors in an interactive fashion for the user. Furthermore, during a data upload process, any errors that are reported by the web service are displayed in context such that the user may quickly affect corrections.

Abstract: Implementations generally relate to an editable table in a spreadsheet integrated with a web service. In some implementations, a method includes obtaining web service metadata from a web service. The method further includes determining one or more capabilities of the web service based on the web service metadata. The method further includes configuring a table component in a spreadsheet based on the one or more capabilities and the web service metadata. The method further includes retrieving data from the web service. The method further includes converting the data to a predetermined format. The method further includes tracking data changes in the spreadsheet based on user input. The method further includes sending the data changes from the spreadsheet to the web service.

Abstract: An example method facilitates data entry into fields or cells of client-side programs, such as spreadsheets, using a versatile data-selection dialog that provides User Interface (UI) controls and associated user options and functionality for efficiently selecting from among lists of values or computing objects for entry into an associated field or cell. The lists can be bounded or unbounded. The listed items can also be sorted and/or searched as needed. The dialog is further supported by functionality enabling selective retrieval of server-side data for populating values in the lists and caching of the retrieved values to meet the needs of a given implementation. Additional controls enable implementing advanced searches via the dialog, where associated advance-search functionality enables, for instance, searching by ranges of values; the addition of new types of search criteria (e.g., by enabling the adding of fields to a set of advanced-search controls), and so on.

Abstract: Example embodiments facilitate orchestrating changes of data made (and/or actions specified for execution) in a client-side program with changes of corresponding data made in one or more server-side data objects. An example method includes structuring one or more worksheet relationships between one or more worksheets of a client-side spreadsheet in accordance with one or more data object relationships of one or more data objects of a server-side data structure; determining that one or more operations have been selected for performing on data of one or more of the worksheets; detecting user input operative to initiate performance of the one or more operations; and initiating implementation of the one or more operations (e.g., CRUD (Create, Read, Update, Delete) operations) in accordance with the one or more worksheet relationships and the one or more data object relationships (e.g., hierarchical relationships).

Abstract: Example embodiments facilitate extending client-side software functionality to leverage server-side functionality, such as server-side business logic implementing custom actions and accessible to a specialized add-in to the client-side software, e.g., a client-side spreadsheet. An example method includes exposing one or more parameters of server-side logic in a client-side spreadsheet, wherein the server-side logic includes code for implementing one or more software actions; providing input to one or more spreadsheet fields corresponding to the one or more parameters, there by allocating one or more values to the one or more parameters; detecting user selection of a User Interface (UI) control for using the server-side logic to implement the one or more software actions; and sending the one or more values to the server-side logic via one or more web services, thereby providing the one or more values as input to the server-side logic.

Abstract: Implementations generally relate to an editable table in a spreadsheet integrated with a web service. In some implementations, a method includes obtaining web service metadata from a web service. The method further includes determining one or more capabilities of the web service based on the web service metadata. The method further includes configuring a table component in a spreadsheet based on the one or more capabilities and the web service metadata. The method further includes retrieving data from the web service. The method further includes converting the data to a predetermined format. The method further includes tracking data changes in the spreadsheet based on user input. The method further includes sending the data changes from the spreadsheet to the web service.

Abstract: Implementations generally relate to a spreadsheet add-in that provides data entry validation. As described in more detail herein, the spreadsheet add-in integrates a spreadsheet-based table component with a remote web service. The spreadsheet add-in uses web service metadata to validate data that a user enters into the spreadsheet. The spreadsheet add-in provides immediate feedback on errors in an interactive fashion for the user. Furthermore, during a data upload process, any errors that are reported by the web service are displayed in context such that the user may quickly affect corrections.

Abstract: Implementations generally relate to an editable table in a spreadsheet integrated with a web service. In some implementations, a method includes obtaining web service metadata from a web service. The method further includes determining one or more capabilities of the web service based on the web service metadata. The method further includes configuring a table component in a spreadsheet based on the one or more capabilities and the web service metadata. The method further includes retrieving data from the web service. The method further includes converting the data to a predetermined format. The method further includes tracking data changes in the spreadsheet based on user input. The method further includes sending the data changes from the spreadsheet to the web service.

Abstract: Implementations generally relate to a spreadsheet add-in that provides data entry validation. As described in more detail herein, the spreadsheet add-in integrates a spreadsheet-based table component with a remote web service. The spreadsheet add-in uses web service metadata to validate data that a user enters into the spreadsheet. The spreadsheet add-in provides immediate feedback on errors in an interactive fashion for the user. Furthermore, during a data upload process, any errors that are reported by the web service are displayed in context such that the user may quickly affect corrections.

Abstract: An example method facilitates authenticating a client-side program, such as a spreadsheet, for access to and use of protected server-side data and/or functionality provided via a web service, such as a REpresentational State Transfer (REST) service or Application Programming Interface (API). The example method uses an add-in or plugin to the spreadsheet (which may run on a mobile device, desktop computer, other client system) to interrogate, negotiate with, or otherwise test or poll the web service to be accessed, so as to determine an authentication method used by the web service when authenticating clients; and to implement an authentication flow in accordance with the authentication method, thereby facilitating authentication of the spreadsheet for interaction with the web service in accordance with permissions associated with the authenticated client software, i.e., spreadsheet.

Abstract: An example method facilitates data entry into fields or cells of client-side programs, such as spreadsheets, using a versatile data-selection dialog that provides User Interface (UI) controls and associated user options and functionality for efficiently selecting from among lists of values or computing objects for entry into an associated field or cell. The lists can be bounded or unbounded. The listed items can also be sorted and/or searched as needed. The dialog is further supported by functionality enabling selective retrieval of server-side data for populating values in the lists and caching of the retrieved values to meet the needs of a given implementation. Additional controls enable implementing advanced searches via the dialog, where associated advance-search functionality enables, for instance, searching by ranges of values; the addition of new types of search criteria (e.g., by enabling the adding of fields to a set of advanced-search controls), and so on.

Abstract: Implementations generally relate to an editable table in a spreadsheet integrated with a web service. In some implementations, a method includes obtaining web service metadata from a web service. The method further includes determining one or more capabilities of the web service based on the web service metadata. The method further includes configuring a table component in a spreadsheet based on the one or more capabilities and the web service metadata. The method further includes retrieving data from the web service. The method further includes converting the data to a predetermined format. The method further includes tracking data changes in the spreadsheet based on user input. The method further includes sending the data changes from the spreadsheet to the web service.

Abstract: Implementations generally relate to a spreadsheet add-in that provides data entry validation. As described in more detail herein, the spreadsheet add-in integrates a spreadsheet-based table component with a remote web service. The spreadsheet add-in uses web service metadata to validate data that a user enters into the spreadsheet. The spreadsheet add-in provides immediate feedback on errors in an interactive fashion for the user. Furthermore, during a data upload process, any errors that are reported by the web service are displayed in context such that the user may quickly affect corrections.