{"action":"closed","issue":{"url":"https://api.github.com/repos/KleeGroup/vertigo-extensions/issues/12","repository_url":"https://api.github.com/repos/KleeGroup/vertigo-extensions","labels_url":"https://api.github.com/repos/KleeGroup/vertigo-extensions/issues/12/labels{/name}","comments_url":"https://api.github.com/repos/KleeGroup/vertigo-extensions/issues/12/comments","events_url":"https://api.github.com/repos/KleeGroup/vertigo-extensions/issues/12/events","html_url":"https://github.com/KleeGroup/vertigo-extensions/issues/12","id":258485284,"number":12,"title":"[Quarto] [Excel export] Timestamp support","user":{"login":"sebez","id":9380855,"avatar_url":"https://avatars1.githubusercontent.com/u/9380855?v=4","gravatar_id":"","url":"https://api.github.com/users/sebez","html_url":"https://github.com/sebez","followers_url":"https://api.github.com/users/sebez/followers","following_url":"https://api.github.com/users/sebez/following{/other_user}","gists_url":"https://api.github.com/users/sebez/gists{/gist_id}","starred_url":"https://api.github.com/users/sebez/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sebez/subscriptions","organizations_url":"https://api.github.com/users/sebez/orgs","repos_url":"https://api.github.com/users/sebez/repos","events_url":"https://api.github.com/users/sebez/events{/privacy}","received_events_url":"https://api.github.com/users/sebez/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2017-09-18T13:45:55Z","updated_at":"2017-12-07T16:51:33Z","closed_at":"2017-12-07T16:51:33Z","author_association":"NONE","body":"## Current behaviour\r\n\r\nCurrently, the Excel export in `Quarto` only supports Date fields with a hard-coded date-only format.\r\n\r\nIf my Date field is a timestamp, the time part is not displayed in the resulting Excel sheet. => KO\r\n**Notice** : The value in the Excel sheet is a valid full timestamp. The issue is only on the displaying of the value.\r\n\r\nDiving in the API, it seems the new Java 8 types `LocalDate` and `ZonedDateTime` and are not supported.\r\n\r\nhttps://github.com/KleeGroup/vertigo-extensions/blob/c07d60af0cc8d692132d896d540f9074f1c54fe2/vertigo-quarto/src/main/java/io/vertigo/quarto/plugins/export/xls/XLSExporter.java#L196\r\n\r\n```java\r\n// Date\r\nfinal HSSFCellStyle oddDateCellStyle = createRowCellStyle(workbook, true);\r\nfinal HSSFCellStyle evenDateCellStyle = createRowCellStyle(workbook, true);\r\noddDateCellStyle.setDataFormat(HSSFDataFormat.getBuiltinFormat(\"m/d/yy\" /* \"m/d/yy h:mm\" */));\r\nevenDateCellStyle.setDataFormat(HSSFDataFormat.getBuiltinFormat(\"m/d/yy\" /* \"m/d/yy h:mm\" */));\r\noddHssfStyleCache.put(DataType.Date, oddDateCellStyle);\r\nevenHssfStyleCache.put(DataType.Date, evenDateCellStyle);\r\n```\r\n\r\n## Expected behaviour\r\n\r\nIt should be possible to export Timestamp fields in the Excel export."}}
{"actor":{"display_login":"mlaroche"}}