{"action":"created","issue":{"url":"https://api.github.com/repos/dfinke/ImportExcel/issues/168","repository_url":"https://api.github.com/repos/dfinke/ImportExcel","labels_url":"https://api.github.com/repos/dfinke/ImportExcel/issues/168/labels{/name}","comments_url":"https://api.github.com/repos/dfinke/ImportExcel/issues/168/comments","events_url":"https://api.github.com/repos/dfinke/ImportExcel/issues/168/events","html_url":"https://github.com/dfinke/ImportExcel/issues/168","id":209105891,"number":168,"title":"Export-Excel: Numeric values not correct","user":{"login":"DarkLite1","id":10828570,"avatar_url":"https://avatars.githubusercontent.com/u/10828570?v=3","gravatar_id":"","url":"https://api.github.com/users/DarkLite1","html_url":"https://github.com/DarkLite1","followers_url":"https://api.github.com/users/DarkLite1/followers","following_url":"https://api.github.com/users/DarkLite1/following{/other_user}","gists_url":"https://api.github.com/users/DarkLite1/gists{/gist_id}","starred_url":"https://api.github.com/users/DarkLite1/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/DarkLite1/subscriptions","organizations_url":"https://api.github.com/users/DarkLite1/orgs","repos_url":"https://api.github.com/users/DarkLite1/repos","events_url":"https://api.github.com/users/DarkLite1/events{/privacy}","received_events_url":"https://api.github.com/users/DarkLite1/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2017-02-21T10:43:33Z","updated_at":"2017-02-21T14:39:22Z","closed_at":null,"body":"Consider the following code:\r\n\r\n```\r\nif (!($TempFolder = $env:TEMP + '\\TestFolder')) {\r\n    New-Item -Path $TempFolder -ItemType Directory\r\n}\r\n\r\n$F = New-Object System.IO.FileStream ($TempFolder + '\\File1.txt'), Create, ReadWrite\r\n$F.SetLength(763905024)\r\n$F.Close()\r\n\r\n$F = New-Object System.IO.FileStream ($TempFolder + '\\File2.txt'), Create, ReadWrite\r\n$F.SetLength(1631405056)\r\n$F.Close()\r\n\r\n$F = New-Object System.IO.FileStream ($TempFolder + '\\File3.txt'), Create, ReadWrite\r\n$F.SetLength(271360)\r\n$F.Close()\r\n\r\n$F = New-Object System.IO.FileStream ($TempFolder + '\\File4.txt'), Create, ReadWrite\r\n$F.SetLength(417006592)\r\n$F.Close()\r\n\r\n$ExcelFile = $env:TEMP + '\\Excel.xlsx'\r\nif (Test-Path -Path $ExcelFile) {\r\n    Remove-Item -Path $ExcelFile -Force\r\n}\r\n\r\nGet-ChildItem -Path $TempFolder | \r\n    Select-Object Name, Length, @{Name=\"Mb\";Expression={'{0:N2}' -f ($_.Length/1Mb)}} |\r\n        Export-Excel $ExcelFile -Show\r\n```\r\n\r\nThis results in:\r\n![image](https://cloud.githubusercontent.com/assets/10828570/23161503/b1656406-f82a-11e6-94d4-4897f0443a22.png)\r\n\r\nAs you can see, the values behind the comma are discarded. \r\nExample: 0,26 becomes 26 in the Excel file.\r\n\r\nAlso, some cells are stored as text rather then number. see C3.\r\n"},"comment":{"url":"https://api.github.com/repos/dfinke/ImportExcel/issues/comments/281362276","html_url":"https://github.com/dfinke/ImportExcel/issues/168#issuecomment-281362276","issue_url":"https://api.github.com/repos/dfinke/ImportExcel/issues/168","id":281362276,"user":{"login":"dfinke","id":67258,"avatar_url":"https://avatars.githubusercontent.com/u/67258?v=3","gravatar_id":"","url":"https://api.github.com/users/dfinke","html_url":"https://github.com/dfinke","followers_url":"https://api.github.com/users/dfinke/followers","following_url":"https://api.github.com/users/dfinke/following{/other_user}","gists_url":"https://api.github.com/users/dfinke/gists{/gist_id}","starred_url":"https://api.github.com/users/dfinke/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dfinke/subscriptions","organizations_url":"https://api.github.com/users/dfinke/orgs","repos_url":"https://api.github.com/users/dfinke/repos","events_url":"https://api.github.com/users/dfinke/events{/privacy}","received_events_url":"https://api.github.com/users/dfinke/received_events","type":"User","site_admin":false},"created_at":"2017-02-21T14:39:22Z","updated_at":"2017-02-21T14:39:22Z","body":"I'll review"}}
{"actor":{"display_login":"dfinke"}}