Excel VSTO - cm inches to point conversion not accurate

0 votes

I've been working on a unique ribbon bar that has the ability to resize charts to fit within a PowerPoint slide template we have.

The accepted wisdom is to utilize a standard 28.35 points to 1 cm to cm conversion function. This doesn't appear to be accurate, though.

For instance, if the input for the conversion function is 6.7 cm, the width of the chart that is embedded in PowerPoint will be 6.88 cm.

This has been tried:

It never comes up accurately.

I have not been able to find any mention of "external factors" that may impact how it appears (such as display resolution, slide size, etc).

Any ideas why this would happen and what workaround options there are?

Oct 31 in Others by Kithuzzz
• 20,660 points
38 views

1 answer to this question.

0 votes
You may convert centimetres to points in Excel VBA more precisely by dividing the centimetres by 0.035278. They utilise a point-to-centimeter ratio of 28.35, which is too rounded and leads to inaccuracies. You could calculate it for inches as well by creating a macro to resize, then dividing the points number by your inches to achieve a more precise conversion calculation.
answered Oct 31 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

csv to excel conversion

So Basically u have to follow few ...READ MORE

answered Feb 9 in Others by gaurav
• 22,040 points
68 views
0 votes
0 answers

MS EXCEL: Convert (Height) Decimal Feet & Inches to Inches Only

Using MS Excel (2010), I would like ...READ MORE

Feb 10 in Others by Edureka
• 13,640 points
96 views
0 votes
1 answer

Conversion of PDF file to Excel in R

I looked at the pdf, and it ...READ MORE

answered Oct 16 in Others by narikkadan
• 37,660 points
70 views
0 votes
1 answer

Currency conversion:number to words excel

Try looking for javascript solutions to use ...READ MORE

answered Oct 28 in Others by narikkadan
• 37,660 points
44 views
0 votes
1 answer

How to reference Microsoft.Office.Interop.Excel dll?

Use NuGet (VS 2013+): The NuGet package manager ...READ MORE

answered Oct 9 in Others by narikkadan
• 37,660 points
145 views
0 votes
1 answer

How to open an Excel file in C#?

You must have Microsoft Visual Studio Tools ...READ MORE

answered Nov 13 in Others by narikkadan
• 37,660 points
43 views
0 votes
1 answer

How do I get an Excel range using row and column numbers in VSTO / C#?

Use: int countRows = xlWorkSheetData.UsedRange.Rows.Count; int countColumns = xlWorkSheetData.UsedRange.Columns.Count; object[,] ...READ MORE

answered Nov 17 in Others by narikkadan
• 37,660 points
32 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,720 points
451 views
0 votes
1 answer

Excel Formula to convert from cm to inches and feet & round off to two digits

Use the TEXT function to format, and ...READ MORE

answered Oct 15 in Others by narikkadan
• 37,660 points
45 views
0 votes
1 answer

Converting Feet-Inches to Inches Excel

We must parse the data because these ...READ MORE

answered Oct 15 in Others by narikkadan
• 37,660 points
58 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP