JP2015125465A - Sheet size setting program and sheet size setting method - Google Patents

Abstract

PROBLEM TO BE SOLVED: To obtain, in setting of a sheet size, a print having a spread sheet document accommodated in a page even when the size of the document is extremely large.SOLUTION: Printing direction is determined according to the lateral length obtained by expanding the width of a reference sheet size by the number of pages in the lateral direction, and the vertical length obtained by expanding the height of the reference sheet size by the number of pages in the vertical direction. Specifically, the lengths in the vertical and lateral directions are compared first. Then, the printing direction is determined to be the "vertical direction" or the "lateral direction" according to whether the lateral length or the vertical length is longer than the other, so that the vertical direction or the lateral direction of a document which has the length shorter than the other is made along the width direction of rolled paper as a recording medium. Accordingly, the reduction rate can be made larger in sheet size processing for eventual printing of a document made fit in with the width of the rolled paper, resultantly enabling an extremely large document to be accommodated in a page with a reduction rate of a spread sheet software.

Description

  The present invention relates to a paper size setting program and a paper size setting method, and more particularly, to a paper size setting for printing a document by a spreadsheet software on one page.

  Spreadsheet software has no page concept. Therefore, when printing a document using spreadsheet software, a paper size corresponding to the page concept is set. In Patent Document 1, the height and width of a range in which a document exists by spreadsheet software is specified by the number of pages of the reference paper size, and the height and width of the reference paper size are respectively expanded to the number of pages. It describes that the paper size is set so that the document can fit on one page. Then, by enlarging and reducing the document on the spreadsheet software with respect to the set paper size, when the document is printed, it fits on the paper without excess or deficiency.

JP 2010-67034 A

  However, even with the technique described in Patent Document 1, when the size of a document by spreadsheet software is extremely large, it may not be possible to print on a predetermined one page of a sheet without excess or deficiency. That is, there is a premise that the paper size that can be used for printing is the paper size handled by the printer driver that controls printing. In addition, there is a limit to the scaling ratio of spreadsheet software. Therefore, depending on the size of the spreadsheet document, there are cases where the paper size that can be handled by the printer driver exceeds the paper size even if it is reduced at the minimum reduction ratio (the reduction ratio that is reduced most) on the spreadsheet software. You may not be able to print to fit on the page.

  SUMMARY OF THE INVENTION An object of the present invention is to provide a paper size setting program and a paper size setting method capable of obtaining a printed matter that fits within one page even for an extremely large spreadsheet document.

  Therefore, according to the present invention, there is provided a paper size setting program for causing a computer to execute processing for setting a paper size in spreadsheet software, and the processing is performed on an area where data created on the spreadsheet software exists. The horizontal length corresponding to the number of pages in the horizontal direction of the area and the vertical length corresponding to the number of pages in the vertical direction of the area obtained based on a predetermined reference paper size, A printing orientation determining step for determining a printing orientation, and the paper size is determined by determining the height and width of the paper size corresponding to the horizontal and vertical directions of the area according to the determined printing orientation. According to the paper size determining step and the determined printing orientation, the height and width of the paper size are enlarged or reduced, and the paper size Characterized in that said data of at least one and a width having a scaling step is to be included in the region exists, the.

  According to the above configuration, it is possible to obtain a printed matter that fits within one page even when the spreadsheet size is extremely large in the setting of the paper size.

1 is a block diagram illustrating an outline of a host computer and an inkjet printer that constitute a printing system according to an embodiment of the present invention. FIG. FIG. 2 is an external perspective view of a printer configuring the recording system illustrated in FIG. 1. It is a figure which shows the structure of the system which has a plug-in which concerns on one Embodiment of this invention. It is a figure which shows a display screen when the spreadsheet software 303 shown in FIG. 3 is started. FIG. 5 is a diagram showing a roll paper width designation dialog displayed on the display when the plug-in activation icon shown in FIG. 4 is pressed. (A) And (b) is a figure explaining the margin deletion function with which a printer driver is provided. (A) And (b) is a figure explaining the no-cut function with which a printer driver is provided. 6 is a flowchart showing an operation by a plug-in program called when a print button is pressed in the roll paper width designation dialog shown in FIG. 5. (A)-(h) is a figure which shows the document which changes with the setting with respect to spreadsheet software and the setting with respect to a printer driver by a plug-in. It is a flowchart which shows the setting process with respect to the spreadsheet software by the plug-in which concerns on one Embodiment of this invention. It is a figure which shows the enlargement / reduction setting dialog with which spreadsheet software is provided. 6 is a flowchart illustrating print setting processing according to an embodiment of the present invention. FIG. 6 is a diagram illustrating a setting dialog provided in the printer driver.

  Hereinafter, embodiments of the present invention will be described in detail with reference to the accompanying drawings. The embodiment of the present invention relates to a plug-in for spreadsheet software. With this plug-in, the paper size is set for the spreadsheet software, and the printer driver is changed based on the set paper size. Set such as double. Here, a plug-in is a program that adds a function to an application. For example, Microsoft Office (Micro Software Inc., USA), Microsoft Internet Explorer (Micro Software Corporation, USA), and the like have released means for extending their functions. Thereby, such an application can add a function by registering a plug-in.

<Configuration of recording system>
FIG. 1 is a block diagram showing an outline of a host computer (hereinafter simply referred to as a host) 1 and an ink jet printer (hereinafter also referred to as a recording apparatus) 2 constituting a printing system according to an embodiment of the present invention. The present invention will be described by taking an ink jet printer as an example of the recording apparatus. However, any printer capable of printing on roll paper can be applied to an electrophotographic recording type printer or an offset printing machine.

  As shown in FIG. 1, the host 1 and the recording apparatus 2 are connected to each other via a bidirectional interface 3 (for example, USB, IEEE 1394, TCP / IP, etc.). A typical example of the host 1 is a personal computer (PC). The host 1 includes a main board 100 including a CPU 101, a keyboard (KB) 105, a display (DISPLAY) 107 such as an LCD, and an external storage device 109 such as a hard disk (HDD) and a flexible disk (FDD). doing. The main board 100 further includes a RAM 102, a ROM 103, a keyboard controller (KBC) 104, a display controller (DISPC) 106, a disk controller (DKC) 108, and a printer controller (PRTC) 110.

  The CPU 101 comprehensively controls the above-described elements connected to the system bus 111, and executes various programs including programs described later with reference to FIGS. A keyboard controller (KBC) 104 controls input from a keyboard 105 and a pointing device (not shown). The keyboard controller 104 is also referred to as an operation unit or an input unit. A display controller (DISPC) 106 controls display on the display 107. The RAM 102 functions as a main memory or work area for the CPU 101. The ROM 103 stores an operating system, a program that executes each function according to this embodiment, a boot program, various applications, a printer control command generation program (hereinafter referred to as a printer driver), and the like.

  A disk controller (DKC) 108 controls access to an external storage device 109 such as a hard disk or a flexible disk (registered trademark). A printer controller (PRTC) 110 is connected to the recording apparatus 2 via the bidirectional interface 3 and controls data and command communication processing with the recording apparatus 2.

  The printer 2 includes a controller 121, a printer engine 122, an operation panel 12, and a nonvolatile storage device 133, and is data-connected to the host 1 via the bidirectional interface 3. The non-volatile storage device 133 includes a hard disk (HDD) 128 or an EEPROM 129. The nonvolatile storage device is also referred to as a nonvolatile memory.

  The controller 121 includes a CPU 124, ROM 125, RAM 126, interface controller (I / FC) 123, disk controller (DKC) 127, panel interface (I / FP) 130, and engine interface (I / FE) 132.

  The CPU 124 executes various programs. The ROM 125 receives printing image data and commands from the host 1 and stores programs and various data for controlling the printer engine 122 to realize optimum recording. The RAM 126 is used as a work area for temporarily storing various data and various programs.

  An interface controller (I / FC) 123 is connected to the host 1 via the bidirectional interface 3 and controls data and command communication processing with the host 1. A hard disk (HDD) 128 stores a large amount of data such as data from the host 1 and attached information related to the data. The EEPROM 129 stores information unique to the recording device used during the recording operation. A disk controller (DKC) 127 controls access to the nonvolatile storage device 133. A panel interface (I / FP) 130 controls display on the operation panel 12 and input from the operation panel 12. An engine interface (I / FE) 132 controls the printer engine 122 that directly controls hardware to realize optimal printing.

  In this embodiment, the printer engine 122 uses an ink jet recording method, but a printer engine or an offset printing machine according to an electrophotographic method can also be used.

<Schematic configuration of inkjet printer>
FIG. 2 is an external perspective view of the recording apparatus 2 constituting the recording system shown in FIG. As shown in FIG. 2, a manual insertion slot 88 is provided on the front surface of the recording apparatus 2, and a roll paper cassette 89 that can be opened and closed to the front surface is provided below the manual insertion slot 88. Thus, a recording medium such as recording paper is supplied from the manual insertion slot 88 or the roll paper cassette 89 into the recording apparatus. The recording apparatus 2 includes an apparatus main body 94 supported by two leg portions 93, a stacker 90 on which the discharged recording medium is stacked, and a transparent and openable upper cover 91 through which the inside can be seen. A control unit (not shown), an operation panel 12, an ink supply unit (not shown), and an ink tank 8 are provided on the right side of the apparatus main body 94. This recording apparatus is in the form of a large format printer capable of recording on a recording medium having a large size such as B0 or A0 size in terms of cut paper. In the present specification and the accompanying drawings, recording by this recording apparatus is also referred to as “printing”.

<System configuration having a plug-in according to the present embodiment>
FIG. 3 is a diagram illustrating a configuration of a system having a plug-in according to an embodiment of the present invention, and includes the PC 1 and the printer 2 illustrated in FIGS. 1 and 2. In FIG. 3, reference numeral 303 denotes spreadsheet software that operates on the PC 1. As an example, Microsoft Excel (US Micro Software Co., Ltd.), which is general spreadsheet software, can be cited. A plug-in 304 expands the function of the spreadsheet software and operates on the spreadsheet software, and operates in cooperation with the spreadsheet software and the printer driver that controls the printer. As will be described later, this plug-in functions as a paper size setting program. Reference numeral 305 denotes a printer driver that an application requests a printer to print via an operating system (hereinafter referred to as OS). The printer driver 305 interprets a print command received via the OS and generates print data that can be interpreted by the printer. Also, a change in print settings from the plug-in 304 is accepted. Reference numeral 306 denotes a spreadsheet software setting unit included in the plug-in 304, and includes a program for performing various settings in the spreadsheet software. Reference numeral 307 denotes a print setting unit included in the plug-in 304, and has a program for making various settings in the printer driver.

<Starting the plug-in of this embodiment>
FIG. 4 is a diagram showing a display screen when the spreadsheet software 303 is activated. The spreadsheet software screen includes a title bar 401 that displays a document title, a menu bar 402 that displays various functions, a toolbar 403 that displays functions as icons, and a document display area 404 that displays a document that is currently being edited. Consists of. An icon 405 in the toolbar 403 is a plug-in activation icon displayed by registering the plug-in 304 in the spreadsheet software 303. In addition, since the method of registering the plug-in for the spreadsheet software is known, the description thereof is omitted.

  FIG. 5 is a diagram showing a roll paper width designation dialog displayed on the display 107 when the plug-in activation icon 405 is pressed. In FIG. 5, the roll paper width designation dialog 501 has a combo box 502 for designating the roll paper width, a print button 503, and a cancel button 504. Here, printing is performed by designating the roll paper width to be printed via the combo box 502 and pressing the print button 503. When the cancel button 504 is pressed, the screen returns to the screen shown in FIG. In the present embodiment, the operation of setting the paper size and the print setting especially when the print button 503 is pressed will be described later with reference to FIGS.

  Before describing these operations, the functions of the printer 2 will be described below. 6 and 7 are diagrams for explaining respective functions of the printer 2 according to the present embodiment.

<Margin Delete Function Provided in Printer of this Embodiment>
6A and 6B are diagrams for explaining a margin deletion function provided in the printer driver. The margin deletion function is a function for printing only image data existing in a page in accordance with an instruction from the printer driver 305 according to a control command. In other words, this function is a function that does not feed the margin of the document data so that no margin is formed in the print result. Paper can be saved by the margin deletion function. Specifically, FIG. 6A shows a case where the margin deletion function is not used, and as a result, extra blanks 602 and 603 are formed above and below the image portion 601. On the other hand, FIG. 6B shows a case where the margin deletion function is used, and extra blanks at the top and bottom of the image portion 601 are not fed and only the image is formed.

<No-cut function provided in the printer of this embodiment>
FIGS. 7A and 7B are diagrams for explaining the non-cut function provided in the printer driver. The no-cut function is a function that prevents the roll paper from being cut for each page in accordance with an instruction from the printer driver 305 according to a control command. The no-cut function is used for long printing or when using paper that cannot be cut. In other words, this no-cut function can eliminate the boundaries between a plurality of divided areas (pages) depending on the sheet size in the spreadsheet software.

  FIG. 7A shows a case where the no-cut function is not used. As shown in FIG. 7A, cutting is performed between the first page 701 and the second page 702. On the other hand, FIG. 7B shows a case where the no-cut function is used. Printing is continued without cutting between the first page 701 and the second page 702.

<Operation of plug-in according to this embodiment>
Hereinafter, the operation of the plug-in 304 according to an embodiment of the present invention will be described. FIG. 8 is a flowchart showing the operation of the plug-in 304 program called when the user presses the print button 503 in the roll paper width designation dialog 501 shown in FIG.

  In step S801, settings are made for the spreadsheet software 303. Specifically, as will be described later with reference to FIG. 10, paper size creation and setting, printing orientation setting, and enlargement / reduction setting are performed. In step S802, settings for the printer driver 305 are performed. Specifically, as will be described later with reference to FIG. 10, based on the paper size set in step S801, the scaling setting and the margin deletion function are set so that the roll paper width specified in the roll paper width specification dialog 501 is printed. Configure settings, cut-off function settings, page rotation settings, and print settings.

  FIGS. 9A to 9H are diagrams showing documents by spreadsheet software that change according to the settings for the spreadsheet software and the settings for the printer driver described above by the plug-in 304. As shown in FIG. 9A, the document created by the spreadsheet software exists in a range of width 6600 mm × height 10500 mm. Note that the size of the range in which this document exists is based on the size set for the cell, and is determined by the sum of the sizes of the cells existing in the vertical and horizontal directions of this range. This size in this example indicates that the range in which the document exists is relatively large. A document of this size becomes data for printing on a roll paper having a width of 24 inches (610.0 mm) by setting processing by the plug-in 304 described below with reference to FIGS. 10 and 12. .

  FIG. 10 is a flowchart showing a setting process for the spreadsheet software by the plug-in according to the embodiment of the present invention.

  First, in step S1001, a predetermined predetermined paper size (reference paper size) is set for a document of spreadsheet software. The reference paper size is not particularly specified, and may be any size that can be handled by the printer driver. In this example, the reference paper size is 300 mm × 300 mm. As a result of this step S1001, the range in which the document exists as indicated by the vertical solid line and the horizontal broken line in FIG. 9A is the width direction (horizontal direction in FIG. 9A) 22 depending on the reference paper size. It is divided into 35 pieces and 35 pieces in the height direction (vertical direction in FIG. 9A). That is, the range in which the document exists is 22 pages in the width direction and 35 pages in the height direction depending on the reference paper size.

  In step S1002, the number of pages divided in the horizontal and vertical directions according to the setting of the reference paper size as described above is acquired. That is, as shown in FIG. 9B, 35 pages long and 22 pages wide are acquired.

  Next, in step S1003, printing is performed from the horizontal length obtained by expanding the width of the reference paper size by the number of pages in the horizontal direction and the vertical length obtained by increasing the height of the reference paper size by the number of pages in the vertical direction. The orientation of the print is determined (print orientation determination). Specifically, first, the vertical length and the horizontal length are compared. The printing direction is determined as “vertical” when the horizontal length is larger, and “horizontal” when the vertical length is larger. In the illustrated example, the horizontal length is 300 × 22 = 6600, and the vertical length is 300 × 35 = 10500. Therefore, it is determined that the vertical length is larger. As a result, as shown in FIG. 9C, it is determined that the printing direction is “horizontal”. That is, in this process, the printing direction is such that the smaller one of the vertical and horizontal lengths of the document is along the width direction of the roll paper as the recording medium. As a result, in the paper size processing in which the document is finally printed in accordance with the width of the roll paper, the reduction ratio can be further increased. As a result, when an extremely large document is put on one page, It is possible to cope with the reduction ratio of the spreadsheet software.

  Next, in step S1004, the paper is obtained from the horizontal length obtained by expanding the width of the reference paper size to the number of pages in the horizontal direction and the vertical length obtained by expanding the height of the reference paper size to the number of pages in the vertical direction. Determine the size (determine paper size). First, the vertical length and the horizontal length are obtained and compared. Since the horizontal length is 300 × 22 = 6600 and the vertical length is 300 × 35 = 10500, it is determined that the horizontal length is small. Then, the height of the paper size is determined based on the smaller length.

  Here, it is assumed that the upper limit of the page size that can be set in the application (spreadsheet software 303) is 6000 mm in both vertical and horizontal directions. Then, if the vertical direction (10500 mm) of the data to be printed is reduced to 6000 mm, the reduction rate is low and may exceed the minimum reduction rate of the spreadsheet software 303. Therefore, the smaller horizontal direction (6600 mm) of the data to be printed is used as a reference, that is, according to the printing direction determined in step S1003 ("horizontal" in this example). The “height” of the paper size corresponding to the vertical direction in the orientation is determined based on the length in the horizontal direction. In this process as well, as described above for step S1003, when a very large document is put on one page, it is possible to cope with the reduction ratio of the spreadsheet software.

  In this example, since the horizontal length is small, the horizontal length of 6600 mm is used as a reference, and 6000 mm, which is smaller than this reference, is set as the height of the paper size. Further, since the width of the paper size corresponding to the horizontal direction in the printing direction may be arbitrary, it is set to 610 mm which is 24 inches. That is, by this process, as shown in FIG. 9D, a paper size of width 610 mm × height 6000 mm is determined.

  In step S1005, the printing direction determined in step S1003 is set in the spreadsheet software. In step S1006, the paper size determined in step S1004 is set in the spreadsheet software. By these processes, pages in units of paper size as shown in FIG. 9E are defined in the spreadsheet document. Specifically, an area divided into two pages in the horizontal direction and 18 pages in the vertical direction is defined.

  In step S1007, enlargement / reduction of 1 × N pages is set in the spreadsheet software. Here, if the printing orientation determined in step S1003 is vertical, one vertical page and N horizontal pages are set. If the printing orientation determined in step S1003 is horizontal, vertical N pages and horizontal one page are set. Set.

  This setting is a setting provided in general spreadsheet software, and is set via a dialog shown in FIG. As shown in FIG. 11, the enlargement / reduction setting dialog 1101 includes an enlargement / reduction ratio designation radio button 1102, a page number designation radio button 1103, an OK button 1104, and a cancel button 1105. When the enlargement / reduction ratio designation radio button 1102 is selected, the current document is arranged on the page at the designated enlargement / reduction ratio. When the page number designation radio button 1103 is selected, the current document is arranged in the designated page number. Here, by selecting a desired enlargement / reduction setting and pressing an OK button 1104, the setting is reflected. If a cancel button 1105 is pressed, the screen returns to the screen on which the enlargement / reduction setting dialog 1101 has been activated. In this example, the page number designation radio button 1103 is selected, and an operation for setting the vertical N page and the horizontal page is designated by the program. If the radio button is already in this state, nothing needs to be done. As a result of the processing in step S1007, as shown in FIG. 9F, since the printing direction is “horizontal”, the data to be printed is reduced so that the horizontal direction of the document becomes one page. The data to be printed is reduced so that the direction is N pages (16 in the illustrated example).

  Depending on the margin setting in the application, a margin may be provided in the page. In step S1008, the margin setting of the spreadsheet software is set so that no margin is provided in the page. For example, “0.0 mm” is set as the margin amount corresponding to the top, bottom, left, and right of the page in the margin setting. Thereby, the data divided into pages so that there is no margin in the page is created by the spreadsheet software.

  As described above, according to the embodiment of the present invention, through the processing of steps S1003 and S1004, the shorter one of the vertical and horizontal data to be printed matches the width direction of the roll paper. Data is reduced. Therefore, when reducing the spreadsheet data to be printed, depending on the reduction ratio of the spreadsheet software, even the spreadsheet data existing in a relatively large size range depends on the paper size that the printer driver can handle. Spreadsheet data can be stored on one page.

  As described above with reference to FIG. 5, when the above “spreadsheet software setting” (S801) is completed, “print setting” (S802) is performed.

  FIG. 12 is a flowchart showing print setting processing according to an embodiment of the present invention.

  First, in step S1201, the printer driver 305 is set to scale to the roll paper width specified in the combo box 502 based on the paper size determined in step S1004. This setting is a setting provided in the printer driver, and is set via a dialog shown in FIG. As shown in FIG. 13, a dialog 1301 includes a combo box 1302 for specifying a document size, a check box 1303 for specifying enlargement / reduction printing, radio buttons 1304 to 1306 for specifying an enlargement / reduction method, and a combo box 1307 for specifying a roll paper width. have. A combo box 1302 sets the paper size of the application. When the check box 1303 is designated, one of the three enlargement / reduction methods can be designated. When the output paper size designation radio button 1304 is selected, the document size is enlarged or reduced in accordance with the paper size designated as the output paper size. When the roll paper width designation radio button 1305 is selected, the document size is enlarged or reduced according to the roll paper width designated in the combo box 1307. Further, when the magnification designation radio button 1306 is selected, the document size is enlarged or reduced at the designated magnification.

  In this example, an operation for designating the roll paper width designated in the combo box 502 to the combo box 1307 by designating the paper size determined in step S1004 in the combo box 1302 and selecting the roll paper width designation radio button 1305. Specify by program.

  In step S1202, a page rotation function is set in the printer driver. This setting is a setting provided in the printer driver, and roll paper can be saved by rotating the page by 90 degrees or 270 degrees. In the dialog shown in FIG. 13, the rotation is designated via a check box 1310 for designating the page rotation function. In this example, an operation for specifying the check box 1310 is specified by a program.

  Through the processes in steps S1201 and S1202, the document state is changed and reduced to the roll paper width as shown in FIG.

  Next, in step S1203, the no-cut function is set in the printer driver. This setting is a setting provided in the printer driver and is the function described above with reference to FIG. This function can be set via a dialog shown in FIG. This is set through a check box 1309 for designating a function without cut in the dialog 1301. In this example, an operation for specifying the check box 1309 is specified by a program.

  With this function, the vertical direction of the spreadsheet document can be contained on one page. In the process of step S1007 described above, by setting the paper size as one page instead of N pages as the vertical direction of the spreadsheet document, the vertical direction of the spreadsheet document is changed to one page without passing through this no-cut function. You may make it contain.

  In step S1204, a margin deletion function is set in the printer driver. This setting is a setting provided in the printer driver and is the function described above with reference to FIG. This function is set via a check box 1308 for specifying a margin deletion function in the dialog 1301 shown in FIG. In this example, an operation for specifying the check box 1308 is specified by a program of plug-in software.

  When printing is executed under the control of the printer driver by the processes in steps S1203 and S1204, as shown in FIG. 9H, the document is printed with no margin between pages.

  Finally, in step S1205, the spreadsheet software is instructed to print. Thereby, the document of the spreadsheet software having a relatively large size shown in FIG. 9A shown in FIG. 9H can be obtained as a one-page printed matter.

  Also, the settings for the spreadsheet software (application) and printer driver in FIGS. 10 and 12 are executed by plug-ins. That is, page setting, margin setting, scaling setting for printer driver, rotation setting, margin deletion function setting, etc. of the spreadsheet software are automatically executed by the plug-in, not by the user's instruction. Therefore, it is possible to easily print the spreadsheet data so as to fit the width of the roll paper without the user giving the above instruction.

  Note that various settings may be changed by the above plug-in without the intention of the user. Therefore, after the processing in FIGS. 10 and 12, processing that returns the setting changed in the spreadsheet software and printer driver to the setting before execution of the processing in FIGS. 10 and 12 may be performed. In this case, for example, the settings before processing are stored in the RAM 102, and after the plug-in executes the processing of FIGS. 10 and 12, the settings stored in the RAM 102 may be set again in the spreadsheet software and the printer driver. .

  In addition, in the spreadsheet software setting process, by adding a frame line around the data of the spreadsheet document (adding a frame line), the layout of the document in the frame line is changed by the various processes of the spreadsheet software setting described above. It may not be changed.

  In the above-described embodiment, the paper size is determined and the print data size is determined by the plug-in, which is a program for adding functions to the spreadsheet software, through the settings for the spreadsheet software and the settings for the printer driver. However, application of the present invention is not limited to this form. For example, the spreadsheet software itself may execute the processing described with reference to FIG.

  Further, when determining the printing direction in FIG. 9C, the printing direction is “vertical” when the vertical direction of the data to be printed is longer than the horizontal direction, and printing is performed when the horizontal direction is longer. The direction may be “horizontal”.

  Note that the functions of this embodiment can also be realized by the following configuration. That is, it is also achieved by supplying a program code for performing the processing of the present embodiment to a system or apparatus, and a computer (or CPU or MPU) of the system or apparatus executing the program code. In this case, the program code itself read from the storage medium realizes the function of the above-described embodiment, and the storage medium storing the program code also realizes the function of the present embodiment.

  Further, the program code for realizing the function of the present embodiment may be executed by one computer (CPU, MPU), or may be executed by a plurality of computers cooperating. Also good. Further, the program code may be executed by a computer, or hardware such as a circuit for realizing the function of the program code may be provided. Alternatively, a part of the program code may be realized by hardware and the remaining part may be executed by a computer.

1 Host computer 2 Recording device (printer)
101 CPU
102 RAM
103 ROM
107 Display 303 Spreadsheet Software 304 Plug-in 305 Printer Driver 306 Spreadsheet Software Setting Unit 307 Print Setting Unit 1011 Enlargement / Reduction Setting Dialog 1301 Dialog

Claims (8)

A paper size setting program for causing a computer to execute processing for setting a paper size in spreadsheet software, wherein the processing includes:
For an area where data created on spreadsheet software is present, a horizontal length corresponding to the number of pages in the horizontal direction of the area and a vertical page of the area obtained based on a predetermined reference paper size A printing direction determination step for determining the printing direction of the data from the length in the vertical direction corresponding to the number;
A paper size determining step for determining the paper size by determining the height and width of the paper size corresponding to the horizontal direction and the vertical direction of the area according to the determined printing orientation;
The height and width of the paper size are enlarged or reduced according to the determined printing orientation, and an area where the data exists is included in at least one of the height and width of the paper size. Scaling process to
A paper size setting program characterized by comprising:   In the printing orientation determination step, the smaller one of the length in the horizontal direction corresponding to the number of pages in the horizontal direction of the area and the length in the vertical direction corresponding to the number of pages in the vertical direction of the area is used for printing. The paper size setting program according to claim 1, wherein the printing direction is determined so as to be along a direction of a smaller length.   In the paper size determination step, when the determined printing direction is horizontal, the height of the paper size corresponding to the vertical direction in the printing direction is determined based on the horizontal length of the region. The paper size setting program according to claim 2, wherein:   4. The method according to claim 1, further comprising a no-cut process for eliminating boundaries between a plurality of divided areas obtained by dividing an area in which the data exists according to the determined sheet size. 5. Paper size setting program.   5. The sheet size setting program according to claim 1, further comprising a frame line adding step for adding a frame line for partitioning an area where the data exists.   6. The scaling process according to claim 1, further comprising a scaling step of scaling to a size of an area where the data to be printed by a recording apparatus exists based on the paper size and the size of the paper used for the printing. The paper size setting program described in any one of the above.   The paper size setting program according to claim 1, wherein the processing is executed by a paper size setting program according to claim 1. A paper size setting method for executing processing for setting a paper size in spreadsheet software,
For an area where data created on spreadsheet software is present, a horizontal length corresponding to the number of pages in the horizontal direction of the area and a vertical page of the area obtained based on a predetermined reference paper size A printing direction determination step for determining the printing direction of the data from the length in the vertical direction corresponding to the number;
A paper size determining step for determining the paper size by determining the height and width of the paper size corresponding to the horizontal direction and the vertical direction of the area according to the determined printing orientation;
The height and width of the paper size are enlarged or reduced according to the determined printing orientation, and an area where the data exists is included in at least one of the height and width of the paper size. Scaling process to
A paper size setting method characterized by comprising:

Images