Height of rows in Excel (points vs Pixels)

Question

0.00/5 (No votes)

See more:

In Excel, the height of rows are entered in points and converted into pixels.
As I thought the pixel was the unit for height I was very surprised to see these conversions .....
Left: The unit of points (manually entered) for the height lines
Right: conversion in pixels from Excel
213.67 units = 284 pixels
213.68 units = 286 pixels
213.69 units = 286 pixels
Why when I go from 213.67 to 213.68 points, the number of pixels increases from 284 to 286?
Do you have any idea why?
Daniel

Posted 14-Aug-10 9:34am

daniel houle

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Answer 1 · 2010-08-15T01:32:00

Solution 1

It depends on the resolution of the output device. Points are absolute values of 1/72 inches, whereas pixels are arbitrary values based on the physical size of the device and the resolution in use.

Posted 15-Aug-10 1:32am

Richard MacCutchan

daniel houle · Answer 2 · 2010-08-15T04:49:00

Richard,
Thanks for your response
My screen is ACER X263W
My resolution is 1680 x 1050.
Pixel Pitch is 0.287mm (per Acer Specs)

Is there enough information to find the formula for conversion of points to pixels?
If not can you please advise what info would be missing?

Thanks again
Daniel

The Manoj Kumar · Answer 3 · 2010-08-15T17:06:00

Solution 3

I hope this should answer your question How to convert Pixels to Points (px to pt) in .NET? (C#)[^]

Posted 15-Aug-10 17:06pm

The Manoj Kumar