Abstract: Context sensitive delimiter insertion when adding references is disclosed. In some embodiments, a plurality of indications of selections of a cell or cell range while in a formula editing mode in a host cell into which a formula is being entered is successively received, and in response to receiving each indication of selection of the plurality a reference to the selected cell or cell range is successively inserted into the formula, wherein the references inserted into the formula are delimited by a first delimiter type if in a first context and wherein the references inserted into the formula are delimited by a second delimiter type if in a second context.

Abstract: A user collaboration system providing for the efficient utilization of an organization's resources, such as the bandwidth associated with call center activity. At the same time, the user collaboration system enables users to quickly and easily receive help in a particular subject matter area, without requiring the user to know who within the organization may be able to provide that assistance. The user collaboration system also maintains an organization's user profile information that tracks employee subject matter expertise and allows users to request assistance from an anonymous expert. The assistance may be provided via a collaboration session which may be optimized based on available network resources.

Abstract: Embodiments of the present invention provide a table graphics management method and apparatus. The table graphics management method includes: displaying a table on a display apparatus; detecting a control track for the table input by an input device; determining a moving direction of the control track according to the detected control track; and along the moving direction of the control track, transposing original information in the frames of the row that are sequentially arranged along the first dimension into the frames of the column that are sequentially arranged along the second dimension, and transposing original information in the frames of the column that are sequentially arranged along the second dimension into the frames of the row that are sequentially arranged along the first dimension, so as to acquire a transposed table; and displaying a transposed table on the display apparatus.

Abstract: A method is disclosed for data entry into the content of cells belonging to an output field, said data being expressed as a mathematical expression of the cell contents of at least one input field in a data multidimensional table used by a data management application.

Abstract: Through proactive structured dataset management, suggestions are made for dataset enrichment, cleansing, and other enhancements. Users need not go looking for potentially helpful datasets online or in an enterprise filesystem, because relevant datasets and services will be automatically suggested, based on a samplex cast from the user's dataset. Enrichment may add typed attributes, rows, and/or cell values from a matching dataset, may cleanse data, and may add another dataset which has data about the same entity as the original dataset. Proactive dataset and service matching occurs inside a security perimeter to protect confidentiality. Confidence in suggested modifications may be shown by color differences. Modifications may be previewed, and kept or reverted after acceptance. Suggestions are made in from-example or from-scratch scenarios.

Abstract: Data cells in a spreadsheet report are collapsed and expanded without disrupting other spreadsheet data. A user may want to drill down on data corresponding to a parent member of the report to display more detailed information about the parent member. Likewise, a user may want to drill up the displayed information corresponding to the parent member to hide detailed information associated with the parent member. Before expanding or collapsing a report, the spreadsheet is scanned for information to determine whether the display of other data in the spreadsheet would be disrupted by the expansion/collapse. The information may include cross-join information associated with the parent member, the number of child members associated with the parent member, the dimension of the report created by the parent member and the associated child members, and other reports that may be linked to the report that includes the parent member.

Abstract: Methods, systems, and machine-readable mediums are disclosed for viewing multiply-dimensioned data. In one embodiment, a method is disclosed which comprises displaying multiply-dimensioned data in a table format, the table format having a plurality of rows, a plurality of columns, and a plurality of cells displaying data, a first column of the plurality of columns including data having at least two hierarchical levels. Data for at least a first set of the plurality of cells is displayed in a graphical format, the first set including cells in the first column, the graphical format of the cells in the first set in the first column indicating a hierarchical level associated with the cell data and a mechanism is displayed for a first one of the rows to display at least one additional row having data in the first column associated with a lower hierarchical level of the first row data.

Abstract: Methods and apparatus are provided for receiving a PDL File that describes a print job, processing the PDL commands in the file, identifying print settings and printer factors that may affect the entire print job, and reporting such print settings and printer factors. Methods and apparatus are also provided for receiving a PDL File that describes a print job, processing the PDL commands in the file, identifying any objects in the print job that have associated predetermined attributes, and reporting the print objects that have any such predetermined attributes.

Abstract: Methods, systems, and machine readable mediums are disclosed for viewing multidimensional data. In one embodiment, a method is disclosed which comprises displaying multidimensional data in a table format, the table format having a plurality of rows, a plurality of columns, and a plurality of cells displaying data, a first column of the plurality of columns including data having at least two hierarchical levels. Data for at least a first set of the plurality of cells is displayed in a graphical format, the first set including cells in the first column, the graphical format of the cells in the first set in the first column indicating a hierarchical level associated with the cell data and a mechanism is displayed for a first one of the rows to display at least one additional row having data in the first column associated with a lower hierarchical level of the first row data.

Abstract: An improved electronic spreadsheet is provided for applications requiring conditional expression execution behavior. Each cell having an executable expression is cooperative with an implicit conditional execution wrapper. The execution of each cellular expression is implicitly conditioned on the state of an individually assigned logical switch expression. The improved electronic spreadsheet also includes a user interface by which a user can assign logical switch expressions to a cell, or to a range of cells. The improved electronic spreadsheet facilitates the use of spreadsheets for wider range of applications than was possible with conventional electronic spreadsheets.

Abstract: For standalone spreadsheet applications and/or Web-based spreadsheet services, the ability to designate, discover and set parameters for spreadsheet documents is provided. When creating a spreadsheet document, the ability to designate certain cells or ranges of cells as parameters to a spreadsheet is enabled. Furthermore, whether viewed in a standalone spreadsheet application or via a Web service, the ability to discover these parameters through the user interface or object model is provided. The ability to set or change these parameters one at a time or in bulk and drive the changes into the calculation model is also provided. Accordingly, whether viewed in a standalone spreadsheet application or via a Web rendering service, the effect of the parameters entered by the user can be calculated and viewed at once. The ability to suspend recalculation of a workbook until all relevant values, such as a current set of parameters, are obtained is also enabled.

Abstract: A method and system for hiding sensitive data in an electronic spreadsheet. A first output equation expresses output data as a function of at least one first input data and at least one first intermediary result. The at least one first and second intermediary result are assigned as content of intermediary cells of the spreadsheet. A second output equation is generated and expresses the output data as a function of a subset of the at least one first and second input data with no functional dependence on the plurality of intermediary results. Generation of the second output equation utilizes the first output equation and the plurality of first intermediary equations. The output data of the second output equation is assigned as content of an output cell of the spreadsheet. The content of the intermediary cells is removed, resulting in the plurality of intermediary results not being identifiable in the spreadsheet.

Abstract: A method and system for facilitating information exchange between individuals and entities interacting on a shared project are provided, and more particularly to a method and system for horizontal. i.e. non-hierarchical, participation in and/or contribution to a spreadsheet-based project. The method and system is Web-based and utilizes conventional browser and spreadsheet technology to achieve collaborative exchanges of information on an enterprise-wide basis. The method and system also facilitate efficacious remote information access and exchange, e.g., over a computer network such as the Internet and/or the World Wide Web, through a caching function that combines individual queries initiated by a spreadsheet program before transmitting across a network to a server for consideration.

Abstract: File formats, methods, and computer program products are provided for representing a workbook in a modular content framework. The modular content framework may include a file format container associated with modular parts. A file format includes logically separate modular parts that are associated with each other by one or more relationships where each modular part is associated with a relationship type. The modular parts include a workbook part operative as a guide for properties of the workbook and a worksheet part associated with the workbook part and operative to specify a definition of cells within a worksheet associated with the worksheet part. The modular parts may also include a document properties part containing built-in properties associated with the file format and a thumbnail part containing associated thumbnails. Each modular part is capable of being interrogated separately, extracted from the workbook, and/or reused in a different workbook.

Abstract: A method and system for facilitating information exchange between individuals and entities interacting on a shared project are provided, and more particularly to a method and system for horizontal. i.e., non-hierarchical, participation in and/or contribution to a spreadsheet-based project. The method and system is Web-based and utilizes conventional browser and spreadsheet technology to achieve collaborative exchanges of information on an enterprise-wide basis. The method and system also facilitate efficacious remote information access and exchange, e.g., over a computer network such as the Internet and/or the World Wide Web, through a caching function that combines individual queries initiated by a spreadsheet program before transmitting across a network to a server for consideration.

Abstract: A method and apparatus for protecting regions of an electronic document are provided. According to the method, the entire electronic document is protected. The selection of a region within the electronic document is received along with identity of one or more users authorized to freely edit the selected region. The identified users are authorized to freely edit only the selected region of the electronic document. A request is then received to edit a region of the electronic document from a current user. In response to the request, a determination is made as to whether the current user is authorized to edit the region. If the user is not authorized to edit the region, the request is denied.

Abstract: System, method and computer program for initiating a search at a server computer. A data base including a URL of the server computer is stored at a client computer. Information entered by a user into the client computer is received. From the information, a search term and the URL of the server computer are identified. Then, an HTTP search request which includes the URL of the server computer and the search term is generated. Then, the HTTP search request is sent to the server computer. The identifying of the URL of the server computer comprises searching the data base for a character string contained in the information that matches the URL of the server computer. The identifying of the search term comprises identifying a portion of the information appended to the URL of the server. The identifying of the search term also comprises omitting from the portion one or more symbols adjacent to the search term which are inconsistent with a search request using HTTP.

Abstract: Private sheets are disclosed, in shared computer applications, such as spreadsheets. In one aspect, a public sheet is accessible to a first client and a second client; and, moreover, a private sheet is accessible only to the second client. The private sheet is configured to access content in the public sheet, but the public sheet can't access content in the private sheet. In this way, users can use private sheets to perform calculations or modeling on the side, while collaborating on public sheets with other users. In another aspect, changes made to the public sheet can be reflected in the private sheet, if such changes are referenced by the private sheet to content in the public sheet. However, changes made to the private sheet are not reflected in the public sheet. Numerous other specific aspects are also disclosed, such as private sheets accessing values but not formulas from public sheets.

Abstract: A method for text entry in an electronic device is disclosed. As a user enters text, such as a URL, into a handheld device the entered text is matched to previously visited URLs and these matched URLs are displayed in a list. The entered text may also be matched to any stored list of URLs or text. Typically, the matching searches for any instances of the entered text no matter the location of the entered text in the matched string. If one of the listed URLs is the URL desired by the user, then the user may select that URL and navigate a web browser to the URL without entering any more text. One of the items in the list may be the entered text with an automatically added prefix and suffix. These features significantly reduce the difficulty of entering URLs, especially on a device with limited input capabilities.