Canvas number formatting must honor Space locale setting

[dolivanu]

Describe the feature:
Numeral formatting in Kibana is done through patterns with the Numeral.js library.

Numeral Formatting

Numeral formatting patterns are used in multiple places in Kibana, including: Canvas

These patterns should take into account the locale defined in each Space:

The display of these patterns is affected by the advanced setting format:number:defaultLocale. The default locale is en, but some examples will specify that they are using an alternate locale.

Canvas number formatting with the numberformat function does not honor the Space locale configuration, formatting always with the default en locale. This issue backs to 2019, stating in 2023 that this disparity between Dashboards (honors Space locale) and Canvas (does not honor Space locale, using always en) would not be fixed, aka Canvas would not honor Space locale setting and would format always with the default en locale.

Canvas does not use Kibana number formatting locale

[Canvas] [Discuss] How should Canvas use formatters?

Feature Request: Canvas should honor the Space locale setting, allowing formatting numbers with different locales like es for Spanish (Spain).

Describe a specific use case for the feature:

If you want to generate a pixel-perfect, paginated report using Kibana, the natural choice is Canvas as stated in the README:

Canvas is one of such applications, in particular catering to users looking for desktop-publishing level of control for the presentation of their data summaries.

Canvas focuses on highly customizable layout more suited to highly curated presentations...

Numeral formatting using locales other than en is required in countries outside the anglosphere when showing numbers with fractional part and/or big enough so the thousands separator is a must for legibility.

For example in the financial sector the monetary amounts normally are displayed with decimal separator and thousands separator. Abbreviations are not suitable in general as the exact number must be displayed.

[elasticmachine]

Pinging @elastic/kibana-presentation (Team:Presentation)

[Heenawter]

We are only prioritizing critical Canvas issues at the moment. Closing for now.