WO2005036391A3 - Visual programming system and method - Google Patents

Visual programming system and method Download PDF

Info

Publication number
WO2005036391A3
WO2005036391A3 PCT/IB2004/002797 IB2004002797W WO2005036391A3 WO 2005036391 A3 WO2005036391 A3 WO 2005036391A3 IB 2004002797 W IB2004002797 W IB 2004002797W WO 2005036391 A3 WO2005036391 A3 WO 2005036391A3
Authority
WO
WIPO (PCT)
Prior art keywords
spreadsheet
objects
spreadsheets
definitions
programming
Prior art date
Application number
PCT/IB2004/002797
Other languages
French (fr)
Other versions
WO2005036391A2 (en
Inventor
Gunnlaugur Jonsson
Original Assignee
Einfalt Ehf
Gunnlaugur Jonsson
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 Einfalt Ehf, Gunnlaugur Jonsson filed Critical Einfalt Ehf
Priority to EP04769211A priority Critical patent/EP1678604A2/en
Publication of WO2005036391A2 publication Critical patent/WO2005036391A2/en
Publication of WO2005036391A3 publication Critical patent/WO2005036391A3/en

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00—Arrangements for software engineering
    • G06F8/30—Creation or generation of source code
    • G06F8/34—Graphical or visual programming
    • 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

Abstract

The present invention provides a user-friendly visual programming and modeling environment with a spreadsheet interface. The invention allows the creation of complex software applications and programs in real-time. A user with no programming skills can easily develop object-oriented software programs. Each spreadsheet can represent an object, and the object can interact and send messages to other objects, which can also be represented by spreadsheets. In addition to variables and formulas, the cells in the spreadsheets can contain commands, definitions of methods and definitions of functions. One column of a spreadsheet may also function similar to a code text editor. In another embodiment, the code can either be complied or translated within a spreadsheet program to create software applications. The invention may include features to make programming easier by including the ability to drag and drop coded objects from a spreadsheet into a form. In this way, different types of objects may be dynamically coded and compiled at runtime. The data of these objects can be directly linked to the data of the cells.
PCT/IB2004/002797 2003-10-09 2004-08-26 Visual programming system and method WO2005036391A2 (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
EP04769211A EP1678604A2 (en) 2003-10-09 2004-08-26 Visual programming system and method

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US10/682,441 US20050081141A1 (en) 2003-10-09 2003-10-09 Visual programming system and method
US10/682,441 2003-10-09

Publications (2)

Publication Number Publication Date
WO2005036391A2 WO2005036391A2 (en) 2005-04-21
WO2005036391A3 true WO2005036391A3 (en) 2006-03-02

Family

ID=34422529

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/IB2004/002797 WO2005036391A2 (en) 2003-10-09 2004-08-26 Visual programming system and method

Country Status (3)

Country Link
US (1) US20050081141A1 (en)
EP (1) EP1678604A2 (en)
WO (1) WO2005036391A2 (en)

Families Citing this family (38)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7251776B2 (en) * 2001-07-13 2007-07-31 Netview Technologies, Inc. System and method for efficiently and flexibly utilizing spreadsheet information
US7266763B2 (en) * 2002-11-26 2007-09-04 Microsoft Corporation User defined spreadsheet functions
US20050197942A1 (en) * 2003-12-09 2005-09-08 Allaway Steven M. Computerized valuation platform
US20050193379A1 (en) * 2004-01-26 2005-09-01 Richard Tanenbaum Program / method for converting spreadsheet models to callable, compiled routines
US20060090156A1 (en) * 2004-06-08 2006-04-27 Richard Tanenbaum Program / method for converting spreadsheet models to callable, compiled routines
US7761843B2 (en) * 2005-07-01 2010-07-20 Ronald Ortscheid Computer source code generator
US9501463B2 (en) * 2005-12-08 2016-11-22 Microsoft Technology Licensing, Llc Spreadsheet cell-based notifications
US7979801B2 (en) * 2006-06-30 2011-07-12 Microsoft Corporation Media presentation driven by meta-data events
US20080016253A1 (en) * 2006-07-11 2008-01-17 Boctor Design, Llc Graphical user interface for navigating and manipulating objects exposed by a host
US20080046861A1 (en) * 2006-08-15 2008-02-21 Grieser Maria A Method and interface for creating a workbook to implement a business process
US8726257B2 (en) * 2006-10-20 2014-05-13 Analog Devices, Inc File attributes for flexible linking
US8276059B2 (en) * 2007-03-30 2012-09-25 Sap Ag Displaying detailed information in the context of a condensed enumeration of information
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
US8812950B2 (en) * 2007-12-31 2014-08-19 Sap Ag Spreadsheet software services
US7770122B1 (en) 2010-04-29 2010-08-03 Cheman Shaik Codeless dynamic websites including general facilities
US20150033105A1 (en) * 2010-05-25 2015-01-29 Diarmuid Pigott System and Method of translation management, including concurrent user-directed presentation and execution of normalised and Romanised function and function parameter names, within Microsoft Excel for Windows (Excel) for non-English and non-Roman script languages.
US9075787B2 (en) * 2010-11-30 2015-07-07 Think-Cell Software Gmbh Defining a reusable spreadsheet-function by extracting the function from a complex calculation in a spreadsheet document
US9053082B2 (en) * 2011-11-03 2015-06-09 Knowledge Inside Spreadsheet data processing method and system
US10509858B1 (en) * 2015-03-15 2019-12-17 Sigma Sciences Limited Data processing in spreadsheet worksheets
US11170165B1 (en) 2015-03-15 2021-11-09 Sigma Sciences Limited Data processing in spreadsheet worksheets
US10540152B1 (en) 2016-09-23 2020-01-21 Massachusetts Mutual Life Insurance Company Systems, devices, and methods for software coding
US11210459B1 (en) * 2016-09-23 2021-12-28 Massachusetts Mutual Life Insurance Company Systems, devices, and methods for software coding
US11138370B1 (en) * 2016-09-23 2021-10-05 Massachusetts Mututal Life Insurance Company Modifying and using spreadsheets to create a GUI on another device
US11188710B2 (en) * 2016-12-30 2021-11-30 Dropbox, Inc. Inline content item editor commands
US10496737B1 (en) 2017-01-05 2019-12-03 Massachusetts Mutual Life Insurance Company Systems, devices, and methods for software coding
KR101843831B1 (en) * 2017-02-10 2018-03-30 주식회사 씨앤알테크 Unplugged Real Coding Block
US11250343B2 (en) 2017-06-08 2022-02-15 Sap Se Machine learning anomaly detection
US10929421B2 (en) 2017-06-08 2021-02-23 Sap Se Suggestion of views based on correlation of data
US10705805B1 (en) 2017-12-12 2020-07-07 Amazon Technologies, Inc. Application authoring using web-of-sheets data model
US11586603B1 (en) 2018-05-23 2023-02-21 Amazon Technologies, Inc. Index sheets for robust spreadsheet-based applications
US10936804B2 (en) 2018-07-27 2021-03-02 Microsoft Technology Licensing, Llc Spreadsheet cell calculation view providing multiple-representation editing
CN109558171B (en) * 2018-12-04 2023-01-10 白华 Method for defining and controlling computer by using electronic form
US11610059B2 (en) 2018-12-07 2023-03-21 Interject Data System, Inc. Systems and methods for a visual interface for grid-based programs
US11294645B2 (en) 2019-04-02 2022-04-05 Gavriel Loria Visual virtual programming machine for real-time interactive creation, playback, execution, inspection and manipulation of programming elements
KR102252206B1 (en) * 2019-12-30 2021-05-17 (주)비아이매트릭스 A task automation system using object action on the Exel sheet
US11848976B2 (en) * 2020-06-30 2023-12-19 Oracle International Corporation Custom action invocation in a speadsheet integrated with web services
US20220092534A1 (en) * 2020-09-18 2022-03-24 International Business Machines Corporation Event-based risk assessment
CN112765934B (en) * 2021-01-20 2022-07-19 山东师范大学 Indentation teaching demonstration system and method for table formula

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5680557A (en) * 1994-02-16 1997-10-21 The United States Of America As Represented By The Secretary Of The Army Natural computing system
WO2001059406A1 (en) * 2000-02-11 2001-08-16 Embedded Lab Technologies, Llc Virtual instrumentation system and method
US6286017B1 (en) * 1995-02-22 2001-09-04 EGILSSON áGUST SVERRIR Graphical environment for managing and developing applications

Family Cites Families (13)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5255363A (en) * 1990-06-19 1993-10-19 Mentor Graphics Corporation Graph-based programming system and associated method
US5293615A (en) * 1990-11-16 1994-03-08 Amada Carlos A Point and shoot interface for linking database records to spreadsheets whereby data of a record is automatically reformatted and loaded upon issuance of a recalculation command
US5721847A (en) * 1994-10-21 1998-02-24 Microsoft Corporation Method and system for linking controls with cells of a spreadsheet
US5724589A (en) * 1995-10-13 1998-03-03 Borland International, Inc. Development system with a property-method-event programming model for developing context-free reusable software components
US6243721B1 (en) * 1997-01-31 2001-06-05 Microsoft Corporation Method and apparatus for providing automatic layout capabilities for computer forms
US6301585B1 (en) * 1999-03-17 2001-10-09 Sun Microsystems, Inc. Redundancy elimination in the persistence of object graphs
US6690401B1 (en) * 1999-07-22 2004-02-10 At&T Corp. Method and apparatus for cell scrolling a data structure
US7146561B2 (en) * 2000-07-13 2006-12-05 International Business Machines Corporation Method and system in an electronic spreadsheet for comparing series of cells
US7206997B2 (en) * 2000-12-18 2007-04-17 General Motors Corporation Functional visualization of spreadsheets
US6779151B2 (en) * 2001-01-05 2004-08-17 Microsoft Corporation Storing objects in a spreadsheet
US8621385B2 (en) * 2004-05-21 2013-12-31 Sap Ag System and method for controlling a display of data
US8621340B2 (en) * 2004-12-20 2013-12-31 Microsoft Corporation Block properties and calculated columns in a spreadsheet application
US20060224946A1 (en) * 2005-03-31 2006-10-05 International Business Machines Corporation Spreadsheet programming

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5680557A (en) * 1994-02-16 1997-10-21 The United States Of America As Represented By The Secretary Of The Army Natural computing system
US6286017B1 (en) * 1995-02-22 2001-09-04 EGILSSON áGUST SVERRIR Graphical environment for managing and developing applications
WO2001059406A1 (en) * 2000-02-11 2001-08-16 Embedded Lab Technologies, Llc Virtual instrumentation system and method

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
P. GÄNG, A. KAMENZ, H. VONHOEGEN: "AUTOMATISATION AVEC DES MACROS", LE GRAND LIVRE DE EXCEL 5, 1994, PARIS, pages 851 - 858, XP002360093, ISBN: 2-7429-0163-9 *
UNKNOWN: "FOR (MACRO SHEETS ONLY)", EXCEL MACRO HELP FILE, 31 October 2001 (2001-10-31), INTERNET, pages 1 - 1, XP002360094, Retrieved from the Internet <URL:http://web.archive.org/web/20011212233743/www.xl-logic.com/xl_files/addins/macro_fun.zip> [retrieved on 20051216] *

Also Published As

Publication number Publication date
US20050081141A1 (en) 2005-04-14
WO2005036391A2 (en) 2005-04-21
EP1678604A2 (en) 2006-07-12

Similar Documents

Publication Publication Date Title
WO2005036391A3 (en) Visual programming system and method
WO2008058159A3 (en) System and method for creating integrated web form and database applications
ATE344510T1 (en) COMPUTER METHOD AND APPARATUS FOR CREATING VISIBLE GRAPHICS USING GRAPH ALGEBRA
WO2011084875A3 (en) Creating inferred symbols from code usage
WO2011159443A3 (en) Creating text functions from a spreadsheet
WO2005114394A3 (en) Graphical data flow programming environment with first model of computation that includes a structure supporting second model of computation
WO2006058207A3 (en) Model-driven user interview
AR047885A1 (en) VIRTUAL FILE SYSTEM
DE60116788D1 (en) PLC WITH INTEGRATED WEBSERVER
WO2007076098A3 (en) Digital effects analysis in modeling environments
WO2005029324A3 (en) Automated source code software programmer&#39;s manual generator
MX2009005757A (en) Managed execution environment for software application interfacing.
MY136473A (en) System and method for defining and using subclasses declaratively within markup
WO2006038132A3 (en) Parsing and handling events from .net objects
WO2002037268A3 (en) Dialogue flow interpreter development tool
EP2090994A3 (en) System, method and computer program product for computer modeling with generative components
WO2007136684A3 (en) Action languages for unified modeling language model
Mollet Remote and Telerobotics
Billings et al. Anthropogenic Declines in Deep Roots Constrain Deep Soil Organic Carbon Forms and Fluxes
Wortmann BMTK-A python based box modeling toolkit for teaching Earth System Science
Evans et al. A subsurface hydrology model that traces oxygen isotopes
Perry When is a process model not a process model: a comparison between UML and BPMN
Savenije Advances in hydrological modelling based on improvement in process and system understanding
Hicke et al. Predictive Modeling of Forest Insects in Ecosystem Models: Challenges and Progress
Barton Scenarios to Models: Towards Integrating Human and Earth Systems

Legal Events

Date Code Title Description
AK Designated states

Kind code of ref document: A2

Designated state(s): AE AG AL AM AT AU AZ BA BB BG BR BW BY BZ CA CH CN CO CR CU CZ DE DK DM DZ EC EE EG ES FI GB GD GE GH GM HR HU ID IL IN IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MA MD MG MK MN MW MX MZ NA NI NO NZ OM PG PH PL PT RO RU SC SD SE SG SK SL SY TJ TM TN TR TT TZ UA UG US UZ VC VN YU ZA ZM ZW

AL Designated countries for regional patents

Kind code of ref document: A2

Designated state(s): BW GH GM KE LS MW MZ NA SD SL SZ TZ UG ZM ZW AM AZ BY KG KZ MD RU TJ TM AT BE BG CH CY CZ DE DK EE ES FI FR GB GR HU IE IT LU MC NL PL PT RO SE SI SK TR BF BJ CF CG CI CM GA GN GQ GW ML MR NE SN TD TG

121 Ep: the epo has been informed by wipo that ep was designated in this application
WWE Wipo information: entry into national phase

Ref document number: 2004769211

Country of ref document: EP

WWP Wipo information: published in national office

Ref document number: 2004769211

Country of ref document: EP