Abstract: A method, system, and apparatus are provided for exposing and calling workbook models via remote function calls. According to the system, a client computer executes a spreadsheet program for creating a workbook model. The workbook model may be published to a server computer along with data defining a function name and the cells that should be used as inputs and outputs to the model. The system also includes a server computer that receives and responds to remote function calls directed toward workbook functions. When a function call is received at the server computer for a workbook function, the server computer populates the cells in the workbook identified as inputs with input parameters received with the function call and recalculates the workbook. The data contained in the output cells is then returned as a reply to the remote function call.

Abstract: Users are enabled to navigate a spreadsheet document presented by a web service in a similar fashion to a locally executed spreadsheet application by retrieving blocks of grid data asynchronously in order to display or refresh the area(s) of the spreadsheet currently being viewed by the user as the user navigates the spreadsheet grid or dynamic updates occur. The blocks are laid out in the browser's user interface to fill the user's viewport as well as a predefined buffer around the edge of the viewport. As such, when the user scrolls or updates occur, data associated with blocks are added, updated, or removed in the browser as required to fill the user's viewport.

Abstract: A method, system, and apparatus are provided for exposing and calling workbook models via remote function calls. According to the system, a client computer executes a spreadsheet program for creating a workbook model. The workbook model may be published to a server computer along with data defining a function name and the cells that should be used as inputs and outputs to the model. The system also includes a server computer that receives and responds to remote function calls directed toward workbook functions. When a function call is received at the server computer for a workbook function, the server computer populates the cells in the workbook identified as inputs with input parameters received with the function call and recalculates the workbook. The data contained in the output cells is then returned as a reply to the remote function call.

Abstract: A method, system, and apparatus are provided for exposing and calling workbook models via remote function calls. According to the system, a client computer executes a spreadsheet program for creating a workbook model. The workbook model may be published to a server computer along with data defining a function name and the cells that should be used as inputs and outputs to the model. The system also includes a server computer that receives and responds to remote function calls directed toward workbook functions. When a function call is received at the server computer for a workbook function, the server computer populates the cells in the workbook identified as inputs with input parameters received with the function call and recalculates the workbook. The data contained in the output cells is then returned as a reply to the remote function call.

Abstract: Users are enabled to navigate a spreadsheet document presented by a web service in a similar fashion to a locally executed spreadsheet application by retrieving blocks of grid data asynchronously in order to display or refresh the area(s) of the spreadsheet currently being viewed by the user as the user navigates the spreadsheet grid or dynamic updates occur. The blocks are laid out in the browser's user interface to fill the user's viewport as well as a predefined buffer around the edge of the viewport. As such, when the user scrolls or updates occur, data associated with blocks are added, updated, or removed in the browser as required to fill the user's viewport.

Abstract: A method, system, and apparatus are provided for exposing and calling workbook models via remote function calls. According to the system, a client computer executes a spreadsheet program for creating a workbook model. The workbook model may be published to a server computer along with data defining a function name and the cells that should be used as inputs and outputs to the model. The system also includes a server computer that receives and responds to remote function calls directed toward workbook functions. When a function call is received at the server computer for a workbook function, the server computer populates the cells in the workbook identified as inputs with input parameters received with the function call and recalculates the workbook. The data contained in the output cells is then returned as a reply to the remote function call.

Abstract: A method, system, and apparatus for discovering and connecting to data sources are provided. A system is provided that includes a server computer operative to maintain a centrally managed repository of data connection definitions. A client computer is also provided including an application program capable of consuming data from a data source. When a request is received by the application to connect to a data source, a list of available sources is retrieved from the server computer. If one of the data sources in the list is selected, a data connection file is retrieved and utilized to connect to the data source. If a report is opened by the application that includes a reference to a data source, the repository is utilized to confirm the connection to the data source.

Abstract: A system and method for restricting a client's access to sensitive material in a network document. The system includes a document storage component for storing documents having an associated level of access. The system also includes a server component for receiving a document request from a user, associating the document request with the level of access of the requested document, and sending a server request if the level of access is limited. The system further includes a document governor component for receiving the server request, sending a governor request to the document storage component, receiving an unrestricted document from the document storage component, processing the unrestricted document to limit rights according to the level of access, and sending a limited document to the server in order to allow a user accessibility to the restricted document.

Abstract: A system and method for restricting a client's access to sensitive material in a network document. The system includes a document storage component for storing documents having an associated level of access. The system also includes a server component for receiving a document request from a user, associating the document request with the level of access of the requested document, and sending a server request if the level of access is limited. The system further includes a document governor component for receiving the server request, sending a governor request to the document storage component, receiving an unrestricted document from the document storage component, processing the unrestricted document to limit rights according to the level of access, and sending a limited document to the server in order to allow a user accessibility to the restricted document.

Abstract: A method, system, and apparatus for discovering and connecting to data sources are provided. A system is provided that includes a server computer operative to maintain a centrally managed repository of data connection definitions. A client computer is also provided including an application program capable of consuming data from a data source. When a request is received by the application to connect to a data source, a list of available sources is retrieved from the server computer. If one of the data sources in the list is selected, a data connection file is retrieved and utilized to connect to the data source. If a report is opened by the application that includes a reference to a data source, the repository is utilized to confirm the connection to the data source.