Forums Ultimate UI for WPF
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Nikolay
370
Digit is inserted into Excel like a string
posted

Hi,

I have trouble with pasting data from xamDataGrid to excel. I have data in a grid as shown on the picture below.

                          

I copy some data, for example "11 994,00" and then insert it to Excel. But the digit inserted as a string because of a whitespace. Сan i avoid or handle this?

I tried to change the mask of xamNumericEditor for CellValuePresenter like a "nnnnnnn.nn", but rendering of a grid with dimensions approximately 20x100 cells terribly slows down.

Thanks in advance! Any help is strongly appreciated.

 

  • 54937
    Verified Answer
    Offline posted

    The current culture you are using uses a space as the group number separator so that is why there is a space in the display. The clipboard handling just uses the display text so that is why it is being copied in that manner. However it seems that Excel doesn't know to treat it as a number. I'm not sure that there is anything we can do on our end but I'll submit an issue for this so we can look into it. You could also try setting the Format property of the editor to something like "F2" that would not use the number grouping separator.

  • 370
    posted

    And yet. There are no whitespace between 11 and 994. There are not printed symbol between of them like a little letter 'o'. It is a real problem, not whitespace.