Skip to content

AddPicture Method: Identifying Scale Adjustment Direction and Proposing Enhanced Functionality #1813

@t4traw

Description

@t4traw

I have a question regarding the AddPicture method.

I understand that in Excel, cell sizes can change depending on the screen size and other environmental factors. Therefore, I thought about adjusting the Scale value for each environment where the file is opened. However, when using the autoFit option with AddPicture, I realized I couldn't proceed without knowing in which direction the Scale is being adjusted.

When passing {autoFit: true} in GraphicOptions, and the image is scaled down to fit the cell width, for example, with a square image in a vertically longer cell, I assume the width fills the cell and the height in pixels is adjusted accordingly.

Is there a way to know whether the adjustment is being made to the width or the height?

Additionally, if there's no way to know this, should I propose a function that returns information about the scaled-down image (for example: AddPictureAndGetInfo) via a Pull Request?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions