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

始终拖放的求和公式 Download PDF

Info

Publication number
CN102945227A
CN102945227A CN2012104090690A CN201210409069A CN102945227A CN 102945227 A CN102945227 A CN 102945227A CN 2012104090690 A CN2012104090690 A CN 2012104090690A CN 201210409069 A CN201210409069 A CN 201210409069A CN 102945227 A CN102945227 A CN 102945227A
Authority
CN
China
Prior art keywords
user interface
computer
status bar
predetermined calculation
formula
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
CN2012104090690A
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 Corp
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 Corp filed Critical Microsoft Corp
Priority to CN201710894652.8A priority Critical patent/CN107656675A/zh
Publication of CN102945227A publication Critical patent/CN102945227A/zh
Pending legal-status Critical Current

Links

Images

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)
CN2012104090690A 2011-10-25 2012-10-24 始终拖放的求和公式 Pending CN102945227A (zh)

Priority Applications (1)

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

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US13/280,754 2011-10-25
US13/280,754 US9588953B2 (en) 2011-10-25 2011-10-25 Drag and drop always sum formulas

Related Child Applications (1)

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

Publications (1)

Publication Number Publication Date
CN102945227A true CN102945227A (zh) 2013-02-27

Family

ID=47728174

Family Applications (2)

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

Family Applications After (1)

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

Country Status (7)

Country Link
US (2) US9588953B2 (enExample)
EP (2) EP2771774B1 (enExample)
JP (1) JP6038166B2 (enExample)
KR (2) KR102083136B1 (enExample)
CN (2) CN102945227A (enExample)
HK (1) HK1248330A1 (enExample)
WO (1) WO2013063040A1 (enExample)

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105378705A (zh) * 2013-06-14 2016-03-02 微软技术许可有限责任公司 智能选择引擎
CN108292295A (zh) * 2016-02-01 2018-07-17 微软技术许可有限责任公司 在电子表格应用中对数学方程式进行参数化和处理
US11093704B2 (en) 2015-11-02 2021-08-17 Microsoft Technology Licensing, Llc Rich data types

Families Citing this family (13)

* 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
US9256590B2 (en) * 2013-12-17 2016-02-09 Microsoft Technology Licensing, Llc Formula and function generation and use in electronic spreadsheets
KR101999576B1 (ko) * 2018-02-22 2019-07-12 주식회사 한글과컴퓨터 선택된 셀 영역에 대한 빠른 함수 연산의 수행이 가능한 스프레드시트 구동 장치 및 그 동작 방법
US11023669B2 (en) * 2018-06-29 2021-06-01 Microsoft Technology Licensing, Llc Rendering lambda functions in spreadsheet applications
US11423116B2 (en) 2018-06-29 2022-08-23 Microsoft Technology Licensing, Llc Automatically creating 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
EP0965932A2 (en) * 1998-06-17 1999-12-22 Xerox Corporation Speadsheet view enhancement system
US6055548A (en) * 1996-06-03 2000-04-25 Microsoft Corporation Computerized spreadsheet with auto-calculator
WO2005043406A2 (en) * 2003-11-03 2005-05-12 Epista Software A/S An electronic mathematical model builder
CN1790240A (zh) * 2004-12-15 2006-06-21 国际商业机器公司 用于指针拖拽路径操作的设备和方法
US20090044089A1 (en) * 2007-08-06 2009-02-12 Apple Inc. Automatic insertion of a default function

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
AU5273100A (en) * 1999-05-17 2000-12-05 Foxboro Company, The Methods and apparatus for control configuration with versioning, security, composite blocks, edit selection, object swapping, formulaic values and other aspects
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
WO2003014987A2 (en) * 2001-08-09 2003-02-20 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
US7073711B2 (en) * 2002-04-19 2006-07-11 Cross Match Technologies, Inc. Mobile handheld code reader and print scanner system and method
JP2004046657A (ja) 2002-07-15 2004-02-12 Answer:Kk 計算支援方法とその装置、及び計算支援ソフト
JP2004118727A (ja) * 2002-09-27 2004-04-15 Casio Comput Co Ltd 図形表示制御装置及びプログラム
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
US9135021B2 (en) * 2003-06-30 2015-09-15 International Business Machines Corporation Method and system for input and output of data with non-standard I/O devices for web applications
US20050188174A1 (en) * 2003-10-12 2005-08-25 Microsoft Corporation Extensible creation and editing of collections of objects
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
US20100004972A1 (en) * 2004-12-15 2010-01-07 Sap Aktiengesellschaft Resource Management
US7451397B2 (en) * 2004-12-15 2008-11-11 Microsoft Corporation System and method for automatically completing spreadsheet formulas
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
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
US8487153B2 (en) * 2009-07-01 2013-07-16 Phillips 66 Company 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
EP2872981A4 (en) 2012-07-13 2016-10-19 Samsung Electronics Co Ltd METHOD FOR SENDING AND RECEIVING DATA BETWEEN A MEMO LAYER AND APPLICATION AND ELECTRONIC DEVICE THEREFOR
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
EP0965932A2 (en) * 1998-06-17 1999-12-22 Xerox Corporation Speadsheet view enhancement system
WO2005043406A2 (en) * 2003-11-03 2005-05-12 Epista Software A/S An electronic mathematical model builder
CN1790240A (zh) * 2004-12-15 2006-06-21 国际商业机器公司 用于指针拖拽路径操作的设备和方法
US20090044089A1 (en) * 2007-08-06 2009-02-12 Apple Inc. Automatic insertion of a default function

Cited By (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105378705A (zh) * 2013-06-14 2016-03-02 微软技术许可有限责任公司 智能选择引擎
US10198423B2 (en) 2013-06-14 2019-02-05 Microsoft Technolgy Licensing, LLC Suggesting a set of operations applicable to a selected range of data in a spreadsheet
US11093704B2 (en) 2015-11-02 2021-08-17 Microsoft Technology Licensing, Llc Rich data types
US11630947B2 (en) 2015-11-02 2023-04-18 Microsoft Technology Licensing, Llc Compound data objects
CN108292295A (zh) * 2016-02-01 2018-07-17 微软技术许可有限责任公司 在电子表格应用中对数学方程式进行参数化和处理
CN108292295B (zh) * 2016-02-01 2022-09-30 微软技术许可有限责任公司 在电子表格应用中对数学方程式进行参数化和处理

Also Published As

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

Similar Documents

Publication Publication Date Title
CN102945227A (zh) 始终拖放的求和公式
JP6763899B2 (ja) ウェブ・アプリケーションにおける連携通信
KR102325237B1 (ko) 선택가능 컨트롤 및 명령을 디스플레이하고 스케일링하는 명령 사용자 인터페이스
US9032292B2 (en) Simultaneous display of multiple maximized applications on touch screen electronic devices
CN104471566B (zh) 与作为应用的文档交互
CN104471520B (zh) 用于提供用于呈现应用功能的用户界面的方法和系统
CN103412703A (zh) 利用功能区来访问应用用户界面
CN105830056B (zh) 与表格应用函数记号交互
CN105531695A (zh) 电子文档中简化的数据输入
US20090235253A1 (en) Smart task list/life event annotator
TW201541333A (zh) 滑動表面
TW201519067A (zh) 自電子文件中的資料產生視覺化
US20150135054A1 (en) Comments on Named Objects
US11329941B2 (en) Automated display state of electronic mail items
CN109313589A (zh) 实现与外部功能的交互
CN105359081A (zh) 包括递增、直接输入和可滚动控件的内容属性控制界面
KR20160090302A (ko) 작성 애플리케이션 확장판 활성화 기법
KR101435577B1 (ko) 스마트 패드를 이용한 그림일기 관리 시스템 및 방법
HK1178646A (en) Drag and drop always sum formulas

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into 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: 1178646

Country of ref document: HK

ASS Succession or assignment of patent right

Owner name: MICROSOFT TECHNOLOGY LICENSING LLC

Free format text: FORMER OWNER: MICROSOFT CORP.

Effective date: 20150727

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

Effective date of registration: 20150727

Address after: Washington State

Applicant after: Micro soft technique license Co., Ltd

Address before: Washington State

Applicant before: Microsoft Corp.

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

Application publication date: 20130227