Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell that is below given coordinates MrT Excel Programming 2 September 10th 06 08:21 PM
Convert point coordinates - pixel coordinates Zorro[_3_] Excel Programming 1 June 1st 06 03:26 AM
Simple way to convert UTM ED50 coordinates to decimal coordinates? Dan[_38_] Excel Programming 8 July 11th 04 04:54 PM
Converting MouseDown Coordinates to Chart Point Coordinates Steve[_50_] Excel Programming 3 December 2nd 03 06:48 PM
Printing with coordinates Beto[_2_] Excel Programming 1 November 24th 03 04:56 PM


All times are GMT +1. The time now is 11:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"