Resolution-issue opening Excel-files from TC

English support forum

Moderators: white, Hacker, petermad, Stefan2

Post Reply
kvex
Junior Member
Junior Member
Posts: 5
Joined: 2022-03-28, 19:26 UTC

Resolution-issue opening Excel-files from TC

Post by *kvex »

Hi all,

I have an issue opening Excel files from TC on my Dell XPS15 (4K screen).

When I open an Excel file it is completely out of proportion: cells are oversized and text is undersized:
Image: https://i.ibb.co/2jrVwdR/From-TC.jpg

At first I thought this is just an issue with the resolution of my screen, but then I noticed that when I open the same file from Windows Explorer, there is nothing wrong:

Image: https://i.ibb.co/qngS772/From-Explorer.jpg

Can somebody please help solve this issue? I would like Excel to operate as if I opened it from the Explorer.
Last edited by kvex on 2022-05-08, 18:17 UTC, edited 1 time in total.
User avatar
white
Power Member
Power Member
Posts: 4594
Joined: 2003-11-19, 08:16 UTC
Location: Netherlands

Re: Resolution-issue opening Excel-files from TC

Post by *white »

2kvex
I noticed "Weergave-instellingen" (display settings) on your TC screenshot. Does that have anything to do with it?
User avatar
Dalai
Power Member
Power Member
Posts: 9364
Joined: 2005-01-28, 22:17 UTC
Location: Meiningen (Südthüringen)

Re: Resolution-issue opening Excel-files from TC

Post by *Dalai »

Do you start TC via a shortcut that applies scaling or other display-related compatibility settings? Maybe such settings are applied to TC's child processes, too.

Regards
Dalai
#101164 Personal licence
Ryzen 5 2600, 16 GiB RAM, ASUS Prime X370-A, Win7 x64

Plugins: Services2, Startups, CertificateInfo, SignatureInfo, LineBreakInfo - Download-Mirror
kvex
Junior Member
Junior Member
Posts: 5
Joined: 2022-03-28, 19:26 UTC

Re: Resolution-issue opening Excel-files from TC

Post by *kvex »

white wrote: 2022-03-29, 08:20 UTC 2kvex
I noticed "Weergave-instellingen" (display settings) on your TC screenshot. Does that have anything to do with it?
I think this is a Red Herring, which is why I did not include it. But since you asked I will show you anyway, hoping that I will not derail my original request too much.

Indeed I had noticed that too and when I clicked it, I got the following options:
Image: https://i.ibb.co/pv35BrG/Weergave-instellingen.jpg
When I changed from the current setting ('optimized for best visibilty') to the alternative setting ('optimize for best compatibility') this completely messed up the interface:
Image: https://i.ibb.co/QXWvY83/Compatibiliteit.jpg
Now Excel occupied only a fraction of my screen, and became virtually unmanageable: to operate it the cursor has to be moved over the white space of the screen and to restore the display settings to their previous setting I had to play a nightmare of a guess-and-clicking-game which took me about half an hour to accomplish, and I will have to do that again now because I made this screenshot for you.

The message is probably connected to the rootcause though, because I consistently get it when opening an Excel from Total Commander, and I consistently do not get it when opening the very same Excel from the Explorer.
kvex
Junior Member
Junior Member
Posts: 5
Joined: 2022-03-28, 19:26 UTC

Re: Resolution-issue opening Excel-files from TC

Post by *kvex »

Dalai wrote: 2022-03-29, 12:10 UTC Do you start TC via a shortcut that applies scaling or other display-related compatibility settings? Maybe such settings are applied to TC's child processes, too.

Regards
Dalai
Thanks Dalai! That was an excellent suggestion. Indeed, I use high-DPI settings when starting Total Commander. When disabling it, the problem is gone, so I think your theory makes perfect sense. Would there be a way to prevent Total Commander from sending the scaling to child processes? Right now I have to choose between Total Commander- or Excel-scaling issues.
User avatar
Dalai
Power Member
Power Member
Posts: 9364
Joined: 2005-01-28, 22:17 UTC
Location: Meiningen (Südthüringen)

Re: Resolution-issue opening Excel-files from TC

Post by *Dalai »

kvex wrote: 2022-03-29, 15:47 UTCRight now I have to choose between Total Commander- or Excel-scaling issues.
Uh, why? TC can do its own scaling (and Excel can, too). See TC's options, e.g. Font.

Regards
Dalai
#101164 Personal licence
Ryzen 5 2600, 16 GiB RAM, ASUS Prime X370-A, Win7 x64

Plugins: Services2, Startups, CertificateInfo, SignatureInfo, LineBreakInfo - Download-Mirror
kvex
Junior Member
Junior Member
Posts: 5
Joined: 2022-03-28, 19:26 UTC

Re: Resolution-issue opening Excel-files from TC

Post by *kvex »

Dalai wrote: 2022-03-29, 16:50 UTC
kvex wrote: 2022-03-29, 15:47 UTCRight now I have to choose between Total Commander- or Excel-scaling issues.
Uh, why? TC can do its own scaling (and Excel can, too). See TC's options, e.g. Font.

Regards
Dalai
The nice thing about the compatibility scaling is that it takes me one checkmark and the whole scaling on my 4K display is just like it was on my Full-HD screen. I've tried fiddling around in the menu's but it is quite a pain to get it looking similar: you have to figure out the exact sizes for fonts, icon sizes in the folders, icon sizes in the top row, and even then it still looks different. Even the menus themselves look different, and when I use the program from USB on my 2K-computer all settings will be wrong again. So it would be much easier for me if I can just have Total Commander not send the scaling info to the app to be opened.
User avatar
Dalai
Power Member
Power Member
Posts: 9364
Joined: 2005-01-28, 22:17 UTC
Location: Meiningen (Südthüringen)

Re: Resolution-issue opening Excel-files from TC

Post by *Dalai »

TC doesn't send anything about scaling to its child processes, but Windows does. It's the same with CPU affinity, user security tokens (UAC, i.e. run as administrator or as different user) and maybe others.

BTW: It wasn't talking about font sizes specifically, but the DPI setting in the Font section. It might be a little bit of effort to adjust the settings for different displays, but I'm quite certain it's possible.

Regards
Dalai
#101164 Personal licence
Ryzen 5 2600, 16 GiB RAM, ASUS Prime X370-A, Win7 x64

Plugins: Services2, Startups, CertificateInfo, SignatureInfo, LineBreakInfo - Download-Mirror
User avatar
ghisler(Author)
Site Admin
Site Admin
Posts: 48021
Joined: 2003-02-04, 09:46 UTC
Location: Switzerland
Contact:

Re: Resolution-issue opening Excel-files from TC

Post by *ghisler(Author) »

There is no need to start TC with high DPI settings - you can change the DPI dialogs inside of Total Commander in
Configuration - Options - Font - Set dots per inch
This will not be passed to apps called from TC.
Author of Total Commander
https://www.ghisler.com
kvex
Junior Member
Junior Member
Posts: 5
Joined: 2022-03-28, 19:26 UTC

Re: Resolution-issue opening Excel-files from TC

Post by *kvex »

@Dalai and ghisler: thanks for your clarifications! I was still using 8.51a, so I switched to 10.00 and found the DPI setting you mentioned. Everything works fine now.
Post Reply