JP2013016049A - Image processing system, image forming device and program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide an image processing system, an image forming device and a program which allow easy correction of image deviation generated in a text display part in spreadsheet software.SOLUTION: The imaging forming device has image analysis means for creating intermediate language data on the basis of input image data. The image analysis means includes: character drawing area extraction means for detecting information on a character drawing area included in the input image data and acquiring a setting range of the character drawing area; character string image formation area calculation means for calculating an image formation range of a character string in printing on the basis of character information of the character string written in the character drawing area; and character drawing area adjustment means for performing adjustment processing to at least one of the image formation range and the character drawing area so that the image formation range can fall within the character drawing area when the image formation range calculated by the character string image formation area calculation means does not fall within the character drawing area extracted by the character drawing area extraction means.

Description

  The present invention relates to an image processing apparatus, an image forming apparatus, and a program.

  2. Description of the Related Art Conventionally, there are various types of spreadsheet software that use a spreadsheet function using cells, create a table list, or use as a database. This spreadsheet software is also used for creating handouts by arbitrarily pasting drawings and texts.

  In recent years, work to standardize the output format of office software such as spreadsheet software has been promoted. OOXML (Office Open XML), which is used as an output file format in Excel (MICROSOFT EXCEL: registered trademark), which is one of spreadsheet software, is one of the standardized file formats. Standardization of the output file format facilitates the development of new data-compatible software.

  In this spreadsheet software, when text written using a text box is printed, the font size and character layout for display display and the font size and character layout for printing differ slightly. The display may differ from the display on the display.

  Therefore, conventionally, an image processing apparatus having a preview display function capable of acquiring character logical information included in print data and displaying characters of a font size matching the print font size on the display has been developed. (Cited document 1).

Japanese Laid-Open Patent Publication No. 2007-193701

  However, if the type of font used for display and the type of font used for printing are different during printing, the font used for display is replaced with the font used for printing even if the font size is matched. As a result, the display of the text may protrude from the text box, or an unnecessary line break may be inserted into the text, resulting in the formation of a printed image with a corrupted text display. In such a case, conventionally, it has been necessary to make adjustments while checking print data by changing the font size, text box size, and the like on spreadsheet software, and there has been a problem that convenience is reduced.

  An object of the present invention is to provide an image processing apparatus, an image forming apparatus, and an image processing apparatus capable of easily correcting a shift of a print image generated in a text display portion when printing a data file described in an output file format of a spreadsheet software. To provide a program.

In order to achieve the above object, the present invention described in claim 1
In an image processing apparatus comprising image analysis means for creating intermediate language data for generating drawing data based on input image data,
The image analysis means includes
Character drawing area extraction means for detecting information of a character drawing area included in the input image data and obtaining a setting range of the character drawing area;
A character string image forming area calculating means for calculating an image forming range of the character string in the generated intermediate language data based on character information about the character string described in the character drawing area;
The character drawing area extracted by the character drawing area extracting unit is compared with the image forming range calculated by the character string image forming area calculating unit, and the image forming range is within the character drawing area. A character drawing area adjusting unit that performs at least one of the image forming range and the character drawing area so that the image forming range fits in the character drawing area,
An image processing apparatus comprising:

The invention according to claim 2 is the image processing apparatus according to claim 1,
The image analysis means includes
An area arrangement adjusting means for correcting the relative position of the character drawing areas is further provided so that the plurality of character drawing areas do not overlap each other.

The invention according to claim 3 is the image processing apparatus according to claim 1 or 2,
The character drawing area adjustment means includes:
The character drawing area is enlarged so that the character drawing area includes the image forming range calculated by the character string image forming area calculating means.

The invention according to claim 4 is the image processing apparatus according to claim 3,
The enlargement of the character drawing area is characterized in that the enlargement in the horizontal direction and the enlargement in the vertical direction can be performed independently.

The invention according to claim 5 is the image processing apparatus according to claim 3 or 4,
The character drawing area adjustment means includes:
By correcting the relative position by the area arrangement adjusting means, the plurality of character drawing areas are enlarged within a range where the plurality of character drawing areas do not overlap,
If the image forming range does not fit within the enlarged character drawing area, the character information about the character string related to the character drawing area is further changed to shorten the line spacing of the character string. In addition, and / or by reducing the font size of the character string, the image forming range is reduced so as to be within the character drawing area.

The invention according to claim 6 is the image processing apparatus according to any one of claims 1 to 5,
Whether or not the character drawing area adjusting means can be executed is selectable based on setting data acquired in advance relating to the necessity of adjustment by the character drawing area adjusting means.

The invention according to claim 7 is the image processing apparatus according to any one of claims 1 to 6,
It is characterized by comprising bitmap generation means for rasterizing the generated intermediate language data to create drawing bitmap data.

The invention according to claim 8 provides:
An image processing apparatus according to claim 7;
Image forming means for acquiring bitmap data created by the image processing apparatus and forming an image on a sheet; and
An image forming apparatus.

The invention according to claim 9 is:
A computer used as an image processing device
A program that functions as image analysis means for creating intermediate language data for generating drawing data based on input image data,
The image analysis means includes
Character drawing area extraction means for detecting information of a character drawing area included in the input image data and acquiring a setting range of the character drawing area;
A character string image forming area calculating means for calculating an image forming range of the character string in the generated intermediate language data based on character information about the character string described in the character drawing area;
The character drawing area extracted by the character drawing area extracting unit is compared with the image forming range calculated by the character string image forming area calculating unit, and the image forming range is within the character drawing area. A character drawing area adjusting unit that performs adjustment processing of at least one of the image forming range and the character drawing area so that the image forming range is entirely included in the character drawing area if not fit
It is a program characterized by comprising.

  According to the present invention, in an image processing apparatus, an image forming apparatus, and a program, when a data file described in an output file format of a spreadsheet software is printed, it is possible to easily correct a print image shift that occurs in a text display portion. Has the effect of becoming possible.

1 is a configuration diagram of a network system including an image forming apparatus according to an embodiment of the present invention. It is a block diagram which shows the structure of a computer. 2 is a block diagram illustrating an internal configuration of the image forming apparatus. FIG. It is the figure which showed the file structure in the Excel file of an OOXML format. It is the figure which showed a part of the contents of drawing1.xml file. It is the figure which showed a part of the contents of drawing1.xml file. It is the figure which showed a part of contents of drawing1.xml file and styles.xml file. It is a flowchart which shows the control procedure of the creation process of the image formation data which a control part performs. It is a figure which shows the example of adjustment of a text box position.

Hereinafter, embodiments of the present invention will be described with reference to the drawings.
FIG. 1 is a configuration diagram of an image processing apparatus and a network system including an image forming apparatus according to an embodiment of the present invention.

In this network system, image forming apparatuses 1, 1, 1 are communicably connected to computers 2, 2 via a line 3.
The line 3 constitutes a network of image forming apparatuses 1, 1, 1 and computers 2, 2. The line 3 may be in any form as long as it connects the computers 2 and 2 and the image forming apparatuses 1, 1, and 1 so as to communicate with each other. For example, the line 3 may be a wired connection line such as a LAN (Local Area Network) cable, a coaxial cable, or an optical fiber, or may be a line using various wireless communication standards such as Bluetooth (registered trademark) or wireless LAN. A plurality of combinations may be used. Further, the line 3 may be a LAN, the Internet, or any other network scale.

FIG. 2 is a block diagram illustrating a configuration of the computer 2.
Specific examples of the computer 2 include a PC (Personal Computer), a PDA (Portable Device Assistant), a mobile phone, and a smartphone.

  The computer 2 includes a control unit 11, a RAM (Random Access Memory) 12, a ROM (Read Only Memory) 13, a storage unit 14, an input I / F (interface) 15, an output I / F 16, and a communication unit. 17. An operation unit 18 is connected to the input I / F 15, and a display unit 19 is connected to the output I / F.

  The control unit 11 includes a CPU. The control unit 11 develops various programs and data stored in the ROM 13 and the storage unit 14 in the RAM 12, performs various arithmetic processes, and controls the overall operation of the computer 2 based on the programs.

  The RAM 12 is a volatile memory that temporarily develops various programs and data executed by the control unit 11 and provides a working memory space for storing temporary data processed by the various programs. The ROM 13 stores a control program such as BIOS (Basic Input / Output System) executed by the control unit 11 and initial setting data in a readable manner. The ROM 13 may be a flash memory or an EEPROM (Electrically Erasable and Programmable Read Only Memory).

The storage unit 14 stores various software (programs) and application data so that they can be read, written, and used. The storage unit 14 is a hard disk in the present embodiment, but is not limited thereto. The storage unit 14 may be, for example, an SSD (Solid State Disk). The software stored in the storage unit 14 includes a print data transmission program 14 a and a print data conversion program 14 b corresponding to the image forming apparatus 1.
The print data transmission program 14a transmits a spreadsheet software output data file (for example, an output file by Excel, hereinafter referred to as an Excel file) and print setting data specified as a print target to the image forming apparatus 1. It is. For example, various settings made by the user on the computer 2 side via the GUI screen, for example, settings related to page allocation, margins, duplex printing, and on / off of automatic adjustment of a text box, which will be described later, are included in the image forming apparatus 1. Sent to. The print data conversion program 14b performs various processes for forming an image of the contents of the Excel file in the OOXML format based on the print settings, and creates data in a predetermined intermediate language data format for printing (DL: display list). A program having a printer driver function for transmitting to the image forming apparatus 1. In addition, for example, spreadsheet software is stored in the storage unit 14, and the created data can be saved as an Excel file in the OOXML format.
Note that the print data transmission program 14a and the print data conversion program 14b can be appropriately used according to the amount of image data and as required. Alternatively, only one of the programs may be provided. The print data conversion program 14 b may be a program that once converts the OOXML file into PDL (page description language) data corresponding to the image forming apparatus 1 and sends the data to the image forming apparatus 1.

The input I / F 15 is an interface that connects the control unit 11 and an external device, and controls an input signal from the external device. Here, the control unit 11 and the operation unit 18 as an external device are connected by an input I / F 15. The operation unit 18 is, for example, a keyboard or a mouse.
The output I / F 16 is an interface that connects the control unit 11 and an external device. The output I / F 16 controls and converts an output signal from the control unit 11 and outputs the signal to the outside. Here, the control unit 11 and the display unit 19 as an external device are connected by the output I / F 16. The display unit 19 is a display composed of, for example, an LCD (Liquid Crystal Display) or an organic ELD (Electro-Luminescent Display).
Alternatively, the input I / F 15 and the output I / F 16 may be connected to a device that performs both an input operation and a display operation, such as a touch panel. The operation unit 18 and the display unit 19 may be externally connected via a cable or the like, or may be integrally provided on the outer surface of the computer 2.

  The communication unit 17 performs communication control for connecting the computer 2 to another device connected to the line 3 and an external network via the line 3, and is, for example, a NIC (Network Interface Card). .

FIG. 3 is a block diagram showing an internal configuration of the image forming apparatus 1.
The image forming apparatus 1 includes an information processing unit 20 as an image processing apparatus, a printer engine 30 as an image forming unit, and the like.
The information processing unit 20 includes a control unit 21 (image analysis unit, character drawing region extraction unit, character string image formation region calculation unit, character drawing region adjustment unit, region arrangement adjustment unit), RAM 22, ROM 23, and storage unit. 24, an input I / F 25, an output I / F 26, a communication unit 27, and the like.

The control unit 21 includes a CPU. The control unit 21 develops various programs and data stored in the ROM 23 and the storage unit 24 in the RAM 22 to perform various arithmetic processes, and performs overall control of the entire operation of the image forming apparatus 1 based on the programs. .
The control unit 21 may include a CPU that performs arithmetic processing related to image processing and a CPU that performs control processing of the entire image forming apparatus 1.

  The RAM 22 is a volatile memory that temporarily expands various programs and data executed by the control unit 21 and provides a working memory space for storing temporary data processed by the various programs. The ROM 23 stores a control processing program executed by the control unit 21 and setting data to be used in a readable manner.

  The storage unit 24 stores various software, application data, and print setting information sent from the computer 2 and an Excel file to be printed, which can be read, written, and used. The storage unit 24 is a hard disk in the present embodiment, but is not limited thereto. The storage unit 24 may be, for example, an SSD (Solid State Disk).

The software stored in the storage unit 24 includes a print control program 24 a and a conversion table 24 b corresponding to print data analysis in the image forming apparatus 1. The print control program 24a is a program that performs various processes for converting the contents of an Excel file in the OOXML format into DL that is inter-print language data. Further, the conversion table 24b indicates the correspondence relationship between the font size used for display display and the font size used for printing in the image forming apparatus 1 when calculating the vertical and horizontal widths of the text to be printed. It is a conversion table. The storage unit 24 further converts a conversion data into PDL (page description language) acquired from the outside by the communication unit 27 and converts it into DL data, or converts the DL data into raster image data for printing. Then, a print data output control program to be output to the printer engine 30 is included.
Note that the image forming apparatus 1 may have a configuration in which these software and programs are stored in the ROM 23 in advance and the storage unit 24 is not provided. Further, the print setting information and the Excel file may be stored in the RAM 22 without being stored in the storage unit 24 and processed.

The input I / F 25 is an interface that connects the control unit 21 and an external device, and is an interface that controls an input signal from the external device. Here, the control unit 21 and the operation unit 28 are connected by an input I / F.
The output I / F 26 is an interface that connects the control unit 21 and an external device, and controls and converts an output signal from the control unit 21 and outputs the signal to the external device. Here, the control unit 21 and the display unit 29 are connected by the output I / F 26. The operation unit 28 and the display unit 29 are, for example, touch panels using an LCD. Alternatively, for example, the operation unit 28 may include an operation key, a keyboard, and a mouse, and the display unit 29 may include a display made of an LCD or an organic ELD, for example. Further, the operation unit 28 and the display unit 29 may be included in the image forming apparatus 1. The operation unit 28 receives an operation from the user, generates an input signal, and outputs the generated input signal to the control unit 21. The display unit 29 displays various setting screens, operation statuses, processing results, and the like according to display signals output from the control unit 21.

  The communication unit 27 performs communication control for connecting the image forming apparatus 1 and an external network via the line 3 and is, for example, a NIC (Network Interface Card).

  The printer engine 30 performs image formation (printing) processing based on the raster image data for printing sent from the information processing unit 20. The printing method that can be employed in the printer engine 30 is not particularly limited, and examples thereof include an electrophotographic method, an inkjet method, a thermal transfer method, and an offset.

Next, display adjustment of a text portion executed when printing an OOXML format Excel file will be described.
FIG. 4 is a diagram showing the configuration of files included in an Excel file in the OOXML format.

  An Excel file in the OOXML format (extension is .xlsx) is an archive file in which at least a plurality of XML files (extension is .xml) and related files (extension is .rels) are compressed and stored in the ZIP format. For example, one Excel file (here, sample.xlsx) is composed of [Content_Types] .xml and files included in both the _rels and xl folders.

A file workbook.xml in the folder xl is a file indicating a configuration of the entire workbook in the Excel file, and styles.xml is a style file having default font information and the like in the entire workbook.
Also, the file worksheetY.xml is stored in the folder worksheets. Here, Y is an integer and indicates a sheet number. That is, the file sheet1.xml is a file indicating the contents of the worksheet 1, and the contents described in each cell of the worksheet 1 are stored.

  The folder drawings stores a file drawingY.xml (Y is an integer, indicating a sheet number). The file drawing1.xml stores data related to the figure and text box inserted into the worksheet 1.

  5 to 7 are diagrams each showing an example of the contents recorded in the drawing1.xml file.

  In the file drawing1.xml, as shown in FIG. 5 and FIG. 6, the description starts with the description part related to the shape class “xdr: sp”, that is, the start tag “<xdr: sp>” (FIG. 5 (a1)). Data related to one figure or text box is described within the range to be ended by the end tag “</ xdr: sp>” (FIG. 6 (b 6)). First, for the text box, in the description by the shape property “<xdr: spPr>”, the class “a: off” indicating the offset value to the start point position and the class “a: ext” indicating the length from the start point The area where the figure or the text box is inserted is specified using (2). Further, in the example of FIG. 5, the setting “rect” that the shape is a square is made using the preset geometry class “a: prstGeom” (a3).

  Subsequently, as shown in FIG. 6, in the description part related to the shape class, the text and the information related to the text described in the text box are displayed using the text body class “<xdr: txBody>”. Has been. In addition, the attribute “anchor” of the body property tag “<a: bodyPr>” indicates that the text in the text box is top-aligned “t” (b1).

Within this text body class, the text of one paragraph and the information about the text are described between the paragraph start tag “<a: p>” and the paragraph end tag “</ a: p>”. . In the description part by this paragraph tag, the font information (b2, b4) is described between the run property start tag “<a: rPr>” and the run property end tag “</ a: rPr>”. The text input using the text box in the spreadsheet software is described between the text start tag “<a: t>” and the text end tag “</ a: t>” (b3, b5). ). In the example of FIG. 6, MS Mincho font is set for Japanese text (b3) (b2), and Arial font is set for English text (b5) (b4).
Note that there may be a case where a single paragraph of text is divided into a plurality of text tags in the file due to space arrangement or font switching. When a proportional font is selected, character spacing such as kerning may be adjusted. Further, there may be a portion where only a space is recorded as text data (b7). Such text for one paragraph is acquired together, and the character width of the text character string is calculated for each line.

  FIG. 7 shows a display example described in the other part of the file drawing1.xml and a part of the description example of the file styles.xml.

  In the description part of the file drawing1.xml shown in Fig. 7 (a), there are six parts surrounded by paragraph tags "<a: p>" and "</ a: p>" in the text body class. In five of them, there are text descriptions c1 to c5 using text tags “<a: t>” and “</ a: t>”. Here, no font is set for these text descriptions c1 to c5. In such a case, the default font described in the file styles.xml is used. As shown in FIG. 7B, a size 11 MSP Gothic font is specified as the default font setting in the file styles.xml. Therefore, the texts c1 to c5 are displayed and printed by MSP Gothic of size 11.

Next, a processing operation for generating print data in the image forming apparatus will be described.
FIG. 8 is a flowchart illustrating a control procedure of print data generation processing executed by the control unit 21 of the image forming apparatus 1.

  This print data generation process is started by receiving a file in OOXML format and print setting data sent from the computer 2 as print data.

  When the print data generation process is started, the control unit 21 including the CPU first obtains the user print settings sent from the computer 2 (step S1). The print settings include general print settings such as page allocation, margins, double-sided printing, and settings related to whether or not to automatically adjust a text box to be printed in the print data generation process. The image forming apparatus 1 can perform print settings separately based on an input operation to the operation unit 28, and the print settings may be used in preference to the print setting data sent from the computer 2.

  Subsequently, the control unit 21 decompresses and expands the received OOXML file to obtain each file necessary for analysis (step S2). Of the acquired files, drawingY.xml and styles.xml are files related to automatic adjustment of the text box. Next, the control unit 21 sets print data necessary for printing the OOXML file in the image forming apparatus 1 (step S3).

  Next, the control unit 21 selects each print element in the print target file in order and performs analysis for creating DL data (step S4). Then, the control unit 21 determines whether or not the automatic adjustment function is set to ON (step S5). If it is determined that the automatic adjustment function is not on, the process of the control unit 21 proceeds to step S12 and generates DL data as usual based on the selected printing element.

  On the other hand, if it is determined that the automatic adjustment function is set to ON, then the control unit 21 determines whether or not the selected print element to be analyzed is a text box (step S6). . If it is determined that the analysis target is not a text box, the processing by the control unit 21 proceeds to step S12, and generates DL data for printing as usual based on the selected printing element.

  When it is determined that the selected print element to be analyzed is a text box, the control unit 21 first acquires the size of the text box in the analysis of the text box (step S7).

  Next, the control unit 21 analyzes the description of the text box for each line, and calculates the width in the vertical and horizontal directions of each line during printing (step S8). Specifically, the control unit 21 first extracts font information based on the contents described between the paragraph start tag “<a: p>” and the paragraph end tag “</ a: p>”. Next, text data for one paragraph is acquired. Then, the control unit 21 calculates the obtained text data by converting the vertical and horizontal widths for each line into values at the time of printing. The control unit 21 accesses the conversion table 24b, and if there is a conversion table for the print designated font, the character included in one line of text data or, if necessary, the character string is printed at the time of printing. If there is no conversion table for obtaining the length, an alternative font is designated and calculated. The control unit 21 repeatedly executes the above process every time a paragraph start tag is detected in the text body class.

  The control unit 21 acquires the vertical and horizontal widths of the sentence size displayed in the text box at the time of printing. That is, when the description in the text box is horizontal writing, the control unit 21 acquires the maximum text width value of all the lines calculated in the process of step S8 as the horizontal width of the sentence size, Further, a value obtained by adding the vertical widths of all the lines is acquired as the vertical width of the sentence size (step S9). The control unit 21 determines whether or not the obtained text size at the time of printing is larger than the size of the text box with respect to the vertical width and the horizontal width (step S10). When it is determined that the sentence size is not larger than any of the vertical and horizontal widths of the text box, the process of the control unit 21 proceeds to step S12 and based on the analyzed text and text box. Create DL data as usual. On the other hand, when it is determined that at least one of the vertical and horizontal widths of the sentence size is larger than the vertical or horizontal width of the text box, the control unit 21 adjusts the position and size of the text box according to the sentence size ( Step S11).

  Specifically, as the text box adjustment processing, the control unit 21 first performs processing for enlarging the size of the text box. For example, if the horizontal width is insufficient, the text box is expanded, and if the vertical width is insufficient, the text box is expanded. The process in the width direction and the process in the height direction are performed independently, and it is possible not to expand the text box in the direction where the width is satisfied, but either one is expanded. In this case, the text box may be enlarged to a similar figure of the original shape. When enlarging the text box, for example, the top left vertex position of the text box is fixed and the width and height are changed.

  Then, the process by the control unit 21 proceeds to step S12 and creates DL data based on the adjusted text box size.

  When DL data is created in the process of step S12, the control unit 21 determines whether or not the analysis for all print elements in the worksheet has been completed (step S13). If it is determined that the analysis of all printing elements has not been completed yet, the processing by the control unit 21 returns to step S4. Then, the processes in steps S4 to S12 are repeated for the next print element.

  If it is determined in step S13 that the analysis of all printing elements has been completed, the control unit 21 ends the print data generation process.

  Here, when there are a plurality of text boxes, the processes of steps S7 to S12 are performed a plurality of times. At this time, when the size of the text box is changed and increased by the process of step S11, it may overlap with another text box. Therefore, after all the text boxes have been adjusted and the print data generation process is completed, the text box position is adjusted.

FIG. 9 shows an example of adjusting the text box position.
As a method for adjusting the positions of a plurality of text boxes in the present embodiment, first, translation is selected. As shown in FIG. 9A, when two text boxes are overlapped, the text box is moved in a direction to separate one or both from the overlapping position (FIG. 9B).

  Next, if the two text boxes are moved so that they do not overlap as described above, they may overlap with other third text boxes, or multiple text boxes may need to be moved in a complex manner. (FIG. 9 (c)). In such a case, first, the text box to be moved is moved within a range that does not overlap with the other third text box. Then, the display font and the size of the text box are reduced to the extent that the text box does not fit in the gap of the other text box to the extent that it fits in the gap of the text box (FIG. 9D).

  Further, as shown in FIG. 9E, the text box may be enlarged as a result of being enlarged. In such a case, the text box can be accommodated in the print surface by moving in the direction opposite to the direction protruding from the paper surface.

  As described above, according to the image forming apparatus 1 of the present embodiment, when an Excel file in the OOXML format is input, the text box is detected when the Excel file is analyzed to generate a display list. In addition, the text display size is obtained by calculating the vertical and horizontal widths of the text described in the text box when the text is printed based on the font size at the time of printing. Then, compare the size of the text box and the display size of the text, and if the display size of the text is larger in at least one of the vertical width and the horizontal width, all the text will fit within the text box size Create DL data after adjusting the size of the text box. By having such a text box size automatic adjustment function, it is possible to easily prevent a text image from being corrupted during printing due to a deviation in font size during printing.

  In addition, when adjusting the size of the text box, it is configured not only to enlarge the text box in a similar manner but also to enlarge only the shortage of the vertical width and / or horizontal width, The text box size can be automatically adjusted without expanding the text box to an unnecessary part.

  When a plurality of text boxes are detected, after automatic adjustment of all the text boxes is completed, it is confirmed whether these text boxes have been expanded and thus do not overlap. And when there exists an overlap part, each display position is moved. Therefore, it is possible not only to destroy the print image of each text box, but also to perform printing without overlapping portions of the text box.

  In addition, when there are duplicate parts in multiple text boxes, if the duplicate part cannot be resolved even if the display position of the text box is moved, the font set for the text in the duplicate text box By reducing the size of, duplicates are eliminated. Therefore, while maintaining the specified font size as much as possible, the font size is reduced only when necessary, so that the appearance of the text printed part does not change significantly and the display is not corrupted. I can do it.

  If automatic adjustment of the text box is not desired, it can be set not to perform automatic adjustment.

  In addition, the image processing unit can convert the DL data created by automatic adjustment as described above into raster image data, and further output it to the printer engine to perform image formation. There is no need to manually resize the text box while checking.

The present invention is not limited to the above-described embodiment, and various modifications can be made.
For example, the spreadsheet data output data file in the OOXML format is not limited to one created by Excel, but may be one created by other spreadsheet software. Also, software other than spreadsheet software, such as presentation software used when creating slides and giving presentations with the slides, and converted to the output data file format of spreadsheet software may be used. good. Spreadsheet files in the ODF format (Open Document Format) are not compatible with the OOXML format. Similarly, a plurality of XML files are archived in the ZIP format, and the font size is detected by detecting the text box part. It is possible to calculate the text display size based on this conversion process and automatically adjust the text box size.

  In the above embodiment, only the overlap between the text boxes is considered, but the display position is adjusted by determining the overlap with other embedded images and the overlap with the contents described in each cell. It is good.

  In the above embodiment, the print setting data is set based on the setting information sent from the computer 2, but can be set based on an operation command to the operation unit 28 of the image forming apparatus 1.

  In the above embodiment, a rectangular text box has been described as an example. However, processing can be similarly performed on text boxes having other shapes. In this case, processing is performed in association with character alignment such as top alignment and center alignment of text.

In the above description, an example in which the storage unit 24 such as HDD or SSD is used as a computer-readable medium of the program according to the present invention is disclosed, but the present invention is not limited to this.
As other computer-readable media, a non-volatile memory such as a flash memory and a portable recording medium such as a CD-ROM can be applied.
A carrier wave is also applied to the present invention as a medium for providing program data according to the present invention via a communication line.
In addition, details such as the specific configuration and display shown in the above embodiment can be changed without departing from the spirit of the present invention.

DESCRIPTION OF SYMBOLS 1 Image forming apparatus 2 Computer 3 Line 11 Control part 12 RAM
13 ROM
14 Storage Unit 14a Print Data Transmission Program 14b Print Data Conversion Program 15 Input I / F
16 output I / F
17 Communication unit 18 Operation unit 19 Display unit 20 Information processing unit 21 Control unit 22 RAM
23 ROM
24 Storage Unit 24a Print Control Program 24b Conversion Table 25 Input I / F
26 Output I / F
27 Communication unit 28 Operation unit 29 Display unit 30 Printer engine

Claims (9)

In an image processing apparatus comprising image analysis means for creating intermediate language data for generating drawing data based on input image data,
The image analysis means includes
Character drawing area extraction means for detecting information of a character drawing area included in the input image data and obtaining a setting range of the character drawing area;
A character string image forming area calculating means for calculating an image forming range of the character string in the generated intermediate language data based on character information about the character string described in the character drawing area;
The character drawing area extracted by the character drawing area extracting unit is compared with the image forming range calculated by the character string image forming area calculating unit, and the image forming range is within the character drawing area. A character drawing area adjusting unit that performs at least one of the image forming range and the character drawing area so that the image forming range fits in the character drawing area,
An image processing apparatus comprising: The image analysis means includes
The image processing apparatus according to claim 1, further comprising an area arrangement adjusting unit that corrects a relative position of the character drawing areas so that the plurality of character drawing areas do not overlap each other. The character drawing area adjustment means includes:
The image processing apparatus according to claim 1, wherein the character drawing area is enlarged so that the character drawing area includes the image forming range calculated by the character string image forming area calculating unit. The image processing apparatus according to claim 3, wherein the enlargement of the character drawing area is set so that enlargement in the horizontal direction and enlargement in the vertical direction can be performed independently. The character drawing area adjustment means includes:
By correcting the relative position by the area arrangement adjusting means, the plurality of character drawing areas are enlarged within a range where the plurality of character drawing areas do not overlap,
If the image forming range does not fit within the enlarged character drawing area, the character information about the character string related to the character drawing area is further changed to shorten the line spacing of the character string. And / or reducing the font size of the character string to reduce the image forming range to be within the character drawing area. . 6. The configuration according to claim 1, wherein execution of the character drawing area adjustment unit is selectable based on setting data acquired in advance regarding whether adjustment by the character drawing area adjustment unit is necessary. The image processing apparatus according to any one of the above. The image processing apparatus according to claim 1, further comprising: a bitmap generation unit that rasterizes the generated intermediate language data to create drawing bitmap data. An image processing apparatus according to claim 7;
Image forming means for acquiring bitmap data created by the image processing apparatus and forming an image on a sheet; and
An image forming apparatus comprising: A computer used as an image processing device
A program that functions as image analysis means for creating intermediate language data for generating drawing data based on input image data,
The image analysis means includes
Character drawing area extraction means for detecting information of a character drawing area included in the input image data and acquiring a setting range of the character drawing area;
A character string image forming area calculating means for calculating an image forming range of the character string in the generated intermediate language data based on character information about the character string described in the character drawing area;
The character drawing area extracted by the character drawing area extracting unit is compared with the image forming range calculated by the character string image forming area calculating unit, and the image forming range is within the character drawing area. A character drawing area adjusting unit that performs adjustment processing of at least one of the image forming range and the character drawing area so that the image forming range is entirely included in the character drawing area if not fit
A program comprising:

Images