Source: https://patents.google.com/patent/US10061473B2/en
Timestamp: 2019-04-24 02:29:47+00:00

Document:
Object editing controls may be provided. First, a selection of an object within an electronic document may be received. Then, in response to the received selection of the object, at least one selectable control may be displayed. The at least one selectable control may be configured to provide a set of most commonly used editing controls for editing the selected object. Upon selection of the at least one selectable control, a user interface comprising the set of most commonly used editing controls may be deployed next to the selected object.
Electronic document editing software may allow users to create and edit objects within electronic documents. The objects may be, for example, pictures, tables, charts, or shapes. The electronic document editing software may provide users with tools for editing and manipulating various properties of these objects. However, these tools are often complex, unorganized, and hard to find within the software.
On-object editing controls may be provided. First, a selection of an object within an electronic document may be received. Then, in response to the received selection of the object, at least one selectable control may be displayed. The at least one selectable control may be configured to provide a set of most commonly used editing controls for editing the selected object. Upon selection of the at least one selectable control, a user interface comprising the set of most commonly used editing controls may be deployed next to the selected object.
Conventional document creation software may provide users with tools for editing objects, such as charts, within an electronic document. The tools for editing the objects may vary for different object types and may be located in various portions, menus, and sub-menus of the software. As a result, these tools may be hard for a typical user to discover and efficiently use for editing.
FIG. 1A illustrates one embodiment of on-object controls 100 consistent with embodiments of the invention. To simplify object editing within document creation software, embodiments of the invention may provide the most commonly used object editing controls in a more user-friendly manner. As shown in FIG. 1A, on-object controls 100 may provide a user with selectable controls 110 displayed on or adjacent to an object 105, such as a chart. When selected, selectable controls 110 may be configured to deploy a user interface, such as a menu, listing, for example, the most commonly used object editing controls. In this way, a user may not need to navigate through complex user interface operations to find the most desirable editing controls.
FIG. 1B illustrates another embodiment of on-object controls 120 consistent with embodiments of the invention. As mentioned above, selectable controls 110 may be displayed over portions of object 105. For example, a title portion 125 of object 105 may comprise a selectable control 130 that is operative to, upon selection, deploy a user interface for entering an object title. In this way, the user may be enabled to quickly enter the object title without processing through complex user interface operations.
Selectable controls 110 may comprise controls operative to, for example, provide the user with options to add chart elements, edit chart layout, and edit chart style. To assist the user in understanding the functionality of selectable controls 110, a tool-tip 115 may be displayed adjacent to each control upon a user focusing, for example, a pointing device over each control. Tool tip 115 may indicate to the user a functionality of the focused control. As will be discussed in further detail with reference to FIG. 2, upon selection of the focused control, the user may be provided a menu comprising the most commonly used controls in editing objects of a same type as object 105.
FIG. 2 is a flow chart setting forth the general stages involved in a method 200 consistent with an embodiment of the invention for providing object editing controls. Method 200 may be implemented using a computing device 400 as described in more detail below with respect to FIG. 4. Ways to implement the stages of method 200 will be described in greater detail below.
Method 200 may begin at starting block 205 and proceed to stage 210 where computing device 400 may receive a selection of object 105 within an electronic document. For example, the user may click on object 105 that may comprise, but not be limited to, for example, a chart, a graph, a text, a text box, a picture, and a shape.
From stage 210, where computing device 400 received the selection of object 105, method 200 may advance to stage 220 where computing device 400 may display selectable controls 110. Selectable controls 110 may be particular to editing selected object 105. Furthermore, to reduce user-interface clutter, various embodiments of the invention may hide selectable controls 110 from display when object 105 is not selected. Once the user selects object 105 for editing, selectable controls 110 may be displayed.
As shown in FIG. 1, selectable controls 110 may comprise, for example, three buttons. A first button may correspond to, for example, controls for editing a layout of underlying data corresponding to object 105 (e.g., chart layout). A second button may correspond to, for example, controls for editing elements displayed within object 105 (e.g., chart element addition/removal). A third button may correspond to, for example, controls for editing a style of object 105 (e.g., chart style). A location of display for selectable controls 110 may be, for example, fixed at an upper-right corner of object 105. When object 105 is moved, selectable controls 110 may move along with object 105.
Once computing device 400 displays selectable controls 110 in stage 320, method 200 may continue to stage 230 where computing device 400 may receive a selection of a selectable control from selectable controls 110. A state of the selected control may change to reflect a type of selection. For example, the default state of each selectable control may be an ‘unselected’ state. In this state, an icon reflecting each selectable control may have a first representation. Similarly, when selected, the icon reflecting the selected control may have a second representation within the ‘selected state’.
In various embodiments, when a user's input device, such as a mouse or keyboard, hovers over or highlights one of the selectable controls, the focused control may transition to a ‘rollover’ state. In this state, the icon reflecting the focused control may glow, for example. In addition, when a selectable control is not applicable for editing selected object 105, the selectable control may be set to a ‘disabled’ state having a disabled representation. Alternatively, the selectable control may not be displayed at all when in the ‘disabled’ state.
After computing device 400 receives a selection of the selectable control in stage 230, method 200 may proceed to stage 240 where computing device 400 may deploy a user interface comprising editing controls for object 105. The user interface may comprise, as illustrated in FIG. 3, for example, a fly-out menu 305 deployed in response to a selection of the selectable control. By default, fly-out menu 305 may comprise editing controls that are most commonly used with editing objects such as object 105. However, a user may configure fly-out menu 305 and manually select which editing controls would be displayed in fly-out menu 305.
In various embodiments, the editing controls within fly-out menu 305 may take the form of, for example, checkboxes 310. However, any form of selectable editing controls may be used. Each checkbox 310 may have a corresponding label 315. Label 315 may indicate an editing function or property that may be applied, or is currently applied, to object 105. For example, if a legend and gridlines are displayed within object 105, the corresponding checkboxes for the legend and gridlines would be checked.
Consistent with embodiments of the invention, a user may preview the editing function or property represented by the editing controls in menu 305. For example, when the user's input device hovers over or highlights an editing control within menu 305, object 105 may be dynamically modified to reflect the underlying function or property of the corresponding editing control. As shown in FIG. 3, trendline 330 may be displayed within object 105 when the trendline editing control is highlighted (e.g., though the checkbox remains unchecked). The dynamic modification may only be temporary. In this way, a user may preview the function or property of each editing control prior to application.
To apply the underlying function or property of the corresponding editing control, the user may select the checkbox representing the editing control. In addition, while the user's input device remains focused on the editing control, an options trigger 320 may appear. Options trigger 320 may indicate that additional options pertaining to the focused editing control are available. Not every editing control may have options trigger 320. Once the user selects options trigger 320, additional options may be provided in an additional fly-out menu 325. Fly-out menu 305 and additional fly-out menu 325 may be deployed adjacent to object 105. However, depending on the available space within the electronic document, the layout of fly-out menu 305 and additional fly-out menu 325 may be modified to best fit the electronic document.
Consistent with embodiments of the invention, editing controls within menu 305 may not only be preselected as the most commonly used controls for object editing, but the editing controls may also be preconfigured to have the most commonly used properties. For example, a chart may comprise gridlines that may be vertical, horizontal, or both. When a user selects the ‘gridlines’ editing control in menu 305, computing device 300 may run an algorithm to determine the most commonly used type of gridline for objects of a similar type as object 105. Computing device 300 may then apply the most commonly used type of gridline without the user having specified a type of gridline.
Should the user desire to manually select, for example, the type of gridline or any other control property, a user may be provided with an option (not show in FIG. 3) to enter a format object task pane (FOTP) to manually select the properties of the editing controls. Once computing device 400 deploys the user interface comprising the editing controls in stage 240, method 200 may then end at stage 250.
An embodiment consistent with the invention may comprise a system for providing object editing controls. The system may comprise a memory storage and a processing unit coupled to the memory storage. The processing unit may be operative to receive a first selection of an object and display at least one selectable control. In addition, the processing unit may be operative to receive a second selection of the at least one selectable control and to deploy a menu comprising commonly used editing controls for editing the object.
Another embodiment consistent with the invention may comprise a system for providing object editing controls. The system may comprise a memory storage and a processing unit coupled to the memory storage. The processing unit may be operative to receive a first selection of an object within an electronic document and overlay, in response to receiving the first selection, at least one selectable control on top of the object. The at least one selectable control may be configured to provide, upon selection, a set editing controls for the object. In addition, the processing unit may be operative to receive a second selection of the at least one selectable control and to deploy, in response to receiving the second selection, a plurality of checkboxes representing the set of editing controls in a menu displayed adjacently to the object.
Yet another embodiment consistent with the invention may comprise a system for providing object editing controls. The system may comprise a memory storage and a processing unit coupled to the memory storage. The processing unit may be operative to display a chart in an electronic document and to display a chart in an electronic document. Furthermore, the processing unit may be operative to receive a first selection of the chart and to display, in response to the first selection of the chart, at least one selectable control for editing the chart at one of the following positions: over a portion of the chart, and within a user-interface corresponding to the electronic document. Moreover, the processing unit may be operative to receive a second selection of the at least one selectable control and to determine a plurality of commonly used controls for editing the chart. In addition, the processing unit may be operative to display, in response to the second selection, the plurality of commonly used controls, receive indication of user-focus on one of the plurality of commonly used controls, and to preview a functionality of the user-focused control.
FIG. 4 is a block diagram of a system including computing device 400. Consistent with an embodiment of the invention, the aforementioned memory storage and processing unit may be implemented in a computing device, such as computing device 400 of FIG. 4. Any suitable combination of hardware, software, or firmware may be used to implement the memory storage and processing unit. For example, the memory storage and processing unit may be implemented with computing device 400 or any of other computing devices 418, in combination with computing device 400. The aforementioned system, device, and processors are examples and other systems, devices, and processors may comprise the aforementioned memory storage and processing unit, consistent with embodiments of the invention.
With reference to FIG. 4, a system consistent with an embodiment of the invention may include a computing device, such as computing device 400. In a basic configuration, computing device 400 may include at least one processing unit 402 and a system memory 404. Depending on the configuration and type of computing device, system memory 404 may comprise, but is not limited to, volatile (e.g. random access memory (RAM)), non-volatile (e.g. read-only memory (ROM)), flash memory, or any combination. System memory 404 may include operating system 405, one or more programming modules 406, and may include a program data 407. Operating system 405, for example, may be suitable for controlling computing device 400's operation. In one embodiment, programming modules 406 may include document creation application 420 and object editing module 425. Document creation application 420 may be operative to perform, for example, word processing, spreadsheet processing, and/or presentation processing. Furthermore, embodiments of the invention may be practiced in conjunction with a graphics library, other operating systems, or any other application program and is not limited to any particular application or system. This basic configuration is illustrated in FIG. 4 by those components within a dashed line 408.
Computing device 400 may have additional features or functionality. For example, computing device 400 may also include additional data storage devices (removable and/or non-removable) such as, for example, magnetic disks, optical disks, or tape. Such additional storage is illustrated in FIG. 4 by a removable storage 409 and a non-removable storage 410. Computer storage media may include volatile and nonvolatile, removable and non-removable media implemented in any method or technology for storage of information, such as computer readable instructions, data structures, program modules, or other data. System memory 404, removable storage 409, and non-removable storage 410 are all computer storage media examples (i.e. memory storage.) Computer storage media may include, but is not limited to, RAM, ROM, electrically erasable read-only memory (EEPROM), flash memory or other memory technology, CD-ROM, digital versatile disks (DVD) or other optical storage, magnetic cassettes, magnetic tape, magnetic disk storage or other magnetic storage devices, or any other medium which can be used to store information and which can be accessed by computing device 400. Any such computer storage media may be part of device 400. Computing device 400 may also have input device(s) 412 such as a keyboard, a mouse, a pen, a sound input device, a touch input device, etc. Output device(s) 414 such as a display, speakers, a printer, etc. may also be included. The aforementioned devices are examples and others may be used.
As stated above, a number of program modules and data files may be stored in system memory 404, including operating system 405. While executing on processing unit 402, programming modules 406 (e.g. document creation application 420 and object editing module 425) may perform processes including, for example, one or more method 200's stages as described above. The aforementioned process is an example, and processing unit 402 may perform other processes. Other programming modules that may be used in accordance with embodiments of the present invention may include electronic mail and contacts applications, word processing applications, spreadsheet applications, database applications, slide presentation applications, drawing or computer-aided application programs, etc.
In a distributed computing environment, program modules may be located in both local and remote memory storage devices. The program modules may be stored on any number of storage media that may be accessed by via a wired or wireless connection. Similarly, the modules may be readily accessed and transferred between computing devices.
Embodiments of the invention may be practiced via a system-on-a-chip (SOC) where each or many of the components illustrated in FIG. 4 may be integrated onto a single integrated circuit. Such an SOC device may include one or more processing units, graphics units, communications units, system virtualization units and various application functionality all of which may be integrated (or “burned”) onto the chip substrate as a single integrated circuit. When operating via an SOC, the functionality described herein with respect to embodiments of the invention, may be performed via application-specific logic integrated with other components of computing device 400 on the single integrated circuit (chip). Moreover, the components illustrated in FIG. 4 may be practiced, for example, in a mobile device or in a cloud computing system.
Computing device 400 may be coupled to a camera that may be operative to record a user and capture motions and/or gestures made by the user. Computing device 400 may be further operative to capture words spoken by the user, such as by a microphone, and/or capture other inputs from the user such as by a keyboard and/or mouse. Consistent with embodiments of the invention, the camera may comprise any motion detection device capable of detecting the movement of the user. For example, the camera may comprise a Microsoft® Kinect® motion capture device comprising a plurality of cameras and a plurality of microphones.
applying a functionality of the editing control corresponding to the selected at least one checkbox.
displaying a checkbox for the most commonly used editing controls.
a third selectable control configured to provide, upon selection, style controls.
4. The computer-readable hardware device of claim 1, further comprising displaying, upon receiving an indication of user-focus on the at least one selectable control, a tool-tip for the at least one selectable control.
5. The computer-readable hardware device of claim 1, wherein deploying, in response to receiving the second selection, the plurality of checkboxes representing the set of editing controls comprising deploying the plurality of checkboxes having certain checkboxes preselected when the object reflects properties corresponding to those certain checkboxes.
providing, in response to the indication of the user-focus, an additional selectable control configured to, upon selection, deploy additional controls operative to edit parameters of an editing control corresponding to the at least one checkbox.
provide, in response to receiving the indication of the user-focus on a control in the plurality of commonly used controls, a preview comprising a temporarily modified object reflecting an underlying functionality of the user-focused control.
8. The system of claim 7, wherein displaying the commonly used controls includes displaying a checkbox corresponding to each of the set of most commonly used controls, the checkbox having a corresponding label indicating an editing function that may be applied upon the selection of the checkbox.
9. The system of claim 7, wherein the processor is further configured to display one or more additional selectable controls as an overlay over a portion of the object.
10. The system of claim 7, wherein the processor is further configured to display, upon receiving an indication of user-focus on the at least one selectable control, a tool-tip for the at least one selectable control.
11. The system of claim 7, wherein the processor is further configured to display, in response to receiving the second selection, the set of controls pertaining to the object comprises deploying editing controls having their control parameters optimized to correspond to a chart type.
12. The system of claim 7, wherein the at least one selectable control include one or more of a control for editing the layout of the chart, a control for editing elements displayed within the chart, or a control for editing a style of the chart.
13. The system of claim 7, wherein the plurality of commonly used editing controls include one or more of a title editing control, an axis title editing control, a legend editing control, a gridlines editing control, a data labels editing control, a data table editing control, a trendline editing control, or an error bars editing control.
providing, in response to receiving the indication of the user-focus on the one of the plurality of commonly used controls, a preview comprising a temporarily modified object reflecting an underlying functionality of the user-focused control.
15. The method of claim 14, wherein the method further comprises displaying, in response to receiving the indication of user-focus on the one of the plurality of commonly used controls, an options trigger adjacent the one of the plurality of commonly used controls.
in response to receiving the selection of the options trigger, displaying a fly-out menu containing additional options for editing the chart.
17. The method of claim 14, wherein the at least one selectable control include one or more of a control for editing the layout of the chart, a control for editing elements displayed within the chart, or a control for editing a style of the chart.
18. The method of claim 14, wherein the plurality of commonly used editing controls include one or more of a title editing control, an axis title editing control, a legend editing control, a gridlines editing control, a data labels editing control, a data table editing control, a trendline editing control, or an error bars editing control.
applying a functionality of the selected at least one editing control to the chart.
20. The method of claim 14, wherein displaying the commonly used controls includes displaying a checkbox corresponding to each of the set of most commonly used controls, the checkbox having a corresponding label indicating an editing function that may be applied upon the selection of the checkbox.
"Chart Component .NET ver. 4.4," Printed: Jul. 27, 2011, available at http://www.chartcomponent.com/, 1pg.
"OLAP Statistics & Reporting," Retrieved: Sep. 2, 2011, 4 pgs., http://www.assistmyteam.net/OLAPStatistics/.
Ani Gupta (nickname: Soan), "Excel Chart Advisor will Create and Suggest Charts for your Data," published on May 29, 2010, available at: http://am22tech.com/s/22/Blogs/post/2010/05/29/Excel-Chart-advisor-will-create-and-suggest-charts-for-your-data.aspx, 4 pgs.
Brian Jones, "Document Assembly Solution for SpreadsheetML," Retrieved at <http://blogs.msdn.com/b/brian_jones/archive/2008/11/04/document-assembly-solution-for-spreadsheetmt.aspx>, Nov. 4, 2008, 11 pgs.
Chinese First Office Action dated Jan. 26, 2015 cited in Application No. 201210448502.1 13 pgs.
Chinese First Office Action dated Jan. 7, 2015 cited in Application No. 201210362781.X, 15 pgs.
Chinese First Office Action with Search Report cited in Application No. 201210387253.X dated Jan. 19, 2015, 13 pgs.
Chinese Office Action and Search Report Issued in Patent Application No. 201210514600.0, dated Sep. 30, 2014, 14 Pages.
Chinese Second Office Action Issued in Patent Application No. 201210387253.X, dated Jul. 8, 2015, 6 Pages.
Gary Klass. Presenting Data: Tabular and graphic display of social indicators. "Constructing Good Charts and Graphs" Printed Jul. 27, 2011, available at http://lilt.ilstu.edu/gmklass/pos138/datadisplay/sections/goodcharts.htm, 28pgs.
International Search Report dated Feb. 26, 2013 cited in Application No. PCT/US2012/066489, 9 pgs.
International Search Report dated Feb. 28, 2013 cited in Application No. PCT/US2012/057159, 13 pgs.
Jean-Luc Doumont et al., "Choosing the Right Graph," Retrieved at <http://users.ece.gatech.edu/˜gpalmer/ece8020/documents/PDF/Graphs.pdf>, IEEE Transactions on Professional Communication, vol. 45, No. 1, Mar. 2002, pp. 1-6.
John Marinuzzi, "PowerPivot for Excel 2010," Retrieved at <https://community.altiusconsulting.com/blogs/altiustechblog/archive/2011/05/04/powerpivot-for-excel-2010.aspx>, May 4, 2011, 5 pgs.
Jonathan I. Helfman et al., "Selecting the Best Graph Based on Data, Tasks, and User Roles." Jun. 11-15, 2007. http://www.upassoc.org/usability_resources/conference/2007/prp_049.pdf, 10 pgs.
Mayes; "Office Labs Chart Advisor for Excel"; TVMCalcs.com; Aug. 25, 2008; Retrieved from the internet: http://www.tvmcalcs.com/index.php/blog/comments/office_labs_chart_advisor_for excel; 6 pgs.
Notice of Allowance dated Apr. 24, 2015 cited in U.S. Appl. No. 13/272,522, 11 pgs.
Notice of Allowance Issued in U.S Patent Application No. 13/272,522 dated May 22, 2015, 4 pgs.
Office Action dated Jul. 27, 2015 cited in U.S. Appl. No. 13/311,541, 21 pgs. (Not at M&G).
U.S. Appl. No. 14/811,090 entitled "Suggesting Alternate Data Mappings for Charts" filed Jul. 28, 2015.
U.S. Appl. No. 14/811,090, Advisory Action dated Apr. 11, 2017, 3 pages.
U.S. Appl. No. 14/811,090, Office Action dated Aug. 25, 2016. 19 pages.
U.S. Appl. No. 14/811,090, Office Action dated Jan. 13, 2017, 17 pages.
U.S. Appl. No. 14/811,090, Office Action dated Jun. 8, 2016, 24 pages.
U.S. Appl. No. 14/811,090, Office Action dated Sep. 22, 2017, 20 pages.
U.S. Final Office Action dated Apr. 15, 2013 cited in U.S. Appl. No. 13/272,522, 24 pgs.
U.S. Final Office Action dated Jun. 11, 2013 cited in U.S. Appl. No. 13/245,126, 24 pgs.
U.S. Final Office Action dated Mar. 12, 2014, cited in U.S. Appl. No. 13/272,522, 19 pgs.
U.S. Office Action dated Dec. 1, 2014 cited in U.S. Appl. No. 13/245,126, 15 pgs.
U.S. Office Action dated Jan. 16, 2015 cited in U.S. Appl. No. 13/311,541, 19 pgs.
U.S. Office Action dated Jun. 13, 2014, cited in U.S. Appl. No. 13/245,126, 35 pgs.
U.S. Office Action dated Jun. 25, 2015 cited in U.S. Appl. No. 13/245,126, 37 pgs.
U.S. Office Action dated Mar. 19, 2013 cited in U.S. Appl. No. 13/311,541, 13 pgs. ('541).
U.S. Office Action dated Nov. 4, 2013 cited in U.S. Appl. No. 13/298,285, 18 pgs. (HB Law Firm).
U.S. Office Action dated Nov. 6, 2014 cited in U.S. Appl. No. 13/272,522, 25 pgs.
U.S. Office Action dated Oct. 22, 2012 cited in U.S. Appl. No. 13/245,126, 18 pgs.
U.S. Office Action dated Oct. 24, 2012 cited in U.S. Appl. No. 13/272,522, 23 pgs.
U.S. Office Action dated Sep. 26, 2013 cited in U.S. Appl. No. 13/272,522, 27 pgs.
U.S. Office Action dated Sep. 6, 2013 cited in U.S. Appl. No. 13/311,541, 20 pgs. (HB Law Firm).
U.S.Office Action dated Dec. 1, 2015 cited in U.S. Appl. No. 14/811,090, 29 pgs.
Wikipedia. "Wikipedia talk:Collaboration to convert graphs to SVG " Printed: Jul. 27, 2011, http://en.wikipedia.org/wiki/Wikipedia_talk:Collaboration_to_convert_graphs_to_SVG#AAutomati_charts, 6pgs.

References: Application No. 201210448502
 Application No. 201210362781
 Application No. 201210387253
 Application No. 201210514600
 Application No. 201210387253
 Application No. 13