CN100424684C - 在电子表格中隐藏列的计算机实现方法及系统 - Google Patents

在电子表格中隐藏列的计算机实现方法及系统 Download PDF

Info

Publication number
CN100424684C
CN100424684C CNB2006100918610A CN200610091861A CN100424684C CN 100424684 C CN100424684 C CN 100424684C CN B2006100918610 A CNB2006100918610 A CN B2006100918610A CN 200610091861 A CN200610091861 A CN 200610091861A CN 100424684 C CN100424684 C CN 100424684C
Authority
CN
China
Prior art keywords
column
spreadsheet
hidden
graphical
window
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.)
Expired - Fee Related
Application number
CNB2006100918610A
Other languages
English (en)
Chinese (zh)
Other versions
CN1908929A (zh
Inventor
K·D·肯纳
R·C·利亚
J·H·弗雷利
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.)
Google LLC
Original Assignee
International Business Machines 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 International Business Machines Corp filed Critical International Business Machines Corp
Publication of CN1908929A publication Critical patent/CN1908929A/zh
Application granted granted Critical
Publication of CN100424684C publication Critical patent/CN100424684C/zh
Expired - Fee Related legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • 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
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/103—Formatting, i.e. changing of presentation of documents
    • 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

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Health & Medical Sciences (AREA)
  • Computational Linguistics (AREA)
  • General Health & Medical Sciences (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Artificial Intelligence (AREA)
  • User Interface Of Digital Computer (AREA)
  • Digital Computer Display Output (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
CNB2006100918610A 2005-08-03 2006-06-13 在电子表格中隐藏列的计算机实现方法及系统 Expired - Fee Related CN100424684C (zh)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US11/196,108 US7788584B2 (en) 2005-08-03 2005-08-03 Computer-implemented method, system, and program product for hiding columns in an electronic table
US11/196,108 2005-08-03

Publications (2)

Publication Number Publication Date
CN1908929A CN1908929A (zh) 2007-02-07
CN100424684C true CN100424684C (zh) 2008-10-08

Family

ID=37700040

Family Applications (1)

Application Number Title Priority Date Filing Date
CNB2006100918610A Expired - Fee Related CN100424684C (zh) 2005-08-03 2006-06-13 在电子表格中隐藏列的计算机实现方法及系统

Country Status (3)

Country Link
US (1) US7788584B2 (enExample)
JP (1) JP4868580B2 (enExample)
CN (1) CN100424684C (enExample)

Families Citing this family (27)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20110289398A1 (en) * 2004-11-26 2011-11-24 Philip King Chin Method of displaying data in a table with a fixed header
AU2007222137A1 (en) * 2006-03-09 2007-09-13 Ringler Informatik Ag Method for creating tables in electronic forms
US8065603B2 (en) * 2007-04-30 2011-11-22 Google Inc. Hiding portions of display content
US8302028B2 (en) * 2008-09-18 2012-10-30 International Business Machines Corporation Expandable area for host table data display in a mobile device
CA2680977C (en) * 2008-10-06 2018-08-07 Accenture Global Services Gmbh Tariff management configuration automation
US9183248B2 (en) * 2009-06-09 2015-11-10 Oracle International Corporation Configuring object displays
US20110219321A1 (en) * 2010-03-02 2011-09-08 Microsoft Corporation Web-based control using integrated control interface having dynamic hit zones
US8694911B2 (en) 2011-11-28 2014-04-08 International Business Machines Corporation Manipulating hidden data entries via representative markers
US9449406B2 (en) * 2012-11-19 2016-09-20 Hewlett Packard Enterprise Development Lp Manipulating timelines
CN102799575B (zh) * 2012-06-29 2015-10-14 杭州迪普科技有限公司 一种表格处理方法及装置
TWI630570B (zh) * 2012-09-12 2018-07-21 三竹資訊股份有限公司 金融商品報價視圖股號欄位展開與隱藏之裝置與方法
US9286285B1 (en) 2012-10-30 2016-03-15 Google Inc. Formula editor
US10372808B1 (en) 2012-12-12 2019-08-06 Google Llc Passing functional spreadsheet data by reference
US20140189559A1 (en) * 2012-12-27 2014-07-03 International Business Machines Corporation Control for rapidly exploring relationships in densely connected networks
CN104239024B (zh) * 2013-06-20 2017-07-18 深圳市华傲数据技术有限公司 一种表格数据获取方法和装置
US9311289B1 (en) 2013-08-16 2016-04-12 Google Inc. Spreadsheet document tab conditional formatting
CN103714127A (zh) * 2013-12-11 2014-04-09 金蝶软件（中国）有限公司 表格分信息组展示方法和系统
US9959265B1 (en) 2014-05-08 2018-05-01 Google Llc Populating values in a spreadsheet using semantic cues
US9710511B2 (en) 2015-05-14 2017-07-18 Walleye Software, LLC Dynamic table index mapping
USD821421S1 (en) * 2016-03-01 2018-06-26 Bobst Mex Sa Computer screen display or portion thereof with graphical user interface
CN107818000B (zh) * 2016-08-31 2021-04-16 北京国双科技有限公司 一种页面表格的操作方法及装置
US10002154B1 (en) 2017-08-24 2018-06-19 Illumon Llc Computer data system data source having an update propagation graph with feedback cyclicality
CN112989776A (zh) * 2021-03-03 2021-06-18 远光软件股份有限公司 调整表格列的方法、装置、存储介质及终端设备
US12360983B2 (en) 2021-11-11 2025-07-15 Sigma Computing, Inc. Live editing editable tables
US12481671B2 (en) 2021-11-11 2025-11-25 Sigma Computing, Inc. Editing data-warehouse tables using managed input tables
US12197458B1 (en) 2021-11-11 2025-01-14 Sigma Computing, Inc. Generating edited input tables for low-latency presentation
CN116126191A (zh) * 2023-02-02 2023-05-16 珠海金山办公软件有限公司 数据载体处理方法及装置

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5950168A (en) * 1996-12-18 1999-09-07 Knowmed Systems Collapsible flowsheet for displaying patient information in an electronic medical record
US6313848B1 (en) * 1999-01-06 2001-11-06 Avaya Technology Corp. Folded tables: a method of viewing wide tables with reduced need for horizontal scrolling
US20050050092A1 (en) * 2003-08-25 2005-03-03 Oracle International Corporation Direct loading of semistructured data

Family Cites Families (22)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
DE69031149T2 (de) * 1989-05-31 1998-01-15 Microsoft Corp Verfahren zum Verstecken oder Sichtbarmachen von Zellen in einem elektronischen Kalkulationsblatt
US5809317A (en) * 1992-12-30 1998-09-15 Intel Corporation Creating and maintaining hypertext links among heterogeneous documents by the establishment of anchors and connections among anchors
JPH06274513A (ja) * 1993-03-19 1994-09-30 Fuji Xerox Co Ltd 階層表計算装置
JP3388655B2 (ja) * 1995-07-28 2003-03-24 シャープ株式会社 データ処理装置
US5706449A (en) 1995-09-18 1998-01-06 International Business Machines Corporation Method and system for providing improved specification of multiple sort criteria in a graphical user interface
JPH09204423A (ja) * 1996-01-29 1997-08-05 Nec Corp 表データ処理装置
US6055550A (en) * 1996-03-21 2000-04-25 Oracle Corporation Auto sizing of fields for displaying computer forms
US6317758B1 (en) * 1998-02-20 2001-11-13 Corel Corporation Method and system for detecting and selectively correcting cell reference errors
US6205453B1 (en) 1998-03-13 2001-03-20 Oracle Corporation System and method for implementing selectively index enabled multi-column lists in a computer system
AU5448500A (en) 1999-05-26 2000-12-28 Alok Batra Network element management system
US6437812B1 (en) * 1999-06-30 2002-08-20 Cerebrus Solutions Limited Graphical user interface and method for displaying hierarchically structured information
US6711715B1 (en) * 1999-08-27 2004-03-23 Microsoft Corporation Method and system for efficient storage and restoration of display state data
US6889359B1 (en) * 1999-10-07 2005-05-03 International Business Machines Corporation Method for providing a visual representation of dynamic HTML table attributes
WO2002045321A2 (en) 2000-11-29 2002-06-06 Unilogic, Inc. A collaborative, fault-tolerant, scaleable, flexible, interactive real-time display and processing method and apparatus
US20020143809A1 (en) * 2001-03-28 2002-10-03 Bennett Paul W. System and method for calculation using multi-field columns with hidden fields
US7275207B2 (en) * 2002-03-28 2007-09-25 International Business Machines Corporation System and method in an electronic spreadsheet for displaying and/or hiding range of cells
US7546523B2 (en) * 2002-03-28 2009-06-09 International Business Machines Corporation Method in an electronic spreadsheet for displaying and/or hiding range of cells
US7376900B2 (en) * 2004-09-30 2008-05-20 International Business Machines Corporation Method and system to control operation of a portlet
US20060117051A1 (en) * 2004-11-26 2006-06-01 Chin Philip K Method of displaying data in a table
US7665028B2 (en) * 2005-07-13 2010-02-16 Microsoft Corporation Rich drag drop user interface
US7487139B2 (en) * 2005-10-12 2009-02-03 International Business Machines Corporation Method and system for filtering a table
US20070157124A1 (en) * 2005-12-30 2007-07-05 Tobias Haug Reduction of graphical clutter in computer displays

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5950168A (en) * 1996-12-18 1999-09-07 Knowmed Systems Collapsible flowsheet for displaying patient information in an electronic medical record
US6313848B1 (en) * 1999-01-06 2001-11-06 Avaya Technology Corp. Folded tables: a method of viewing wide tables with reduced need for horizontal scrolling
US20050050092A1 (en) * 2003-08-25 2005-03-03 Oracle International Corporation Direct loading of semistructured data

Also Published As

Publication number Publication date
JP4868580B2 (ja) 2012-02-01
US20070033518A1 (en) 2007-02-08
JP2007042108A (ja) 2007-02-15
CN1908929A (zh) 2007-02-07
US7788584B2 (en) 2010-08-31

Similar Documents

Publication Publication Date Title
CN100424684C (zh) 在电子表格中隐藏列的计算机实现方法及系统
KR101733943B1 (ko) 계층적-체계화된 컨트롤 갤러리 제공 기법
JP4896444B2 (ja) 電子ドキュメント内で特定のタイプのコンテンツを管理するための方法、装置、およびコンピュータ可読媒体
US11366676B2 (en) Embedded user assistance for software applications
US9367198B2 (en) Spin control user interface for selecting options
US8464248B2 (en) Contextual discovery of value-added components
EP1679589B1 (en) System and methods for inline property editing in tree view based editors
US9250926B2 (en) Platform extensibility framework
US20090132952A1 (en) Localized thumbnail preview of related content during spatial browsing
KR20090018927A (ko) 차트를 포맷하는 방법, 차트를 수정하는 시스템, 및 컴퓨터판독가능 매체
JP2009508233A (ja) スレッドナビゲーション
WO2011136932A1 (en) Temporary formatting and charting of selected data
US20120005572A1 (en) System, method, and apparatus for location identification of content
US20070239746A1 (en) Visual merge of portlets
KR20080059200A (ko) 차트 생성을 향상시키기 위한 컴퓨터 판독가능 매체, 장치및 방법
WO2008073838A1 (en) Automated control text truncation detection
US9424256B2 (en) Method and apparatus for performing type-aware change tracking in a document
US8635541B2 (en) Indicating pending asynchronous updates in a graphical user interface (GUI)
CN108304291A (zh) 测试输入信息检索装置和方法
US7743079B1 (en) Managing data across a semantic data view and a presentation data view
US20070283271A1 (en) System and Method for Providing Indicators of Component Interaction Capability Across Navigation Elements
JP2006338099A (ja) 階層構造表示装置、階層構造表示方法、階層構造表示システム、クライアント端末、階層構造表示サーバ、並びに、階層構造表示プログラムおよび記録媒体
KR102150536B1 (ko) 서버 설정에 따라 동적으로 웹 ui 컴포넌트를 생성하기 위한 시스템 및 방법

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C14 Grant of patent or utility model
GR01 Patent grant
ASS Succession or assignment of patent right

Owner name: GOOGLE INC.

Free format text: FORMER OWNER: INTERNATIONAL BUSINESS MACHINES CORP.

Effective date: 20120514

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

Effective date of registration: 20120514

Address after: American California

Patentee after: GOOGLE Inc.

Address before: American New York

Patentee before: International Business Machines Corp.

CP01 Change in the name or title of a patent holder
CP01 Change in the name or title of a patent holder

Address after: American California

Patentee after: Google Inc.

Address before: American California

Patentee before: Google Inc.

CF01 Termination of patent right due to non-payment of annual fee

Granted publication date: 20081008

CF01 Termination of patent right due to non-payment of annual fee