MSO_AUTO_SIZE.TEXT_TO_FIT_SHAPE attribute does not take effect about python-pptx HOT 4 OPEN

I have the same problem. I wonder if python-pptx is really even able to calculate the correct size. The calculation seems to only happen when you open the Excel file, and slightly tweak the shape size, or the text.
This is a big problem for exports, because nothing really ever fits onto the single slide properly.

from python-pptx.

Calculating the correct size would require using font metrics - which I don't believe python-pptx has access to or understanding of.

from python-pptx.

I just found this method which looks interesting:

shape.text_frame.fit_text()

It doesn't quite work for me because I'm running linux in a docker container which is an unsupported OS, but it might work for others.

It seems that python-pptx does have some understanding of fonts (although I'm unsure if font 'metrics' is a specific term).
The following class looks interesting:
pptx.text.fonts.py - especially the _best_fit_font_size method.

from python-pptx.

If you want to know how long a certain character string is you need font metrics - which describe the width of pairs of neighbouring characters. The only exception to this is fixed-pitch fonts.

from python-pptx.