JP2018165000A - Output control program and output control method - Google Patents

Abstract

PROBLEM TO BE SOLVED: To enable a table to be output and information referred to by the table to be combined and output on one page when an object of a spread sheet is output.SOLUTION: A control device for processing data about spread sheet exerts control as follows: data about the spread sheet is analyzed and set information including output specified information is acquired; table data to be output is extracted on the basis of acquired set information; on the basis of a mathematical expression and so on for each cell included in the table data to be output, it is determined whether this table data has referred to other table data or not; in a case where this table data has referred to the other table data, output data is created, in which layout is changed such that the table data to be output and at least part of the other table data that has been referred to are combined on the same page; and the output data thus created is output to output devices, such as a printer and a display device.SELECTED DRAWING: Figure 8

Description

  The present invention relates to an output control program and an output control method, and more particularly to an output control program and an output control method for controlling output of table data.

  Office suite applications capable of processing such as document creation and spreadsheets are commonly used in various situations such as office work, education, and home. A typical spreadsheet application in the office suite application is Microsoft (registered trademark, hereinafter omitted) Excel (registered trademark, hereinafter omitted). There are also a number of applications that have similar functions, such as Apache OpenOffice, and these spreadsheet applications are called spreadsheets.

  In spreadsheets such as Microsoft's Excel, it is common to create materials by placing objects such as diagrams, tables, and characters in worksheets. In particular, when creating a table, the table can be created by referring to a predetermined cell, and the content of the table can be automatically corrected by correcting the content of the predetermined cell. In the spreadsheet, by designating a range or object, only the designated range or object can be printed on paper or displayed on a screen.

  Regarding printing of such an object, for example, in Patent Document 1 below, a graph drawing result is divided into a plurality of pages, or a table and a graph on the same sheet are divided into different pages. A technique for controlling printing so that they are printed on the same page is disclosed.

JP2011-066800A

  As described above, objects can be related in a spreadsheet, such as creating a table by referring to a predetermined cell. However, if a range or object is specified, only the specified range or object is output. The object associated with the output target object cannot be printed on the same paper as the output target object or displayed on the same screen.

  With respect to this problem, in Patent Document 1 described above, print data is generated so that a table and a graph generated from the table are printed on the same page, but the table refers to another table. In this case, it is not possible to print or display the referenced table on the same page. For this reason, when viewing a printed material or a screen, a user who views the printed material must check the printed material on which the referenced table is printed or the screen on which the referenced table is printed, which is very complicated. There was a problem of becoming.

  The present invention has been made in view of the above-described problems, and its main purpose is to aggregate a table to be output and information referred to by the table into one page when outputting a spreadsheet object. It is an object to provide an output control program and an output control method that can output the output.

  One aspect of the present invention is an output control program that operates on an apparatus that processes spreadsheet data, the apparatus including output designation information that analyzes the spreadsheet data and designates an object to be output. A first process of acquiring setting information and extracting table data to be output based on the setting information; determining whether the table data to be output refers to other table data that is not to be output; When the table data to be output refers to the other table data, the layout is changed so that the table data to be output and at least a part of the other table data are aggregated on the same page. 2 processing, the 3rd processing which produces | generates the output data which arranged the object according to the changed layout, and outputs it to a printing apparatus or a display apparatus is performed. To.

  One aspect of the present invention is an output control method in a system including an apparatus for processing spreadsheet data, a printing apparatus, or a display apparatus, and the apparatus analyzes and outputs the spreadsheet data. A first process for obtaining setting information including output designation information for designating an object to be output, and extracting table data to be output based on the setting information; and other tables in which the table data to be output is not an output target If it is determined whether data is referenced and the table data to be output refers to the other table data, the table data to be output and at least a part of the other table data are the same page A second process for changing the layout so as to be aggregated, and generating output data in which objects are arranged according to the changed layout, and And executes a third process that forces the.

  According to the output control program and the output control method of the present invention, when outputting a spreadsheet object, the output target table and the information referred to by the table can be collected and output on one page.

  The reason is that an output control program that operates on a device that processes spreadsheet data analyzes the spreadsheet data to obtain setting information, extracts table data to be output based on the obtained setting information, Determine whether the extracted table data refers to other table data, and if other table data is referenced, the table data to be output and at least a part of the referenced other table data This is because the layout is changed so as to be integrated into one page, and output data in which objects are arranged in the changed layout is generated and controlled to be output to the printing apparatus or display apparatus.

1 is a schematic diagram illustrating a configuration of a printing system according to an embodiment of the present invention. 1 is a schematic diagram illustrating a configuration of a printing system according to an embodiment of the present invention. It is a block diagram which shows the structure of the client terminal which concerns on one Example of this invention. It is a block diagram which shows the structure of the controller which concerns on one Example of this invention. 1 is a block diagram illustrating a configuration of a printing apparatus according to an embodiment of the present invention. It is a schematic diagram explaining the problem in the output of the conventional table data. It is a schematic diagram explaining the output control method which concerns on one Example of this invention. It is a flowchart figure which shows the process of the controller which concerns on one Example of this invention. It is a schematic diagram which shows the example of specification of table data (when specifying a range). It is a schematic diagram which shows the example of specification of table data (when specifying a graph). It is a schematic diagram which shows the numerical example of table | surface data. It is a schematic diagram which shows the identification method of the whole table | surface data of the spreadsheet which concerns on one Example of this invention. It is a schematic diagram which shows the identification method of the reference table data of the spreadsheet which concerns on one Example of this invention. It is a schematic diagram which shows the case where the reference table data is referring to other table data. It is a schematic diagram which shows the spreadsheet table data and reference table data which concern on one Example of this invention.

  As shown in the background art, in a spreadsheet such as Microsoft Excel, if a range or object is specified, only the specified range or object is output, so the object associated with the output target object Cannot print on the same page or display on the same screen. For example, when a table and a table referenced by the table are divided into a plurality of pages or different worksheets, the plurality of tables are output separately. For this reason, if the user wants to check whether the contents of the table are correct, the user has to check the contents of the referenced table by straddling pages or across sheets, which is very complicated. Become. Further, since the print setting is performed for each worksheet, it is necessary to perform the same print setting operation for each worksheet, and the work becomes very complicated.

  Therefore, in one embodiment of the present invention, when outputting a table included in a spreadsheet, the relationship between the tables is analyzed, and when the table refers to another table, it is referred to as the original table. Even if the table is on a different page or a different worksheet, control is performed so that these tables are aggregated and output on the same page.

  Specifically, in an apparatus that processes spreadsheet data, the spreadsheet data is analyzed to obtain setting information including output designation information, and table data to be output is extracted based on the obtained setting information. Based on the formula of each cell included in the table data to be output, determine whether the table data refers to other table data, and if the table data refers to other table data, the table to be output Change the layout so that the data and at least a part of other referenced table data are aggregated on the same page, generate output data with objects arranged in the changed layout, and print devices, display devices, etc. Controls output to the output device.

  As a result, it is possible to look over the entire document with only one output page, and when it is desired to check whether the table data is correct, there is no need to bother to go to the table data of the reference destination, reducing the user's trouble. be able to.

  In order to describe the above-described embodiment of the present invention in more detail, an output control program and an output control method according to an embodiment of the present invention will be described with reference to FIGS. 1 and 2 are schematic diagrams showing the configuration of the printing system of this embodiment, and FIGS. 3 to 5 are block diagrams showing the configurations of a client terminal, a controller, and a printing apparatus, respectively. 6 is a schematic diagram for explaining a problem in outputting table data, FIG. 7 is a schematic diagram for explaining an output control method of the present embodiment, and FIG. 8 shows processing of the controller of the present embodiment. It is a flowchart figure. FIGS. 9 and 10 are schematic diagrams showing examples of specifying table data, and FIG. 11 is a schematic diagram showing examples of formulas for table data. 12 and 13 are schematic diagrams showing a method for specifying the reference table data of the spreadsheet according to the present embodiment, and FIG. 14 is a schematic diagram showing a case where the reference table data refers to other table data. FIG. 15 is a schematic diagram showing the spreadsheet table data and reference table data of the present embodiment.

  The output control of the present invention can be applied to both the case where the spreadsheet table data is printed and the case where it is displayed. However, in the following embodiment, when the spreadsheet direct print is instructed, the table is displayed. A description will be given of control when data and referenced table data are collected and printed on the same page. The table data in the present invention is data describing information of each cell in a table composed of a plurality of cells.

  As shown in FIG. 1, the printing system 10 according to the present embodiment includes a client terminal 20, a controller 30, a printing device 40, and the like. These are connected via a communication network 50 such as a LAN (Local Area Network) or a WAN (Wide Area Network) defined by standards such as Ethernet (registered trademark), token ring, and FDDI (Fiber-Distributed Data Interface). .

  The controller 30 and the printing apparatus 40 may be connected by a dedicated line such as PCI (Peripheral Component Interconnect) connection. In FIG. 1, the printing system 10 includes the client terminal 20, the controller 30, and the printing device 40, but the controller 30 may be built in the printing device 40 as illustrated in FIG. 2. Hereinafter, each apparatus will be described on the premise of the printing system 10 of FIG.

[Client terminal]
The client terminal 20 is a computer device such as a personal computer, a portable terminal such as a smartphone or a tablet, and creates spreadsheet data (hereinafter referred to as document data) and transmits it to the controller 30. As shown in FIG. 3A, the client terminal 20 includes a control unit 21, a storage unit 25, a network I / F unit 26, a display unit 27, an operation unit 28, and the like.

  The control unit 21 includes a CPU (Central Processing Unit) 22 and a memory such as a ROM (Read Only Memory) 23 and a RAM (Random Access Memory) 24. The CPU 22 stores a control program stored in the ROM 23 and the storage unit 25. Is expanded in the RAM 24 and executed to control the operation of the entire client terminal 20. As shown in FIG. 3B, the control unit 21 (CPU 22) executes an OS (Operating System) 21a, an application 21b, a direct print utility 21c, and the like.

  The OS 21a is Windows (registered trademark), Mac OS (registered trademark), Android (registered trademark), or the like, and enables the client terminal 20 to operate the application 21b, the direct print utility 21c, and the like.

  The application 21b is a spreadsheet application (spreadsheet) such as Microsoft Excel, and creates document data in which objects such as diagrams, tables, and characters are arranged in the sheet. The material data of the spreadsheet includes setting information that defines output designation information, the number of sheets, the number of pages per sheet, the page size, object information (size, drawing position, etc.), and the like.

  The direct print utility 21c monitors a predetermined folder (for example, a folder in the storage unit 25), and when the material data of the spreadsheet is stored in the predetermined folder, the material data is transmitted to the controller 30 for direct printing. Instruct.

  The storage unit 25 includes an HDD (Hard Disk Drive), an SSD (Solid State Drive), and the like, and stores a program for the CPU 22 to control each unit, spreadsheet data, and the like.

  The network I / F unit 26 is configured by a NIC (Network Interface Card), a modem, or the like, and connects the client terminal 20 to the communication network 50 so that spreadsheet material data can be transmitted.

  The display unit 27 includes a liquid crystal display (LCD), an organic EL (electroluminescence) display, and the like, and displays a screen of the application 21b.

  The operation unit 28 includes a mouse, a keyboard, and the like, and enables operations such as creation of spreadsheet material data, designation of an output target, and direct print instruction using the application 21b.

  In FIG. 3B, the direct print utility 21c is used to issue a print instruction. However, it is also possible to issue a print instruction using a printer driver. In that case, the printer driver is executed by the control unit 21, and the printer driver converts the material data created by the application 21b into pages such as PJL (Printer Job Language), PS (PostScript), and PCL (Printer Control Language). The data is converted into a PDL (Page Description Language) job described in a description language and transmitted to the controller 30. At this time, information indicating each cell constituting the table and information indicating the reference relationship of the table are added to the setting information added to the job.

[controller]
The controller 30 processes the spreadsheet material data received from the client terminal 20 and instructs the printing apparatus 40 to print. As shown in FIG. 4A, the controller 30 includes a control unit 31, a storage unit 35, a network I / F unit 36, a display unit 37, an operation unit 38, and the like.

  The control unit 31 includes a CPU 32 and a memory such as a ROM 33 and a RAM 34. The CPU 32 controls the overall operation of the controller 30 by developing the control program stored in the ROM 33 and the storage unit 35 in the RAM 34 and executing it. To do. 4B, the control unit 31 functions as a data analysis unit 31a, a layout change unit 31b, an output data generation unit 31c, a display control unit 31d, and the like.

  The data analysis unit 31a analyzes the spreadsheet data received from the client terminal 20, and defines output designation information, the number of sheets, the number of pages for each sheet, page size, object information (size, drawing position, etc.), and the like. Get configuration information. Then, an output target object is extracted based on the acquired setting information, and it is determined whether the extracted object is table data to be output. In addition, the data analysis unit 31a determines a print page size based on the acquired setting information, divides the sheet into pages based on the determined print page size, and arranges an object on each divided page.

  The layout changing unit 31b determines whether the output target table data extracted by the data analysis unit 31a refers to other table data that is not the output target. If the table data to be output refers to other table data, the table data to be output and at least a part of the other table data being referenced are aggregated on one page. Change the data layout. Specifically, it is determined whether a formula is included in at least one cell of the table data to be output, and if any cell contains a formula, it is output to the row number / column number in the formula. It is determined whether a cell number other than the target table data is included. If the cell number other than the table data to be output is included, identify the table data corresponding to the row number / column number in the formula, and from the corresponding table data to the row number / column number in the formula A corresponding cell is specified, and the entire other table data being referred to is specified based on the presence or absence of data in a cell adjacent to the specified cell. Then, according to a predetermined rule, an aggregation range is set from the entire table data being referenced, and the aggregation range is added to the output target as reference table data.

  The output data generation unit 31c functions as a RIP (Raster Image Processor) unit, rasterizes the material data, and places output target objects in accordance with the layout changed by the layout change unit 31b (particularly, the output target table). Output data in which the data and the aggregation range are aggregated on the same page (preferably, output data in which the table data to be output and the aggregation range are aggregated adjacent to each other) are generated, and the generated output data is transmitted to the printing apparatus 40. .

  The display control unit 31d is provided as necessary, and displays a display image in which objects to be output are arranged according to the layout changed by the layout change unit 31b (particularly, the table data to be output and the aggregation range are aggregated on the same page. A display image (preferably, a display image in which the table data to be output and the aggregation range are aggregated adjacent to each other) is displayed on the display unit 37.

  The data analysis unit 31a, the layout change unit 31b, the output data generation unit 31c, and the display control unit 31d may be configured as hardware, or the control unit 31 may be configured as a data analysis unit 31a, a layout change unit 31b, and output data. The output control program may be configured to function as the generation unit 31c and the display control unit 31d (particularly, the data analysis unit 31a, the layout change unit 31b, and the output data generation unit 31c), and the CPU 32 may execute the output control program. Good.

  The storage unit 35 is configured by an HDD, an SSD, or the like, and stores programs for the CPU 32 to control each unit, spreadsheet data received from the client terminal 20, output data generated by the output data generation unit 31c, and the like.

  The network I / F unit 36 includes a NIC, a modem, and the like, and connects the controller 30 to the communication network 50 so that the spreadsheet material data can be received from the client terminal 20 and the output data can be transmitted to the printing apparatus 40. To do.

  The display unit 37 is a display device configured by a liquid crystal display device, an organic EL display device, or the like, and displays various screens. In the present embodiment, in particular, a display image in which objects are arranged is displayed according to the layout changed by the layout changing unit 31b in accordance with the control of the display control unit 31d.

  The operation unit 38 includes a mouse, a keyboard, and the like, and enables various operations.

[Printer]
The printing apparatus 40 is an MFP (Multi-Functional Peripherals), a single function printer, or the like, and performs printing on a sheet based on output data received from the controller 30. As shown in FIG. 5, the printing apparatus 40 includes a control unit 41, a storage unit 45, a network I / F unit 46, a display operation unit 47, a reading unit 48, a printing unit 49, and the like.

  The control unit 41 includes a CPU 42 and a memory such as a ROM 43 and a RAM 44. The CPU 42 develops a control program stored in the ROM 43 and the storage unit 45 in the RAM 44 and executes it, thereby controlling the overall operation of the printing apparatus 40. To do.

  The storage unit 45 is configured by an HDD, an SSD, or the like, and stores a program for the CPU 42 to control each unit, information on processing functions of the own device, output data, and the like.

  The network I / F unit 46 is configured by a NIC, a modem, or the like, and connects the printing apparatus 40 to the communication network 50 so that output data can be received from the controller 30.

  The display operation unit 47 is a touch panel provided with a pressure-sensitive operation unit (touch sensor) in which transparent electrodes are arranged in a grid pattern on the display unit, displays various screens related to printing processing, and performs various operations related to printing. to enable.

  The reading unit 48 is a part that optically reads image data from a document on a document table, and an image such as a light source that scans the document and a CCD (Charge Coupled Devices) that converts light reflected by the document into an electrical signal. The sensor and an A / D converter for A / D converting an electric signal are used. The reading unit 48 is not essential.

  The printing unit 49 is a print engine that forms a print image on paper supplied from the paper supply unit and outputs the print image to the paper discharge unit. The printing unit 49 includes, for example, an exposure unit that irradiates and exposes a laser beam based on a printed image, a photosensitive drum, a developing unit, a charging unit, a photosensitive unit cleaning unit, and a primary transfer roller. An image forming unit that forms a toner image of each color, an intermediate belt that is rotated by a roller and functions as an intermediate transfer member that conveys the toner image formed by the image forming unit to a sheet, and a toner image formed on the intermediate belt Is composed of a secondary transfer roller for transferring the toner image onto the paper and a fixing unit for fixing the toner image transferred onto the paper.

  1 to 5 show an example of the printing system 10 of the present embodiment, and the configuration and control of each device can be changed as appropriate. For example, in the above description, the case where the controller 30 controls the printing device 40 has been described. However, when the controller 30 is built in the printing device 40 as illustrated in FIG. 2, the control unit 41 of the printing device 40 performs data analysis. It may be configured to function as a section, a layout change section, an output data generation section, and a display control section (the CPU 42 executes an output control program).

  In the above description, the control unit 31 of the controller 30 is configured to function as the data analysis unit 31a, the layout change unit 31b, the output data generation unit 31c, and the display control unit 31d. However, the control unit 21 of the client terminal 20 is changed in layout. The display 21 may function as a display unit, a display control unit, or the like (or the application 21b may have functions such as a layout change unit and a display control unit).

  The output control in the printing system 10 configured as described above will be outlined with reference to FIGS. As shown in FIG. 6, for example, when the worksheet is composed of four pages and the table data (table data on the second page) refers to another table data (table data on the fourth page), the original In order to confirm whether tabular data is correct, it is necessary to examine it against the related information. However, when table data and referenced table data (referred to as reference table data) are divided into a plurality of pages or different worksheets, the user straddles the pages one by one or straddles the sheets. It is necessary to go back and forth between a plurality of table data, and the work is very complicated.

  For this problem, in this embodiment, for the four pages of the worksheet shown in FIG. 6, as shown in FIG. 7A, an object surrounded by a thick line of pages 1-3 is designated as an output target. In this case, as shown in FIG. 7B, not only the objects of pages 1 to 3, but also the objects (reference table data) of the fourth page referred to by the objects (table data) of the second page are output targets. Include in Further, in order to make it easier to compare the original table data and the reference table data, as shown in FIG. 7C, they are arranged close to each other (the reference table data on the fourth page is changed to the table on the second page). Placed immediately after the data).

  Hereinafter, the operation of the controller 30 of this embodiment (or the printing apparatus 40 incorporating the controller 30) will be specifically described. The CPU 32 executes the processing of each step shown in the flowchart of FIG. 8 by developing the output control program stored in the ROM 33 or the storage unit 35 in the RAM 34 and executing it. In the following description, spreadsheet data is created using the application 21b of the client terminal 20, and the data is transmitted to the controller 30 (or the printing apparatus 40 incorporating the controller 30) by the direct print utility 21c. Shall.

  The control unit 31 (data analysis unit 31a) of the controller 30 receives the material data from the client terminal 20, analyzes the material data, and sets the setting information (output designation information, the number of sheets, the number of pages per sheet, the page size, the object Information etc.) is acquired (S101). Note that the output target object is specified by the output specification information. There are two methods for specifying the output target table data: (1) a range specification method and (2) a graph specification method. is there. Regarding (1), for example, as shown in FIG. 9, the application 21b of the client terminal 20 can specify the table data to be output by drawing a frame surrounding the table. Regarding (2), for example, as shown in FIG. 10, a graph is designated on the application 21b of the client terminal 20, or a graph is selected and designated by a print setting by the direct print utility 21c of the client terminal 20. The table data to be output can be specified by selecting and specifying a graph with the operation unit 38 of the controller 30 or the like. It is also possible to specify that all table data in the material data is to be output.

  Next, the control unit 31 (data analysis unit 31a) extracts an output target object based on the acquired setting information (output designation information) (S102), and determines whether the extracted object is output target table data. Judgment is made (S103). When the extracted object is not table data to be output (for example, in the case of a graph) (No in S103), the control unit 31 (output data generation unit 31c) does not include the extracted object in the output data (S110). If the extracted object is the output target table data (Yes in S103), the extracted table data is put in the output data (S104). In the above, when the extracted object is a graph, it is not included in the output data. However, if the graph is created based on the output target table data, the graph data is input to the output data and output. It may be output to a page different from the target table data.

  Next, the control unit 31 (layout changing unit 31b) determines whether or not a formula is included in at least one cell of the table data to be output (S105), and if the table data includes a formula (Yes in S105). ), It is determined whether the row number / column number in the formula includes a cell number other than the original table data (S106). When the table data does not include a formula (No in S105), or the row number / column number in the formula does not include a cell number other than the original table data (other table data is not referred to). (No in S106), there is no need to search for the table data to be referred to, so the process proceeds to S111.

  On the other hand, when the cell number other than the original table data is included in the row number / column number in the formula (Yes in S106), the control unit 31 (layout changing unit 31b) displays the row number / column number in the formula. Table data corresponding to is specified (S107). Then, the control unit 31 (layout changing unit 31b) specifies the cell corresponding to the row number / column number in the formula from the corresponding table data, and refers to it based on the presence or absence of data in the cell adjacent to the corresponding cell. The entire table data is identified (S108).

  For example, as shown in FIG. 11, a formula of table data (here, a formula specifying K22, L22, and M22 cells of the sheet “sample” surrounded by a thick solid line) is extracted. In addition, as shown in FIG. 12, when the cells surrounded by the thick broken lines are the K22, L22, and M22 cells of the “sample” sheet, specify the cells containing some data on the top, bottom, left, and right of those cells. To do. Here, since data is contained in the upper 1 row, the lower 3 rows, and the left 3 columns, the area surrounded by the thick solid line in the figure is recognized as the entire table data being referred to.

  Next, the control unit 31 (layout changing unit 31b) sets an aggregation range from the entire table data being referenced according to a predetermined rule, and the set aggregation range is set to the same page as the table data to be output. The layout is changed so as to be aggregated, and the control unit 31 (output data generation unit 31c) puts the set aggregation range (reference table data) in the output data (S109). There are the following three methods for setting the aggregation range.

  The first method is a method in which the entire referenced table data is used as reference table data. For example, when the size of the table data being referenced is equivalent to the size of the table data to be output, or smaller than the table data to be output, or at most about 1, 2 rows / 1, 2 columns In other words, when the size of the referenced table data is equal to the size of the table data to be output, the entire referenced table data is used as the reference table data. In addition, when the size of the referenced table data is a level that fits within the output range of one page when it is aggregated on the same page as the table data to be output, the entire referenced table data is the reference table data. And Note that the table data being referenced can be reduced to fit on one page, but it is preferable to consider so that the readability of the table is not lost at that time. For example, the font size at the time of printing is 6 pt or more. It is preferable to ensure it. In addition, when the ratio of the number of cells corresponding to the row number / column number in the formula to the total number of cells of the referenced table data is 50% or more, the entire referenced table data is referred to. If the data is less than 50%, the specified part is used as reference table data according to the second method described later.

  The second method is a method in which a part of the referenced table data is used as reference table data. For example, when a cell surrounded by a thick solid line in the table data to be output shown in FIG. 13A refers to a cell surrounded by a thick solid line in the table data shown in FIG. 13B, the cell is output. Item cell indicating the cell corresponding to the row number / column number in the formula of the table data and the data item arranged in the same row and / or the same column as the cell (first cell on the top, bottom, left, and right of the table data (other than numerical values) ))) And the reference table data. In addition, when the data item is cell-coupled, from the cell next to it (including characters other than numeric values), the cell with the same row number or column number as the corresponding cell (the cell marked “sam” here) ).

  The third method is a method in which only the cell corresponding to the row number / column number in the formula of the table data to be output is used as reference table data.

  When the table data to be output and the aggregation range (reference table data) set by any of the above methods are aggregated into one page, the table data is arranged in page order as shown in FIG. Alternatively, as shown in FIG. 7C, the table data to be output and the reference table data may be arranged adjacent to each other.

  Also, if the table data to be output and the reference table data straddle the page as a result of laying out the object to be output, the table data to be output and the reference table data are consolidated and printed on the same page. Change the layout to be Specifically, the control unit 31 (layout changing unit 31b) determines whether or not the table data to be output and the reference table data can be within the same page print range, and cannot be within the same page print range. Forms a page break before the table data to be output, and prints the table data to be output and the reference table data on the next page.

  Further, when the referenced table data refers to another table data, the other table data (referred to as “referenced table data”) is also an aggregation target. For example, as shown in FIG. 14, the portion surrounded by the thick broken line of the table data to be output (table data on the lower side of the figure) is the thick broken line of the referenced table data (table data at the center of the figure). When the cell surrounded by the thick solid line of the table data to be referenced refers to the cell surrounded by the thick solid line of the referenced table data (the table data on the upper side of the figure), Not only the table data to be referenced but also the referenced table data is targeted for aggregation.

  Returning to FIG. 8, the control unit 31 (output data generation unit 31 c) performs the processing of S <b> 103 to S <b> 110 for all the objects to be output, and then outputs the output data to the printing device 40. Based on the output data, the table data to be output and the reference table data (and higher-level referenced table data if necessary) are collected and output as a printed matter (S111). Alternatively, the control unit 31 (display control unit 31d) can generate table data and reference table data to be output based on the output data generated by the output data generation unit 31c (and higher-level referenced table data as necessary). And) are displayed on the display unit 37.

  In the above flow, the control unit 31 (output data generation unit 31c) puts the table data to be output in the output data in S104, and puts the aggregation range in the output data in S109. However, the control unit 31 (layout change unit) After 31b) changes the layout, output data may be generated according to the changed layout.

  In this way, when the table data refers to another table data, the table data and the referenced table data are combined even if the referenced other table data is on another page or another worksheet. By collecting and outputting on the same page, the entire document can be looked over, and the user can omit the troublesome work of checking a plurality of table data one by one. Further, when checking whether the table data is correct or what the meaning of the data is, not only the table data but also the reference table data having information different from the target table data (if necessary, a higher-level table data) (Reference table data) is also aggregated, so that it is possible to increase the accuracy and validity judgment materials, and the table data can be confirmed efficiently at a time.

  For example, as shown in FIG. 14, it can be seen that the number of NG cases is 25 when the numerical values of the A, B, and C ranks are combined in the first reference table data. From this, the 25 cases are less than the number of NG cases detected from the other evaluation items, and information that the quality of the evaluation items is good is obtained. For example, as shown in FIG. 15A, when the cell value is selected from the pull-down data, the reference table data (pull-down option) shown in FIG. 15B is also output together. Thus, it is possible to obtain information such as what options are available and what steps (procedures) need to be taken later.

  In addition, this invention is not limited to the said Example, The structure and control can be changed suitably, unless it deviates from the meaning of this invention.

  For example, in the above-described embodiment, the print control in the direct print is described as an example of the output control. However, the present invention can be applied to the case where the document data created by the application 21b is displayed on the client terminal 20 or the controller 30. The output control method can be similarly applied.

  The present invention is applicable to an output control program for controlling the output of table data, a recording medium recording the output control program, and an output control method.

DESCRIPTION OF SYMBOLS 10 Printing system 20 Client terminal 21 Control part 21a OS
21b Application 21c Direct Print Utility 22 CPU
23 ROM
24 RAM
25 storage unit 26 network I / F unit 27 display unit 28 operation unit 30 controller 31 control unit 31a data analysis unit 31b layout change unit 31c output data generation unit 31d display control unit 32 CPU
33 ROM
34 RAM
35 Storage Unit 36 Network I / F Unit 37 Display Unit 38 Operation Unit 40 Printing Device 41 Control Unit 42 CPU
43 ROM
44 RAM
45 Storage Unit 46 Network I / F Unit 47 Display Operation Unit 48 Reading Unit 49 Printing Unit 50 Communication Network

Claims (20)

An output control program that operates on an apparatus for processing spreadsheet data,
In the device,
Analyzing the spreadsheet data, obtaining setting information including output designation information for designating an object to be output, and extracting table data to be output based on the setting information;
It is determined whether the output target table data refers to other table data that is not an output target, and when the output target table data refers to the other table data, the output target table data And a second process for changing the layout so that at least a part of the other table data is aggregated on the same page,
Generating output data in which objects are arranged according to the changed layout, and executing a third process of outputting the output data to a printing device or a display device;
An output control program characterized by that. In the second process, it is determined whether at least one cell of the table data to be output includes a formula specifying a cell other than the table data to be output, and when the formula is included The other table data including the cell specified by the formula is specified, an aggregation range is set from the other table data according to a predetermined rule, and the table data to be output and the aggregation range are the same Change the layout to be consolidated on the page,
The output control program according to claim 1. In the second process, when setting the aggregation range, the whole of the other table data is specified based on the presence or absence of data in a cell adjacent to the cell specified by the formula.
The output control program according to claim 2. In the second process, when the size of the other table data is equal to the size of the table data to be output, a predetermined font size is set for the table data to be output and the aggregation range of the other table data. If it can be consolidated on the same page as described above, or if the ratio of the number of cells specified by the above formula to the total number of cells of the other table data is 50% or more, the entire other table data is Set to the aggregation range,
The output control program according to claim 2 or 3, characterized in that. In the second process, when the ratio of the number of cells specified by the formula to the number of all cells of the other table data is less than 50%, the cell specified by the formula is the same as the cell An item cell indicating a data item arranged in a row and / or the same column, and set in the aggregation range,
The output control program according to claim 2 or 3, characterized in that. In the second process, only the cells specified by the formula are set in the aggregation range.
The output control program according to claim 2 or 3, characterized in that. In the second process, when the other table data refers to another table data, the other table data is also set in the aggregation range.
The output control program according to claim 2, wherein the output control program is a program. In the second process, the table data to be output and the aggregation range are aggregated adjacent to each other.
The output control program according to any one of claims 2 to 7, In the second process, when the table data to be output and the aggregation range straddle a page, a page break is performed before the table data to be output, and the table data to be output and the aggregation range are combined. To the next page,
The output control program according to any one of claims 2 to 8, wherein An output control method in a system including a device for processing spreadsheet data and a printing device or a display device,
The device is
Analyzing the spreadsheet data, obtaining setting information including output designation information for designating an object to be output, and extracting table data to be output based on the setting information;
It is determined whether the output target table data refers to other table data that is not an output target, and when the output target table data refers to the other table data, the output target table data And a second process for changing the layout so that at least a part of the other table data is aggregated on the same page;
Generating output data in which objects are arranged according to the changed layout, and executing a third process of outputting the output data to a printing apparatus or a display apparatus;
An output control method characterized by the above. In the second process, it is determined whether at least one cell of the table data to be output includes a formula specifying a cell other than the table data to be output, and when the formula is included The other table data including the cell specified by the formula is specified, an aggregation range is set from the other table data according to a predetermined rule, and the table data to be output and the aggregation range are the same Change the layout to be consolidated on the page,
The output control method according to claim 10. In the second process, when setting the aggregation range, the whole of the other table data is specified based on the presence or absence of data in a cell adjacent to the cell specified by the formula.
The output control method according to claim 11. In the second process, when the size of the other table data is equal to the size of the table data to be output, a predetermined font size is set for the table data to be output and the aggregation range of the other table data. If it can be consolidated on the same page as described above, or if the ratio of the number of cells specified by the above formula to the total number of cells of the other table data is 50% or more, the entire other table data is Set to the aggregation range,
The output control method according to claim 11 or 12, characterized in that: In the second process, when the ratio of the number of cells specified by the formula to the number of all cells of the other table data is less than 50%, the cell specified by the formula is the same as the cell An item cell indicating a data item arranged in a row and / or the same column, and set in the aggregation range,
The output control method according to claim 11 or 12, characterized in that: In the second process, only the cells specified by the formula are set in the aggregation range.
The output control method according to claim 11 or 12, characterized in that: In the second process, when the other table data refers to another table data, the other table data is also set in the aggregation range.
The output control method according to any one of claims 11 to 15, wherein: In the second process, the table data to be output and the aggregation range are aggregated adjacent to each other.
The output control method according to any one of claims 11 to 16, wherein: In the second process, when the table data to be output and the aggregation range straddle a page, a page break is performed before the table data to be output, and the table data to be output and the aggregation range are combined. To the next page,
The output control method according to any one of claims 11 to 17, wherein: The printing apparatus creates a printed matter in which the output target table data and the aggregation range are aggregated on the same page based on the output data.
The output control method according to claim 11, wherein: The display device displays a display image in which the table data to be output and the aggregation range are aggregated on the same page based on the output data.
The output control method according to claim 11, wherein:

Images