KR101797573B1 - Web based spreadsheets service providing apparatus and method - Google Patents

Abstract

A web-based spreadsheet service provision apparatus and method are disclosed. The present invention supports a plurality of cells constituting a spreadsheet through a browser of a client terminal so that they can be accurately rendered and displayed on the screen, and even if a function operation is included in the spreadsheet, a web Based spreadsheet service providing apparatus and method.

Description

[0001] WEB BASED SPREADSHEETS SERVICE PROVIDING APPARATUS AND METHOD [0002]

The present invention relates to an apparatus and a method for providing a web-based spreadsheet service that supports reading, creating, and editing of a spreadsheet for a client terminal based on the web.

2. Description of the Related Art [0002] Recently, various electronic document-related programs have been released to enable electronic documents to be viewed, created, and edited using electronic terminal devices such as computers, smart phones, tablet PCs, and the like.

Examples of such electronic document related programs include a word processor for basic document creation and editing, a data input, an arithmetic operation, a spreadsheet for supporting data management, and presentation programs for assisting presenters.

Conventionally, in order to view, create and edit an electronic document by using an electronic terminal device, a user has to install the above-mentioned electronic document related programs directly in the electronic terminal device, and then operate the electronic document related programs to browse, I had to edit.

However, in recent years, a wireless Internet environment has been established in which a broadband Internet environment is established and a user can access the Internet anytime and anywhere. Thus, by providing an electronic document related service to an electronic terminal device serving as a client terminal through a remote server, A web-based electronic document service that allows an electronic document to be viewed, created, and edited anytime and anywhere without installing a predetermined electronic document-related program in the electronic terminal apparatus is emerging.

Such a web-based electronic document service enables various client terminals to access an electronic document service providing server, browse an electronic document based on a markup language through a browser, and then create and edit the corresponding electronic document And it is mainly utilized in companies and organizations in that various client terminals support simultaneous collaboration on the electronic document in real time.

If a web-based electronic document service can be connected to the Internet without installing a predetermined electronic document creating program on the client terminal, the electronic document service can be browsed, created and edited through a browser installed in the client terminal And thus the mobility of users can be guaranteed, and the number of individual users is also increasing.

Among these web-based electronic document services, there is a spreadsheet service that enables users to create spreadsheet-related documents on the web.

However, the spreadsheet is composed of a plurality of cells having row and column addresses, and differs from a general electronic document in that it supports function operations. Therefore, since the spreadsheet is a somewhat complicated structure document, It is necessary to discuss a technical method for supporting to provide the user of the client terminal with a basis.

The present invention supports a plurality of cells constituting a spreadsheet through a browser of a client terminal so that they can be accurately rendered and displayed on the screen, and even if a function operation is included in the spreadsheet, a web Based spreadsheet service providing apparatus and method.

The apparatus for providing a web-based spreadsheet service according to an embodiment of the present invention includes information on at least one cell in which data is inserted among a plurality of cells constituting a spreadsheet, Wherein the at least one cell includes data inserted in one cell and a column address allocated to each of the at least one cell, and grouping the cells in the same row unit based on the row address assigned to each of the at least one cell, Wherein the list includes information on each row address in which the information about the at least one cell is grouped, and when the open command for the spreadsheet is received from the client terminal, Extracts data on the list and transmits the data to the client terminal Wherein the client terminal is configured to transmit a row address for the at least one cell grouped on the list through the browser of the client terminal when the data for the list is received, Extracting a column address assigned to each of the at least one cell and data inserted in each of the at least one cell from the information about the at least one cell included in the list, A plurality of cells constituting the spreadsheet are rendered based on the row address, the extracted column address, and the extracted data, and displayed on the screen.

A method for providing a web-based spreadsheet service according to an exemplary embodiment of the present invention is a method for providing information on at least one cell in which data is inserted among a plurality of cells constituting a spreadsheet, Wherein the at least one cell includes data inserted in the at least one cell and a column address allocated to each of the at least one cell, grouping the data in the same row unit based on the row address assigned to each of the at least one cell, - maintaining the cell database storing the information for each row address in which the information for the at least one cell is grouped, and if the open command for the spreadsheet is received from the client terminal , Extracts data on the list from the cell database, And transmitting the data for the list to the terminal, wherein when the data for the list is received, the client terminal transmits the data for the at least one cell grouped on the list through the browser of the client terminal Extracting a column address assigned to each of the at least one cell and data inserted in each of the at least one cell from information on the at least one cell included in the list, And displays a plurality of cells constituting the spreadsheet on the screen based on the extracted row address, the extracted column address, and the extracted data.

The present invention supports a plurality of cells constituting a spreadsheet through a browser of a client terminal so that they can be accurately rendered and displayed on the screen, and even if a function operation is included in the spreadsheet, a web Based spreadsheet service providing apparatus and method.

1 is a diagram illustrating a structure of a web-based spreadsheet service providing apparatus according to an embodiment of the present invention.
2 to 6 are views for explaining operations of a web-based spreadsheet service providing apparatus according to an embodiment of the present invention.
7 is a flowchart illustrating a method of providing a web-based spreadsheet service according to an embodiment of the present invention.

While the invention is susceptible to various modifications and alternative forms, specific embodiments thereof are shown by way of example in the drawings and will herein be described in detail. It should be understood, however, that the invention is not intended to be limited to the particular embodiments, but includes all modifications, equivalents, and alternatives falling within the spirit and scope of the invention. Like reference numerals are used for like elements in describing each drawing.

It is to be understood that when an element is referred to as being "connected" or "connected" to another element, it may be directly connected or connected to the other element, . On the other hand, when an element is referred to as being "directly connected" or "directly connected" to another element, it should be understood that there are no other elements in between.

The terminology used in this application is used only to describe a specific embodiment and is not intended to limit the invention. The singular expressions include plural expressions unless the context clearly dictates otherwise. In the present application, the terms "comprises" or "having" and the like are used to specify that there is a feature, a number, a step, an operation, an element, a component or a combination thereof described in the specification, But do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, or combinations thereof.

Unless defined otherwise, all terms used herein, including technical or scientific terms, have the same meaning as commonly understood by one of ordinary skill in the art to which this invention belongs. Terms such as those defined in commonly used dictionaries are to be interpreted as having a meaning consistent with the contextual meaning of the related art and are to be interpreted as either ideal or overly formal in the sense of the present application Do not.

Hereinafter, embodiments according to the present invention will be described in detail with reference to the accompanying drawings.

1 is a diagram illustrating a structure of a web-based spreadsheet service providing apparatus according to an embodiment of the present invention.

Referring to FIG. 1, an apparatus 110 for providing a web-based spreadsheet service according to an embodiment of the present invention includes a cell database 111 and a spreadsheet data transfer unit 112.

The cell database 111 groups information of at least one cell in which a data is inserted among a plurality of cells constituting a spreadsheet in units of the same row based on the row address assigned to each of the at least one cell, .

Wherein the information about the at least one cell includes data inserted into the at least one cell and a column address assigned to each of the at least one cell and the list includes information about the at least one cell And includes information about each row address grouped.

In this regard, the cell database 111 may store a list as shown in Fig.

For example, if it is assumed that data is inserted into a plurality of cells constituting the spreadsheet as shown in FIG. 3, the cell database 111 stores a cell And a list in which information on cells including information as data is grouped in units of the same row may be stored.

3, data "a" is inserted into "1 row, A column" among the plurality of cells constituting the spreadsheet, and data "1" is inserted into "1 row, B column" Is stored in the cell database 111 and data "2" is inserted in the "1 row, C column", and data "3" is inserted in the "1 row, D column" 2, information about a cell called " data: a, column: A "221 is stored for a row address" row: 1 " Information about a cell called " data: 2, column: C "223, and information about a cell called" data: 3, column: D " They may be grouped into the same group.

At this time, the list includes information on the row address of each group such as the row addresses "row: 1", "row: 2", "row: 3", "row: 4" .

The spreadsheet data transfer unit 112 accesses the web-based spreadsheet service providing apparatus 110 via the Internet using the client terminal 130 and then authorizes an open command for the spreadsheet, When the open command for the spreadsheet is received from the terminal 130, the data for the list is extracted from the cell database 111 and the data for the list is transmitted to the client terminal 130.

At this time, when the data of the list is received from the web-based spreadsheet service providing apparatus 110, the client terminal 130 transmits the list to the at least one cell grouped on the list through the browser of the client terminal 130 Extracts a column address assigned to each of the at least one cell and data inserted in each of the at least one cell from information on the at least one cell included in the list A plurality of cells configuring the spreadsheet may be rendered and displayed on the screen based on the identified row address, the extracted column address, and the extracted data.

2, when data of the list is received from the web-based spreadsheet service providing apparatus 110, the client terminal 130 receives a spread of the form shown in FIG. 3 through the browser In order to render a plurality of cells constituting the sheet and display them on the screen, a script for rendering a spreadsheet may be provided on the browser. For example, the browser of the client terminal 130 may be provided with a JavaScript (JavaScript) composed of instructions for rendering the spreadsheet.

At this time, when the client terminal 130 receives data on the list as shown in FIG. 2 from the web-based spreadsheet service providing apparatus 110, the client terminal 130 transmits a spreadsheet of the form shown in FIG. The plurality of cells constituting the plurality of cells may be rendered and displayed on the screen. More specifically, each command of the script installed in the browser may be executed to identify a row address for the at least one cell grouped on the list Extracting a column address assigned to each of the at least one cell and data inserted in each of the at least one cell from information on the at least one cell included in the list, Based on the extracted column address and the extracted data, It is possible to render a plurality of cells constituting the display unit and display the cells on the screen.

At this time, the client terminal 130 executes each command of the script installed in the browser to display a plurality of cells constituting the spreadsheet in a markup language (HTML) such as Hypertext Markup Language (HTML) or XML (eXtensible Markup Language) Markup Language) based document and display it on the screen.

That is, according to the present invention, as shown in FIG. 2, a web-based spreadsheet service providing apparatus 110 stores at least one of a plurality of cells in which data is inserted among a plurality of cells constituting a spreadsheet The information about the cell is grouped by the same row unit based on the row address assigned to each of the at least one cell and stored as a list. When an open command for the spreadsheet is received from the client terminal 130, Extracts data for the list from the cell database 111 and transmits the extracted data to the client terminal 130. The client terminal 130 then transmits the list data to the client terminal 130 via the browser on the basis of the data for the list From the information on the cell of the at least one cell, a column address assigned to each of the at least one cell, Extracts the inserted data, and then the client terminal 130 forms the spreadsheet as shown in FIG. 3 based on the confirmed row address, the extracted column address, and the extracted data By rendering a plurality of cells and displaying them on the screen, the user can support the user to browse the spreadsheet through the client terminal 130 on a web-based basis.

According to an embodiment of the present invention, the web-based spreadsheet service providing apparatus 110 may further include an edit information receiving unit 113 and an update unit 114.

The editing information receiving unit 113 may correct the data inserted in the at least one cell among the plurality of cells constituting the spreadsheet displayed on the browser at the client terminal 130 by the user, When the data inserted in at least one cell occurs, the client terminal 130 receives from the client terminal 130 the row address and the column address of the cell in which the data modification has occurred and the modification edit information including the changed data in the cell where the data modification occurs .

The update unit 114 updates information on the at least one cell included in the list stored in the cell database 111 based on the received modified edit information.

For example, when a plurality of cells constituting the spreadsheet are displayed on the client terminal 130 through the browser, as shown in reference numeral 410 in FIG. 4, Quot; 4 " 421 as indicated by reference numeral 420, the data "2" 411 inserted in the " Edit editing information including "1 row" which is the row address of the "1 row, C column" in which the modification occurred, "C column" which is the column address, and "4" which is the changed data in the cell where the data modification occurred To the web-based spreadsheet service providing apparatus 110.

At this time, the edit information receiving unit 113 can receive the edit edit information from the client terminal 130, and the update unit 114 updates the edit information stored in the cell database 111 And update information about the at least one cell included in the list.

2, column: C "223, which is the information of the cell corresponding to the column C in" row: 1 "210 which is grouped in one row on the list shown in FIG. 2, Is changed to "data: 4, column: C ", information on the at least one cell included in the list can be updated.

According to an embodiment of the present invention, the web-based spreadsheet service providing apparatus 110 may further include a function information database 115.

In the function information database 115, when a function is inserted in a first cell of the at least one cell, information on the function and at least one first input cell referred to as an input value in the function And a first input cell is a cell included in the at least one cell).

For example, as shown in a figure 410 in FIG. 4, data inserted in a cell corresponding to "4 rows, C columns" while data is input to a plurality of cells constituting the spreadsheet is a simple number Data inserted in "1 row, C column", "2 row, C column", "3 row, C column" instead of "14" (412) SUM (C1, C2, C3) "inserted in the" fourth row, C column "corresponding to the first cell is stored in the function information database 115 And information on the addresses of "1 row, C column", "2 row, C column", "3 row, C column" which are at least one first input cell referenced as an input value in the function are stored corresponding to each other Can be.

At this time, the data inserted into the cell corresponding to "4th row, Cth column" at 410 in FIG. 4 is inserted into "1st row, Cth column", "2nd row, Cth column", "3rd row, Cth column" Quot; 14 "(412) because it is the sum of the data that is " 14 "

At this time, the update unit 114 may include an edit determination unit 116, a function operation performing unit 117, and a data change unit 118.

When the edit / edit information is received from the client terminal 130, the edit determination unit 116 refers to the information on the row address and the column address of the at least one first input cell stored in the function information database 115 To determine whether modification of the data according to the received modified edit information has occurred in the at least one first input cell.

If it is determined that the modification of the data according to the received modified edit information has occurred in the at least one first input cell, the function operation performing unit 117 obtains information about the function stored in the function information database 115 And generates a first output value by performing a function operation based on the change data of the at least one first input cell according to the received modified edit information.

The data changing unit 118 changes the data inserted in the first cell on the list into the first output value based on the first output value.

For example, when a plurality of cells constituting the spreadsheet are displayed on the client terminal 130 through the browser, as shown in reference numeral 410 in FIG. 4, 1 "from the client terminal 130 by modifying the data" 2 "411 inserted in the" 1 row, C column "to" 4 "421 as indicated by reference numeral 420 via the input device of the client terminal 130 When the web-based spreadsheet service providing apparatus 110 receives the edit editing information for changing the data of the cell corresponding to the " row, column C "from" 2 "411 to" 4 "421, Quot; C row, "" 2 rows, C columns," " 3 rows, C columns ", which are addresses of the at least one first input cell stored in the function information database 115 The modification of the data according to the received modified editing information is performed at least at least Of the first input cell, "first rows, columns C", "the second row, column C", it can be determined whether or not generated in the "three-row, column C".

Then, the function operation performing unit 117 determines whether or not the modification of the data according to the received correction editing information is performed in the order of "1 row, C column", "2 row, C column" SUM (C1, C2, C3) "which is a function stored in the function information database 115 because it has occurred in the " 1 row, C column" Quot; 16 "by performing a function operation based on the change data of the at least one first input cell according to the first output value.

Then, based on the first output value "16 ", the data changing unit 118 changes the value of the function" SUM (C1, C2, C3) " Data: 14, column: C "225 corresponding to the first cell corresponding to the fourth row and the fourth column can be changed to" data: 16, column: C ".

In this case, according to an embodiment of the present invention, the spreadsheet data transfer unit 112 may further include an update data transfer unit 119.

When the data inserted in the first cell is changed to the first output value, the update data transmission unit 119 transmits the information about the row address and the column address of the first cell and the first output value to the client terminal 130 and transmits a data update command for the first cell to the client terminal 130.

At this time, when the client terminal 130 receives the information on the row address and column address of the first cell, the first output value, and the data update command for the first cell, Refers to information on a row address and a column address of the first cell and determines data inserted in the first cell among a plurality of cells constituting the spreadsheet displayed on the screen through the browser To the first output value.

In this regard, the operation of the update data transfer unit 119 will be described in more detail with reference to the example described above. The data "14: column: C" 225 , column: C ", the update data transfer unit 119 transfers" 4 rows, C columns "and" 16 ", which are the information about the row address and the column address of the first cell, And transmits the data update command for the first cell to the client terminal 130 at the same time.

At this time, when the client terminal 130 receives the information on the row address and column address of the first cell, the first output value, and the data update command for the first cell, Which is displayed on the screen through the browser on the screen 410 of FIG. 4 with reference to the "4 rows, C columns ", which is information on the row address and the column address of the first cell, Quot; 14 "412 inserted in the first cell among the plurality of cells constituting the first cell 420 can be changed to the first output value" 16 "422 as shown by reference numeral 420 in FIG. 4 .

As a result, the web-based spreadsheet service providing apparatus 110 according to the present invention includes a function information database storing a function inserted in a specific cell of a spreadsheet and information on an address of a cell referenced by the function as an input value 115 of the client terminal 130 so as to reflect the data change of the corresponding cell in the list stored in the cell database 111, If the cell in which the data is changed is a cell referenced as an input value in a function stored in the function information database 115, an output value of the cell in which the function is inserted is generated by performing a function operation based on the changed data The client terminal 130 may transmit the output value to the client terminal 130. At this time, It can change the data of the cell in which the function is inserted on the screen that is being displayed through the distributors in the output value.

Accordingly, the present invention can normally provide a complicated function calculation function that is difficult to implement through a script installed in the browser of the client terminal 130 itself in the web-based spreadsheet service.

According to an embodiment of the present invention, the editing information receiving unit 113 may extract, among the plurality of cells constituting the spreadsheet displayed through the browser at the client terminal 130, among the remaining cells excluding the at least one cell When data insertion occurs for at least one additional cell, the client terminal 130 receives additional editing information including the row address and column address of the at least one additional cell and data inserted into the at least one additional cell .

At this time, the update unit 114 may update the information on the at least one additional cell based on the additional editing information, wherein the information about the at least one additional cell is the data included in the at least one additional cell, (Including a column address assigned to each of at least one additional cell) on the same row basis on the basis of the row address assigned to each of the at least one additional cell.

For example, as shown in FIG. 3, when a plurality of cells constituting the spreadsheet are displayed on the client terminal 130 through the browser, the user inputs an input device such as a keyboard connected to the client terminal 130 (511) is generated by generating an additional cell corresponding to "2 rows, E columns" as shown by reference numeral 510 in FIG. 5, the client terminal 130 adds the additional cell Provides a web-based spreadsheet service by generating additional editing information including "row 2", which is the row address of "row 2, column E", column "E column", and column "b" To the device (110).

At this time, the edit information receiving unit 113 can receive the additional edit information from the client terminal 130, and the update unit 114, based on the additional edit information, , column: E "(611) may be grouped into" 2 rows ", which is the row address assigned to the additional cell, and added to the list.

That is, as shown in Fig. 6, the updating unit 114 updates the data of the cell corresponding to the column E with respect to "row: 2" ) Can be added.

According to an embodiment of the present invention, when the inserted data for the first additional cell of the at least one additional cell is a function, the additional editing information may include information about the function inserted in the first additional cell, At least one second input cell referred to as an input value in a function inserted in the first additional cell, wherein the at least one second input cell is a cell included in the at least one additional cell and the at least one additional cell ) And the row address and the column address of the column address.

At this time, the update unit 114 determines that the information about the function inserted in the first additional cell and the information about the row address and the column address of the at least one second input cell are included in the additional editing information , Information on a function inserted in the first additional cell and information on a row address and a column address of the at least one second input cell are associated with each other in the function information database 115 by referring to the additional editing information And a function information update unit 120 for storing the function information.

The function operation performing unit 117 refers to the information about the function inserted in the first additional cell and the information about the row address and the column address of the at least one second input cell, The second output value can be generated by performing a functional operation based on the data inserted in the cell and the data changing unit 118 can generate the second additional value on the list based on the second output value, May include the data to be inserted into the second output value.

In this case, according to an embodiment of the present invention, when the generation of the second output value is completed, the update data transmission unit 119 transmits information about the row address and the column address of the first additional cell, To the client terminal 130 and to transmit the data update command for the first additional cell to the client terminal 130.

At this time, when the client terminal 130 receives the information on the row address and column address of the first additional cell, the second output value, and the data update command for the first additional cell, Wherein the first additional cell is connected to the first additional cell among the plurality of cells constituting the spreadsheet displayed on the screen by referring to the information on the row address and the column address of the first additional cell, The second output value may be inserted.

Hereinafter, operations of the update unit 114 and the update data transfer unit 119 will be described in detail with reference to FIG.

3, when a plurality of cells constituting the spreadsheet are displayed on the client terminal 130 through the browser, the user can access the client terminal 130 through an input device such as a keyboard connected to the client terminal 130 As shown in 510 of FIG. 5, "additional cell 1" corresponding to "column 2, column E" is generated and data "b" 511 is input. At the same time, Inserted into "1 row B column", "1 row, C column", "1 row, D column" called "= SUM (B1, C1, D1)" The client terminal 130 adds "2 rows" which is the row address of the "additional cell 1", "E column" which is the column address, and data added to the corresponding cell Quot; = SUM (B1, C1, D1) ", which is a function inserted into the corresponding cell, " And the function Which includes row addresses and column addresses of "1 row B column", "1 row, C column", "1 row, D column" which are input cells referred to as "= SUM (B1, C1, D1) Additional editing information can be generated and transmitted to the web-based spreadsheet service providing apparatus 110. [

At this time, the edit information receiving unit 113 can receive the additional edit information from the client terminal 130, and the update unit 114, based on the additional edit information, , column: E "611 can be grouped into" 2 rows ", which is the row address assigned to the "additional cell 1 " data 6, colunm: E "612 can be grouped into" 1 row ", which is a row address assigned to the "additional cell 2 " . At this time, since the data value in the "additional cell 2" is calculated based on the function inserted in the " additional cell 2 ", the data "6" , The update unit 114 may further perform a process for calculating data "6 ".

In relation to this, the function information update unit 120 adds information on " = SUM (B1, C1, D1) ", which is a function inserted in the " additional cell 2 " 1 row, C column "," 1 row, D column ", which are the input cells referred to by the input values" B1, C1, D1) Quot; 1 row, B column ", "1 row, C column "," 1 row ", " D column ", " "Can be stored in association with each other.

Then, the function operation performing unit 117 acquires information on the function inserted in the above-mentioned "additional cell 2" and the cell corresponding to "1 row B column", "1 row, C column", "1 row, D column" Refers to the information on the row address and the column address of the cell 1, and performs a functional operation based on the data inserted in the cell corresponding to "1 row B column", "1 row, C column", "1 row, D column" , It is possible to generate an output value of "6 ".

At this time, based on the output value of "6 ", the data changing section 118 includes data to be inserted in the" additional cell 2 " in the list as "6 & information about "additional cell 2" of "data: 6, column: E" 612 can be grouped into "1 row" assigned to the "additional cell 2" .

At this time, when the calculation of the data "6" to be inserted into the " additional cell 2 " is completed, the update data transfer unit 119 outputs the information of the row address and column address of the & To the client terminal 130 and to transmit the data update command for the "additional cell 2 " to the client terminal 130.

At this time, when the client terminal 130 receives the information on the row address and column address of the "additional cell 2" and the data update command on the output value "6" and the "additional cell 2" 2, " which is displayed on the screen through the browser, as indicated by reference numeral 520 in FIG. 5, by referring to the information on the row address and column address of the "additional cell 2 " An output value of "6" (521) can be inserted into "additional cell 2" among the plurality of cells constituting the spreadsheet.

As a result, when the user of the client terminal 130 creates a new cell on the spreadsheet and adds data, the apparatus 110 for providing a web-based spreadsheet service according to the present invention can perform data addition and deletion from the client terminal 130 If the data added by the user is a predetermined function, the result of the operation is reflected on the list by performing the function operation. The client terminal 130 can support the display of the output value corresponding to the function added by the user by transmitting the result value to the client terminal 130 at the same time.

7 is a flowchart illustrating a method of providing a web-based spreadsheet service according to an embodiment of the present invention.

In step S710, information on at least one cell in which data is inserted among a plurality of cells constituting the spreadsheet, wherein the information on the at least one cell includes data inserted in the at least one cell, (Including a column address assigned to each of at least one cell) is grouped in units of the same row on the basis of a row address assigned to each of the at least one cell, (Including information about each row address grouped by information).

In step S720, when an open command for the spreadsheet is received from the client terminal, data for the list is extracted from the cell database and data for the list is transmitted to the client terminal.

At this time, when data on the list is received, the client terminal checks a row address for the at least one cell grouped on the list through the browser of the client terminal, Extracting a column address assigned to each of the at least one cell and data inserted in each of the at least one cell from information on one cell and then extracting the extracted row address and the extracted column address and the extracted data A plurality of cells constituting the spreadsheet are rendered and displayed on the screen.

According to an embodiment of the present invention, the web-based spreadsheet service providing method includes inserting the at least one cell among the plurality of cells constituting the spreadsheet displayed through the browser at the client terminal Receiving modified edit information including a row address and a column address of a cell in which data modification has occurred and changed data in a cell in which data modification has occurred from the client terminal when a modification to the data exists, Updating the information on the at least one cell included in the list stored in the cell database based on the editing information.

According to an embodiment of the present invention, the method for providing a web-based spreadsheet service may include a step of, when a function is inserted in a first cell of the at least one cell, A function information database in which information on row addresses and column addresses of at least one first input cell to be referred to (where the at least one first input cell is a cell included in the at least one cell) The method comprising:

In this case, the updating may include: receiving, when receiving the modification edit information from the client terminal, information on a row address and a column address of the at least one first input cell stored in the function information database, Determining whether modification of the data according to the modified edit information has occurred in the at least one first input cell, determining that modification of the data according to the received modified edit information occurs in the at least one first input cell By performing a function operation based on the change data of the at least one first input cell according to the received modified edit information by referring to the information about the function stored in the function information database, Based on the first output value, And changing the data inserted in the first cell to the first output value.

According to an embodiment of the present invention, when the data inserted in the first cell is changed to the first output value, the method for providing the web-based spreadsheet service may further include: And transmitting the first output value to the client terminal and transmitting a data update command for the first cell to the client terminal.

At this time, when the client terminal receives the information on the row address and the column address of the first cell, the first output value and the data update command for the first cell, And a control unit that refers to information on a row address and a column address of the first cell and transmits data inserted in the first cell among a plurality of cells constituting the spreadsheet displayed on the screen through the browser, 1 Output value can be changed.

According to another embodiment of the present invention, there is provided a method of providing a web-based spreadsheet service, the method comprising: a step of, in the client terminal, extracting, from among a plurality of cells constituting the spreadsheet displayed through the browser, Wherein when at least one additional cell of the remaining cells has been inserted, the client terminal receives, from the client terminal, additional editing information including a row address and a column address of the at least one additional cell and data inserted in the at least one additional cell Information about the at least one additional cell based on the additional editing information, wherein the information for the at least one additional cell includes data inserted in the at least one additional cell, Lt; RTI ID = 0.0 > cell < / RTI > By grouping the row address assigned to my additional cells, each of the same line by line on the basis of it may further comprise the step of adding to the said list.

According to an embodiment of the present invention, when the inserted data for the first additional cell of the at least one additional cell is a function, the additional editing information may include information about the function inserted in the first additional cell, At least one second input cell referred to as an input value in a function inserted in the first additional cell, wherein the at least one second input cell is a cell included in the at least one additional cell and the at least one additional cell May further include information on the row address and the column address of the < RTI ID = 0.0 >

At this time, the step of adding on the list includes information on a function inserted in the first additional cell and information on a row address and a column address of the at least one second input cell on the additional editing information , Information on a function inserted in the first additional cell and information on a row address and a column address of the at least one second input cell are associated with each other in the function information database with reference to the additional editing information Storing information on a function inserted in the first additional cell and information on a row address and a column address of the at least one second input cell, Generating a second output value by performing a function operation on the basis of the first output value and a second output value on the list based on the second output value, The data to be is possible to include the step of including a second output value.

According to an embodiment of the present invention, the method of providing a web-based spreadsheet service may further comprise: when the generation of the second output value is completed, information on a row address and a column address of the first additional cell, And transmitting an output value to the client terminal and transmitting a data update command for the first additional cell to the client terminal.

At this time, when the client terminal receives the information on the row address and column address of the first additional cell, the second output value, and the data update command for the first additional cell, the client terminal updates the data for the first additional cell The first additional cell is connected to the first additional cell by referring to the information on the row address and the column address of the first additional cell, 2 Output values can be inserted.

The method of providing a web-based spreadsheet service according to an embodiment of the present invention has been described with reference to FIG. Here, the web-based spreadsheet service providing method according to an embodiment of the present invention can correspond to the configuration of the operation of the web-based spreadsheet service providing apparatus 110 described with reference to Figs. 1 to 6, A detailed description thereof will be omitted.

A web-based spreadsheet service providing method according to an embodiment of the present invention can be realized by a computer program stored in a storage medium for execution through a combination with a computer.

In addition, the web-based spreadsheet service providing method according to an embodiment of the present invention may be implemented in a form of a program command that can be executed through various computer means and recorded in a computer readable medium. The computer-readable medium may include program instructions, data files, data structures, and the like, alone or in combination. The program instructions recorded on the medium may be those specially designed and configured for the present invention or may be available to those skilled in the art of computer software. Examples of computer-readable media include magnetic media such as hard disks, floppy disks and magnetic tape; optical media such as CD-ROMs and DVDs; magnetic media such as floppy disks; Magneto-optical media, and hardware devices specifically configured to store and execute program instructions such as ROM, RAM, flash memory, and the like. Examples of program instructions include machine language code such as those produced by a compiler, as well as high-level language code that can be executed by a computer using an interpreter or the like.

As described above, the present invention has been described with reference to particular embodiments, such as specific elements, and specific embodiments and drawings. However, it should be understood that the present invention is not limited to the above- And various modifications and changes may be made thereto by those skilled in the art to which the present invention pertains.

Accordingly, the spirit of the present invention should not be construed as being limited to the embodiments described, and all of the equivalents or equivalents of the claims, as well as the following claims, belong to the scope of the present invention .

Claims (16)

Information about at least one cell in which data is inserted among a plurality of cells constituting a spreadsheet, information about the at least one cell is allocated to each of the at least one cell and data inserted in the at least one cell, Grouped in the same row unit on the basis of the row address assigned to each of the at least one cell, the list comprising a list of each row address grouped with information about the at least one cell A cell database that stores information about the cell; And
A spreadsheet data transmitting unit for extracting data on the list from the cell database and transmitting data for the list to the client terminal when an open command for the spreadsheet is received from the client terminal,
Lt; / RTI >
The client terminal
And when the data for the list is received, checking the row address for the at least one cell grouped on the list through the browser of the client terminal, and determining information about the at least one cell included in the list Extracting the column address assigned to each of the at least one cell and the data inserted into each of the at least one cell from the extracted row address, the extracted column address, and the extracted data, And displays the plurality of cells on the screen. The method according to claim 1,
When a correction is made to the data inserted in the at least one cell among the plurality of cells constituting the spreadsheet displayed on the browser at the client terminal, An edit information receiving unit which receives edit edit information including an address, a column address, and changed data in a cell where the data modification occurs; And
An updating unit for updating information on the at least one cell included in the list stored in the cell database based on the received modified editing information,
Based spreadsheet service providing apparatus. 3. The method of claim 2,
At least one first input cell referenced by information about the function and an input value in the function if the function is inserted in a first one of the at least one cell, A function information database in which information on a row address and a column address of a cell included in one cell correspond to each other and stored
Further comprising:
The update unit
And when the correction editing information is received from the client terminal, referring to the information on the row address and the column address of the at least one first input cell stored in the function information database, An edit determining unit for determining whether a correction has occurred in the at least one first input cell;
If it is determined that the modification of the data according to the received modified edit information has occurred in the at least one first input cell, the information on the function stored in the function information database is referred to, A function operation performing unit operable to perform a function operation based on the change data of the at least one first input cell to generate a first output value; And
And for changing data inserted in the first cell to the first output value on the basis of the first output value,
Based spreadsheet service providing apparatus. The method of claim 3,
The spreadsheet data transfer unit
When the data inserted in the first cell is changed to the first output value, transmits information on the row address and column address of the first cell and the first output value to the client terminal, An update data transfer unit for transferring a data update command for the cell to the client terminal,
Lt; / RTI >
The client terminal
When receiving the information on the row address and the column address of the first cell and the data update command for the first cell and the first output value, Refers to information on a row address and a column address and changes data inserted in the first cell among a plurality of cells constituting the spreadsheet displayed on the screen through the browser to the first output value A web-based spreadsheet service provider. 5. The method of claim 4,
The editing information receiver
When insertion of data occurs in at least one additional cell among the plurality of cells constituting the spreadsheet displayed through the browser in the client terminal except for the at least one cell, Receiving additional editing information including a row address and a column address of the at least one additional cell and data inserted into the at least one additional cell,
The update unit
Wherein the information for the at least one additional cell based on the further editing information, the information for the at least one additional cell is allocated to each of the at least one additional cell and the data inserted in the at least one additional cell Wherein the at least one additional cell is grouped in units of rows based on a row address assigned to each of the at least one additional cell and added to the list. 6. The method of claim 5,
The additional editing information includes
If the inserted data for the first additional cell of the at least one additional cell is a function, the information about the inserted function in the first additional cell and the information about the function inserted in the first additional cell, Wherein the at least one second input cell further comprises information about a row address and a column address of a second input cell, the at least one second input cell being a cell included in the at least one cell and the at least one additional cell,
The update unit
If it is confirmed that information on a function inserted in the first additional cell and information on a row address and a column address of the at least one second input cell are included in the additional editing information, A function information update unit for storing information on a function inserted in the first additional cell and information on a row address and a column address of the at least one second input cell in association with each other,
Further comprising:
The function calculation unit
Based on data inserted in the at least one second input cell by referring to information on a function inserted in the first additional cell and information on a row address and a column address of the at least one second input cell, Thereby generating a second output value,
The data changing unit
Based on the second output value, data to be inserted into the first additional cell as the second output value on the list. The method according to claim 6,
The update data transfer unit
When the generation of the second output value is completed, information on a row address and a column address of the first additional cell and the second output value are transmitted to the client terminal and a data update command To the client terminal,
The client terminal
When receiving the information on the row address and column address of the first additional cell and the data update command on the second output value and on the first additional cell according to the data update command for the first additional cell, One of the plurality of cells constituting the spreadsheet displayed on the screen is inserted into the first additional cell through the browser by referring to the information on the row address and the column address of the first additional cell A web-based spreadsheet service provider. Information about at least one cell in which data is inserted among a plurality of cells constituting a spreadsheet, information about the at least one cell is allocated to each of the at least one cell and data inserted in the at least one cell, Grouped in the same row unit on the basis of the row address assigned to each of the at least one cell, the list comprising a list of each row address grouped with information about the at least one cell - maintaining a cell database that stores information about a cell; And
Extracting data for the list from the cell database and transmitting data for the list to the client terminal when an open command for the spreadsheet is received from the client terminal
Lt; / RTI >
The client terminal
And when the data for the list is received, checking the row address for the at least one cell grouped on the list through the browser of the client terminal, and determining information about the at least one cell included in the list Extracting the column address assigned to each of the at least one cell and the data inserted into each of the at least one cell from the extracted row address, the extracted column address, and the extracted data, And displaying the plurality of cells on the screen. 9. The method of claim 8,
When a correction is made to the data inserted in the at least one cell among the plurality of cells constituting the spreadsheet displayed on the browser at the client terminal, Receiving modified edit information including an address, a column address, and changed data in a cell in which data modification has occurred; And
Updating the information on the at least one cell contained in the list stored in the cell database based on the received modified editing information
Based spreadsheet service. 10. The method of claim 9,
At least one first input cell referenced by information about the function and an input value in the function if the function is inserted in a first one of the at least one cell, A step of maintaining a function information database in which information on a row address and a column address of a cell included in one cell correspond to each other and stored
Further comprising:
The updating step
And when the correction editing information is received from the client terminal, referring to the information on the row address and the column address of the at least one first input cell stored in the function information database, Determining whether a modification occurred in the at least one first input cell;
If it is determined that the modification of the data according to the received modified edit information has occurred in the at least one first input cell, the information on the function stored in the function information database is referred to, Generating a first output value by performing a functional operation based on the change data of the at least one first input cell; And
Changing data inserted in the first cell on the list to the first output value based on the first output value
Based spreadsheet service. 11. The method of claim 10,
When the data inserted in the first cell is changed to the first output value, transmits information on the row address and column address of the first cell and the first output value to the client terminal, Transmitting a data update command for the cell to the client terminal
Further comprising:
The client terminal
When receiving the information on the row address and the column address of the first cell and the data update command for the first cell and the first output value, Refers to information on a row address and a column address and changes data inserted in the first cell among a plurality of cells constituting the spreadsheet displayed on the screen through the browser to the first output value How to provide a web-based spreadsheet service. 11. The method of claim 10,
When insertion of data occurs in at least one additional cell among the plurality of cells constituting the spreadsheet displayed through the browser in the client terminal except for the at least one cell, Receiving additional editing information including a row address and a column address of the at least one additional cell and data inserted into the at least one additional cell; And
Wherein the information for the at least one additional cell based on the further editing information, the information for the at least one additional cell is allocated to each of the at least one additional cell and the data inserted in the at least one additional cell Grouped in the same row unit based on the row address assigned to each of the at least one additional cell and adding it to the list
Based spreadsheet service. 13. The method of claim 12,
The additional editing information includes
If the inserted data for the first additional cell of the at least one additional cell is a function, the information about the inserted function in the first additional cell and the information about the function inserted in the first additional cell, Wherein the at least one second input cell further comprises information about a row address and a column address of a second input cell, the at least one second input cell being a cell included in the at least one cell and the at least one additional cell,
The step of adding on the list
If it is confirmed that information on a function inserted in the first additional cell and information on a row address and a column address of the at least one second input cell are included in the additional editing information, Storing information on a function inserted in the first additional cell and information on a row address and a column address of the at least one second input cell in association with each other in the function information database;
Based on data inserted in the at least one second input cell by referring to information on a function inserted in the first additional cell and information on a row address and a column address of the at least one second input cell, Generating a second output value by performing an operation; And
Including in the list based on the second output value, data to be inserted into the first additional cell as the second output value
Based spreadsheet service. 14. The method of claim 13,
When the generation of the second output value is completed, information on a row address and a column address of the first additional cell and the second output value are transmitted to the client terminal and a data update command To the client terminal
Further comprising:
The client terminal
When receiving the information on the row address and column address of the first additional cell and the data update command on the second output value and on the first additional cell according to the data update command for the first additional cell, One of the plurality of cells constituting the spreadsheet displayed on the screen is inserted into the first additional cell through the browser by referring to the information on the row address and the column address of the first additional cell How to provide a web-based spreadsheet service. A computer-readable recording medium recording a program for performing the method of any one of claims 8 to 14. 15. A computer program stored in a storage medium for executing the method of any one of claims 8 to 14 through a combination with a computer.

Images