Information processing system, information processing method, and program

The print output adjustment system addresses the inefficiencies in existing image reading devices by using correction objects and a correction unit to remove margins and ensure distortion-free printing, thereby simplifying the printing process and improving efficiency.

JP7658629B1Active Publication Date: 2025-04-08DOCURAIN INC
View PDF 4 Cites 0 Cited by

Patent Information

Application Number
JP2024058480
Authority / Receiving Office
JP · JP
Patent Type
Patents
Current Assignee / Owner
Filing Date
2024-04-01
Publication Date
2025-04-08
Estimated Expiration
2044-04-01

AI Technical Summary

Technical Problem

Existing image reading devices require significant user effort to achieve desired printing layouts and struggle with handling large amounts of image data, leading to inefficient printing processes.

Method used

A print output adjustment system that utilizes spreadsheet software to create print data with a prescribed paper size, includes an object arrangement unit for placing correction objects to identify peripheral edges, and a correction unit to enlarge and correct the print display area, removing margins and ensuring distortion-free printing.

Benefits of technology

The system enables simple and efficient processing to achieve desired printing results by removing margins and maintaining the original size and layout of print data, thereby reducing user effort and improving printing efficiency.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure 0007658629000001_ABST
    Figure 0007658629000001_ABST
Patent Text Reader

Abstract

The object is to provide a system that can obtain a desired print result with simple processing. [Solution] The system includes print data for printing, created with an aspect ratio of a specified paper size by spreadsheet software that displays multiple cells arranged in a grid pattern, an object placement unit that places correction objects whose positional relationship with the periphery of the print data can be identified in at least two locations within the range of the print data, and a correction unit that corrects the converted data into converted data, the converted data being in a file format that indicates the state when printed on paper of the specified paper size, including a print display area in which the print data is displayed and a margin area around the print display area, by enlarging the print display area so that the margin area is eliminated, based on the correction object included in the print display area.
Need to check novelty before this filing date? Find Prior Art

Description

[Technical field]

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

[0002] 2. Description of the Related Art There is known an image reading device that enables an image read from a document to be printed on a print medium in any size or layout that a user intends or plans (see, for example, Patent Document 1). [Prior art documents] [Patent documents]

[0003] [Patent Document 1] JP 2007-143109 A Summary of the Invention [Problem to be solved by the invention]

[0004] The image reading device described in Patent Document 1 detects the area of ​​the image data received by the printing device that will be placed on the printing medium, and uses the detection results to correct the original image so that the image can be printed on the printing medium in the desired layout. Specifically, first, the image reading device transmits reference image data to the printing device. The printing device prints the reference image. Next, once printing of the reference image is complete, the user uses the scanner unit of the image reading device to read the print medium on which the reference image has been printed, and generates image data for correction. At this time, the image reading device uses the internal setting information of the printing device to Based on the result, the image reading device corrects the reference image to generate image data for correction. In this way, the image reading device can cause the printing device to print the document image on the printing medium in a desired size or layout (image data for correction) via optical reading.

[0005] However, the image reading device described in Patent Document 1 requires a great deal of work from the user to print in a desired layout, and is therefore unable to handle printing of huge amounts of image data.

[0006] SUMMARY OF THE PRESENT DISCLOSURE In view of the above problems, an object of the present invention is to provide a system that can obtain a desired print result with simple processing. [Means for solving the problem]

[0007] An information processing system according to one embodiment of the present invention includes print data for printing created with an aspect ratio of a predetermined paper size by spreadsheet software that displays a plurality of cells arranged in a grid pattern, an object placement unit that places correction objects whose positional relationship with the periphery of the print data can be identified in at least two locations within the range of the print data, and a correction unit that corrects the converted data into converted data, the converted data being in a file format that indicates the state when printed on paper of the predetermined paper size, including a print display area in which the print data is displayed and a margin area around the print display area, by enlarging the print display area so that the margin area is eliminated based on the correction object included in the print display area.

[0008] An information processing method according to one aspect of the present invention includes a computer executing the following steps: placing correction objects, whose positional relationship with the periphery of the print data can be identified, at at least two locations within the range of print data for printing, which is print data for printing created by a computer using spreadsheet software that displays a plurality of cells arranged in a grid pattern, and correcting the print display area into which the print data has been converted, based on the correction objects included in the print display area, so that the margin area is eliminated, for converted data in a file format that indicates the state of printing on paper of the specified paper size, including a print display area in which the print data is displayed and a margin area around the print display area into which the print data has been converted.

[0009] A program according to one aspect of the present invention causes a computer to execute the following steps: place correction objects, whose positional relationship with the periphery of the print data can be identified, in at least two locations within the range of the print data for printing, which is print data for printing created by spreadsheet software that displays a plurality of cells arranged in a grid pattern, and correct the converted data, which is in a file format indicating the state of printing on paper of the specified paper size, including a print display area into which the print data is converted and in which the print data is displayed, and a margin area around the print display area, by enlarging and correcting the print display area so that the margin area is eliminated, based on the correction objects included in the print display area. Effect of the Invention

[0010] According to the present invention, it is possible to provide a system that can obtain a desired print result with simple processing. [Brief description of the drawings]

[0011] [Figure 1] FIG. 1 illustrates an example of a configuration of a print output adjustment system. [Diagram 2] FIG. 13 is a diagram showing an example of print information D111. [Diagram 3] FIG. 13 is a diagram showing an example of format information D112. [Figure 4] FIG. 13 is a diagram showing print data generated by spreadsheet software. [Diagram 5] FIG. 13 is a diagram showing an example of a state in which a correction object is arranged in print data. [Figure 6] 13A and 13B are diagrams illustrating another example of a state in which a correction object is arranged in print data. [Figure 7] FIG. 11 is a diagram showing an example of PDF data converted from print data. [Figure 8] 13A and 13B are diagrams illustrating an example of specifying a print display area based on a PDF-converted correction object. [Figure 9] 13A and 13B are diagrams illustrating an example in which a print display area is enlarged and margin areas are removed. [Figure 10] FIG. 13 is a diagram showing a state in which correction objects are placed at two arbitrary positions in print data. [Figure 11] 10 is a flowchart illustrating an example of a processing procedure of the print output adjustment system. [Figure 12] FIG. 2 illustrates an example of a hardware configuration of a computer. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0012] A preferred embodiment of the present invention (hereinafter, referred to as "the present embodiment") will be described with reference to the attached drawings. In each drawing, the same reference numerals are used to denote the same or similar configurations. In this embodiment, "part", "means", "apparatus", and "system" do not simply mean physical means, but also include cases where the functions of the "part", "means", "apparatus", and "system" are realized by software. In addition, the functions of one "part", "means", "apparatus", or "system" may be realized by two or more physical means or devices, and the functions of two or more "parts", "means", "apparatus", or "system" may be realized by one physical means or device.

[0013] ===Print output adjustment system 100=== <<Overview>> The print output adjustment system 100 is a system that can appropriately remove margins from converted data, which is a file format that represents the state in which the data will be printed on paper, obtained by converting spreadsheet data for printing that has been created using spreadsheet software.

[0014] Spreadsheet software is software that generates spreadsheet data by arranging a large number of cells in a grid pattern to form multiple rows and columns.

[0015] The converted data is, for example, PDF (Portable Document Format) data. For convenience, the converted data will be described below as "PDF data."

[0016] In various spreadsheet software, margins are generated around the periphery of PDF data converted from spreadsheet data. This is because general printing processes are not required to print without margins on the entire surface of a printing medium such as printing paper. The range of the margins also differs depending on the type of spreadsheet software. When PDF data is stretched to remove the margins, distortion occurs in the PDF data due to factors such as the different sizes of the multiple cells that make up the original spreadsheet data. Therefore, the print output adjustment system 100 removes the margins that are generated when spreadsheet data generated by spreadsheet software is converted into PDF data without distorting the PDF data, and generates PDF data of a specified paper size without margins.

[0017] The print output adjustment system 100 may be, for example, a cloud computer, a server computer, a personal computer (e.g., a desktop, a laptop, a tablet, etc.), a media computer platform (e.g., a cable or satellite set-top box, a digital video recorder), a handheld computer device (e.g., a PDA, an email client, etc.), or any other type of computer or communication platform. At least a portion of the processing in the print output adjustment system 100 may be implemented by one or more computers (for example, but not limited to, cloud computing configured by one or more computers).

[0018] <<Configuration>> The configuration of the print output adjustment system 100 will be described with reference to Fig. 1. Fig. 1 is a diagram showing an example of the configuration of the print output adjustment system 100. As shown in Fig. 1, the print output adjustment system 100 includes, for example, a storage unit 110, an acquisition unit 120, a setting unit 130, an object arrangement unit 140, a PDF conversion unit 150, a correction unit 160, and a display processing unit 170.

[0019] The storage unit 110 includes print information D111 and format information D112.

[0020] The configuration of the print information D111 will be described with reference to Fig. 2. Fig. 2 is a diagram showing an example of the print information D111. The print output adjustment system 100 removes blank spaces from the PDF data with reference to the print information D111.

[0021] As shown in FIG. 2, the print information D111 may include items such as [Print ID], [Spreadsheet software], [Print data], [PDF data], and [Correction object]. [Print ID] stores identification information that can uniquely identify the spreadsheet data. [Spreadsheet software] stores, for example, the name of the spreadsheet software. [Print data] stores print data that is spreadsheet data. The print data may include information indicating the paper size and the length or ratio of the vertical and horizontal lengths of the cells. [PDF data] includes various information related to the PDF data. The various information is, for example, the paper size, the coordinates of the vertices in the print area R10 (for example, the two diagonal vertices or the four corner vertices), the coordinates of the vertices in the print display area R11 (for example, the two diagonal vertices or the four corner vertices), the coordinate range of the margin area R12, and the like. [Correction object] stores, for example, coordinates or coordinate ranges indicating the positions of the correction object B10 that is placed in at least two places within the range of the print data.

[0022] The configuration of the format information D112 will be described with reference to Fig. 3. Fig. 3 is a diagram showing an example of the format information D112. The print output adjustment system 100 refers to the format information D112 and converts the print data into PDF data without distortion.

[0023] The format information D112 may include items such as [format ID], [initial format], [spreadsheet software], [correction amount], [version information], and [set format]. [Format ID] stores identification information that can uniquely identify the format that reflects the print data. [Initial format] stores a format that is white data of a predetermined paper size generated by the spreadsheet software to which the print data is reflected (hereinafter referred to as "initial format"). [Spreadsheet software] stores, for example, a name that can identify the spreadsheet software. [Correction amount] stores a correction amount that is reflected in the format. The correction amount (setting condition) is, for example, the amount of adjustment of the vertical and horizontal lengths or ratios of the cells. [Version information] stores version information that can identify a combination of the spreadsheet software and the correction amount. The version information is information that can identify a template to which a specific correction amount is applied. [Set format] stores a format that is data in which the initial format is set by the setting unit 130 based on the correction amount for each cell (hereinafter referred to as "set format").

[0024] Here, the print output adjustment system 100 can provide the user with a template to which a desired correction amount has been applied by using the format information D112 that associates the correction amount at a specific time with the version information, thereby enabling the user to obtain the desired print result.

[0025] The acquisition unit 120 acquires print data D1 generated by a spreadsheet software.

[0026] The setting unit 130 sets the length or ratio of the vertical and horizontal lengths of a plurality of cells to a predetermined condition for the print data D1, which is spreadsheet data indicating printing of a predetermined paper size. The predetermined paper size is not limited to the typical A4 or A3 size, and may be any paper size. FIG. 4 is a diagram showing print data D1 generated by spreadsheet software. As shown in FIG. 4, the setting unit 130 may set the vertical length L1 and horizontal length L2 of a plurality of cells to a predetermined length (for example, 1 mm), or may set the vertical and horizontal ratio of the cells to a predetermined ratio (for example, 1:1). In FIG. 4, the print data D1 is described as being A4 size data as an example. That is, FIG. 4 shows print data D1 configured such that the vertical length:horizontal length is 297:210, for example.

[0027] As a result, all cells constituting the print data D1 show the same distortion, so the print output adjustment system 100 can convert the print data D1 into PDF data D2 and uniformly stretch it to create PDF data of a specified paper size with margins removed. In other words, the print output adjustment system 100 can produce a print output of a specified paper size with no distortion and with margins removed using a simple method, without adjusting each cell.

[0028] Furthermore, if the size of each cell in the print data D1 is changed by an unnecessary operation by the user, when the print data D1 is converted to PDF data D2, the size of certain cells will be uneven, making it difficult to remove the margins. Therefore, in the print output adjustment system 100, by making the length and width or ratio of all cells uniform before converting to PDF data D2, it becomes possible to remove the margins and print out the specified paper size simply by stretching the PDF data D2 uniformly.

[0029] The setting unit 130 may generate a set format by setting the length or ratio of the vertical and horizontal lengths of a plurality of cells of the initial format generated by the spreadsheet software to which the print data D1 is reflected, based on the correction amount of the format information D112, so that the length or ratio of the vertical and horizontal lengths of the cells is uniform. The setting unit 130 stores the set format in the format information D112.

[0030] In each format generated by the spreadsheet software, slight differences may occur in each of the multiple cells. The differences are not limited to those that can be visually identified by humans. In other words, even in the initial formats created by the same procedure using the spreadsheet software, the differences occurring in each of the multiple cells are not uniform. Therefore, the setting unit 130 generates in advance a post-setting format corrected with a correction amount corresponding to each initial format, and stores the post-setting format in the format information D112. In the print output adjustment system 100, by using a post-setting format that has been set in advance so that the multiple cells are uniform, the preparation time required for the operator to execute printing can be shortened.

[0031] The object placement unit 140 places the correction object B10, whose positional relationship with the four sides that are the periphery of the print data D1 can be specified, in at least two locations within the range of a predetermined paper size in the print data D1.

[0032] The correction object B10 is, for example, an object that is transparent or has the same color as the color of the portion in the print data D1 where it is placed. As a result, the correction object B10 is printed on the paper surface so that it is not visible. The correction object B10 may also be, for example, a point or the intersection of two straight lines.

[0033] The correction object B10 arranged in the print data D1 will be described with reference to Fig. 5 and Fig. 6. Fig. 5 is a diagram showing an example of a state in which the correction object B10 is arranged in the print data D1. Fig. 6 is a diagram showing another example of a state in which the correction object B10 is arranged in the print data D1.

[0034] 5, the object placement unit 140 places the correction object B10 at any two positions within the range of the print data D1. The object placement unit 140 may place the correction object B10 so that it extends beyond the diagonal vertex of the print data D1 and includes the vertex. The object placement unit 140 may also place the correction object B10 so that it surrounds the range of the print data D1 with four straight lines.

[0035] Here, as shown in Fig. 6, it is preferable that the object placement unit 140 places each of the correction objects B10 so as to overlap with each of the two diagonal vertices of the print data D1. In this case, the object placement unit 140 refers to the print information D111 to identify the coordinates of the two diagonal vertices of the print data D1. The object placement unit 140 places the correction object B10 at the coordinates. This allows the print output adjustment system 100 to reduce the amount of processing by the correction unit 160, which will be described later, and therefore makes it possible to increase the execution speed of the print process. For the sake of convenience, the following description will be given assuming that the correction object B10 is placed at each of the two diagonal vertices.

[0036] Furthermore, the object placement unit 140 may, for example, accept a user's operation input for each of two diagonal vertices of the print data D1 displayed on the display screen, and place the correction object B10 at the vertices. This allows the print output adjustment system 100 to place the correction object B10 at the two diagonal vertices visually recognized by the user, thereby enabling the user to execute the print processing intended by the user.

[0037] The PDF conversion unit 150 converts the print data D1 in which the cells are set by the setting unit 130 and the correction object B10 is arranged into PDF data D2 of a predetermined paper size. Note that the PDF conversion unit 150 does not need to be included in the print output adjustment system 100, and may be, for example, a functional unit executed in another system.

[0038] The PDF data D2 will be described with reference to Fig. 7. Fig. 7 is a diagram showing an example of the PDF data D2 obtained by converting the print data D1. As shown in Fig. 7, the PDF data D2 is an area to be printed on a print medium by a printing device, and includes a print area R10 of a predetermined paper size. The print area R10 includes, for example, a print display area R11, which is an area where the print data D1 is displayed, and a margin area R12, which is an area showing the margins around the print display area R11.

[0039] The range of the margin area R12 varies depending on the version of the PDF conversion software used when converting print data D1 to PDF data D2. In other words, when print data D1 is converted to PDF data D2, the length or ratio of the vertical and horizontal lengths of each cell in the original print data D1 of the PDF data D2 varies.

[0040] As will be described later, the print output adjustment system 100 appropriately removes the margin area R12 of each cell in the print data D1 while maintaining the size of the display objects (e.g., characters, figures, etc.) included in the print data D1, i.e., so that the length or ratio of the vertical and horizontal lengths of each cell in the print data D1 does not change as a result. This allows the print output adjustment system 100 to convert the print data D1 into PDF data D2 (data with no margins) of a specified paper size without deforming the display objects displayed in the print data D1. Below, the correction unit 160 that removes the margin area R12 will be described.

[0041] The correction unit 160 corrects the print display area R11 based on the correction object B10 so that the print display area R11 coincides with the print area R10 in the PDF data D2. In other words, the correction unit 160 enlarges the print display area R11 so as to remove the margin area R12 of the print display area R11.

[0042] The process of removing the margin area R12 using the PDF-converted correction object B10 will be described in detail with reference to Fig. 8 and Fig. 9. Fig. 8 is a diagram showing an example of specifying the print display area R11 based on the PDF-converted correction object B10. Fig. 9 is a diagram showing an example of enlarging the print display area R11 to remove the margin area R12.

[0043] 8 and 9, for convenience, the print display area R11 is shown to have a different color from the margin area R12, but the boundary between the print display area R11 and the margin area R12 is the same color as the margin area R12 (for example, pure white). Therefore, it is difficult to identify the boundary. Therefore, the print output adjustment system 100 makes it possible to identify the boundary between the print display area R11 and the margin area R12 by arranging the correction object B10, which is recognized as graphic information in the PDF data, within the range of the print data D1.

[0044] First, as shown in FIG. 8, the correction unit 160 specifies the coordinates of the correction object B10, which is located at least at the diagonal vertices of the print display area R11 and is recognized as a figure after being converted into PDF. The correction object B10 is of the same color as the print display area R11 or is transparent, so that the user cannot see it. The correction unit 160 specifies, as the print display area R11, a closed area formed by the intersection of virtual lines along the X axis (horizontal direction in FIG. 9) and the Y axis (vertical direction in FIG. 9) with the coordinates of each of the specified correction objects B10 as the starting point. The correction unit 160 moves the print display area R11 so that one of the four corners of the specified print display area R11 faces the vertex of the print area R10 opposite the vertex (for example, vertex (1,1) in FIG. 9). This allows the print output adjustment system 10 to execute a process of enlarging the print display area R11, which will be described later, with a simple design.

[0045] 9, the correction unit 160 specifies the size of the margin area R12 in the X-axis direction and the size of the margin area R12 in the Y-axis direction. Based on the size of the margin area R12, the correction unit 160 enlarges the print display area R11 in each of the X-axis direction and the Y-axis direction so that the print display area R11 matches the print area R10. Specifically, for example, when the correction unit 160 specifies that the margin area is 50 mm in the Y-axis direction and 30 mm in the X-axis direction for the print area R10, which is an A4 paper size (297 mm in the Y-axis direction × 210 mm in the X-axis direction), the correction unit 160 enlarges the print display area R11 by approximately 1.20 times (297 / (297-50)) in the Y-axis direction and approximately 1.17 times (210 / (210-30)) in the X-axis direction.

[0046] In this way, the print output adjustment system 100 can appropriately specify the print display area R11 converted to PDF by using the correction object B10 for print data adjusted so that the vertical and horizontal ratios of multiple cells are equal, and can appropriately enlarge the print display area R11 so as to remove the margin area R12 without distortion. In other words, the print output adjustment system 10 can execute print output without distortion and without margins. Furthermore, the print output adjustment system 100 can eliminate the need for an operator to perform adjustment work associated with, for example, upgrading the function of the PDF conversion unit 150, by the correction process of the PDF data D2 by the correction unit 160.

[0047] Here, in the above, it has been described that the correction object B10 is placed at the diagonal vertices of the print data D1, but with reference to Fig. 10, a case where the correction object B10 is placed at two arbitrary positions within the range of the print data D1 will be described. Fig. 10 is a diagram showing a situation where the correction object B10 is placed at two arbitrary positions in the print data D1. In Fig. 10, the correction object B10 is placed in the print data D1 at a distance of 10 mm from each of the diagonal vertices of the print data D1.

[0048] In this case, the correction unit 160 specifies the PDF-converted correction object B10 that is located at a position 10 mm away from the diagonal vertices of the print display area R11 in the Y-axis direction and 10 mm away from the diagonal vertices in the X-axis direction. For example, the correction unit 160 may specify the position of the correction object B10 by referring to the print information D111. The correction unit 160 specifies the virtual rectangular area R20 shown by the dashed line in FIG. 10 based on the specified position of the correction object B10. For example, based on the positional relationship between the correction object B10 and the print display area R11, the correction unit 160 specifies that the print display area R11 is located at a distance of 10 mm away from each side of the virtual rectangular area R20 in the +Y-axis direction, 10 mm away from each side of the virtual rectangular area R20 in the -Y-axis direction, 10 mm away from each side of the virtual rectangular area R20 in the +X-axis direction, and 10 mm away from each side of the virtual rectangular area R20 in the -X-axis direction, based on the positional relationship between the correction object B10 and the print display area R11. As described above, the correction unit 160 specifies the size of the margin area R12 based on the print display area R11 and enlarges the print display area R11.

[0049] The display processing unit 170 displays the print data D1 generated by the spreadsheet software and the PDF data D2 converted from the print data D1 on the display unit. The display processing unit 170 may also display information indicating the version information of the format in which the print data D1 is reflected and the amount of correction, together with the print data D1, by referring to the format information D112. Specifically, the display processing unit 170 may display such information in a cell in the upper left corner of the paper surface of the print data D1 shown in FIG. 4, or may not be included in the print data D1, but may be included as the file name of the print data D1, or may be specified using a correspondence table between the print data D1 and such information prepared outside the print output adjustment system 100. This allows the print output adjustment system 100 to present the format version and the amount of correction to the user, thereby improving the user's convenience.

[0050] <<Processing Procedure>> The process procedure of the print output adjustment system 100 will be described with reference to Fig. 11. Fig. 11 is a flowchart showing an example of the process procedure of the print output adjustment system 100.

[0051] In step S100, the print output adjustment system 100 acquires print data D1 of a specific paper size that has been generated using spreadsheet software.

[0052] In step S101, the print output adjustment system 100 sets the length or ratio of each of the multiple cells in the print data D1 to be uniform (see FIG. 4). Note that the print output adjustment system 100 may generate print data D1 with the length or ratio of each of the multiple cells set to be uniform by referencing the format information D112 and reflecting the print data D1 in the set format.

[0053] In step S102, the print output adjustment system 10 places a correction object B10 in the print data D1 (see FIG. 5).

[0054] In step S103, the print output adjustment system 100 converts the print data D1 into PDF data D2 (see FIG. 7).

[0055] In step S104, the print output adjustment system 100 identifies a correction object B10 (for example, coordinates) in the print area R10 of the PDF data D2 (see FIG. 8).

[0056] In step S105, the print output adjustment system 100 specifies the print display area R11 based on the position of the correction object B10.

[0057] In step S106, the print output adjustment system 100 moves the print display area R11 so that, for example, one vertex of the print display area R11 overlaps with one vertex of the print area R10 that faces the one vertex.

[0058] In step S107, the print output adjustment system 100 expands the print display area R11 in the X-axis direction and the Y-axis direction so as to eliminate the margin area R12 (see FIG. 9).

[0059] In step S108, the print output adjustment system 100 prints out the PDF data D2 on a printing device.

[0060] ===Hardware Configuration=== An example of a hardware configuration for implementing the print output adjustment system 100 on a computer will be described with reference to Fig. 12. Fig. 12 is a diagram showing an example of a hardware configuration of a computer.

[0061] As shown in FIG. 12, a computer 1000 includes a processor 1001, a memory 1002, a storage device 1003, an input I / F unit 1004, a data I / F unit 1005, a communication I / F unit 1006, and a display unit 1007.

[0062] The processor 1001 is a control unit that controls various processes in the computer 1000 by executing programs stored in the memory 1002 .

[0063] The memory 1002 is a storage medium such as a RAM (Random Access Memory), etc. The memory 1002 temporarily stores the program code of the program executed by the processor 1001 and data required when the program is executed.

[0064] The storage device 1003 is a non-volatile storage medium such as a hard disk drive (HDD), a flash memory, etc. The storage device 1003 stores an operating system and various programs for implementing the above-mentioned components.

[0065] The input I / F unit 1004 is a device for receiving input from a user. Specific examples of the input I / F unit 1004 include a keyboard, a mouse, a touch panel, various sensors, a wearable device, etc. The input I / F unit 1004 may be connected to the computer 1000 via an interface such as a USB (Universal Serial Bus).

[0066] The data I / F unit 1005 is a device for inputting data from outside the computer 1000. A specific example of the data I / F unit 1005 is a drive device for reading data stored in various storage media. The data I / F unit 1005 may be provided outside the computer 1000. In that case, the data I / F unit 1005 is connected to the computer 1000 via an interface such as a USB.

[0067] The communication I / F unit 1006 is a device for performing data communication via the Internet N, either wired or wirelessly, with an external device of the computer 1000. The communication I / F unit 1006 may be provided outside the computer 1000. In that case, the communication I / F unit 1006 is connected to the computer 1000 via an interface such as a USB.

[0068] The display unit 1007 is a device for displaying various types of information. Specific examples of the display unit 1007 include a liquid crystal display, an organic EL (Electro-Luminescence) display, a display of a wearable device, and the like. The display unit 1007 may be provided outside the computer 1000. In that case, the display unit 1007 is connected to the computer 1000 via, for example, a display cable. In addition, when a touch panel is adopted as the input I / F unit 1004, the display unit 1007 can be configured integrally with the input I / F unit 1004.

[0069] ===Summary=== <1> The print output adjustment system 100 in this embodiment includes an object arrangement unit that arranges correction objects capable of identifying a positional relationship with the periphery of the print data in at least two locations within the range of the print data, which is print data for printing created by spreadsheet software that displays a plurality of cells arranged in a grid pattern, and a correction unit that corrects the print display area by enlarging it so that the margin area is eliminated, based on the correction object included in the print display area, for the converted data that is a file format that indicates the state when printed on paper of the specified paper size, including a print display area in which the print data is displayed and a margin area around the print display area. As a result, the print output adjustment system 100 can remove margins that occur when spreadsheet data generated by the spreadsheet software is converted into PDF data without distorting the PDF data, and generate PDF data of the specified paper size without margins.

[0070] <2> Furthermore, the object placement unit in the print output adjustment system 100 in this embodiment places the correction object in the same color as the color of the position in the print data where the correction object is placed, or in a transparent state. This allows the print output adjustment system 100 to appropriately remove blank spaces and print the paper surface so that the placed correction object B10 is not visible.

[0071] <3> In addition, the object placement unit in the print output adjustment system 100 in this embodiment places the correction object so as to include at least two diagonal vertices in the print data. This allows the print output adjustment system 100 to automatically set the correction object B10 at the two diagonal vertices for a given print data D1, thereby shortening the time required to execute the print process.

[0072] <4> The print output adjustment system 100 in this embodiment further includes a setting unit that sets the print data so that the length or ratio of the vertical and horizontal lengths of the multiple cells constituting the print data is equal, and the correction unit corrects the converted data obtained by converting the print data set by the setting unit by enlarging the print display area based on the correction object included in the print display area so that the margin area is eliminated. This makes it possible for the print output adjustment system 100 to print out a predetermined paper size without distortion and with margins removed in a simple manner without adjusting each cell.

[0073] <5> The print output adjustment system 100 in this embodiment further includes a setting unit that sets the length and width or ratio of the cells in the format that reflects the print data based on format information that associates each format that reflects the print data with each setting condition related to the length and width or ratio of the cells in the spreadsheet software, and the correction unit corrects the converted data obtained by converting the print data reflected in the format in which the length and width or ratio of the cells is set, by enlarging the print display area based on the correction object included in the print display area so that the margin area is eliminated. As a result, the print output adjustment system 100 can shorten the processing time until printing is executed by using a post-setting format that is set in advance so that the cells are uniform.

[0074] <6> In addition, the print output adjustment system 100 in this embodiment further includes a display processing unit that associates the print data reflected in the format in which the aspect ratio is set based on the format information with the setting conditions related to the print data and displays them on a display unit. This allows the print output adjustment system 100 to present the format version and its correction amount to the user, thereby improving user convenience.

[0075] It should be noted that the present embodiment is an example for explaining the present invention, and is not intended to limit the present invention to only this embodiment. The present invention can be modified in various ways without departing from the gist of the present invention. The components of the print output adjustment system 100 described in the above embodiment are realized in cooperation with other hardware by the processor 1001 executing a program stored in the storage device 1003. [Explanation of symbols]

[0076] 100: print output adjustment system, 110: memory unit, 120: acquisition unit, 130: setting unit, 140: object placement unit, 150: PDF conversion unit, 160: correction unit, 170: display processing unit.

Claims

1. an acquisition unit that acquires spreadsheet data created by spreadsheet software that displays a plurality of cells arranged in a grid; an object placement unit that places correction objects capable of specifying a positional relationship with a periphery of a print target range in at least two locations within the print target range, the correction objects being in a range that indicates a ratio of length to width of a predetermined paper size displayed on a display unit based on the spreadsheet data; a correction unit that corrects converted data obtained by converting the spreadsheet data in which the correction object is arranged in the print target range, The conversion data is a display screen including a print display area for displaying information within the print range and a margin area around the print display area, the display screen showing a display state when the information within the print range is printed on paper of the predetermined paper size by a printing device; PDF data that can be displayed on the display unit, a correction unit that corrects the conversion data so that the print display area is enlarged within the display screen based on information about the correction object included in the print display area, and the margin area is eliminated; An information processing system comprising:

2. the object placement unit places the correction object in a color that is the same as a color at a position within the printing range where the correction object is to be placed, or the correction object is transparent; The information processing system according to claim 1 .

3. the object placement unit places the correction object in the printing range so as to include at least two diagonal vertices. The information processing system according to claim 1 .

4. a setting unit that sets the length and width or ratio of the cells in the range to be printed, which is displayed on the display unit, to a predetermined condition based on the spreadsheet data; the correction unit corrects the converted data obtained by converting the spreadsheet data set by the setting unit by enlarging the print display area on the display screen based on information about the correction object included in the print display area, so that the margin area is eliminated. The information processing system according to claim 1 .

5. The computer Acquiring spreadsheet data created by spreadsheet software that displays a plurality of cells arranged in a grid pattern; arranging correction objects capable of specifying a positional relationship with a periphery of a print target range in at least two locations within the print target range, the correction objects being in a range that indicates a ratio of length to width of a predetermined paper size displayed on a display unit based on the spreadsheet data; correcting converted data obtained by converting the spreadsheet data in which the correction object is arranged in the print target range, The conversion data is a display screen including a print display area for displaying information within the print range and a margin area around the print display area, the display screen showing a display state when the information within the print range is printed on paper of the predetermined paper size by a printing device; PDF data to be displayed on the display unit, enlarging the print display area within the display screen based on information about the correction object included in the print display area, and correcting the conversion data so that the margin area is eliminated; An information processing method for performing the above.

6. On the computer, Acquiring spreadsheet data created by spreadsheet software that displays a plurality of cells arranged in a grid pattern; arranging correction objects capable of specifying a positional relationship with a periphery of a print target range in at least two locations within the print target range, the correction objects being in a range that indicates a ratio of length to width of a predetermined paper size displayed on a display unit based on the spreadsheet data; correcting converted data obtained by converting the spreadsheet data in which the correction object is arranged in the print target range, The conversion data is a display screen including a print display area for displaying information within the print range and a margin area around the print display area, the display screen showing a display state when the information within the print range is printed on paper of the predetermined paper size by a printing device; PDF data to be displayed on the display unit, enlarging the print display area within the display screen based on information about the correction object included in the print display area, and correcting the conversion data so that the margin area is eliminated; A program for executing the above.

Citation Information

Patent Citations

  • Image reading device and printing system

    JP2007143109A

  • Information processing apparatus, information processing method and program

    JP2015170115A

  • Electronic apparatus, order entry system, and program

    JP2016095560A

  • Image processing apparatus and program

    JP2019217676A