WO2008107665A3 - A graphical user interface for use in integrating programming functions with spreadsheet applications - Google Patents

A graphical user interface for use in integrating programming functions with spreadsheet applications Download PDF

Info

Publication number
WO2008107665A3
WO2008107665A3 PCT/GB2008/000733 GB2008000733W WO2008107665A3 WO 2008107665 A3 WO2008107665 A3 WO 2008107665A3 GB 2008000733 W GB2008000733 W GB 2008000733W WO 2008107665 A3 WO2008107665 A3 WO 2008107665A3
Authority
WO
WIPO (PCT)
Prior art keywords
cells
code
region
grid region
content
Prior art date
Application number
PCT/GB2008/000733
Other languages
French (fr)
Other versions
WO2008107665A2 (en
Inventor
Giles Thomas
Patrick Kemmis
Robert Smithson
William Reade
Michael Foord
Andrzej Krzywda
Original Assignee
Resolver Systems Ltd
Giles Thomas
Patrick Kemmis
Robert Smithson
William Reade
Michael Foord
Andrzej Krzywda
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 Resolver Systems Ltd, Giles Thomas, Patrick Kemmis, Robert Smithson, William Reade, Michael Foord, Andrzej Krzywda filed Critical Resolver Systems Ltd
Publication of WO2008107665A2 publication Critical patent/WO2008107665A2/en
Publication of WO2008107665A3 publication Critical patent/WO2008107665A3/en

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

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)
  • User Interface Of Digital Computer (AREA)
  • Stored Programmes (AREA)

Abstract

A graphical user interface (GUI) for interacting with a user, the GUI comprising: a grid region comprising a plurality of cells, the cells being arranged to receive content and to allow dependency relationships between cells to be created; a code region arranged to receive programming code; data entry means arranged to allow the user to either enter content to the cells of the grid region or programming code to the code region; program code means arranged to analyze the plurality of cells within the grid region, generate programming code representative of the grid region and to integrate the user-entered programming code contained within the code region and the programming code representative of the grid region into a resultant program; and output means arranged to output the resultant program wherein the program code means comprises code generation means arranged to: (i) traverse the plurality of cells in the grid region and identify content within the plurality of cells; (ii) determine dependency relationships between cells that contain content; and (iii) generate programming code representative of the dependency relationships and the content of the cells.
PCT/GB2008/000733 2007-03-05 2008-03-04 A graphical user interface for use in integrating programming functions with spreadsheet applications WO2008107665A2 (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
GB0704234.4 2007-03-05
GBGB0704234.4A GB0704234D0 (en) 2007-03-05 2007-03-05 Improvements relating to spreadsheet systems

Publications (2)

Publication Number Publication Date
WO2008107665A2 WO2008107665A2 (en) 2008-09-12
WO2008107665A3 true WO2008107665A3 (en) 2009-02-26

Family

ID=37965949

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/GB2008/000733 WO2008107665A2 (en) 2007-03-05 2008-03-04 A graphical user interface for use in integrating programming functions with spreadsheet applications

Country Status (2)

Country Link
GB (1) GB0704234D0 (en)
WO (1) WO2008107665A2 (en)

Families Citing this family (13)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8707156B2 (en) * 2009-04-02 2014-04-22 Business Objects, S.A. Render engine for spreadsheet
US9417890B2 (en) * 2013-04-12 2016-08-16 Microsoft Technology Licensing, Llc Compilation of transformation in recalculation user interface
US10325014B2 (en) 2015-04-30 2019-06-18 Workiva Inc. System and method for convergent document collaboration
US10255263B2 (en) 2015-05-18 2019-04-09 Workiva Inc. Data storage and retrieval system and method for storing cell coordinates in a computer memory
US9158832B1 (en) 2015-05-18 2015-10-13 Workiva Inc. Method and computing device for maintaining dependencies among reference elements
US12039258B2 (en) * 2018-10-15 2024-07-16 Dayal Family LLC Method and system for dynamic naming of component expressions within a formula in a cell in a spreadsheet application
US11449493B2 (en) * 2019-08-08 2022-09-20 Sap Se Persistent and configurable multidimensional data constraints
US11755825B2 (en) 2019-09-12 2023-09-12 Workiva Inc. Method, system, and computing device for facilitating private drafting
US11443108B2 (en) 2020-08-17 2022-09-13 Workiva Inc. System and method for document management using branching
US11100281B1 (en) 2020-08-17 2021-08-24 Workiva Inc. System and method for maintaining links and revisions
US11100277B1 (en) 2021-02-15 2021-08-24 Workiva Inc. Systems, methods, and computer-readable media for flow-through formatting for links
US11354362B1 (en) 2021-05-06 2022-06-07 Workiva Inc. System and method for copying linked documents
US11640495B1 (en) 2021-10-15 2023-05-02 Workiva Inc. Systems and methods for translation comments flowback

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US4398249A (en) * 1970-08-12 1983-08-09 Pardo Rene K Process and apparatus for converting a source program into an object program
US5893123A (en) * 1995-06-22 1999-04-06 Tuinenga; Paul W. System and method of integrating a spreadsheet and external program having output data calculated automatically in response to input data from the spreadsheet
US6104872A (en) * 1995-11-28 2000-08-15 Fujitsu Limited Macro program management system
US20040064470A1 (en) * 2002-08-02 2004-04-01 Jedox Gmbh Method for generating a stand-alone multi-user application from predefined spreadsheet logic

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US4398249A (en) * 1970-08-12 1983-08-09 Pardo Rene K Process and apparatus for converting a source program into an object program
US5893123A (en) * 1995-06-22 1999-04-06 Tuinenga; Paul W. System and method of integrating a spreadsheet and external program having output data calculated automatically in response to input data from the spreadsheet
US6104872A (en) * 1995-11-28 2000-08-15 Fujitsu Limited Macro program management system
US20040064470A1 (en) * 2002-08-02 2004-04-01 Jedox Gmbh Method for generating a stand-alone multi-user application from predefined spreadsheet logic

Non-Patent Citations (3)

* Cited by examiner, † Cited by third party
Title
DE HOON W A C A J ET AL: "Implementing a functional spreadsheet in Clean", JOURNAL OF FUNCTIONAL PROGRAMMING UK, vol. 5, July 1995 (1995-07-01), pages 383 - 414, XP002508379, ISSN: 0956-7968, Retrieved from the Internet <URL:http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.46.1465> [retrieved on 20081216] *
HANNA K: "Interactive visual functional programming", SIGPLAN NOTICES ACM USA, vol. 37, no. 9, September 2002 (2002-09-01), pages 145 - 156, XP002508378, ISSN: 0362-1340 *
YODER A G ET AL: "Real spreadsheets for real programmers", COMPUTER LANGUAGES, 1994., PROCEEDINGS OF THE 1994 INTERNATIONAL CONFE RENCE ON TOULOUSE, FRANCE 16-19 MAY 1994, LOS ALAMITOS, CA, USA,IEEE COMPUT. SOC, 16 May 1994 (1994-05-16), pages 20 - 30, XP010098771, ISBN: 978-0-8186-5640-8 *

Also Published As

Publication number Publication date
WO2008107665A2 (en) 2008-09-12
GB0704234D0 (en) 2007-04-11

Similar Documents

Publication Publication Date Title
WO2008107665A3 (en) A graphical user interface for use in integrating programming functions with spreadsheet applications
WO2008103823A3 (en) Advanced spreadsheet cell navigation
WO2013065004A3 (en) Electronic device power saving mode, associated apparatus and methods
WO2013064994A3 (en) Electric device power saving mode, associated apparatus and methods
WO2007087236A3 (en) Multiple conditional formatting
WO2012027691A3 (en) Graphical user interface system for a log analyzer
WO2008039815A3 (en) Systems and methods for providing a user interface
TW200733080A (en) Method of configuring storage device
Ramachandran et al. Mayavi2: 3D Scientific Data Visualization and Plottin'
Beck et al. Challenges to finding olivine on the surface of 4 Vesta
Finér et al. Tree species richness affecting fine root biomass in European forests
Wheatland Modelling magnetic flux ropes in solar, stellar, and laboratory contexts
Belabbassi et al. The Ocean Observatories Initiative: Data pre-Processing: Diagnostic Tools to Prepare Data for QA/QC Processing.
Duncanson et al. How important is individual tree information for biomass modeling and mapping?
Kaiser IMCAT: Image and Catalogue Manipulation Software
Vannoppen et al. Meta-analysis of the effects of plant roots in controlling concentrated flow erosion rates
Treiman et al. Lunar Cordierite-Spinel Troctolite: Igneous History, and Volatiles
McElhoney et al. The In-Situ Wet Chemical Analysis Laboratory and Sensor Array (CHEMSENS): The Next Generation Mars Soil Chemistry Analyzer
Deng et al. Analysis of Average Water Table Depth in TOPMODEL
Jandt et al. A comprehensive validation toolbox for regional ocean models-Outline, implementation and application to the Baltic Sea
Pinet et al. Mafic mineralogy of martian meteorites based on a systematic deconvolution using an improved Modified Gaussian Model (MGM) approach
Guidi et al. Reply to Comment on" A new procedure to optimize the selection of groups in a classification tree: Applications for ecological data"
Viviano et al. Using JMARS as a teaching tool in undergraduate planetary courses
Fung et al. The Modern Era of Research in Biosphere Atmosphere Interactions
Charmandaris Mid-Infrared Spectroscopic Diagnostics of Galactic Nuclei

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 08709590

Country of ref document: EP

Kind code of ref document: A2

NENP Non-entry into the national phase

Ref country code: DE

122 Ep: pct application non-entry in european phase

Ref document number: 08709590

Country of ref document: EP

Kind code of ref document: A2