Class / Patent application number | Description | Number of patent applications / Date published |
715217000 | Cell format | 64 |
20090006939 | TASK-SPECIFIC SPREADSHEET WORKSHEETS - A computer-readable medium having computer-executable modules is provided. The medium includes a computer spreadsheet application including a worksheet defining a series of cells arranged in addressable rows and columns. In addition, a sheet definition is provided. The sheet definition includes a set of constraints applied to the worksheet based on a task-specific function defined for the spreadsheet. Users may select a task-specific worksheet in the application which is limited by the set of constraints. | 01-01-2009 |
20090031205 | System for exporting-impoting the content of input cells from a scalable template instance to another - The present invention is directed to a method, system and program for exporting-importing the content of input cells from a source scalable template instance in a source multi-dimensional spreadsheet to a destination scalable template instance in a destination multi-dimensional spreadsheet; a multi-dimensional spreadsheet comprising a plurality of cells identified by a cell address along each dimension; a scalable template instance comprising a variable number of contiguous elements of same size ordered and aligned along a given spreadsheet dimension and structured according to information defined in an associated scalable template; an element being defined as a range of cells; a range of cells comprising one or a plurality of cells; said scalable template comprising an element profile; an element profile defining a cell content and a cell destination for each cell within each element; said cell destination specifying whether the cell is an input cell for receiving an entry or an output cell for producing a result. The method comprises the steps of:
| 01-29-2009 |
20090031206 | System in a spreadsheet for exporting-importing the content of input cells from a scalable template instance to another - The present invention is directed to a method, system and program for exporting-importing the content of input cells from a source scalable template instance in a source multi-dimensional spreadsheet to a destination scalable template instance in a destination multi-dimensional spreadsheet; a multi-dimensional spreadsheet comprising a plurality of cells identified by a cell address along each dimension; a scalable template instance comprising a variable number of contiguous elements of same size ordered and aligned along a given spreadsheet dimension and structured according to information defined in an associated scalable template; an element being defined as a range of cells; a range of cells comprising one or a plurality of cells; said scalable template comprising an element profile; an element profile defining a cell content and a cell destination for each cell within each element; said cell destination specifying whether the cell is an input cell for receiving an entry or an output cell for producing a result. The method comprises the steps of:
| 01-29-2009 |
20090083614 | System and method for optimizing information display in spreadsheets and tables - Disclosed is a system and method for reducing the size of a tabular display, such as a spreadsheet or dynamically formatted table. Global optimization techniques, for example, simulated annealing, are used to identify an optimal or near-optimal set of column widths whereby the width of columns having cells containing greater amounts of text are increased while the width of columns having cells containing smaller amounts of text are correspondingly decreased, thus reducing overall table height without changing net table width. Use of global optimization avoids converging upon local minimum solutions in favor of solutions which are optimal or near-optimal. By reducing table height, readability is enhanced, and efficiencies are realized which result in reduced costs and reduced consumption of resources. Reductions in table width, as well as conformance of table size to a target aspect ratio are also disclosed. | 03-26-2009 |
20090276691 | METHOD AND SYSTEM FOR NAVIGATING AND SELECTING MEDIA FROM LARGE DATA SETS - Some embodiments of the invention provide a method of accessing a data set. The data set includes a set of data elements. The method collects the data elements of the data set. The method receives a lens item. The lens item provides a set of parameters for searching the data set. The method searches the data set by using the lens item to identify a data subset. The method sorts a list of data elements based on the data subset. The sorting generates an ordered list. The method filters the data subset. Filtering the data subset comprises excluding the data elements that are not relevant to the lens item. The method presents the ordered list in a first column of a matrix. The matrix has several cells. The cells of the matrix are based on the data subset. The method selects column headings for the matrix and populates the cells of the matrix. Some embodiments provide a system for providing access to a data set. The system has a set of data elements that comprises a first data source. The system has a first device for collecting the set of data elements. The first device receives a first lens item for searching the data elements. The first device filters the data elements by using the first lens item to generate a first subset. The first device presents the first subset in a variety of views for navigation through the first subset. | 11-05-2009 |
20090282325 | SPARKLINES IN THE GRID - A sparkline is associated with a location in a document to provide a visual representation of one or more data values included in the document. The sparkline is associated with a data source within the document including the one or more data values. The sparkline is generated by generating the visual representation based on the one or more data values with a matrix of points to be presented at the associated location in the document. The sparkline is presented at the associated location in the document. The sparkline is configured to be regenerated when one or more of the data values in the data source change. | 11-12-2009 |
20100083087 | Rendering common cell formatting for adjacent cells - Rendering common cell formatting for adjacent cells is disclosed. In some embodiments, when rendering cells, a set of adjacent cells that have at least one type of cell formatting in common is identified, and the at least one type of cell formatting is rendered as a single entity rather than individually for each cell in the set to prevent visual artifacts between adjacent cells from arising. | 04-01-2010 |
20100083088 | Defining custom formats - Defining custom cell formats is disclosed. In some embodiments, in response to receiving an indication of a selection of an option to define a custom cell format, a user interface to define the custom cell format is provided, wherein a format element in a definition of the custom cell format in the user interface is represented as a format element token. | 04-01-2010 |
20100083089 | Token representation of references and function arguments - A token representation of references and function arguments is disclosed. In some embodiments, an indication that a formula is being entered into a cell is received, and references and/or function arguments in the formula, if any, are represented as tokens. Each token comprises an atomic user interface object. In various embodiments, references are rendered as reference tokens and function arguments are rendered as argument tokens and/or mode tokens. | 04-01-2010 |
20100100802 | CONTEXTUAL REPORT ELEMENT MAPPING TO WEB SERVICE INPUT PARAMETER - Some aspects include selection of a cell of a report section, the cell associated with a data dimension and with a context of the report section, and association of the cell with an input parameter of a software service. Aspects may include identification of a contextual report specification associated with a software service and with one or more report elements, at least one of the one or more report elements being associated with an input parameter of the software service, determination of data corresponding to a plurality of the one or more report elements, generation of a script to invoke the software service and to pass contents of the at least one of the one or more report elements as the input parameter to the software service, and generation of a report output based on the data and the script. | 04-22-2010 |
20100100803 | COMPUTER PRODUCT, SPREADSHEET GENERATING APPARATUS, AND SPREADSHEET GENERATING METHOD - A computer-readable recording medium stores therein a spreadsheet generating program that causes a computer to execute acquiring information related to layout positions of items in a form; column-sorting the items in ascending order, according to column-related coordinate values of the items; determining a column width for each of the items, based on a distance to the previous item in the column-sorted items; row-sorting the items in ascending order, according to row-related coordinate values of the items; determining a row height for each of the items, based on a distance to the previous item in the row-sorted items; designating, for each of the items and from among cells having the determined column widths and the determined row heights, a cell corresponding to a layout position indicated in the acquired information; and outputting a spreadsheet related to layout of the form by a provision of the items to the designated cells. | 04-22-2010 |
20100251090 | Dynamic Thresholds for Conditional Formats - Generally described, embodiments of the present invention provide the ability to utilize dynamic thresholds and dynamic threshold values when generating variable formatting rules to be applied to a range of cells. Dynamic thresholds include, but are not limited to, “Highest Value,” “Middle Value,” “Lowest Value,” “Number,” “Percent,” “Percentile,” and “Formula.” When using a dynamic threshold, dynamic threshold values are determined based on values contained in a selected range of cells. | 09-30-2010 |
20100269031 | SYSTEM AND METHOD FOR FREEZING COLUMNS AND ROWS IN A UI TABLE - Displaying tabular information in a user interface (UI) on a display screen is enhanced by freezing selected non-adjacent columns (rows). Freezing ensures the display of the selected non-adjacent columns (rows) when scrolling to bring other columns (rows) into the table for display. Border rows (columns) may also be frozen when scrolling. A table in a document navigable by moving a focus to scroll the document may be displayed by a UI control configured to automatically display the frozen border rows (columns). When scrolling a focus in the document at an edge of the display screen to bring the UI control into the display, the UI control aligns a portion of the table with the edge and paints the frozen border row (column). The UI control maintain the display of the border row (column) when scrolling through the table. | 10-21-2010 |
20100293449 | METHOD FOR EXPANDING AND COLLAPSING DATA CELLS IN A SPREADSHEET REPORT - 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. | 11-18-2010 |
20100325526 | FILTER AND SORT BY FORMAT - The present invention comprises methods and user interfaces for organizing data displayed within a data application. Specifically, the present invention provides methods and systems for arranging the display of the data by a format applied to one or more portions of the data. The formats comprise different visual characteristics of the displayed data. In exemplary embodiments, the data application organizes the data by the fill color of the cell, the font color of the data within the cell, or the type of icon inserted into the cell. The organizations comprise any type of rearrangement of the data. In exemplary embodiments, the data application sorts or filters the displayed data according to the format. | 12-23-2010 |
20110035653 | ASSOCIATING CONDITIONS TO SUMMARY TABLE DATA - A method and system associate conditional formats with selected data points or groups of data points within a summary table. In one embodiment, related groups of data are determined based upon currently highlighted cells in a summary table. A user then selects from the groups and identifies conditional formats to be associated with the specified data points. The conditional formats are associated with currently displayed as well as non-displayed data within the summary table. The associated conditions are saved relative to the data points rather than the original cell positions so that the conditions remain associated with the data points following a reorganization of the summary table. | 02-10-2011 |
20110099465 | BUTTERFLY DIAGRAMS ENABLING MULTI-DIMENSIONAL PERFORMANCE ANALYSIS - A method for multi-dimensional performance analysis may be provided. A plurality of data may be displayed in a butterfly diagram comprising a data grid, a histogram associated with column sorting criteria, and a histogram associated with row-sorting criteria. Additional information depth may be provided with conditional formatting of the cells of the data grid. | 04-28-2011 |
20110138265 | METHOD AND APPARATUS FOR PRESENTING DATE IN A TABULAR FORMAT - Some embodiments provide a system for displaying cells of a table. During operation, the system can receive a sort-and-merge request for sorting the rows of the table using a sort column. Next, the system can sort the rows of the table based at least on cell values in the sort column to obtain a sorted table. The system can then merge a set of consecutive cells in a merge column of the sorted table to obtain a merged cell, wherein the set of consecutive cells are associated with the same cell value. Note that the sort column and the merge column can be the same column, or they can be different columns. Next, the system can display the merged cell and other cells in the sorted-and-merged table. Displaying a cell can involve positioning the cell's value in a visible area of the cell. | 06-09-2011 |
20110197118 | SYSTEMS AND METHODS FOR PROCESSING MARKUP LANGUAGE SPECIFIED SPREADSHEET STYLES - Methods to facilitate the processing of formatting information for cells in a spreadsheet document described in a markup language are presented. For spreadsheet documents that include a plurality of style objects, cell formatting information may be obtained from a master style object that stores master formatting information. In addition, named style information may be obtained from a style name object that stores named styles. Further, cell specific formatting information, which can override master formatting information, may be obtained from a cell-specific style object that includes cell specific formatting information. Combined cell formatting information for cells may be stored in a cell format object, wherein the combined cell formatting information can comprise named styles, cell-specific formatting information that overrides formatting information in the master style object, and master formatting information that has not been overridden by the cell-specific formatting information. | 08-11-2011 |
20110202823 | PASTING A SET OF CELLS - Pasting a set of cells is disclosed. In some embodiments, a selection of an option to paste a set of cells in a paste destination is received; and in response to determining that the paste destination is not large enough to accommodate a paste operation associated with the selected option, the paste destination is automatically expanded so that the paste destination is large enough to accommodate the paste operation. | 08-18-2011 |
20110252300 | Row Heights in Electronic Documents - A computer-implemented method for managing row height in an electronic document includes receiving, at a computing device, a request to display a portion of a document that defines a plurality of rows of content and that is represented by a document model; determining heights of the plurality of rows and saving information about the determined heights in a cache that correlates rows to the height information; and using the document model and the cache to generate a view of the document model having the determined row heights. | 10-13-2011 |
20110264993 | Multi-Threaded Sort of Data Items in Spreadsheet Tables - To perform a sort operation on a spreadsheet table, data items in the spreadsheet table are divided into a plurality of blocks. Multiple threads are then used to sort the data items in the blocks. After the data items in the blocks are sorted, multiple threads are used to merge the blocks into a final block. The final block contains each of the data items in the spreadsheet table. A sorted version of the spreadsheet table is then displayed. Data items in the sorted version of the spreadsheet table have the same order as an order of data items in the final block. | 10-27-2011 |
20110276868 | Multi-Threaded Adjustment of Column Widths or Row Heights - A computing system performs a column adjustment process. The column adjustment process uses multiple threads to determine overall maximum column widths for each column in a set of target columns in a spreadsheet table. For each of the target columns, the overall maximum column width for the target column is based on the width of the widest textual representation of a value in any cell in the column. The set of target columns includes at least one column. The computing system then reflows the spreadsheet table such that each column in the set of target columns has a width based on the overall maximum column width for the column. A similar process is performed to adjust the height of rows. | 11-10-2011 |
20110276869 | SYSTEM AND METHOD FOR DYNAMIC BINDING OF A SPREADSHEET WITH EXTERNAL PARAMETERS - In one aspect, the present invention relates to utilizing a spreadsheet by defining a parameter external to the spreadsheet and associating the parameter with the spreadsheet to define a parameterized workbook. In one embodiment, this utilization further comprises storing a location of the spreadsheet and storing the name of the parameter in the same storage module as the location. In another embodiment, it includes defining a result external to the spreadsheet, the result referencing one or more cells within the spreadsheet. in another embodiment, this utilization further comprises receiving a value for the parameter and generating the result based at least in part on the value and the spreadsheet. In another embodiment, it further comprises associating a type with the parameter. The type can define a range of values or attributes associated with the parameter. | 11-10-2011 |
20120017143 | ELECTRONIC DEVICE AND METHOD FOR DATA MANAGEMENT - An electronic device receives a number of HTML files in a queue. The electronic device reads the HTML files in a spreadsheet format, whereby sets of test data in the HTML files are read as cells of a spreadsheet in EXCEL. Values and names are extracted from the sets of test data by the electronic device. The electronic device compiles the extracted values and names and generates a test report file from the complied values and names. | 01-19-2012 |
20120060080 | Visual representation of a cell-based calendar transparently overlaid with event visual indicators for mining data records - A system causes display of a visual representation of a cell-based calendar having cells representing data records, where the cells have corresponding visual indicators corresponding to values of the respective data records. The cells are arranged in plural blocks corresponding to time intervals of the cell-based calendar. Event visual indicators transparently overlay cells in at least some of the plural blocks, where the event visual indicators represent events that occurred in time intervals corresponding to the at least some blocks. The events are separate from activities represented by the data records. Providing the event visual indicators transparently overlaid over the cells in the at least some blocks depict a relationship and relative impact between the data records and the events. | 03-08-2012 |
20120151317 | System and Method for Providing Online Data Management Services - First, second, and third sets of spreadsheet cells are defined in a display, the first and second sets being separated by a first boundary having a selected orientation, the second and third sets being separated by a second boundary having the selected orientation. A selected scrolling function is disabled within selected sets among the first, second and third sets of cells in accordance with an alternating pattern. | 06-14-2012 |
20120192051 | FORMATTING DATA BY EXAMPLE - Data formatting rules to convert data from one form to another form are automatically determined based on a user's edits. A machine learning heuristic is applied to a user's edits to determine a data formatting rule that may be applied to data. For example, a user may make edits that add/remove characters from data, concatenate data, extract data, rename data, and the like. The machine learning heuristic may be automatically triggered in response to an event (e.g. after a predetermined number of edits are made to a same type of data) or manually triggered (e.g. selecting a user interface option). The data formatting rule may be applied to other data and the results of the formatting reviewable by the user. Based on further edits/reviews, the data formatting rule may be updated. The data formatting rules may be stored for later use. | 07-26-2012 |
20120198322 | AUTOMATED TABLE TRANSFORMATIONS FROM EXAMPLES - Described herein are mechanisms for automatically generating a computer-executable program that transforms a first table in a first format to a second table in a second format by way of user-provided examples. A user provides an exemplary input table of a first format, where the input table may be a portion of the first table. The user also provides an exemplary output table of a second format, wherein contents of the output table correspond to contents of the input table. Based upon these user-provided examples, a table transform program is automatically generated, wherein the table transform program, when executed over the first table generates the second table. | 08-02-2012 |
20120260152 | SPREADSHEET CONTROL PROGRAM, SPREADSHEET CONTROL APPARATUS AND SPREADSHEET CONTROL METHOD - Lines drawn on a touch screen with an inputting window opened are recognized as ruled lines which are parallel with a row or column of a spreadsheet, and a square formed by the ruled lines is set to a cell in the spreadsheet when the square is formed. Consequently, it is possible to create the spreadsheet when a user of a computer simply draws a line with a fingertip or the like over the touch screen, and furthermore, it is also possible to input a value to the cell by specifying the square part drawn with the lines to carry out an operation for inputting data. Thus, there is provided a spreadsheet creating interface which makes the most of a visibility and an operability of the touch screen. | 10-11-2012 |
20120260153 | PERSISTENTLY SELF-REPLICATING MULTIPLE RANGES OF CELLS THROUGH A TABLE - The present invention includes a method and system for persistently self-replicating multiple ranges of cells through a copy-paste operation, in a multi dimensional spreadsheet. A set of ranges of cells is defined, wherein each range of cells has the same size. Each time the content of a range of cells belonging to this set is changed, a self-replication operation is performed automatically. The self-replication operation includes the steps of copying the changed range of cells onto a buffer; determining the set of ranges of cells to which the changed range of cells belongs; identifying the ranges of cells belonging to the set; and pasting the content of the buffer in each of the identified range of cells belonging to the set. | 10-11-2012 |
20120284601 | Enhanced Find and Replace for Electronic Documents - An enhanced find and replace feature for a spreadsheet program module is disclosed. The enhanced find and replace feature allows users to search for terms and attributes across multiple sheets of a workbook. The find and replace feature also allows searches to be performed based on the formatting attributes of a cell as well as the textual or numerical contents of a cell. The enhanced find and replace feature also allows users to perform bulk formatting of cells (even cells without text) in a spreadsheet. In another aspect, the enhanced find and replace feature lists all the results of the find operation in a results list so that the user may choose which result(s) to view and edit. | 11-08-2012 |
20120324328 | VARIABLE FORMATTING OF VALUES - Variable formatting for cells in computer spreadsheets, tables, and other documents is provided. For a selected range of cells, cell formats vary with the value in each cell (or an associated value). Formats can include color-scale backgrounds, in-cell elements (e.g., icons and data bars), and other cell formats that can be varied with a value. | 12-20-2012 |
20130013994 | SYSTEM AND METHOD FOR DYNAMIC DATA ACCESS IN A SPREADSHEET WITH EXTERNAL PARAMETERS - In one aspect, the present invention relates to utilizing a spreadsheet by defining a parameter external to the spreadsheet and associating the parameter with the spreadsheet to define a parameterized workbook. In one embodiment, this utilization further comprises storing a location of the spreadsheet and storing the name of the parameter in the same storage module as the location. In another embodiment, it includes defining a result external to the spreadsheet, the result referencing one or more cells within the spreadsheet. In another embodiment, this utilization further comprises receiving a value for the parameter and generating the result based at least in part on the value and the spreadsheet. In another embodiment, it further comprises associating a type with the parameter. The type can define a range of values or attributes associated with the parameter. | 01-10-2013 |
20130013995 | Method, System, and Apparatus for Providing Access to Workbook Models Through Remote Function Calls - 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. | 01-10-2013 |
20130036346 | System and Method for Accessing Rich Objects Via Spreadsheets - One embodiment of the present invention sets forth a method for providing access to a data object from within a spreadsheet included in a spreadsheet application. The method includes associating the data object with a first cell of the spreadsheet, wherein the data object is related to a parameter, and the first cell is identified by a cell reference, receiving an input that is related to a second cell of the spreadsheet and includes an expression that specifies the parameter and the first cell reference, and replacing the first cell reference specified by the expression with the data object, wherein a value for the second cell may be determined by applying the parameter to the data object specified in the expression. | 02-07-2013 |
20130061122 | MULTI-CELL SELECTION USING TOUCH INPUT - Touch input is used for multi-selection of cells within a spreadsheet. For example, a user may drag a finger across the cells of the spreadsheet that they would like to select. The multi-selection of cells may include cells within one or more rows and one or more columns of the spreadsheet. The multi-selection may be adjusted to select more or fewer cells within the multi-selection. The multi-selection of cells may be used for different purposes. For example, the cells within the multi-selection may be used to display summary information related to the multi-selection (e.g. sum, average, median, min, max, count, and the like). The multi-selection may also be used to provide input to a formula that is currently being edited (e.g. a range of cells). | 03-07-2013 |
20130086461 | TECHNIQUES FOR SELECTION AND MANIPULATION OF TABLE BOARDERS - Techniques to select and manipulate table borders as discrete objects are described. In particular, a table border may be selected without having to select a cell that includes the desired border. In one embodiment, for example, a technique may include detecting a selector in proximity to a border in a table. The border in proximity to the selector may be highlighted visually on a display to show which part of the table border may be selected. A selection may cause the highlighted border to be selected. The now-selected border may then be manipulated. Other embodiments are described and claimed. | 04-04-2013 |
20130117650 | Generating reproducible reports used in predictive modeling actions - A method and system that generate reproducible reports describing one or more analytical functions are disclosed. The reports describe a sequence of analytical functions and allow subsequent executions of the sequence of analytical functions. The matrix space that is inherent in worksheets is used to record a sequence of operations as a tabular report that can be interpreted by a computer program. | 05-09-2013 |
20130212458 | DISPLAY CONTROL DEVICE, DISPLAY CONTROL METHOD, AND DISPLAY CONTROL PROGRAM - Disclosed is a display control device including a selection information acquiring part | 08-15-2013 |
20130262974 | TABULAR WIDGET WITH MERGABLE CELLS - Disclosed herein are systems, methods, and non-transitory computer-readable storage media for managing spreadsheets with decision tables. The exemplary method includes generating an underlying data model associated with a visual data model of a spreadsheet containing a decision table, populating the underlying data model based on information contained in the visual data model and based on the decision table, generating a first index for mapping cells in the visual data model to cells in the underlying data model consistent with the decision table, and generating a second index for mapping cells in the underlying data model to cells in the visual data model consistent with the decision table. | 10-03-2013 |
20130275847 | AUTOMATED TABLE TRANSFORMATIONS FROM EXAMPLES - Described herein are mechanisms for automatically generating a computer-executable program that transforms a first table in a first format to a second table in a second format by way of user-provided examples. A user provides an exemplary input table of a first format, where the input table may be a portion of the first table. The user also provides an exemplary output table of a second format, wherein contents of the output table correspond to contents of the input table. Based upon these user-provided examples, a table transform program is automatically generated, wherein the table transform program, when executed over the first table generates the second table. | 10-17-2013 |
20130290823 | METHOD FOR EXPANDING AND COLLAPSING DATA CELLS IN A SPREADSHEET REPORT - 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. | 10-31-2013 |
20130332811 | PROGRESSIVE LOADING FOR WEB-BASED SPREADSHEET APPLICATIONS - Concepts and technologies are described herein for progressive loading for web-based spreadsheet applications. In accordance with the concepts and technologies disclosed herein, a user device can access data from a remote source such as a server computer. The user device can determine dimensions of a viewport corresponding to a viewable portion of the data, a window associated with the viewport, and a preloaded area associated with the window. The user device can request the data associated with the window and the preloaded area and store the data in a cache associated with the user device. The cached data can be used by the user device to generate UIs for displaying the spreadsheet. If the user device detects movement of the viewport, the user device can render a new UI in response to the movement. The user device also can be configured to update and/or clean the cache. | 12-12-2013 |
20130339832 | CUSTOMIZABLE SPREADSHEET TABLE STYLES - Table styles provide a way to format an entire spreadsheet table quickly and easily. According to described implementations, table styles can be created and customized for repeated use in a spreadsheet application. As a result, a user does not have to manually modify multiple formatting options for each table included in one or more spreadsheets. A graphical user interface is also described that provides simple user access to existing table styles that can be modified according to the user's requirements. | 12-19-2013 |
20140082470 | SPREADTREE HIERARCHY SYSTEM FOR SPREADSHEETS AND RELATED METHODS - A method of managing a spreadtree hierarchy comprises storing at least one spreadsheet in a network environment accessible to a plurality of users, and storing at least one data object in the network responsive to an edit of the at least one spreadsheet, the at least one data object having a unique ID and data associated with the edit. A spreadtree system comprises an application server configured to operate within a network (Internet or Intranet), and further configured to communicate with a plurality of clients and manage a spreadtree hierarchy. The spreadtree hierarchy comprises a plurality of linked spreadsheets having reference files stored within the network, and a plurality of data objects associated with the plurality of linked spreadsheets. Each data object of the plurality includes a change to at least one cell in at least one linked spreadsheet of the plurality. A method for operating a spreadtree hierarchy system is also disclosed. | 03-20-2014 |
20140089774 | Row Heights in Electronic Documents - A computer-implemented method for managing row height in an electronic document includes receiving, at a computing device, a request to display a portion of a document that defines a plurality of rows of content and that is represented by a document model; determining heights of the plurality of rows and saving information about the determined heights in a cache that correlates rows to the height information; and using the document model and the cache to generate a view of the document model having the determined row heights. | 03-27-2014 |
20140115434 | BLOCK PROPERTIES AND CALCULATED COLUMNS IN A SPREADSHEET APPLICATION - Block properties and improved calculated columns properties are provided in a spreadsheet application. Once block properties are set for a group of spreadsheet cells or a spreadsheet list, the properties may be applied to the entire group of selected cells or list as opposed to requiring application of properties to individual cells. If rows or columns are added to the group of selected cells or list, properties applied to the group of cells or list are automatically applied to the new rows or columns. Block properties also provide for intelligent-behaving list borders where list borders are not corrupted by the movement or changing of columns or rows sharing edges with a list border. Calculated columns are a type of block property that extends the functionality of formulas throughout an entire column of an associated group of cells or list. | 04-24-2014 |
20140149838 | Dashboard Formula Execution - Formulas in dashboards can be executed at a client executing web technologies such as HTML5 and JavaScript. The formulas specified by a spreadsheet file are transformed into a pre-defined notation format and then recursively evaluated. Related apparatus, systems, techniques and articles are also described. | 05-29-2014 |
20140164896 | Method And System For Expanding And Collapsing Data Cells In A Spreadsheet Application - The invention relates to a method for expanding data cells in a spreadsheet or a report which is associated with a spreadsheet having a number of cells that are displayed in rows and columns wherein at least some of the cells may contain data which is member of a hierarchic structure comprising different hierarchic levels, the methods comprising the following steps:
| 06-12-2014 |
20140237339 | FOR A GIVEN CELL IN A SPREADSHEET, EVALUATING AN UNLIMITED NUMBER OF CONDITIONAL FORMATTING RULES AND APPLYING MULTIPLE CORRESPONDING FORMATS TO THE CELL - Generally described, embodiments of the present invention relate to applying and evaluating conditional formatting rules to a given range of cells. Additionally, multiple conditional formatting rules may be evaluated to TRUE for the same cell contained in a user interface and multiple formats applied to that cell. | 08-21-2014 |
20140281869 | VARIABLE SIZE TABLE TEMPLATES, INTERACTIVE SIZE TABLES, DISTRIBUTABLE SIZE TABLES, AND RELATED SYSTEMS AND METHODS - Described herein are Interactive Size Tables, Variable Size Table Templates, Distributable Size Tables, and related systems and methods that execute and enable generating, publishing, distributing, displaying, modifying, viewing, and interacting with online Interactive Size Tables. Interactive Size Tables are client customizable size tables with interactive features, and, may be generated using Variable Size Table Templates. An example of an executable user interactive feature is size selection by tapping a size displayed on an Interactive Size Table. Another interactive feature is the multiple format feedback feature, which allows users to choose from several different feedback formats and to leave user feedback in sections proximate utilized Interactive Size Tables. User feedback is then made available online and reportable back to generating clients, along with other metrics and usage fees, through a client data purchase and billing interface. Interactive Size Tables are cloud storable and remotely accessible, modifiable, publishable, and efficiently distributable. | 09-18-2014 |
20140289601 | METHOD FOR CONTROLLING ELECTRONIC SPREADSHEET ON HANDHELD TOUCH DEVICE - The present invention relates to a method for controlling an electronic spreadsheet on a handheld touch device, comprising an operation procedure, a display procedure and a recovery procedure. The operation procedure comprises: receiving a selection touch control signal for selecting cells, determining selected cells in an electronic spreadsheet according to the selection touch control signal, calculating according to a preset processing method, and storing the calculation result. The display procedure comprises: receiving a first touch control signal for controlling movement of an electronic spreadsheet from an initial position of the electronic spreadsheet to an interim position, moving the electronic spreadsheet from the initial position of the electronic spreadsheet to the interim position according to the first touch control signal to expose a blank area, querying whether the calculation result exists or not, and if yes, displaying the calculation result in the blank area. The recovery procedure comprises: receiving a second touch control signal for controlling movement of the electronic spreadsheet from the interim position to the initial position of the electronic spreadsheet, and moving the electronic spreadsheet to the initial position of the electronic spreadsheet according to the second touch control signal to cover the blank area. The calculation result can be displayed clearly by using the method, thereby facilitating use by users. | 09-25-2014 |
20150100871 | DYNAMIC THRESHOLDS FOR CONDITIONAL FORMATS - Generally described, embodiments of the present invention provide the ability to utilize dynamic thresholds and dynamic threshold values when generating variable formatting rules to be applied to a range of cells. Dynamic thresholds include, but are not limited to, “Highest Value,” “Middle Value,” “Lowest Value,” “Number,” “Percent,” “Percentile,” and “Formula.” When using a dynamic threshold, dynamic threshold values are determined based on values contained in a selected range of cells. | 04-09-2015 |
20150121186 | METHOD AND APPARATUS FOR INCREASING THE INFORMATION DENSITY IN INFORMATION PROVIDED ON THE PROGRESS OF A PROJECT - A method for increasing the information density in providing information on a progress of at least one project, comprises providing at least one project related goal and at least one project related information, the project related information being related to the project related goal. The information characterizing the project related goal is arranged in a first cell in one element of the group of the cells of a first row of a table and the cells of a first column of the table and the information characterizing the project related information is arranged in a second cell of the other element of the group. An information cell of the table is colored in a first color when the goal is achieved and in a second, different color when the goal is not achieved. | 04-30-2015 |
20150331844 | INFORMATION PROCESSING APPARATUS AND NON-TRANSITORY COMPUTER READABLE MEDIUM - An information processing apparatus includes a detection unit, a combining unit, and a definition unit. The detection unit detects a character acceptance frame from a spreadsheet having the character acceptance frame. The combining unit combines cells in the spreadsheet into a combined cell, the cells corresponding to the character acceptance frame detected by the detection unit. The definition unit defines the combined cell generated by the combining unit as one cell that accepts a character string to be written in the character acceptance frame. | 11-19-2015 |
20160055139 | AUTOMATICALLY ADJUSTING SPREADSHEET FORMULAS AND/OR FORMATTING - In some embodiments, a computer-implemented spreadsheet management method is provided that automatically copies formatting and formulas from appropriate peer rows to an updated row. In some embodiments, the method automatically determines which peer rows, if any, should be used as the source of copied formatting and formulas. In some embodiments, the method automatically fixes formulas that are affected by the updated row in order to maintain consistency throughout the spreadsheet. | 02-25-2016 |
20160103819 | UPDATING FORMULAS IN RESPONSE TO TABLE TRANSPOSITION - Embodiments are disclosed in which an algorithm that updates or rewrites one or more formulas when a table is transposed in an application. In certain embodiments the formula is rewritten so as to preserve the functionality of the formula with respect to the transposed table. In certain embodiments, a notification may be provided that a formula is changed or not changed in response to the table transposition event. | 04-14-2016 |
20160117308 | RESPONSIVE DATA EXPLORATION ON SMALL SCREEN DEVICES - Large and complex data sets can be difficult to view on devices with small screens, such as on smartphones, or in small windows on devices with large screens. The presently disclosed systems, methods and apparatus can determine characteristics associated with a display used to display a requested resource. Based on these determined characteristics, the systems and methods can determine whether the requested resource should be reformatted to fit the display. The requested resource can be reformatted to allow a user to consume complex data on a small display easily and effectively. In some embodiments, this can be done by ensuring that the current data context, previously provided by row/column headers, are always in view in a compact format. | 04-28-2016 |
20160124932 | DATA PROCESSING DEVICE AND METHOD - Data processing device and method. The device includes: a spreadsheet of data displaying row for displaying a part of data retrieved from a database and a hyper row for expressing the remaining data; a data processor configured to calculate the value of the formula based on the data retrieved from the database. According to the device and method of the present invention, it is possible to eliminate overhead for loading data from the database to the spreadsheet when there are massive data records, continuously update the resulting data, and minimize users' development and migration cost. | 05-05-2016 |
20160147730 | SYSTEM AND METHOD FOR ACCESSING RICH OBJECTS VIA SPREADSHEETS - One embodiment of the present invention sets forth a method for providing access to a data object from within a spreadsheet included in a spreadsheet application. The method includes associating the data object with a first cell of the spreadsheet, wherein the data object is related to a parameter, and the first cell is identified by a cell reference, receiving an input that is related to a second cell of the spreadsheet and includes an expression that specifies the parameter and the first cell reference, and replacing the first cell reference specified by the expression with the data object, wherein a value for the second cell may be determined by applying the parameter to the data object specified in the expression. | 05-26-2016 |
20190147030 | SYSTEMS AND METHODS FOR PROVIDING A COMMUNICATION PROGRAM INTERFACE WITH AN INTEGRATED TABULAR DATA MANAGEMENT INTERFACE | 05-16-2019 |
715218000 | Cell hiding | 2 |
20090187816 | SYSTEM AND METHOD IN AN ELECTRONIC SPREADSHEET FOR DISPLAYING AND/OR HIDING RANGE OF CELLS - The present invention is directed to a method, system and program for displaying and/or hiding, in an electronic multi-dimensional spreadsheet on a user interface, elements of a range of cells, a range of cells having one or more contiguous elements aligned along a given spreadsheet dimension, an element of a range of cells having one or more cells along one or a plurality of spreadsheet dimensions. The method includes (A) detecting a command for hiding at least one element in a selected range of cells, the command comprising means for identifying the selected range of cells and means for identifying a display focus level selected among a plurality of ordered display focus levels defined for the selected range of cells; (B) identifying the selected range of cells in the element to hide; (C) identifying the selected display focus level; (D) identifying a table associated with the selected range of cells, the table associating each defined display focus level with at least one cell content criteria to apply to the content of the at least one cell; and (E) selectively displaying the element on the user interface based on the relationship of the selected display focus level with the display focus level associated with the element. | 07-23-2009 |
20100199161 | System and computer program product for displaying and/or hiding a range of cells in an electronic spreadsheet - The present invention is directed to a method, system and program for displaying and/or hiding, in an electronic multi-dimensional spreadsheet on a user interface, elements of a range of cells, a range of cells having one or more contiguous elements aligned along a given spreadsheet dimension, an element of a range of cells having one or more cells along one or a plurality of spreadsheet dimensions. The method includes (A) detecting a command for hiding at least one element in a selected range of cells, the command comprising means for identifying the selected range of cells and means for identifying a display focus level selected among a plurality of ordered display focus levels defined for the selected range of cells; (B) identifying the selected range of cells in the element to hide; (C) identifying the selected display focus level; (D) identifying a table associated with the selected range of cells, the table associating each defined display focus level with at least one cell content criteria to apply to the content of the at least one cell; and (E) selectively displaying the element on the user interface based on the relationship of the selected display focus level with the display focus level associated with the element. | 08-05-2010 |