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
205
Copy/Paste from/to excel copies only visible decimals
posted

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,35
5,35    5,35
5,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,346
5,346    5,346
5,346    5,346

in multiple formats, but never with all decimals in it

Kind Regards

Ralph Bariz

(AVL List GmbH)