Somethings not correct in DPI 144

Aspose.Cells Product Family
1

Hi all,
I’m using Aspose Cell 19.2 and genarate a excel file.
My screen resolution is 2560x1440 and scale layout set to 150% (144 DPI)
I trying to set coulmn width is 400px, add a TextBox (40x40 px, Placement=FreeFloating),
Font.SchemeType = Minor. (Default style of book)
But I open file and check then my column width has changed to 364px and TextBox size is not correct.

I trying set other DPI or set Font Scheme to Major or None and it working fine. But if I don’t set to Minor, I can’t changing Themes And Color :frowning:

This is my test Project:
AsposeTestApp.zip (32.8 KB)

What wrong with 144 DPI and how to fix it?

Best and Regard!

2

@DungLT,
We have logged the issue in our database for investigations. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSNET-47330 - Problem with DPI and Font Scheme
1 Like
3

I founded solution to fix it.
Change font to Calibri, 11
Read more: How column widths are determined in Excel - Microsoft 365 Apps | Microsoft Learn

4

@DungLT,
Good to know that your issue is sorted out. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

1 Like