CN107656675A - 始终拖放的求和公式 - Google Patents

始终拖放的求和公式 Download PDF

Info

Publication number
CN107656675A
CN107656675A CN201710894652.8A CN201710894652A CN107656675A CN 107656675 A CN107656675 A CN 107656675A CN 201710894652 A CN201710894652 A CN 201710894652A CN 107656675 A CN107656675 A CN 107656675A
Authority
CN
China
Prior art keywords
user interface
computer
status bar
predetermined
content surface
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.)
Pending
Application number
CN201710894652.8A
Other languages
English (en)
Chinese (zh)
Inventor
E·W·帕特森
K·X·程
B·E·兰帕森
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 CN107656675A publication Critical patent/CN107656675A/zh
Pending legal-status Critical Current

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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/0486—Drag-and-drop
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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/0481—Interaction techniques based on graphical user interfaces [GUI] based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
    • G06F3/04817—Interaction techniques based on graphical user interfaces [GUI] based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance using icons
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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/0481—Interaction techniques based on graphical user interfaces [GUI] based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
    • G06F3/0482—Interaction with lists of selectable items, e.g. menus
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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

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)
CN201710894652.8A 2011-10-25 2012-10-24 始终拖放的求和公式 Pending CN107656675A (zh)

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
US13/280,754 US9588953B2 (en) 2011-10-25 2011-10-25 Drag and drop always sum formulas
US13/280,754 2011-10-25
CN2012104090690A CN102945227A (zh) 2011-10-25 2012-10-24 始终拖放的求和公式

Related Parent Applications (1)

Application Number Title Priority Date Filing Date
CN2012104090690A Division CN102945227A (zh) 2011-10-25 2012-10-24 始终拖放的求和公式

Publications (1)

Publication Number Publication Date
CN107656675A true CN107656675A (zh) 2018-02-02

Family

ID=47728174

Family Applications (2)

Application Number Title Priority Date Filing Date
CN201710894652.8A Pending CN107656675A (zh) 2011-10-25 2012-10-24 始终拖放的求和公式
CN2012104090690A Pending CN102945227A (zh) 2011-10-25 2012-10-24 始终拖放的求和公式

Family Applications After (1)

Application Number Title Priority Date Filing Date
CN2012104090690A Pending CN102945227A (zh) 2011-10-25 2012-10-24 始终拖放的求和公式

Country Status (7)

Country Link
US (2) US9588953B2 (enExample)
EP (2) EP3660644A1 (enExample)
JP (1) JP6038166B2 (enExample)
KR (2) KR101978007B1 (enExample)
CN (2) CN107656675A (enExample)
HK (1) HK1248330A1 (enExample)
WO (1) WO2013063040A1 (enExample)

Families Citing this family (16)

* 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 珠海金山办公软件有限公司 一种在手持触摸设备上控制电子表格的方法
US10078430B2 (en) * 2013-03-14 2018-09-18 Vmware, Inc. Providing batch operations with an auxiliary user interface
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
US9256590B2 (en) * 2013-12-17 2016-02-09 Microsoft Technology Licensing, Llc Formula and function generation and use in electronic spreadsheets
US10599764B2 (en) 2015-11-02 2020-03-24 Microsoft Technology Licensing, Llc Operations on images associated with cells in spreadsheets
CN108292295B (zh) * 2016-02-01 2022-09-30 微软技术许可有限责任公司 在电子表格应用中对数学方程式进行参数化和处理
KR101999576B1 (ko) * 2018-02-22 2019-07-12 주식회사 한글과컴퓨터 선택된 셀 영역에 대한 빠른 함수 연산의 수행이 가능한 스프레드시트 구동 장치 및 그 동작 방법
US11423116B2 (en) 2018-06-29 2022-08-23 Microsoft Technology Licensing, Llc Automatically creating lambda functions in spreadsheet applications
US11023669B2 (en) * 2018-06-29 2021-06-01 Microsoft Technology Licensing, Llc Rendering lambda functions in spreadsheet applications
CN111159988B (zh) * 2019-12-31 2023-09-08 软通动力信息技术(集团)股份有限公司 一种模型处理方法、装置、计算机设备及存储介质
GB202002163D0 (en) * 2020-02-17 2020-04-01 Microsoft Technology Licensing Llc Spreadsheet with reuse functionality
KR102743105B1 (ko) * 2022-04-21 2024-12-16 주식회사 한글과컴퓨터 스프레드시트에서 사용자에 의해 선택된 셀에 대한 자동 연산 기능을 제공하는 전자 단말 장치 및 그 동작 방법
KR102886742B1 (ko) * 2022-09-16 2025-11-14 주식회사 한글과컴퓨터 데이터의 통화 표기 형식을 자동 변환하여 붙여넣기 할 수 있는 전자 단말 장치 및 그 동작 방법
JP2024078737A (ja) * 2022-11-30 2024-06-11 株式会社島津製作所 分析装置

Citations (6)

* 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
US6055548A (en) * 1996-06-03 2000-04-25 Microsoft Corporation Computerized spreadsheet with auto-calculator
US20040016811A1 (en) * 2002-04-19 2004-01-29 Cross Match Technologies, Inc. Mobile handheld code reader and print scanner system and method
CN1578299A (zh) * 2003-06-30 2005-02-09 国际商业机器公司 为Web应用输入和输出数据的方法和系统
CN1695107A (zh) * 2002-09-27 2005-11-09 卡西欧计算机株式会社 用于显示图表和图形的图形显示控制装置以及记录介质
EP0965932A3 (en) * 1998-06-17 2006-01-04 Xerox Corporation Speadsheet view enhancement system

Family Cites Families (64)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH0738204B2 (ja) * 1987-12-23 1995-04-26 インターナシヨナル・ビジネス・マシーンズ・コーポレーシヨン 計算処理方法
US5848187A (en) 1991-11-18 1998-12-08 Compaq Computer Corporation Method and apparatus for entering and manipulating spreadsheet cell data
US5588105A (en) * 1992-11-16 1996-12-24 Apple Computer, Inc. Status bar for application windows
US5603021A (en) * 1994-09-02 1997-02-11 Borland International, Inc. Methods for composing formulas in an electronic spreadsheet system
WO1996009579A1 (en) 1994-09-22 1996-03-28 Izak Van Cruyningen Popup menus with directional gestures
AU712491B2 (en) 1995-04-07 1999-11-11 Sony Electronics Inc. Method and apparatus for improved graphical user interface with function icons
GB2301758A (en) 1995-06-03 1996-12-11 Ibm Icon driven data processing system
US6157935A (en) * 1996-12-17 2000-12-05 Tran; Bao Q. Remote data access and management system
US6385662B1 (en) * 1997-10-03 2002-05-07 Ericsson Inc. Method of processing information using a personal communication assistant
US6256649B1 (en) * 1998-06-17 2001-07-03 Xerox Corporation Animated spreadsheet for dynamic display of constraint graphs
AU5025600A (en) * 1999-05-17 2000-12-05 Foxboro Company, The Process control configuration system with parameterized objects
JP2001173263A (ja) 1999-12-16 2001-06-26 Zenitaka Corp タンクの建設工法
US7117435B1 (en) * 2000-06-21 2006-10-03 Microsoft Corporation Spreadsheet fields in text
CA2403300A1 (en) * 2002-09-12 2004-03-12 Pranil Ram A method of buying or selling items and a user interface to facilitate the same
US6868526B2 (en) * 2001-07-18 2005-03-15 The Mathworks, Inc. Graphical subclassing
EP1456786A2 (en) * 2001-08-09 2004-09-15 International Business Machines Corporation Spreadsheet system and method for transferring the content of input cells between scalable template instances
US20030074647A1 (en) 2001-10-12 2003-04-17 Andrew Felix G.T.I. Automatic software input panel selection based on application program state
US20030112277A1 (en) 2001-12-14 2003-06-19 Koninklijke Philips Electronics N.V. Input of data using a combination of data input systems
JP2004046657A (ja) 2002-07-15 2004-02-12 Answer:Kk 計算支援方法とその装置、及び計算支援ソフト
US7634729B2 (en) 2002-11-10 2009-12-15 Microsoft Corporation Handwritten file names
US7266763B2 (en) * 2002-11-26 2007-09-04 Microsoft Corporation User defined spreadsheet functions
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
US20050188174A1 (en) * 2003-10-12 2005-08-25 Microsoft Corporation Extensible creation and editing of collections of objects
DE602004019242D1 (de) 2003-11-03 2009-03-12 Epista Software As Elektronischer mathematischer modellbauer
US7506271B2 (en) 2003-12-15 2009-03-17 Microsoft Corporation Multi-modal handwriting recognition correction
US8117542B2 (en) 2004-08-16 2012-02-14 Microsoft Corporation User interface for displaying selectable software functionality controls that are contextually relevant to a selected object
US7634730B2 (en) * 2004-12-15 2009-12-15 Microsoft Corporation Task helpers
US20060129945A1 (en) 2004-12-15 2006-06-15 International Business Machines Corporation Apparatus and method for pointer drag path operations
US7451397B2 (en) * 2004-12-15 2008-11-11 Microsoft Corporation System and method for automatically completing spreadsheet formulas
US20100004972A1 (en) * 2004-12-15 2010-01-07 Sap Aktiengesellschaft Resource Management
US20060132812A1 (en) 2004-12-17 2006-06-22 You Software, Inc. Automated wysiwyg previewing of font, kerning and size options for user-selected text
US20060188267A1 (en) * 2005-02-23 2006-08-24 Pavle Gavrilovic System and method for suppression of stimulated Brillouin scattering in optical transmission communications
JP2006277727A (ja) * 2005-03-04 2006-10-12 Canon Inc レイアウト処理方法、情報処理装置及びコンピュータプログラム
US7561145B2 (en) 2005-03-18 2009-07-14 Microsoft Corporation Systems, methods, and computer-readable media for invoking an electronic ink or handwriting interface
US20060282818A1 (en) * 2005-06-14 2006-12-14 Microsoft Corporation Interactive formula builder
US7424668B2 (en) * 2005-06-15 2008-09-09 Microsoft Corporation Pre-formulated spreadsheet cell groups
US7752536B2 (en) 2005-09-09 2010-07-06 Microsoft Corporation Designating, setting and discovering parameters for spreadsheet documents
US8307119B2 (en) 2006-03-31 2012-11-06 Google Inc. Collaborative online spreadsheet application
US20080168341A1 (en) * 2007-01-10 2008-07-10 Raymond Payette Digital spreadsheet formula automation
US20090006939A1 (en) 2007-06-29 2009-01-01 Microsoft Corporation Task-specific spreadsheet worksheets
US20090044089A1 (en) 2007-08-06 2009-02-12 Apple Inc. Automatic insertion of a default function
US20100049723A1 (en) * 2008-08-21 2010-02-25 Russell Aebig Spreadsheet risk reconnaissance network for automatically detecting risk conditions in spreadsheet documents within an organization using principles of objective-relative risk analysis
US8166385B2 (en) 2008-08-27 2012-04-24 The Board Of Trustees Of The Leland Stanford Junior University Spreadsheet system and method for managing photos
US8255789B2 (en) 2008-09-30 2012-08-28 Apple Inc. Providing spreadsheet features
US8321802B2 (en) 2008-11-13 2012-11-27 Qualcomm Incorporated Method and system for context dependent pop-up menus
WO2011003044A1 (en) * 2009-07-01 2011-01-06 Conocophillips Company - Ip Services Group Selective olefin dimerization with supported metal complexes activated by alkylaluminum compounds or ionic liquids
US9256219B2 (en) * 2009-08-11 2016-02-09 Fisher-Rosemount Systems, Inc. System configuration using templates
US8436821B1 (en) 2009-11-20 2013-05-07 Adobe Systems Incorporated System and method for developing and classifying touch gestures
US8773370B2 (en) 2010-07-13 2014-07-08 Apple Inc. Table editing systems with gesture-based insertion and deletion of columns and rows
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
US9747270B2 (en) 2011-01-07 2017-08-29 Microsoft Technology Licensing, Llc Natural input for spreadsheet actions
US8405627B2 (en) 2010-12-07 2013-03-26 Sony Mobile Communications Ab Touch input disambiguation
JP5267546B2 (ja) 2010-12-22 2013-08-21 カシオ計算機株式会社 手書き数式認識機能を備えた電子計算機およびプログラム
JP5650564B2 (ja) 2011-03-01 2015-01-07 株式会社ユビキタスエンターテインメント スプレッドシート制御プログラム、スプレッドシート制御装置及びスプレッドシートの制御方法
US8619090B2 (en) * 2011-09-23 2013-12-31 The Mathworks, Inc. Text import tool for a technical computing environment
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
CN102566901A (zh) 2011-11-18 2012-07-11 珠海金山办公软件有限公司 一种在手持触摸设备上控制电子表格的方法
US20130145244A1 (en) 2011-12-05 2013-06-06 Microsoft Corporation Quick analysis tool for spreadsheet application programs
WO2014010998A1 (en) 2012-07-13 2014-01-16 Samsung Electronics Co., Ltd. Method for transmitting and receiving data between memo layer and application and electronic device using the same
US20140033110A1 (en) 2012-07-26 2014-01-30 Texas Instruments Incorporated Accessing Secondary Functions on Soft Keyboards Using Gestures
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
KR20140134018A (ko) 2013-05-13 2014-11-21 삼성전자주식회사 화면상에서 사용자 입력과 관련된 기능을 실행하기 위한 장치, 방법 및 컴퓨터 판독 가능한 기록 매체
US10360297B2 (en) 2013-06-14 2019-07-23 Microsoft Technology Licensing, Llc Simplified data input in electronic documents

Patent Citations (6)

* 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
US6055548A (en) * 1996-06-03 2000-04-25 Microsoft Corporation Computerized spreadsheet with auto-calculator
EP0965932A3 (en) * 1998-06-17 2006-01-04 Xerox Corporation Speadsheet view enhancement system
US20040016811A1 (en) * 2002-04-19 2004-01-29 Cross Match Technologies, Inc. Mobile handheld code reader and print scanner system and method
CN1695107A (zh) * 2002-09-27 2005-11-09 卡西欧计算机株式会社 用于显示图表和图形的图形显示控制装置以及记录介质
CN1578299A (zh) * 2003-06-30 2005-02-09 国际商业机器公司 为Web应用输入和输出数据的方法和系统

Also Published As

Publication number Publication date
KR101978007B1 (ko) 2019-05-13
US20170242563A1 (en) 2017-08-24
HK1248330A1 (zh) 2018-10-12
JP6038166B2 (ja) 2016-12-07
US10394440B2 (en) 2019-08-27
CN102945227A (zh) 2013-02-27
KR20140084069A (ko) 2014-07-04
KR20190053279A (ko) 2019-05-17
WO2013063040A1 (en) 2013-05-02
EP2771774A1 (en) 2014-09-03
US9588953B2 (en) 2017-03-07
JP2014531101A (ja) 2014-11-20
US20130104020A1 (en) 2013-04-25
EP2771774B1 (en) 2019-12-25
EP2771774A4 (en) 2015-09-02
KR102083136B1 (ko) 2020-02-28
EP3660644A1 (en) 2020-06-03

Similar Documents

Publication Publication Date Title
CN107656675A (zh) 始终拖放的求和公式
KR102325237B1 (ko) 선택가능 컨트롤 및 명령을 디스플레이하고 스케일링하는 명령 사용자 인터페이스
CN104094251B (zh) Web应用中的协作通信
CN102929917B (zh) 动态内容馈源过滤
CN104471566B (zh) 与作为应用的文档交互
US20170052686A1 (en) Pinning a callout animation
CN105431807A (zh) 在导航日历的同时显示生活事件
CN105493481A (zh) 自动改变图形用户界面的显示
CN106164891A (zh) 幻灯片展示表面
CN105917326A (zh) 从电子文档中的文本数据创建信息图
CN106030572B (zh) 与外部内容项的经编码的关联
CN105339960A (zh) 创建重复约会
KR102267925B1 (ko) 작성 애플리케이션 확장판 활성화 기법
HK1178646A (en) Drag and drop always sum formulas
CN105359134A (zh) 将别名用于日期输入

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
REG Reference to a national code

Ref country code: HK

Ref legal event code: DE

Ref document number: 1248330

Country of ref document: HK

RJ01 Rejection of invention patent application after publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20180202

REG Reference to a national code

Ref country code: HK

Ref legal event code: WD

Ref document number: 1248330

Country of ref document: HK