JP6759552B2 - Information processing equipment and information processing programs - Google Patents

Description

The present invention relates to an information processing device and an information processing program.

In Patent Document 1, the problem is that the information indicated by the sticky note cannot be properly shared in the conventional information processing device, and the display form designation reception unit that accepts the form identification information of the form and the display form designation reception unit accept the information. The form information used for the form corresponding to the form identification information and the screen configuration information constituting the form screen are read from the form information storage unit and the screen configuration information storage unit, and the screen configuration unit constituting the form screen. Display form designation The sticky note information acquisition unit that acquires the sticky note information associated with the form information corresponding to the form identification information received by the reception unit from the sticky note information storage unit, and the acquired sticky note information are placed on the form. It is disclosed that the sticky note screen component unit that constitutes the screen of the sticky note, the screen component unit, and the output unit that outputs the screen composed of the sticky note screen component unit are provided.

A subject of Patent Document 2 is to provide a network system, a server device, and a groupware program that improve user operability by linking various information between groupware functions, and the storage means is an image. The data attached to the object is stored in association with the window displayed in a superimposed manner, and all the data attached to the image object is stored in the data item regardless of whether the data attached to the image object is on any of the windows. It is possible, and when the image object on the first window is moved onto the seat image of the seating chart window, the client device requests the server device to update the data attached to the image object, and the storage means is , It is disclosed that while inheriting the data attached to the image object, the image object is stored in the data item in association with the user data attached to the moved or copied seat image and the message view window. ..

Japanese Unexamined Patent Publication No. 2009-093389 Japanese Unexamined Patent Publication No. 2011-164696

In the technique described in Patent Document 1, an electronic sticky note (also referred to as an electronic card or the like, hereinafter simply referred to as a sticky note) is attached to a form or the like. Then, in addition to the memo information, the sticky note information includes display attributes and the like (information for designating the color, shape, size, stacking order, etc.) when composing the image of the sticky note.
However, it was not possible to set the attributes according to the position where the sticky note was pasted on the table.
Therefore, an object of the present invention is to provide an information processing device and an information processing program capable of setting information in a cell related to the pasted position as an attribute of a sticky note pasted on a table. It is supposed to be.

The gist of the present invention for achieving such an object lies in the inventions of the following items.

The invention of claim 1 comprises a first specific means for specifying the position of a sticky note attached on a table, a second specific means for specifying a cell in the table from the position, and the sticky note from the cell. A third specific means for specifying a cell to be an attribute of the sticky note , a setting means for setting information in a cell specified by the third specific means as an attribute of the sticky note , a pattern in the table, the number of columns, The reception means that accepts the number of rows, the presentation control means that controls to present the table according to the information received by the reception means, and the cell of the attribute on the presented table according to the pattern of the table. It is an information processing device having an extraction means for extracting attribute information from a sticky note attached .

In the invention of claim 3 , the third specific means is specified by the cell at the head position of the column to which the cell specified by the second specific means belongs in the table, and the second specific means. The cell at the beginning of the row to which the cell belongs, or both the cell at the beginning of the column to which the cell identified by the second specific means belongs and the cell at the beginning of the row. The information processing apparatus according to claim 1 or 2 , which specifies any one of them .

In the invention of claim 4, as the pattern of the table, any one of the cell at the head position of the column and the cell at the head position of the row is set as the attribute name, and the cell is set at the head position of the column. In the case of a certain cell, a cell other than the beginning of the column is used as an attribute, and in the case of a cell in which the cell is located at the beginning of the row, a cell other than the beginning of the row is used as an attribute. The cell of the attribute name and the cell of the attribute are specified according to the pattern in the table, and the setting means uses the information in the cell of the attribute name specified by the third specific means as the attribute name and is in the cell of the attribute. The information processing apparatus according to claim 1, wherein the information of the above is set as an attribute on the sticker.
The invention of claim 5 further includes a pattern of the table, a number of columns, and a receiving means for receiving the number of rows, and the pattern of the table is a cell at the head of a column and a reception means at the head of a row. If any one of the cells is the attribute name, the cell is the cell at the beginning of the column, the cell other than the beginning of the column is the attribute, and the cell is the cell at the beginning of the row. Uses cells other than the beginning of the row as attributes, the third specific means identifies cells with attribute names and attribute cells according to the pattern in the table, and the setting means uses the third specific means. The information processing apparatus according to claim 2, wherein the information in the cell of the attribute name specified by is set as the attribute name, and the information in the cell of the attribute is set as the attribute in the sticker.

The invention of claim 6 comprises a reception means that receives the pattern, the number of columns, and the number of rows of the table, a presentation control means that controls to present the table according to the information received by the reception means, and the table. according to the pattern, the pasted into a cell of the attribute on the presented table tag, an information processing apparatus according to claim 2, further comprising extraction means for extracting information of attributes, the.

In the invention of claim 7, when the sticky note is pasted across cells and the attributes set on the sticky note are continuous, the setting means is intermediate between the values of the attributes of the cells straddling the sticky notes. setting the specific value as the attribute, an information processing apparatus according to claim 1.

The invention of claim 8 performs a second receiving means for receiving the table, a generating means for generating a sticky note containing information in a cell of the table, and a control for presenting the table and the sticky note. an information processing apparatus according to any one of claims 1 to 7, further comprising a second presentation control means.

The invention of claim 9 is to output a sticky note with an attribute set, and to output a table from the information in the sticky note pasted on the table as information in the cell at the position where the sticky note is pasted. or information processing according to any one of claims 1 to 8 having further outputting on the basis of the specified attributes in a tabular format, and output means for performing any one or a combination of these, the It is a device.

The invention of claim 10 describes the computer as a first specific means for specifying the position of a sticky note attached on a table, a second specific means for specifying a cell in the table from the position, and the cell. A third specific means for specifying a cell to be an attribute of the sticky note , a setting means for setting information in a cell specified by the third specific means as an attribute of the sticky note , and a pattern in the table. A reception means that accepts the number of columns and rows, a presentation control means that controls to present a table according to the information received by the reception means, and attributes on the table presented according to the pattern of the table. It is an information processing program for functioning as an extraction means for extracting attribute information from a sticky note attached to a cell of .
The invention of claim 11 describes the computer as a first specific means for specifying the position of a sticky note attached on a table, a second specific means for specifying a cell in the table from the position, and the cell. The sticky note is pasted across the cells as information in the cell specified by the third specific means for specifying the cell that is the attribute of the sticky note and the third specific means, and the sticky note is attached to the sticky note. When the set attributes are continuous, it is an information processing program for functioning as a setting means for setting an intermediate value of the attribute values of the straddling cells as the attribute of the sticky note.

According to the information processing apparatus of claim 1, for the sticky note pasted on the table, the information in the cell related to the pasted position can be set as an attribute. In addition, the attribute information can be extracted from the sticky note attached to the attribute cell on the table.
According to the information processing apparatus of claim 2, for the sticky note pasted on the table, the information in the cell related to the pasted position can be set as an attribute. Further, even when the sticky note is pasted across cells, it is possible to set an intermediate value of the attribute value of the straddling cell as an attribute on the sticky note.

According to the information processing apparatus of claim 3 , the cell at the head position of the column to which the cell specified by the second specific means belongs, and the row to which the cell specified by the second specific means belongs. Identifying any one of the cell at the beginning or both the cell at the beginning of the column and the cell at the beginning of the row to which the cell identified by the second identification means belongs. Can be done.

According to the information processing apparatus of claim 4 , any one of the cell at the head position of the column and the cell at the head position of the row is used as the attribute name, and that cell is the cell at the head position of the column. In the case of, a cell other than the beginning of the column can be an attribute, and if the cell is a cell at the beginning of the row, a cell other than the beginning of the row can be an attribute.
According to the information processing apparatus of claim 5, any one of the cell at the head position of the column and the cell at the head position of the row is used as the attribute name, and that cell is the cell at the head position of the column. In the case of, a cell other than the beginning of the column can be an attribute, and if the cell is a cell at the beginning of the row, a cell other than the beginning of the row can be an attribute.

According to the information processing apparatus of claim 6 , attribute information can be extracted from the sticker attached to the attribute cell on the table.

According to the information processing apparatus of claim 7 , even when a sticky note is pasted across cells, it is possible to set an intermediate value of the attribute value of the straddling cell as an attribute on the sticky note. it can.

According to the information processing apparatus of claim 8 , it is possible to present a sticky note containing the information in the cell of the table.

According to the information processing apparatus of claim 9 , the sticky note with the attribute set is output, and the information in the sticky note pasted on the table is output as the information in the cell at the position where the sticky note is pasted. Either one of the above, or the output in tabular format based on the specified attributes, or a combination thereof can be performed.

According to the information processing program of claim 10 , for the sticky note pasted on the table, the information in the cell related to the pasted position can be set as an attribute. In addition, the attribute information can be extracted from the sticky note attached to the attribute cell on the table.
According to the information processing program of claim 11, for the sticky note pasted on the table, the information in the cell related to the pasted position can be set as an attribute. Further, even when the sticky note is pasted across cells, it is possible to set an intermediate value of the attribute value of the straddling cell as an attribute on the sticky note.

It is a conceptual module configuration diagram about the configuration example of this embodiment. It is explanatory drawing which shows the system configuration example using this embodiment. It is explanatory drawing which shows the use example of the shared sticky note information processing apparatus, and the sticky note information processing apparatus. It is explanatory drawing which shows the processing example of display control. It is explanatory drawing which shows the data structure example of a table structure table. It is explanatory drawing which shows the data structure example of the background attribute information table. It is explanatory drawing which shows the data structure example of the sticky note information table. It is explanatory drawing which shows the data structure example of the sticky note attribute information table. It is a flowchart which shows the processing example by this embodiment. It is explanatory drawing which shows the display example for setting a table. It is explanatory drawing which shows the example of the pattern of a table. It is explanatory drawing which shows the display example of a table. It is a flowchart which shows the processing example by this embodiment. It is explanatory drawing which shows the display example of a table. It is explanatory drawing which shows the display example of an attribute. It is explanatory drawing which shows the display example for setting of export. It is explanatory drawing which shows the example which output the exported information as a table. It is explanatory drawing which shows the processing example by this embodiment. It is explanatory drawing which shows the data structure example of a table structure table. It is explanatory drawing which shows the data structure example of the background attribute information table. It is explanatory drawing which shows the data structure example of the sticky note information table. It is explanatory drawing which shows the data structure example of the sticky note attribute information table. It is explanatory drawing which shows the processing example by this embodiment. It is explanatory drawing which shows the data structure example of a table structure table. It is explanatory drawing which shows the data structure example of the background attribute information table. It is explanatory drawing which shows the data structure example of the sticky note information table. It is explanatory drawing which shows the data structure example of the sticky note attribute information table. It is explanatory drawing which shows the processing example by this embodiment. It is explanatory drawing which shows the processing example by this embodiment. It is a block diagram which shows the hardware configuration example of the computer which realizes this embodiment.

Hereinafter, an example of a preferred embodiment for realizing the present invention will be described with reference to the drawings.
FIG. 1 shows a conceptual module configuration diagram for a configuration example of the present embodiment.
The module generally refers to parts such as software (computer program) and hardware that can be logically separated. Therefore, the module in this embodiment refers not only to the module in the computer program but also to the module in the hardware configuration. Therefore, in the present embodiment, a computer program for functioning as those modules (a program for causing the computer to execute each procedure, a program for causing the computer to function as each means, and each function for the computer). It also serves as an explanation of the program), system and method for realizing the above. However, for convenience of explanation, "remember", "remember", and equivalent words are used, but these words are stored in a storage device or stored when the embodiment is a computer program. It means that the device is controlled to store it. Further, the modules may have a one-to-one correspondence with the functions, but in mounting, one module may be configured by one program, a plurality of modules may be configured by one program, and conversely, one module may be configured. May be composed of a plurality of programs. Further, the plurality of modules may be executed by one computer, or one module may be executed by a plurality of computers by a computer in a distributed or parallel environment. It should be noted that one module may include another module. In addition, hereinafter, "connection" is used not only for physical connection but also for logical connection (data transfer, instruction, reference relationship between data, etc.). "Predetermined" means that it is determined before the target process, not only before the process according to the present embodiment starts, but also after the process according to the present embodiment starts. However, if it is before the target process, it is used with the intention that it will be determined according to the situation / state at that time or according to the situation / state up to that point. When there are a plurality of "predetermined values", they may be different values, or two or more values (including all values, of course) may be the same. Further, the description having the meaning of "if A, do B" is used to mean "determine whether or not it is A, and if it is determined to be A, do B". However, this excludes cases where it is not necessary to determine whether or not it is A.
In addition, a system or device is configured by connecting a plurality of computers, hardware, devices, etc. by communication means such as a network (including a one-to-one correspondence communication connection), and one computer, hardware, device, etc. It also includes cases where it is realized by such means. "Device" and "system" are used as synonymous terms. Of course, the "system" does not include anything that is nothing more than a social "mechanism" (social system) that is an artificial arrangement.
In addition, for each process by each module or when multiple processes are performed in the module, the target information is read from the storage device, and after the processes are performed, the process results are written to the storage device. is there. Therefore, the description of reading from the storage device before processing and writing to the storage device after processing may be omitted. The storage device here may include a hard disk, a RAM (Random Access Memory), an external storage medium, a storage device via a communication line, a register in a CPU (Central Processing Unit), and the like.

The information processing device 100 according to the present embodiment attaches a sticky note on the table, and as shown in the example of FIG. 1, the sticky note creation module 105, the sticky note display information configuration module 110, and the sticky note information management module 115. , Background screen configuration module 120, sticky note-background relationship analysis module 125, sticky note attribute setting module 130, tabular background creation module 135, sticky note information DB 140, sticky note attribute information DB 145, background information DB 150. Here, the "table" is an array composed of rows and columns, and is also called a spreadsheet or the like. Further, here, the concept of the table may include an array and includes a document such as a form. In addition, since a sticky note is attached on the table, this table serves as a mount (or background). Further, the information processing device 100 is connected to the display device 180.

The information processing device 100 and the display device 180 are used at meetings (workshops, meetings, idea extraction meetings, study meetings, etc.) held by a facilitator (generally one person) and a plurality of participants using sticky notes. To. Participants use a terminal device (sticky note information processing device 210 described later) as a terminal for participants to create a sticky note on which ideas and the like are described. Generally, as shown in the example of FIG. 3, as the sticky note information processing device 210, there are a sticky note information processing device 210A, a sticky note information processing device 210B, and the like (hereinafter, collectively referred to as a sticky note information processing device 210). There are a plurality of processing devices 210. Then, the shared sticky note information processing device 200 receives the sticky note from the sticky note information processing device 210 and attaches the sticky note on the mount. The facilitator uses the shared screen, which is the display device of the shared sticky note information processing device 200, to determine or change the position of the sticky notes on the mount, and to put together the sticky notes (associate the first sticky note with the second sticky note). It is also called group formation, etc.), and the meeting is promoted by creating sticky note information by itself. In the present embodiment, the participants include facilitators.

The sticky note information processing device 210 has, for example, a touch panel type display device and an input device, and accepts operations using a participant's finger, pen, or the like to create sticky note information. In addition to the touch panel, input using a keyboard and mouse, voice input using a microphone, image input using a camera, and the like may be used. The sticky note may have a data structure capable of managing card-type information, and its contents include, for example, text information, handwritten characters, vector data indicating figures, audio information, still image information such as photographs, and the like. It may be moving image information or the like, or a combination thereof. And the sticky note has an attribute. For example, the result of grouping (classifying, categorizing) sticky notes is set as an attribute.
The shared sticky note information processing device 200 attaches and displays a sticky note transmitted from the sticky note information processing device 210 on a mount, and processes the sticky note. As a person who instructs the processing of the sticky note, there is a facilitator and an operator of the shared sticky note information processing device 200.

At meetings using the shared sticky note information processing device 200 and the sticky note information processing device 210, discussions are held by pasting sticky notes with texts, numbers, etc. on templates and frameworks prepared as backgrounds for discussions. Will be done. In the present embodiment, a table is used as the background, cell A in the table is specified from the position of the pasted sticky note, cell B as an attribute is specified from the cell A, and the content of the cell B is specified. It is an attribute of sticky notes.
In addition, the character information and the number information in the sticky note may be aggregated. In this case, the information processing apparatus 100 makes it possible to perform this aggregation processing or the like using a table as a spreadsheet, and to use a sticky note for input to the spreadsheet. .. So to speak, it has a function as a FEP (Front End Processor) for spreadsheet software.

The sticky note creation module 105 is connected to the sticky note information DB 140. The sticky note creation module 105 creates a sticky note according to an operation by the operator. For example, a new sticky note is created, text information or the like is received from a keyboard or the like, and the content of the sticky note is used. Here, as the attributes of the sticky note, the color of the sticky note (pink, orange, green, etc.), the color of the outer frame of the sticky note, the line shape (solid line, broken line, alternate long and short dash line, etc.) may be specified.
The sticky note information DB 140 is connected to the sticky note creation module 105, the sticky note information management module 115, the sticky note-background relationship analysis module 125, and the sticky note attribute information DB 145. The sticky note information DB 140 stores the sticky notes created by the sticky note creation module 105. For example, the sticky note information table 700 is stored. FIG. 7 is an explanatory diagram showing an example of a data structure of the sticky note information table 700. The sticky note information table 700 has a sticky note ID column 710, a position column 720, a size column 730, a content column 740, and the like. In the present embodiment, the sticky note ID column 710 stores information (sticky note ID: IDentification) for uniquely identifying the sticky note. The position column 720 stores the position where the sticky note is attached. The size column 730 stores the size of the sticky note (for example, length, width, etc.). The content column 740 stores the content of the sticky note. Further, the sticky note information table 700 may store information such as the date and time when the sticky note was created, the creator, and the like.

The sticky note display information configuration module 110 is connected to the sticky note information management module 115 and the display control module 185 of the display device 180. The sticky note display information configuration module 110 displays a sticky note on a display device (or background) such as a liquid crystal display of the display device 180, and manages the display position and size of the sticky note. For example, according to the operation of the operator, the already created sticky note is displayed, and the sticky note is moved, resized, deleted, or the like.
The sticky note information management module 115 is connected to the sticky note display information configuration module 110, the sticky note information DB 140, and the sticky note attribute information DB 145. The sticky note information management module 115 receives the result of processing such as moving the sticky note by the sticky note display information configuration module 110, and stores it in the sticky note information DB 140. Specifically, the target sticky note is reflected in the position column 720 and the size column 730 of the sticky note information table 700.
The background screen configuration module 120 is connected to the display control module 185 of the display device 180. The background screen configuration module 120 displays a table as a background on a display screen such as a liquid crystal display included in the display device 180. Then, it manages which part of the table is displayed on the display device. This information (information indicating which part of the table is displayed on the display device) is passed to the sticky note-background relationship analysis module 125. That is, this information is information that can correspond the physical display position of the sticky note on the display device with the display portion of the table as the background.

The sticky note-background relationship analysis module 125 is connected to the sticky note attribute setting module 130, the sticky note information DB 140, and the background information DB 150. The relationship analysis module 125 between the sticky note and the background identifies the position of the sticky note pasted on the table by using the information from the background screen configuration module 120 and the information in the sticky note information DB 140, and the position of the sticky note is used in the table. Identify the cell of. Specifically, the physical position of the sticky note on the display device is made to correspond to the position of the cell of the table displayed on the display device, and the cell in which the sticky note is located is specified. Since the sticky note has a size, the sticky note may be pasted across cells depending on the sticky position. In this case, one cell having a predetermined position of the sticky note (for example, the coordinates of the upper left corner of the sticky note) may be specified, or a plurality of cells across the sticky note may be specified. You may.

The sticky note attribute setting module 130 is connected to the sticky note-background relationship analysis module 125 and the sticky note attribute information DB 145. The sticky note attribute setting module 130 identifies a cell that is an attribute of the sticky note from the cells specified by the background screen configuration module 120. Then, the information in the specified cell is set as an attribute of the sticky note.
Further, the sticky note attribute setting module 130 may specify cells according to the pattern in the table. Here, the pattern of the table is set by the tabular background creation module 135, and (1) a cell at the beginning (header) of the column, (2) a cell at the beginning of the row, and so on. Alternatively, it is any one of (3) both cells at the head position of the column and the head position of the row.
Further, the sticky note attribute setting module 130 may specify the attribute name cell and the attribute cell according to the pattern in the table. Then, the information in the cell of the specified attribute name may be set as the attribute name, and the information in the cell of the attribute may be set as the attribute in the sticky note. Here, the table pattern is set by the tabular background creation module 135, and one of the cell at the beginning of the column and the cell at the beginning of the row is used as the attribute name. , If the cell is at the beginning of the column, the cell other than the beginning of the column is the attribute, and if the cell is at the beginning of the row, the cell other than the beginning of the row is the attribute. Is what you do. Specifically, (4) a pattern in which the cell at the beginning of the column is the attribute name and cells other than the beginning of the column are the attributes, and (5) the cell at the beginning of the row is the attribute name. It is one of the patterns whose attributes are cells other than the beginning of the row. The patterns in the table will be described in detail with reference to the example of FIG.
Then, when the specified first cell is the first cell of the row, the sticky note attribute setting module 130 uses the information in the second cell at the first position of the column as the attribute name and uses that row as the attribute name. The attribute of the sticky note is set with the information of the cell at the intersection of the column and the column as the attribute. Here, the "cell at the beginning of the row" means a cell in the first column (to be exact, excluding the cell in the first row and the first column).
Further, in the sticky note attribute setting module 130, when the specified first cell is the first cell of the column, the information in the second cell at the first position of the row is used as the attribute name, and the column is used. The attribute of the sticky note is set with the information of the cell at the intersection of the row and the row as the attribute. Here, the "first cell in the column" means a cell in the first row (to be exact, excluding the cell in the first row and the first column).

Further, in the sticky note attribute setting module 130, when the sticky note is pasted across cells and the attributes set on the sticky note are continuous, the intermediate value of the attribute value of the straddling cell is obtained. May be set as an attribute. Here, "when the attribute has continuity" is specifically a case where the information of the attribute is a numerical value. Further, the "intermediate value" may be the median value (average value) between the two values, or may be a value according to the area where the sticky note is included in the cell. For example, if one cell contains 80% of the sticky note area and the other cell contains 20% of the sticky note area, then 80% of the attribute values in one cell and the other It may be a value obtained by adding 20% of the value of the attribute of the cell of.
Further, the sticky note attribute setting module 130 outputs the sticky note with the attribute set, and outputs the information in the sticky note pasted on the table as the information in the cell at the position where the sticky note is pasted. Or, output in a tabular format based on the specified attribute, or a combination thereof may be performed. As described above, in the "sticky note with the attribute set", the attribute is set by another method (for example, the operation of the operator) in addition to the sticky note for which the attribute setting module 130 has set the attribute. Sticky notes may be included. “Outputting in tabular format based on the specified attributes” will be described later using the example of FIG. 29.

The tabular background creation module 135 is connected to the background information DB 150. The tabular background creation module 135 accepts a table pattern, the number of columns, and the number of rows according to the operation of the operator. Then, the pattern of the table to be displayed on the display screen of the display device 180 is set, and the table is created. As the patterns in the table, there are five patterns (1) to (5) as described above.
Then, the background screen configuration module 120 controls the display control module 185 to present the table on the display screen of the display device 180 according to the information received by the tabular background creation module 135.
Then, the sticky note attribute setting module 130 may extract the attribute information from the sticky note pasted in the presented cell of the attribute on the table according to the pattern of the table. That is, the content of the sticky note attached to the cell is used as the content of the cell in the table.
Further, the tabular background creation module 135 may accept an already created table (spreadsheet).
Then, the sticky note information management module 115 may generate a sticky note containing the information in the cell of the table. The table already created can be handled in the present embodiment, and each cell in which the content is described is used as a sticky note. For the generation of sticky notes, one sticky note may be generated from one cell, or a plurality of sticky notes may be generated from one cell. For example, a sticky note may be generated for each code predetermined by the information in the cell. Specifically, the code may be a line feed code or tag information.
The background screen configuration module 120 and the sticky note display information configuration module 110 control the display control module 185 to present the table and the sticky note.

The background information DB 150 is connected to the sticky note-background relationship analysis module 125, the tabular background creation module 135, and the sticky note attribute information DB 145. The background information DB 150 stores a table as a background. For example, the table structure table 500 and the background attribute information table 600 are stored. FIG. 5 is an explanatory diagram showing an example of a data structure of the table structure table 500. The table structure table 500 has a background ID column 510, a background pattern column 520, a row number column 530, and a column number column 540. The background ID column 510 stores information (background ID) for uniquely identifying the background (table) in the present embodiment. The background pattern column 520 stores the above-mentioned pattern in the table. The number of rows column 530 stores the number of rows in the table. The column number column 540 stores the number of columns in the table.

FIG. 6 is an explanatory diagram showing an example of a data structure of the background attribute information table 600. The background attribute information table 600 stores information about cells, and has a background ID column 610, a row number column 620, a column number column 630, a position column 640, a size column 650, a row header column 660, and a column header column 670. are doing. The background ID column 610 stores the background ID. The row number column 620 stores the row numbers in the table. The column number column 630 stores the column numbers in the table. The cell is specified by the row number column 620 and the column number column 630. The position column 640 stores the position of the cell. The size column 650 stores the size of the cell. The row header column 660 stores information indicating whether or not the cell corresponds to the row header. The column header column 670 stores information indicating whether or not the cell corresponds to the column header.

The sticky note attribute information DB 145 is connected to the sticky note information management module 115, the sticky note attribute setting module 130, the sticky note information DB 140, and the background information DB 150. The sticky note attribute information DB 145 stores the attributes of the sticky note. For example, the sticky note attribute information table 800 is stored. FIG. 8 is an explanatory diagram showing an example of a data structure of the sticky note attribute information table 800. The sticky note attribute information table 800 has a sticky note information field 810, an attribute information field 820, and an attribute name field 830. The sticky note information field 810 stores sticky note information. For example, the sticky note ID is stored. The attribute information column 820 stores the attribute information. For example, the sticky note ID of the sticky note in the cell as an attribute is stored. The attribute name column 830 stores the attribute name of the attribute.

The display device 180 has a display control module 185.
The display control module 185 is connected to the sticky note display information configuration module 110 and the background screen configuration module 120 of the information processing apparatus 100. The display control module 185 displays the table and the sticky note on the display screen of the display device 180 according to the control by the sticky note display information configuration module 110 and the background screen configuration module 120. In addition to the display on a display device such as a liquid crystal display, printing by a printing device such as a printer, output of sound to an audio output device such as a speaker, vibration by a vibration device, or the like may be combined.

FIG. 2 is an explanatory diagram showing an example of a system configuration using the present embodiment. The shared sticky note information processing device 200 generally includes a large-screen display device and is operated by a facilitator. This display device is visible to all participants. Each sticky note information processing device 210 is operated by the participants at the meeting, and generally, each participant has one. For example, a tablet terminal or the like is used as the sticky note information processing device 210.
In the example of FIG. 2A1, the shared sticky note information processing device 200 has an information processing device 100 and a display device 180, and each sticky note information processing device 210 has a display device 180. The shared sticky note information processing device 200, the sticky note information processing device 210A, the sticky note information processing device 210B, and the sticky note information processing device 210C are each connected via a communication line 299. The communication line 299 may be wireless, wired, or a combination thereof, and may be, for example, the Internet as a communication infrastructure, an intranet, or the like. In this case, the information processing device 100 processes the table and sticky notes displayed on the screen of the shared sticky note information processing device 200. Then, the screen display of the shared sticky note information processing device 200 is transmitted to each sticky note information processing device 210, and the display device 180 of each sticky note information processing device 210 displays it.

In the example of FIG. 2A2, the shared sticky note information processing device 200 and each sticky note information processing device 210 have a display device 180. The information processing device 100, the shared sticky note information processing device 200, the sticky note information processing device 210A, the sticky note information processing device 210B, and the sticky note information processing device 210C are each connected via a communication line 299. In this case, the shared sticky note information processing device 200 and each sticky note information processing device 210 use the information processing device 100 via the communication line 299. According to the control of the information processing device 100, the shared sticky note information processing device 200 and the display device 180 of each sticky note information processing device 210 display the table and the sticky note. Further, the function of the information processing device 100 may be realized as a cloud service.
In the example of FIG. 2A3, each of the shared sticky note information processing device 200 and each sticky note information processing device 210 has an information processing device 100 and a display device 180. The shared sticky note information processing device 200, the sticky note information processing device 210A, the sticky note information processing device 210B, and the sticky note information processing device 210C are each connected via a communication line 299. In this case, each information processing device 100 processes the table and sticky note displayed on the screen of each sticky note information processing device (shared sticky note information processing device 200, each sticky note information processing device 210).

In the example of FIG. 2B, the shared sticky note information processing device 200, the sticky note information processing device 210A, the sticky note information processing device 210B, and the sticky note information processing device 210C are installed in the meeting room 280, and a meeting is held. The shared sticky note information processing device 200, the sticky note information processing device 210A, the sticky note information processing device 210B, and the sticky note information processing device 210C are each connected via a communication line 299. Each of the shared sticky note information processing device 200 and each sticky note information processing device 210 has a display device 180.
The devices in the information processing device 100, the background information storage device 290, the sticker information storage device 294, and the conference room 280 are connected to each other via the communication line 298. The communication line 298 may be wireless, wired, or a combination thereof, and may be, for example, the Internet as a communication infrastructure, an intranet, or the like. Further, the functions of the information processing device 100, the background information storage device 290, and the sticky note information storage device 294 may be realized as a cloud service. The background information storage device 290 has a background information DB 150. The sticky note information storage device 294 has a sticky note information DB 140 and a sticky note attribute information DB 145. The information processing device 100 performs processing using the background information DB 150 in the background information storage device 290, the sticky note information DB 140 in the sticky note information storage device 294, and the sticky note attribute information DB 145. In this case, the shared sticker information processing device 200 uses the information processing device 100 to transmit the screen display of the shared sticker information processing device 200 to each sticker information processing device 210, and the display device of each sticker information processing device 210. It may be displayed at 180. Further, each of the shared sticky note information processing device 200 and each sticky note information processing device 210 may use the information processing device 100.

FIG. 3 is an explanatory diagram showing an example of a conference room or the like in which the present embodiment is used, and an example of using the shared sticky note information processing device 200 and the sticky note information processing device 210.
As shown in the example of FIG. 3A, participants 311 and 312 and facilitator 321 are gathered in a conference room or the like. Participant 311 uses the sticky note information processing device 210A, and participant 312 uses the sticky note information processing device 210B. Generally, one terminal device (sticky note information processing device 210A, etc.) is given to each participant, and is about the size of a notebook (like the sticky note information processing device 210 shown in the example of FIG. 3C). For example, it is a tablet-type terminal (A4, B5, 7 to 10 inches, etc.), which is operated by using a finger, a pen, or the like. Participants create sticky note information containing text data, handwritten characters, figures, and the like. The terminal device is not limited to the tablet type terminal, and may be a PC (including a notebook PC) provided with a keyboard, a mouse, or the like.
The shared sticky note information processing device 200x shown in the example of FIG. 3A is a projector and displays a mount and sticky notes. The shared sticky note information processing device 200y is an electronic whiteboard that detects the movement of the facilitator 321's finger or pen, attaches the sticky note to the mount (front), moves the sticky note, and associates the sticky note (group). It accepts operations such as performing information processing. For example, the shared sticky note information processing device 200y is equipped with a pen, the pen is separated from a predetermined pen holder (the facilitator 321 lifts the pen for operation), and the position of the tip of the pen. By detecting (the tip of the pen touches the shared sticky note information processing device 200y, etc.), the operation for the mount and the sticky note is accepted. For example, a sensor (a sensor that switches on and off by the gravity of the pen, etc.) is provided in the pen holder, and which pen is used among multiple pens (black pen, red pen, blue pen, etc.) is used. You just have to detect it. Further, the entire display screen of the shared sticky note information processing device 200y is a touch sensor, and the position and pressure touched by the display screen may be detected.
Further, the shared sticky note information processing device 200 may be an electronic board as shown in the example of FIG. 3B. The electronic board generally has a large screen display device (at least larger than the display device of the sticky note information processing device 210), and the display device is a touch panel, and the position and pressure at which the display screen is touched. Is detected. For example, the screen may have a size of 80 inches or the like.

FIG. 4 is an explanatory diagram showing an example of display control processing by the display control module 185.
As shown in the example of FIG. 4A, the display control module 185 creates two layers. One is a background layer 410 for displaying a table (mounting paper), and the other is a sticky note layer 420 for displaying a sticky note. The display destination by the background screen configuration module 120 is the background layer 410, and the display destination by the sticky note display information configuration module 110 is the sticky note layer 420. Then, in general, the background layer 410 is a lower layer, the sticky note layer 420 is a higher layer, and the operation by the operator is accepted as an operation on the object (sticky note) displayed on the sticky note layer 420. Of course, a mode for accepting operations on the object (table) displayed on the background layer 410 may be prepared.
As shown in the example of FIG. 4B, the sticky notes 422 to 436 are superimposed on the table 415 on the screen 400. That is, the background screen configuration module 120 displays the table 415 on the background layer 410, the sticky note display information configuration module 110 displays the sticky notes 422 to 436 on the sticky note layer 420, and the display control module 185 displays the sticky note layer 420 on the background layer 410. It is superimposed and displayed on the screen 400.

For example, in discussions using sticky notes, the arrangement of sticky notes is changed to categorize the contents written on the sticky notes. When this embodiment is not used, the categorized information is only retained as location information, and it is difficult to reuse it. In addition, a tabular framework is prepared and sticky notes are pasted on it. When this embodiment is not used, the information about which item of the framework the sticky note is for is only retained as position information, and it is difficult to reuse it.
In the present embodiment, by pasting a sticky note on the table, attribute information is set for the sticky note from the information on the table.

FIG. 9 is a flowchart showing a processing example of the tabular background creation module 135.
In step S902, it is determined whether or not to import the background table information (spreadsheet information), and if the spreadsheet information created in advance is to be imported, the process proceeds to step S912. Otherwise, step S912 is performed. Proceed to S904.
In step S904, the number of rows and the number of columns are accepted.
In step S906, the background pattern is accepted.
In step S904 and step S906, for example, the table setting screen 1010 is displayed on the screen 1000 as shown in FIG. FIG. 10 is an explanatory diagram showing a display example for setting the table. The table setting screen 1010 displays the matrix setting area 1020 and the "background pattern selection" button 1030, and accepts the operation of the operator. That is, when the number of rows and the number of columns are accepted in the matrix setting area 1020 and the "select background pattern" button 1030 is pressed, the patterns in the table are enumerated and the patterns in the table are selected.

In step S912, the number of rows and the number of columns are extracted from the imported spreadsheet information.
In step S914, the pattern of the spreadsheet information table is accepted. Similar to step S906 (displaying the "select background pattern" button 1030 shown in the example of FIG. 10), the table pattern may be accepted according to the operation of the operator, or may be preset in the spreadsheet information. The pattern of the spreadsheet may be extracted.
In step S916, the attribute information in the spreadsheet information is extracted according to the pattern in the table.
In step S918, a sticky note is generated from the described cell in the spreadsheet information.

FIG. 11 is an explanatory diagram showing an example of the pattern in the table. The patterns (1) to (5) in the above table correspond to the examples of FIGS. 11 (a2), (a3), (a1), (b1), and (b2), respectively. It can be roughly divided into the following two patterns.
(A) The header is an attribute ((a1), (a2), (a3))
(B) The header is an attribute name, and the attributes other than the header are attributes ((b1), (b2)).
In the example of FIG. 11 (a1), the row header and the column header are the attributes of the sticky note. Specifically, for sticky notes pasted on cells in areas other than the column header group 1112 and row header group 1114, the information in the cell that is the header of the column to which the cell belongs (pasted in that cell). The attributes may be the information on the attached sticky note (the same applies hereinafter) and the information in the cell that is the header of the row to which the cell belongs. Therefore, two attributes are set for one sticky note.
In the example of FIG. 11A2, the column header is the attribute of the sticky note. Specifically, for a sticky note attached to a cell in an area other than the column header group 1122, the information in the cell that is the header of the column to which the cell belongs is used as an attribute. Therefore, one attribute is set for one sticky note.
In the example of FIG. 11 (a3), the line header is the attribute of the sticky note. Specifically, for a sticky note attached to a cell in an area other than the row header group 1134, the information in the cell that is the header of the row to which the cell belongs is used as an attribute. Therefore, one attribute is set for one sticky note.

In the example of FIG. 11 (b1), the column header is the attribute name, and the information in the cell in the same row for the sticky note in the first column is the attribute. Specifically, for the sticky note A pasted in the cell of the first column, the cell in the row to which the sticky note A belongs (in the attribute group 1146) with the information of the cell in the column header group 1142 as the attribute name. The information in cell) will be set as an attribute. Therefore, one or more attributes are set for one sticky note A. If nothing is described in the cell of the row to which the sticky note A belongs, the attribute may not be set, or the attribute which is an empty (NULL) attribute value may be set.
In the example of FIG. 11 (b2), the row header is an attribute name, and the sticky note in the same column is the attribute for the sticky note in the first row. Specifically, for the sticky note B pasted in the cell of the first row, the cell information of the cell in the row header group 1154 is used as the attribute name, and the cell of the column to which the sticky note B belongs (in the attribute group 1156). The information in cell) will be set as an attribute. Therefore, one or more attributes are set for one sticky note B. If nothing is described in the cell of the column to which the sticky note B belongs, the attribute may not be set, or the attribute which is an empty (NULL) attribute value may be set.

FIG. 12 is an explanatory diagram showing a display example of the table.
The front screen 1210 is displayed on the screen 1000 as a mount on which a sticky note is attached. In this example, a table of patterns shown in the example of FIG. 11 (a1) is displayed on the front screen 1210 with 6 rows × 5 columns. The size of each column and each row may be changed by using a program that generates a spreadsheet.

FIG. 13 is a flowchart showing a processing example of determining a target cell and a cell as an attribute from the selected table pattern.
In step S1302, the position and size of the sticky note information (specifically, the position column 720 and the size column 730 of the sticky note information table 700) and the position and size of the background information (specifically, the position column of the background attribute information table 600). From 640, size column 650), the row number and column number of the cell containing the sticky note are calculated.
In step S1304, it is determined whether each cell is an attribute cell or a sticky note cell according to the table pattern (background pattern column 520 of the table structure table 500).
In step S1306, the attribute information is extracted from the cell determined to be the attribute cell in step S1304.
In step S1308, for the sticky note attached to the cell determined to be the sticky note cell in step S1304, the cell to be an attribute is determined according to the table pattern. For example, in the case of a sticky note attached to a cell (row 2, column 3) in the pattern (a1), the cells (row 2, column 1) and (row 1, column 3) are attributes.

In step S1310, the sticky note attached to the cell that is the attribute is acquired. Then, the information described in the sticky note is acquired as attribute information. The information described in the attribute cell in the table may be acquired as the attribute information.
In step S1312, attribute information is associated with each sticky note. That is, as the attribute of the sticky note pasted on the cell determined to be the sticky note cell in step S1304, the information of the attribute cell corresponding to the cell (attribute information acquired in step S1310) is set.
FIG. 14 is an explanatory diagram showing a display example of the table. The front screen 1210 is displayed on the screen 1000. Attribute sticky notes are pasted in the first cell of each row and each column. Then, it is attached to a cell to which a sticky note (Company A) 1432 or the like is applied (a cell in which a column to which an attribute applies and a row intersect). This table is the pattern shown in the example of FIG. 11 (a1). Sticky note (development) 1412 is (2,1), sticky note (production) 1414 is (3,1), sticky note (sales) 1416 is (4,1), sticky note (management) 1418 is (5,1), sticky note ( (Manufacturing) 1422 is (1,2), Sticky Note (Finance) 1424 is (1,3), Sticky Note (Education) 1426 is (1,4), Sticky Note (Food) 1428 is (1,5), Sticky Note (Company A) ) 1432 is (2,3), sticky note (Company D) 1434 is (2,3), sticky note (Company C) 1436 is (3,3), sticky note (Company E) 1438 is (4,2), sticky note ( Company B) 1440 is in the position (5, 5). Therefore, the content (development) of the sticky note (development) 1412 and the content (finance) of the sticky note (finance) 1424 are set as the attributes of the sticky note (company A) 1432, and the sticky note (development) is set as the attribute of the sticky note (company D) 1434. ) The contents of 1412 (development) and the contents of sticky notes (finance) 1424 (finance) are set, and the contents of sticky notes (production) 1414 and the contents of sticky notes (finance) 1424 are set as attributes of sticky notes (company C) 1436. (Finance) is set, and the content (sales) of the sticky note (sales) 1416 and the content (manufacturing) of the sticky note (manufacturing) 1422 are set as the attributes of the sticky note (company E) 1438, and the attributes of the sticky note (company B) 1440. As a result, the content (management) of the sticky note (management) 1418 and the content (food) of the sticky note (food) 1428 are set.

FIG. 15 is an explanatory diagram showing an example of displaying attributes. For each sticky note, the contents of the row and the first cell of the cell to which the sticky note is pasted are set as attributes. For example, it is shown that the content (development) of the sticky note (development) 1412 is given as the attribute 1 of the sticky note (company A) 1432, and the content (finance) of the sticky note (finance) 1424 is given as the attribute 2. ) It is shown that the content (management) of the sticky note (management) 1418 is given as the attribute 1 of 1440, and the content (food) of the sticky note (food) 1428 is given as the attribute 2.

In step S1314, it is determined whether or not to export according to the operation of the operator, and if it is performed, the process proceeds to step S1316, and if not, the process proceeds to step S1320.
In step S1316, the selection of the attribute is accepted. FIG. 16 is an explanatory diagram showing a display example for export setting (selection of attributes). In the example of FIG. 16, of the attributes 1 (development, production, sales, management), attribute 2 (manufacturing, finance, education, food), and colors (pink, orange, green), the attributes 1 and color are exported. Indicates that the attribute of is selected.
In step S1318, the table information is exported. For example, it may be exported as CSV (Comma-Separated Values) or may be exported using the data structure of a program that generates a spreadsheet.
In step S1320, the sticky note information is stored.
FIG. 17 is an explanatory diagram showing an example in which the exported information is output as a table.
Table 1710 is displayed on the screen 1000. Table 1710 shows development in (2,1) (corresponding to sticky note (development) 1412), production in (3,1) (corresponding to sticky note (production) 1414), and sales in (4,1) (sticky note (sales)). 1416), (5,1) management (corresponding to sticky note (management) 1418), (2,2) company A (corresponding to sticky note (A company) 1432), (2,3) company D (corresponding to) Sticky note (Company D) 1434), (3,4) Company C (corresponding to Sticky Note (Company C) 1436), (4,2) Company E (corresponding to Sticky Note (Company E) 1438), (5) , 4) has company B (corresponding to sticky note (company B) 1440).
In this way, the table generated by the present embodiment can be reflected in the table generated by the program that generates the spreadsheet.

FIG. 18 is an explanatory diagram showing a processing example according to the present embodiment. Table 1800 shows the pattern of FIG. 11 (a1).
Sticky note (user) 1812 is (2,1), sticky note (facilitator) 1814 is (3,1), sticky note (operator) 1816 is (4,1), sticky note (administrator) 1818 is (5,1), Sticky notes (preparation) 1822 are (1,2), sticky notes (idea) 1824 are (1,3), sticky notes (structured) 1826 are (1,4), and sticky notes (evaluation of ideas) 1828 are (1, 5), Sticky note (summary) 1830 is (1,6), sticky note (●● function) 1852 is (2,3), sticky note (★★ function) 1854 is (2,5), sticky note (△△ function) 1856 Is (3,3), sticky note (addition of ◆◆) 1858 is (3,4), sticky note (improvement of ◎◎) 1860 is (4,2), sticky note (▽▽ function) 1862 is (4,2) , Sticky note (□□ function) 1864 is in the position of (5,2).

Table 1800 is composed of the data shown in the examples of FIGS. 19 to 22.
FIG. 19 is an explanatory diagram showing an example of a data structure of the table structure table 1900. FIG. 19 has a data structure equivalent to that of the table structure table 500 shown in the example of FIG. Table 1800 is the table format of the first row of the table structure table 1900.
FIG. 20 is an explanatory diagram showing an example of a data structure of the background attribute information table 2000. FIG. 20 has a data structure equivalent to that of the background attribute information table 600 shown in the example of FIG. It stores information about each cell in Table 1800.
FIG. 21 is an explanatory diagram showing an example of a data structure of the sticky note information table 2100. FIG. 21 has a data structure equivalent to that of the sticky note information table 700 shown in the example of FIG. The information about each sticky note pasted in Table 1800 is stored.
FIG. 22 is an explanatory diagram showing an example of a data structure of the sticky note attribute information table 2200. FIG. 22 has a data structure equivalent to that of the sticky note attribute information table 800 shown in the example of FIG. It shows the attribute set for the sticky note in Table 1800. For example, for sticky note C (sticky note (improvement of ◎◎) 1860), sticky note A (sticky note (operator) 1816) and sticky note E (sticky note (preparation) 1822) are set as attribute information. By recording the attribute information with the sticky note ID, it is possible to distinguish the sticky notes that are the attribute information even when the sticky notes having the same contents are pasted on the header. Further, the row number and the column number to which the sticky note indicating the attribute information is attached may be held in the attribute information column 2220. Further, in the patterns of FIGS. 11 (a1) to 11 (a3), the attribute name column 2230 may be unnecessary.

FIG. 23 is an explanatory diagram showing a processing example according to the present embodiment.
Sticky note (request title) 2310 is (1,1), sticky note (explanation) 2312 is (2,1), sticky note (manpower) 2314 is (3,1), sticky note (priority) 2316 is (4,1). , Sticky note (status) 2318 is (5,1), sticky note (●● function) 2322 is (1,2), sticky note (□□ function) 2324 is (1,3), sticky note (△△ function) 2326 is ( 1,4), sticky note (addition of ◆◆) 2328 is (1,5), sticky note (●● can be written) 2352 is (2,2), sticky note (□□ can be set) 2354 is (2,3) , Sticky note (△△ can) 2356 is (2,4), Sticky note (◆◆ can be added) 2358 is (2,5), Sticky note (2) 2360 is (3,2), Sticky note (1) 2362 is ( 3,3), sticky note (10) 2364 is (3,4), sticky note (5) 2366 is (3,5), sticky note (18) 2368 is (3,6), sticky note (4) 2370 is (4,3) 2), Sticky note (3) 2372 is (4,3), Sticky note (3) 2374 is (4,4), Sticky note (5) 2376 is (4,5), Sticky note (5) 2378 is (4,6) , Sticky note (new) 2380 is (5,2), sticky note (new) 2382 is (5,3), sticky note (starting) 2384 is (5,4), sticky note (completed) 2386 is (5,5) In position.
For example, in the attribute area 2330, there are a sticky note (●● can be written) 2352, a sticky note (2) 2360, a sticky note (4) 2370, and a sticky note (new) 2380, which are attributes of the sticky note (●● function) 2322. Specifically, on the sticker (●● function) 2322, the attribute value “●● can be written” of “description” (sticker (description) 2312) as the attribute name, and “manipulation” (sticker (work) 2314) as the attribute name. ) Attribute value "2", attribute name "priority" (attachment (priority) 2316) attribute value "4", attribute name "status" (attachment (status) 2318) attribute value "new" It is set.

Table 2300 is composed of the data shown in the examples of FIGS. 24 to 27.
FIG. 24 is an explanatory diagram showing an example of a data structure of the table structure table 2400. FIG. 24 has a data structure equivalent to that of the table structure table 500 shown in the example of FIG. Table 2300 is the table format of the second row of the table structure table 2400.
FIG. 25 is an explanatory diagram showing an example of a data structure of the background attribute information table 2500. FIG. 25 has a data structure equivalent to that of the background attribute information table 600 shown in the example of FIG. It stores information about each cell in Table 2300.
FIG. 26 is an explanatory diagram showing an example of a data structure of the sticky note information table 2600. FIG. 26 has a data structure equivalent to that of the sticky note information table 700 shown in the example of FIG. The information about each sticky note pasted in Table 2300 is stored.
FIG. 27 is an explanatory diagram showing an example of a data structure of the sticky note attribute information table 2700. FIG. 27 has a data structure equivalent to that of the sticky note attribute information table 800 shown in the example of FIG. It shows the attribute set for the sticky note in Table 2300. For example, with respect to sticky note E (sticky note (●● function) 2322), sticky note F (sticky note (●● can be written) 2352) of the attribute value of sticky note B (sticky note (explanation) 2312) of the attribute name as attribute information, Attribute name sticky note C (sticky note (manpower) 2314) attribute value sticky note G (sticky note (2) 2360), attribute name sticky note D (sticky note (priority) 2316) attribute value sticky note H (sticky note (4)) 2370) and the like are set.

In addition, sticky notes (18) 2368 and sticky notes (5) 2378 are attached to Table 2300. The sticky note (18) 2368 has a rule of "summing the values of the columns containing the sticky note (18) 2368", and the target sticky note (sticky note (2) 2360, sticky note (1) ) 2362, sticky note (10) 2364, sticky note (5) 2366) are totaled. In addition, the sticky note (5) 2378 has a rule of "extracting the highest value of the column containing the sticky note (5) 2378", and the target sticky note (sticky note (4) 2370, The highest value in the sticky note (3) 2372, the sticky note (3) 2374, and the sticky note (5) 2376) is extracted.

FIG. 28 is an explanatory diagram showing a processing example according to the present embodiment.
Table 2800 is a pattern of the table shown in the example of FIG. 11 (a2). In the column header 2810, which is an attribute, a value in which the content of the pasted sticky note is continuous is described. Here, the "continuous value" may be a condition that the content of the sticky note or the cell is a numerical value, or is a numerical value, and each difference between adjacent cells is a constant value (example of FIG. 23). Then, the condition may be 1).
When a sticky note is attached across cells to such a table 2800, a value corresponding to the position of the sticky note may be calculated and used as an attribute. For example, since the sticky note 2850 is pasted between the attribute 2 and the attribute 3, the attribute 2.5 is set. This makes it possible to handle continuous values such as numerical values. As a continuous value other than the numerical value, for example, there is a color or the like. If the sticky note is pasted so that it straddles red and blue, the attribute of purple (subtractive color mixing) may be set. When additive color mixing is adopted, the yellow attribute may be set. Further, as described above, a value corresponding to the area of the sticky note included in the cell may be set as an attribute.

FIG. 29 is an explanatory diagram showing a processing example according to the present embodiment. It shows one form of the output function of the sticky note attribute setting module 130, and shows an example of the above-mentioned "output in tabular form based on the specified attribute". This kind of output function is provided so that it can be used not only in the same table as the sticky note is pasted, but also when you want to combine different attributes and analyze from a different perspective. is there.
The man-hour / priority correspondence table 2900 outputs the sticky note (man-hours) 2314 of the table 2300 shown in the example of FIG. 23 as the column title and the sticky note (priority) 2316 as the tabular data of the row title. Here, as an example of the "specified attribute", the sticky note (man-hours) 2314 and the sticky note (priority) 2316 targeted for output may be predetermined titles or are designated by the operation of the operator. It may be a sticky note. Of course, any title in Table 2300 may be used, and any of them may be used as a row title or a column title in the man-hour / priority correspondence table 2900.
As an output function, the sticky note attribute setting module 130 has a function of generating tabular data showing the man-hour / priority correspondence table 2900 from the attributes designated as table 2300. Specifically, from Table 2300 illustrated in FIG. 23, the sticky note (●● function) 2322 has a sticky note (2) 2360 as a sticky note (manpower) 2314 and a sticky note (4) 2370 as a sticky note (priority) 2316. Therefore, set "●● function" (corresponding to sticky note (●● function) 2322) in the cell at position (2, 4) in the effort / priority correspondence table 2900, and sticky note (□□ function) 2324 is a sticky note. Since the sticky note (1) 2362 is used as the (manpower) 2314 and the sticky note (3) 2372 is used as the sticky note (priority) 2316, the cell at the position (1, 3) in the manpower / priority correspondence table 2900 has "□". □ Function ”(corresponding to sticky note (□□ function) 2324) is set, and sticky note (△△ function) 2326 is sticky note (10) 2364 as sticky note (manpower) 2314 and sticky note (3) 2374 as sticky note (priority) 2316. Therefore, set the "△△ function" (corresponding to the sticky note (△△ function) 2326) in the cell at the position (10, 3) in the effort / priority correspondence table 2900, and set the sticky note (◆◆). Since the (additional) 2328 has a sticky note (5) 2366 as a sticky note (manpower) 2314 and a sticky note (5) 2376 as a sticky note (priority) 2316, the position of (5, 5) in the manpower / priority correspondence table 2900. Set "Add ◆◆" (corresponding to sticky note (addition of ◆◆) 2328) in the cell.

As illustrated in FIG. 30, the hardware configuration of the computer on which the program of the present embodiment is executed is a general computer, specifically, a personal computer, a computer that can be a server, and the like. That is, as a specific example, the CPU 3001 is used as the processing unit (calculation unit), and the RAM 3002, ROM 3003, and HD 3004 are used as the storage device. As the HD3004, for example, a hard disk or SSD (Solid State Drive) may be used. Stickbook creation module 105, sticky note display information configuration module 110, sticky note information management module 115, background screen configuration module 120, sticky note-background relationship analysis module 125, sticky note attribute setting module 130, tabular background creation module 135, display control A CPU 3001 that executes a program such as a module 185, a RAM 3002 that stores the program or data, a ROM 3003 that stores a program or the like for starting the computer, and an auxiliary storage device (may be a flash memory or the like). ) HD3004, a reception device 3006 that accepts data based on user operations on keyboards, mice, touch panels, microphones, etc., output devices 3005 such as CRTs, liquid crystal displays, speakers, and communication networks such as network interface cards. It is composed of a communication line interface 3007 for connecting to and a bus 3008 for connecting them and exchanging data. A plurality of these computers may be connected to each other by a network.

Among the above-described embodiments, in the case of a computer program, the system of the present hardware configuration is made to read the computer program which is software, and the software and the hardware resources cooperate with each other to carry out the above-described embodiment. Is realized.
The hardware configuration shown in FIG. 30 shows one configuration example, and the present embodiment is not limited to the configuration shown in FIG. 30, and the module described in the present embodiment can be executed. All you need is. For example, some modules may be configured with dedicated hardware (for example, an Applied Special Integrated Circuit (ASIC)), and some modules are in an external system and are connected by a communication line. Further, a plurality of systems shown in FIG. 30 may be connected to each other by a communication line so as to cooperate with each other. In addition to personal computers, mobile information and communication devices (including mobile phones, smartphones, mobile devices, wearable computers, etc.), home information appliances, robots, copiers, fax machines, scanners, printers, multifunction devices (scanners, printers, etc.) It may be incorporated in an image processing apparatus having any two or more functions such as a copying machine and a fax machine).

The described program may be stored in a recording medium and provided, or the program may be provided by a communication means. In that case, for example, the program described above may be regarded as an invention of "a computer-readable recording medium on which the program is recorded".
The "computer-readable recording medium on which a program is recorded" means a computer-readable recording medium on which a program is recorded, which is used for program installation, execution, program distribution, and the like.
The recording medium is, for example, a digital versatile disc (DVD), which is a standard established by the DVD Forum, "DVD-R, DVD-RW, DVD-RAM, etc.", and DVD + RW. Standards such as "DVD + R, DVD + RW, etc.", compact discs (CD), read-only memory (CD-ROM), CD recordable (CD-R), CD rewritable (CD-RW), etc., Blu-ray discs (CD-RW) Blu-ray® Disc), optomagnetic disc (MO), flexible disc (FD), magnetic tape, hard disk, read-only memory (ROM), electrically erasable and rewritable read-only memory (EEPROM® )), Flash memory, random access memory (RAM), SD (Secure Digital) memory card and the like.
Then, the whole or a part of the program may be recorded on the recording medium and stored, distributed, or the like. Further, by communication, for example, a wired network used for a local area network (LAN), a metropolitan area network (MAN), a wide area network (WAN), the Internet, an intranet, an extranet, or wireless communication. It may be transmitted using a transmission medium such as a network or a combination thereof, or may be carried on a carrier.
Further, the program may be a part or all of other programs, or may be recorded on a recording medium together with a separate program. Further, the recording may be divided into a plurality of recording media. Further, it may be recorded in any mode as long as it can be restored, such as compression and encryption.
The above-described embodiment may be grasped as follows.
[A1] The first specific means for specifying the position of the sticky note pasted on the table, and
A second identification means for identifying a cell in the table from the position,
A third specific means for identifying a cell that is an attribute of the sticky note from the cell, and
Setting means for setting the information in the cell specified by the third specific means as an attribute of the sticky note.
Information processing device with.
[A2] As a table pattern, any one of a cell at the beginning of a column, a cell at the beginning of a row, or both cells at the beginning of a column and the beginning of a row. And
The third identifying means identifies cells according to the patterns in the table.
The information processing device according to [A1].
[A3] As the pattern of the table, when any one of the cell at the head position of the column and the cell at the head position of the row is used as the attribute name and the cell is at the head position of the column. Has a cell other than the beginning of the column as an attribute, and if the cell is a cell at the beginning of the row, the cell other than the beginning of the row is an attribute.
The third identification means identifies the cell of the attribute name and the cell of the attribute according to the pattern in the table.
The setting means sets the information in the cell of the attribute name specified by the third specific means as the attribute name and the information in the cell of the attribute as the attribute in the sticky note.
The information processing device according to [A1].
[A4] A reception means for accepting the pattern, the number of columns, and the number of rows in the table,
A presentation control means that controls the presentation of a table according to the information received by the reception means.
Extraction means for extracting attribute information from sticky notes attached to the presented cell of attributes on the table according to the pattern in the table.
The information processing apparatus according to any one of [A1] to [A3].
[A5] When the sticky note is pasted across cells and the attributes set on the sticky note are continuous, the setting means sets an intermediate value between the attribute values of the straddling cells. Set as an attribute,
The information processing device according to any one of [A1] to [A4].
[A6] A second receiving means for receiving the table and
A generation means for generating a sticky note containing information in the cells of the table, and
A second presentation control means for controlling the presentation of the table and the sticky note.
The information processing apparatus according to any one of [A1] to [A5].
[A7] Output a sticky note with the attribute set, output the information in the sticky note pasted on the table as information in the cell at the pasted position, or specify. Output means to output in tabular format based on the above attributes, or a combination of these
The information processing apparatus according to any one of [A1] to [A6].
[A8] Computer
The first identification means to identify the position of the sticky note pasted on the table, and
A second identification means for identifying a cell in the table from the position,
A third specific means for identifying a cell that is an attribute of the sticky note from the cell, and
Setting means for setting the information in the cell specified by the third specific means as an attribute of the sticky note.
An information processing program to function as.
The above-mentioned invention has the following effects.
According to the information processing device of [A1], for the sticky note pasted on the table, the information in the cell related to the pasted position can be set as an attribute.
According to the information processing apparatus of [A2], the pattern of the table is a cell at the beginning of the column, a cell at the beginning of the row, or both the beginning of the column and the beginning of the row. Any one of the cells can be used.
According to the information processing device of [A3], any one of the cell at the beginning of the column and the cell at the beginning of the row is used as the attribute name, and that cell is at the beginning of the column. In the case of, a cell other than the beginning of the column can be an attribute, and if the cell is a cell at the beginning of the row, a cell other than the beginning of the row can be an attribute.
According to the information processing device of [A4], the attribute information can be extracted from the sticky note attached to the attribute cell on the table.
According to the information processing device of [A5], even when a sticky note is pasted across cells, it is possible to set an intermediate value of the attribute value of the straddling cell as an attribute on the sticky note. it can.
According to the information processing apparatus of [A6], it is possible to present a sticky note containing the information in the cell of the table.
According to the information processing device of [A7], the sticky note with the attribute set is output, and the information in the sticky note pasted on the table is output as the information in the cell at the position where the sticky note is pasted. Either one of the above, or the output in tabular format based on the specified attributes, or a combination thereof can be performed.
According to the information processing program of [A8], for the sticky note pasted on the table, the information in the cell related to the pasted position can be set as an attribute.

100 ... Information processing device 105 ... Sticky note creation module 110 ... Sticky note display information configuration module 115 ... Sticky note information management module 120 ... Background screen configuration module 125 ... Sticky note and background relationship analysis module 130 ... Sticky note attribute setting module 135 ... Tabular format Background creation module 140 ... Sticky note information DB
145 ... Sticky note attribute information DB
150 ... Background information DB
180 ... Display device 185 ... Display control module 200 ... Shared sticky note information processing device 210 ... Sticky note information processing device 280 ... Conference room 290 ... Background information storage device 294 ... Sticky note information storage device 298 ... Communication line

Claims (11)

The first identification means to identify the position of the sticky note pasted on the table , and
A second identification means for identifying a cell in the table from the position,
A third specific means for identifying a cell that is an attribute of the sticky note from the cell, and
A setting means for setting the information in the cell specified by the third specific means as an attribute of the sticky note , and a setting means.
A reception means that accepts the pattern, number of columns, and number of rows in the table,
A presentation control means that controls the presentation of a table according to the information received by the reception means.
An extraction means for extracting attribute information from the sticky notes pasted in the presented attribute cells on the table according to the pattern in the table.
Information processing device with. The first identification means to identify the position of the sticky note pasted on the table, and
A second identification means for identifying a cell in the table from the position,
A third specific means for identifying a cell that is an attribute of the sticky note from the cell, and
As the information in the cell specified by the third specific means, when the sticky note is pasted across the cells and the attributes set on the sticky note are continuous, the attributes of the cells straddling the sticky notes. A setting means for setting an intermediate value of the value of the sticky note as an attribute of the sticky note, and
Information processing device with. The third specific means belongs to the cell at the head position of the column to which the cell specified by the second specific means belongs in the table, and the cell specified by the second specific means. Identify either the cell at the beginning of the row, or both the cell at the beginning of the column to which the cell identified by the second identification means belongs and the cell at the beginning of the row. To do
The information processing device according to claim 1 or 2. As the pattern of the table, one of the cell at the beginning of the column and the cell at the beginning of the row is used as the attribute name, and if the cell is the cell at the beginning of the column, the column is used. If the cell is located at the beginning of the row, the cell other than the beginning of the row is used as the attribute.
The third identification means identifies the cell of the attribute name and the cell of the attribute according to the pattern in the table.
The setting means sets the information in the cell of the attribute name specified by the third specific means as the attribute name and the information in the cell of the attribute as the attribute in the sticky note.
The information processing device according to claim 1. A reception means that accepts the pattern, number of columns, and number of rows in the table,
Have more
As the pattern of the table, one of the cell at the beginning of the column and the cell at the beginning of the row is used as the attribute name, and if the cell is the cell at the beginning of the column, the column is used. If the cell is located at the beginning of the row, the cell other than the beginning of the row is used as the attribute.
The third identification means identifies the cell of the attribute name and the cell of the attribute according to the pattern in the table.
The setting means sets the information in the cell of the attribute name specified by the third specific means as the attribute name and the information in the cell of the attribute as the attribute in the sticky note.
The information processing device according to claim 2. A reception means that accepts the pattern, number of columns, and number of rows in the table,
A presentation control means that controls the presentation of a table according to the information received by the reception means.
An extraction means for extracting attribute information from the sticky notes pasted in the presented attribute cells on the table according to the pattern in the table.
The information processing apparatus according to claim 2, further comprising. In the setting means, when the sticky note is pasted across cells and the attributes set on the sticky note are continuous, an intermediate value of the attribute values of the straddling cells is set as an attribute. To do
The information processing device according to claim 1. A second receiving means for accepting the table and
A generation means for generating a sticky note containing information in the cells of the table, and
A second presentation control means for controlling the presentation of the table and the sticky note, and
The information processing apparatus according to any one of claims 1 to 7, further comprising. Output a sticky note with attributes set, output the information in the sticky note pasted on the table as information in the cell at the pasted position, or output the specified attribute Output means that output in tabular format based on any one or a combination of these, and
The information processing apparatus according to any one of claims 1 to 8, further comprising. Computer ,
The first identification means to identify the position of the sticky note pasted on the table , and
A second identification means for identifying a cell in the table from the position,
A third specific means for identifying a cell that is an attribute of the sticky note from the cell, and
A setting means for setting the information in the cell specified by the third specific means as an attribute of the sticky note , and a setting means.
A reception means that accepts the pattern, number of columns, and number of rows in the table,
A presentation control means that controls the presentation of a table according to the information received by the reception means.
An information processing program for functioning as an extraction means for extracting attribute information from a sticky note attached to an attribute cell on the presented table according to the pattern in the table . Computer,
The first identification means to identify the position of the sticky note pasted on the table, and
A second identification means for identifying a cell in the table from the position,
A third specific means for identifying a cell that is an attribute of the sticky note from the cell, and
As the information in the cell specified by the third specific means, when the sticky note is pasted across the cells and the attributes set on the sticky note are continuous, the attributes of the cells straddling the sticky notes. An information processing program for functioning as a setting means for setting an intermediate value of the value of the sticky note as an attribute of the sticky note.

Images