WO2013071837A1 - 一种在手持触摸设备上控制电子表格的方法 - Google Patents

一种在手持触摸设备上控制电子表格的方法 Download PDF

Info

Publication number
WO2013071837A1
WO2013071837A1 PCT/CN2012/084315 CN2012084315W WO2013071837A1 WO 2013071837 A1 WO2013071837 A1 WO 2013071837A1 CN 2012084315 W CN2012084315 W CN 2012084315W WO 2013071837 A1 WO2013071837 A1 WO 2013071837A1
Authority
WO
WIPO (PCT)
Prior art keywords
spreadsheet
initial position
touch
electronic form
touch signal
Prior art date
Application number
PCT/CN2012/084315
Other languages
English (en)
French (fr)
Inventor
王冬
赵威
黎志宇
Original Assignee
珠海金山办公软件有限公司
珠海金山软件有限公司
王晖
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by 珠海金山办公软件有限公司, 珠海金山软件有限公司, 王晖 filed Critical 珠海金山办公软件有限公司
Priority to AU2012339393A priority Critical patent/AU2012339393B2/en
Priority to EP12850202.8A priority patent/EP2781997A4/en
Priority to US14/356,765 priority patent/US9619454B2/en
Priority to JP2014541522A priority patent/JP5918857B2/ja
Priority to CA2850982A priority patent/CA2850982C/en
Publication of WO2013071837A1 publication Critical patent/WO2013071837A1/zh

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
    • G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
    • G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
    • G06F3/0487—Interaction techniques based on graphical user interfaces [GUI] using specific features provided by the input device, e.g. functions controlled by the rotation of a mouse with dual sensing arrangements, or of the nature of the input device, e.g. tap gestures based on pressure sensed by a digitiser
    • G06F3/0488—Interaction techniques based on graphical user interfaces [GUI] using specific features provided by the input device, e.g. functions controlled by the rotation of a mouse with dual sensing arrangements, or of the nature of the input device, e.g. tap gestures based on pressure sensed by a digitiser using a touch-screen or digitiser, e.g. input of commands through traced gestures
    • G06F3/04883—Interaction techniques based on graphical user interfaces [GUI] using specific features provided by the input device, e.g. functions controlled by the rotation of a mouse with dual sensing arrangements, or of the nature of the input device, e.g. tap gestures based on pressure sensed by a digitiser using a touch-screen or digitiser, e.g. input of commands through traced gestures for inputting data by handwriting, e.g. gesture or text
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
    • G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
    • G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
    • G06F3/0487—Interaction techniques based on graphical user interfaces [GUI] using specific features provided by the input device, e.g. functions controlled by the rotation of a mouse with dual sensing arrangements, or of the nature of the input device, e.g. tap gestures based on pressure sensed by a digitiser
    • G06F3/0488—Interaction techniques based on graphical user interfaces [GUI] using specific features provided by the input device, e.g. functions controlled by the rotation of a mouse with dual sensing arrangements, or of the nature of the input device, e.g. tap gestures based on pressure sensed by a digitiser using a touch-screen or digitiser, e.g. input of commands through traced gestures
    • G06F3/04886—Interaction techniques based on graphical user interfaces [GUI] using specific features provided by the input device, e.g. functions controlled by the rotation of a mouse with dual sensing arrangements, or of the nature of the input device, e.g. tap gestures based on pressure sensed by a digitiser using a touch-screen or digitiser, e.g. input of commands through traced gestures by partitioning the display area of the touch-screen or the surface of the digitising tablet into independently controllable areas, e.g. virtual keyboards or menus
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets

Definitions

  • the present invention relates to a method of controlling a spreadsheet on a handheld touch device.
  • a spreadsheet contains cells with numeric values. Multiple cell values can be mathematically manipulated, such as summation, averaging, and so on.
  • Spreadsheet software on a PC PC such as Office
  • the method provided by Excel is to automatically perform calculations after selecting multiple cell data by mouse, and display the results on the status bar.
  • a handheld touch device the user can use the touch on the touch screen of the device to control the use of the device, such as iphone3, 4 mobile phone, HTC On the G11, G14 mobile phones, etc., it is limited by the screen size of the device.
  • the spreadsheet software on the market also stops providing this function that can greatly facilitate the user while simplifying the function.
  • a method of controlling a spreadsheet on a handheld touch device comprising the following process:
  • Handheld touch device Receiving a selection touch signal of the selected cell, selecting a selected cell in the spreadsheet according to the selection touch signal, and then performing calculation according to a preset processing method, and saving the calculation result;
  • Display process Handheld touch device Receiving a first touch signal for moving the spreadsheet from the initial position to the rest position, moving the spreadsheet from the initial position to the resting position according to the first touch signal to display a blank area, and querying whether there is a calculation result, if any , the calculation result is displayed in the blank area;
  • the display process also includes the following process: when the blank area is presented and there is a calculation result, the handheld touch device Receiving a third touch signal that points any calculation result to an unused cell, and displays the calculation result in the unused cell according to the third touch signal.
  • Controlling the first touch signal of the spreadsheet from the initial position to the resting position specifically: pressing and holding the place corresponding to the spreadsheet on the touch screen and moving to an area outside the blank area; controlling the spreadsheet to move from the resting position to The second touch signal in the initial position is specifically: pressing and holding the place corresponding to the spreadsheet on the touch screen and moving toward or away from the blank area.
  • the method for controlling the transfer of the electronic form between the initial position and the resting position is specifically: the electronic form is provided with a mobile function button for being touched by the touch to control the transfer of the electronic form between the initial position and the resting position.
  • the move function button When the spreadsheet is in the initial position, the move function button displays the down mark; when the spreadsheet is in the hold position, the move function button displays the up mark.
  • the present invention displays the calculation result by moving the touch spreadsheet to display a blank area, and can clearly display the calculation result for the user to use.
  • 1 is a flow chart of a processing method in an operation process
  • 2 through 6 are flow diagrams of operating a spreadsheet.
  • a method of controlling a spreadsheet on a handheld touch device comprising the following process:
  • the operation process receiving a selection touch signal of the selected cell, selecting the selected cell in the electronic table according to the selection touch signal, and then performing calculation according to a preset processing method, and saving the calculation result;
  • Display process receiving a first touch signal for moving the spreadsheet from the initial position to the rest position, moving the spreadsheet from the initial position to the resting position according to the first touch signal to display a blank area, and then querying whether there is a calculation As a result, if it exists, the calculation result is displayed in the blank area;
  • Recovery process receiving a second touch signal that controls the spreadsheet to move back from the resting position to the initial position, according to the second touch signal, moving the spreadsheet back to the initial position, and the spreadsheet covers the blank area.
  • the display process further includes the following process: when the blank area is presented and the calculation result is present, receiving a third touch signal that points any calculation result into an unused cell, and the unused unit is used according to the touch signal. Fill in the calculation result in the grid.
  • the third touch signal is specifically: dragging and dropping any calculation result on the touch screen to an unused cell.
  • Controlling the first touch signal of the spreadsheet from the initial position to the resting position specifically: correspondingly pressing and holding the spreadsheet on the touch screen An area outside the blank area; the second touch signal that controls the electronic table to move from the rest position to the initial position, specifically: correspondingly pressing the electronic table on the touch screen to move toward or away from the blank area.
  • the processing method in the operation process includes the following processes:
  • S04 determining the number of data that can be calculated, if the number is 1, the calculation result is the data; if the number is greater than 1, then turning to S05;
  • S05 Calculate the operable data according to the arbitrable rules.
  • the non-operable rule in step S03 is to calculate the number of selected cells.
  • the operational rule in step S05 includes calculating the number of operable data, the minimum and maximum values of the data, the average of the data, and the sum of the data.
  • the present embodiment provides for operating a spreadsheet using a handheld touch device that uses the present invention to control a spreadsheet:
  • the spreadsheet is opened by the handheld touch device, and the spreadsheet is in the initial position;
  • the touch screen is selected by the touch screen input to select the cells A1-A3, and the handheld touch device performs calculation according to the preset processing method according to the selected touch signal, and saves the calculation result;
  • the user inputs the first touch signal, specifically, the place corresponding to the electronic form on the touch screen (the place to be pressed is specifically corresponding to the title of the spreadsheet) and downward Moving to an area outside the blank area; the handheld touch device will electronically according to the first touch signal
  • the control signal displays 80 in cell A4;
  • the user inputs a second touch signal, specifically, Press and hold the position corresponding to the title of the spreadsheet on the touch screen and move upward (ie, toward the blank area); the handheld touch device moves the spreadsheet to the initial position according to the second touch signal, and the spreadsheet covers the blank area.
  • a second touch signal specifically, Press and hold the position corresponding to the title of the spreadsheet on the touch screen and move upward (ie, toward the blank area); the handheld touch device moves the spreadsheet to the initial position according to the second touch signal, and the spreadsheet covers the blank area.
  • the embodiment further provides a specific method, which may coexist in the implementation of the corresponding one, or replace the corresponding one.
  • the method for controlling the transfer of the electronic form between the initial position and the resting position is specifically: the electronic form is provided with a mobile function button for being touched by the touch to control the transfer of the electronic form between the initial position and the resting position; the first touch The control signal and the second touch signal are all corresponding to the touch click and the mobile function button on the touch screen.
  • the following design is made: when the spreadsheet is in the initial position, the mobile function button displays the down mark; when the spreadsheet is in the hold position, the move function button displays the up mark.
  • the present invention is not limited to the above embodiments, and a simple replacement based on the above-described embodiments without creative work should fall within the scope of the present invention.

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • General Engineering & Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Human Computer Interaction (AREA)
  • Health & Medical Sciences (AREA)
  • Artificial Intelligence (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Computational Linguistics (AREA)
  • General Health & Medical Sciences (AREA)
  • User Interface Of Digital Computer (AREA)
  • Position Input By Displaying (AREA)

Abstract

本发明涉及一种在手持触摸设备上控制电子表格的方法，包括以下过程：运算过程：接收选择单元格的选择触控信号，根据该选择触控信号选定电子表格中被选择的单元格，然后按预先设置的处理方法进行计算，并保存计算结果；显示过程：接收控制将电子表格从初始位置移至搁置位置的第一触控信号，根据该第一触控信号将电子表格从初始位置移至搁置位置以显示出空白区，查询是否存在计算结果，若存在，则在空白区显示计算结果；恢复过程：接收控制将电子表格从搁置位置移回初始位置的第二触控信号，据该第二触控信号将电子表格移回初始位置，电子表格覆盖空白区。本发明能清楚地显示计算结果，利于使用者使用。

Description

一种在手持触摸设备上控制电子表格的方法 技术领域
本发明涉及一种在手持触摸设备上控制电子表格的方法。
背景技术
电子表格中包含具有数值的单元格，多个单元格数值可以进行数学运算，例如求和，求平均数等。在PC个人电脑上的电子表格软件，如Office Excel提供的方法是：通过鼠标选中多个单元格数据后自动进行计算操作，并将结果显示在状态条上。而在手持触摸设备(使用者可以在该设备的触控屏幕上使用触摸的方式来控制该设备的使用，例如iphone3、4手机，HTC G11、G14手机等)上，受限于设备屏幕大小，市面上的电子表格软件在精简功能的同时，也停止提供这一能为使用者带来极大便利的功能
技术解决方案
本发明 要解决的技术问题 是提供一种在手持触摸设备上控制电子表格的方法，能清楚地显示计算结果，利于使用者使用。
上述 技术问题 通过以下技术方案实现：
一种在手持触摸设备上控制电子表格的方法，其特征在于， 包括以下过程：
运算过程： 手持触摸设备 接收选择单元格的选择触控信号，根据该选择触控信号选定电子表格中被选择的单元格，然后按预先设置的处理方法进行计算，并保存计算结果;
显示过程： 手持触摸设备 接收控制将电子表格从初始位置移至搁置位置的第一触控信号，根据该第一触控信号将电子表格从初始位置移至搁置位置以显示出空白区，查询是否存在计算结果，若存在，则在空白区显示计算结果；
恢复过程： 手持触摸设备 接收控制将电子表格从搁置位置移回初始位置的第二触控信号，根据该第二触控信号将电子表格移回初始位置，电子表格覆盖空白区。
显示过程还包括下述过程：当空白区呈现并存在计算结果时， 手持触摸设备 接收将任意一计算结果指向一未用的单元格中的第三触控信号，根据该第三触控信号在上述未用的单元格中显示该计算结果。
控制电子表格从初始位置移至搁置位置的第一触控信号，具体为：在触控屏幕上按住与电子表格对应的地方并移动至空白区以外的区域；控制电子表格从搁置位置移至初始位置的第二触控信号，具体为：在触控屏幕上按住与电子表格对应的地方并朝向或背向空白区进行移动。
控制电子表格在初始位置和搁置位置之间转移的方法具体为：电子表格上设有一用于被触控点击以控制电子表格在初始位置和搁置位置之间转移的移动功能按钮。
当电子表格在初始位置时，移动功能按钮显示朝下标识；当电子表格在搁置位置时，移动功能按钮显示朝上标识。
由上述方案可见，本发明通过触控电子表格移动以显示出空白区来显示计算结果，能够清楚地显示计算结果，利于使用者使用。
 附图说明
图1为运算过程中的处理方法的流程图；
图2至图6为操作电子表格的流程图。
 本发明的实施方式
实施例一
一种在手持触摸设备上控制电子表格的方法,包括以下过程：
运算过程：接收选择单元格的选择触控信号，根据该选择触控信号选定电子表格中被选择的单元格，然后按预先设置的处理方法进行计算，并保存计算结果;
显示过程：接收控制将电子表格从初始位置移至搁置位置的第一触控信号，根据该第一触控信号将电子表格从初始位置移至搁置位置以显示出空白区，然后查询是否存在计算结果，若存在，则在空白区显示计算结果；
恢复过程：接收控制将电子表格从搁置位置移回初始位置的第二触控信号，据该第二触控信号将电子表格移回初始位置，电子表格覆盖空白区。
显示过程还包括下述过程：当空白区呈现并存在计算结果时，接收将任意一计算结果指向一未用的单元格中的第三触控信号，根据该触控信号在上述未用的单元格中填入该计算结果。第三触控信号具体为，在触控屏幕上对应地按住任意一计算结果拖向一未用的单元格。
控制电子表格从初始位置移至搁置位置的第一触控信号，具体为：在触控屏幕上对应地按住电子表格 移动 至空白区以外的区域；控制电子表格从搁置位置移至初始位置的第二触控信号，具体为：在触控屏幕上对应地按住电子表格朝向或背向空白区进行移动。
其中，如图1所示，运算过程中的处理方法，包括以下流程：
S01 ：判断被选择的单元格内是否有数据，若否，则计算结果为空；若是，转S02;
S02 ：判断数据的个数，若个数为1，则计算结果为该数据；若个数大于1，则转S03；
S03 ：判断这些数据是否存在可运算，若否，则按非可运算规则计算；若是，则转S04；
S04 ：判断可运算的数据的个数，若个数为1，则计算结果为该数据；若个数大于1，则转S05；
S05 ：将这些可运算的数据按可运算规则进行计算。
其中，步骤S03中的非可运算规则为计算被选择的单元格的个数。
步骤S05中可运算规则包括计算可运算的数据的个数，这些数据中的最小值和最大值，这些数据的平均值，这些数据的总和。
如图2至图6所示，本实施例提供使用一运用本发明来控制电子表格的手持触摸设备来操作电子表格：
如图2所示，在手持触摸设备打开电子表格，电子表格处于初始位置；
如图3所示，通过触控屏幕输入选择触控信号来选择单元格A1-A3，手持触摸设备根据选择触控信号按预先设置的处理方法进行计算，并保存计算结果；
如图4所示，使用者输入第一触控信号，具体是，在触控屏幕上按住与电子表格对应的地方（按住的地方具体是与电子表格的标题对应的地方）并向下移动至空白区以外的区域；手持触摸设备根据第一触控信号将电子 表格向下移至搁置位置，显示空白区，同时，空白区显示数据：sum=80、avg=26.666、count=3、min=20、max=36；
如图5所示，使用者输入第三触控信号，具体是，在触控屏幕上按住与sum=80对应的地方并移动至与单元格A4对应的地方；手持触摸设备根据第三触控信号在单元格A4中显示80;
如图6所示，使用者输入 第二触控信号，具体是， 在触控屏幕上按住与电子表格的标题对应的地方并向上（即朝向空白区）移动；手持触摸设备根据第二触控信号将电子表格移至初始位置，电子表格覆盖空白区。
实施例二
针对控制电子表格在初始位置和搁置位置之间转移的方法，本实施例另外提供一种具体方法，其可以在实施一的对应方案并存，或取代实施一的对应方案。
控制电子表格在初始位置和搁置位置之间转移的方法具体为：电子表格上设有一用于被触控点击以控制电子表格在初始位置和搁置位置之间转移的移动功能按钮；上述第一触控信号和上述第二触控信号均为在触控屏幕上触控点击与移动功能按钮对应的地方。为了更加形象以方便使用者使用，进行以下设计：当电子表格在初始位置时，移动功能按钮显示朝下标识；当电子表格在搁置位置时，移动功能按钮显示朝上标识。
本发明不局限于上述实施例，基于上述实施例的、未做出创造性劳动的简单替换，应当属于本发明揭露的范围。

Claims (1)

1 、一种在手持触摸设备上控制电子表格的方法，其特征在于， 包括以下过程：
运算过程：接收选择单元格的选择触控信号，根据该选择触控信号选定电子表格中被选择的单元格，然后按预先设置的处理方法进行计算，并保存计算结果;
显示过程：接收控制将电子表格从初始位置移至搁置位置的第一触控信号，根据该第一触控信号将电子表格从初始位置移至搁置位置以显示出空白区，查询是否存在计算结果，若存在，则在空白区显示计算结果；
恢复过程：接收控制将电子表格从搁置位置移回初始位置的第二触控信号，根据该第二触控信号将电子表格移回初始位置，电子表格覆盖空白区。
2 、根据权利要求1所述的在手持触摸设备上控制电子表格的方法，其特征在于， 显示过程还包括下述过程：当空白区呈现并存在计算结果时，接收将任意一计算结果指向一未用的单元格中的第三触控信号，根据该第三触控信号在上述未用的单元格中显示该计算结果。
3 、根据权利要求1所述的在手持触摸设备上控制电子表格的方法，其特征在于，控制电子表格从初始位置移至搁置位置的第一触控信号，具体为：在触控屏幕上按住与电子表格对应的地方并移动至空白区以外的区域；控制电子表格从搁置位置移至初始位置的第二触控信号，具体为：在触控屏幕上按住与电子表格对应的地方并朝向或背向空白区进行移动。
4 、根据权利要求1所述的在手持触摸设备上控制电子表格的方法，其特征在于， 控制电子表格在初始位置和搁置位置之间转移的方法具体为：电子表格上设有一用于被触控点击以控制电子表格在初始位置和搁置位置之间转移的移动功能按钮。
5 、根据权利要求4所述的在手持触摸设备上控制电子表格的方法，其特征在于，
当电子表格在初始位置时，移动功能按钮显示朝下标识；当电子表格在搁置位置时，移动功能按钮显示朝上标识。
PCT/CN2012/084315 2011-11-18 2012-11-08 一种在手持触摸设备上控制电子表格的方法 WO2013071837A1 (zh)

Priority Applications (5)

Application Number Priority Date Filing Date Title
AU2012339393A AU2012339393B2 (en) 2011-11-18 2012-11-08 Method for controlling electronic form on handheld touch device
EP12850202.8A EP2781997A4 (en) 2011-11-18 2012-11-08 METHOD FOR CONTROLLING ELECTRONIC FORMULAS IN A PORTABLE TOUCHING DEVICE
US14/356,765 US9619454B2 (en) 2011-11-18 2012-11-08 Method for controlling electronic spreadsheet on handheld touch device
JP2014541522A JP5918857B2 (ja) 2011-11-18 2012-11-08 手持型タッチデバイス上の電子スプレッドシートの制御方法
CA2850982A CA2850982C (en) 2011-11-18 2012-11-08 Method for controlling electronic spreadsheet on handheld touch device

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN2011103673758A CN102566901A (zh) 2011-11-18 2011-11-18 一种在手持触摸设备上控制电子表格的方法
CN201110367375.8 2011-11-18

Publications (1)

Publication Number Publication Date
WO2013071837A1 true WO2013071837A1 (zh) 2013-05-23

Family

ID=46412439

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2012/084315 WO2013071837A1 (zh) 2011-11-18 2012-11-08 一种在手持触摸设备上控制电子表格的方法

Country Status (7)

Country Link
US (1) US9619454B2 (zh)
EP (1) EP2781997A4 (zh)
JP (1) JP5918857B2 (zh)
CN (1) CN102566901A (zh)
AU (1) AU2012339393B2 (zh)
CA (1) CA2850982C (zh)
WO (1) WO2013071837A1 (zh)

Families Citing this family (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US9588953B2 (en) 2011-10-25 2017-03-07 Microsoft Technology Licensing, Llc Drag and drop always sum formulas
CN102566901A (zh) * 2011-11-18 2012-07-11 珠海金山办公软件有限公司 一种在手持触摸设备上控制电子表格的方法
CN102999289B (zh) * 2012-08-07 2016-10-05 珠海金山办公软件有限公司 在函数表达式中生成选区参数表示的方法及装置
CA2838165A1 (en) * 2012-12-31 2014-06-30 Smart Technologies Ulc Method for manipulating tables on an interactive input system and interactive input system executing the method
US10360297B2 (en) * 2013-06-14 2019-07-23 Microsoft Technology Licensing, Llc Simplified data input in electronic documents
US9256590B2 (en) 2013-12-17 2016-02-09 Microsoft Technology Licensing, Llc Formula and function generation and use in electronic spreadsheets
US20150169532A1 (en) * 2013-12-17 2015-06-18 Microsoft Corporation Interaction with Spreadsheet Application Function Tokens
US9348561B2 (en) * 2014-05-21 2016-05-24 InvestCloud, Inc Tabular format transaction editor
CN104461349B (zh) * 2014-11-12 2018-08-14 无锡永中软件有限公司 移动设备上的分屏显示方法及装置
US10466868B2 (en) 2016-04-27 2019-11-05 Coda Project, Inc. Operations log
US11768997B2 (en) * 2020-03-31 2023-09-26 Atlassian Pty Ltd. Systems and methods for creating, using, and managing fields in electronic content
US11222161B1 (en) * 2020-07-02 2022-01-11 Hexagon Technology Center Gmbh Grid magnifier

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1790259A (zh) * 2004-12-15 2006-06-21 微软公司 自动完成电子表格公式的系统和方法
US20100281374A1 (en) * 2009-04-30 2010-11-04 Egan Schulz Scrollable menus and toolbars
CN102156614A (zh) * 2010-01-06 2011-08-17 苹果公司 使用多接触姿态来操作表格的设备、方法和图形用户界面
CN102566901A (zh) * 2011-11-18 2012-07-11 珠海金山办公软件有限公司 一种在手持触摸设备上控制电子表格的方法

Family Cites Families (18)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5040131A (en) * 1987-12-23 1991-08-13 International Business Machines Corporation Graphical processing
JP3388655B2 (ja) * 1995-07-28 2003-03-24 シャープ株式会社 データ処理装置
JPH09106430A (ja) * 1995-08-04 1997-04-22 Hitachi Ltd 情報処理装置および表計算方法
US6055548A (en) * 1996-06-03 2000-04-25 Microsoft Corporation Computerized spreadsheet with auto-calculator
US20060282818A1 (en) * 2005-06-14 2006-12-14 Microsoft Corporation Interactive formula builder
US7676767B2 (en) * 2005-06-15 2010-03-09 Microsoft Corporation Peel back user interface to show hidden functions
US8112701B2 (en) * 2007-08-06 2012-02-07 Apple Inc. Reference adding behavior in formula editing mode
JP5188132B2 (ja) * 2007-09-27 2013-04-24 株式会社日立ハイテクノロジーズ データ処理装置の表示方法
KR101477743B1 (ko) * 2008-06-16 2014-12-31 삼성전자 주식회사 단말 및 그의 기능 수행 방법
US8255789B2 (en) * 2008-09-30 2012-08-28 Apple Inc. Providing spreadsheet features
US8799775B2 (en) * 2009-09-25 2014-08-05 Apple Inc. Device, method, and graphical user interface for displaying emphasis animations for an electronic document in a presentation mode
JP5650564B2 (ja) * 2011-03-01 2015-01-07 株式会社ユビキタスエンターテインメント スプレッドシート制御プログラム、スプレッドシート制御装置及びスプレッドシートの制御方法
US20130061122A1 (en) * 2011-09-07 2013-03-07 Microsoft Corporation Multi-cell selection using touch input
US9594735B2 (en) * 2011-09-12 2017-03-14 Microsoft Technology Licensing, Llc Automatic highlighting of formula parameters for limited display devices
US9588953B2 (en) * 2011-10-25 2017-03-07 Microsoft Technology Licensing, Llc Drag and drop always sum formulas
US10360297B2 (en) * 2013-06-14 2019-07-23 Microsoft Technology Licensing, Llc Simplified data input in electronic documents
US9805016B2 (en) * 2013-10-22 2017-10-31 Microsoft Technology Licensing, Llc Techniques to present a dynamic formula bar in a spreadsheet
US9256590B2 (en) * 2013-12-17 2016-02-09 Microsoft Technology Licensing, Llc Formula and function generation and use in electronic spreadsheets

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1790259A (zh) * 2004-12-15 2006-06-21 微软公司 自动完成电子表格公式的系统和方法
US20100281374A1 (en) * 2009-04-30 2010-11-04 Egan Schulz Scrollable menus and toolbars
CN102156614A (zh) * 2010-01-06 2011-08-17 苹果公司 使用多接触姿态来操作表格的设备、方法和图形用户界面
CN102566901A (zh) * 2011-11-18 2012-07-11 珠海金山办公软件有限公司 一种在手持触摸设备上控制电子表格的方法

Also Published As

Publication number Publication date
US9619454B2 (en) 2017-04-11
EP2781997A8 (en) 2015-01-21
US20140289601A1 (en) 2014-09-25
CN102566901A (zh) 2012-07-11
JP2015504200A (ja) 2015-02-05
CA2850982C (en) 2019-02-05
EP2781997A4 (en) 2015-07-22
JP5918857B2 (ja) 2016-05-18
EP2781997A1 (en) 2014-09-24
AU2012339393B2 (en) 2015-04-09
AU2012339393A1 (en) 2014-04-10
CA2850982A1 (en) 2013-05-23

Similar Documents

Publication Publication Date Title
WO2013071837A1 (zh) 一种在手持触摸设备上控制电子表格的方法
CN202331405U (zh) 一种带有背面触摸板的平板电脑
WO2013189270A1 (zh) 一种用户界面的图标管理方法及触控设备
CN101681209A (zh) 具有触摸输入表面的移动设备
CN103092525B (zh) 一种移动终端的截屏方法及其基于该截屏方法的移动终端
CN101996031A (zh) 具有触摸输入功能的电子装置及其触摸输入方法
CN104380239A (zh) 操作显示单元的方法和支持所述方法的终端
WO2014094427A1 (zh) 触摸屏手机保护套
CN102736852A (zh) 用于手势操作的应用编程接口
WO2018090761A1 (zh) 一种显示界面排版调整方法及系统
US20120196540A1 (en) Method and apparatus for a bluetooth-enabled headset with a multitouch interface
CN104731469A (zh) 一种触控设备及其单手操作方法
CN104077066A (zh) 可携式装置与操作方法
CN103500062A (zh) 一种终端、终端控制方法及装置
CN203930577U (zh) 大屏幕触屏电子设备
WO2016112813A1 (zh) 一种实现多个位置动态被动确定按键之方法
CN105808033A (zh) 电子装置的界面显示控制系统及其界面显示控制方法
CN105072224A (zh) 一种后盖触摸操作的手机及实现手机后盖触摸操作的方法
WO2014187028A1 (zh) 更新应用程序图标所在的待机界面方法以及无线通信设备
CN104516668A (zh) 手持式电子装置及其控制方法
WO2014190600A1 (zh) 通过移动终端远程控制数字电视终端的方法及其系统
JP2014071477A (ja) 携帯端末
KR20130029884A (ko) 터치스크린패널 기반 로봇 교시조작기 사용자 인터페이스
CN205091727U (zh) 一种支持手势触控操作的屏幕
CN202998209U (zh) 移动终端

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 12850202

Country of ref document: EP

Kind code of ref document: A1

WWE Wipo information: entry into national phase

Ref document number: 2012850202

Country of ref document: EP

ENP Entry into the national phase

Ref document number: 2850982

Country of ref document: CA

ENP Entry into the national phase

Ref document number: 2012339393

Country of ref document: AU

Date of ref document: 20121108

Kind code of ref document: A

WWE Wipo information: entry into national phase

Ref document number: 14356765

Country of ref document: US

ENP Entry into the national phase

Ref document number: 2014541522

Country of ref document: JP

Kind code of ref document: A

NENP Non-entry into the national phase

Ref country code: DE