SG115351A1 - Method and system in an electronic spreadsheet for adding or removing elements from a cell named range according to different modes - Google Patents
Method and system in an electronic spreadsheet for adding or removing elements from a cell named range according to different modesInfo
- Publication number
- SG115351A1 SG115351A1 SG200100118A SG200100118A SG115351A1 SG 115351 A1 SG115351 A1 SG 115351A1 SG 200100118 A SG200100118 A SG 200100118A SG 200100118 A SG200100118 A SG 200100118A SG 115351 A1 SG115351 A1 SG 115351A1
- Authority
- SG
- Singapore
- Prior art keywords
- different modes
- range according
- electronic spreadsheet
- removing elements
- named range
- Prior art date
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)
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
EP00480009 | 2000-01-06 |
Publications (1)
Publication Number | Publication Date |
---|---|
SG115351A1 true SG115351A1 (en) | 2005-10-28 |
Family
ID=8174208
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
SG200100118A SG115351A1 (en) | 2000-01-06 | 2001-01-05 | Method and system in an electronic spreadsheet for adding or removing elements from a cell named range according to different modes |
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)
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)
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 |
-
2000
- 2000-06-15 CA CA002311866A patent/CA2311866A1/fr not_active Abandoned
- 2000-12-06 US US09/731,164 patent/US6757867B2/en not_active Expired - Lifetime
- 2000-12-07 DE DE60008498T patent/DE60008498T2/de not_active Expired - Lifetime
- 2000-12-27 JP JP2000398247A patent/JP2001216463A/ja active Pending
-
2001
- 2001-01-05 SG SG200100118A patent/SG115351A1/en unknown
Also Published As
Publication number | Publication date |
---|---|
CA2311866A1 (fr) | 2001-07-06 |
JP2001216463A (ja) | 2001-08-10 |
DE60008498D1 (de) | 2004-04-01 |
US20010007988A1 (en) | 2001-07-12 |
US6757867B2 (en) | 2004-06-29 |
DE60008498T2 (de) | 2004-12-02 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
SG115351A1 (en) | Method and system in an electronic spreadsheet for adding or removing elements from a cell named range according to different modes | |
GB2365724B (en) | A system and method for authenticating electronic documents | |
AU2003240811A8 (en) | Method and system for facilitating paper to electronic communications | |
GB2333878B (en) | System and method for performing an electronic financial transaction | |
IL131135A0 (en) | A method and system for electronic mail | |
AU2001233140A1 (en) | System and method for efficiently performing scheduling operations in an electronic device | |
IL153939A0 (en) | System and method for visual feedback of command execution in electronic mail systems | |
AU2002220204A1 (en) | Electronic payment system and method | |
GB9917511D0 (en) | Method and apparatus for executing standard functions in a computer system | |
AU2001253809A1 (en) | Method and system for signing and authenticating electronic documents | |
GB0219742D0 (en) | Method and apparatus for representing resources in a computing system environment | |
AU2002239241A1 (en) | System and method for updating stored information in electronic devices | |
AU9508201A (en) | An electronic collateral management system and method | |
GB0123265D0 (en) | System and method for drawing electronic images cross reference to related application | |
AU2001217971A1 (en) | A system and method for electronic ticketing | |
AU2001296319A1 (en) | System and method for migrating data in an electronic commerce system | |
GB2360380B (en) | Method and system for electronic commerce | |
SG108816A1 (en) | Electronic settling system and electronic settling method | |
EP1297436A4 (fr) | Systeme et procede permettant d'emettre des tickets electroniques | |
IL149270A0 (en) | System and method for secure electronic transactions | |
GB0205806D0 (en) | System and method for electronic document distribution | |
EP1314169A4 (fr) | Syst me et proc d de protection de carte circuits imprim s | |
AU2002222828A1 (en) | Electronic procurement system and method | |
AU2003232174A8 (en) | Method and system for secure electronic transactions using an agent | |
AU3268200A (en) | Method and system for processing electronic documents |