KR100956571B1 - 스프레드시트의 셀 처리 방법, 시스템 및 컴퓨터 프로그램제품 - Google Patents

스프레드시트의 셀 처리 방법, 시스템 및 컴퓨터 프로그램제품 Download PDF

Info

Publication number
KR100956571B1
KR100956571B1 KR1020077006469A KR20077006469A KR100956571B1 KR 100956571 B1 KR100956571 B1 KR 100956571B1 KR 1020077006469 A KR1020077006469 A KR 1020077006469A KR 20077006469 A KR20077006469 A KR 20077006469A KR 100956571 B1 KR100956571 B1 KR 100956571B1
Authority
KR
South Korea
Prior art keywords
cell
formula
cells
root
spreadsheet
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
KR1020077006469A
Other languages
English (en)
Korean (ko)
Other versions
KR20070059106A (ko
Inventor
마이클 챠보우스티에
앤드류 에버바흐
트레버 몽고메리
조슈아 우즈
Original Assignee
인터내셔널 비지네스 머신즈 코포레이션
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by 인터내셔널 비지네스 머신즈 코포레이션 filed Critical 인터내셔널 비지네스 머신즈 코포레이션
Publication of KR20070059106A publication Critical patent/KR20070059106A/ko
Application granted granted Critical
Publication of KR100956571B1 publication Critical patent/KR100956571B1/ko
Anticipated expiration legal-status Critical
Expired - Fee Related legal-status Critical Current

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
    • G06F17/00—Digital computing or data processing equipment or methods, specially adapted for specific functions

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • Computational Linguistics (AREA)
  • General Health & Medical Sciences (AREA)
  • Health & Medical Sciences (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Artificial Intelligence (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Mathematical Physics (AREA)
  • Software Systems (AREA)
  • User Interface Of Digital Computer (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)
KR1020077006469A 2004-10-07 2005-09-23 스프레드시트의 셀 처리 방법, 시스템 및 컴퓨터 프로그램제품 Expired - Fee Related KR100956571B1 (ko)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US10/960,254 US9047266B2 (en) 2004-10-07 2004-10-07 Methods, systems and computer program products for processing cells in a spreadsheet
US10/960,254 2004-10-07

Publications (2)

Publication Number Publication Date
KR20070059106A KR20070059106A (ko) 2007-06-11
KR100956571B1 true KR100956571B1 (ko) 2010-05-07

Family

ID=35986144

Family Applications (1)

Application Number Title Priority Date Filing Date
KR1020077006469A Expired - Fee Related KR100956571B1 (ko) 2004-10-07 2005-09-23 스프레드시트의 셀 처리 방법, 시스템 및 컴퓨터 프로그램제품

Country Status (8)

Country Link
US (1) US9047266B2 (https=)
EP (1) EP1800221A2 (https=)
JP (1) JP4726907B2 (https=)
KR (1) KR100956571B1 (https=)
CN (1) CN101010672A (https=)
CA (1) CA2582743A1 (https=)
TW (1) TW200622864A (https=)
WO (1) WO2006037733A2 (https=)

Families Citing this family (33)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
DE102004007638A1 (de) * 2004-02-17 2005-09-01 Xapio Gmbh Verfahren zum Erzeugen von Quellcode in einer prozeduralen, reentrantfähigen Programmiersprache aus einer Spreadsheet-Darstellung
US8745483B2 (en) 2004-10-07 2014-06-03 International Business Machines Corporation Methods, systems and computer program products for facilitating visualization of interrelationships in a spreadsheet
US7716231B2 (en) 2004-11-10 2010-05-11 Microsoft Corporation System and method for generating suggested alternatives for visual or audible submissions
CA2614059C (en) * 2005-03-11 2014-11-04 Orangescape Technologies Limited A system and method of defining a hierarchical datamodel and related computation and instruction rules using spreadsheet like user interface
US7424668B2 (en) * 2005-06-15 2008-09-09 Microsoft Corporation Pre-formulated spreadsheet cell groups
CN1892641A (zh) * 2005-06-29 2007-01-10 国际商业机器公司 用于在电子表单中隐藏模型内的敏感数据的方法和系统
US20070219847A1 (en) * 2006-03-15 2007-09-20 Kazimierz Ogonowski Internet-based marketing and sales application and method for targeted marketing of a product and/or service
US20080104498A1 (en) * 2006-10-25 2008-05-01 International Business Machines Corporation Dynamically Merging Columns Within a Table
JP2008165408A (ja) * 2006-12-27 2008-07-17 Canon Inc 情報処理装置、その制御方法及びプログラム
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
US8407668B2 (en) * 2007-10-26 2013-03-26 Microsoft Corporation Model based spreadsheet scripting language
US8370795B1 (en) * 2008-01-31 2013-02-05 Intuit Inc. Method and system for explaining a value of a field in a form
US20090228776A1 (en) * 2008-03-05 2009-09-10 Microsoft Corporation Dynamic formulas for spreadsheet cells
DE102009014616A1 (de) * 2009-03-24 2010-09-30 Hansa-Datenservice, Gowarsch & Co. Vorrichtung und Verfahren zur automatischen Verarbeitung von Daten
CA2718360A1 (en) * 2010-10-25 2011-01-05 Ibm Canada Limited - Ibm Canada Limitee Communicating secondary selection feedback
US9075787B2 (en) * 2010-11-30 2015-07-07 Think-Cell Software Gmbh Defining a reusable spreadsheet-function by extracting the function from a complex calculation in a spreadsheet document
US8250459B2 (en) * 2010-12-13 2012-08-21 Google Inc. System and method for providing online data management services
US9460073B2 (en) * 2013-02-27 2016-10-04 Google Inc. Systems and methods for mutations and operational transforms in a collaborative spreadsheet environment
US20140359417A1 (en) * 2013-06-04 2014-12-04 Omer Bar-On Systems and methods for graphically modulating structured data
US9026897B2 (en) 2013-07-12 2015-05-05 Logic9S, Llc Integrated, configurable, sensitivity, analytical, temporal, visual electronic plan system
US9116931B2 (en) 2013-07-12 2015-08-25 Logic9S, Llc Integrated, configurable, analytical, temporal, visual electronic plan system
US10574548B2 (en) * 2013-07-31 2020-02-25 Splunk Inc. Key indicators view
CN103488622A (zh) * 2013-09-04 2014-01-01 用友软件股份有限公司 隐藏数据计算系统和隐藏数据计算方法
US10599764B2 (en) 2015-11-02 2020-03-24 Microsoft Technology Licensing, Llc Operations on images associated with cells in spreadsheets
EP3411800A1 (en) * 2016-02-01 2018-12-12 Microsoft Technology Licensing, LLC Parameterizing and working with math equations in a spreadsheet application
US9983768B2 (en) * 2016-10-20 2018-05-29 International Business Machines Corporation Tabulated data selection
CN108446264B (zh) * 2018-03-26 2022-02-15 阿博茨德（北京）科技有限公司 Pdf文档中的表格矢量解析方法及装置
US12039258B2 (en) * 2018-10-15 2024-07-16 Dayal Family LLC Method and system for dynamic naming of component expressions within a formula in a cell in a spreadsheet application
US11610059B2 (en) * 2018-12-07 2023-03-21 Interject Data System, Inc. Systems and methods for a visual interface for grid-based programs
CN111859880B (zh) * 2019-04-29 2023-06-27 珠海金山办公软件有限公司 一种定位到单元格的方法、系统、存储介质和终端
CN112784548B (zh) * 2019-11-07 2024-08-13 珠海金山办公软件有限公司 一种单元格合并方法、装置、及存储介质
CN113779161B (zh) * 2021-08-27 2022-08-23 北京元年科技股份有限公司 计算脚本的生成方法、装置、计算机设备以及存储介质

Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20040088650A1 (en) * 2002-10-30 2004-05-06 Actuate Corporation Methods and apparatus for generating a spreadsheet report template

Family Cites Families (20)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5033009A (en) * 1989-03-03 1991-07-16 Dubnoff Steven J System for generating worksheet files for electronic spreadsheets
US5255356A (en) * 1989-05-31 1993-10-19 Microsoft Corporation Method for hiding and showing spreadsheet cells
US5325478A (en) * 1989-09-15 1994-06-28 Emtek Health Care Systems, Inc. Method for displaying information from an information based computer system
US5949416A (en) * 1991-05-28 1999-09-07 Borland International, Inc. Method for providing help information for nested functions
US5701499A (en) * 1992-03-25 1997-12-23 Microsoft Corporation Method and system for automatically entering a data series into contiguous cells of an electronic spreadsheet program or the like
US5553215A (en) * 1994-09-21 1996-09-03 Microsoft Corporation Method and system of sharing common formulas in a spreadsheet program and of adjusting the same to conform with editing operations
US5592666A (en) * 1994-10-31 1997-01-07 Sinper Corporation Method and system for storing and retrieving data from a multidimensional array using database pointers
JPH08180116A (ja) 1994-12-27 1996-07-12 Nec Software Ltd スプレッドシートセル構造
US6006239A (en) * 1996-03-15 1999-12-21 Microsoft Corporation Method and system for allowing multiple users to simultaneously edit a spreadsheet
US5819293A (en) * 1996-06-06 1998-10-06 Microsoft Corporation Automatic Spreadsheet forms
US5987481A (en) * 1997-07-01 1999-11-16 Microsoft Corporation Method and apparatus for using label references in spreadsheet formulas
US6057837A (en) * 1997-07-15 2000-05-02 Microsoft Corporation On-screen indentification and manipulation of sources that an object depends upon
US6460059B1 (en) * 1998-08-04 2002-10-01 International Business Machines Corporation Visual aid to simplify achieving correct cell interrelations in spreadsheets
US6640234B1 (en) * 1998-12-31 2003-10-28 Microsoft Corporation Extension of formulas and formatting in an electronic spreadsheet
GB2358936A (en) 2000-02-02 2001-08-08 Roke Manor Research Improvements in or relating to spreadsheets
US6341292B1 (en) * 2000-05-30 2002-01-22 Outlooksoft Corporation Spreadsheet-based network information exchange with two-part cache
US6766512B1 (en) * 2000-11-22 2004-07-20 Furraylogic Ltd. Methods and systems for generating a structured language model from a spreadsheet model
US7251776B2 (en) * 2001-07-13 2007-07-31 Netview Technologies, Inc. System and method for efficiently and flexibly utilizing spreadsheet information
US7530012B2 (en) * 2003-05-22 2009-05-05 International Business Machines Corporation Incorporation of spreadsheet formulas of multi-dimensional cube data into a multi-dimensional cube
US20070074112A1 (en) * 2005-09-23 2007-03-29 Business Objects Apparatus and method for consolidating reporting formulas

Patent Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20040088650A1 (en) * 2002-10-30 2004-05-06 Actuate Corporation Methods and apparatus for generating a spreadsheet report template

Also Published As

Publication number Publication date
KR20070059106A (ko) 2007-06-11
WO2006037733A2 (en) 2006-04-13
US20060080595A1 (en) 2006-04-13
EP1800221A2 (en) 2007-06-27
US9047266B2 (en) 2015-06-02
JP2008516321A (ja) 2008-05-15
CA2582743A1 (en) 2006-04-13
WO2006037733A3 (en) 2006-07-27
CN101010672A (zh) 2007-08-01
TW200622864A (en) 2006-07-01
JP4726907B2 (ja) 2011-07-20

Similar Documents

Publication Publication Date Title
KR100956571B1 (ko) 스프레드시트의 셀 처리 방법, 시스템 및 컴퓨터 프로그램제품
US11036930B2 (en) Methods, systems and computer program products for facilitating visualization of interrelationships in a spreadsheet
US9727551B2 (en) Associating conditions to summary table data
US9075787B2 (en) Defining a reusable spreadsheet-function by extracting the function from a complex calculation in a spreadsheet document
US8166387B2 (en) DataGrid user interface control with row details
US6078739A (en) Method of managing objects and parameter values associated with the objects within a simulation model
AU2011245657B2 (en) Temporary formatting and charting of selected data
US20060190432A1 (en) System and method for graphically distinguishing levels of a multidimensional database
CA2718360A1 (en) Communicating secondary selection feedback
CN101258490A (zh) 指定、设置和发现电子表格文档的参数
US20060053363A1 (en) Graphically defining a formula for use within a spreadsheet program
US20040227759A1 (en) Plotting numerical data
US6766509B1 (en) Methodology for testing spreadsheet grids
US6938260B1 (en) Complex data navigation, manipulation and presentation support for visualage Java
US20080172636A1 (en) User interface for selecting members from a dimension
EP2118743A2 (en) Method for providing a user interface driven by database tables
JPH0619655A (ja) オブジェクト指向ソフトウェアプログラムにおいてコンピュータのビデオディスプレイにマルチエントリのデータフィールドを表示する方法
Velázquez-Iturbide et al. Recursion-based visualizations of search algorithms in state-spaces
Gibbons et al. ExActR: A Shiny app for creating ecosystem extent accounts
CN121901247A (zh) 查询表单的查询项生成方法和系统、信息模型生成方法
CN121901244A (zh) 查询表单的查询项生成方法和系统、数据模型生成方法
Gregory Lists
CA2468045A1 (en) System and method of presenting multilingual metadata

Legal Events

Date Code Title Description
PA0105 International application

St.27 status event code: A-0-1-A10-A15-nap-PA0105

PG1501 Laying open of application

St.27 status event code: A-1-1-Q10-Q12-nap-PG1501

A201 Request for examination
P11-X000 Amendment of application requested

St.27 status event code: A-2-2-P10-P11-nap-X000

P13-X000 Application amended

St.27 status event code: A-2-2-P10-P13-nap-X000

PA0201 Request for examination

St.27 status event code: A-1-2-D10-D11-exm-PA0201

R18-X000 Changes to party contact information recorded

St.27 status event code: A-3-3-R10-R18-oth-X000

R18-X000 Changes to party contact information recorded

St.27 status event code: A-3-3-R10-R18-oth-X000

E902 Notification of reason for refusal
PE0902 Notice of grounds for rejection

St.27 status event code: A-1-2-D10-D21-exm-PE0902

E13-X000 Pre-grant limitation requested

St.27 status event code: A-2-3-E10-E13-lim-X000

P11-X000 Amendment of application requested

St.27 status event code: A-2-2-P10-P11-nap-X000

P13-X000 Application amended

St.27 status event code: A-2-2-P10-P13-nap-X000

E701 Decision to grant or registration of patent right
PE0701 Decision of registration

St.27 status event code: A-1-2-D10-D22-exm-PE0701

GRNT Written decision to grant
PR0701 Registration of establishment

St.27 status event code: A-2-4-F10-F11-exm-PR0701

PR1002 Payment of registration fee

St.27 status event code: A-2-2-U10-U12-oth-PR1002

Fee payment year number: 1

PG1601 Publication of registration

St.27 status event code: A-4-4-Q10-Q13-nap-PG1601

LAPS Lapse due to unpaid annual fee
PC1903 Unpaid annual fee

St.27 status event code: A-4-4-U10-U13-oth-PC1903

Not in force date: 20130430

Payment event data comment text: Termination Category : DEFAULT_OF_REGISTRATION_FEE

PC1903 Unpaid annual fee

St.27 status event code: N-4-6-H10-H13-oth-PC1903

Ip right cessation event data comment text: Termination Category : DEFAULT_OF_REGISTRATION_FEE

Not in force date: 20130430