Hi,
How the subject says only the visible decimals are copied from/to excel.
If I copy something from excel, sadly only the XML Spreadsheet mimetype contains all decimals but not the text type.
XML Spreadsheet Snippet:
<Cell ss:StyleID="s62"><Data ss:Type="Number">5.3456700000000001</Data></Cell> <Cell ss:StyleID="s62"><Data ss:Type="Number">5.3456700000000001</Data></Cell> </Row> <Row> <Cell ss:StyleID="s62"><Data ss:Type="Number">5.3456700000000001</Data></Cell> <Cell ss:StyleID="s62"><Data ss:Type="Number">5.3456700000000001</Data></Cell> </Row> <Row> <Cell ss:StyleID="s62"><Data ss:Type="Number">5.3456700000000001</Data></Cell> <Cell ss:StyleID="s62"><Data ss:Type="Number">5.3456700000000001</Data></Cell>
Text Snippet:
5,35 5,355,35 5,355,35 5,35
On the other hand the usual copy operation of the xamdatagrid when 3 decimals are visible but the number is 5,34567 produces only
5,346 5,3465,346 5,3465,346 5,346
in multiple formats, but never with all decimals in it
Kind Regards
Ralph Bariz
(AVL List GmbH)
Hello Ralph,
Thank you for your post!
I have been looking into it. If you want to show more than two digits after the floating point of the number, I can suggest to create a style for the XamNumericEditor and place it in the resources of the XamDataGrid for example. In the style you have to set the Mask property of the XamNumericEditor. Here is an example for the mask double:5.16. Setting the Mask this way you would be able to enter(paste) 5 numbers before the floating point and 16 numbers after it in the cell of the XamDataGrid. More about the masks you can find on the following link: http://help.infragistics.com/doc/WPF/2014.2/CLR4.0/?page=xamInputs_Masks.html.
Here is an example of the above mentioned style:
<Style TargetType="{x:Type igEditors:XamNumericEditor}">
<Setter Property="Mask" Value="{}{double:5.16}"/>
</Style>
Please do not hesitate to let me know if you have any further questions on this matter.
No, I want to SEE only as few digits, but I want to GET the complete data.
When I paste the data from excel into xamdatagrid(select cells in excel -> CTRL+C -> select a cell in the xamdatagrid -> CTRL+V), I get only whats visible in excel instead of the whole number(which you can see in the edit bar in excel). The reason is, xamdatagrid is using the text mime type for parsing the CLIPBOARD contents instead the XML Spreadsheet mime type. In the opposite I want to get the whole numbers in excel when I copy from xamdatagrid(select cells in xamdatagrid -> CTRL+C -> select a cell in excel -> CTRL+V). That is not working because xamdatagrid does not create the clipboardcontent with the whole data but only the shown.
I have been further researching the functionality you want to achieve. What I can suggest is to create a new product idea for this functionality. You can suggest new Product Ideas for future versions (or vote for existing ones) at http://ideas.infragistics.com.
Steps to create your idea:
1. Log into the Infragistics Product Ideas site at http://ideas.infragistics.com (creating a new login if needed).
2. Navigate to the product / platform channel of your choice (e.g. WPF, Windows Forms, ASP.NET, HTML5 / Ignite UI, iOS / NucliOS, etc.)
3. Add your product idea and be sure to be specific and provide as much detail as possible.
• Explain the context in which a feature would be used, why it is needed, why it can’t be accomplished today, and who would benefit from it. You can even add screenshots to build a stronger case. Remember that for your suggestion to be successful, you need other members of the community to vote for it. Be convincing!
• [CASE: “Reference case [case number], FORUMS: “Include a link to this thread”] in your idea so product management will be able to look back at this case.
The benefits of submitting the product idea yourself include:
- Direct communication with our product management team regarding your product idea.
- Notifications whenever new information regarding your idea becomes available.
Additional benefits of the Product Idea system include:
- Ability to vote on your favorite product ideas to let us know which ones are the most important to you. You will have ten votes for this and can change which ideas you are voting for at any time.
- Allow you to shape the future of our products by requesting new controls and products altogether.
- You and other developers can discuss existing product ideas with members of our Product Management team.
The product ideas site allows you to track the progress of your ideas at any time, see how many votes it got, read comments from other developers in the community, and see if someone from the product team has additional questions for you.
Thank you for contacting Infragistics.
I am just checking if you have any further questions on this matter. Please do not hesitate to let me know if you do.