Thursday, January 25, 2007

The issue of centering a report in the page in excel format

When you are exporting a report in excel format and want to center a table in the page, could find difficult to do it, because the width of the table in Excel change against the width which you have setted for the table when you created the report.
I have notice that the ratio "width of table of excel/width whic you have setted for the table in the project" is nearest to 1.076. Therefore you must divide the width which you want for the table in excel format by this constant to obtain the width to set for of the table in the project, considering obviously the width of the margins of the report. After you have divided by 1.076 let have the shrewdness to reduce the width found for the table in the project by 1/10 of a millimetre because of the inevitable imprecision of the printer.
Goodby and god job.

No comments:

Post a Comment