Methods and systems for spreadsheet function and flex copy paste control of formatting and use of selection list panels
US-12169687-B2 · Dec 17, 2024 · US
US2016267069A1 · US · A1
| Field | Value |
|---|---|
| Publication number | US-2016267069-A1 |
| Application number | US-201514657295-A |
| Country | US |
| Kind code | A1 |
| Filing date | Mar 13, 2015 |
| Priority date | Mar 13, 2015 |
| Publication date | Sep 15, 2016 |
| Grant date | — |
A practical reading order for non-experts. Skip the full description unless you need deep technical detail.
What the patent document calls the invention.
A short plain-language summary of the technical disclosure.
Who owns or filed the patent and who is credited as inventor.
Filing, priority, publication, and grant dates set the timeline.
The legal scope of protection — read this for what is actually claimed.
Technology tags used to group this patent with similar filings.
Prior art links and similar publications in this corpus.
Official abstract text for this publication.
Displaying a table in a user interface includes receiving data related to a position within the user interface selected by a user; determining a particular cell of the table corresponding to the position, wherein the particular cell includes an editable portion and a non-editable portion; and determining a particular location within the cell corresponding to the position. A determination is made whether the particular location corresponds to the editable portion of the particular cell; and, if so, positioning a cursor at the particular location; or when the particular location does not correspond to the editable portion of the particular cell, preventing editing at the particular location.
Opening claim text (preview).
1 . A computer-implemented method for displaying a table in a user interface, comprising: receiving, by an application executing on a computer, data related to a position within the user interface selected by a user; determining, by the application executing on the computer, a particular cell of the table corresponding to the position, wherein the particular cell comprises an editable portion and a non-editable portion; determining, by the application executing on the computer, a particular location within the cell corresponding to the position; determining, by the application executing on the computer, whether the particular location corresponds to the editable portion of the particular cell; when the particular location corresponds to the editable portion of the particular cell, positioning, by the application executing on the computer, a cursor at the particular location; and when the particular location does not correspond to the editable portion of the particular cell, preventing, by the application executing on the computer, editing at the particular location. 2 . The method of claim 1 , comprising: receiving, by the application executing on the computer, user input; and modifying, by the application executing on the computer, contents of the particular cell at the particular location based on the user input. 3 . The method of claim 1 , wherein: the editable portion comprises a plurality of non-contiguous regions within the particular cell. 4 . The method of claim 1 , wherein determining the particular cell of the table comprises: determining a particular row of the table, from amongst a plurality of rows, each row comprising a plurality of cells. 5 . The method of claim 1 , wherein determining the particular cell of the table comprises: determining, by the application executing on the computer, a size of the table displayed within the user interface; and determining, by the application executing on the computer, a size of each character in the table. 6 . The method of claim 1 , wherein determining whether the particular location corresponds to the editable portion of the particular cell, comprises: comparing the particular location with a predetermined list having data which relates to an identification of the non-editable portion of the table. 7 . The method of claim 1 , wherein determining whether the particular location corresponds to the editable portion of the particular cell, comprises: comparing the particular location with a predetermined list having data which relates to an identification of the editable portion of the table. 8 . The method of claim 1 , wherein the user interface comprises a plurality of windows, each window corresponding to a different, respective executing application. 9 . The method of claim 1 , comprising: receiving, by the application executing on the computer, notification of a single mouse click event, wherein the mouse click event includes the data related to the position within the user interface selected by the user. 10 . The method of claim 1 , comprising: after receiving notification of the single mouse click event, determining, by the application executing on the computer, the particular cell of the table corresponding to the position. 11 . A system for displaying a table in a user interface, comprising: a computer configured to execute an application comprising a plurality of executable instructions in an accessible memory; the computer when executing instructions stored in the accessible memory: receives data related to a position within the user interface selected by a user; determines a particular cell of the table corresponding to the position, wherein the particular cell comprises an editable portion and a non-editable portion; determines a particular location within the cell corresponding to the position; determines whether the particular location corresponds to the editable portion of the particular cell; positions a cursor at the particular location, when the particular location corresponds to the editable portion of the particular cell; and prevents editing at the particular location when the particular location does not correspond to the editable portion of the particular cell. 12 . The system of claim 11 , wherein the computer when executing the application: receives user input; and modifies contents of the particular cell at the particular location based on the user input. 13 . The system of claim 11 , wherein: the editable portion comprises a plurality of non-contiguous regions within the particular cell. 14 . The system of claim 11 , wherein the computer when executing the application: determines a particular row of the table, from amongst a plurality of rows, each row comprising a plurality of cells. 15 . The system of claim 11 , wherein the computer when executing the application: determines a size of the table displayed within the user interface; and determines a size of each character in the table. 16 . The system of claim 11 , wherein the computer when executing the application: compares the particular location with a predetermined list having data which relates to an identification of the non-editable portion of the table. 17 . The system of claim 11 , wherein the computer when executing the application: compares the particular location with a predetermined list having data which relates to an identification of the editable portion of the table. 18 . The system of claim 11 , wherein the user interface comprises a plurality of windows, each window corresponding to a different, respective executing application. 19 . The system of claim 11 , wherein the computer when executing the application: receives notification of a single mouse click event, wherein the mouse click event includes the data related to the position within the user interface selected by the user. 20 . The system of claim 11 , wherein the computer when executing the application: determines the particular cell of the table corresponding to the position, after receiving notification of the single mouse click event. 21 . A computer program product for displaying a table in a user interface, comprising: a non-transitory computer readable storage medium having computer readable program code embodied therewith, the computer readable program code comprising: computer readable program code configured to receive data related to a position within the user interface selected by a user; computer readable program code configured to determine a particular cell of the table corresponding to the position, wherein the particular cell comprises an editable portion and a non-editable portion; computer readable program code configured to determine a particular location within the cell corresponding to the position; computer readable program code configured to determine whether the particular location corresponds to the editable portion of the particular cell; computer readable program code configured to position a cursor at the particular location, when the particular location corresponds to the editable portion of the particular cell; and computer readable program code configured to prevent editing at the particular location when the particular location does not correspond to the editable portion of the particular cell.
of spreadsheets (form-filling G06F40/174) · CPC title
of tables; using ruled lines · CPC title
Physics · mapped topic
Physics · mapped topic
Related publications grouped by family.
Answers are generated from the same data shown on this page.