WO2016126247A1 - Systèmes, procédés et articles pour application de tableur basé sur le web - Google Patents

Systèmes, procédés et articles pour application de tableur basé sur le web Download PDF

Info

Publication number
WO2016126247A1
WO2016126247A1 PCT/US2015/014462 US2015014462W WO2016126247A1 WO 2016126247 A1 WO2016126247 A1 WO 2016126247A1 US 2015014462 W US2015014462 W US 2015014462W WO 2016126247 A1 WO2016126247 A1 WO 2016126247A1
Authority
WO
WIPO (PCT)
Prior art keywords
spreadsheet
web
user
line
web application
Prior art date
Application number
PCT/US2015/014462
Other languages
English (en)
Inventor
Peter Thomas
Original Assignee
Intuit Inc.
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 Intuit Inc. filed Critical Intuit Inc.
Publication of WO2016126247A1 publication Critical patent/WO2016126247A1/fr

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
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/103—Formatting, i.e. changing of presentation of documents

Definitions

  • the invention relates to methods, systems and apparatus for a web-based (i.e., online) spreadsheet application, and more particularly, to new methods, systems and apparatus for a web-based spreadsheet program which allows for simplified creation, customization and data entry.
  • a computerized spreadsheet consists of a table of cells arranged into a two-dimensional array of rows and columns, in which each cell is configured to contain variable input data, constant data, formulas and/or functions.
  • the rows are labeled using numbers, 1, 2, 3, etc. and the columns are labeled using letters, A, B, C, etc., such that a single cell can be referred to by addressing its row and column labels, for example, "C9", which refers to the cell located in the third column and the 9th row.
  • a user interacts with a spreadsheet mainly through the cells by selecting one or more cells of a displayed array of cells (e.g. an array of cells in 20 rows by 25 columns) and entering data, such as alphanumeric text, formulas, and/or functions into the cells.
  • a spreadsheet may be created for a particular purpose, such as for accounting or bookkeeping task or other desired calculation or analysis, using certain cells for inputting variable data such that calculations can be conveniently performed on various different data sets.
  • a cell might include text which is a heading or label, or a date.
  • a spreadsheet may be created for multiple users and/or for multiple data sets. For example, a spreadsheet may be created for data entry users to enter numerous different data sets into the spreadsheet and to obtain a resulting calculated spreadsheet for each data set.
  • a spreadsheet may be created for data entry users to enter numerous different data sets into the spreadsheet and to obtain a resulting calculated spreadsheet for each data set.
  • Embodiments of the present invention are directed to methods, systems and articles of manufacture for creating an electronic spreadsheet using a web-based spreadsheet application.
  • the spreadsheet is configured for inputting input data into the spreadsheet and performing one or more calculations using the input data.
  • the invention is direct to a system for providing a web-based spreadsheet website accessible through the internet.
  • the system is implemented on a webserver hosting a web-based spreadsheet website accessible through the internet.
  • the webserver comprises one or more computer processors, memory, data storage, and a network adapter (an internet communication device) for providing access to the web-based spreadsheet website through the internet.
  • the web-based spreadsheet website is configured to transmit a spreadsheet web application to a user computing device via the internet.
  • the user computing device may be any suitable computing device having a web browser and capable of connecting to the internet, such as a personal computer, a tablet computer, a cellular phone, a smart phone, a hand-held computer, or the like.
  • the spreadsheet web application is in a web-browser programming language and is configured to program the web-browser of the computing device to display and execute the spreadsheet web application.
  • the spreadsheet web application running on the web-browser is configured to display and execute a spreadsheet web interface having a design section having a plurality of user-selectable spreadsheet commands and functions for creating a spreadsheet.
  • the web interface may also have a preview panel separate from the design section which displays a spreadsheet preview of a spreadsheet in an end-user mode as the spreadsheet is being created by the user in the design section.
  • the spreadsheet web application may be further configured to allow test data to be entered into the spreadsheet preview.
  • the spreadsheet preview calculates the spreadsheet according to a design of a spreadsheet in the design section. In this way, the user can see how the spreadsheet looks and how it functions while creating the spreadsheet.
  • the spreadsheet web application may be configured to create a spreadsheet in a line by line sequence without a starting grid of rows and columns.
  • the rows and/or columns of the spreadsheet are formed only as the rows and/or columns are added to the spreadsheet by the user in the design section. For example, the user may select a command to add a row to the spreadsheet, and only then is the row added to the spreadsheet.
  • the spreadsheet web application may be configured with an embedded worksheet function to embed a worksheet within a particular line (or cell) of a main spreadsheet, called a first or referencing spreadsheet.
  • the embedded worksheet function creates an embedded worksheet comprising a different spreadsheet, called a referenced spreadsheet, in which a value of the referenced worksheet is used by the particular line in executing the referencing spreadsheet.
  • the spreadsheet web application may also be configured to recursively embed referenced spreadsheets.
  • the spreadsheet web application may be configured to display the embedded worksheet in the particular line of the referencing spreadsheet which references the embedded worksheet.
  • the web-based spreadsheet website may be further configured to facilitate use of a spreadsheet created using the spreadsheet web application by one or more end-users.
  • the website is configured to receive from the user a spreadsheet created using the spreadsheet web application, via the internet.
  • the website then generates an end-user spreadsheet application of the spreadsheet.
  • the end-user spreadsheet application is configured to display and execute the spreadsheet with one or more fields of the first spreadsheet locked from being modified by the end-user, and one or more fields which allow the user to enter end-user data.
  • the website is also configured to transmit the end-user spreadsheet application to a web-browser of an end-user computing device.
  • the present invention is directed to a system for executing the spreadsheet web application.
  • the system comprises a computing device (e.g. a personal computer, tablet computer, smartphone, etc.) having a computer processor, memory, data storage and a network communication adapter capable of accessing the internet.
  • the computing device further comprises a web-browser and a spreadsheet web application in a web-browser programming language which is programs the web-browser to execute the spreadsheet we application.
  • the spreadsheet web application is configured to display and execute a web spreadsheet interface comprising a design section having plurality of user- selectable commands and functions for creating a spreadsheet.
  • the spreadsheet web application comprises one or more of the additional features as described above for the web-server based system.
  • the spreadsheet web application may include the separate preview panel, the test data feature, the line by line building of a spreadsheet without a starting grid of rows and columns, the embedded spreadsheet feature, the embedded worksheet display within a line feature, or any combination of two or more of the additional features.
  • Another embodiment of the present invention is directed to computer- implemented methods for creating an electronic spreadsheet using a web-based spreadsheet application.
  • the method may include a web-server hosting a web-based spreadsheet website, same or similar to the system described above, transmitting a spreadsheet web application to a user computing device via the internet.
  • the spreadsheet web application is in a web-browser programming language and is configured to program a web-browser of the computing device to display and execute the spreadsheet web application.
  • the spreadsheet web application is configured to display and execute a spreadsheet web interface having a design section having a plurality of user-selectable spreadsheet commands and functions for creating a spreadsheet.
  • the spreadsheet application is also configured to include one or more of the additional features as described above for the web-server based system and computing device system, including the separate preview panel, the test data feature, the line by line building of a spreadsheet without a starting grid of rows and columns, the embedded spreadsheet feature, the embedded worksheet display within a line feature, or any combination of two or more of the additional features.
  • the web interface may also have a preview panel separate from the design section which displays a spreadsheet preview of a spreadsheet in an end-user mode as the spreadsheet is being created by the user in the design section.
  • Another embodiment of the present invention is directed to an article of manufacture comprising a non-transitory computer readable medium embodying instructions executable by a computer to execute a process according to any of the method embodiments of the present invention for creating an electronic spreadsheet using a web-based spreadsheet application.
  • the non-transitory computer readable medium embodying instructions executable by a computer may be configured to execute a process comprising: transmitting a spreadsheet web application to a web-browser of a user computing device via the internet, the spreadsheet web application in a web-browser programming language for programming the web-browser to execute the spreadsheet web application, the web-server comprising one or more computer processors, memory and data storage and hosting a web- based spreadsheet website; and wherein the spreadsheet web application is configured to display and execute on the user computing device a spreadsheet web interface comprising a design section having a plurality of user-selectable spreadsheet commands and functions for creating a spreadsheet.
  • the spreadsheet web application is configured to include one or more of the additional features as described above for the web-server based system and computing device system, including the separate preview panel, the test data feature, the line by line building of a spreadsheet without a starting grid of rows and columns, the embedded spreadsheet feature, the embedded worksheet display within a line feature, or any combination of two or more of the additional features.
  • FIG. 1 illustrates a block diagram o an exemplary system for creating an electronic spreadsheet using a web-based spreadsheet application, according to one embodiment of the present invention
  • FIG. 2 is a block diagram of a computing device (computer) which may be utilized in the system of Fig. 1;
  • Figs. 3-18 are various screen shots from a spreadsheet web application, according to one embodiment of the present invention.
  • Embodiments of the present invention are directed to methods, systems and articles of manufacture for creating an electronic spreadsheet using a web-based spreadsheet application.
  • a web-server hosting a web-based spreadsheet website comprises one or more computer(s) having at least one computer processor, memory, data storage and a network communication device (e.g. a network adapter).
  • the web-server is configured to transmit a spreadsheet web application to a user computing device (e.g. a personal computer, tablet computer, smartphone, etc.) having a web-browser via the internet.
  • the spreadsheet web application is configured to program the web-browser of the computing device to display and execute a spreadsheet web application having various features and functionality, including one or more of a separate design section and preview panel, a test data feature, line by line building of a spreadsheet without a starting grid of rows and columns, an embedded spreadsheet feature, an embedded worksheet display within a line feature, or any combination of these features.
  • a block diagram of a web-based spreadsheet system 100 for creating an electronic spreadsheet using a web-based spreadsheet application is shown.
  • the system 100 comprises a web-server 102 hosting a web-based spreadsheet website 104 which is accessible by a user computer 1 16 via the internet 1 10.
  • the web-based spreadsheet website 104 comprises web pages and software programming for providing a web-based spreadsheet website.
  • the web-based spreadsheet website may include a welcome page, log-in functionality for accessing the website, and other website content.
  • the web-server 102 also comprises one or more computer(s) 108 having one or more computer processor(s), and computer hardware 109, such as memory, data storage and networking hub and/or network adapters for communicating with a user computer 1 16 via the internet 110.
  • the web-server 102 also comprises a web-based spreadsheet web application 106 which is in a web-browser programming language.
  • the web-browser programming language may be any suitable programming language, or combination of programming languages, such as JAVA, JAVASCRIPT, HTML or other scripting language for a web-browser.
  • the web- based spreadsheet web application 106 is configured to program a web-browser 1 18 of the user computer 1 16 to execute and display the spreadsheet web application 106 on the user computer 116.
  • the user computer 116 may be any type of computing device having a computer processor, memory, a network adapter for communicating over a communication network including the internet (collectively, computer hardware 122), a display 120 for displaying graphics (e.g. an LCD display, LED display, CRT display, etc.) and an input device 124 (e.g. a mouse, touchpad, touchscreen, keyboard, etc).
  • the user computer 1 16 may be a personal computer, a tablet computer, a cellular phone, a smartphone, a handheld computer, or the like.
  • the user computer 116 also has a web-browser 1 18 for browsing the internet and executing web applications configured for operating on a web-browser.
  • the network adapter may be any suitable network adapter for providing a connection to the internet, such as an ethernet adapter, WiFi adapter, Bluetooth adapter, cellular data transceiver (sometime called a cellular transceiver chip), etc.
  • Fig. 2 generally shows a block diagram of the components of an example of a computer (computing device) 200 that may be used as the computer in the computers and servers identified in the system 100 of Fig. 1, such as the computer(s) 108 of the web-server 102 and user computer 116.
  • the computer 200 includes a memory 210, a software program(s) 212, a processor or controller 214 to execute the software program(s) 212, a network or communications interface 216, e.g., for communications with a network or interconnect 218 between the components.
  • the memory 210 may be or include one or more of cache, RAM, ROM, SRAM, DRAM, RDRAM, EEPROM, SDRAM and other types of volatile or non-volatile memory capable of storing data.
  • the processor unit 214 may be or include multiple processors, a single threaded processor, a multi-threaded processor, a multi- core processor, or other type of processor capable of processing data.
  • the interconnect 218 may include a system bus, LDT, PCI, ISA, or other types of buses, and the communications or network interface may, for example, be an Ethernet interface, a Frame Relay interface, or other interface.
  • the network interface 216 may be configured to enable a system component to communicate with other system components across a network which may be a wireless network or various other
  • Fig. 2 the system configuration provided in Fig. 2 is provided to generally illustrate how embodiments may be configured and implemented.
  • the web-server 102 is networked to the internet 1 10, and is in communication with the user computer 1 16 through the internet 1 10 and/or any other communication networks, such as a proprietary network, LAN, WAN, cellular network, wireless network, the internet and/or other suitable communication network.
  • any other communication networks such as a proprietary network, LAN, WAN, cellular network, wireless network, the internet and/or other suitable communication network.
  • the user 126 accesses the web-based spreadsheet website 104 using the web-browser 1 18 on the user computer 116, such as by entering the web address of the website 104 or using a search engine.
  • the website 104 will display on the user computer a selection for the user to utilize the web-based spreadsheet web application 106.
  • the website 104 may request the user 126 to log-in on the website 104.
  • the user 126 logs in and selects to utilize the web-based spreadsheet web application 106.
  • the web- server 102 receives the request from the user 126 to utilize the web-based spreadsheet application 106, and then transmits the web-based spreadsheet application 106 to the user computer 126 via the internet.
  • the web-based spreadsheet application 106 programs the web-browser 118 on the user computer 116 to execute and display the web-based spreadsheet application 106 on the display 120 of the user computer 1 16.
  • the web-based spreadsheet application 106 can be transmitted completely to provide the full functionality of the web app, as described below, or it can be transmitted partially and intermittently as programming of the web-browser 118 is required by the spreadsheet web application 106 executing on the user computer, such as when functionality is selected by the user 126.
  • FIGs. 3-19 a number of examples of screen shots of a representative spreadsheet web application 106 which are displayed on the display 120 of the user computer 116 as the spreadsheet web application 106 is executed within the web-browser 118.
  • the screen shot 300 shows the web-browser 118 as displayed on the display 120.
  • the web-browser 1 18 may be any suitable web-browser, such as
  • the web-browser 118 has a menu bar 302 having the typical menu items and functions, such as a back button, favorites button, home button, search bar, address bar, etc.
  • the spreadsheet web application 106 first programs the web- browser 118 to display an "open spreadsheet" screen 300 which includes a command menu bar 304 having a plurality of commands, such as "Manage,” “Save,” and “Import.”
  • the commands and selections displayed by the web application 106 may be buttons, selectable text, menus, drop-down menus, or the like.
  • Selection of the "Manage” command brings up the screen to manage the user's spreadsheets, same or similar to the screen 300.
  • Selection of the "Save” command saves the current spreadsheet in the state at the time of the "Save” command.
  • the "Save” command may save the spreadsheet on the user computer 1 16, on the web-server 102, or both.
  • the "Import” command allows the user 126 to import a spreadsheet from a storage device, such as the storage device of the user computer 116 or another source, such as another computer, a cloud storage source, another user's account on the website 104, etc.
  • Screen 300 also displays a list 308 of previously created and stored spreadsheets.
  • the list 308 may include the name and description of each spreadsheet, and also commands to "Load,” “Edit,” and “Delete” each of the spreadsheets in the list 308.
  • the "Load” selection loads the selected spreadsheet for use of the spreadsheet without the ability to edit the spreadsheet.
  • the "Edit” selection loads the selected spreadsheet and allows editing of the spreadsheet, which is the same as editing a new spreadsheet as described in detail below.
  • the "Delete” selection deletes the selected spreadsheet from the list and may also delete the spreadsheet from where it is stored (e.g. user computer 116 or web-server 102).
  • Screen 300 also has a "New" command 306 for opening and creating a new spreadsheet.
  • the web application 106 opens a "new spreadsheet" screen 310, as shown in Fig. 4.
  • the screen 310 includes a fill-able "Name” text box 312 and a fill-able "Description” text box 314, in which the user 126 can type in a name and description for a new spreadsheet using the input device 124 of the user computer 116.
  • the user 126 has entered “Sample Spreadsheet" in the "Name” text box 312 and "Test” as the description in the "Description” text box 314.
  • the screen 310 also has a "Save/Edit" command for saving the new spreadsheet having the name and description as entered into the respective text boxes 312 and 314, and proceeding to creating and editing the new spreadsheet.
  • the web application 106 receives the data or the command, function or other selection. Accordingly, the act of the web application 106 receiving the data, command, function or other selection is not repeated throughout, with the understanding that such act is still described herein, and is a part of the described embodiments.
  • any "text box” may used for alpha-numeric text, numbers, text, punctuation and/or other characters, as the case may be for the particular "text box.”
  • Fig. 5 upon selection of the "Save/Edit" command on screen 310, the web application 106 displays a spreadsheet building screen 316.
  • the spreadsheet building screen 316 does not have a starting grid of rows and columns. Instead, the spreadsheet building screen 316 creates a spreadsheet in a line by line sequence. As shown in the screen shot 316 of Fig. 5, a first line 318 (a blank line until filled-in) for a spreadsheet 301 is displayed.
  • the first line 318 includes a fill-able line description text box 320, a spreadsheet line number 322 (in this case, line number 1), a function selection 324, a line value box 326, a "Hide" command 328, a line value format selection 330, and a function editing menu 332.
  • the building screen 316 also has an add line command 334 which when selected adds another line to the spreadsheet 301 (e.g. see Fig. 6 in which rows 2 and 3 have been added) .
  • the screen 316 also displays the name of the spreadsheet above the first blank line 318.
  • the user 126 enters a line description into the line description text box 320 using the input device 124 of the user computer 106.
  • the user 126 may also select a function using the function selection 324, and upon selection of the function selection 324, a function drop-down menu 321 of selectable functions is displayed, such as mathematical functions, other function and/or commands.
  • a function drop-down menu 321 of selectable functions is displayed, such as mathematical functions, other function and/or commands.
  • An example of the drop-down menu 321 is shown in the screen shot 317 of Fig. 6 for line 2 of the spreadsheet 301.
  • the user 126 To select one of the selectable functions in the dropdown menu 321, the user 126 simply moves a screen cursor onto, or scrolls onto the desired selectable function and clicks on the desired selectable function.
  • the function selected in the function selection 324 defines a function to be applied between the preceding spreadsheet line 318 and the current spreadsheet line 318. For example, referring to Fig. 6, the "-" operator (subtraction function) selected in line 2 of the spreadsheet 301 indicates that calculation of the spreadsheet 301 will subtract the value of the line value box 326
  • the user 126 may enter a line value into the line value box 326 by typing a value into the box using an input device 124 of the user computer 116, or by using the selection arrows 325 to increase and decrease the line value.
  • a line value need not be entered into the line value box 326, and instead may enter values into the line value box 326 after the spreadsheet 301 is completed, and the spreadsheet 301 is being utilized for a desired calculation using particular input values for certain line value boxes 326.
  • the line value format selection 330 is also a dropdown menu 331 of format selections for the type of value to be entered into the line value box 326, as shown in the screen shot 319 of Fig. 7 for line 3 of the spreadsheet 301.
  • the format dropdown menu may include format selections for decimal value, string value, and date, as well as currency values (e.g. $), time, percentage, fraction, text, etc.
  • the format dropdown menu for the line value format selection 330 operates the same as the function dropdown menu 321, as do all of the other dropdown menus described herein.
  • the "Hide” command 328 is a toggle command which toggles between a "Hide” state which hides the selected line of the spreadsheet and a "Show” state in which the selected line is displayed. If the "Hide” command 318 shows the text "Hide”, then selection of the command 318 hides the selected line, and the command 318 then toggles to display the text "Show” in the command button 318, as shown in the screen shot 337 of Fig. 12 in line 3 of the spreadsheet 301. Conversely, if the command 318 shows the text "Show”, then selection of the command 318 shows the selected line and toggles the command 318 to show the text "Hide.”
  • Fig. 6 is a screen shot 317 showing a second line and third line added to the spreadsheet 301. The user 126 can then complete the second blank line in the same manner described above for the first line, as shown in Fig. 6.
  • the add line command 334 may be selected to add as many lines as desired for the spreadsheet 301, with each additional line having the succeeding line number 322. An example of a spreadsheet 301 with three lines 318 completed is shown in Fig. 6.
  • the function editing menu 332 provides a selection of line functions for creating functions for the value of line value box 326 which are more complex than simply entering a value into the line value box 326.
  • the editing menu 332 is also a dropdown menu 333, as shown in Fig. 8 in line 3 of the spreadsheet 301.
  • the dropdown menu 333 includes the line functions "Edit Expression,” “Edit Line Items,” "Edit
  • the "Edit Expression” function allows the user to enter an expression for the value of the line value box 326, which may have logic operators, mathematical functions and formulas, and/or references to other values in the spreadsheet or in a worksheet thereof.
  • the editing screen 342 allows one or more lines to be added to the "Line Items" function 343 for defining the value of the line value box 326 for the particular row (row 3 in the example of Figs. 8 and 9) of the spreadsheet 301.
  • the editing screen 342 displays a line number 344, an item description text box 346, and a line item value box 348 for each line of the "Line Items" function 343.
  • the line item editing screen 342 has an add line item command 350 which when selected adds another line to the "Line Items" function 343.
  • the add line item command 348 can be selected to add as many line items as desired to the "Line Items" function 343.
  • the editing screen 342 also has a "Save” button 345 for saving the "Line Items” function 343 as a part of the spreadsheet 301 of Fig. 8 and a "Cancel” button 347 to cancel the "Line Items” function such that the creation and/or any changes to the function 343 are not saved and do not become a part of the spreadsheet 301 of Fig. 8.
  • FIG. 10 Selecting the "Edit Worksheet" function of the function editing dropdown menu 333 allows an embedded worksheet to be inserted into a line 318 of the spreadsheet 301 for defining the value of the line value box 326 of the particular line 318.
  • a screen shot 329 is shown which displays an embedded worksheet building screen 352 for creating an embedded worksheet 354 for line 3 of the spreadsheet 301 as shown in Fig 1 1.
  • the embedded worksheet building screen 352 has the same elements and functions, and operates the same, as the spreadsheet building screen 316 as described above, and like elements have like reference numbers.
  • creating the lines 318 of an embedded worksheet 354 is created in the same way as described above for creating the lines 318 of the spreadsheet 301.
  • FIG. 1 1 shows a screen shot 335 of an embedded worksheet 354 having three lines which have been created using the embedded worksheet function.
  • the result of the embedded worksheet 354 defines the value entered into the line value box 326 for line 3 of the spreadsheet 301 in Fig. 1 1.
  • the embedded worksheet building screen 352 has a "Done” button 355which operates the same as the "Save” button 345 described above, and a "Cancel” button 353 which operates the same as the "Cancel” button 347 described above.
  • the embedded worksheet 352 is inserted into the spreadsheet 301 in an Expanded View, as described below.
  • the spreadsheet web application 106 also displays a "Design Mode” selection in the form of a checkbox and an Expanded View selection also in the form of a checkbox.
  • a user 126 can check or uncheck the checkbox of these selections to put the spreadsheet web application 106 into the Design Mode and out of the Design Mode (out of the Design Mode is referred to as a "User Mode” or "end-user mode").
  • the application 106 displays the spreadsheet 301, or other spreadsheet functionality, in a mode in which the spreadsheet can be created and modified, and also shows any lines which are selected to be hidden.
  • the User-Mode i.e.
  • Fig. 12 shows a spreadsheet 301 in the Design Mode, such that each line 318 includes the fill-able line description text box 320, the function selection 324, the line value box 326, the "Hide" command 328, the line value format selection 330, and the function editing menu 332.
  • Figs. 12 shows a spreadsheet 301 in the Design Mode, such that each line 318 includes the fill-able line description text box 320, the function selection 324, the line value box 326, the "Hide" command 328, the line value format selection 330, and the function editing menu 332.
  • 15 and 16 show a similar spreadsheet 301 in the User Mode, in which the line description is not fill-able or changeable, and there is no fill-able line description text box 320, function selection 324, line value box 326, "Hide” command 328, line value format selection 330, or function editing menu 332. An end user can only fill certain line value boxes 326.
  • the spreadsheet 301 is displayed with any line functions created using the line functions from the function editing menu 332 inserted into the particular spreadsheet line, as shown in Fig. 12 in line 3.
  • the spreadsheet 301 in Fig. 12 shows the embedded worksheet 354 inserted into line 3. Accordingly, the line value box 325 for line 3 will be the result of the embedded worksheet 354.
  • the line functions are not displayed in the spreadsheet 301, as can be seen by comparing Fig. 15 (Expanded View) and Fig. 16 (not Expanded View).
  • Selecting the "Edit Column Series" function of the function editing dropdown menu 333 allows a table having multiple columns to be inserted into a line 318 of the spreadsheet 301 for defining the value of the line value box 326 of the particular line 318.
  • a screen shot 339 is shown which displays an column series building screen 360 for creating a multiple column table 362 for line 3 of the spreadsheet 301 as shown in Fig 1 1.
  • the column series building screen 360 has one or more lines 364 in which each line defines a column in the column table 362.
  • Each line 364 includes a fill-able column description text box 366, a column line number 368, a column function selection 370, a column value box 372, a "Hide” column command 374, a column value format selection 376, and a column function editing menu 378.
  • Each line 364 also has a "Show Total” selection which when selected inserts a total 381 into the column which is a total of the line value boxes for the particular column The "Show Total” selection is a toggle selection, similar to the "Hide” selection, and toggles between “Show Total” and “Hide Total.”
  • the column series building screen 360 also has an add line command 380 which when selected add another line 364 for adding a column to the column table 362.
  • a preview panel 382 is also displayed which shows a preview of the column table 362 of the spreadsheet 301 as defined by the lines 364 of the column series building screen 360.
  • the column function selection 370 the column value box 372 which creates a line value box 398 for each row in the respective column of the column table 362
  • the column value format selection 376 and/or a column function editing menu 378
  • the column as defined by the particular line 364 is created in the column table 362 in the preview panel 382.
  • rows in the column table 362 may be added by filling in the table value boxes 398 for each row created in the column table 362.
  • the preview panel 382 also performs the calculations as defined by the functions input into each of the lines 364 of the column series building screen 360. Accordingly, a user can enter test data into the preview panel 382, such as adding rows to the column table 362 and entering text into the description text boxes 396 and values into the table value boxes 398, and seeing the calculated results of the column table 362.
  • the Design Mode selection for the column series building screen 360 operates as described above. Accordingly, Fig. 13 shows an example of a column series building screen 360, and column table 362 in the preview panel 382 in the Design Mode. Fig. 14 shows the same column table 362 in the User Mode (i.e. with the Design Mode de-selected), except with one additional row added to the column table 362. In the User Mode of the column table 362, there is no preview table, and as described above, the table creation functions are not available. [0050]
  • the column series building screen 360 has a "Done" button which operates the same as the "Save” button 345 described above, and a "Cancel” button 353 which operates the same as the "Cancel” button 347 described above. Upon selecting the "Done" button in the column series building screen 360 in Fig. 13 or Fig. 14, the spreadsheet 301 is displayed as shown in the screen shot 343 of Fig. 15.
  • Fig. 15 shows the spreadsheet 301 having the column table 362 inserted into line 3.
  • Fig. 15 shows the spreadsheet 301 in the User Mode and in the Expanded View.
  • the column table 362 is shown in line 3 of the spreadsheet 301.
  • Fig. 16 is a screen shot 345 showing the same spreadsheet 301 of Fig. 15 in the User Mode and in the non-Expanded View (i.e. with the Expanded View de-selected).
  • each line 318 of a spreadsheet having a line function from the function editing menu 332 e.g. a Line Items function, an embedded worksheet, or a column table
  • the web application 106 Upon selection of the function input data button 390, the web application 106 displays a function input data screen 392, as shown in the screen shot 347 of Fig. 17.
  • the end user can enter descriptions into the description text boxes 396, enter values into the line value boxes 398, and add lines to the line function by selecting the add line/row button 394.
  • the end user selects the "Done” or "Cancel” button, which operate the same as the "Done” and "Cancel” buttons described above.
  • the spreadsheet 301 is displayed with the column table 362 having the data as input by the user on the input data screen 392 in line 3 of the spreadsheet 301, as shown in the screen shot 349 of Fig. 18.
  • the web-based spreadsheet web application 106 may have a User Mode in which certain fields of the spreadsheet 301 are not changeable by the user, the web application 106 can still be toggled between the Design Mode and the User Mode. Thus, it may be desirable to create an end-user version of the spreadsheet in which one or more of the fields (e.g. the text boxes (such as 320 or 396) and/or line value boxes (such as 326 or 398) of the spreadsheet is locked from being modified by the end-user.
  • the user sends the spreadsheet 301 to the website 104 and the web server 102 receives the spreadsheet 301.
  • the web server 102 has an end-user spreadsheet engine 105 configured to generate an end-user spreadsheet application 128 of the spreadsheet 301 in which one or more of the text boxes (e.g. 320 or 396) and/or line value boxes (e.g. 326 or 398) of the spreadsheet is locked from being modified by the end-user and at least one text box and/or line value box which allows the end-user to enter user data into the field.
  • the end-user spreadsheet application 128 may display and execute a spreadsheet which is the same as the End-User mode of the spreadsheet 301 as described above and shown in Figs. 15-18.
  • the end-user spreadsheet application 128 is configured to display and execute the end-user spreadsheet application 128 on a web browser 1 18 of an end-user computer 130 (see Fig. 1) which may be same or similar to the user computer 116.
  • the web server 102 is configured to transmit the end-user spreadsheet application 128 to the web browser 118 of the end user computerl30 via the internet 110. This may be done same or similar to transmitting the web-based spreadsheet web application 106 to a user, as described above.
  • a web-based spreadsheet system 100 for creating an electronic spreadsheet using a web-based spreadsheet application.
  • any and all method embodiments implemented by the system 100 and/or its components for creating an electronic spreadsheet using a web-based spreadsheet application have also been provided.
  • the methods embodiments described herein may also be embodied in, or readable from, a computer-readable medium (computer program carrier), e.g., one or more of the fixed and/or removable data storage data devices and/or data communications devices connected to a computer, including a non-transitory computer medium having instructions that when executed by a computer perform the described methods.
  • the computer program carrier is readable by a computer and embodies instructions executable by the computer to perform the method steps of programming a computer to perform the methods implemented by the system 100 and/or its components, as described herein.
  • Carriers may be, for example, magnetic storage medium, optical storage medium and magneto-optical storage medium. Examples of carriers include, but are not limited to, a floppy diskette, a memory stick or a flash drive, a hard drive, CD-R, CD-RW, CD-ROM, DVD-R, and DVD-RW.

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)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

L'invention concerne des procédés, systèmes et articles de fabrication permettant de détecter des erreurs dans un fichier de données de déclaration de revenus dans un format de l'agence fiscale. Un système de validation de déclaration de revenus informatisée reçoit un fichier de données de déclaration de revenus avant sa soumission à l'agence fiscale chargée de la déclaration de l'impôt et dans le même format que celui auquel elle doit être soumise à l'agence discale officielle. Le système analyse le fichier de données et détermine la présence ou l'absence d'erreurs dans la déclaration de revenus selon les exigences d'admissibilité de l'agence fiscale qui, si elles ne sont pas satisfaites, aboutissent au refus de la déclaration de revenus. Si le système détermine la présence d'erreur(s), alors le système génère un message d'erreur que le système utilise pour identifier, évaluer et/ou corriger l'erreur. Si le système de validation de déclaration de revenus détermine l'absence d'erreur, alors le système génère un message d'absence d'erreur.
PCT/US2015/014462 2015-02-03 2015-02-04 Systèmes, procédés et articles pour application de tableur basé sur le web WO2016126247A1 (fr)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US14/613,263 US9910843B2 (en) 2015-02-03 2015-02-03 Systems, methods and articles for a web-based spreadsheet application
US14/613,263 2015-02-03

Publications (1)

Publication Number Publication Date
WO2016126247A1 true WO2016126247A1 (fr) 2016-08-11

Family

ID=56554423

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/US2015/014462 WO2016126247A1 (fr) 2015-02-03 2015-02-04 Systèmes, procédés et articles pour application de tableur basé sur le web

Country Status (2)

Country Link
US (1) US9910843B2 (fr)
WO (1) WO2016126247A1 (fr)

Families Citing this family (13)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US10031906B2 (en) 2015-11-02 2018-07-24 Microsoft Technology Licensing, Llc Images and additional data associated with cells in spreadsheets
US11157689B2 (en) 2015-11-02 2021-10-26 Microsoft Technology Licensing, Llc Operations on dynamic data associated with cells in spreadsheets
US11023668B2 (en) 2015-11-02 2021-06-01 Microsoft Technology Licensing, Llc Enriched compound data objects
US10963635B2 (en) 2015-11-02 2021-03-30 Microsoft Technology Licensing, Llc Extensibility of compound data objects
US9836444B2 (en) * 2015-12-10 2017-12-05 International Business Machines Corporation Spread cell value visualization
US10540153B2 (en) 2016-12-03 2020-01-21 Thomas STACHURA Spreadsheet-based software application development
US11726753B2 (en) 2016-12-03 2023-08-15 Thomas STACHURA Spreadsheet-based software application development
US10216494B2 (en) 2016-12-03 2019-02-26 Thomas STACHURA Spreadsheet-based software application development
PL3718000T3 (pl) * 2017-12-03 2024-02-05 Thomas Stachura Tworzenie aplikacji programowej w oparciu o arkusz kalkulacyjny
US11099721B2 (en) * 2018-04-03 2021-08-24 Tiller LLC In-cell commands for matrix layout structured user interface
US11119737B1 (en) * 2020-08-10 2021-09-14 Adp, Llc Dynamic column guides and data representation on an application development workspace
US11556702B2 (en) * 2020-08-31 2023-01-17 Oracle International Corporation Orchestration of crud operations for a hierarchical web service data model in a spreadsheet
CN112558957B (zh) * 2020-12-08 2024-02-13 中国联合网络通信集团有限公司 生成网页表格的方法、装置、电子设备及可读存储介质

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6988241B1 (en) * 2000-10-16 2006-01-17 International Business Machines Corporation Client side, web-based spreadsheet
US20070233811A1 (en) * 2006-03-31 2007-10-04 Jonathan Rochelle Collaborative online spreadsheet application
US7673227B2 (en) * 2000-06-21 2010-03-02 Microsoft Corporation User interface for integrated spreadsheets and word processing tables
US7752536B2 (en) * 2005-09-09 2010-07-06 Microsoft Corporation Designating, setting and discovering parameters for spreadsheet documents
US20130145244A1 (en) * 2011-12-05 2013-06-06 Microsoft Corporation Quick analysis tool for spreadsheet application programs

Family Cites Families (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5819293A (en) * 1996-06-06 1998-10-06 Microsoft Corporation Automatic Spreadsheet forms
WO2002005065A2 (fr) * 2000-07-11 2002-01-17 Juice Software, Inc. Systeme et procede pour l'integration de fonctions de reseau en applications de productivite
US7233951B1 (en) 2004-02-18 2007-06-19 Microsoft Corporation Spreadsheet grid-like control for a web-based collaboration system
US20060026240A1 (en) * 2004-07-28 2006-02-02 Unilever Home & Personal Care Usa, Division Of Conopco, Inc. Method of collecting data from one or multiple respondents using spreadsheet based tool with programmed wizard utility deployed by e-mail
WO2006095365A2 (fr) 2005-03-11 2006-09-14 Suresh Sambandam Systeme et procede de definition d'un modele de donnees hierarchique et regles de calcul et d'instructions apparentees utilisant une interface utilisateur de type tableur
US20080071580A1 (en) * 2005-06-03 2008-03-20 Marcus Alan O System and method for medical evaluation and monitoring
US20070033074A1 (en) * 2005-06-03 2007-02-08 Medtronic Minimed, Inc. Therapy management system
US8122061B1 (en) * 2010-11-10 2012-02-21 Robert Guinness Systems and methods for information management using socially constructed graphs
US20130085962A1 (en) * 2011-09-23 2013-04-04 No Magic, Inc. System and method for generating visual models from activity based modeling data

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7673227B2 (en) * 2000-06-21 2010-03-02 Microsoft Corporation User interface for integrated spreadsheets and word processing tables
US6988241B1 (en) * 2000-10-16 2006-01-17 International Business Machines Corporation Client side, web-based spreadsheet
US7752536B2 (en) * 2005-09-09 2010-07-06 Microsoft Corporation Designating, setting and discovering parameters for spreadsheet documents
US20070233811A1 (en) * 2006-03-31 2007-10-04 Jonathan Rochelle Collaborative online spreadsheet application
US20130145244A1 (en) * 2011-12-05 2013-06-06 Microsoft Corporation Quick analysis tool for spreadsheet application programs

Also Published As

Publication number Publication date
US20160224536A1 (en) 2016-08-04
US9910843B2 (en) 2018-03-06

Similar Documents

Publication Publication Date Title
US9910843B2 (en) Systems, methods and articles for a web-based spreadsheet application
US9152542B2 (en) Automatic generation of test scripts
US20210318851A1 (en) Systems and Methods for Dataset Merging using Flow Structures
US9996613B2 (en) System and method for accessibility assessment of a web application
US20170090875A1 (en) Declarative design-time experience platform for code generation
US10637913B2 (en) Mechanism for webpage composition
US20180081994A1 (en) Automatically mapping data while designing process flows
US9811248B1 (en) Webpage testing tool
US20180174243A1 (en) Systems, methods and apparatus for enhanced navigation in preparation of an electronic tax return
CN109829144A (zh) 一种在线表格跨表引用方法及装置
US11080476B2 (en) Interactive data entry validation and problem correction in a table component in a spreadsheet driven by a web service
US9778833B2 (en) Identifying and surfacing relevant report artifacts in documents
US9727450B2 (en) Model-based software application testing
EP3262527B1 (fr) Découverte d'ensemble de formules uniques dans des feuilles de calcul
US20240020350A1 (en) Method and system for navigation control
US9928221B1 (en) Sharing links which include user input
US10460015B1 (en) Assimilation in multi model webpage composition
CN114706580A (zh) 前端网页开发方法、装置、存储介质和电子设备
US10007493B1 (en) Event based validation
US10929380B2 (en) Definition of programmable conditions applicable to an operation
CN108132755A (zh) 一种数字输入方法、装置和移动设备
US10225316B1 (en) Method and mechanism for data source fetch through virtual data source
US11036932B2 (en) Technology platform having integrated content creation features
KR20130014841A (ko) 로그검색식 자동완성 방법 및 이를 수행하기 위한 시스템
EP2767901A1 (fr) Génération de documents électroniques interactifs

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: 15881353

Country of ref document: EP

Kind code of ref document: A1

NENP Non-entry into the national phase

Ref country code: DE

122 Ep: pct application non-entry in european phase

Ref document number: 15881353

Country of ref document: EP

Kind code of ref document: A1