{"action":"created","issue":{"url":"https://api.github.com/repos/JanKallman/EPPlus/issues/196","repository_url":"https://api.github.com/repos/JanKallman/EPPlus","labels_url":"https://api.github.com/repos/JanKallman/EPPlus/issues/196/labels{/name}","comments_url":"https://api.github.com/repos/JanKallman/EPPlus/issues/196/comments","events_url":"https://api.github.com/repos/JanKallman/EPPlus/issues/196/events","html_url":"https://github.com/JanKallman/EPPlus/issues/196","id":316798499,"number":196,"title":"Can’t get custom date format to only display the day of the month","user":{"login":"flindr","id":17991532,"avatar_url":"https://avatars2.githubusercontent.com/u/17991532?v=4","gravatar_id":"","url":"https://api.github.com/users/flindr","html_url":"https://github.com/flindr","followers_url":"https://api.github.com/users/flindr/followers","following_url":"https://api.github.com/users/flindr/following{/other_user}","gists_url":"https://api.github.com/users/flindr/gists{/gist_id}","starred_url":"https://api.github.com/users/flindr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/flindr/subscriptions","organizations_url":"https://api.github.com/users/flindr/orgs","repos_url":"https://api.github.com/users/flindr/repos","events_url":"https://api.github.com/users/flindr/events{/privacy}","received_events_url":"https://api.github.com/users/flindr/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-04-23T12:51:19Z","updated_at":"2018-04-25T19:41:06Z","closed_at":null,"author_association":"NONE","body":"I have a date 1/1/2018 and I want it displayed as just 1. I set the custom formatting type to just ‘d’.\r\nIn Excel it is displayed as it should but when I read the cell.Text property it’s set to 1/1/2018. If I set the type to ‘dd’ it is displayed as 01, 02 etc. Correctly as it should.\r\nI tried in OpenOffice to set the format ‘d’ and it works there (OpenOffice API is used in Epplus right?)\r\n\r\nRepro steps:\r\n1.\tLoad the attached file with Epplus.\r\n2.\tRead cells B2 (format ‘d’) and C2 (format ‘dd’).\r\n3.\tText property on cell B2 will read 01/01/2018 but should be 1.\r\n4.\tText property on cell C2 will read 01 as it should be.\r\n\r\nEdit: Excel file is attached.\r\n\r\n![image](https://user-images.githubusercontent.com/17991532/39127522-93198ce0-4705-11e8-8478-fd52a424c1df.png)\r\n\r\n![image](https://user-images.githubusercontent.com/17991532/39127529-964f7c4e-4705-11e8-947e-6c7b45a46ad3.png)\r\n\r\n[dateformatbug.xlsx](https://github.com/JanKallman/EPPlus/files/1938232/dateformatbug.xlsx)\r\n"},"comment":{"url":"https://api.github.com/repos/JanKallman/EPPlus/issues/comments/384409797","html_url":"https://github.com/JanKallman/EPPlus/issues/196#issuecomment-384409797","issue_url":"https://api.github.com/repos/JanKallman/EPPlus/issues/196","id":384409797,"user":{"login":"JanKallman","id":982881,"avatar_url":"https://avatars2.githubusercontent.com/u/982881?v=4","gravatar_id":"","url":"https://api.github.com/users/JanKallman","html_url":"https://github.com/JanKallman","followers_url":"https://api.github.com/users/JanKallman/followers","following_url":"https://api.github.com/users/JanKallman/following{/other_user}","gists_url":"https://api.github.com/users/JanKallman/gists{/gist_id}","starred_url":"https://api.github.com/users/JanKallman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JanKallman/subscriptions","organizations_url":"https://api.github.com/users/JanKallman/orgs","repos_url":"https://api.github.com/users/JanKallman/repos","events_url":"https://api.github.com/users/JanKallman/events{/privacy}","received_events_url":"https://api.github.com/users/JanKallman/received_events","type":"User","site_admin":false},"created_at":"2018-04-25T19:41:06Z","updated_at":"2018-04-25T19:41:06Z","author_association":"OWNER","body":"d was incorrectly transformed as the shortdate format (in .NET). The problem should now be fixed. \r\nEPPlus don't us the ooxml sdk. "}}
{"actor":{"display_login":"JanKallman"}}