NumberToTextConverter ignores locale

[Bykiev]

NPOI Version

latest

File Type

• XLSX
• XLS
• DOCX
• XLSM
• OTHER

Steps to reproduce

Thread.CurrentThread.CurrentCulture = CultureInfo.GetCultureInfo("ru-RU");
var res = NumberToTextConverter.ToText(1234.56);

Issue Description

NumberToTextConverter ignores locale and FormatGreaterThanOne, FormatLessThanOne always using dot as decimal separator, that's why DataFormatter fails in cultures with comma separator. To resolve the issue the new ToText(double value, CultureInfo locale) overload should be added.

[tonyqus]

I checked the code in https://github.com/apache/poi/blob/trunk/poi/src/main/java/org/apache/poi/ss/util/NumberToTextConverter.java. Looks to be same

[Bykiev]

Thank you, then it's a POI bug ;)