I have a particular problem because of a bug in Excel for Mac 2011 in Yosemite. I have discovered a workaround: by changing the Region setting, in SystemPreferences/Language & Region, to a non-GMT locale, the bug no longer occurs. For instance, if I change Region from United Kingdom, to Italy, the bug doesn't occur.
I've been developing a macro that runs an AppleScript, that in turn runs a shell script, to change the setting using the defaults utility. The shell script I'm using is this:
The intention being that on opening Excel, the application changes the value of AppleLocale, the bug is zapped and then, on closing, it changes AppleLocale back to what it as previously.
Changing the setting of AppleLocale programmatically on opening Excel works fine. But Excel only recognises this change if I then restart it. However, if I make the change using the System Preferences GUI, then I don't need to restart Excel for it to recognise the change.
I really want to avoid GUI Scripting, so I'm wondering if some clever bod out there might know why this scripted change isn't recognised. Do I need to do something else to force Excel to recognise the change?
Thanks for any help...
I've been developing a macro that runs an AppleScript, that in turn runs a shell script, to change the setting using the defaults utility. The shell script I'm using is this:
Code:
defaults write NSGlobalDomain AppleLocale en_GBChanging the setting of AppleLocale programmatically on opening Excel works fine. But Excel only recognises this change if I then restart it. However, if I make the change using the System Preferences GUI, then I don't need to restart Excel for it to recognise the change.
I really want to avoid GUI Scripting, so I'm wondering if some clever bod out there might know why this scripted change isn't recognised. Do I need to do something else to force Excel to recognise the change?
Thanks for any help...
