DE60008498T2 - 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 Download PDF

Info

Publication number
DE60008498T2
DE60008498T2 DE60008498T DE60008498T DE60008498T2 DE 60008498 T2 DE60008498 T2 DE 60008498T2 DE 60008498 T DE60008498 T DE 60008498T DE 60008498 T DE60008498 T DE 60008498T DE 60008498 T2 DE60008498 T2 DE 60008498T2
Authority
DE
Germany
Prior art keywords
cell
range
address
der
area
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
German (de)
English (en)
Other versions
DE60008498D1 (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)
  • Document Processing Apparatus (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (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 DE60008498D1 (de) 2004-04-01
DE60008498T2 true 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 (fr)
JP (1) JP2001216463A (fr)
CA (1) CA2311866A1 (fr)
DE (1) DE60008498T2 (fr)
SG (1) SG115351A1 (fr)

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
US7415481B2 (en) * 2004-09-30 2008-08-19 Microsoft Corporation Method and implementation for referencing of dynamic data within spreadsheet formulas
US7698287B2 (en) 2004-09-30 2010-04-13 Microsoft Corporation Design of spreadsheet functions for working with tables of data
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
US20070061699A1 (en) * 2005-09-09 2007-03-15 Microsoft Corporation Named object view of electronic data report
US7752536B2 (en) * 2005-09-09 2010-07-06 Microsoft Corporation Designating, setting and discovering parameters for spreadsheet documents
US7792847B2 (en) * 2005-09-09 2010-09-07 Microsoft Corporation Converting structured reports to formulas
US8095866B2 (en) 2005-09-09 2012-01-10 Microsoft Corporation Filtering user interface for a data summary table
US20110145689A1 (en) * 2005-09-09 2011-06-16 Microsoft Corporation Named object view over multiple files
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
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
US10402759B2 (en) * 2015-01-22 2019-09-03 Visier Solutions, Inc. Systems and methods of adding and reconciling dimension members
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
CA2311866A1 (fr) 2001-07-06
SG115351A1 (en) 2005-10-28
JP2001216463A (ja) 2001-08-10
DE60008498D1 (de) 2004-04-01
US20010007988A1 (en) 2001-07-12
US6757867B2 (en) 2004-06-29

Similar Documents

Publication Publication Date Title
DE60008498T2 (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
DE60133343T2 (de) Verfahren und System in einem elektronischen Kalkulationsblatt für die Handhabung von benutzerdefinierten Optionen in einer Ausschneiden-Kopieren-Einfügen-Funktion
DE69425684T2 (de) System und Verfahren zur Verwaltung elektronischer Modellierungssysteme
DE69331025T2 (de) System und Verfahren für Rechnerschnittstellen
DE3586790T2 (de) In linie-dynamischer editor fuer gemischte objectdokumente.
US7895511B2 (en) Copy and paste of cells in a multi-dimensional spreadsheet
DE4301766C2 (de) Verfahren zum Darstellen eines doppelseitigen, umwendbaren elektronischen Papiers
DE602004003139T2 (de) System und verfahren für eine datentabelle zur verwaltung von einfügeoperationen in rekursiven skalierbaren vorlageninstanzen
DE69127672T2 (de) Zielorientiertes elektronisches Formblattsystem
DE69429658T2 (de) Computer-bedieneroberfläche für dokumente mit vielfältigem inhalt
DE69318571T2 (de) Verfahren und system für die in-ort-wechselwirkung mit eingebetteten objekten
DE3586273T2 (de) Implizite erzeugung einer superblockstruktur in einem vieldaten-edierungsgeraet.
DE69600794T2 (de) Graphische entwicklungs- und verwaltungsumgebung für anwendungsprogramme
DE3586274T2 (de) Vieldaten-edierungsgeraet mit gebrauch von attributstroemen fuer textobjekte.
DE60314563T2 (de) Überlagerung mit elektronischer Tinte
DE69526545T2 (de) Ein Verfahren und Gerät zur Darstellung von Datenbanksuchergebnissen
DE69601151T2 (de) Interaktives sytem zum generieren von berichten und verfahren zu seinem betrieb
DE3586272T2 (de) Integriertes vieldaten-edierungsgeraet.
DE69732547T2 (de) Verfahren und Gerät zum Zusammenklappen und zur Ausdehnung auserwählter Bereiche von Arbeitsräumen auf einem von einem Rechner kontrollierten Anzeigesystem
DE60203525T2 (de) Vorrichtung und verfahren in einer büroapplikation zur bereitstellung von inhaltsabhängiger hilfeinformation
US7971134B2 (en) Method and system in an electronic spreadsheet for persistently filling by samples a range of cells
DE29623701U1 (de) Grafik Browser
US7743316B2 (en) Method and system for hiding sensitive data in an electronic spreadsheet environment
DE69404438T2 (de) Objektorientiertes graphisches auswahlsystem
DE69430013T2 (de) Rahmenstruktur als schnittstelle zwischen den teilen eines zusammengesetzten dokuments

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