{"action":"created","issue":{"url":"https://api.github.com/repos/westonganger/spreadsheet_architect/issues/3","repository_url":"https://api.github.com/repos/westonganger/spreadsheet_architect","labels_url":"https://api.github.com/repos/westonganger/spreadsheet_architect/issues/3/labels{/name}","comments_url":"https://api.github.com/repos/westonganger/spreadsheet_architect/issues/3/comments","events_url":"https://api.github.com/repos/westonganger/spreadsheet_architect/issues/3/events","html_url":"https://github.com/westonganger/spreadsheet_architect/issues/3","id":140479834,"number":3,"title":"Number and Date formats","user":{"login":"robbytobby","id":1087033,"avatar_url":"https://avatars.githubusercontent.com/u/1087033?v=3","gravatar_id":"","url":"https://api.github.com/users/robbytobby","html_url":"https://github.com/robbytobby","followers_url":"https://api.github.com/users/robbytobby/followers","following_url":"https://api.github.com/users/robbytobby/following{/other_user}","gists_url":"https://api.github.com/users/robbytobby/gists{/gist_id}","starred_url":"https://api.github.com/users/robbytobby/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/robbytobby/subscriptions","organizations_url":"https://api.github.com/users/robbytobby/orgs","repos_url":"https://api.github.com/users/robbytobby/repos","events_url":"https://api.github.com/users/robbytobby/events{/privacy}","received_events_url":"https://api.github.com/users/robbytobby/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":7,"created_at":"2016-03-13T12:03:55Z","updated_at":"2016-03-20T17:54:06Z","closed_at":null,"body":"First of all: Nice gem, makes generating spreadsheets easy with only a few lines of code. Thanks.\r\n\r\nI've got some issues with formatting though:\r\n\r\n**in .xlsx and .ods:**\r\nwhen outputting a localized date (e.g 31.1.2010)  the cell value is preceded with a single quote ('). So I cannot work with any date functions of LibreOffice on that value.\r\nif I do not localize the value, I get the integer representation. I admit, I can just format that column as date manually in LibreOffice, but most users will not see that little workaround.\r\n\r\n**in .ods only:**\r\nwhen outputting an integer, it is as well preceded with a \" ' \", so the cell is a text value. When outputting a float, the cell uses a dot as the decimal sign, which leads to the problem, that the value is interpreted as text in (german) LibreOffice. \r\nNote: both integer and float work in .xlsx spreadsheets.\r\n\r\nps: \r\nspreadsheet_architect 1.2.0\r\naxlsx 2.1.0.pre"},"comment":{"url":"https://api.github.com/repos/westonganger/spreadsheet_architect/issues/comments/198974313","html_url":"https://github.com/westonganger/spreadsheet_architect/issues/3#issuecomment-198974313","issue_url":"https://api.github.com/repos/westonganger/spreadsheet_architect/issues/3","id":198974313,"user":{"login":"westonganger","id":3414795,"avatar_url":"https://avatars.githubusercontent.com/u/3414795?v=3","gravatar_id":"","url":"https://api.github.com/users/westonganger","html_url":"https://github.com/westonganger","followers_url":"https://api.github.com/users/westonganger/followers","following_url":"https://api.github.com/users/westonganger/following{/other_user}","gists_url":"https://api.github.com/users/westonganger/gists{/gist_id}","starred_url":"https://api.github.com/users/westonganger/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/westonganger/subscriptions","organizations_url":"https://api.github.com/users/westonganger/orgs","repos_url":"https://api.github.com/users/westonganger/repos","events_url":"https://api.github.com/users/westonganger/events{/privacy}","received_events_url":"https://api.github.com/users/westonganger/received_events","type":"User","site_admin":false},"created_at":"2016-03-20T17:54:06Z","updated_at":"2016-03-20T17:54:06Z","body":"For me on master using LibreoOffice on OSX with ods and xlsx I am not getting the `'` on integers or floats numbers."}}