Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Coordinates and Printing
I'm using ExportAsFixedFormat to create an XPS file of a worksheet. I'd like
to iterate through cells in the sheet and determine the coordinates of each cell as it was printed on the XPS page. I've run into two problems with this. 1. The Left property of Range objects return different values depending on the current view mode ("Normal", "Page Layout", and "Page Break Preview"). In "Page Layout" mode, it lines up perfectly but the other two modes are equally shifted left. 2. Values of the Top property are slightly too large (even in "Page Layout" mode). For example, with 3/4 inch margins, a typical page is 9.5 inches or 684 points high. The Top of the bottom row printed on this page is returned as 690. What can I do to get around these problems and accurately determine page coordinates? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell that is below given coordinates | Excel Programming | |||
Convert point coordinates - pixel coordinates | Excel Programming | |||
Simple way to convert UTM ED50 coordinates to decimal coordinates? | Excel Programming | |||
Converting MouseDown Coordinates to Chart Point Coordinates | Excel Programming | |||
Printing with coordinates | Excel Programming |