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?

Comments

  • edited 12:23PM
    I'm testing this product to move from ReportBuilder, and I have the same problem.

    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.

  • edited 12:23PM
    Export as .cvs and open it with Excel.

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.