A GRAPHICAL USER INTERFACE FOR USE IN INTEGRATING PROGRAMMING FUNCTIONS WITH SPREADSHEET APPLICATIONS

摘要

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.