Workarounds other than using a macro. I can program macros but that isn't the
point. The point is that this should have been working properly out of the
box without having to resort to a macro in the first place.

So please no macro suggestions.