CN102939585B - 根据电子表格创建文本函数 - Google Patents
根据电子表格创建文本函数 Download PDFInfo
- Publication number
- CN102939585B CN102939585B CN201180029494.0A CN201180029494A CN102939585B CN 102939585 B CN102939585 B CN 102939585B CN 201180029494 A CN201180029494 A CN 201180029494A CN 102939585 B CN102939585 B CN 102939585B
- Authority
- CN
- China
- Prior art keywords
- cell
- value
- result
- action
- electrical form
- 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.)
- Active
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
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/40—Transformation of program code
- G06F8/41—Compilation
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Stored Programmes (AREA)
- Devices For Executing Special Programs (AREA)
Abstract
Description
Claims (13)
Applications Claiming Priority (3)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US12/815,801 US8499290B2 (en) | 2010-06-15 | 2010-06-15 | Creating text functions from a spreadsheet |
US12/815,801 | 2010-06-15 | ||
PCT/US2011/037965 WO2011159443A2 (en) | 2010-06-15 | 2011-05-25 | Creating text functions from a spreadsheet |
Publications (2)
Publication Number | Publication Date |
---|---|
CN102939585A CN102939585A (zh) | 2013-02-20 |
CN102939585B true CN102939585B (zh) | 2016-06-29 |
Family
ID=45097323
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201180029494.0A Active CN102939585B (zh) | 2010-06-15 | 2011-05-25 | 根据电子表格创建文本函数 |
Country Status (5)
Country | Link |
---|---|
US (1) | US8499290B2 (zh) |
EP (1) | EP2583169A4 (zh) |
CN (1) | CN102939585B (zh) |
HK (1) | HK1180054A1 (zh) |
WO (1) | WO2011159443A2 (zh) |
Families Citing this family (15)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US8365143B2 (en) * | 2010-06-15 | 2013-01-29 | Microsoft Corporation | Dynamic languages for static hosts |
US8631387B2 (en) * | 2011-03-31 | 2014-01-14 | Coral Networks, Inc. | System and method for the structuring and interpretation of organic computer programs |
JP5758534B1 (ja) * | 2014-09-09 | 2015-08-05 | インテグラート株式会社 | シミュレーションシステム、シミュレーション方法及びシミュレーションプログラム |
US10997364B2 (en) | 2015-11-02 | 2021-05-04 | Microsoft Technology Licensing, Llc | Operations on sound files associated with cells in spreadsheets |
US10175955B2 (en) | 2016-01-13 | 2019-01-08 | Hamilton Sundstrand Space Systems International, Inc. | Spreadsheet tool manager for collaborative modeling |
EP3411800A1 (en) * | 2016-02-01 | 2018-12-12 | Microsoft Technology Licensing, LLC | Parameterizing and working with math equations in a spreadsheet application |
US10691881B2 (en) | 2016-02-08 | 2020-06-23 | International Business Machines Corporation | Spreadsheet compiler for stream processing |
US10255262B2 (en) | 2016-02-08 | 2019-04-09 | International Business Machines Corporation | Encoding a spreadsheet program for stream processing |
US11354305B2 (en) * | 2018-06-13 | 2022-06-07 | Oracle International Corporation | User interface commands for regular expression generation |
US11941018B2 (en) | 2018-06-13 | 2024-03-26 | Oracle International Corporation | Regular expression generation for negative example using context |
US11263247B2 (en) | 2018-06-13 | 2022-03-01 | Oracle International Corporation | Regular expression generation using longest common subsequence algorithm on spans |
US11580166B2 (en) * | 2018-06-13 | 2023-02-14 | Oracle International Corporation | Regular expression generation using span highlighting alignment |
US20240070382A1 (en) * | 2018-10-15 | 2024-02-29 | Dayal Family LLC | Method and System for Dynamic Naming of Component Expressions Within a Formula in a Cell in a Spreadsheet Application |
CN109857384A (zh) * | 2018-11-21 | 2019-06-07 | 江苏方天电力技术有限公司 | 一种热工指标在线计算的编码方法 |
CN115658144B (zh) * | 2022-12-09 | 2023-05-02 | 西安葡萄城软件有限公司 | 电子表格公式按需计算方法及装置 |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5581760A (en) * | 1992-07-06 | 1996-12-03 | Microsoft Corporation | Method and system for referring to and binding to objects using identifier objects |
CN1821993A (zh) * | 2006-03-24 | 2006-08-23 | 无锡永中科技有限公司 | 基于时间序列的电子表格数据处理方法 |
US7519962B2 (en) * | 2004-10-07 | 2009-04-14 | Thomson Financial Llc | Command script parsing using local and extended storage for command lookup |
Family Cites Families (27)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5481708A (en) * | 1992-06-05 | 1996-01-02 | Borland International, Inc. | System and methods for optimizing object-oriented compilations |
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 |
US6314559B1 (en) * | 1997-10-02 | 2001-11-06 | Barland Software Corporation | Development system with methods for assisting a user with inputting source code |
US6526566B1 (en) * | 1997-11-14 | 2003-02-25 | National Instruments Corporation | Graphical programming system and method including nodes for programmatically accessing data sources and targets |
US6237136B1 (en) * | 1997-12-02 | 2001-05-22 | National Instruments Corporation | System and method for automatically creating source code example files for an application program in a plurality of programming languages |
US6311327B1 (en) * | 1998-03-02 | 2001-10-30 | Applied Microsystems Corp. | Method and apparatus for analyzing software in a language-independent manner |
US6226783B1 (en) * | 1998-03-16 | 2001-05-01 | Acuity Imaging, Llc | Object oriented method of structuring a software step program |
US6714936B1 (en) * | 1999-05-25 | 2004-03-30 | Nevin, Iii Rocky Harry W. | Method and apparatus for displaying data stored in linked nodes |
US7117435B1 (en) | 2000-06-21 | 2006-10-03 | Microsoft Corporation | Spreadsheet fields in text |
US6766512B1 (en) | 2000-11-22 | 2004-07-20 | Furraylogic Ltd. | Methods and systems for generating a structured language model from a spreadsheet model |
US7010779B2 (en) | 2001-08-16 | 2006-03-07 | Knowledge Dynamics, Inc. | Parser, code generator, and data calculation and transformation engine for spreadsheet calculations |
US20030226105A1 (en) * | 2002-05-29 | 2003-12-04 | Mattias Waldau | Method in connection with a spreadsheet program |
US20040064470A1 (en) * | 2002-08-02 | 2004-04-01 | Jedox Gmbh | Method for generating a stand-alone multi-user application from predefined spreadsheet logic |
US7266763B2 (en) | 2002-11-26 | 2007-09-04 | Microsoft Corporation | User defined spreadsheet functions |
US7765540B2 (en) * | 2003-10-23 | 2010-07-27 | Microsoft Corporation | Use of attribution to describe management information |
US7827527B1 (en) * | 2004-02-12 | 2010-11-02 | Chiluvuri Raju V | System and method of application development |
US7761858B2 (en) * | 2004-04-23 | 2010-07-20 | Microsoft Corporation | Semantic programming language |
US7506304B2 (en) * | 2004-05-14 | 2009-03-17 | National Instruments Corporation | Graphical data flow programming environment with first model of computation that includes a structure supporting second model of computation |
US20060090156A1 (en) * | 2004-06-08 | 2006-04-27 | Richard Tanenbaum | Program / method for converting spreadsheet models to callable, compiled routines |
US7793273B2 (en) * | 2004-11-23 | 2010-09-07 | National Instruments Corporation | Type propagation for automatic casting of output types in a data flow program |
US8799857B2 (en) * | 2005-04-29 | 2014-08-05 | Microsoft Corporation | XML application framework |
US7840889B2 (en) | 2007-04-02 | 2010-11-23 | Business Objects Software Ltd. | Apparatus and method for generating spreadsheet function source code for use in a source code application |
US20090172063A1 (en) | 2007-12-26 | 2009-07-02 | Microsoft Corporation | Multi-Threaded Codeless User-Defined Functions |
US20090228776A1 (en) * | 2008-03-05 | 2009-09-10 | Microsoft Corporation | Dynamic formulas for spreadsheet cells |
US9229922B2 (en) | 2008-09-30 | 2016-01-05 | Apple Inc. | Token representation of references and function arguments |
US8296744B2 (en) * | 2008-10-03 | 2012-10-23 | Microsoft Corporation | Tree-based directed graph programming structures for a declarative programming language |
US20100095195A1 (en) | 2008-10-15 | 2010-04-15 | Apple Inc. | Defining spreadsheet functions |
-
2010
- 2010-06-15 US US12/815,801 patent/US8499290B2/en active Active
-
2011
- 2011-05-25 WO PCT/US2011/037965 patent/WO2011159443A2/en active Application Filing
- 2011-05-25 EP EP11796139.1A patent/EP2583169A4/en not_active Ceased
- 2011-05-25 CN CN201180029494.0A patent/CN102939585B/zh active Active
-
2013
- 2013-06-17 HK HK13107047.3A patent/HK1180054A1/zh unknown
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5581760A (en) * | 1992-07-06 | 1996-12-03 | Microsoft Corporation | Method and system for referring to and binding to objects using identifier objects |
US7519962B2 (en) * | 2004-10-07 | 2009-04-14 | Thomson Financial Llc | Command script parsing using local and extended storage for command lookup |
CN1821993A (zh) * | 2006-03-24 | 2006-08-23 | 无锡永中科技有限公司 | 基于时间序列的电子表格数据处理方法 |
Also Published As
Publication number | Publication date |
---|---|
HK1180054A1 (zh) | 2013-10-11 |
EP2583169A4 (en) | 2017-12-20 |
US20110307874A1 (en) | 2011-12-15 |
WO2011159443A2 (en) | 2011-12-22 |
US8499290B2 (en) | 2013-07-30 |
CN102939585A (zh) | 2013-02-20 |
EP2583169A2 (en) | 2013-04-24 |
WO2011159443A3 (en) | 2012-04-05 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN102939585B (zh) | 根据电子表格创建文本函数 | |
Budde et al. | JANI: quantitative model and tool interaction | |
Schulz | System description: E 1.8 | |
US10095602B2 (en) | Automated code analyzer | |
Urban et al. | First neural conjecturing datasets and experiments | |
CN108885632A (zh) | 用于实时数据流编程的高效状态机 | |
Welsh et al. | Self-explanation in adaptive systems based on runtime goal-based models | |
CN102314481B (zh) | 丰富的站点图 | |
JP2019133621A (ja) | Apiドキュメンテーションの収集 | |
CN108804688A (zh) | 一种游戏资源引用关系的查找以及优化方法 | |
Zuzak et al. | A finite-state machine approach for modeling and analyzing restful systems | |
Narayanan et al. | ADIC2: Development of a component source transformation system for differentiating C and C++ | |
Rodrigues et al. | Model-driven approach for building efficient wireless sensor and actuator network applications | |
Su et al. | Code synthesis for dataflow-based embedded software design | |
Boring et al. | Human performance modeling for dynamic human reliability analysis | |
Ciancone et al. | The KlaperSuite framework for model-driven reliability analysis of component-based systems | |
Ganzha et al. | Multiagent systems and applications | |
Ďurčík et al. | Transformation of ontological represented web service composition problem into a planning one | |
Prackwieser et al. | Overcoming heterogeneity in business process modeling with rule-based semantic mappings | |
Talanov et al. | Automating programming via concept mining, probabilistic reasoning over semantic knowledge base of SE domain | |
Zhao et al. | Using deep learning to improve the accuracy of requirements to code traceability | |
Gillieson | A framework for graphic description in book design | |
Mohamed et al. | Semantic-based Social Media Threats Detection | |
Zhao et al. | A survey on semantic scientific workflow | |
Giraldo et al. | Integrating Technical Debt into MDE. |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
REG | Reference to a national code |
Ref country code: HK Ref legal event code: DE Ref document number: 1180054 Country of ref document: HK |
|
ASS | Succession or assignment of patent right |
Owner name: MICROSOFT TECHNOLOGY LICENSING LLC Free format text: FORMER OWNER: MICROSOFT CORP. Effective date: 20150729 |
|
C41 | Transfer of patent application or patent right or utility model | ||
TA01 | Transfer of patent application right |
Effective date of registration: 20150729 Address after: Washington State Applicant after: Micro soft technique license Co., Ltd Address before: Washington State Applicant before: Microsoft Corp. |
|
C14 | Grant of patent or utility model | ||
GR01 | Patent grant | ||
REG | Reference to a national code |
Ref country code: HK Ref legal event code: GR Ref document number: 1180054 Country of ref document: HK |