DE60008498D1 - Verfahren und System zum Addieren und Löschen von Elementen in einem Bereich von mit Namen versehenen Zellen entsprechend verschiedener Methoden in einem elektronischen Kalkulationsblatt - Google Patents

Verfahren und System zum Addieren und Löschen von Elementen in einem Bereich von mit Namen versehenen Zellen entsprechend verschiedener Methoden in einem elektronischen Kalkulationsblatt

Info

Publication number
DE60008498D1
DE60008498D1 DE60008498T DE60008498T DE60008498D1 DE 60008498 D1 DE60008498 D1 DE 60008498D1 DE 60008498 T DE60008498 T DE 60008498T DE 60008498 T DE60008498 T DE 60008498T DE 60008498 D1 DE60008498 D1 DE 60008498D1
Authority
DE
Germany
Prior art keywords
range
various methods
cells according
electronic spreadsheet
deleting elements
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 - Lifetime
Application number
DE60008498T
Other languages
English (en)
Other versions
DE60008498T2 (de
Inventor
Albert Harari
Frederic Bauchot
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.)
International Business Machines Corp
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 DE60008498D1 publication Critical patent/DE60008498D1/de
Application granted granted Critical
Publication of DE60008498T2 publication Critical patent/DE60008498T2/de
Anticipated expiration legal-status Critical
Expired - Lifetime legal-status Critical Current

Links

Classifications

    • 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
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99931—Database or file accessing

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)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Document Processing Apparatus (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)
DE60008498T 2000-01-06 2000-12-07 Verfahren und System zum Addieren und Löschen von Elementen in einem Bereich von mit Namen versehenen Zellen entsprechend verschiedener Methoden in einem elektronischen Kalkulationsblatt Expired - Lifetime DE60008498T2 (de)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
EP00480009 2000-01-06
EP00480009 2000-01-06

Publications (2)

Publication Number Publication Date
DE60008498D1 true DE60008498D1 (de) 2004-04-01
DE60008498T2 DE60008498T2 (de) 2004-12-02

Family

ID=8174208

Family Applications (1)

Application Number Title Priority Date Filing Date
DE60008498T Expired - Lifetime DE60008498T2 (de) 2000-01-06 2000-12-07 Verfahren und System zum Addieren und Löschen von Elementen in einem Bereich von mit Namen versehenen Zellen entsprechend verschiedener Methoden in einem elektronischen Kalkulationsblatt

Country Status (5)

Country Link
US (1) US6757867B2 (de)
JP (1) JP2001216463A (de)
CA (1) CA2311866A1 (de)
DE (1) DE60008498T2 (de)
SG (1) SG115351A1 (de)

Families Citing this family (44)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7117430B2 (en) * 2001-02-27 2006-10-03 Microsoft Corporation Spreadsheet error checker
US20030033329A1 (en) * 2001-06-22 2003-02-13 Bergman Eric D. Method and apparatus for entry and editing of spreadsheet formulas
US6988242B2 (en) * 2002-01-07 2006-01-17 International Business Machines Corporation Transforming a portion of a database into a custom spreadsheet
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
JP2005038149A (ja) * 2003-07-14 2005-02-10 Canon Inc 帳票処理方法、帳票処理プログラム、帳票処理装置
US7127672B1 (en) * 2003-08-22 2006-10-24 Microsoft Corporation Creating and managing structured data in an electronic spreadsheet
FR2864275A1 (fr) * 2003-12-19 2005-06-24 Thales Sa Procede de mise a jour d'une base de donnees creee avec un tableur
JP2005216203A (ja) * 2004-02-02 2005-08-11 Mantaro Yajima 表フォーマットデータ処理方法並びに表フォーマットデータ処理装置
US7769783B2 (en) * 2004-04-20 2010-08-03 Reuters Limited Computing algebraic equations
US7698287B2 (en) * 2004-09-30 2010-04-13 Microsoft Corporation Design of spreadsheet functions for working with tables of data
US7415481B2 (en) * 2004-09-30 2008-08-19 Microsoft Corporation Method and implementation for referencing of dynamic data within spreadsheet formulas
US8621340B2 (en) 2004-12-20 2013-12-31 Microsoft Corporation Block properties and calculated columns in a spreadsheet application
US7693860B2 (en) * 2005-03-18 2010-04-06 Microsoft Corporation Method and system to associate cell and item metadata
US20070050700A1 (en) * 2005-08-30 2007-03-01 Microsoft Corporation Formattable spreadsheet table elements with automatic updating
US8234293B2 (en) * 2005-09-08 2012-07-31 Microsoft Corporation Autocompleting with queries to a database
US8601383B2 (en) 2005-09-09 2013-12-03 Microsoft Corporation User interface for creating a spreadsheet data summary table
US8095866B2 (en) 2005-09-09 2012-01-10 Microsoft Corporation Filtering user interface for a data summary table
US20070061699A1 (en) * 2005-09-09 2007-03-15 Microsoft Corporation Named object view of electronic data report
US20110145689A1 (en) * 2005-09-09 2011-06-16 Microsoft Corporation Named object view over multiple files
US7792847B2 (en) * 2005-09-09 2010-09-07 Microsoft Corporation Converting structured reports to formulas
US7752536B2 (en) * 2005-09-09 2010-07-06 Microsoft Corporation Designating, setting and discovering parameters for spreadsheet documents
US7805433B2 (en) * 2005-10-14 2010-09-28 Microsoft Corporation Multidimensional cube functions
US7627812B2 (en) 2005-10-27 2009-12-01 Microsoft Corporation Variable formatting of cells
US20070168323A1 (en) * 2006-01-03 2007-07-19 Microsoft Corporation Query aggregation
US7770100B2 (en) * 2006-02-27 2010-08-03 Microsoft Corporation Dynamic thresholds for conditional formats
US20070294141A1 (en) * 2006-06-15 2007-12-20 Eric Bublitz Method and Device for Aiding Consumers in the Selection of Infant Clothing
US7937426B2 (en) * 2006-06-30 2011-05-03 Mircosoft Corporation Interval generation for numeric data
JP4973063B2 (ja) * 2006-08-14 2012-07-11 富士通株式会社 表データ処理方法及び装置
US10318624B1 (en) * 2006-12-28 2019-06-11 Apple Inc. Infinite canvas
US20090044090A1 (en) * 2007-08-06 2009-02-12 Apple Inc. Referring to cells using header cell values
US9164978B2 (en) * 2008-06-17 2015-10-20 Microsoft Technology Licensing, Llc Identifying objects within a multidimensional array
US20110072340A1 (en) * 2009-09-21 2011-03-24 Miller Darren H Modeling system and method
US9747270B2 (en) 2011-01-07 2017-08-29 Microsoft Technology Licensing, Llc Natural input for spreadsheet actions
US8793566B2 (en) * 2010-11-10 2014-07-29 Duquesne University Of The Holy Spirit System and method for allocating, scheduling, tracking and reporting usage of training assets and facilities
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
US10209864B2 (en) * 2012-06-19 2019-02-19 Microsoft Technology Licensing, Llc UI differentiation between delete and clear
US10664652B2 (en) 2013-06-15 2020-05-26 Microsoft Technology Licensing, Llc Seamless grid and canvas integration in a spreadsheet application
US10402759B2 (en) * 2015-01-22 2019-09-03 Visier Solutions, Inc. Systems and methods of adding and reconciling dimension members
US11636408B2 (en) 2015-01-22 2023-04-25 Visier Solutions, Inc. Techniques for manipulating and rearranging presentation of workforce data in accordance with different data-prediction scenarios available within a graphical user interface (GUI) of a computer system, and an apparatus and hardware memory implementing the techniques
KR101966177B1 (ko) * 2017-09-19 2019-04-05 이강돈 다중 다차원 속성을 가진 스프레드 시트 처리 방법 및 시스템
US10776574B1 (en) * 2019-03-19 2020-09-15 Apple Inc. Custom summarization in categories
US11886916B2 (en) 2020-06-30 2024-01-30 Microsoft Technology Licensing, Llc System for adaptive multithreaded recalculation operations
US20230244863A1 (en) * 2022-01-28 2023-08-03 Intuit Inc. System and method for reference validation of spreadsheet

Family Cites Families (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5418898A (en) 1991-08-07 1995-05-23 Occam Research Corporation Multidimensional data display system and method
US5416895A (en) 1992-04-08 1995-05-16 Borland International, Inc. System and methods for improved spreadsheet interface with user-familiar objects
US5471612A (en) * 1994-03-03 1995-11-28 Borland International, Inc. Electronic spreadsheet system and methods for compiling a formula stored in a spreadsheet into native machine code for execution by a floating-point unit upon spreadsheet recalculation
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
US5842180A (en) * 1996-03-28 1998-11-24 Microsoft Corporation Method and system for detecting and correcting errors in a spreadsheet formula
US6317758B1 (en) * 1998-02-20 2001-11-13 Corel Corporation Method and system for detecting and selectively correcting cell reference errors

Also Published As

Publication number Publication date
US6757867B2 (en) 2004-06-29
JP2001216463A (ja) 2001-08-10
SG115351A1 (en) 2005-10-28
CA2311866A1 (en) 2001-07-06
US20010007988A1 (en) 2001-07-12
DE60008498T2 (de) 2004-12-02

Similar Documents

Publication Publication Date Title
DE60008498D1 (de) Verfahren und System zum Addieren und Löschen von Elementen in einem Bereich von mit Namen versehenen Zellen entsprechend verschiedener Methoden in einem elektronischen Kalkulationsblatt
DE50306368D1 (de) Verfahren und vorrichtung zur bestimmung der konzentration von in einer zu untersuchenden probe enthaltenen liganden
DE69940270D1 (de) In situ verfahren zum analysieren von zellen
DE602004027513D1 (de) System und verfahren zur verhinderung von duplikat-druck in einem web-browser
DE19983352T1 (de) Verfahren und Vorrichtung zum Authentisieren von Verbingungen mit einem mit einem Netzwerk gekoppelten Speichersystem
DE60141025D1 (de) Vorrichtung und verfahren zum erkennen von defekten oder beschädigungen in abwasserleitungen
DE60327499D1 (de) Vorrichtung und Verfahren zur Zuweisung von Ressourcen einer virtuellen Zelle in einem OFDM-Mobilkommunikationssystem
DE50308888D1 (de) Verfahren zur unterdr ckung von st rungen in systemen z ur objekterfassung
DE10196670T1 (de) System und Verfahren zur Migration von Daten in einem elektronischen Handelssystem
DE10085363T1 (de) Verfahren und Einrichtung zum Verwalten von Ressourcen in einem Multithreaded-Prozessor
DE602005009150D1 (de) Vorrichtung und verfahren zum effizienten suchen von inhalten in einem filesystem
DE602005006036D1 (de) System und Verfahren zur Bereitstellung von Weglenkungsinformation in einem Maschennetzwerk
DE112007000300B8 (de) Brennstoffzellensystem und Verfahren zum Reduzieren von Wasser in einem Brennstoffzellensystem
DE10195549T1 (de) Verfahren zum schnellen Abschluss von in einem Netzwerk verteilten Datenverarbeitungs-Prozessen
DE60119567D1 (de) Verfahren und vorrichtung zur erkennung und klassifikation von störungen in einem rf-modulierten netzwerk
DE60302585D1 (de) System und Verfahren zur Erkennung von Computerviren in einem mobilen Kommunikationsgerät
DE60318468D1 (de) Verfahren zur lösung von entscheidungslosigkeiten in einem cluster-rechnersystem
DE10292223D2 (de) Verfahren zum Abführen von in einem Kraftstofffilter abgeschiedenem Wasser und Vorrichtung zur Durchführung dieses Verfahrens
DE60302945D1 (de) Vorrichtung und Verfahren zur Detektion von Rissen in Wabenstrukturmaterial
DE602004016215D1 (de) Speichersystem und Verfahren zur Erfassung und Verwendung von Speicherauszügen
DE60120572D1 (de) Verfahren und Vorrichtung zur Trennung von Wasser und Gas in einem Gasanalysegerät
ATE405344T1 (de) Ringspaltreaktor und verfahren durchgeführt in einem ringspaltreaktor
DE60042120D1 (de) Verfahren zum Einsetzen von Lagersteinen in einem Uhrwerkteil,sowie Vorrichtung zur Durchführung dieses Verfahrens
ATE461490T1 (de) Verfahren, system, datenverarbeitungseinrichtung und computerprogramm zum spezifizieren von knoten in einem einrichtungs-verwaltungssystem
DE60002290D1 (de) Verfahren zum Nachweis von Anomalien in einem Signal

Legal Events

Date Code Title Description
8364 No opposition during term of opposition
8320 Willingness to grant licences declared (paragraph 23)
8328 Change in the person/name/address of the agent

Representative=s name: DUSCHER, R., DIPL.-PHYS. DR.RER.NAT., PAT.-ANW., 7

R082 Change of representative

Ref document number: 1139249

Country of ref document: EP

Representative=s name: PFENNING MEINIG & PARTNER GBR, DE