Information processing device, information processing method, and information processing program

The information processing device simplifies cell combination in tables by using truth values to determine merging or separate adjacent cells, reducing complex settings and enabling efficient dynamic state control.

JP7584370B2Active Publication Date: 2024-11-15OBIC CO LTD
View PDF 5 Cites 0 Cited by

Patent Information

Application Number
JP2021119673
Authority / Receiving Office
JP · JP
Patent Type
Patents
Current Assignee / Owner
Filing Date
2021-07-20
Publication Date
2024-11-15
Estimated Expiration
2041-07-20

AI Technical Summary

Technical Problem

Conventional methods require complex setting operations for combining cells in tables, necessitating a cumulative number of patterns based on the number of cells to be combined.

Method used

An information processing device and method that allows cells to be combined with a simple setting operation by detecting cell combinations and applying truth values to determine whether adjacent cells are merged or displayed separately, reducing the need for complex pattern settings.

Benefits of technology

Enables cells to be combined efficiently with a simple operation, reducing the time and effort required for setting, and allowing dynamic state control of cell combinations based on conditions.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure 0007584370000001
    Figure 0007584370000001
  • Figure 0007584370000002
    Figure 0007584370000002
  • Figure 0007584370000003
    Figure 0007584370000003
Patent Text Reader

Abstract

To couple desired cells to each other with a simple setting operation.SOLUTION: In an information processing apparatus of the present embodiment performing cell coupling processing in a table formed of a plurality of cells, a detection unit detects coupling settings set to the cells for designating at least coupling of the cells to each other. When the coupling settings set to an adjacent cell adjacent to a coupled cell are coupling settings instructing coupling of cells to each other, a coupling processing unit performs the processing of coupling the adjacent cell adjacent to the coupled cell to the coupled cell. Consequently, the cells in the table can be dynamically coupled only by setting the coupling settings to the cells. This can eliminate the need of complicated settings for the number of cumulative patterns according to the number of cells desired to be coupled and allows coupling of the desired cells to each other with a simple setting operation.SELECTED DRAWING: Figure 34
Need to check novelty before this filing date? Find Prior Art

Description

[Technical field]

[0001] The present invention relates to an information processing device, an information processing method, and an information processing program. [Background technology]

[0002] 2. Description of the Related Art Nowadays, there are known form creation application programs that allow a user to create a form by inputting desired values ​​or the like into desired cells among input areas (cells) on a form displayed on a screen.

[0003] For example, Patent Document 1 (JP Patent Publication 2002-358297A) discloses a table creation program that allows table layout to be specified by simple operations. In the case of this table creation program, three types of data files are input: first text data in which cell strings are arranged, document data in which the first text data is typeset in a finished format for the text portion using an editing layout software, and text data composed of flag characters that indicate cell merge specification or background color specification, and document data typeset as a table is automatically created. In addition, it is possible to execute specification of a complex table layout while checking it on an interactive screen. This reduces the burden on the operator and enables table layout specification by simple operations. [Prior art documents] [Patent documents]

[0004] [Patent Document 1] JP 2002-358297 A Summary of the Invention [Problem to be solved by the invention]

[0005] However, in the past, when dynamically combining cells, a problem occurred in that a cell combining setting operation was required for a cumulative number of patterns corresponding to the number of cells to be combined.

[0006] The present invention has been made in view of the above, and has an object to provide an information processing device, an information processing method, and an information processing program that enable desired cells to be merged with each other through a simple setting operation. [Means for solving the problem]

[0007] In order to solve the above-mentioned problems and achieve the object, an information processing device according to the present invention is an information processing device that performs a process of merging cells in a table formed of a plurality of cells, and includes a detection unit that detects a merging setting that is set for a cell and is used to specify at least a merging of cells, and a merging processing unit that performs a process of merging the adjacent cell adjacent to the joined cell to the joined cell when a merging setting that is set for an adjacent cell adjacent to a joined cell is a merging setting that instructs the merging of cells. The merging setting includes a true / false value of cell use indicating whether or not the cell is to be used, and the merging processing unit displays the adjacent cell in a state in which the adjacent cell is not merged with the joined cell when the true / false value included in the merging setting set for the adjacent cell is a value of "true" indicating that the adjacent cell is to be used, and performs a merging process of the adjacent cell to the joined cell when the true / false value included in the merging setting set for the adjacent cell is a value of "true" indicating that the adjacent cell is not to be used.

[0008] In order to solve the above-mentioned problems and achieve the object, an information processing method according to the present invention is an information processing method in an information processing device that performs a process of merging cells in a table formed of a plurality of cells, the method including: a detection step in which a detection unit detects a merging setting set for a cell for at least specifying merging of cells; and a merging processing step in which a merging processing unit performs a process of merging the adjacent cell adjacent to the joined cell to the joined cell when the merging setting set for an adjacent cell adjacent to the joined cell is a merging setting that instructs merging of cells. The coupling setting includes a truth value of cell use indicating whether or not the cell is to be used, and in the coupling processing step, if the truth value included in the coupling setting set for the adjacent cell is a "true" value indicating that the adjacent cell is to be used, the adjacent cell is displayed in a state in which the adjacent cell is not coupled to the coupled cell, and if the truth value is a "false" value indicating that the adjacent cell is not to be used, the adjacent cell is coupled to the coupled cell.

[0009] In order to solve the above-mentioned problems and achieve the object, an information processing program according to the present invention is an information processing program for an information processing device that performs a process of merging cells in a table formed of a plurality of cells, and includes a computer as a detection unit that detects a merge setting set for a cell for at least specifying merging of cells, and a merge processing unit that performs a process of merging the adjacent cell adjacent to the merged cell to the merged cell when the merge setting set for an adjacent cell adjacent to the merged cell is a merge setting that instructs merging of the cells. The merging setting includes a true / false value of cell use indicating whether or not the cell is to be used, and the merging processing unit displays the adjacent cell in a state where the adjacent cell is not merged with the joined cell when the true / false value included in the merging setting set for the adjacent cell is a "true" value indicating that the adjacent cell is to be used, and performs merging processing of the adjacent cell to the joined cell when the true / false value included in the merging setting set for the adjacent cell is a "true" value indicating that the adjacent cell is not to be used. Effect of the Invention

[0010] According to the present invention, it is possible to advantageously combine desired cells with a simple setting operation. [Brief description of the drawings]

[0011] [Figure 1] FIG. 1 is a diagram illustrating an example of the table. [Diagram 2] FIG. 2 is a diagram for explaining the configuration of the table. [Diagram 3] FIG. 3 is a diagram for explaining rows and columns of a table. [Figure 4] FIG. 4 is a diagram showing a display form of the merged cells. [Diagram 5] FIG. 5 is a diagram showing an example of setting data for each cell of a table. [Figure 6] FIG. 6 is a diagram for explaining the setting of column span in the journal entry input system of the reference example. [Figure 7] FIG. 7 shows the execution screen in which the position of the cell has been changed. [Figure 8] FIG. 8 is a diagram showing a system configuration of the journal entry input system according to the embodiment. [Figure 9] FIG. 9 is a diagram showing the configuration of an application Web server device. [Figure 10] FIG. 10 is a diagram showing an example of a setting screen that is displayed by the business support program and is operated by the development user. [Figure 11] FIG. 11 is a diagram showing an example in which the display combination setting of "display" is performed for the cell of analysis 2 in the detail section of the setting screen. [Figure 12] FIG. 12 is a diagram showing an example in which the display merge setting of "merge to the left" is applied to the cell of analysis 2 in the detail section. [Figure 13] FIG. 13 is a diagram showing an example in which the display merge setting of "merge to the left" is applied to the cell of analysis 2 in the header section. [Figure 14] FIG. 14 is a diagram showing the display combination settings for "conditionally controlled." [Figure 15] FIG. 15 is a diagram showing an example of the variable setting screen. [Figure 16] FIG. 16 is a diagram showing an example of dynamic combination settings of cells. [Figure 17] FIG. 17 is a diagram showing an example of setting data stored in the development database when the display combination setting for a cell is set to "conditionally controlled." [Figure 18] FIG. 18 is a diagram illustrating an example of a program for executing the dynamic state control. [Figure 19] FIG. 19 is a flowchart of an API call process in the start event handler. [Figure 20] FIG. 20 is a diagram showing detailed settings of an API call process in a start event handler. [Figure 21] FIG. 21 illustrates a data structure of the API call process. [Figure 22] FIG. 22 is a flowchart showing the flow of operations of the application Web server device based on the business support program. [Figure 23] FIG. 23 is a schematic diagram of the execution process of a predefined start event handler. [Figure 24] FIG. 24 is a schematic diagram for explaining the evaluation process of the dynamic state control. [Diagram 25] FIG. 25 is a flowchart for evaluating dynamic state control of the display combination setting of two detailed analysis cells. [Figure 26] FIG. 26 is a diagram showing an example of the values ​​of variables set in each analysis cell. [Figure 27] FIG. 27 is a diagram for explaining the evaluation operation of the display combination setting of the detailed analysis cell 2 by the evaluation unit. [Figure 28] FIG. 28 is a diagram for explaining the evaluation operation of the display combination setting of the detailed analysis cell 3 by the evaluation unit. [Figure 29] FIG. 29 is a diagram for explaining the evaluation operation of the display combination setting of the detailed analysis cell 4 by the evaluation unit. [Diagram 30]FIG. 30 is a diagram for explaining the evaluation operation of the display combination setting of the detailed analysis cell 5 by the evaluation unit. [Diagram 31] FIG. 31 is a flowchart showing the flow of the column span calculation operation by the calculation unit. [Diagram 32] FIG. 32 is a diagram showing the display binding settings of all cells that have been replaced with static setting values ​​in the dynamic state control evaluation process, sorted in the order of row index and column index. [Diagram 33] FIG. 33 is a diagram in which, of all the cells shown in FIG. 32, the cells in the same row are arranged in order. [Diagram 34] FIG. 34 is a schematic diagram showing the cell merging process for the cells in analysis 1. [Diagram 35] FIG. 35 is a schematic diagram showing the cell merging process for the cells in analysis 2. [Diagram 36] FIG. 36 is a schematic diagram showing the cell merging process for the cells in analysis 3. [Figure 37] FIG. 37 is a schematic diagram showing the cell merging process for the cells in analysis 4. [Figure 38] FIG. 38 is a schematic diagram showing the cell merging process for the cells in analysis 5. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0012] Hereinafter, a journal entry input system according to an embodiment of the present invention, to which an information processing device, an information processing method, and an information processing program are applied, will be described in detail with reference to the drawings. Note that the present invention is not limited to the embodiment.

[0013] [overview] First, the journal entry input system according to the embodiment displays a "table" whose interior is divided into a grid. This table is made up of a number of squares (divided areas) called "cells." A business user inputs desired characters, numbers, etc. into these cells to create a journal or the like.

[0014] Fig. 1 is a diagram showing an example of a table. In the journal entry input system according to the embodiment, a development user creates a setting screen shown in Fig. 1(a) based on a low-code development tool. In the journal entry input system according to the embodiment, a business user who creates a journal or the like inputs desired characters, numbers, etc. into an execution screen shown in Fig. 1(b) that is displayed based on the setting screen, thereby creating a journal or the like.

[0015] FIG. 2 is a diagram explaining the structure of a table. FIG. 2(a) shows the structure of the table displayed on the setting screen, and FIG. 2(b) shows the structure of the table displayed on the execution screen. As can be seen from FIG. 2(a) and FIG. 2(b), a table has a header section which is an area for displaying item names, and a details section which is an area for displaying data. The layout of one detail is defined on the setting screen. A "detail" means a block of data. In a table, multiple data (details) of the same shape (having items with the same names) are displayed vertically.

[0016] FIG. 3 is a diagram for explaining the rows and columns of such a table. FIG. 3(a) shows a table with 3 rows and 5 columns in which one detail is created without merging cells. When a table is divided vertically and horizontally, the horizontal group is called a "row" as shown in FIG. 3(b), and the vertical group is called a "column" as shown in FIG. 3(c). FIG. 3(d) shows a state in which the cells in the first and second columns of the first row are merged, a state in which the cells in the third and fourth columns of the first row are merged, a state in which the cells in the first and second columns of the second row are merged, and a state in which the cells in the third and fourth columns of the second row are merged.

[0017] Fig. 4 shows the display form of a merged cell. Fig. 4(a) shows an example of a setting screen including a merged cell, and Fig. 4(b) shows an example of an execution screen including a merged cell. As can be seen from Fig. 4(a) and Fig. 4(b), by setting the cells to be merged, all characters of a string can be displayed in the merged cell, even if there are many characters to be displayed.

[0018] Fig. 5 shows an example of setting data for each cell of a table, in which Fig. 5(a) shows an example of setting data for each cell in the header section, and Fig. 5(b) shows an example of setting data for each cell in the detail section.

[0019] As shown in Fig. 5(a), a cell identifier, row index, column index, column span, and label are set for the header general account cell to header analysis 5 cell in the header section. Also, as shown in Fig. 5(b), a cell identifier, row index, column index, and column span are set for the detail general account cell to detail analysis 5 cell in the detail section.

[0020] The row index is a number that indicates the row in which the cell resides. For example, the row index of a cell that belongs to the Mth row (M is a natural number) is "M". The column index is a number that indicates the column in which the cell resides. The column index of a cell that belongs to the Nth column (N is a natural number) is "N". The column span is a number that indicates how many columns will be joined.

[0021] Note that the cells may be merged in the column direction (horizontal direction) or in the row direction (vertical direction). In the following description, it is assumed that cells are merged in the column direction (horizontal direction).

[0022] [Dynamic cell merging in the reference journal entry system] The dynamic binding operation of cells in a journal entry input system that is a reference example for the journal entry input system of the embodiment will be described. As an example, in the execution screen shown in FIG. 1(b), Analysis 2 to Analysis 5 are set to "Use" and "Do not use" depending on the individual company requirements. The individual company requirements are the business requirements of each client company that introduces the journal entry input system. In addition, in low-code development tools, specifications that cover a wide range of business requirements are created as standard applications, and unnecessary items may be hidden from this standard application when the system is introduced to each company. In addition, Analysis 2 to Analysis 5 are common items used in multiple screens. For this reason, it is preferable that the settings of "Use" and "Do not use" for Analysis 2 to Analysis 5 are set commonly, rather than being set on each screen, and the setting values ​​are stored in a business database (reference number 7 in FIG. 8) described later.

[0023] However, in the reference example journal entry system, two settings, "Use" and "Do not use," were set for each of the four items, Analysis 2 to Analysis 5. For this reason, as shown in Figure 6, the reference example journal entry system required a total of 16 settings, which is 2 to the power of 4, for the column span settings, which posed a problem in that merging cells required complicated setting operations.

[0024] In addition, in the case of the execution screen in Figure 1(b), the four items, Analysis 2 to Analysis 5, are arranged side by side in the same row, but if these Analysis 2 to Analysis 5 are rearranged to different rows as shown in Figure 7, the cell merging settings also need to be reconfigured.

[0025] For this reason, in the journal entry input system of the embodiment, when developing a business support program (an example of an information processing program), the development user sets the cell merging setting of "whether to merge unused cells to the left" rather than "column span of cells on the left". This significantly reduces the effort required for setting cell merging settings, and allows cell merging settings to be performed easily. Furthermore, the journal entry input system of the embodiment also enables setting control (dynamic state control) of cell merging settings according to conditions.

[0026] There are more advantages to expanding the cell area horizontally than vertically. Also, unused items (cells) are often placed on the right side. In other words, important items (cells) used by any company are often placed toward the beginning (left). For this reason, unused cells are merged with cells to the left rather than to the right. This saves the development user the trouble of having to specify which cell (left or right) to merge each time, because the direction of the cells to be merged is predetermined.

[0027] [System Configuration] Next, the system configuration of the journal entry input system of the embodiment will be described. Figure 8 is a diagram showing the system configuration of the journal entry input system of the embodiment. As shown in this Figure 8, the journal entry input system of the embodiment has a developer computer device 1, a low-code development Web server device 2, a development database 3, an application Web server device 4 (an example of an information processing device), a business support device 5, a business API (Application Programming Interface) 6, and a business database 7.

[0028] The developer computer device 1 communicates with the low-code development Web server device 2 via a predetermined network such as the Internet using a Web browser 8. The low-code development Web server device 2 provides low-code development tools to the developer computer device 1. A developer uses the low-code development tools provided by the low-code development Web server device 2 to operate the developer computer device 1 to create a business support program. As a result, the business support program created on the developer computer device 1 is stored in a development database 3 via the low-code development Web server device 2.

[0029] The application Web server device 4 acquires definition data of a business support program created by the developer computer device 1 from the development database 3. The application Web server device 4 also generates a business support program based on the acquired definition data. The application Web server device 4 then acquires business data from the business database 7 via the business API based on the generated business support program, generates an execution screen, and provides it to the business support device 5. The application Web server device 4 also supplies the business data generated by the business support device 5 via the execution screen to the business database 7 via the business API 6, and updates the business data.

[0030] The business support device 5 communicates with the application Web server device 4 via a Web browser 9 and a network such as the Internet. The business support device 5 acquires an execution screen generated by the application Web server device 4 based on a business support program. Business data input and processed by a business user via the execution screen is transmitted to the application Web server device 4 via the Web browser 9 and the network. As a result, the application Web server device 4 updates the business data in the business database with the new business data received from the business support device 5.

[0031] (Application Web Server Device Configuration) Fig. 9 is a diagram showing the configuration of the application Web server device 4. As shown in Fig. 9, the application Web server device 4 includes a storage unit 12, a control unit 13, and a communication interface unit 14. The communication interface unit 14 is connected to the low-code development Web server device 2 and the business support device 5 via a predetermined network 15 such as the Internet. The communication interface unit 14 is also connected to a business database 7 via the network 15 and a business API 6.

[0032] The control unit 13 includes a communication control unit 21, a definition acquisition unit 22, and an application generation unit 23. The communication control unit 21 communicates with the business database 7 via the development database 3 and the business API 6. The definition acquisition unit 22 acquires definition data from the development database 3. The application generation unit 23 generates a business assistance program based on the acquired definition data, and deploys it in the storage unit 12.

[0033] Moreover, the control unit 13 executes this business support program to realize the functions of an execution unit 24, an evaluation unit 25, a calculation unit 26, and a screen generation unit 27. The screen generation unit 27 generates an execution screen and provides it to the business support device 5 of the business user. The execution unit 24 executes a predefined activation event handler, and the evaluation unit 25 evaluates dynamic state control. Furthermore, the calculation unit 26 calculates column spans. The operation of each of these functions will be described later with reference to the flowchart of FIG. 22 and the like.

[0034] The communication control unit 21 to the screen generating unit 27 of the control unit 13 may be realized by software such as a business support program, or may be realized entirely or partially by hardware such as an IC (Integrated Circuit).

[0035] The business support program may be provided by recording file information in an installable or executable format on a computer-readable recording medium such as a CD-ROM or a flexible disk (FD). The business support program may be provided by recording file information in an installable or executable format on a computer-readable recording medium such as a CD-R, a DVD (Digital Versatile Disk), a Blu-ray (registered trademark) disk, or a semiconductor memory. The business support program may be provided by installing the program via a network such as the Internet. The business support program may be provided by being pre-installed in a ROM or the like within a device.

[0036] As an example, in the case of the journal entry input system of the embodiment, the business support program is created using a low-code development tool. 1. "Store and provide pre-generated source code or binary programs" type, 2. "Interpreted sequentially at the time of execution and executed as runtime code" type, There are two types of low-code development tools, but either type can be used to create business support programs.

[0037] (Features of the business support program) Next, the business support program created by the development user and stored in the development database has the following features. Fig. 10 shows an example of a setting screen displayed by the business support program and operated by the development user. In the journal entry input system according to the embodiment, as shown in Fig. 10, the display combination settings (an example of combination settings) for each cell can be set to "display", "simple hide", "combine to the left", and "control according to conditions".

[0038] FIG. 11 shows an example where the display combination setting of "display" is made for the analysis 2 cell of the detail section. FIG. 11(a) is an example of a setting screen. In this case, as shown in FIG. 11(b), the identification name indicating the cell to be set is "detailed analysis 2 cell", and definition data indicating that the display combination setting is "display" is stored in the development database 3. FIG. 11(c) shows an example of an execution screen that is generated by the screen generation unit 27 of the application Web server device 4 based on this definition data and provided to the business support device 5. In this case, the analysis 2 cell of the detail section is displayed on the execution screen without being combined, as shown in FIG. 11(c).

[0039] In contrast, FIG. 12 shows an example where the display merge setting of "merge to the left" is set for the cell of analysis 2 of the details section. FIG. 12(a) is an example of a setting screen. In this case, as shown in FIG. 12(b), the identification name indicating the cell to be set is "detailed analysis 2 cell", and definition data indicating that the display merge setting is "merge to the left" is stored in the development database 3. FIG. 12(c) shows an example of an execution screen that is generated based on this definition data by the screen generating unit 27 of the application Web server device 4 and provided to the business support device 5, and is displayed. In this case, the execution screen operated by the business user has the analysis 2 cell of the details section merged with the cell to the left as shown in FIG. 12(c), and the analysis 2 cell is not displayed. That is, the display area of ​​the cell of analysis 1 of the details section is displayed in a form extended to the right (longer to the right) (two columns wide).

[0040] FIG. 13 shows an example where the display merge setting of "merge left" is set for the analysis 2 cell in the header section. FIG. 13(a) is an example of a setting screen. In this case, as shown in FIG. 13(b), the identification name indicating the cell to be set is "Header analysis 2 cell", and definition data indicating that the display merge setting is "merge left" is stored in the development database 3. FIG. 13(c) shows an example of an execution screen that is generated based on this definition data by the screen generation unit 27 of the application Web server device 4 and provided to the business support device 5, and is displayed. In this case, on the execution screen operated by the business user, as shown in FIG. 13(c), the analysis 2 cell in the header is merged with the cell on the left, and the analysis 2 cell is not displayed. That is, the display area of ​​the analysis 1 cell in the header section is displayed in a form extended to the right (lengthened to the right) (two columns wide).

[0041] (Dynamic state control) Next, Fig. 14 is a diagram showing the display combination setting of "control according to conditions". As shown in Fig. 14(a), when the display combination setting of "control according to conditions" is selected for the cell of analysis 2 of the detail section, a condition setting button 30 is displayed. When this condition setting button 30 is clicked by the development user, a condition setting screen shown in Fig. 14(b) is displayed for setting the conditions for the display combination setting. This condition setting screen includes a variable setting item, a boolean value setting item, a display combination setting item when the boolean value is satisfied, and a display combination setting item when the boolean value is not satisfied (other cases).

[0042] Although variables are not displayed on the screen, their values ​​are updated or referenced according to the operations of the business user, so to speak, they are hidden items on the screen. The low-code development tool stored in the low-code development Web server device 2 has the functions of "declaring variables," "defining value sets for variables (explained in the execution operation of the start event handler described later)," and "using variables as condition determination items."

[0043] The variables are selected from among variables that have been declared in advance. Specifically, FIG. 15 is a diagram showing an example of a variable setting screen. The example in FIG. 15(a) shows an example in which the variables "Use Analysis 2", "Use Analysis 3", and "Use Analysis 4" have been set in advance. When adding further variables on such a variable setting screen, the development user clicks on the Add button 31 displayed on the variable setting screen.

[0044] When the add button 31 is clicked, a selection menu of the variable type is displayed in a pull-down menu as shown in FIG. 15(b). An example of this selection menu of the variable type is an example in which a selection menu of each type of character, number, boolean, date and time is displayed. When a desired type of variable is selected from this selection menu, a new variable is added as shown as "variable 1" in FIG. 15(c). The identification name of this variable can be changed as shown in FIG. 15(d). FIG. 15(d) shows an example in which the identification name of "variable 1" is changed to "use analysis 5". FIG. 15(e) shows the data structure of the variable set in this way. As shown in FIG. 15(e), each variable is stored in association with a "type" such as a boolean value and an "identification name" such as "use analysis 2".

[0045] Returning to the explanation of FIG. 14(b), the example of FIG. 14(b) is an example in which the variable "use analysis 2" is selected, and the display merge setting is set to "display" the analysis 2 cell when the boolean value meets the condition of "true". Also, the example of FIG. 14(b) is an example in which the display merge setting is set to "merge to the left" the analysis 2 cell when the boolean value does not meet the condition of "true". In the case of such settings, at run time, if the setting value "use analysis 2" of the business database 7 is true, the detailed analysis 2 cell is displayed, and if it is false, the detailed analysis 2 cell is merged to the cell to the left.

[0046] Similarly, the example in FIG. 16(a) is an example in which the variable "use analysis 3" is selected, and the display merge setting is set to "display" the analysis 3 cell when the boolean value meets the condition of "true". Moreover, the example in FIG. 16(b) is an example in which the display merge setting is set to "merge to the left" the analysis 3 cell when the boolean value does not meet the condition of "true". In the case of such settings, at run time, if the setting value "use analysis 3" in the business database 7 is true, the detailed analysis 3 cell is displayed, and if it is false, the detailed analysis 3 cell is merged to the cell to the left.

[0047] Similarly, the example in FIG. 16(b) is an example in which the variable "use analysis 4" is selected, and the display merge setting is set to "display" the analysis 4 cell when the boolean value meets the condition of "true". Also, the example in FIG. 16(b) is an example in which the display merge setting is set to "merge to the left" the analysis 4 cell when the boolean value does not meet the condition of "true". In the case of such settings, at run time, if the setting value "use analysis 4" of the business database 7 is true, the detailed analysis 4 cell is displayed, and if it is false, the detailed analysis 4 cell is merged to the cell to the left.

[0048] Similarly, the example in FIG. 16(c) is an example in which the variable "use analysis 5" is selected, and the display merge setting is set to "display" the analysis 5 cell when the boolean value meets the condition of "true". Also, the example in FIG. 16(c) is an example in which the display merge setting is set to "merge to the left" the analysis 5 cell when the boolean value does not meet the condition of "true". In the case of such settings, at run time, if the setting value "use analysis 5" of the business database 7 is true, the detailed analysis 5 cell is displayed, and if it is false, the detailed analysis 5 cell is merged to the cell to the left.

[0049] The journal entry input system of the embodiment can realize the 16 branching patterns described with reference to Fig. 6 simply by configuring a total of four settings: "variable setting," "boolean value setting," "display combination setting when boolean value setting is satisfied," and "display combination setting when boolean value setting is not satisfied." Therefore, the development user does not need to configure the complicated settings of cumulative patterns (16 patterns) according to the number of cells to be combined, and can simply specify the combination condition for each cell.

[0050] In addition, there is no need to reset the settings even if the cell layout is changed. The conditions are set not for the cell to the left of the cell to be merged, but for the cells to be merged, so there is no need to reset the settings since they are not dependent on the cell layout.

[0051] 17 shows the setting data stored in the development database 3 when the display combination setting for detailed analysis cells 2 to 5 is set to "control according to conditions." In this case, the identification names of detailed analysis cells 2, 3, etc., and the display combination setting content "control according to conditions" are associated with each other and stored in the development database 3.

[0052] FIG. 18 is an example of a program for executing "dynamic state control", which is a binding control according to such cell conditions. This dynamic state control program is included in the above-mentioned business support program. FIG. 18(a) to FIG. 18(d) are a series of programs. FIG. 18(a) is an example of a program for executing "dynamic state control" for detailed analysis 2 cell. In FIG. 18(a), conditional expression A1 is a conditional expression for binary comparison, and a type such as "variable value reference" and a variable identification name such as "use analysis 2" are defined as the "left side A2". In addition, in conditional expression A1, a type such as "fixed value" and a truth value such as "true" are defined as the "right side A3". In addition, in conditional expression A1, a comparison type such as "equal" is defined.

[0053] The comparison type is defined by selecting from among "equal to", "not equal to", "> (greater than)", "≥ (greater than or equal to)", "< (less than)", "≤ (less than or equal to)", etc. When the comparison type is defined as "equal to", if the left side A2 and the right side A3 are equal, the evaluation result is "true", and if they are not equal, the evaluation result is "false".

[0054] Moreover, formula A4 is the static setting value when condition formula A1 is "true". FIG. 18(a) shows an example where the display coupling setting is set to "display". Formula A5 is the static setting value when the condition formula on the left side A2 is "false". FIG. 18(a) shows an example where the display coupling setting is set to "couple to the left".

[0055] Fig. 18(b) is an example of a program for executing "dynamic state control" for detailed analysis cell 3, Fig. 18(c) is an example of a program for executing "dynamic state control" for detailed analysis cell 4, and Fig. 18(d) is an example of a program for executing "dynamic state control" for detailed analysis cell 5. Conditional expressions for performing "dynamic state control" are defined for detailed analysis cells 3 to 5 in the same way as for detailed analysis cell 2 described above.

[0056] Next, in dynamic state control, variables such as "use analysis 2" or "use analysis 3" are referenced, and it is necessary to set a setting value of the business database 7 as this variable. Therefore, in order to set the setting value of the business database 7 as a variable, the development user creates a flow of "API call process" shown in Fig. 19 and registers it as a startup event handler. The registration of this startup event handler is also performed by the development user at the time of development.

[0057] Fig. 20 is a diagram showing detailed settings of API call processing in the start event handler. As shown in Fig. 20, the API call processing performs processing to obtain setting values ​​including a data name and a truth value of whether or not to use analysis 2 from a business database 7 by a business API 6, such as whether or not to use analysis 2, and to set the values ​​to variables such as whether or not to use analysis 2.

[0058] Fig. 21 is a diagram showing the data structure of such an API call process. As shown in Fig. 21, in the API call process, the source data name such as whether or not analysis 2 is used, the set destination, the type such as variation, and the variable identification name such as whether analysis 2 is used are defined. This start event handler makes it possible to set the setting value of the business database 7 as a variable.

[0059] [Operation of application Web server device based on business support program] Next, the operation of the application Web server device 4 based on the business support program thus developed by the development user will be described. Fig. 22 is a flowchart showing the flow of the operation of the application Web server device 4 based on the business support program. In the flowchart of Fig. 22, when the business user performs an operation to start the execution screen of the business support device 5 (step S1), the operation to start the execution screen is notified to the application Web server device 4 via the Web browser 9 of the business support device 5.

[0060] When a start operation of the execution screen is notified, the definition acquisition unit 22 of the application Web server device 4 shown in Fig. 9 reads out definition data from the development database 2, and the application generation unit 23 generates a business support program based on this definition data and loads it in the storage unit 12 such as a RAM (Random Access Memory). Then, the execution unit 24, which is realized by the control unit 13 executing this business support program, executes the "defined start event handler" (step S2).

[0061] Specifically, the execution process of the predefined activation event handler in step S2 is the process that is executed first when the execution screen is started if a process is registered in the predefined activation event handler. In the execution process of the predefined activation event handler in step S2, the execution unit 24 performs a process of calling the business API 6 that acquires a setting value of the business database 3, for example, and setting the value in a variable. This will be described in detail later.

[0062] Next, in step S3, the evaluation unit 25 (an example of a detection unit) realized by the control unit 13 executing the business support program evaluates the conditions defined in each cell and converts the dynamic display combination setting into a static setting (dynamic state control evaluation process). This dynamic state control evaluation process in step S3 is executed as the second process when the execution screen is started up if at least one dynamic state control is set. This will be described in detail later.

[0063] Next, in step S4, the calculation unit 26 (an example of a merge processing unit) realized by the control unit 13 executing the business support program calculates the column span based on the display merge setting of each cell. This column span calculation process in step S4 is executed as the third process when the execution screen is started. Details will be described later.

[0064] Next, in step S5, the screen generator 27, which is realized by the control unit 13 executing the business support program, generates an execution screen in which cells are appropriately combined based on the column span calculation process in step S4. This execution screen is transmitted to the business support device 5 by the communication control unit 21 and displayed on the display unit via the Web browser 9. This allows the business user to operate the execution screen.

[0065] (Execution of predefined startup event handler) Next, the execution process of the defined start event handler described in step S2 above will be described with reference to Fig. 23. In step S2, the execution unit 24 of the application Web server device 4 acquires the start event handler definition registered in the development database 3, as shown in Fig. 23(a). Then, the execution unit 24 executes the read start event handler. As a result, as shown in Fig. 23(b), the setting data of the display combination setting described with reference to Fig. 17 is acquired from the business database 7 via the business API 6, and set in variables in memory.

[0066] The setting values ​​of the transaction database 7 are set by a "transaction management user" who manages transactions at the stage of introducing the journal entry input system of the embodiment.

[0067] (Dynamic state control evaluation process) Next, the evaluation process of the dynamic state control explained in the above step S3 will be explained. In step S3, the evaluation unit 25 of the application Web server device 4 acquires preset setting data of the dynamic state control from the development database 3, as shown in FIG.

[0068] Next, the evaluation unit 25 evaluates the dynamic state control based on the read setting data, and replaces the display combination setting of the cell with a static value. If there are multiple dynamic state controls, all the dynamic state controls are evaluated in order. FIG. 25 is a flowchart showing the flow of the evaluation operation when evaluating one dynamic state control. FIG. 25 is also a flowchart for evaluating the dynamic state control of the display combination setting of the detailed analysis 2 cell, and is an operation based on the conditional formula A1 shown in FIG. 18(a).

[0069] In the flowchart of FIG. 25 and the conditional expression A1 of FIG. 18(a), the evaluation unit 25 judges whether the variable "use analysis 2 (A2)" is equal to "true (A3)" (step S11). When the evaluation unit 25 judges that the variable "use analysis 2 (A2)" is equal to "true (A3)" (step S11: Yes), the evaluation unit 25 sets the static display combination setting to "display (A4)" in step S12. On the other hand, when the evaluation unit 25 judges that the variable "use analysis 2 (A2)" is not equal to "true (A3)" (step S11: No), the evaluation unit 25 sets the static display combination setting to "combine to the left (A5)" in step S13. The evaluation unit 25 repeats the operation of the flowchart shown in FIG. 25 as many times as the number of dynamic state controls that are set.

[0070] For example, suppose that dynamic state control as exemplified in FIG. 14(b) and FIG. 16(a) to FIG. 16(c) is set for analysis 2 cell, analysis 3 cell, analysis 4 cell, and analysis 5 cell, and the values ​​of the variables are "analysis 2 is used -> false", "analysis 3 is used -> true", "analysis 4 is used -> false", and "analysis 5 is used -> false" as shown in FIG. 26. In this case, as shown in the flowchart of FIG. 27, the evaluation unit 25 determines whether the variable "analysis 2 is used" is equal to the truth value "true" in step S21. If it is determined that the variable "analysis 2 is used" is equal to the truth value "true" (step S21: Yes), the evaluation unit 25 sets the static display combination setting to "display" in step S22.

[0071] On the other hand, if it is determined that the variable "use analysis 2" is not equal to the boolean value "true" (step S21: No), the evaluation unit 25 sets the static display combination setting to "combine to the left" in step S23. FIG. 27(a) shows the state of the display combination setting of each cell before the evaluation of dynamic state control by the evaluation unit 25, and FIG. 27(c) shows the state of the display combination setting of each cell after the evaluation of dynamic state control. As can be seen by comparing FIG. 27(a) and FIG. 27(c), the evaluation of the display combination setting of detailed analysis cell 2 is "combine to the left" before and after the evaluation.

[0072] Next, Fig. 28(b) is a flowchart showing the flow of evaluation of dynamic state control for the display combination setting of the detailed analysis 3 cell. In the flowchart of Fig. 28(b), in step S25, the evaluation unit 25 determines whether the variable "use analysis 3" is equal to the boolean value "true". If it is determined that the variable "use analysis 3" is equal to the boolean value "true" (step S25: Yes), in step S26, the evaluation unit 25 sets the static display combination setting to "display".

[0073] On the other hand, if it is determined that the variable "use analysis 3" is not equal to the boolean value "true" (step S25: No), the evaluation unit 25 sets the static display combination setting to "combine to the left" in step S27. FIG. 28(a) shows the state of the display combination setting of each cell before the evaluation of the dynamic state control by the evaluation unit 25, and FIG. 28(c) shows the state of the display combination setting of each cell after the evaluation of the dynamic state control. As can be seen by comparing FIG. 28(a) and FIG. 28(c), before and after the evaluation, the display combination setting of the detailed analysis cell 2 is evaluated as "combine to the left", and the display combination setting of the detailed analysis cell 3 is evaluated as "display".

[0074] Next, Fig. 29(b) is a flowchart showing the flow of evaluation of dynamic state control for the display combination setting of the detailed analysis 4 cell. In the flowchart of Fig. 29(b), the evaluation unit 25 determines in step S31 whether the variable "use analysis 4" is equal to the boolean value "true". If it is determined that the variable "use analysis 4" is equal to the boolean value "true" (step S31: Yes), the evaluation unit 25 sets the static display combination setting to "display" in step S32.

[0075] On the other hand, when it is determined that the variable "use analysis 4" is not equal to the boolean value "true" (step S31: No), the evaluation unit 25 sets the static display combination setting to "combine to the left" in step S33. FIG. 29(a) shows the state of the display combination setting of each cell before the evaluation of the dynamic state control by the evaluation unit 25, and FIG. 29(c) shows the state of the display combination setting of each cell after the evaluation of the dynamic state control. As can be seen by comparing FIG. 29(a) and FIG. 29(c), before and after the evaluation, the display combination setting of the detailed analysis cell 2 is evaluated as "combine to the left", the display combination setting of the detailed analysis cell 3 is evaluated as "display", and the display combination setting of the detailed analysis cell 4 is evaluated as "combine to the left".

[0076] Next, Fig. 30(b) is a flowchart showing the flow of evaluation of dynamic state control for the display combination setting of the detailed analysis 5 cell. In the flowchart of Fig. 30(b), the evaluation unit 25 determines in step S35 whether the variable "use analysis 5" is equal to the boolean value "true". If it is determined that the variable "use analysis 5" is equal to the boolean value "true" (step S35: Yes), the evaluation unit 25 sets the static display combination setting to "display" in step S36.

[0077] On the other hand, when it is determined that the variable "use analysis 5" is not equal to the boolean value "true" (step S35: No), the evaluation unit 25 sets the static display combination setting to "combine to the left" in step S37. FIG. 30(a) shows the state of the display combination setting of each cell before the evaluation of the dynamic state control by the evaluation unit 25, and FIG. 30(c) shows the state of the display combination setting of each cell after the evaluation of the dynamic state control. As can be seen by comparing FIG. 30(a) and FIG. 30(c), before and after the evaluation, the display combination setting of the detailed analysis cell 2 is evaluated as "combine to the left", the display combination setting of the detailed analysis cell 3 is evaluated as "display", the display combination setting of the detailed analysis cell 4 is evaluated as "combine to the left", and the display combination setting of the detailed analysis cell 5 is evaluated as "combine to the left".

[0078] In this manner, the evaluation unit 25 evaluates all the dynamic state controls set for each cell in step S3 of the flowchart in FIG. 22, and replaces them with static display combination settings.

[0079] (Column span calculation behavior) Next, a description will be given of the calculation operation of the column span in step S4 of the flowchart in Fig. 22. The calculation unit 26 shown in Fig. 9 calculates the column span based on the display coupling setting replaced with a static setting value in the evaluation of the dynamic state control of each cell in the above-mentioned step S3.

[0080] Fig. 31 is a flowchart showing the flow of the column span calculation operation by the calculation unit 26. In step S41 of the flowchart in Fig. 31, the calculation unit 26 arranges the display combination settings of all cells that have been replaced with static setting values ​​in the above-mentioned dynamic state control evaluation process in the order of row index and column index, as shown in Fig. 32.

[0081] The example in Figure 32 shows an example where the "General account title" cell in the first row of the detail section is two cells in the first and second columns, and the display combination setting is set to "display." The example in Figure 32 also shows an example where the "Client" cell in the first row of the detail section is two cells in the third and fourth columns, and the display combination setting is set to "display." The example in Figure 32 also shows an example where the "Tax category" cell in the first row of the detail section is one cell in the fifth column, and the display combination setting is set to "display."

[0082] Similarly, the example in Figure 32 shows an example where the "Sub-account" cell in the second row of the detail section is two cells wide, in columns 1 and 2, and the display combination setting is set to "display." The example in Figure 32 also shows an example where the "Establishment" cell in the second row of the detail section is two cells wide, in columns 3 and 4, and the display combination setting is set to "display." The example in Figure 32 also shows an example where the "Amount" cell in the second row of the detail section is one cell wide, in column 5, and the display combination setting is set to "display."

[0083] Similarly, the example of FIG. 32 shows an example where the cell "Analysis 1" in the third row of the detail section is the size of one cell in the first column, and the display merge setting is set to "display". Also, the example of FIG. 32 shows an example where the cell "Analysis 2" in the third row of the detail section is the size of one cell in the second column, and the display merge setting is set to "merge left". Also, the example of FIG. 32 shows an example where the cell "Analysis 3" in the third row of the detail section is the size of one cell in the third column, and the display merge setting is set to "display". Also, the example of FIG. 32 shows an example where the cell "Analysis 4" in the third row of the detail section is the size of one cell in the fourth column, and the display merge setting is set to "merge left". Also, the example of FIG. 32 shows an example where the cell "Analysis 5" in the third row of the detail section is the size of one cell in the fifth column, and the display merge setting is set to "merge left".

[0084] Next, in step S42, the calculation unit 26 arranges all the cells shown in Fig. 32 in the order of row index and column index as shown in Fig. 33. When all the cells shown in Fig. 32 are arranged in the order of row index and column index, the cells in the first row, row index 1, are arranged in the order of "detailed total account title cell", "detailed customer cell", and "detailed tax classification cell" as shown in Fig. 33, forming one row group.

[0085] Next, if all the cells shown in Figure 32 are arranged in the order of row index and column index, the cells in the second row, row index 2, as shown in Figure 33, are arranged in the order of ``detailed sub-item cell,'' ``detailed business establishment cell,'' and ``detailed amount cell,'' forming one row group.

[0086] Next, if all the cells shown in FIG. 32 are arranged in the order of row index and column index, the cells in the third row, row index 3, as shown in FIG. 33, are arranged in the order of “Detailed Analysis 1 Cell”, “Detailed Analysis 2 Cell”, “Detailed Analysis 3 Cell”, “Detailed Analysis 4 Cell”, and “Detailed Analysis 5 Cell”, forming one row group.

[0087] Next, the calculation unit 26 repeatedly executes the processes of steps S51 to S56 in steps S43 and S44 of the flowchart in Fig. 31. That is, the calculation unit 26 repeatedly executes the processes of steps S51 to S56 in ascending order of row index of the row group (step S43) and in ascending order of column index of the cells in the row group (step S44).

[0088] Specifically, in step S51, the calculation unit 26 determines whether the display combination setting for the cell to be processed is set to "merge to the left". If the display combination setting for the cell to be processed is set to "merge to the left" (step S51: Yes), the calculation unit 26 moves the process to the next cell. On the other hand, if the display combination setting for the cell to be processed is not set to "merge to the left" (step S51: No), the calculation unit 26 determines in step S52 that the cell one cell to the right of the cell currently being processed (an example of a merged cell) is the "partner cell (an example of an adjacent cell)". The "one cell to the right" is the cell with the smallest column index among the cells in the same row group as the reference cell and with a larger column index than the reference cell.

[0089] Next, in step S53, the calculation unit 26 determines whether or not a partner cell exists. If a partner cell does not exist (step S53: No), the calculation unit 26 returns the process to step S51 to proceed to the process of the next cell.

[0090] If a partner cell exists (step S53: Yes), the calculation unit 26 determines in step S54 whether the display coupling setting of the partner cell is set to "merge to the left." If the display coupling setting of the partner cell is not set to "merge to the left" (step S54: No), the calculation unit 26 returns the process to step S51 to proceed to the process of the next cell.

[0091] On the other hand, if the display coupling setting of the counterpart cell is set to "merge to the left" (step S54: Yes), the calculation unit 26 adds the column span of the counterpart cell to the column span of the cell being processed in step S55. Then, in step S56, the calculation unit 26 sets the cell one cell further to the right of the counterpart cell as the "counter cell", returns the process to step S53, and repeats the process of adding the column span of the counterpart cell to the column span of the cell being processed if the display coupling setting of the counterpart cell is set to "merge to the left".

[0092] The calculation unit 26 repeatedly executes the processes of steps S51 to S56 in ascending order of row index of the row group (step S43) and in ascending order of column index of the cells in the row group (step S44). This allows a cell whose display combination setting is set to "combine to the left" to be combined with a cell on the left.

[0093] 34 to 38 are schematic diagrams for explaining specific examples of such cell merging processing. Of these, Fig. 34 is a schematic diagram showing cell merging processing for a cell of analysis 1. In Fig. 34(a), the cell of analysis 1 is the cell in the third row (row index: 3) and first column (column index: 1) as shown in Fig. 32, and is the cell currently being processed (the cell currently being processed). Also, as shown in Fig. 34(b), the cell of analysis 2, which is the cell immediately to the right of the cell of analysis 1, is the partner cell.

[0094] The row index of the cell of analysis 1 currently being processed is "3" and the column index is "1", while the row index of the counterpart cell is also "3" and the column index is "2". Because the display merge setting of this counterpart cell, analysis 2, is set to "merge to left", calculation unit 26 adds the column span "1" of the counterpart cell to the column span of the cell of analysis 1 currently being processed. As a result, the column span of the cell of analysis 1 currently being processed becomes "2", and the size of the cell of analysis 1 is expanded to the width of two columns along the row direction. The cell of analysis 2 is hidden by the cell of analysis 1 and becomes hidden.

[0095] Next, as shown in FIG. 34(c), the calculation unit 26 sets the cell of analysis 3, which is one cell to the right of the cell of analysis 2, as the counterpart cell. Since the cell of analysis 2 has been merged with the cell of analysis 1, the cell currently being processed is the cell of analysis 1 with row index "3" and column index "1". In contrast, the counterpart cell is the cell of analysis 3 with row index "3" and column index "3". The display merge setting for this cell of analysis 3 is "display". Therefore, since the display merge setting of the counterpart cell (cell of analysis 3) is not "merge to left", the calculation unit 26 shifts the cell currently being processed from the cell of analysis 1 to the next cell, the cell of analysis 2.

[0096] Next, the calculation unit 26 attempts to perform cell merging processing on the cell of analysis 2 shown in Fig. 35 as the currently processed cell. The cell of analysis 2 is a cell with a row index of "3" and a column index of "2". The display merging setting of the cell of analysis 2, which is the currently processed cell, is "merge to the left". In this case, the processing of merging the cell of analysis 2 with the cell of analysis 1 was completed when the cell of analysis 1 was processed as described above, so the calculation unit 26 simply shifts the currently processed cell from the cell of analysis 2 to the cell of analysis 3.

[0097] Next, the calculation unit 26 attempts cell merging processing with the cell of analysis 3 shown in FIG. 36(a) as the cell currently being processed. The cell of analysis 3 is a cell with a row index of "3" and a column index of "3". The current merging state of the cells is that the cell of analysis 2 is merged with the cell of analysis 1. In this state, the calculation unit 26 sets the cell of analysis 4, which is the cell immediately to the right of the cell of analysis 3 currently being processed, as the partner cell, as shown in FIG. 36(b). The row index and column index of the cell of analysis 3 currently being processed are "3" and "3". The row index and column index of the cell of analysis 4, which is the partner cell, are "3" and "4".

[0098] As shown in FIG. 36(b), the display merge setting of the counterpart cell, which is the cell of analysis 4, is "merge to the left". Therefore, the calculation unit 26 adds the column span "1" of the counterpart cell, which is the cell of analysis 4, to the column span of the cell of analysis 3 currently being processed. As a result, the column span of the cell of analysis 1 in the detail section becomes "2", the column span of the cell of analysis 2 becomes "1", the column span of the cell of analysis 3 becomes "2", the column span of the cell of analysis 4 becomes "1", and the column span of the cell of analysis 5 becomes "1". Therefore, the size of the cell of analysis 1 is expanded to a width of two columns along the row direction, and the size of the cell of analysis 3 is expanded to a width of two columns along the row direction. Note that the cell of analysis 2 is hidden by the cell of analysis 1 and is hidden. Also, the cell of analysis 4 is hidden by the cell of analysis 3 and is hidden.

[0099] Next, the calculation unit 26 sets the cell of analysis 5, which is adjacent to the cell of analysis 4 on the right, as the counterpart cell, as shown in Fig. 36(c). The row index and column index of the cell of analysis 3 currently being processed are "3" and "3", respectively, and the row index and column index of the cell of analysis 5, which has become the counterpart cell, are "3" and "5". In this case, the display merge setting of the cell of analysis 5, which has become the counterpart cell, is also "merge to the left".

[0100] Therefore, the calculation unit 26 further adds the column span "1" of the counterpart cell, which is the cell of analysis 5, to the column span of the cell of analysis 3 currently being processed. As a result, the column span of the cell of analysis 1 in the detail section becomes "2", the column span of the cell of analysis 2 becomes "1", the column span of the cell of analysis 3 becomes "3", the column span of the cell of analysis 4 becomes "1", and the column span of the cell of analysis 5 becomes "1". Therefore, the size of the cell of analysis 1 is expanded to a width of two columns along the row direction, and the size of the cell of analysis 3 is expanded to a width of three columns along the row direction. Note that the cell of analysis 2 is hidden by the cell of analysis 1 and becomes invisible. Also, the cells of analysis 4 and analysis 5 are hidden by the cell of analysis 3 and become invisible.

[0101] Next, as shown in Fig. 36(d), calculation unit 26 sets the cell adjacent to the right of the cell of analysis 5 as the partner cell. However, as shown in Fig. 36(d), there is no cell adjacent to the right of the cell of analysis 5 (there is no partner cell). Therefore, calculation unit 26 shifts the cell to be processed to the next cell (in this case, the cell of analysis 4).

[0102] Next, the calculation unit 26 attempts to perform cell merging processing on the cell of analysis 4 shown in Fig. 37 as the cell currently being processed. The cell of analysis 4 has a row index of "3" and a column index of "4". However, the display merging setting of the cell of analysis 4, which is the cell currently being processed, is "merge to the left". Therefore, the calculation unit 26 shifts the cell to be processed to the next cell (in this case, the cell of analysis 5).

[0103] Next, the calculation unit 26 attempts to perform cell merging processing on the cell of analysis 5 shown in Fig. 38 as the currently processed cell. The cell of analysis 5 has a row index of "3" and a column index of "5". However, the display merging setting of the cell of analysis 5, which is the currently processed cell, is "merge to the left". Therefore, the calculation unit 26 moves on to processing the next cell (in this case, the first cell of the next row).

[0104] If the next cell does not exist, calculation unit 26 proceeds to processing the cell in the next row, and if the next cell does not exist, ends the calculation process of the column span.

[0105] [Effects of the embodiment] As is clear from the above explanation, the journal entry input system of the embodiment can dynamically combine cells in a table just by specifying a combining condition for each cell. Specifically, the user sets "whether to combine unused cells to the left" instead of "column span of the cell on the left". This eliminates the need for cumbersome settings of the cumulative number of patterns according to the number of cells to be combined, and allows desired cells to be combined with a simple setting operation.

[0106] Furthermore, since the conditions are set for the cells to be merged, rather than for the cell to the left of the cell to be merged, they do not depend on the cell arrangement, and even if the cell arrangement is changed, there is no need to reset the conditions.

[0107] In the above embodiment, the cell adjacent to the right of the cell currently being processed is combined with the cell currently being processed. However, the cell adjacent to the left of the cell currently being processed, the cell adjacent above the cell currently being processed, or the cell adjacent below the cell currently being processed may be combined with the cell currently being processed as the cell adjacent to the left of the cell currently being processed. In either case, the same effect as described above can be obtained.

[0108] [Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving business efficiency and promoting appropriate management decisions by companies, thereby contributing to goals 8 and 9 of the SDGs.

[0109] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of SDGs Goals 12, 13, and 15.

[0110] Furthermore, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.

[0111] [Other embodiments] The present invention may be embodied in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.

[0112] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically using known methods.

[0113] In addition, the processing procedures, control procedures, specific names, information including parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings may be changed as desired unless otherwise specified.

[0114] Furthermore, with regard to the journal entry input system, the components shown in the figures are merely functional concepts, and the system does not necessarily have to be physically configured as shown in the figures.

[0115] For example, the processing functions of the application Web server device 4, particularly the control unit 13 and each processing function performed by the control unit 13, may be realized in whole or in part by a CPU (Central Processing Unit) and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded in a non-transient computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the business support device 1 as necessary. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD. This computer program is executed by being loaded into a RAM, and constitutes the control unit 3 in cooperation with the CPU.

[0116] In addition, this computer program, which is the business support program, may be stored in another server device connected to the application Web server device 4 via any network, and it is also possible to download all or part of it as needed.

[0117] The business support program for executing the process described in the present embodiment may be stored in a non-transient computer-readable recording medium, or may be configured as a program product. Here, the term "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical Disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) Disc.

[0118] Moreover, a "program" is a data processing method written in any language or description method, and may be in any form, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a configuration that is distributed as multiple modules or libraries, and a program that works with a separate program, such as an OS, to achieve its function. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, may use well-known configurations and procedures.

[0119] The memory unit 12 is a storage means such as a memory device such as RAM or ROM, a fixed disk device such as a hard disk, a flexible disk, or an optical disk, and stores various programs, tables, databases, and web page files used for various processes and providing websites.

[0120] The application Web server device 4 may be configured as an information processing device such as a known personal computer device or a workstation, or may be configured as the information processing device to which any peripheral device is connected. The information processing device may be realized by implementing software (including programs, data, etc.) that realizes the processing described in this embodiment.

[0121] Furthermore, the specific form of distribution and integration of the devices is not limited to those shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in any unit according to various additions or function additions. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively. [Industrial Applicability]

[0122] The present invention is useful for creating forms and the like that are made up of a plurality of cells. [Explanation of symbols]

[0123] 1. Development computer equipment 2. Low-code development web server device 3 Development Database 4 Application Web server device 5 Business support equipment 6 Business API 7 Business Database 8. Web Browser 9. Web Browser 12 Storage section 13 Control section 14 Communication interface section 15 Network 21 Communication control section 22 Definition acquisition part 23 Application Generation Section 24 Executive Department 25 Evaluation Section 26 Arithmetic section 27 Image Generation Unit 31 Add button

Claims

1. An information processing device that performs a process of merging cells in a table formed of a plurality of cells, a detection unit that detects a merge setting that is set for the cell and is used to specify at least a merge between cells; a merge processing unit that performs a merge process on the adjacent cell adjacent to the joined cell when the merge setting set on the adjacent cell adjacent to the joined cell is a merge setting that instructs merging of cells, and merges the adjacent cell adjacent to the joined cell to the joined cell, The binding setting includes a truth value of a cell usage indicating whether or not the cell is to be used; The coupling processing unit displays the adjacent cell in a state where the adjacent cell is not coupled to the coupled cell when the truth value included in the coupling setting set for the adjacent cell is a value of "true" indicating that the adjacent cell is to be used, and performs coupling processing on the adjacent cell to the coupled cell when the truth value included in the coupling setting set for the adjacent cell is a value of "true" indicating that the adjacent cell is not to be used. An information processing device comprising:

2. The detection unit detects the coupling setting set in the adjacent cell adjacent to the right of the coupled cell, The merge processing unit merges the adjacent cell adjacent to the right of the merged cell to the merged cell, thereby expanding the merged cell in a row direction.

2. The information processing apparatus according to claim 1,

3. The detection unit sequentially sets cells arranged in a row direction as the adjacent cells and detects the coupling setting.

3. The information processing apparatus according to claim 2,

4. 1. An information processing method for an information processing device that performs a process of merging cells in a table formed by a plurality of cells, comprising: a detection step in which a detection unit detects a combination setting for specifying at least a combination of cells, the combination setting being set for the cell; a merging processing step in which, when the merging setting set for the adjacent cell adjacent to the joined cell is a merging setting instructing merging of cells, the merging processing unit performs a merging process for the adjacent cell adjacent to the joined cell to the joined cell; The binding setting includes a truth value of a cell usage indicating whether or not the cell is to be used; In the coupling processing step, when the truth value included in the coupling setting set for the adjacent cell is a value of "true" indicating that the adjacent cell is to be used, the adjacent cell is displayed in a state in which the adjacent cell is not coupled to the coupled cell, and when the truth value included in the coupling setting is a value of "false" indicating that the adjacent cell is not to be used, the adjacent cell is subjected to coupling processing to the coupled cell. An information processing method comprising:

5. An information processing program for an information processing device that performs a process of merging cells in a table formed by a plurality of cells, Computer, a detection unit that detects a merge setting that is set for the cell and is used to specify at least a merge between cells; When the merge setting set for the adjacent cell adjacent to the joined cell is a merge setting instructing merging of cells, the adjacent cell adjacent to the joined cell is made to function as a merge processing unit that performs a merge process on the joined cell; The binding setting includes a truth value of a cell usage indicating whether or not the cell is to be used; the merging processing unit displays the adjacent cell in a state in which the adjacent cell is not merged with the joined cell when the truth value included in the merge setting set for the adjacent cell is a value of "true" indicating that the adjacent cell is to be used, and performs a merge process of the adjacent cell to the joined cell when the truth value included in the merge setting set for the adjacent cell is a value of "true" indicating that the adjacent cell is not to be used; An information processing program characterized by:

Citation Information

Patent Citations

  • Generation program for listing, specifying method for listing and layout apparatus for editing

    JP2002358297A

  • Device, method, and program for table editing and recording medium

    JP2003216886A

  • Program generator and program generating method

    JP2004094763A

  • Analysis device, analysis method, and analysis program

    JP2018037017A

  • Analysis apparatus, analysis method, and recording medium

    US20180067916A1