office plugin linking to word's language setting, doesn't always run.

[hazel-intelligentediting]

I've been working in a Office plugin using uno to allow us to keep our existing xaml files. I have set up Resource Strings to allow language settings, these settings need to be read of the office configuration:

function getOfficeLanguage() {
    const language = Office.context.displayLanguage;
    console.log(`Office language: ${language}`);
    return language;
}

Then in C# in the App.xaml.cs file:

using Windows.Globalization;
using Uno.Foundation;

public App()
{
     ...
     ApplicationLanguages.PrimaryLanguageOverride = WebAssemblyRuntime.InvokeJS("getOfficeLanguage()");
     ...
}

When this runs then console displays

Office language: es-MX

However mainly this is just not there, here is some of the console output near it:

Add officejs
Debugging hotkey: Shift+Alt+D (when application has focus)
Active service worker found, skipping register
IDBFS is not enabled in the project configuration, persistence is disabled. See https://aka.platform.uno/wasm-idbfs for more details
IDBFS is not enabled in the project configuration, persistence is disabled. See https://aka.platform.uno/wasm-idbfs for more details
IDBFS is not enabled in the project configuration, persistence is disabled. See https://aka.platform.uno/wasm-idbfs for more details
**Office language: es-MX**
dbug: Uno.Extensions.Navigation.RouteResolverDefault[0]

Mostly this is the output:

Add officejs
Debugging hotkey: Shift+Alt+D (when application has focus)
Active service worker found, skipping register
IDBFS is not enabled in the project configuration, persistence is disabled. See https://aka.platform.uno/wasm-idbfs for more details
IDBFS is not enabled in the project configuration, persistence is disabled. See https://aka.platform.uno/wasm-idbfs for more details
IDBFS is not enabled in the project configuration, persistence is disabled. See https://aka.platform.uno/wasm-idbfs for more details
dbug: Uno.Extensions.Navigation.RouteResolverDefault[0]

I decided to Enable IDBFS, incase it is linked, i'm not sure what IDBFS is for. now i get:

Add officejs
Debugging hotkey: Shift+Alt+D (when application has focus)
Active service worker found, skipping register
Making persistent: /local
Making persistent: /roaming
Making persistent: /shared
dbug: Uno.Extensions.Navigation.RouteResolverDefault[0]

or (when it works):

Add officejs
Debugging hotkey: Shift+Alt+D (when application has focus)
Active service worker found, skipping register
Making persistent: /local
Making persistent: /roaming
Making persistent: /shared
**Office language: es-MX**
dbug: Uno.Extensions.Navigation.RouteResolverDefault[0]

I thought the information from the js script is possibility cached someone so converted this to use an nesting function, however this didn't work.

When Office language: es-MX is in the console output the language updates, but mainly like 80% of the time it is simply missing from the console.

[jeromelaban]

Thanks for the question.

When it does not work, this would mean that the getOfficeLanguage() is not imported properly, or maybe too late. Try adding a try/catch around the call to WebAssemblyRuntime.InvokeJS("getOfficeLanguage()"); and do a Console.WriteLine with the exception, if any.

Note that it's best to use JSImport to call javascript functions.