CN102629180B - 电子表格动作的自然输入 - Google Patents

电子表格动作的自然输入 Download PDF

Info

Publication number
CN102629180B
CN102629180B CN201210012142.0A CN201210012142A CN102629180B CN 102629180 B CN102629180 B CN 102629180B CN 201210012142 A CN201210012142 A CN 201210012142A CN 102629180 B CN102629180 B CN 102629180B
Authority
CN
China
Prior art keywords
gesture
electrical form
described electrical
data
chart
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
Application number
CN201210012142.0A
Other languages
English (en)
Other versions
CN102629180A (zh
Inventor
J·坎贝尔
A·林
L·沃尔德曼
S·德尔
程晓旭
C·多恩
T·康斯坦丁
C·罗斯切里尔
马云
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Microsoft Technology Licensing LLC
Original Assignee
Microsoft Technology Licensing LLC
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 Microsoft Technology Licensing LLC filed Critical Microsoft Technology Licensing LLC
Publication of CN102629180A publication Critical patent/CN102629180A/zh
Application granted granted Critical
Publication of CN102629180B publication Critical patent/CN102629180B/zh
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

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]
    • 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
    • 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/03—Arrangements for converting the position or the displacement of a member into a coded form
    • G06F3/033—Pointing devices displaced or positioned by the user, e.g. mice, trackballs, pens or joysticks; Accessories therefor
    • G06F3/0346—Pointing devices displaced or positioned by the user, e.g. mice, trackballs, pens or joysticks; Accessories therefor with detection of the device orientation or free movement in a 3D space, e.g. 3D mice, 6-DOF [six degrees of freedom] pointers using gyroscopes, accelerometers or tilt-sensors
    • 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/0484—Interaction techniques based on graphical user interfaces [GUI] for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range
    • 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/0484—Interaction techniques based on graphical user interfaces [GUI] for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range
    • G06F3/04845—Interaction techniques based on graphical user interfaces [GUI] for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range for image manipulation, e.g. dragging, rotation, expansion or change of colour
    • 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/0484—Interaction techniques based on graphical user interfaces [GUI] for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range
    • G06F3/0485—Scrolling or panning
    • 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
    • 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/14—Digital output to display device ; Cooperation and interconnection of the display device with other functional units
    • 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
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F2200/00—Indexing scheme relating to G06F1/04 - G06F1/32
    • G06F2200/16—Indexing scheme relating to G06F1/16 - G06F1/18
    • G06F2200/161—Indexing scheme relating to constructional details of the monitor
    • G06F2200/1614—Image rotation following screen orientation, e.g. switching from landscape to portrait mode
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F2203/00—Indexing scheme relating to G06F3/00 - G06F3/048
    • G06F2203/048—Indexing scheme relating to G06F3/048
    • G06F2203/04806—Zoom, i.e. interaction techniques or interactors for controlling the zooming operation
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F2203/00—Indexing scheme relating to G06F3/00 - G06F3/048
    • G06F2203/048—Indexing scheme relating to G06F3/048
    • G06F2203/04808—Several contacts: gestures triggering a specific function, e.g. scrolling, zooming, right-click, when the user establishes several contacts with the surface simultaneously; e.g. using several fingers or a combination of fingers and pen

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

电子表格动作的自然输入
技术领域
本发明涉及电子表格。
背景技术
许多人利用电子表格来与数据交互。一般而言，用户通过输入设备，如鼠标、触摸屏、图形用户界面和键盘来与电子表格交互。有时这种交互可能是令人受挫的。例如，在小屏幕设备(例如，蜂窝电话、平板计算机)上与大型电子表格交互以及操纵大型电子表格可能是困难且乏味的。
发明内容
提供本发明内容以便以简化形式介绍将在以下具体实施方式中进一步描述的一些概念。本发明内容并非旨在标识所要求保护的主题的关键特征或必要特征，也不旨在用于帮助确定所要求保护的主题的范围。
使用不同的手势和动作来与电子表格交互。在操纵电子表格以及在电子表格中执行其它动作时使用手势。例如，手势可用于在电子表格内移动、选择数据、筛选(filter)、排序、下钻/上钻、缩放、分行/列、执行撤销/恢复动作等。与设备相关联的传感器也可用于与电子表格交互。例如，加速计可用于在电子表格内移动和执行操作。
附图说明
图1示出了示例性计算设备；
图2示出了示例性触摸输入系统；
图3示出了用于使用手势和传感器信息来与应用交互的系统；
图4示出了电子表格内的缩放手势；
图5示出了对手势框的使用；
图6示出了空手道砍劈手势；
图7示出了用户选择数据然后画出图表手势来改变所选数据的视图；
图8示出了用户在图表上画出趋势线手势；
图9示出了注释手势；
图10示出了响应于一动作对数据执行的漩涡效果；
图11示出了抓取用户界面元素的显示及与之进行的交互；
图12示出了电子表格对象正基于设备的移动进行显示；以及
图13示出了用于使用手势和传感器来与电子表格交互的说明性过程。
具体实施方式
现在参考其中相同的标号代表相同的元素的附图，描述各实施例。具体地，图1和相应的讨论旨在提供对在其中可实现各实施例的合适计算环境的简要、概括描述。
一般而言，程序模块包括执行特定任务或实现特定抽象数据类型的例程、程序、组件、数据结构和其它类型的结构。也可使用其它计算机系统配置，包括手持式设备、多处理器系统、基于微处理器或可编程消费电子产品、小型计算机、大型计算机等等。还可使用在其中任务由通过通信网络链接的远程处理设备执行的分布式计算环境。在分布式计算环境中，程序模块可位于本地和远程存储器存储设备两者中。
现在参考图1，将描述在各实施例中利用的计算机100的说明性计算机体系结构。图1所示的计算机体系结构可被配置为移动或台式计算机，并且包括中央处理单元5(“CPU”)、包括随机存取存储器9(“RAM”)和只读存储器(“ROM”)10的系统存储器7、以及将存储器耦合至中央处理单元(“CPU”)5的系统总线12。根据各实施例，计算机100是手持式计算设备，诸如移动电话、平板计算机、膝上型计算机、上网本、PDA等。
基本输入/输出系统存储在ROM10中，所述基本输入/输出系统包含帮助在诸如启动期间在计算机内元件之间传递信息的基本例程。计算机100还包括用于存储操作系统16、应用程序24、其它程序模块25和手势管理器26的大容量存储设备14，这将在以下更为详尽地描述。
大容量存储设备14通过连接至总线12的大容量存储控制器(未示出)连接到CPU5。大容量存储设备14及其相关联的计算机可读介质为计算机100提供非易失性存储。虽然此处包含的对计算机可读介质的描述针对诸如硬盘或CD-ROM驱动器等大容量存储设备，但是计算机可读介质可以是能够由计算机100访问的任何可用物理介质。
作为示例而非限制，计算机可读介质可包括计算机存储介质和通信介质。计算机存储介质包括以存储如计算机可读指令、数据结构、程序模块或其他数据等信息的任何方法或技术来实现的物理易失性和非易失性、可移动和不可移动介质。计算机存储介质还包括，但不限于，RAM、ROM、可擦除可编程只读存储器(“EPROM”)、电可擦可编程只读存储器(“EEPROM”)、闪存或其它固态存储器技术、CD-ROM、数字多功能盘(“DVD”)或其它光存储、磁带盒、磁带、磁盘存储或其它磁性存储设备、或能用于存储所需信息且可以由计算机100访问的任何其它介质。
根据各实施例，计算机100可以使用通过诸如因特网的网络18至远程计算机的逻辑连接在联网环境中操作。计算机100可以通过连接至总线12的网络接口单元20来连接到网络18。网络连接可以是无线的和/或有线的。网络接口单元20也可用于连接到其它类型的网络和远程计算机系统。计算机100也可包括输入/输出控制器22，用于接收和处理来自多个其他设备，包括显示器/触摸输入设备28的输入。触摸输入设备可利用允许每次识别触摸输入的任何技术。例如，技术可包括但不限于：热量、手指压力、高俘获率照像机、红外光、光学捕捉、调谐的电磁感应、超声波接收器、传感麦克风、激光测距仪、阴影捕捉等。在图2中示出了示例性触摸输入设备。触摸输入设备28还可与显示器分开。输入/输出控制器22也向一个或多个显示屏、打印机或其他类型的输出设备提供输出。
计算机100还可包括一个或多个传感器21。根据实施例，计算机100包括用于传感计算机或计算机的一部分的加速度的加速计。例如，加速计可检测显示器28的移动。加速计可以是用于传感方向、加速度、振动或可由加速计传感的其它类型的动作的单轴或多轴加速计。还可包括其它传感器，诸如位置传感器(即GPS)、音频传感器、红外传感器、其它类型的倾斜传感器等。传感器21接收的信息可用于与应用程序交互。例如，当用户移动计算设备时，可响应于移动，显示电子表格的不同部分。
如前简述的一样，多个程序模块和数据文件可以存储在计算机100的大容量存储设备14和RAM9内，包括适于控制联网的个人计算机的操作的操作系统16，如华盛顿州雷蒙德市的微软公司的操作系统。根据一个实施例，操作系统被配置成包括对触摸输入设备28的支持。根据另一个实施例，手势管理器26可用于处理从触摸输入设备28接收到的触摸输入中的某些/全部。
大容量存储设备14和RAM9还可以存储一个或多个程序模块。具体地，大容量存储设备14和RAM9可以存储诸如电子表格应用程序等一个或多个应用程序24。根据实施例，电子表格应用是MICROSOFTEXCEL电子表格应用。也可以使用其他电子表格应用。
结合应用的操作，手势管理器26被配置成检测由触摸输入设备28接收到的手势。一般而言，手势管理器26被配置成传感何时接收到手势，该手势涉及结合诸如电子表格应用的应用程序来执行操作。可接收不同类型的手势。例如，可接收滑动手势、剪切/粘贴手势、插入手势、漩涡手势、抓取手势、图表手势、趋势线手势、注释手势、缩放手势、排序手势、撤销/恢复手势等。
手势管理器26还被配置成从一个或多个传感器接收输入。可单独使用和/或结合接收到的手势使用从传感器接收的信息。例如，倾斜设备可使得电子表格在倾斜的方向上滚动/扫视(pan)。晃动设备可用于清除筛选、复位状态、执行撤销等。急摇(jerk)设备可引起滚动中的加速或滚动位置上的跳转。陡峭地倾斜设备(即，大于30度或某一其它预定角度)可使得电子表格23内包含的电子表格对象看上去如同它们向电子表格的顶端溢出一样，从而允许用户选择电子表格对象中的一个。在选择之后，电子表格对象可返回到其原始位置，且视图可以所选对象为中心。可使用手势和传感器信息来改变信息的显示、激活/停用功能、和/或执行与应用24或某一其它功能和/或程序相关联的某一其它类型的操作。以下将提供关于手势和传感器信息的附加细节。
图2示出了示例性触摸输入系统。如图所示的触摸输入系统200包括触摸面板202，面板202中集成了若干个传感器204。根据一个实施例，传感器204是红外(IR)传感器。触摸输入系统200被配置成检测或者与可触摸表面206接触、或者靠近但不与可触摸表面206实际接触(“邻近”)的对象。被传感的对象可以是许多不同类型的对象，诸如手指、手或其它物理对象。红外传感器204可遍布触摸面板202分布，且与可触摸表面206平行放置。红外传感器204中的一个或多个可检测从诸如手208等对象反射的红外辐射，如箭头所示。尽管在本说明书中使用术语“上方”，应理解，触摸面板系统的定向是不相关的。如图2中所示，可触摸表面206是水平的，但在旋转系统200顺时针90度生成的一不同实施例中，可触摸表面206可以是垂直的。在该实施例中，从中检测到反射的IR辐射的对象在可触摸表面206的一侧。术语“上方”旨在可适用于所有这样的定向。可触摸表面206也可变为其它定向。
触摸面板202可包括过滤器212，该过滤器吸收可见光并发射红外辐射，该过滤器位于可触摸表面206和IR传感器204之间，以便在IR传感器204对除了纯粹的红外波长以外的光的更广的波长范围敏感的情况下，遮蔽IR传感器204防止可见光入射到可触摸表面206上。
触摸面板202可包括显示器，它被配置成显示可经由可触摸表面206查看的图像。例如，所显示的图像可以是与诸如电子表格等应用有关的图像。显示器例如可以是LCD、有机发光二极管(OLED)显示器、诸如电子纸张等柔性显示器、或其中可集成IR传感器的任何其它合适的显示器。
系统200可包括显示器的背光216。背光216可包括至少一个IR源218，它被配置成用通过可触摸表面206的红外辐射来照射与可触摸表面206接触或邻近的对象，如箭头所示。IR传感器204对从上方入射的辐射敏感，因此不会检测到从背光216到IR传感器204直接行进的IR辐射。
传感器204的输出可由手势管理器26和/或包括在操作系统或某个其它应用内的功能处理，以检测何时物理对象(例如，手、瓶子、玻璃、手指、帽子等)与触摸输入表面206的一部分物理接触和/或何时物理对象在表面的附近。例如，传感器204可检测何时手208的一部分(诸如一个或多个手指)与触摸输入显示表面206接触或在其附近。附加的传感器可被嵌入到触摸输入显示表面206中，并且可包括例如加速计、压力传感器、温度传感器、图像扫描仪、条形码扫描仪等，来检测多个同时输入。
当传感器204是IR传感器时，从对象反射的IR辐射可从用户的手、手指、对象的反射性墨水图案、对象上的金属设计或任何其它合适的反射体反射。手指反射了足够的附近IR以检测手指或手位于特定位置上或邻近可触摸表面。可使用更高分辨率的IR传感器来扫描对象，以实现更高的分辨率。
传感器204可被包括(例如，嵌入)在多个位置中。传感器204的密度可以是足以检测到整个触摸输入显示表面206上的接触。传感器204可以针对检测到的接触和/或近乎接触，按照如1毫秒、5毫秒等指定间隔来对触摸输入显示表面206的表面采样。当所检测到的对象在触摸表面上移动时；检测到的对象不再位于检测范围之内时；以及当有新对象进入检测范围内时，从传感器204接收到的传感器数据在采样间隔之间变化。例如，手势管理器26可确定首先在第一位置检测到接触、然后接触随之移动到其它位置。作为响应，手势管理器26可确定何时接收到手势以及接收到何种类型的手势。
图2仅提供了触摸输入系统的一个示例。在其它示例性触摸系统中，背光可不包括任何IR源，且表面206可包括前光(frontlight)，前光包括至少一个IR源。在这样的示例中，系统的可触摸表面206是前光的表面。前光可包括光导，使得从IR源发出的IR辐射通过光导行进，并朝向可触摸表面和与其接触或在其邻近的任何对象定向。在其它触摸面板系统中，背光和前光均可包括IR源。在又一些触摸面板系统中，没有背光，而前光包括IR源和可见光源两者。在其它示例中，系统可不包括前光或背光，相反，IR源可被集成在触摸面板内。在一实现中，触摸输入系统200可包括OLED显示器，OLED显示器包括IROLED发射器以及IR敏感的有机光敏元件(这可包括反向偏压OLED)。在一些触摸系统中，可不包括显示器。即使如果触摸系统包括显示器的一个或多个组件或元件，触摸系统也可被配置成不显示图像。例如，这可能是触摸输入板与显示器分开的情况。其它示例包括触摸板、手势板或类似的非显示设备和组件。
对某些应用，可能期望仅当对象与触摸面板系统的可触摸表面实际接触时才检测该对象。例如，根据一个实施例，如果手势不是正在触摸表面时执行的，则可不识别手势。类似地，当在表面上方执行时，可识别手势。可仅当触摸了可触摸表面时才开启触摸输入系统的IR源。或者，可无论是否触摸了可触摸表面均开启IR源，且对可触摸表面和对象之间的实际触摸是否发生的检测可与IR传感器的输出一起处理。可通过任何合适的装置，包括如耦合到触摸面板的振动传感器或话筒，来检测可触摸表面和对象之间的实际接触。用于检测接触的传感器的示例的非穷尽列表包括：基于压力的机构、微机械加速计、压电设备、电容传感器、电阻传感器、感应传感器、激光振动计和LED振动计。
图3示出了用于使用手势和传感器信息来与应用交互的系统。如图所示，系统300包括电子表格应用302、回调代码312、传感器304、手势管理器26、电子表格310和触摸输入设备/显示器340。根据实施例，系统300的功能被包括在移动计算设备内。
为了便于与手势管理器26的通信，可以实现一个或多个回调例程，这些例程在图3中被示为回调代码312。根据一个实施例，手势管理器26被配置成从触摸敏感输入设备340和传感器304接收输入。例如，在用户的手(即手312)或某个其它对象执行用于与电子表格310交互的手势时，手势管理器26可向应用302提供指示。传感器信息也可由手势管理器26接收以与电子表格310交互。例如，用户可倾斜或叩击计算设备的侧面以滚动电子表格310的显示。
手势管理器26被配置成识别许多不同类型的手势。某些手势可以是上下文相关的、对应用专用的和/或在许多不同类型的应用中使用。例如，手势可用于与同电子表格应用302相关联的电子表格310交互。可在与触摸输入设备/显示器340相关的许多不同位置中接收手势。例如，可在电子表格310的显示内、在手势框314内和/或在显示器340上的某个其它位置处接收手势。
可按照不同的方式预先确定和/或指定手势。例如，某些手势可被预先确定为与特定动作相关联，而可由用户使其它手势与一个或多个动作相关联。例如，用户可指定，当接收到特定手势时，则要进行一个或多个电子表格操作。操作可以按照许多不同的方式来指定。例如，可使用编程代码、可创建宏、可配置公式等。
可发生的动作有许多不同示例。例如，某些动作在被识别时可反转条件格式化的极性(即，从高到低至低到高格式化的改变)。执行手势可改变数据的格式化(即，高值一开始被格式化为绿色的，在用户执行某一手势之后现在是红色的)。一个或多个手势可导致反转图表的定向。例如，图表一开始显示从一月到三月的数据，当手势执行之后，图表反转并显示从三月到一月的数据。一个或多个手势可展示更多信息。例如，假定图表当前正在显示2009年1月至2009年3月间的数据。当接收到手势时，图表的显示移位，并示出从2009年2月到2009年7月之间的数据。以下参考图4-12描述示例性的手势和与电子表格的交互。
可使用手势管理器26接收的传感器信息以与电子表格310交互。例如，计算设备/显示器的相对位置可用于确定要显示的电子表格的部分。例如，向左移动设备可向左滚动/扫视电子表格的显示，而向右移动设备可向右滚动/摇摄电子表格的显示。显示的滚动/扫视可以是水平和垂直滚动/扫视的组合。例如，对角线移动设备可导致等量的水平和垂直滚动/移动。如此处所使用的术语“滚动”和“扫视”可互换使用。向上或向下移动设备也可影响电子表格310的显示。例如，向下移动设备可执行缩小操作，使得显示更多的电子表格，而在向上方向移动设备可执行放大操作，以便显示电子表格的更详细视图。根据实施例，当缩放超过预定缩放级别时，缩小操作显示电子表格工作簿(workbook)的每一工作表的缩略视图。向上/向下移动电子表格也可引起对电子表格执行钻取操作。例如，在向上方向上移动设备可执行上钻操作以减少电子表格中的细节，而向下移动设备可执行下钻操作以示出更多细节。
电子表格/计算设备的移动速度也可用于确定滚动和/或缩放的速度。例如，一方向上的突然移动可增加滚动和/或缩放动作的速度。根据实施例，当接近电子表格内的预定位置(“减速带”)时，滚动可减慢/停止。减速带的位置可置于电子表格内的不同位置处。它们可以自动地确定和/或手动地定位。只要在电子表格内存在数据中的缝隙时，即可自动放置减速带。例如，假定电子表格具有来自行1-3和10-20的内容且没有来自行4-10的内容。可在行4放置减速带(318)。当用户扫视到行4时，扫视如同它击中电子表格的末尾一般停止。扫视也可在减速带之前在其接近数据的末尾时减慢。为了继续扫视，用户仅仅再次执行扫视操纵。也可遍布电子表格的网格周期性地放置减速带(即，每100行、200行、1000行等)。不同的动作也可与减速带相关联。例如，电子表格的移动可在其击中减速带时停止、当其击中减速带时减慢并且然后在其移动离开减速带时加速等等。
还可监视电子表格/计算设备的定向。倾斜电子表格的显示可引起电子表格的显示在倾斜方向上滚动/扫视。倾斜量和/或倾斜速度也可用于执行操作。例如，在垂直方向上陡峭地倾斜设备可使得电子表格310内的所有电子表格对象看上去如同它们正向电子表格的顶端溢出一般(见图12)。倾斜也可被解释为导航对象内的不同数据。例如，倾斜设备可跨图表中的数据序列导航。
旋转设备可用于改变与电子表格相关联的视图。例如，旋转电子表格的显示可使得视图从工作表视图变为命名对象视图，命名对象视图显示与电子表格310相关联的每一对象。类似地，当用户正在查看对象时，视图可基于对象改变。例如，当用户正在查看饼状图时，旋转电子表格可使得视图变为某种其它类型的图表(例如，条形图)。
晃动设备也可被确定为执行与电子表格相关的操作。例如，晃动设备可用于清除在电子表格内的表格或数据透视表上设置的过滤器、复位状态、执行和撤销操作等。
图4-12示出了用于与电子表格交互的示例性手势和动作。
图4示出了电子表格内的缩放手势。如图所示，图4示出了在缩放之前的电子表格视图410以及在执行缩小操作之后的经缩放视图420。根据实施例，在用户如手势445所示张开其两根手指时检测到缩放手势。当用户闭合其两根手指时可检测到放大手势。当用户缩小超过某个点(即，＜5％)时和/或基于手势的两根手指之间的移动速度，可显示经缩小的视图420。例如，手指的非常快速的分开可引起显示缩略图缩放视图420。如图所示，经缩放视图420是电子表格工作簿内每一工作表的缩略视图。还可提供其它经缩放的视图。例如，在缩放到电子表格内的每一工作表的缩略图视图之前，可在预定缩放级别显示(例如，在缩放级别15-20％)当前的命名对象视图。
图5示出了对手势框的使用。如图所示，图5示出了显示电子表格540、选择512和手势框518的显示530。根据实施例，在显示的角落附近画出手势框518。可在手势框518内画手势516。每一手势与特定命令相关联。例如，通过手势框命令520示出一些示例性命令。例如：画出S可保存电子表格，画出B可加粗文本，画出+符号可写出求和公式，画出-符号可写出减法公式，画出向上箭头可向上排序，画出向下箭头可向下排序，画出圆圈将写出求平均公式。可在手势框518内使用其它手势命令。例如，用户可创建自定义手势和/或修改现有手势。这些手势可被记录并与编程代码、命令和/或宏相关联。
如图所示，用户用手势514创建了对数字10、12和5的选择512，然后在手势框518内画出“+”符号。响应于画出+符号，对网格位置A4写入求和公式，这导致值27被显示。用户可在框内画出适用于选择512的任何手势命令。例如，用户可在手势框518内画出圆圈，这将写出将引起在位置A4处显示9的求平均公式。
尽管在显示530的左下位置处显示手势框518，但手势框可在其它位置处显示。例如，手势框518可显示在电子表格540的顶端，或显示在显示530上的任何其它位置处。
图6示出了空手道砍劈手势。如图所示，图6示出了电子表格610接收水平空手道型手势612和垂直空手道型手势614。空手道型手势用于在电子表格内的特定位置处插入行/列。在执行空手道砍劈运动时，检测到空手道砍劈手势。例如，可检测到用户的手的边缘、或具有拥有与用户的手类似的特征的边缘的另一物理对象的边缘，以接收空手道型手势。当接收到水平空手道砍劈手势612时，在空手道砍劈手势的位置处插入新行。当接收到垂直空手道砍劈手势614时，在空手道砍劈手势的位置处插入新列。在当前示例中，在行2和3之间插入新行，并在列6之后插入新列(见电子表格620)。根据另一实施例，使空手道砍劈手势与其它命令相关联。例如，空手道砍劈手势将触发文本到列的自动转换。
图7示出了用户选择数据然后画出图表手势来改变所选数据的视图。如图所示，图7示出了包括数据716的电子表格710。在当前示例中，用户选择了数据716，然后画出图表手势以创建图表的显示来表示所选数据。
图表手势722示出用户画出表示饼状图的圆圈。当用户完成图表手势722时，显示饼状图712。图表可被显示在不同的位置处。例如，图表可替换所选数据、图表可被放置在所选数据附近、或者图表可被放置在用户指定位置处。图表也可被置于电子表格工作簿的另一工作表上。
图表手势724示出了用户画出按照为所选数据716创建条形图714的线形式的图表手势。根据实施例，可对所选数据显示一个以上的类型的图表。
图表手势726示出了用户画出按照为所选数据716创建散点图718的半圆线形式的图表手势。根据实施例，可对所选数据显示一个以上的类型的图表。
图8示出了用户画出被识别为图表上的趋势线手势的图表手势。如图所示，图8示出了具有趋势线的条形图810和条形图814，以及具有对数趋势线的散点图820和散点图824。在条形图的示例中，用户画出靠近所显示的图表元素数据的边缘附近的趋势线手势812，以创建带有条形图的趋势线的显示(814)。在散点图的示例中，用户画出趋势线手势822，该手势是靠近数据中间的线，以创建带有散点数据的趋势线的显示(824)。
图9示出了注释手势。注释手势在注释手势的开头附近创建注释位置。例如，在图9中，注释位于最后一个条形图的顶部附近(920)。注释手势是如显示910所示的一条线继之以圆圈的一部分。尽管注释手势被示为在图表上执行，但注释手势可位于显示内的任何位置并与不同类型的元素相关联。例如，注释手势可与单个单元格、一组所选单元格、图表、表格或某个其它对象相关联。响应于接收到注释手势显示允许用户输入注释的注释框。
图10示出了响应于一动作对数据执行的漩涡效果。如图所示，显示1010示出了用户剪切所选数据。响应于选择剪切选项，显示看上去像“漩涡”的动画，这创建了被剪切的内容正被吸入手指的错觉(1012)。根据实施例，内容在手指最后接触屏幕的点消失。
显示1020显示用户粘贴数据。应粘贴命令，内容从接触的手指尖向外画出(1014)，漩涡动画创建被粘贴的内容正从手指产生的错觉。
图11示出了对抓取用户界面元素的显示及与之进行的交互。抓取用户界面元素1112被显示在诸如电子表格1110的文档的顶部。根据实施例，抓取用户界面元素1112被置于非惯用手的屏幕一侧上(例如，对使用右手的用户在左侧上，而对使用左手的用户在右侧上)。当抓取1112未压下时，惯用手的滑行动作1114被解释为扫视。
当如显示1120所示抓取被(例如，非惯用手)压下时，另一只手的任何滑行动作1124被解释为选择单元格。可对网格1112的显示应用不同的效果。例如，电子表格的网格可在与网格的接触点处在视觉上“混合”，以提供抓取正在被压下的视觉反馈。
图12示出了电子表格对象正基于设备的移动被显示。
显示1220示出了从显示溢出的电子表格对象。例如，在垂直方向上倾斜计算设备可使得电子表格1210内的电子表格对象如同它们正向电子表格的顶端溢出一般(如显示1220中所示)显现。水平倾斜设备可使得电子表格对象向设备的侧面溢出。在选择对象之后，按照以所选对象为中心的视图显示电子表格。这提供了在工作表上导航对象的更快速的方式。
显示1230显示了电子表格对象按重力排序。例如，用户可使计算设备从横向到纵向模式倾斜，然后晃动该设备。根据实施例，该组合的动作对数据排序，使得最大的项出现在底部上。数据可以是数字、图表数据、电子表格对象等。例如，当应用于条形图时，可显现为图表中的最重的条落到底部。
现在参考图13，将描述用于使用手势和传感器来与电子表格交互的说明性过程1300。当阅读对在此提供的例程的讨论时，应当理解，各实施例的逻辑操作被实现为(1)运行于计算系统上的一系列计算机实现的动作或程序模块，和/或(2)计算系统内互连的机器逻辑电路或电路模块。该实现是取决于实现本发明的计算系统的性能要求来选择的。因此，所例示的并且构成此处所描述的实施例的逻辑操作被不同地表示为操作、结构设备、动作或模块。这些操作、结构设备、动作和模块可用软件、固件、专用数字逻辑，及其任何组合来实现。
在起始操作之后，过程流至操作1310，其中接收手势和/或接收传感器信息。手势可以是此处所述的手势或其它识别的手势中的任何一个，诸如可接收空手道砍劈手势、抓取手势、晃动手势、趋势线手势、注释手势、缩放手势、排序手势等。根据一个实施例，用户可将其手的至少一部分(例如，一根或多根手指)置于触摸表面上。另外，根据一些实施例，用户可将其手置于触摸表面的表面附近但不在触摸表面上。传感器信息可涉及可在与显示的交互中使用的许多不同类型的传感器信息。例如，传感器信息可涉及可在确定计算设备的定向以及设备的速度时使用的加速计数据。
移动到操作1320，确定要执行的动作。根据实施例，该动作涉及与电子表格的交互，包括诸如扫视、倾斜、排序、缩放、钻取等动作。尽管描述的动作涉及与电子表格的交互，其它应用可与所描述的手势一起使用。
流向操作1330，执行所确定的动作。一般而言，动作涉及更新电子表格。例如，可创建图表、可添加趋势线、可对数据排序、可对数据求和、或可对数据执行某种其它操作等等。
转至操作1340，显示被更新。响应于接收到的手势/接收到的传感器信息来更新显示。
过程然后流动至结束操作并且返回至处理其他动作。
以上说明、示例和数据提供了对本发明的组成部分的制造和使用的全面描述。因为可以在不背离本发明的精神和范围的情况下做出本发明的许多实施例，所以本发明落在所附权利要求的范围内。

Claims (10)

1.一种用于与电子表格交互的方法，包括：
接收触摸输入设备上的手势；其中所述手势用于与所述电子表格交互；
接收传感器信息，其中所述传感器信息用于与所述电子表格交互；其中所述传感器信息包括用于改变所述电子表格的视图的加速计数据；
自动确定对于所述电子表格接收的手势的类型，其中所述手势的类型是以下中的至少一个：向电子表格应用指示在所述电子表格内插入数据的空手道砍劈手势；向所述电子表格应用指示在所述电子表格内显示图表的图表手势；向所述电子表格应用指示在所述电子表格内显示注释框的注释手势；指示何时将滚动模式改为选择模式的抓取手势；向所述电子表格应用指示执行以下中的至少一个动作的缩放手势：为所述电子表格的每一工作表显示缩略图并对所述电子表格的数据执行钻取操作；以及向所述电子表格指示对所述电子表格的数据执行操作的手势框手势；
响应于所述对于所述电子表格接收的手势的类型或者响应于所述对于所述电子表格接收的手势的类型和所接收的传感器信息执行动作；以及
更新所述电子表格的显示。
2.如权利要求1所述的方法，其特征在于，执行所述动作包括：当所述手势被确定为所述空手道砍劈手势时在所述电子表格中所接收的空手道砍劈手势的位置的附近插入行和列中的至少一个。
3.如权利要求1所述的方法，其特征在于，当所述手势是注释手势时，则在靠近所接收的手势位置的位置处显示注释框以接收注释；当所述手势是图表手势时，则插入以下中的至少一个：所述电子表格中所显示的图表上的趋势线和所述电子表格中的图表；当所述手势是缩放手势时，执行以下中的至少一个：在缩放级别超过预定阈值时，为与所述电子表格相关联的工作簿内的每一工作表显示缩略图；和显示所述电子表格的数据的下钻视图；以及当所述手势是排序手势时，对所述电子表格内的数据的至少一部分排序。
4.如权利要求1所述的方法，其特征在于，还包括在所述电子表格的显示上显示抓取用户界面元素，且其中通过以下各项来确定所述手势是所述抓取手势：确定何时按压所述抓取用户界面元素并且当按压所述抓取用户界面元素，则响应于手指在所述电子表格上移动来选择所述电子表格的一部分，以及当所述抓取用户界面元素不被按压，则改变所述电子表格的显示。
5.如权利要求1所述的方法，其特征在于，还包括：显示用于接收手势命令的手势框，且其中自动确定所接收的手势的类型包括：确定何时在所述手势框内接收到所述手势；根据所述手势确定手势命令；以及对所述电子表格中的数据执行所述手势命令。
6.如权利要求1所述的方法，其特征在于，还包括基于所接收的手势的位置，响应于剪切命令以及响应于粘贴命令来显示漩涡动画。
7.如权利要求1所述的方法，其特征在于，还包括确定何时所述电子表格被倾斜；确定所述倾斜的速度；且其中执行所述动作包括以下中的至少一个：基于倾斜和所述倾斜的速度中的至少一个来滚动所述电子表格的显示；显示所述电子表格中的电子表格对象向所述电子表格的顶端溢出；当与所述电子表格中的位置相关联的减速带位于预定位置中时自动减慢所述电子表格的滚动；确定何时所述电子表格被晃动并执行以下中的至少一个：清除电子表格对象上的筛选；并执行基于所述电子表格对象的重量对电子表格数据进行排序的重力排序，以及确定何时所述电子表格被旋转，并作为响应，改变所述电子表格的视图的类型。
8.一种用于与电子表格交互的方法，包括：
确定何时接收到触摸输入设备上的手势；其中所述手势用于与所述电子表格交互；
自动确定对于所述电子表格接收的手势的类型，其中所述手势的类型是以下中的至少一个：向电子表格应用指示在所述电子表格内插入数据的空手道砍劈手势；向所述电子表格应用指示在所述电子表格内显示图表的图表手势；向所述电子表格应用指示在所述电子表格内显示注释框的注释手势；指示何时将滚动模式改为选择模式的抓取手势；向所述电子表格应用指示执行以下中的至少一个动作的缩放手势：为所述电子表格的每一工作表显示缩略图并对所述电子表格的数据执行钻取操作；以及向所述电子表格指示对所述电子表格的数据执行操作的手势框手势；
响应于对于所述电子表格接收到的手势的类型相关执行动作；以及
更新所述电子表格的显示。
9.一种用于与电子表格交互的系统，包括：
确定何时接收到触摸输入设备上的手势的装置；其中所述手势用于与所述电子表格交互；
确定何时接收到与电子表格的移动相关的传感器信息的装置；
在对于所述电子表格接收到手势时自动确定所接收的手势的类型的装置，其中所述手势的类型是以下中的至少一个：向电子表格应用指示在所述电子表格内插入数据的空手道砍劈手势；向所述电子表格应用指示在所述电子表格内显示图表的图表手势；向所述电子表格应用指示在所述电子表格内显示注释框的注释手势；指示何时将滚动模式改为选择模式的抓取手势；向所述电子表格应用指示执行以下中的至少一个动作的缩放手势：为所述电子表格的每一工作表显示缩略图并对所述电子表格的数据执行钻取操作；以及向所述电子表格指示对所述电子表格的数据执行操作的手势框手势；
响应于对于所述电子表格接收到的手势的类型执行动作的装置；以及
更新所述电子表格的显示的装置。
10.如权利要求9所述的系统，其特征在于，还包括确定何时所述电子表格被倾斜的装置；确定何时所述电子表格被旋转的装置；确定何时所述电子表格被晃动的装置，且其中执行所述动作包括以下中的至少一个：显示所述电子表格中的电子表格对象向所述电子表格的顶端溢出；滚动所述电子表格；反转所显示的数据的方向；改变数据的排序以及改变所述电子表格的视图类型。
CN201210012142.0A 2011-01-07 2012-01-06 电子表格动作的自然输入 Active CN102629180B (zh)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US12/986,473 US9747270B2 (en) 2011-01-07 2011-01-07 Natural input for spreadsheet actions
US12/986,473 2011-01-07

Publications (2)

Publication Number Publication Date
CN102629180A CN102629180A (zh) 2012-08-08
CN102629180B true CN102629180B (zh) 2016-03-16

Family

ID=46456197

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201210012142.0A Active CN102629180B (zh) 2011-01-07 2012-01-06 电子表格动作的自然输入

Country Status (11)

Country Link
US (2) US9747270B2 (zh)
EP (1) EP2661664B1 (zh)
JP (1) JP5984843B2 (zh)
KR (1) KR101955433B1 (zh)
CN (1) CN102629180B (zh)
AU (1) AU2012204477B2 (zh)
BR (1) BR112013017396A2 (zh)
CA (1) CA2822066C (zh)
MX (1) MX343076B (zh)
RU (1) RU2604989C2 (zh)
WO (1) WO2012094396A2 (zh)

Families Citing this family (141)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8930331B2 (en) 2007-02-21 2015-01-06 Palantir Technologies Providing unique views of data based on changes or rules
US8984390B2 (en) 2008-09-15 2015-03-17 Palantir Technologies, Inc. One-click sharing for screenshots and related documents
CA2716436A1 (en) 2010-03-01 2011-09-01 Dundas Data Visualization, Inc. Systems and methods for generating data visualization dashboards
US9747270B2 (en) 2011-01-07 2017-08-29 Microsoft Technology Licensing, Llc Natural input for spreadsheet actions
CA2754520A1 (en) 2010-10-07 2012-04-07 Dundas Data Visualization, Inc. Systems and methods for dashboard image generation
CN103313650B (zh) * 2010-11-11 2016-09-14 卓尔医学产品公司 急诊处理系统信息面板
US20120180108A1 (en) 2011-01-06 2012-07-12 Dundas Data Visualization, Inc. Methods and systems for providing a discussion thread to key performance indicator information
JP2012231249A (ja) * 2011-04-25 2012-11-22 Sony Corp 表示制御装置、表示制御方法、およびプログラム
US8799240B2 (en) 2011-06-23 2014-08-05 Palantir Technologies, Inc. System and method for investigating large amounts of data
US9092482B2 (en) 2013-03-14 2015-07-28 Palantir Technologies, Inc. Fair scheduling for mixed-query loads
US9547693B1 (en) 2011-06-23 2017-01-17 Palantir Technologies Inc. Periodic database search manager for multiple data sources
US8832588B1 (en) * 2011-06-30 2014-09-09 Microstrategy Incorporated Context-inclusive magnifying area
US10001898B1 (en) 2011-07-12 2018-06-19 Domo, Inc. Automated provisioning of relational information for a summary data visualization
US9792017B1 (en) 2011-07-12 2017-10-17 Domo, Inc. Automatic creation of drill paths
US9202297B1 (en) * 2011-07-12 2015-12-01 Domo, Inc. Dynamic expansion of data visualizations
US8732574B2 (en) 2011-08-25 2014-05-20 Palantir Technologies, Inc. System and method for parameterizing documents for automatic workflow generation
US20130055131A1 (en) * 2011-08-26 2013-02-28 Microsoft Corporation Animation for Cut and Paste of Content
US9069454B2 (en) * 2011-08-31 2015-06-30 Sap Se Multi-select tools
US8504542B2 (en) 2011-09-02 2013-08-06 Palantir Technologies, Inc. Multi-row transactions
US9588953B2 (en) 2011-10-25 2017-03-07 Microsoft Technology Licensing, Llc Drag and drop always sum formulas
US9053083B2 (en) 2011-11-04 2015-06-09 Microsoft Technology Licensing, Llc Interaction between web gadgets and spreadsheets
US9171099B2 (en) 2012-01-26 2015-10-27 Microsoft Technology Licensing, Llc System and method for providing calculation web services for online documents
US9733707B2 (en) * 2012-03-22 2017-08-15 Honeywell International Inc. Touch screen display user interface and method for improving touch interface utility on the same employing a rules-based masking system
US9323443B2 (en) * 2012-05-02 2016-04-26 International Business Machines Corporation Drilling of displayed content in a touch screen device
US8527909B1 (en) * 2012-05-29 2013-09-03 Sencha, Inc. Manipulating data visualizations on a touch screen
KR102092234B1 (ko) * 2012-08-03 2020-03-23 엘지전자 주식회사 이동 단말기 및 그 제어방법
KR102096581B1 (ko) * 2012-09-14 2020-05-29 삼성전자주식회사 표시 정보를 편집하기 위한 방법 및 그 전자 장치
US9348677B2 (en) 2012-10-22 2016-05-24 Palantir Technologies Inc. System and method for batch evaluation programs
US20140118270A1 (en) * 2012-10-26 2014-05-01 Qualcomm Incorporated System and method for providing infrared gesture interaction on a display
US9182826B2 (en) * 2012-11-21 2015-11-10 Intel Corporation Gesture-augmented speech recognition
US9158766B2 (en) * 2012-11-29 2015-10-13 Oracle International Corporation Multi-touch interface for visual analytics
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
US9380431B1 (en) 2013-01-31 2016-06-28 Palantir Technologies, Inc. Use of teams in a mobile application
US9159116B2 (en) * 2013-02-13 2015-10-13 Google Inc. Adaptive screen interfaces based on viewing distance
US10372292B2 (en) 2013-03-13 2019-08-06 Microsoft Technology Licensing, Llc Semantic zoom-based navigation of displayed content
US10037314B2 (en) 2013-03-14 2018-07-31 Palantir Technologies, Inc. Mobile reports
KR102089951B1 (ko) * 2013-03-14 2020-04-14 엘지전자 주식회사 이동 단말기 및 그것의 제어방법
US8788405B1 (en) 2013-03-15 2014-07-22 Palantir Technologies, Inc. Generating data clusters with customizable analysis strategies
US9965937B2 (en) 2013-03-15 2018-05-08 Palantir Technologies Inc. External malware data item clustering and analysis
US8937619B2 (en) 2013-03-15 2015-01-20 Palantir Technologies Inc. Generating an object time series from data objects
US9760262B2 (en) * 2013-03-15 2017-09-12 Microsoft Technology Licensing, Llc Gestures involving direct interaction with a data visualization
US8917274B2 (en) 2013-03-15 2014-12-23 Palantir Technologies Inc. Event matrix based on integrated data
US8868486B2 (en) 2013-03-15 2014-10-21 Palantir Technologies Inc. Time-sensitive cube
US8909656B2 (en) 2013-03-15 2014-12-09 Palantir Technologies Inc. Filter chains with associated multipath views for exploring large data sets
US20140310619A1 (en) * 2013-04-12 2014-10-16 Microsoft Corporation Signal capture controls in recalculation user interface
US20140325418A1 (en) * 2013-04-30 2014-10-30 Microsoft Corporation Automatically manipulating visualized data based on interactivity
US8799799B1 (en) 2013-05-07 2014-08-05 Palantir Technologies Inc. Interactive geospatial map
US20140372856A1 (en) 2013-06-14 2014-12-18 Microsoft Corporation Natural Quick Functions Gestures
US10360297B2 (en) 2013-06-14 2019-07-23 Microsoft Technology Licensing, Llc Simplified data input in electronic documents
US9489368B2 (en) 2013-06-14 2016-11-08 Microsoft Technology Licensing, Llc Suggesting a set of operations applicable to a selected range of data in a spreadsheet
US10664652B2 (en) 2013-06-15 2020-05-26 Microsoft Technology Licensing, Llc Seamless grid and canvas integration in a spreadsheet application
US9223773B2 (en) 2013-08-08 2015-12-29 Palatir Technologies Inc. Template system for custom document generation
KR20150026095A (ko) * 2013-08-30 2015-03-11 삼성전자주식회사 전자 장치에서 차트를 표시하는 장치 및 방법
US9116975B2 (en) 2013-10-18 2015-08-25 Palantir Technologies Inc. Systems and user interfaces for dynamic and interactive simultaneous querying of multiple data stores
US8868537B1 (en) 2013-11-11 2014-10-21 Palantir Technologies, Inc. Simple web search
US9105000B1 (en) 2013-12-10 2015-08-11 Palantir Technologies Inc. Aggregating data from a plurality of data sources
US20150169531A1 (en) * 2013-12-17 2015-06-18 Microsoft Corporation Touch/Gesture-Enabled Interaction with Electronic Spreadsheets
US10356032B2 (en) 2013-12-26 2019-07-16 Palantir Technologies Inc. System and method for detecting confidential information emails
US8832832B1 (en) 2014-01-03 2014-09-09 Palantir Technologies Inc. IP reputation
JP5924554B2 (ja) * 2014-01-06 2016-05-25 コニカミノルタ株式会社 オブジェクトの停止位置制御方法、操作表示装置およびプログラム
US9483162B2 (en) 2014-02-20 2016-11-01 Palantir Technologies Inc. Relationship visualizations
US9727376B1 (en) 2014-03-04 2017-08-08 Palantir Technologies, Inc. Mobile tasks
CN103941997B (zh) * 2014-03-17 2017-12-26 联想(北京)有限公司 一种表格编辑方法及装置
US8924429B1 (en) 2014-03-18 2014-12-30 Palantir Technologies Inc. Determining and extracting changed data from a data source
US9857958B2 (en) 2014-04-28 2018-01-02 Palantir Technologies Inc. Systems and user interfaces for dynamic and interactive access of, investigation of, and analysis of data objects stored in one or more databases
US10162855B2 (en) 2014-06-09 2018-12-25 Dundas Data Visualization, Inc. Systems and methods for optimizing data analysis
US9619557B2 (en) 2014-06-30 2017-04-11 Palantir Technologies, Inc. Systems and methods for key phrase characterization of documents
US9535974B1 (en) 2014-06-30 2017-01-03 Palantir Technologies Inc. Systems and methods for identifying key phrase clusters within documents
US9256664B2 (en) 2014-07-03 2016-02-09 Palantir Technologies Inc. System and method for news events detection and visualization
US9202249B1 (en) 2014-07-03 2015-12-01 Palantir Technologies Inc. Data item clustering and analysis
US9513671B2 (en) 2014-08-01 2016-12-06 Microsoft Technology Licensing, Llc Peripheral retention device
US10191986B2 (en) 2014-08-11 2019-01-29 Microsoft Technology Licensing, Llc Web resource compatibility with web applications
US9705637B2 (en) 2014-08-19 2017-07-11 Microsoft Technology Licensing, Llc Guard band utilization for wireless data communication
US9805483B2 (en) 2014-08-21 2017-10-31 Microsoft Technology Licensing, Llc Enhanced recognition of charted data
US9524429B2 (en) * 2014-08-21 2016-12-20 Microsoft Technology Licensing, Llc Enhanced interpretation of character arrangements
US10095389B2 (en) * 2014-08-22 2018-10-09 Business Objects Software Ltd. Gesture-based on-chart data filtering
US9397723B2 (en) 2014-08-26 2016-07-19 Microsoft Technology Licensing, Llc Spread spectrum wireless over non-contiguous channels
KR20160024583A (ko) * 2014-08-26 2016-03-07 삼성전자주식회사 전자 장치 및 드로잉 기능 제공 방법
US9454281B2 (en) 2014-09-03 2016-09-27 Palantir Technologies Inc. System for providing dynamic linked panels in user interface
US10635262B2 (en) 2014-09-08 2020-04-28 Tableau Software, Inc. Interactive data visualization user interface with gesture-based data field selection
US10347018B2 (en) 2014-09-08 2019-07-09 Tableau Software, Inc. Interactive data visualization user interface with hierarchical filtering based on gesture location on a chart
US10521092B2 (en) * 2014-09-08 2019-12-31 Tableau Software, Inc. Methods and devices for adjusting chart magnification asymmetrically
US10347027B2 (en) 2014-09-08 2019-07-09 Tableau Software, Inc. Animated transition between data visualization versions at different levels of detail
US10380770B2 (en) 2014-09-08 2019-08-13 Tableau Software, Inc. Interactive data visualization user interface with multiple interaction profiles
US9424048B2 (en) 2014-09-15 2016-08-23 Microsoft Technology Licensing, Llc Inductive peripheral retention device
US9501851B2 (en) 2014-10-03 2016-11-22 Palantir Technologies Inc. Time-series analysis system
US9767172B2 (en) 2014-10-03 2017-09-19 Palantir Technologies Inc. Data aggregation and analysis system
US9984133B2 (en) 2014-10-16 2018-05-29 Palantir Technologies Inc. Schematic and database linking system
US9043894B1 (en) 2014-11-06 2015-05-26 Palantir Technologies Inc. Malicious software detection in a computing system
US9904456B2 (en) * 2014-12-02 2018-02-27 Business Objects Software Ltd. Gesture-based visualization of data grid on mobile device
US9348920B1 (en) 2014-12-22 2016-05-24 Palantir Technologies Inc. Concept indexing among database of documents using machine learning techniques
US9367872B1 (en) 2014-12-22 2016-06-14 Palantir Technologies Inc. Systems and user interfaces for dynamic and interactive investigation of bad actor behavior based on automatic clustering of related data in various data structures
US10552994B2 (en) 2014-12-22 2020-02-04 Palantir Technologies Inc. Systems and interactive user interfaces for dynamic retrieval, analysis, and triage of data items
US9335911B1 (en) 2014-12-29 2016-05-10 Palantir Technologies Inc. Interactive user interface for dynamic data analysis exploration and query processing
US9817563B1 (en) 2014-12-29 2017-11-14 Palantir Technologies Inc. System and method of generating data points from one or more data stores of data items for chart creation and manipulation
US9811256B2 (en) * 2015-01-14 2017-11-07 International Business Machines Corporation Touch screen tactile gestures for data manipulation
CN105988655B (zh) * 2015-02-09 2018-12-21 珠海金山办公软件有限公司 一种电子表格行列区域调整方法及装置
US9727560B2 (en) 2015-02-25 2017-08-08 Palantir Technologies Inc. Systems and methods for organizing and identifying documents via hierarchies and dimensions of tags
US10229655B2 (en) * 2015-02-28 2019-03-12 Microsoft Technology Licensing, Llc Contextual zoom
EP3070622A1 (en) 2015-03-16 2016-09-21 Palantir Technologies, Inc. Interactive user interfaces for location-based data analysis
US9454785B1 (en) 2015-07-30 2016-09-27 Palantir Technologies Inc. Systems and user interfaces for holistic, data-driven investigation of bad actor behavior based on clustering and scoring of related data
US9456000B1 (en) 2015-08-06 2016-09-27 Palantir Technologies Inc. Systems, methods, user interfaces, and computer-readable media for investigating potential malicious communications
US10489391B1 (en) 2015-08-17 2019-11-26 Palantir Technologies Inc. Systems and methods for grouping and enriching data items accessed from one or more databases for presentation in a user interface
US9600146B2 (en) 2015-08-17 2017-03-21 Palantir Technologies Inc. Interactive geospatial map
US11150917B2 (en) 2015-08-26 2021-10-19 Palantir Technologies Inc. System for data aggregation and analysis of data from a plurality of data sources
US10706434B1 (en) 2015-09-01 2020-07-07 Palantir Technologies Inc. Methods and systems for determining location information
US10896532B2 (en) 2015-09-08 2021-01-19 Tableau Software, Inc. Interactive data visualization user interface with multiple interaction profiles
US10296617B1 (en) 2015-10-05 2019-05-21 Palantir Technologies Inc. Searches of highly structured data
US9542446B1 (en) 2015-12-17 2017-01-10 Palantir Technologies, Inc. Automatic generation of composite datasets based on hierarchical fields
US9823818B1 (en) 2015-12-29 2017-11-21 Palantir Technologies Inc. Systems and interactive user interfaces for automatic generation of temporal representation of data objects
US9612723B1 (en) 2015-12-30 2017-04-04 Palantir Technologies Inc. Composite graphical interface with shareable data-objects
US10748312B2 (en) 2016-02-12 2020-08-18 Microsoft Technology Licensing, Llc Tagging utilizations for selectively preserving chart elements during visualization optimizations
US10347017B2 (en) * 2016-02-12 2019-07-09 Microsoft Technology Licensing, Llc Interactive controls that are collapsible and expandable and sequences for chart visualization optimizations
JP6455466B2 (ja) * 2016-03-02 2019-01-23 京セラドキュメントソリューションズ株式会社 表示操作装置およびプログラム
US10698938B2 (en) 2016-03-18 2020-06-30 Palantir Technologies Inc. Systems and methods for organizing and identifying documents via hierarchies and dimensions of tags
EP3452924A4 (en) * 2016-04-27 2020-01-01 Coda Project, Inc. SYSTEM, METHOD AND APPARATUS FOR OPERATING A UNIFIED DOCUMENT SURFACE WORKSPACE
CN107358574A (zh) * 2016-05-10 2017-11-17 阿里巴巴集团控股有限公司 一种图像缩小方法及装置
US10324609B2 (en) 2016-07-21 2019-06-18 Palantir Technologies Inc. System for providing dynamic linked panels in user interface
US10719188B2 (en) 2016-07-21 2020-07-21 Palantir Technologies Inc. Cached database and synchronization system for providing dynamic linked panels in user interface
US10474356B2 (en) * 2016-08-04 2019-11-12 International Business Machines Corporation Virtual keyboard improvement
US10025768B2 (en) 2016-08-08 2018-07-17 International Business Machines Corporation Inserting new elements in a tabular data structure
US20180090027A1 (en) * 2016-09-23 2018-03-29 Apple Inc. Interactive tutorial support for input options at computing devices
US10318630B1 (en) 2016-11-21 2019-06-11 Palantir Technologies Inc. Analysis of large bodies of textual data
CN108319577B (zh) * 2017-01-18 2021-09-28 阿里巴巴集团控股有限公司 一种图表的处理方法、装置及电子设备
US20190050060A1 (en) * 2017-03-10 2019-02-14 Awearable Apparel Inc. Methods, systems, and media for providing input based on accelerometer input
USD847826S1 (en) * 2017-03-20 2019-05-07 MTL Ventures LLC Display screen with animated graphical user interface
USD847827S1 (en) * 2017-03-20 2019-05-07 MTL Ventures LLC Display screen with animated graphical user interface
JP6939135B2 (ja) * 2017-06-23 2021-09-22 カシオ計算機株式会社 電子機器、プログラム、サーバ、グラフ画像生成方法およびグラフ画像生成システム
US20190068900A1 (en) * 2017-08-30 2019-02-28 Lenovo (Singapore) Pte. Ltd. Display Component Emitting Both Visible Spectrum and Infrared Spectrum Light
US11048695B2 (en) * 2017-09-12 2021-06-29 Sap Se Context-aware data commenting system
JP6821536B2 (ja) * 2017-10-03 2021-01-27 キヤノン株式会社 画像処理装置、制御方法及びプログラム
CN109992751B (zh) * 2017-12-29 2023-12-01 珠海金山办公软件有限公司 表格对象的放大显示方法、装置、电子设备及存储介质
US11599369B1 (en) 2018-03-08 2023-03-07 Palantir Technologies Inc. Graphical user interface configuration system
US11320983B1 (en) * 2018-04-25 2022-05-03 David Graham Boyers Methods and graphical user interfaces for positioning a selection, selecting, and editing, on a computing device running applications under a touch-based operating system
US10885021B1 (en) 2018-05-02 2021-01-05 Palantir Technologies Inc. Interactive interpreter and graphical user interface
CN109117227A (zh) * 2018-08-01 2019-01-01 长沙拓扑陆川新材料科技有限公司 一种用户界面生成区块功能链的方法
US11610059B2 (en) 2018-12-07 2023-03-21 Interject Data System, Inc. Systems and methods for a visual interface for grid-based programs
CN110245586A (zh) * 2019-05-28 2019-09-17 贵州卓霖科技有限公司 一种基于手势识别的数据统计方法、系统、介质及设备
CN112162640B (zh) * 2020-10-13 2022-10-25 深圳晶泰科技有限公司 晶体显示方法及系统
WO2022182796A1 (en) 2021-02-23 2022-09-01 Coda Project, Inc. System, method, and apparatus for publication and external interfacing for a unified document surface
CN113238688B (zh) * 2021-05-10 2023-06-27 北京字跳网络技术有限公司 表格展示方法、装置、设备及介质

Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1877505A (zh) * 2005-06-10 2006-12-13 鸿富锦精密工业（深圳）有限公司 数位信息阅读装置及其控制方法

Family Cites Families (361)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH01165795A (ja) 1987-12-22 1989-06-29 Kanai Hiroyuki タイヤ用ビードワイヤの製造方法
US5339392A (en) 1989-07-27 1994-08-16 Risberg Jeffrey S Apparatus and method for creation of a user definable video displayed document showing changes in real time data
JPH03268185A (ja) 1990-03-19 1991-11-28 Nec Home Electron Ltd 表計算方法及びシステム
JPH043477A (ja) 1990-04-19 1992-01-08 Furukawa Electric Co Ltd:The セラミックス超電導限流器
GB9009930D0 (en) 1990-05-02 1990-06-27 Int Computers Ltd Electronic spreadsheet
US5212788A (en) 1990-05-22 1993-05-18 Digital Equipment Corporation System and method for consistent timestamping in distributed computer databases
US5095429A (en) 1990-08-28 1992-03-10 Pillar Corporation Method for prioritizing data in financial information system
JP3196852B2 (ja) 1991-05-09 2001-08-06 ソニー株式会社 ウインドウ表示位置制御装置およびウインドウ表示位置制御方法
US5848187A (en) 1991-11-18 1998-12-08 Compaq Computer Corporation Method and apparatus for entering and manipulating spreadsheet cell data
US6578027B2 (en) 1996-08-20 2003-06-10 Business Objects, Sa Relational database access system using semantically dynamic objects
US5555403A (en) 1991-11-27 1996-09-10 Business Objects, S.A. Relational database access system using semantically dynamic objects
US5623282A (en) 1991-12-31 1997-04-22 Microsoft Corporation Method and system for the direct manipulation of cells in an electronic spreadsheet program or the like
US5416895A (en) 1992-04-08 1995-05-16 Borland International, Inc. System and methods for improved spreadsheet interface with user-familiar objects
US5371675A (en) 1992-06-03 1994-12-06 Lotus Development Corporation Spreadsheet program which implements alternative range references
US5423034A (en) 1992-06-10 1995-06-06 Cohen-Levy; Leon Network file management with user determined hierarchical file structures and means for intercepting application program open and save commands for inputting and displaying user inputted descriptions of the location and content of files
JP3613401B2 (ja) 1992-07-06 2005-01-26 マイクロソフト コーポレーション オブジェクトの名称を付けて結び付ける方法及びシステム
JP3462512B2 (ja) 1992-07-10 2003-11-05 株式会社日立製作所 グラフ修正方法
US5403639A (en) 1992-09-02 1995-04-04 Storage Technology Corporation File server having snapshot application data groups
WO1994014115A2 (en) 1992-12-01 1994-06-23 Microsoft Corporation A method and system for in-place interaction with embedded objects
US5452447A (en) 1992-12-21 1995-09-19 Sun Microsystems, Inc. Method and apparatus for a caching file server
EP0698242A1 (en) 1993-05-10 1996-02-28 Apple Computer, Inc. System for automatically determining the status of contents added to a document
US5455945A (en) 1993-05-19 1995-10-03 Vanderdrift; Richard System and method for dynamically displaying entering, and updating data from a database
US5963962A (en) 1995-05-31 1999-10-05 Network Appliance, Inc. Write anywhere file-system layout
JP3751018B2 (ja) 1993-06-03 2006-03-01 ネットワーク・アプライアンス・インコーポレイテッド ライトエニウエアファイルシステムレイアウト
JPH0737008A (ja) 1993-06-29 1995-02-07 Hitachi Ltd 表計算処理装置の表示制御方法
US5581670A (en) 1993-07-21 1996-12-03 Xerox Corporation User interface having movable sheet with click-through tools
US6216138B1 (en) 1994-04-22 2001-04-10 Brooks Automation Inc. Computer interface system for automatically generating graphical representations of computer operations linked together according to functional relationships
US5604854A (en) 1994-04-22 1997-02-18 Borland International, Inc. System and methods for reformatting multi-dimensional spreadsheet information
JPH07334696A (ja) 1994-06-10 1995-12-22 Hitachi Ltd 表作成システム
US6160549A (en) 1994-07-29 2000-12-12 Oracle Corporation Method and apparatus for generating reports using declarative tools
US5727161A (en) 1994-09-16 1998-03-10 Planscan, Llc Method and apparatus for graphic analysis of variation of economic plans
US5881176A (en) 1994-09-21 1999-03-09 Ricoh Corporation Compression and decompression with wavelet style and binary style including quantization by device-dependent parser
US5694608A (en) 1995-01-27 1997-12-02 Borland International, Inc. Non-modal database system wth methods for incremental maintenance of live reports
US5893125A (en) 1995-01-27 1999-04-06 Borland International, Inc. Non-modal database system with methods for incremental maintenance
US5619631A (en) 1995-06-07 1997-04-08 Binaryblitz Method and apparatus for data alteration by manipulation of representational graphs
US5893123A (en) 1995-06-22 1999-04-06 Tuinenga; Paul W. System and method of integrating a spreadsheet and external program having output data calculated automatically in response to input data from the spreadsheet
GB9516977D0 (en) 1995-08-17 1995-10-18 Dreamware Design & Dev Ltd Processing apparatus and method and computer software therefor
US6157934A (en) 1995-10-24 2000-12-05 Ultimus, L.L.C. Method and apparatus for using distributed spreadsheets in a client/server architecture for workflow automation
US5890174A (en) 1995-11-16 1999-03-30 Microsoft Corporation Method and system for constructing a formula in a spreadsheet
GB2311151B (en) 1996-02-29 2000-11-15 Jba Holdings Plc An object browser and manipulation system
EP0798655A3 (en) 1996-03-25 1999-05-19 Sun Microsystems, Inc. Internet-enabled graphical user interface with toolbar icons having built-in links to world-wide web documents and an integrated web browser
US6434578B1 (en) 1996-06-26 2002-08-13 Microsoft Corporation Generating instruction sequences using independently executable pane renderers
JPH1027089A (ja) 1996-07-11 1998-01-27 Fuji Xerox Co Ltd コンピュータ操作支援装置
US5745714A (en) 1996-07-19 1998-04-28 International Business Machines Corporation Method and system in a data processing system for the association and display of a plurality of objects
JPH1069480A (ja) 1996-08-29 1998-03-10 Canon Inc 文書処理方法及び文書処理装置、記憶媒体
US6081818A (en) 1996-12-11 2000-06-27 International Business Machines Corporation Cut object dynamic display and method of displaying cut objects
US5899988A (en) 1997-02-28 1999-05-04 Oracle Corporation Bitmapped indexing with high granularity locking
EP0864838B1 (de) 1997-03-11 2002-12-04 Behr GmbH & Co. Wärmeübertrager für ein Kraftfahrzeug
US6097391A (en) 1997-03-31 2000-08-01 Menai Corporation Method and apparatus for graphically manipulating objects
US5978818A (en) 1997-04-29 1999-11-02 Oracle Corporation Automated hypertext outline generation for documents
US6256651B1 (en) 1997-06-20 2001-07-03 Raja Tuli Time management workflow software
US6269403B1 (en) 1997-06-30 2001-07-31 Microsoft Corporation Browser and publisher for multimedia object storage, retrieval and transfer
US5987481A (en) 1997-07-01 1999-11-16 Microsoft Corporation Method and apparatus for using label references in spreadsheet formulas
US5910988A (en) 1997-08-27 1999-06-08 Csp Holdings, Inc. Remote image capture with centralized processing and storage
JP4149574B2 (ja) 1997-08-29 2008-09-10 ゼロックス コーポレイション ユーザインターフェースサポートデバイス、及び情報入力方法
US6038639A (en) 1997-09-09 2000-03-14 Storage Technology Corporation Data file storage management system for snapshot copy operations
US6003012A (en) 1997-12-05 1999-12-14 Square D Company Methodology and computer-based tools for design, production and sales of customized switchboards
US20070177804A1 (en) * 2006-01-30 2007-08-02 Apple Computer, Inc. Multi-touch gesture dictionary
US6323846B1 (en) 1998-01-26 2001-11-27 University Of Delaware Method and apparatus for integrating manual input
US9292111B2 (en) * 1998-01-26 2016-03-22 Apple Inc. Gesturing with a multipoint sensing device
US6249606B1 (en) 1998-02-19 2001-06-19 Mindmaker, Inc. Method and system for gesture category recognition and training using a feature vector
US6009455A (en) 1998-04-20 1999-12-28 Doyle; John F. Distributed computation utilizing idle networked computers
US7539637B2 (en) 1998-04-24 2009-05-26 Starmine Corporation Security analyst estimates performance viewing system and method
US6289352B1 (en) 1998-05-29 2001-09-11 Crystal Decisions, Inc. Apparatus and method for compound on-line analytical processing in databases
US6460059B1 (en) 1998-08-04 2002-10-01 International Business Machines Corporation Visual aid to simplify achieving correct cell interrelations in spreadsheets
JP2000056888A (ja) 1998-08-10 2000-02-25 Dainippon Screen Mfg Co Ltd ユーザーインターフェイス設定方法及びその装置
US6625603B1 (en) 1998-09-21 2003-09-23 Microsoft Corporation Object type specific access control
US6412070B1 (en) 1998-09-21 2002-06-25 Microsoft Corporation Extensible security system and method for controlling access to objects in a computing environment
US6501491B1 (en) 1998-09-21 2002-12-31 Microsoft Corporation Extensible user interface for viewing objects over a network
US6275824B1 (en) 1998-10-02 2001-08-14 Ncr Corporation System and method for managing data privacy in a database management system
US6298334B1 (en) 1998-10-15 2001-10-02 Netdecide Corporation Object-based numeric-analysis engine
US6360246B1 (en) 1998-11-13 2002-03-19 The Nasdaq Stock Market, Inc. Report generation architecture for remotely generated data
US6023691A (en) 1998-12-22 2000-02-08 Ac Properties B.V. Goal based stimulator utilizing a spreadsheet architecture
US6549878B1 (en) 1998-12-31 2003-04-15 Microsoft Corporation System and method for editing a spreadsheet via an improved editing and cell selection model
US6640234B1 (en) 1998-12-31 2003-10-28 Microsoft Corporation Extension of formulas and formatting in an electronic spreadsheet
US7469381B2 (en) 2007-01-07 2008-12-23 Apple Inc. List scrolling and document translation, scaling, and rotation on a touch-screen display
JP3396177B2 (ja) 1999-01-26 2003-04-14 インターナショナル・ビジネス・マシーンズ・コーポレーション ウェブページカスタマイズシステム
EP1037157A1 (en) 1999-03-05 2000-09-20 International Business Machines Corporation Method and system for processing different cell protection modes in an electronic spreadsheet
US6199099B1 (en) 1999-03-05 2001-03-06 Ac Properties B.V. System, method and article of manufacture for a mobile communication network utilizing a distributed communication network
US6662341B1 (en) 1999-05-20 2003-12-09 Microsoft Corporation Method and apparatus for writing a windows application in HTML
US7421648B1 (en) 1999-05-21 2008-09-02 E-Numerate Solutions, Inc. Reusable data markup language
US7821507B2 (en) 1999-05-25 2010-10-26 Silverbrook Research Pty Ltd Method of providing information via a printed substrate and two-mode sensing device
AU5062000A (en) 1999-06-11 2001-03-13 Cci Europe A/S A content management computer system for managing publishing content objects
US6626959B1 (en) 1999-06-14 2003-09-30 Microsoft Corporation Automatic formatting of pivot table reports within a spreadsheet
US6411313B1 (en) 1999-06-14 2002-06-25 Microsoft Corporation User interface for creating a spreadsheet pivottable
US6613098B1 (en) 1999-06-15 2003-09-02 Microsoft Corporation Storage of application specific data in HTML
US6701485B1 (en) 1999-06-15 2004-03-02 Microsoft Corporation Binding spreadsheet cells to objects
US6631497B1 (en) 1999-07-19 2003-10-07 International Business Machines Corporation Binding data from data source to cells in a spreadsheet
US7644366B1 (en) 1999-07-30 2010-01-05 Computer Associates Think, Inc. Method and system for displaying a plurality of discrete files in a compound file
US6189009B1 (en) 1999-08-27 2001-02-13 The Voice.Com, Inc. System and method for integrating paper-based business documents with computer-readable data entered via a computer network
US6507865B1 (en) 1999-08-30 2003-01-14 Zaplet, Inc. Method and system for group content collaboration
JP2001092444A (ja) 1999-09-21 2001-04-06 Sony Corp 情報処理装置及び情報処理方法並びにプログラム格納媒体
GB2354851B (en) 1999-10-01 2004-07-21 Ibm Web browser extension and method for processing data content of web pages
CA2321456A1 (en) 1999-10-01 2001-04-01 B-50.Com, Llc System and methods for generating custom reports based on point-of-sale data
US6832351B1 (en) 1999-10-01 2004-12-14 Microsoft Corporation Method and system for previewing and printing customized business forms
JP2001109741A (ja) 1999-10-13 2001-04-20 Toshiba Corp Ｈｔｍｌデータ作成方法及びｈｔｍｌデータ作成システム
JP2001118009A (ja) 1999-10-18 2001-04-27 Internatl Business Mach Corp <Ibm> 電子帳票の取得方法、電子帳票システム、電子帳票を取得するプログラムを格納した記憶媒体
DE60045625D1 (de) 1999-12-22 2011-03-24 Accenture Global Services Gmbh Ein verfahren für einen suchfiltergenerator mit grafischer benutzerschnittstelle
CA2311866A1 (en) 2000-01-06 2001-07-06 International Business Machines Corporation Method and system in an electronic spreadsheet for adding or removing elements from a cell named range according to different modes
JP2003521061A (ja) 2000-01-25 2003-07-08 オートデスク，インコーポレイテッド インターネット上で建築図面へのアクセスを提供し、処理する方法および装置
WO2001059675A1 (en) 2000-02-11 2001-08-16 Ryan Mark H Method and system for distributing and collecting spreadsheet information
US6484186B1 (en) 2000-02-15 2002-11-19 Novell, Inc. Method for backing up consistent versions of open files
US6651075B1 (en) 2000-02-16 2003-11-18 Microsoft Corporation Support for multiple temporal snapshots of same volume
US6757869B1 (en) 2000-03-20 2004-06-29 International Business Machines Corporation Method and apparatus for providing access to a legacy application on a distributed data processing system
US7725385B2 (en) 2000-03-29 2010-05-25 American Express Travel Related Services Company, Inc. System and method for facilitating the handling of a dispute using disparate architectures
US20020049778A1 (en) 2000-03-31 2002-04-25 Bell Peter W. System and method of information outsourcing
US7143338B2 (en) 2000-04-14 2006-11-28 International Business Machines Corporation Method and system in an electronic spreadsheet for handling absolute references in a copy/cut and paste operation according to different modes
US20020015059A1 (en) 2000-04-17 2002-02-07 Clarke Hernan Jose Method and system for publishing reports to a network
US20020070953A1 (en) 2000-05-04 2002-06-13 Barg Timothy A. Systems and methods for visualizing and analyzing conditioned data
US6995768B2 (en) 2000-05-10 2006-02-07 Cognos Incorporated Interactive business data visualization system
JP2001357088A (ja) 2000-06-16 2001-12-26 Denso Corp パラメトリック機能を有する３次元モデリングシステムと、同システムによるパラメータ編集方法
US7117435B1 (en) 2000-06-21 2006-10-03 Microsoft Corporation Spreadsheet fields in text
US6632249B2 (en) 2000-06-23 2003-10-14 Microsoft Corporation Method for providing web-based services to an application program module
US6961905B1 (en) 2000-06-23 2005-11-01 Microsoft Corporation Method and system for modifying an image on a web page
AU7326201A (en) 2000-07-05 2002-01-14 Xml Industries, Llc Process and architecture for xml-based insurance marketplace
AU2001277868A1 (en) 2000-07-11 2002-01-21 Juice Software, Inc. A method and system for integrating network-based functionality into productivity applications and documents
US6948134B2 (en) 2000-07-21 2005-09-20 Microsoft Corporation Integrated method for creating a refreshable Web Query
WO2002019228A1 (en) 2000-09-01 2002-03-07 Togethersoft Corporation Methods and systems for improving a workflow based on data mined from plans created from the workflow
JP3790661B2 (ja) 2000-09-08 2006-06-28 インターナショナル・ビジネス・マシーンズ・コーポレーション アクセス制御システム
US7295509B2 (en) 2000-09-13 2007-11-13 Qualcomm, Incorporated Signaling method in an OFDM multiple access system
US6988241B1 (en) 2000-10-16 2006-01-17 International Business Machines Corporation Client side, web-based spreadsheet
US7930252B2 (en) 2000-10-24 2011-04-19 Google, Inc. Method and system for sharing anonymous user information
US7055105B2 (en) 2000-10-27 2006-05-30 Siemens Aktiengesellschaft Drop-enabled tabbed dialogs
JP2002140159A (ja) 2000-10-30 2002-05-17 Motoaki Fujimoto センサー付き携帯情報機器
US7885981B2 (en) 2000-10-31 2011-02-08 Michael Philip Kaufman System and method for generating automatic user interface for arbitrarily complex or large databases
US6738770B2 (en) 2000-11-04 2004-05-18 Deep Sky Software, Inc. System and method for filtering and sorting data
US6918091B2 (en) * 2000-11-09 2005-07-12 Change Tools, Inc. User definable interface system, method and computer program product
JP2003050964A (ja) 2000-11-30 2003-02-21 Kokusai Zunou Sangyo Kk 表計算ウェブサーバシステムおよび表計算ウェブシステム
US7206997B2 (en) 2000-12-18 2007-04-17 General Motors Corporation Functional visualization of spreadsheets
US6901407B2 (en) 2001-01-12 2005-05-31 Rick D. Curns System and method for updating project management scheduling charts
US6789109B2 (en) 2001-02-22 2004-09-07 Sony Corporation Collaborative computer-based production system including annotation, versioning and remote interaction
US20040125130A1 (en) 2001-02-26 2004-07-01 Andrea Flamini Techniques for embedding custom user interface controls inside internet content
TWI251751B (en) 2001-02-27 2006-03-21 Ibm Method and system in an electronic spreadsheet for handling graphical objects referring to working ranges of cells in a copy/cut and paste operation
US6906717B2 (en) 2001-02-27 2005-06-14 Microsoft Corporation Multiple chart user interface
US7552139B2 (en) 2001-03-19 2009-06-23 Xerox Corporation Represented object groups
US20030061305A1 (en) 2001-03-30 2003-03-27 Chyron Corporation System and method for enhancing streaming media delivery and reporting
US6775675B1 (en) 2001-04-04 2004-08-10 Sagemetrics Corporation Methods for abstracting data from various data structures and managing the presentation of the data
AU2002254564A1 (en) 2001-04-10 2002-10-28 Latanya Sweeney Systems and methods for deidentifying entries in a data source
US6801910B1 (en) 2001-06-19 2004-10-05 Microstrategy, Incorporated Method and system for guiding drilling in a report generated by a reporting system
US6691100B1 (en) 2001-06-20 2004-02-10 Microstrategy, Incorporated HTML/DHTML web interface system and method
US7013312B2 (en) 2001-06-21 2006-03-14 International Business Machines Corporation Web-based strategic client planning system for end-user creation of queries, reports and database updates
US20030033329A1 (en) 2001-06-22 2003-02-13 Bergman Eric D. Method and apparatus for entry and editing of spreadsheet formulas
US20030011638A1 (en) * 2001-07-10 2003-01-16 Sun-Woo Chung Pop-up menu system
US7765490B2 (en) 2001-07-18 2010-07-27 International Business Machines Corporation Method and system for software applications using a tiled user interface
US20030044762A1 (en) 2001-08-29 2003-03-06 Assessment Technology Inc. Educational management system
US7031979B2 (en) 2001-08-31 2006-04-18 Hewlett-Packard Development Company, L.P. Report generation system and method
US20030065638A1 (en) 2001-09-19 2003-04-03 Jason Robert The method to comstomize the appearance of a wab page by dragging and dropping objects within a web page
JP2003108440A (ja) 2001-09-28 2003-04-11 Toshiba Corp データ公開方法、データ公開プログラム、データ公開装置
US6907428B2 (en) 2001-11-02 2005-06-14 Cognos Incorporated User interface for a multi-dimensional data store
US7174504B2 (en) 2001-11-09 2007-02-06 Wuxi Evermore Software, Inc. Integrated data processing system with links
US20030120999A1 (en) 2001-12-21 2003-06-26 Miller Michelle A. Calculating in spreadsheet cells without using formulas
JP4291999B2 (ja) 2002-01-18 2009-07-08 株式会社インターネットディスクロージャー 書類作成システム及び作成管理プログラム
US7647320B2 (en) 2002-01-18 2010-01-12 Peoplechart Corporation Patient directed system and method for managing medical information
US7231657B2 (en) 2002-02-14 2007-06-12 American Management Systems, Inc. User authentication system and methods thereof
US7441197B2 (en) 2002-02-26 2008-10-21 Global Asset Protection Services, Llc Risk management information interface system and associated methods
US7650576B2 (en) 2002-03-07 2010-01-19 Business Objects Americas Method and system for creating graphical and interactive representations of input and output data
US6993533B1 (en) 2002-03-25 2006-01-31 Bif Technologies Corp. Relational database drill-down convention and reporting tool
US7015911B2 (en) 2002-03-29 2006-03-21 Sas Institute Inc. Computer-implemented system and method for report generation
US20040003353A1 (en) 2002-05-14 2004-01-01 Joey Rivera Workflow integration system for automatic real time data management
US7805437B1 (en) 2002-05-15 2010-09-28 Spotfire Ab Interactive SAR table
EP1367514A1 (en) 2002-05-29 2003-12-03 Framtidsforum I &amp; M AB Method in connection with a spreadsheet program
US20030226105A1 (en) 2002-05-29 2003-12-04 Mattias Waldau Method in connection with a spreadsheet program
US20030233257A1 (en) 2002-06-13 2003-12-18 Gregor Matian Interactive patient data report generation
US7574652B2 (en) 2002-06-20 2009-08-11 Canon Kabushiki Kaisha Methods for interactively defining transforms and for generating queries by manipulating existing query data
US20040064449A1 (en) 2002-07-18 2004-04-01 Ripley John R. Remote scoring and aggregating similarity search engine for use with relational databases
US7058902B2 (en) * 2002-07-30 2006-06-06 Microsoft Corporation Enhanced on-object context menus
US7945846B2 (en) 2002-09-06 2011-05-17 Oracle International Corporation Application-specific personalization for data display
US20040117731A1 (en) 2002-09-27 2004-06-17 Sergey Blyashov Automated report building system
JP2004145713A (ja) 2002-10-25 2004-05-20 Toukei Computer Co Ltd ブラウザのみで動作する「表計算」「ワープロ」ソフトによるドキュメント作成・管理システム
US8416217B1 (en) 2002-11-04 2013-04-09 Neonode Inc. Light-based finger gesture user interface
US20040100501A1 (en) 2002-11-25 2004-05-27 Dornback Jason Robert Method of dragging and dropping defined objects to or from a web page
US7266763B2 (en) 2002-11-26 2007-09-04 Microsoft Corporation User defined spreadsheet functions
US20040119727A1 (en) 2002-12-19 2004-06-24 International Business Machines Corporation Extracting displayed numerical data from displayed documents received from communication networks, e.g. World Wide Web, and processing the extracted numerical data independent of the received document
US20040123246A1 (en) 2002-12-23 2004-06-24 Ju Wu Apparatus and method for creating new reports from discrete reports
US20040128147A1 (en) 2002-12-26 2004-07-01 Sundar Vallinayagam Method and system to implement complex pricing rules
US7949937B2 (en) 2002-12-31 2011-05-24 Business Objects Software Ltd Apparatus and method for delivering portions of reports
US7660843B1 (en) 2003-01-21 2010-02-09 Novell, Inc. Method and apparatus for dynamically delivering a gadget
US7565618B2 (en) 2003-02-13 2009-07-21 LumaPix Inc. Method and system for distributing multiple dragged objects
US20040168115A1 (en) 2003-02-21 2004-08-26 Bauernschmidt Bill G. Method and system for visualizing data from multiple, cached data sources with user defined treemap reports
US7017112B2 (en) 2003-02-28 2006-03-21 Microsoft Corporation Importing and exporting markup language data in a spreadsheet application document
US6990632B2 (en) 2003-02-28 2006-01-24 Microsoft Corporation Method and system for inferring a schema from a hierarchical data structure for use in a spreadsheet
US7917382B2 (en) 2003-03-05 2011-03-29 Teradata Us, Inc. Integration of visualizations, reports, and data
US20040181748A1 (en) 2003-03-10 2004-09-16 International Business Machines Corporation Thin client framework deployment of spreadsheet applications in a web browser based environment
US7188308B2 (en) 2003-04-08 2007-03-06 Thomas Weise Interface and method for exploring a collection of data
US7007229B2 (en) 2003-04-11 2006-02-28 Sas Institute Inc. Computer-implemented system and method for web-based data access
US20040221233A1 (en) 2003-04-29 2004-11-04 David Thielen Systems and methods for report design and generation
US7516146B2 (en) 2003-05-15 2009-04-07 Microsoft Corporation Fast adaptive document filtering
JP2006526828A (ja) 2003-06-05 2006-11-24 スイス リインシュアランス カンパニー 均一な装置無依存型グラフィカル・ユーザー・インターフェースの生成方法およびターミナル
CA2433523C (en) 2003-06-26 2010-06-29 Ibm Canada Limited - Ibm Canada Limitee Mehtod of displaying local and remote data objects and of interacting with same
US7299223B2 (en) 2003-07-16 2007-11-20 Oracle International Corporation Spreadsheet to SQL translation
US7047380B2 (en) 2003-07-22 2006-05-16 Acronis Inc. System and method for using file system snapshots for online data backup
US7793227B2 (en) 2003-08-12 2010-09-07 Yahoo! Inc. Method and system of providing customizable buttons
US7205957B2 (en) 2003-08-18 2007-04-17 Via Technologies, Inc. Mechanism for adjusting the operational parameters of a component with minimal impact on graphics display
US20050097146A1 (en) 2003-08-21 2005-05-05 Konstantinou Alexander V. Methods and systems for autonomously managing a network
US7406483B2 (en) 2003-09-02 2008-07-29 International Business Machines Corporation Provisioning of software components via workflow management systems
US20050068290A1 (en) 2003-09-28 2005-03-31 Denny Jaeger Method for creating and using user-friendly grids
EP1683049A1 (en) 2003-10-29 2006-07-26 Sap Ag Sytems and methods for searching and displaying reports
US7640496B1 (en) 2003-10-31 2009-12-29 Emc Corporation Method and apparatus for generating report views
US20050108052A1 (en) 2003-11-03 2005-05-19 Omaboe Nortey J. Proces for diagnosic system and method applying artificial intelligence techniques to a patient medical record and that combines customer relationship management (CRM) and enterprise resource planning (ERP) software in a revolutionary way to provide a unique-and uniquely powerful and easy-to-use-tool to manage veterinary or human medical clinics and hospitals
WO2005045656A1 (en) 2003-11-04 2005-05-19 Think2020, Inc. Systems, methods, and computer program products for developing enterprise software applications
US7424154B2 (en) 2003-11-10 2008-09-09 Microsoft Corporation Boxed and lined input panel
US7650644B2 (en) 2003-11-25 2010-01-19 Sap Aktiengesellschaft Object-based access control
US7676785B2 (en) 2004-02-13 2010-03-09 Microsoft Corporation Hosted application as a designer in an integrated development environment
US7398562B2 (en) 2004-03-10 2008-07-15 Easy Rhino Designs, Inc. Article with 3-dimensional secondary element
US8468444B2 (en) 2004-03-17 2013-06-18 Targit A/S Hyper related OLAP
RU2280481C2 (ru) 2004-04-20 2006-07-27 Государственное образовательное учреждение высшего профессионального образования "Московский государственный институт стали и сплавов" (технологический университет) Аппарат магнитолазерной терапии
US7584502B2 (en) 2004-05-03 2009-09-01 Microsoft Corporation Policy engine and methods and systems for protecting data
US8352423B2 (en) 2004-05-07 2013-01-08 Inceptia Llc Apparatus and method for providing streaming data
US20050268215A1 (en) 2004-06-01 2005-12-01 Microsoft Corporation Method and apparatus for viewing and interacting with a spreadsheet from within a web browser
US7673340B1 (en) 2004-06-02 2010-03-02 Clickfox Llc System and method for analyzing system user behavior
US7788606B2 (en) 2004-06-14 2010-08-31 Sas Institute Inc. Computer-implemented system and method for defining graphics primitives
US7519223B2 (en) 2004-06-28 2009-04-14 Microsoft Corporation Recognizing gestures and using gestures for interacting with software applications
US20060013462A1 (en) * 2004-07-15 2006-01-19 Navid Sadikali Image display system and method
CN101300564A (zh) 2004-07-16 2008-11-05 科格洛斯公司 用于具有多维数据存储器的企业规划系统的电子表格用户接口
JP2006048110A (ja) 2004-07-30 2006-02-16 Casio Comput Co Ltd 演算制御装置及びプログラム
EP2000894B1 (en) 2004-07-30 2016-10-19 Apple Inc. Mode-based graphical user interfaces for touch sensitive input devices
US7761814B2 (en) 2004-09-13 2010-07-20 Microsoft Corporation Flick gesture
US7415481B2 (en) 2004-09-30 2008-08-19 Microsoft Corporation Method and implementation for referencing of dynamic data within spreadsheet formulas
US7698287B2 (en) 2004-09-30 2010-04-13 Microsoft Corporation Design of spreadsheet functions for working with tables of data
JP2007141190A (ja) 2004-12-09 2007-06-07 Ricoh Co Ltd 情報処理装置、情報処理方法、およびそのプログラム
US7849395B2 (en) 2004-12-15 2010-12-07 Microsoft Corporation Filter and sort by color
US8274534B2 (en) 2005-01-31 2012-09-25 Roland Wescott Montague Methods for combination tools that zoom, pan, rotate, draw, or manipulate during a drag
US7584414B2 (en) 2005-02-01 2009-09-01 Microsoft Corporation Export to excel
US7797320B2 (en) 2005-03-15 2010-09-14 Hyperion Solutions Corporation Dimensionality reduction
US8130193B2 (en) * 2005-03-31 2012-03-06 Microsoft Corporation System and method for eyes-free interaction with a computing device through environmental awareness
US7680823B2 (en) 2005-05-17 2010-03-16 International Business Machines Corporation Custom report generation
US7424668B2 (en) 2005-06-15 2008-09-09 Microsoft Corporation Pre-formulated spreadsheet cell groups
US9104773B2 (en) 2005-06-21 2015-08-11 Microsoft Technology Licensing, Llc Finding and consuming web subscriptions in a web browser
KR20070013739A (ko) 2005-07-27 2007-01-31 오재연 문서파일의 전송, 변환, 및 디스플레이 방법
CN1904879B (zh) 2005-07-27 2011-01-12 国际商业机器公司 电子表格系统及获取电子表格文档的快照/历史信息的方法
US20070061669A1 (en) 2005-08-30 2007-03-15 Major Karl L Method, device and system for detecting error correction defects
US7657571B2 (en) 2005-08-30 2010-02-02 Microsoft Corporation Electronic data snapshot generator
JP5466363B2 (ja) 2005-09-08 2014-04-09 味の素株式会社 卵白無添加の食肉単味品の製造法及び卵白無添加食肉単味品用のピックル
US7792847B2 (en) 2005-09-09 2010-09-07 Microsoft Corporation Converting structured reports to formulas
US8095866B2 (en) 2005-09-09 2012-01-10 Microsoft Corporation Filtering user interface for a data summary table
US7752536B2 (en) 2005-09-09 2010-07-06 Microsoft Corporation Designating, setting and discovering parameters for spreadsheet documents
US20110145689A1 (en) 2005-09-09 2011-06-16 Microsoft Corporation Named object view over multiple files
US20070061699A1 (en) 2005-09-09 2007-03-15 Microsoft Corporation Named object view of electronic data report
JP2009042796A (ja) 2005-11-25 2009-02-26 Panasonic Corp ジェスチャー入力装置および方法
US7730425B2 (en) * 2005-11-30 2010-06-01 De Los Reyes Isabelo Function-oriented user interface
US9501463B2 (en) 2005-12-08 2016-11-22 Microsoft Technology Licensing, Llc Spreadsheet cell-based notifications
US7908549B2 (en) 2005-12-08 2011-03-15 Microsoft Corporation Spreadsheet calculation as part of workflow
US20070136683A1 (en) 2005-12-14 2007-06-14 Alcatel Graphical user interface for generic listing of managed objects
US7587661B2 (en) 2006-01-19 2009-09-08 Microsoft Corporation Identifying design issues in electronic forms
US7667686B2 (en) * 2006-02-01 2010-02-23 Memsic, Inc. Air-writing and motion sensing input for portable devices
US7676763B2 (en) * 2006-02-21 2010-03-09 Sap Ag Method and system for providing an outwardly expandable radial menu
US7770100B2 (en) 2006-02-27 2010-08-03 Microsoft Corporation Dynamic thresholds for conditional formats
US8307119B2 (en) 2006-03-31 2012-11-06 Google Inc. Collaborative online spreadsheet application
EP2010999A4 (en) 2006-04-21 2012-11-21 Google Inc SYSTEM FOR ORGANIZING AND VISUALIZING DISPLAY OBJECTS
US8190650B2 (en) 2006-05-02 2012-05-29 Microsoft Corporation Efficiently filtering using a web site
CN102081645B (zh) 2006-05-10 2014-11-26 谷歌公司 Web笔记本工具
US9063647B2 (en) 2006-05-12 2015-06-23 Microsoft Technology Licensing, Llc Multi-touch uses, gestures, and implementation
TWI386817B (zh) 2006-05-24 2013-02-21 Kofax Inc 提供電腦軟體應用程式之使用者介面的系統及其方法
US20080016182A1 (en) 2006-07-11 2008-01-17 Nokia Corporation Dynamic device profile interfaces
JP4290717B2 (ja) 2006-08-29 2009-07-08 日本ユニシス株式会社 業務処理フロー図作成編集支援システムおよび支援プログラム
US7797621B1 (en) 2006-10-26 2010-09-14 Bank Of America Corporation Method and system for altering data during navigation between data cells
JP2008123199A (ja) 2006-11-10 2008-05-29 Nec Saitama Ltd 携帯電話機
US8468244B2 (en) 2007-01-05 2013-06-18 Digital Doors, Inc. Digital information infrastructure and method for security designated data and with granular data stores
US8321781B2 (en) 2007-02-08 2012-11-27 Microsoft Corporation User interface pane for an interactive chart
US8316105B2 (en) 2007-03-22 2012-11-20 Microsoft Corporation Architecture for installation and hosting of server-based single purpose applications on clients
US20080271127A1 (en) 2007-04-24 2008-10-30 Business Objects, S.A. Apparatus and method for creating stand-alone business intelligence widgets within an authentication framework
US8065603B2 (en) 2007-04-30 2011-11-22 Google Inc. Hiding portions of display content
US7702754B2 (en) 2007-05-23 2010-04-20 Sap Ag Enhanced widget architecture
US8392890B2 (en) 2007-10-15 2013-03-05 Software Research, Inc. Method and system for testing websites
US8578330B2 (en) 2007-06-11 2013-11-05 Sap Ag Enhanced widget composition platform
KR20090013551A (ko) 2007-08-02 2009-02-05 에스케이 텔레콤주식회사 제스쳐 인식 전자책 단말기 및 그 제어방법
US20100031167A1 (en) 2008-08-04 2010-02-04 Alexander Roytman Browser-based development tools and methods for developing the same
KR100934514B1 (ko) 2008-05-07 2009-12-29 엘지전자 주식회사 근접한 공간에서의 제스쳐를 이용한 사용자 인터페이스제어방법
US8332772B2 (en) 2007-10-12 2012-12-11 Business Objects Software Limited Providing structured visualizations of expressions in an expressions editor
JP2009110286A (ja) * 2007-10-30 2009-05-21 Toshiba Corp 情報処理装置、ランチャー起動制御プログラムおよびランチャー起動制御方法
US20090158190A1 (en) 2007-12-13 2009-06-18 Yuvee, Inc. Computing apparatus including a personal web and application assistant
TW200941262A (en) 2008-02-06 2009-10-01 Teo Inc Universal targeted blogging system
US8121975B2 (en) 2008-02-20 2012-02-21 Panorama Software Inc. Creating pivot tables from tabular data
US8174502B2 (en) 2008-03-04 2012-05-08 Apple Inc. Touch event processing for web pages
US20090254846A1 (en) 2008-04-02 2009-10-08 Microsoft Corporation Interactive host-aware advertising
US10180714B1 (en) * 2008-04-24 2019-01-15 Pixar Two-handed multi-stroke marking menus for multi-touch devices
US9841980B2 (en) 2008-04-25 2017-12-12 Microsoft Technology, LLC Extensible and application-adaptable toolbar for web services
US9165044B2 (en) 2008-05-30 2015-10-20 Ethority, Llc Enhanced user interface and data handling in business intelligence software
US20090307762A1 (en) 2008-06-05 2009-12-10 Chorus Llc System and method to create, save, and display web annotations that are selectively shared within specified online communities
US8612438B2 (en) 2008-06-13 2013-12-17 Microsoft Corporation Techniques for dynamic cross-filtering
US8826181B2 (en) * 2008-06-28 2014-09-02 Apple Inc. Moving radial menus
US8245156B2 (en) * 2008-06-28 2012-08-14 Apple Inc. Radial menu selection
US8539444B2 (en) 2008-06-30 2013-09-17 International Business Machines Corporation System and method for platform-independent, script-based application generation for spreadsheet software
JP5161690B2 (ja) * 2008-07-31 2013-03-13 キヤノン株式会社 情報処理装置及びその制御方法
US20100031152A1 (en) 2008-07-31 2010-02-04 Microsoft Corporation Creation and Navigation of Infinite Canvas Presentation
US8279174B2 (en) * 2008-08-27 2012-10-02 Lg Electronics Inc. Display device and method of controlling the display device
US9081471B2 (en) 2008-09-19 2015-07-14 Oracle International Corporation Providing modal window views for widgets on web pages
US8255789B2 (en) 2008-09-30 2012-08-28 Apple Inc. Providing spreadsheet features
US20100100854A1 (en) 2008-10-16 2010-04-22 Dell Products L.P. Gesture operation input system
US20100107067A1 (en) 2008-10-27 2010-04-29 Nokia Corporation Input on touch based user interfaces
CN101404009B (zh) 2008-10-31 2012-01-25 金蝶软件（中国）有限公司 一种数据分类过滤方法、系统及设备
US8719251B1 (en) 2008-11-14 2014-05-06 Kayak Software Corporation Sharing and collaboration of search results in a travel search engine
US20100131529A1 (en) 2008-11-26 2010-05-27 Vishal Kasera Open entity extraction system
US8351910B2 (en) 2008-12-02 2013-01-08 Qualcomm Incorporated Method and apparatus for determining a user input from inertial sensors
GB2478230B (en) 2008-12-15 2014-05-14 Hewlett Packard Development Co Gesture based edit mode
JP2010152801A (ja) 2008-12-26 2010-07-08 Fxcm Japan Inc 外国為替取引プログラム及び外国為替取引システム
US9383897B2 (en) * 2009-01-29 2016-07-05 International Business Machines Corporation Spiraling radial menus in computer systems
KR101617645B1 (ko) 2009-02-24 2016-05-04 삼성전자주식회사 디스플레이 제어 방법 및 이를 이용한 장치
US20100228752A1 (en) 2009-02-25 2010-09-09 Microsoft Corporation Multi-condition filtering of an interactive summary table
US20100229090A1 (en) * 2009-03-05 2010-09-09 Next Holdings Limited Systems and Methods for Interacting With Touch Displays Using Single-Touch and Multi-Touch Gestures
US8839155B2 (en) 2009-03-16 2014-09-16 Apple Inc. Accelerated scrolling for a multifunction device
US9053260B2 (en) 2009-04-13 2015-06-09 Honeywell International Inc. Utilizing spreadsheet user interfaces with flowsheets of a CPI simulation system
US8601389B2 (en) * 2009-04-30 2013-12-03 Apple Inc. Scrollable menus and toolbars
US8549432B2 (en) * 2009-05-29 2013-10-01 Apple Inc. Radial menus
US8281233B2 (en) 2009-06-15 2012-10-02 Microsoft Corporation Architecture to expose internal business data on a website
US8543946B2 (en) * 2009-06-29 2013-09-24 Sharp Laboratories Of America, Inc. Gesture-based interface system and method
US8990717B2 (en) 2009-08-12 2015-03-24 Apple Inc. Context-aware charting
US8624933B2 (en) 2009-09-25 2014-01-07 Apple Inc. Device, method, and graphical user interface for scrolling a multi-section document
US9275031B2 (en) 2009-10-09 2016-03-01 Microsoft Technology Licensing, Llc Data analysis expressions
CN102096582A (zh) 2009-12-11 2011-06-15 谷歌公司 离线小工具集成开发环境
US9465532B2 (en) * 2009-12-18 2016-10-11 Synaptics Incorporated Method and apparatus for operating in pointing and enhanced gesturing modes
US8786559B2 (en) 2010-01-06 2014-07-22 Apple Inc. Device, method, and graphical user interface for manipulating tables using multi-contact gestures
US8698845B2 (en) * 2010-01-06 2014-04-15 Apple Inc. Device, method, and graphical user interface with interactive popup views
US20110283176A1 (en) 2010-05-17 2011-11-17 SYNTES S.r.l. Method and device for processing and analyzing data on a personal computer
CN102939578A (zh) * 2010-06-01 2013-02-20 诺基亚公司 用于接收用户输入的方法、设备和系统
JP5528229B2 (ja) 2010-06-23 2014-06-25 キヤノン株式会社 文書生成装置、文書生成システム、文書アップロード方法及びプログラム
KR20120001336A (ko) 2010-06-29 2012-01-04 삼성전자주식회사 컨텐트 변환 방법 및 그 장치
CN101882108A (zh) 2010-06-30 2010-11-10 三一重机有限公司 嵌入式软件自动测试系统及其方法
US8825745B2 (en) 2010-07-11 2014-09-02 Microsoft Corporation URL-facilitated access to spreadsheet elements
US20120013539A1 (en) 2010-07-13 2012-01-19 Hogan Edward P A Systems with gesture-based editing of tables
US8773370B2 (en) * 2010-07-13 2014-07-08 Apple Inc. Table editing systems with gesture-based insertion and deletion of columns and rows
US8423909B2 (en) 2010-07-26 2013-04-16 International Business Machines Corporation System and method for an interactive filter
US20120030567A1 (en) 2010-07-28 2012-02-02 Victor B Michael System with contextual dashboard and dropboard features
US20120072820A1 (en) 2010-09-19 2012-03-22 Weinman Jr Joseph Bernard Systems and Computer Program Products for Conducting Multi-Window Multi-Aspect Processing and Calculations
US9003298B2 (en) 2010-09-21 2015-04-07 Microsoft Corporation Web page application controls
US9747270B2 (en) * 2011-01-07 2017-08-29 Microsoft Technology Licensing, Llc Natural input for spreadsheet actions
US8817053B2 (en) * 2010-09-30 2014-08-26 Apple Inc. Methods and systems for opening a file
US10048854B2 (en) 2011-01-31 2018-08-14 Oracle International Corporation Drag and drop interaction between components of a web application
US8924842B2 (en) 2011-02-25 2014-12-30 Hewlett-Packard Development Company, L.P. Method and system to build interactive documents
US8626477B2 (en) 2011-03-04 2014-01-07 Xldyn, Llc Spreadsheet-based graphical user interface for modeling of products using the systems engineering process
US8863019B2 (en) 2011-03-29 2014-10-14 International Business Machines Corporation Modifying numeric data presentation on a display
CA2830491C (en) 2011-03-31 2018-07-03 Smart Technologies Ulc Manipulating graphical objects in a multi-touch interactive system
US8533595B2 (en) 2011-04-19 2013-09-10 Autodesk, Inc Hierarchical display and navigation of document revision histories
JP5742506B2 (ja) 2011-06-27 2015-07-01 日本電気株式会社 文書類似度算出装置
US9330080B2 (en) 2011-06-27 2016-05-03 Sap Se Methods and systems to facilitate providing spreadsheet and database data to users via a social network
US8744821B2 (en) 2011-07-07 2014-06-03 Xldyn, Llc Spreadsheet-based templates for supporting the systems engineering process
US20130061122A1 (en) 2011-09-07 2013-03-07 Microsoft Corporation Multi-cell selection using touch input
US9411797B2 (en) 2011-10-31 2016-08-09 Microsoft Technology Licensing, Llc Slicer elements for filtering tabular data
US9053083B2 (en) 2011-11-04 2015-06-09 Microsoft Technology Licensing, Llc Interaction between web gadgets and spreadsheets
US9223761B2 (en) 2011-11-04 2015-12-29 Microsoft Technology Licensing, Llc Real time visual feedback during move, resize and/or rotate actions in an electronic document
US8640022B2 (en) 2011-12-08 2014-01-28 Microsoft Corporation Integration of spreadsheet objects on web page
US20130159832A1 (en) 2011-12-12 2013-06-20 Black Point Technologies Llc Systems and methods for trading using an embedded spreadsheet engine and user interface
US20130174025A1 (en) 2011-12-29 2013-07-04 Keng Fai Lee Visual comparison of document versions
US9171099B2 (en) 2012-01-26 2015-10-27 Microsoft Technology Licensing, Llc System and method for providing calculation web services for online documents
US8854433B1 (en) 2012-02-03 2014-10-07 Aquifi, Inc. Method and system enabling natural user interface gestures with an electronic system
US10289660B2 (en) 2012-02-15 2019-05-14 Apple Inc. Device, method, and graphical user interface for sharing a content object in a document
CN102637118B (zh) 2012-05-04 2015-11-25 珠海金山办公软件有限公司 插入或删除电子表格中单元格或行列的方法及其装置
US9652141B2 (en) 2012-05-29 2017-05-16 Blackberry Limited Portable electronic device including touch-sensitive display and method of controlling same
KR101974852B1 (ko) 2012-05-30 2019-05-03 삼성전자 주식회사 터치스크린을 가진 단말에서 오브젝트 이동 방법 및 장치
US9383913B2 (en) 2012-05-30 2016-07-05 Sap Se Touch screen device data filtering
US10209864B2 (en) 2012-06-19 2019-02-19 Microsoft Technology Licensing, Llc UI differentiation between delete and clear
US20140019842A1 (en) 2012-07-11 2014-01-16 Bank Of America Corporation Dynamic Pivot Table Creation and Modification
US20140033093A1 (en) 2012-07-25 2014-01-30 Microsoft Corporation Manipulating tables with touch gestures
US8868574B2 (en) 2012-07-30 2014-10-21 Box, Inc. System and method for advanced search and filtering mechanisms for enterprise administrators in a cloud-based environment
US20140194162A1 (en) 2013-01-04 2014-07-10 Apple Inc. Modifying A Selection Based on Tapping
US9317182B2 (en) 2013-04-11 2016-04-19 Apple Inc. Pop-up menu interface
US8943142B1 (en) 2013-05-22 2015-01-27 Google Inc. Non-collaborative filters in a collaborative document
US9672259B2 (en) 2013-05-29 2017-06-06 Ebay Inc. Methods and systems to refine search information
US20140372856A1 (en) 2013-06-14 2014-12-18 Microsoft Corporation Natural Quick Functions Gestures
US10664652B2 (en) 2013-06-15 2020-05-26 Microsoft Technology Licensing, Llc Seamless grid and canvas integration in a spreadsheet application
US20140372932A1 (en) 2013-06-15 2014-12-18 Microsoft Corporation Filtering Data with Slicer-Style Filtering User Interface

Patent Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1877505A (zh) * 2005-06-10 2006-12-13 鸿富锦精密工业（深圳）有限公司 数位信息阅读装置及其控制方法

Also Published As

Publication number Publication date
MX2013007905A (es) 2013-08-29
EP2661664A4 (en) 2018-01-17
JP2014501996A (ja) 2014-01-23
EP2661664B1 (en) 2020-10-14
WO2012094396A2 (en) 2012-07-12
AU2012204477A1 (en) 2013-08-01
CA2822066A1 (en) 2012-07-12
RU2013131022A (ru) 2015-01-10
KR20140001981A (ko) 2014-01-07
AU2012204477B2 (en) 2016-11-03
WO2012094396A3 (en) 2012-10-04
CN102629180A (zh) 2012-08-08
JP5984843B2 (ja) 2016-09-06
US20120180002A1 (en) 2012-07-12
CA2822066C (en) 2018-06-12
RU2604989C2 (ru) 2016-12-20
US9747270B2 (en) 2017-08-29
BR112013017396A2 (pt) 2016-10-04
KR101955433B1 (ko) 2019-03-08
US20170300222A1 (en) 2017-10-19
EP2661664A2 (en) 2013-11-13
MX343076B (es) 2016-10-24
US10732825B2 (en) 2020-08-04

Similar Documents

Publication Publication Date Title
CN102629180B (zh) 电子表格动作的自然输入
US11699031B2 (en) Natural quick function gestures
CN102207788B (zh) 使用边框手势的径向菜单
RU2413970C2 (ru) Системы, способы и машиночитаемый носитель данных для активации интерфейса с электронными чернилами или рукописным вводом
JP4890853B2 (ja) カーソルを用いて入力を制御する入力制御方法
CN102884498B (zh) 在计算设备上进行输入的方法
US20130191768A1 (en) Method for manipulating a graphical object and an interactive input system employing the same
CN102122230A (zh) 多手指手势
CN102754050A (zh) 屏幕上和屏幕外手势组合
CN102122229A (zh) 使用边框作为输入机制
CN102207818A (zh) 使用屏幕上和屏幕外手势的页面操纵
TW201337714A (zh) 電子裝置及控制電子裝置的方法
CN104137044A (zh) 用触摸上下文用户界面来进行显示和交互
CN103425426A (zh) 处理与多触摸相对应的功能的方法和电子设备
CN108182032A (zh) 用于对值进行就地编辑的用户界面
US20130246975A1 (en) Gesture group selection
US9753633B2 (en) Information processing apparatus and method for arranging elements on a display region
CN102520838A (zh) 擦拭触摸信息提示
US20140232667A1 (en) Electronic device and method

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
ASS Succession or assignment of patent right

Owner name: MICROSOFT TECHNOLOGY LICENSING LLC

Free format text: FORMER OWNER: MICROSOFT CORP.

Effective date: 20150722

C41 Transfer of patent application or patent right or utility model
TA01 Transfer of patent application right

Effective date of registration: 20150722

Address after: Washington State

Applicant after: Micro soft technique license Co., Ltd

Address before: Washington State

Applicant before: Microsoft Corp.

C14 Grant of patent or utility model
GR01 Patent grant