CN103345359B - A kind of gesture is switched the mthods, systems and devices of chart ranks - Google Patents
A kind of gesture is switched the mthods, systems and devices of chart ranks Download PDFInfo
- Publication number
- CN103345359B CN103345359B CN201310215707.XA CN201310215707A CN103345359B CN 103345359 B CN103345359 B CN 103345359B CN 201310215707 A CN201310215707 A CN 201310215707A CN 103345359 B CN103345359 B CN 103345359B
- Authority
- CN
- China
- Prior art keywords
- chart
- displacement
- preset value
- user
- ranks
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Landscapes
- Position Input By Displaying (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
本发明提出一种手势切换图表行列的方法、系统和装置，在该方法中系统首先检测用户施加在图表图例位置上的持续触摸动作；计算该触摸动作的位移量，并将该位移量与预设值相比较，其中：在发生的位移量小于第一预设值时，判断此位移为用户对图例位置的调整动作，随用户触摸位置的移动而调整图例在图表中的位置；在发生的位移量大于第一预设值时，判断此位移为用户对图表行列的切换动作，提供图表的行列切换的预览效果；在发生的位移量继续增大至大于等于第二预设值，并且检测到用户结束其触摸动作时，完成图表行列的切换。本发明的图表行列切换方法切换行列占用的空间相对较小，移动图例位置即可完成切换动作，方便快捷。
The present invention proposes a method, system and device for gesture switching chart rows and columns. In the method, the system first detects the continuous touch action applied by the user on the legend position of the chart; calculates the displacement of the touch action, and compares the displacement with the preset Compared with the set value, wherein: when the amount of displacement that occurs is less than the first preset value, it is judged that the displacement is the adjustment action of the user to the position of the legend, and the position of the legend in the chart is adjusted as the user touches the position; When the displacement is greater than the first preset value, it is judged that the displacement is the user’s switching action of the row and column of the chart, and a preview effect of the row and column switching of the chart is provided; when the displacement continues to increase to be greater than or equal to the second preset value, and detect When the user finishes his touch action, the chart row and column switching is completed. The row and column switching method of the present invention occupies a relatively small space for switching rows and columns, and the switching action can be completed by moving the position of the legend, which is convenient and fast.
Description
技术领域 technical field
本发明涉及一种手势切换图表行列的方法、系统和装置，属于移动应用领域。 The invention relates to a method, system and device for switching chart ranks and columns by gesture, and belongs to the field of mobile applications.
背景技术 Background technique
图表是电子表格中最常用也是最有用的功能之一，可方便地让用户将数据更多样化、更形象化的呈现。行列切换，是在不更改图表的类型基础上，将图表的显示效果调整优化的一种最直接的方式。目前移动设备上的应用很少提供了图表行列切换的方式，就算提供都是用对话框的形式，不符合移动的操作习惯，提供一整个对话框，而且位于一个不起眼的位置，很容易让人忽略。 Charts are one of the most commonly used and useful functions in spreadsheets, allowing users to present data in a more diverse and visual way. Row and column switching is the most direct way to adjust and optimize the display effect of the chart without changing the type of the chart. At present, the applications on mobile devices rarely provide a way to switch chart rows and columns. Even if they are provided, they are in the form of a dialog box, which does not conform to the mobile operating habits. It provides a whole dialog box and is located in an inconspicuous position. People ignore.
目前PC上提供的切换行列的方式为通过右键菜单进入到更改图表数据源对话框后进行切换，这种方式切换行列所占用的空间相对较大，移动设备上没有足够大的空间，不适宜应用在移动设备上，而且切换方式相对隐蔽，用户不易发现。 Currently, the way to switch rows and columns provided on PC is to switch after entering the dialog box of changing chart data source through the right-click menu. This way of switching rows and columns occupies a relatively large space, and there is not enough space on mobile devices, so it is not suitable for application. On mobile devices, and the switching method is relatively hidden, and it is difficult for users to find out.
目前移动设备上的相关应用仅在一开始插入图表时提供了系列产生的选择，功能设置的选项较多，比较容易忽略行列切换这个选项设置。并且一经设置，不能更改。 At present, related applications on mobile devices only provide the selection of series generation when inserting charts at the beginning, and there are many options for function settings, so it is easier to ignore the option setting of row and column switching. And once set, it cannot be changed.
发明内容 Contents of the invention
针对以上现有技术的缺陷，本发明的目的在于提供一种合适移动设备上的手势切换行列方式，根据用户施加在图表的行列位置上的触摸动作的位移量切换该图表行列，方便用户调整图表的显示效果。 In view of the above defects in the prior art, the purpose of the present invention is to provide a gesture switching row and column method on a suitable mobile device, and switch the row and column of the chart according to the displacement of the touch action applied by the user on the row and column position of the chart, so as to facilitate the user to adjust the chart display effect.
本发明的技术方案为： Technical scheme of the present invention is:
一种手势切换图表行列的方法，含有以下步骤： A method for switching chart ranks and columns with gestures, comprising the following steps:
检测用户施加在图表图例位置上的持续触摸动作； Detect the continuous touch action applied by the user on the position of the chart legend;
计算该触摸动作的位移量，并将该位移量与预设值相比较，其中： Calculate the displacement of the touch action, and compare the displacement with the preset value, where:
在发生的位移量小于第一预设值时，判断此位移为用户对图例位置的调整动作，随用户触摸位置的移动而调整图例在图表中的位置； When the amount of displacement occurred is less than the first preset value, it is judged that the displacement is an adjustment action of the user to the position of the legend, and the position of the legend in the chart is adjusted as the user touches the position;
在发生的位移量大于第一预设值时，判断此位移为用户对图表行列的切换动作，提供图表的行列切换的预览效果； When the amount of displacement that occurs is greater than the first preset value, it is judged that the displacement is the switching action of the user on the row and column of the chart, and a preview effect of switching the row and column of the chart is provided;
在发生的位移量继续增大至大于等于第二预设值，并且检测到用户结束其触摸动作时，完成图表行列的切换。 When the amount of displacement continues to increase to be greater than or equal to the second preset value, and it is detected that the user ends his touch action, the chart row and column switching is completed.
此外，本发明还提出了对应以上方法的系统和含有此系统的装置，其中所述系统包括： In addition, the present invention also proposes a system corresponding to the above method and a device containing the system, wherein the system includes:
触摸检测器，检测用户施加在图表图例位置上的持续触摸动作； Touch detector, which detects the continuous touch action applied by the user on the position of the chart legend;
位移计算器，计算该触摸动作的位移量； A displacement calculator, calculating the displacement of the touch action;
比较判断器，将该位移量与预设值相比较，其中： Compare the judger to compare the displacement with the preset value, where:
在发生的位移量小于第一预设值时，判断此位移为用户对图例位置的调整动作，随用户触摸位置的移动而调整图例在图表中的位置； When the amount of displacement occurred is less than the first preset value, it is judged that the displacement is an adjustment action of the user to the position of the legend, and the position of the legend in the chart is adjusted as the user touches the position;
在发生的位移量大于第一预设值时，判断此位移为用户对图表行列的切换动作，提供图表的行列切换的预览效果； When the amount of displacement that occurs is greater than the first preset value, it is judged that the displacement is the switching action of the user on the row and column of the chart, and a preview effect of switching the row and column of the chart is provided;
在发生的位移量继续增大至大于等于第二预设值，并且检测到用户结束其触摸动作时，完成图表行列的切换。 When the amount of displacement continues to increase to be greater than or equal to the second preset value, and it is detected that the user ends his touch action, the chart row and column switching is completed.
含有以上用于手势切换图表行列的系统的装置包括智能手机和带有触摸屏的移动设备。 Devices incorporating the above system for gesture-toggling chart ranks include smartphones and mobile devices with touch screens.
作为以上技术方案的一种改进，所述第一预设值和第二预设值基于用户设备屏幕的大小和/或分辨率确定。 As an improvement of the above technical solution, the first preset value and the second preset value are determined based on the size and/or resolution of the screen of the user equipment.
作为以上技术方案的一种改进，所述第一预设值和第二预设值基于用户设备屏幕上显示的图表大小确定。 As an improvement of the above technical solution, the first preset value and the second preset value are determined based on the size of the graph displayed on the screen of the user equipment.
作为以上技术方案的一种改进，在发生的位移量大于等于第二预设值但未检测到用户结束其触摸动作时，继续提供行列切换的预览效果。 As an improvement of the above technical solution, when the amount of displacement is greater than or equal to the second preset value but it is not detected that the user ends the touch action, the preview effect of row and column switching is continued to be provided.
本发明的图表行列切换方法切换行列占用的空间相对较小，移动图例位置即可完成切换动作，相对于现有的切换方式不仅效果直观，而且操作方便快捷，能极大的提高应用的用户体验。 The row and column switching method of the present invention occupies a relatively small space for switching rows and columns, and the switching action can be completed by moving the position of the legend. Compared with the existing switching method, not only the effect is intuitive, but also the operation is convenient and fast, which can greatly improve the user experience of the application .
附图说明 Description of drawings
以下结合附图和实施例对本发明作进一步说明，其中： The present invention will be further described below in conjunction with accompanying drawing and embodiment, wherein:
图1为本发明的行列切换示意图。 FIG. 1 is a schematic diagram of row and column switching in the present invention.
具体实施方式 detailed description
图1示出了发明提出的手势切换图表行列的方法的一个具体实施例，以常见的簇状柱形图为例，因便携设备的屏幕较小，如常见的智能手机通常只具有3-5寸的屏幕，打开的柱形图会占据屏幕的大部分位置。在这种情况下，简单易用、效果直观的行列切换方式就显得尤为重要。 Fig. 1 shows a specific embodiment of the method for switching chart ranks and columns by gestures proposed by the invention, taking the common clustered column chart as an example, because the screen of the portable device is small, such as a common smart phone usually only has 3-5 inch screen, the open column chart will occupy most of the screen. In this case, an easy-to-use and intuitive row-to-column switching method is particularly important.
采用本方法的应用首先调用系统服务对用户的触摸动作进行检测判断。在此实施例中，系统判断用户的手指是否按在了图表上的图例位置上（所谓图例位置即是图表中代表数据的各种图形占据的范围，举例来说，在柱形图表中即是柱状体占据的范围）。在系统确定用户手指按在柱状体位置后，对用户手指触摸位置的位移量进行计算。在发生小量位移，即发生的位移量小于预设的第一预设值时，系统判断用户的触摸动作仅为图例的位置调整，进而随用户手指的移动调整图例位置。如果期间用户撤销其触摸动作，则将图表的图例放置在用户最后接触的位置。 The application adopting this method first calls the system service to detect and judge the user's touch action. In this embodiment, the system judges whether the user's finger is pressed on the legend position on the chart (the so-called legend position refers to the range occupied by various graphics representing data in the chart, for example, in a column chart is The range occupied by the column). After the system determines that the user's finger is on the position of the column, it calculates the displacement of the user's finger's touch position. When a small amount of displacement occurs, that is, when the displacement is less than the preset first preset value, the system judges that the user's touch action is only for adjusting the position of the legend, and then adjusts the position of the legend with the movement of the user's finger. If the user undoes their touch in between, place the chart's legend where the user last touched.
当系统检测到用户手指发生大量位移，即系统检测到用户手指的位移量大于预设的第一预设值，或者换句话说，在图例即将触碰到图表的坐标轴X轴时（X轴可能在底部、中部或顶部，由图表的实际情况决定）时，系统产生一个行列即将切换的预览图像，供用户预览行列切换后的效果。如果期间用户撤销其触摸动作，则将图表的图例位置返回至原始位置，不做出任何改动。 When the system detects a large amount of displacement of the user's finger, that is, the system detects that the displacement of the user's finger is greater than the preset first preset value, or in other words, when the legend is about to touch the X-axis of the chart's coordinate axis (X-axis may be at the bottom, middle or top, determined by the actual situation of the chart), the system will generate a preview image of the row and column to be switched for the user to preview the effect after the row and column switch. If the user cancels their touch in the meantime, return the chart's legend position to its original position without any changes.
最后在位移量继续增大至大于等于预设的第二预设值，并在检测到用户结束其触摸动作（即松手）后，系统完成行列的切换。典型地，此第二预设值可根据屏幕大小选取适当的值，使得在位移量等于其时图例刚好接触到图表坐标的X轴。 Finally, after the displacement continues to increase to be greater than or equal to the preset second preset value, and after detecting that the user ends his touch action (ie let go), the system completes the switching of rows and columns. Typically, this second preset value can be selected according to the screen size, so that the legend just touches the X-axis of the chart coordinates when the displacement is equal to it.
当然，在另外的实施例中，用户的触摸也可以通过触摸笔来实现。 Of course, in other embodiments, the user's touch can also be realized by a touch pen.
在以上实施例中，所述第一和第二预设值可根据移动设备的屏幕分辨率、大小以及图表的大小来设置，举例来说，对于在常见的854×480的4寸屏幕上以竖屏方式显示柱形图，可根据图表的大小选取第一预设值为数十个像素，而第二预设值则根据图表的图例位置和坐标轴之间的距离选取，其中第一预设值小于第二预设值。 In the above embodiments, the first and second preset values can be set according to the screen resolution, size and chart size of the mobile device. For example, for a common 854×480 4-inch screen with The column chart is displayed in a vertical screen, and the first preset value can be selected according to the size of the chart to be tens of pixels, while the second preset value can be selected according to the distance between the legend position of the chart and the coordinate axis. The first preset value is The set value is smaller than the second preset value.
现有的智能手机和带有触摸屏的移动设备可很方便地应用以上手势切换图表行列的方法，在切换图表行列时占用的空间相对较小，移动图例位置即可完成切换动作，相对于现有的切换方式不仅效果直观，而且操作方便快捷，能极大的提高应用的用户体验。 Existing smartphones and mobile devices with touch screens can easily apply the above method of switching chart ranks and columns with gestures. When switching chart ranks and columns, the space occupied is relatively small, and the switching action can be completed by moving the position of the legend. Compared with the existing The switching method is not only intuitive, but also convenient and quick to operate, which can greatly improve the user experience of the application.
本发明除了上述实施方式之外，其等同技术方案也应当在其保护范围之内，在此不再一一叙述。 In addition to the above-mentioned embodiments of the present invention, its equivalent technical solutions should also be within the scope of its protection, and will not be described one by one here.
Claims (9)
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310215707.XA CN103345359B (en) | 2013-06-03 | 2013-06-03 | A kind of gesture is switched the mthods, systems and devices of chart ranks |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310215707.XA CN103345359B (en) | 2013-06-03 | 2013-06-03 | A kind of gesture is switched the mthods, systems and devices of chart ranks |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103345359A CN103345359A (en) | 2013-10-09 |
| CN103345359B true CN103345359B (en) | 2016-05-11 |
Family
ID=49280159
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310215707.XA Active CN103345359B (en) | 2013-06-03 | 2013-06-03 | A kind of gesture is switched the mthods, systems and devices of chart ranks |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103345359B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US10095389B2 (en) * | 2014-08-22 | 2018-10-09 | Business Objects Software Ltd. | Gesture-based on-chart data filtering |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101408841A (en) * | 2008-11-26 | 2009-04-15 | 浪潮集团山东通用软件有限公司 | General-purpose data multidimensional component exhibiting method |
| CN102156614A (en) * | 2010-01-06 | 2011-08-17 | 苹果公司 | Apparatus, method and graphical user interface for manipulating forms using multi-touch gestures |
| CN102879471A (en) * | 2012-09-21 | 2013-01-16 | 何鲜峰 | Structural tomography method based on chart control |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP4462983B2 (en) * | 2004-03-31 | 2010-05-12 | 株式会社湯山製作所 | Electronic medical record device |
| US20080168402A1 (en) * | 2007-01-07 | 2008-07-10 | Christopher Blumenberg | Application Programming Interfaces for Gesture Operations |
| WO2012088474A2 (en) * | 2010-12-23 | 2012-06-28 | Apple Inc. | Device, method, and graphical user interface for switching between two user interfaces |
-
2013
- 2013-06-03 CN CN201310215707.XA patent/CN103345359B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101408841A (en) * | 2008-11-26 | 2009-04-15 | 浪潮集团山东通用软件有限公司 | General-purpose data multidimensional component exhibiting method |
| CN102156614A (en) * | 2010-01-06 | 2011-08-17 | 苹果公司 | Apparatus, method and graphical user interface for manipulating forms using multi-touch gestures |
| CN102879471A (en) * | 2012-09-21 | 2013-01-16 | 何鲜峰 | Structural tomography method based on chart control |
Non-Patent Citations (2)
| Title |
|---|
| 基于行列转换的统计功能研究与应用张;张娜;《中国优秀硕士学位论文全文数据库（电子期刊）》;20130228;I138-824 * |
| 报表行列转置Excel应用浅析;邢伟平 等;《财会通讯》;20110131(第1期);第121-122页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103345359A (en) | 2013-10-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| JP6122037B2 (en) | Content moving method and apparatus in terminal | |
| US10401964B2 (en) | Mobile terminal and method for controlling haptic feedback | |
| KR102202899B1 (en) | Method and apparatus for providing multiple applications | |
| US8976140B2 (en) | Touch input processor, information processor, and touch input control method | |
| US20160004416A1 (en) | Mobile terminal for controlling icons displayed on touch screen and method therefor | |
| US10579248B2 (en) | Method and device for displaying image by using scroll bar | |
| CN103793093A (en) | Multiscreen portable terminal and touch control method thereof | |
| KR102155836B1 (en) | Mobile terminal for controlling objects display on touch screen and method therefor | |
| US20150339026A1 (en) | User terminal device, method for controlling user terminal device, and multimedia system thereof | |
| US20170047065A1 (en) | Voice-controllable image display device and voice control method for image display device | |
| US10095384B2 (en) | Method of receiving user input by detecting movement of user and apparatus therefor | |
| US10949078B2 (en) | Display apparatus, display method, and non-transitory computer-readable recording medium | |
| CN103914228A (en) | Mobile terminal and touch screen operating method thereof | |
| US10318131B2 (en) | Method for scaling down effective display area of screen, and mobile terminal | |
| US20140168106A1 (en) | Apparatus and method for processing handwriting input | |
| US20160170596A1 (en) | Image display apparatus, image display method, and image-display program product | |
| CN103345359B (en) | A kind of gesture is switched the mthods, systems and devices of chart ranks | |
| JP2015215840A (en) | Information processing apparatus and input method | |
| CN103869941B (en) | Electronic device with virtual touch service and virtual touch real-time calibration method | |
| CN104932755B (en) | Input system and operation method thereof | |
| US20150015510A1 (en) | Electronic device and method for drawing pictures | |
| CN104484117A (en) | Method and device for man-machine interaction | |
| TWI493431B (en) | Method and system for prompting adjustable direction of cursor | |
| CN104063163B (en) | The method and apparatus for adjusting dummy keyboard button size | |
| KR20160040028A (en) | Display apparatus and control methods thereof |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| C56 | Change in the name or address of the patentee | ||
| CP01 | Change in the name or title of a patent holder |
Address after: Jinshan software building No. 8 Jingshan Hill Road, Lane 519015 Lianshan Jida Zhuhai city in Guangdong Province Patentee after: Zhuhai Kingsoft Office Software Co., Ltd. Patentee after: Beijing Kingsoft office software Limited by Share Ltd Address before: Jinshan software building No. 8 Jingshan Hill Road, Lane 519015 Lianshan Jida Zhuhai city in Guangdong Province Patentee before: Zhuhai Kingsoft Office Software Co., Ltd. Patentee before: Beijing Kingsoft WPS Office Co., Ltd. |