BRPI0907608A2 - Formulas dinâmicas para células de planilha - Google Patents

Formulas dinâmicas para células de planilha

Info

Publication number
BRPI0907608A2
BRPI0907608A2 BRPI0907608-5A BRPI0907608A BRPI0907608A2 BR PI0907608 A2 BRPI0907608 A2 BR PI0907608A2 BR PI0907608 A BRPI0907608 A BR PI0907608A BR PI0907608 A2 BRPI0907608 A2 BR PI0907608A2
Authority
BR
Brazil
Prior art keywords
spreadsheet cells
dynamic formulas
formulas
dynamic
spreadsheet
Prior art date
Application number
BRPI0907608-5A
Other languages
English (en)
Inventor
Allan Folting
Jeffrey J Duzak
Charles D Ellis
Original Assignee
Microsoft 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 Microsoft Corp filed Critical Microsoft Corp
Publication of BRPI0907608A2 publication Critical patent/BRPI0907608A2/pt

Links

Classifications

    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F17/00Digital computing or data processing equipment or methods, specially adapted for specific functions
    • G06F17/10Complex mathematical operations
    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/177Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • Mathematical Physics (AREA)
  • Data Mining & Analysis (AREA)
  • Computational Linguistics (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Artificial Intelligence (AREA)
  • Health & Medical Sciences (AREA)
  • General Health & Medical Sciences (AREA)
  • Mathematical Optimization (AREA)
  • Mathematical Analysis (AREA)
  • Computational Mathematics (AREA)
  • Algebra (AREA)
  • Pure & Applied Mathematics (AREA)
  • Databases & Information Systems (AREA)
  • Software Systems (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)
  • Document Processing Apparatus (AREA)
  • User Interface Of Digital Computer (AREA)
  • Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
BRPI0907608-5A 2008-03-05 2009-01-30 Formulas dinâmicas para células de planilha BRPI0907608A2 (pt)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US12/042,500 US20090228776A1 (en) 2008-03-05 2008-03-05 Dynamic formulas for spreadsheet cells
PCT/US2009/032532 WO2009111116A1 (en) 2008-03-05 2009-01-30 Dynamic formulas for spreadsheet cells

Publications (1)

Publication Number Publication Date
BRPI0907608A2 true BRPI0907608A2 (pt) 2015-07-21

Family

ID=41054870

Family Applications (1)

Application Number Title Priority Date Filing Date
BRPI0907608-5A BRPI0907608A2 (pt) 2008-03-05 2009-01-30 Formulas dinâmicas para células de planilha

Country Status (15)

Country Link
US (1) US20090228776A1 (pt)
EP (1) EP2266056A4 (pt)
JP (1) JP5451648B2 (pt)
KR (1) KR20100115818A (pt)
CN (1) CN101965564A (pt)
AU (1) AU2009220127B2 (pt)
BR (1) BRPI0907608A2 (pt)
CA (1) CA2717072A1 (pt)
IL (1) IL207283A0 (pt)
MX (1) MX2010009740A (pt)
RU (1) RU2487402C2 (pt)
SG (1) SG188806A1 (pt)
TW (1) TW200939052A (pt)
WO (1) WO2009111116A1 (pt)
ZA (1) ZA201005433B (pt)

Families Citing this family (26)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7716231B2 (en) * 2004-11-10 2010-05-11 Microsoft Corporation System and method for generating suggested alternatives for visual or audible submissions
US8407668B2 (en) * 2007-10-26 2013-03-26 Microsoft Corporation Model based spreadsheet scripting language
US8713423B2 (en) * 2009-03-28 2014-04-29 International Business Machines Corporation Automated dynamic differential data processing
JP2011037097A (ja) * 2009-08-10 2011-02-24 Brother Industries Ltd 印刷装置
US8499290B2 (en) * 2010-06-15 2013-07-30 Microsoft Corporation Creating text functions from a spreadsheet
CN102456013A (zh) * 2010-10-20 2012-05-16 金蝶软件(中国)有限公司 数据表中计算公式的处理方法和装置
CA2718360A1 (en) * 2010-10-25 2011-01-05 Ibm Canada Limited - Ibm Canada Limitee Communicating secondary selection feedback
US10409892B2 (en) * 2011-01-26 2019-09-10 Microsoft Technology Licensing, Llc Formatting data by example
US9069748B2 (en) 2011-10-04 2015-06-30 Microsoft Technology Licensing, Llc Selective generation and display of data items associated with a spreadsheet
US8990675B2 (en) * 2011-10-04 2015-03-24 Microsoft Technology Licensing, Llc Automatic relationship detection for spreadsheet data items
US10229101B2 (en) 2013-06-14 2019-03-12 Microsoft Technology Licensing, Llc Smart fill
CN103488622A (zh) * 2013-09-04 2014-01-01 用友软件股份有限公司 隐藏数据计算系统和隐藏数据计算方法
RU2563144C1 (ru) * 2014-05-14 2015-09-20 Виталий Юрьевич Авдеев Способ заполнения электронной таблицы
US10824799B2 (en) 2014-06-30 2020-11-03 Microsoft Technology Licensing, Llc Summary data autofill
US9652446B2 (en) 2014-08-22 2017-05-16 Smartsheet Inc. Automatically adjusting spreadsheet formulas and/or formatting
US9588952B2 (en) 2015-06-22 2017-03-07 International Business Machines Corporation Collaboratively reconstituting tables
US10031906B2 (en) 2015-11-02 2018-07-24 Microsoft Technology Licensing, Llc Images and additional data 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
US11017165B2 (en) 2017-07-10 2021-05-25 Adaptam Inc. Methods and systems for connecting a spreadsheet to external data sources with temporal replication of cell blocks
US11036929B2 (en) 2017-11-15 2021-06-15 Adaptam Inc. Methods and systems for connecting a spreadsheet to external data sources with ordered formulaic use of data retrieved
US11281696B1 (en) * 2018-04-30 2022-03-22 Workday, Inc. Systems and methods for improving computational speed of planning by tracking dependencies in hypercubes
KR102076550B1 (ko) * 2018-06-22 2020-02-12 주식회사 한글과컴퓨터 스프레드시트 편집 장치 및 방법
US11657217B2 (en) 2020-06-26 2023-05-23 Adaptam Inc. Methods and systems for presenting drop-down, pop-up or other presentation of a multi-value data set in a spreadsheet cell
US12450426B1 (en) * 2020-12-21 2025-10-21 Mehrdad Samadani Method and system for cellular computation and display
US11977835B2 (en) 2021-05-24 2024-05-07 Adaptam Inc. Method and system for spreadsheet error identification and avoidance
CN115658144B (zh) * 2022-12-09 2023-05-02 西安葡萄城软件有限公司 电子表格公式按需计算方法及装置

Family Cites Families (24)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6002865A (en) * 1992-05-28 1999-12-14 Thomsen; Erik C. Location structure for a multi-dimensional spreadsheet
US6138130A (en) * 1995-12-08 2000-10-24 Inventure Technologies, Inc. System and method for processing data in an electronic spreadsheet in accordance with a data type
US6055548A (en) * 1996-06-03 2000-04-25 Microsoft Corporation Computerized spreadsheet with auto-calculator
US5987481A (en) * 1997-07-01 1999-11-16 Microsoft Corporation Method and apparatus for using label references in spreadsheet formulas
US6134563A (en) * 1997-09-19 2000-10-17 Modernsoft, Inc. Creating and editing documents
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
EP1037157A1 (en) * 1999-03-05 2000-09-20 International Business Machines Corporation Method and system for processing different cell protection modes in an electronic spreadsheet
US6766509B1 (en) * 1999-03-22 2004-07-20 Oregon State University Methodology for testing spreadsheet grids
US6684010B1 (en) * 2000-03-03 2004-01-27 Digital Optics Corp. Wavelength compensated optical wavelength division coupler and associated methods
US8275974B2 (en) * 2001-01-16 2012-09-25 Outlooksoft Corporation Systems and methods providing dynamic spreadsheet functionality
US7251776B2 (en) * 2001-07-13 2007-07-31 Netview Technologies, Inc. System and method for efficiently and flexibly utilizing spreadsheet information
US7110779B2 (en) * 2004-01-29 2006-09-19 Harris Corporation Wireless communications system including a wireless device locator and related methods
US7213199B2 (en) * 2004-07-16 2007-05-01 Cognos Incorporated Spreadsheet user-interface for an enterprise planning system having multi-dimensional data store
US7676738B2 (en) * 2004-09-13 2010-03-09 Whitebirch Software, Inc. Scenario-dependent evaluation formula
US7415481B2 (en) * 2004-09-30 2008-08-19 Microsoft Corporation Method and implementation for referencing of dynamic data within spreadsheet formulas
US9047266B2 (en) * 2004-10-07 2015-06-02 International Business Machines Corporation Methods, systems and computer program products for processing cells in a spreadsheet
US7426688B2 (en) * 2004-11-02 2008-09-16 Hewlett-Packard Development Company, L.P. Embedded spreadsheet commands
US7451397B2 (en) * 2004-12-15 2008-11-11 Microsoft Corporation System and method for automatically completing spreadsheet formulas
US8621340B2 (en) * 2004-12-20 2013-12-31 Microsoft Corporation Block properties and calculated columns in a spreadsheet application
US8726143B2 (en) * 2005-01-14 2014-05-13 Microsoft Corporation System and method for a spreadsheet application supporting diverse formulaic functions
US8161372B2 (en) * 2005-12-09 2012-04-17 Microsoft Corporation Extensible value types in cells
JP4140919B2 (ja) * 2006-03-14 2008-08-27 インターナショナル・ビジネス・マシーンズ・コーポレーション 表計算などの処理を行うシステムおよびその方法
US8161373B2 (en) * 2007-08-06 2012-04-17 Apple Inc. Preventing the inclusion of a reference to a host cell in a formula

Also Published As

Publication number Publication date
US20090228776A1 (en) 2009-09-10
EP2266056A4 (en) 2018-01-03
AU2009220127A1 (en) 2009-09-11
RU2487402C2 (ru) 2013-07-10
IL207283A0 (en) 2010-12-30
CN101965564A (zh) 2011-02-02
EP2266056A1 (en) 2010-12-29
SG188806A1 (en) 2013-04-30
JP5451648B2 (ja) 2014-03-26
KR20100115818A (ko) 2010-10-28
MX2010009740A (es) 2010-09-28
CA2717072A1 (en) 2009-09-11
WO2009111116A1 (en) 2009-09-11
JP2011513857A (ja) 2011-04-28
ZA201005433B (en) 2011-10-26
RU2010136950A (ru) 2012-03-10
TW200939052A (en) 2009-09-16
AU2009220127B2 (en) 2014-03-06

Similar Documents

Publication Publication Date Title
BRPI0907608A2 (pt) Formulas dinâmicas para células de planilha
BRPI0921799A2 (pt) compostos que expandem células-tronco hematopoéticas
BRPI0920135A2 (pt) imidazopiridazinacarbonitrilos úteis como inibidores de quinase
DK2273984T3 (da) Lipidsammensætning
BRPI0822903A2 (pt) Autoconfiguração para células femto
SMP201100036B (it) Reattore elettrochimico
BRPI0909160A2 (pt) rolamentos
DE112009000578A5 (de) Reibahle
DE112009000730A5 (de) Gleitlager
BRPI0916632A2 (pt) método para composição de banner dinâmico
BRPI0814572A2 (pt) Célula de lítio
DK2379995T3 (da) Vejecelle
FI20080146L (fi) Liiskauspuristin
BRPI0915106A2 (pt) benzimidazóis substituídos para neurofibromatose
DK2289271T3 (da) Celleselektiv netværksadgang
BRPI0813726A2 (pt) Célula de lítio
PL2338012T3 (pl) Sonda geotermiczna
DE102008045464B8 (de) Lageranordnung
BRPI0920293A2 (pt) nacela
BRPI0909039A2 (pt) escareador
EP2300594A4 (en) ELECTROBIOCHEMICAL REACTOR
ES1069848Y (es) Soporte para laminados fotovoltaicos
EP2256754A4 (en) REACTOR
EP2379762A4 (en) CERMET
MA31558B1 (fr) Arriere-plan technologique

Legal Events

Date Code Title Description
B25A Requested transfer of rights approved

Owner name: MICROSOFT TECHNOLOGY LICENSING, LLC (US)

B06F Objections, documents and/or translations needed after an examination request according [chapter 6.6 patent gazette]
B06T Formal requirements before examination [chapter 6.20 patent gazette]
B11E Dismissal acc. art. 34 of ipl - requirements for examination incomplete
B11T Dismissal of application maintained [chapter 11.20 patent gazette]