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, 2022 in Others by Kithuzzz
• 38,010 points
1,685 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, 2022 by narikkadan
• 63,420 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, 2022 in Others by gaurav
• 23,260 points
430 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, 2022 in Others by Edureka
• 13,670 points
381 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, 2022 in Others by narikkadan
• 63,420 points
1,288 views
0 votes
1 answer

Currency conversion:number to words excel

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

answered Oct 28, 2022 in Others by narikkadan
• 63,420 points
307 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, 2022 in Others by narikkadan
• 63,420 points
2,213 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, 2022 in Others by narikkadan
• 63,420 points
996 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, 2022 in Others by narikkadan
• 63,420 points
1,263 views
0 votes
1 answer

Unhide all Hidden Excel Columns Without Individual Iteration?

I discovered that the best way to ...READ MORE

answered Dec 16, 2022 in Others by narikkadan
• 63,420 points
554 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, 2022 in Others by narikkadan
• 63,420 points
595 views
0 votes
1 answer

Converting Feet-Inches to Inches Excel

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

answered Oct 15, 2022 in Others by narikkadan
• 63,420 points
948 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