Memo formatted %2.2n in Rus Excel is NOT numeric!!
How I can get a numeric value in the Excel cell after export using TfrxXlsExport filter for russian locale settings?
Description:
In the russian locale ThousandSeparator is ' ' (space).
MemoView has following formatting:
m.DisplayFormat.FormatStr := '%2.2n';
m.DisplayFormat.Kind := fkNumeric;
Export filter configured as
TfrxXlsExport.FastExport := true;
TfrxXlsExport.AsText := false;
(other settings imho don't has action upon numeric format)
For the small digits that less then 1000 export done sucessfully - they are numberic in excel. Other digits has been export as text, for ex. '1_234_567,89', where '_' is the space (' ').
Anybody can help me?
Description:
In the russian locale ThousandSeparator is ' ' (space).
MemoView has following formatting:
m.DisplayFormat.FormatStr := '%2.2n';
m.DisplayFormat.Kind := fkNumeric;
Export filter configured as
TfrxXlsExport.FastExport := true;
TfrxXlsExport.AsText := false;
(other settings imho don't has action upon numeric format)
For the small digits that less then 1000 export done sucessfully - they are numberic in excel. Other digits has been export as text, for ex. '1_234_567,89', where '_' is the space (' ').
Anybody can help me?
Comments
I posted a message in this forum, in the newsgroup and also send a mail. But I no recieve any answer from FastReport support.
I read that some people have the same problem.