{"action":"created","issue":{"url":"https://api.github.com/repos/awalker89/openxlsx/issues/117","labels_url":"https://api.github.com/repos/awalker89/openxlsx/issues/117/labels{/name}","comments_url":"https://api.github.com/repos/awalker89/openxlsx/issues/117/comments","events_url":"https://api.github.com/repos/awalker89/openxlsx/issues/117/events","html_url":"https://github.com/awalker89/openxlsx/issues/117","id":101047286,"number":117,"title":"Page Breaks","user":{"login":"JKigotho","id":13800019,"avatar_url":"https://avatars.githubusercontent.com/u/13800019?v=3","gravatar_id":"","url":"https://api.github.com/users/JKigotho","html_url":"https://github.com/JKigotho","followers_url":"https://api.github.com/users/JKigotho/followers","following_url":"https://api.github.com/users/JKigotho/following{/other_user}","gists_url":"https://api.github.com/users/JKigotho/gists{/gist_id}","starred_url":"https://api.github.com/users/JKigotho/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JKigotho/subscriptions","organizations_url":"https://api.github.com/users/JKigotho/orgs","repos_url":"https://api.github.com/users/JKigotho/repos","events_url":"https://api.github.com/users/JKigotho/events{/privacy}","received_events_url":"https://api.github.com/users/JKigotho/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-08-14T16:28:57Z","updated_at":"2015-08-15T10:32:09Z","closed_at":null,"body":"Hi,\r\n\r\nThis package was a gamechager for me, esp with my high usage of excel in analysis.\r\n\r\nIs it possible to have an option for inserting pagebreaks? It would really be revolutionary.\r\n\r\nSecondly, the number format does not appear to be customizable after saving to excel. e.g, having negative numbers in brackets, red font, with commas and 2dp. \r\n\r\nFinally, detectDates was working just fine for me until i updated the package(on 14/08/2015). I ran the same code but it picked the dates as character. The code is as below, with two date columns. \r\n\r\nopen <- read.xlsx(xlsxFile = \"Customer_Open_Transaction_Listing_With_Cut_Off.xlsx\",sheet = 1,colNames = FALSE,startRow = 4, detectDates = TRUE)\r\n\r\nWill appreciate any help.\r\n\r\nBest package for R-excel users.\r\n\r\nThanks\r\nJoseph"},"comment":{"url":"https://api.github.com/repos/awalker89/openxlsx/issues/comments/131331940","html_url":"https://github.com/awalker89/openxlsx/issues/117#issuecomment-131331940","issue_url":"https://api.github.com/repos/awalker89/openxlsx/issues/117","id":131331940,"user":{"login":"JKigotho","id":13800019,"avatar_url":"https://avatars.githubusercontent.com/u/13800019?v=3","gravatar_id":"","url":"https://api.github.com/users/JKigotho","html_url":"https://github.com/JKigotho","followers_url":"https://api.github.com/users/JKigotho/followers","following_url":"https://api.github.com/users/JKigotho/following{/other_user}","gists_url":"https://api.github.com/users/JKigotho/gists{/gist_id}","starred_url":"https://api.github.com/users/JKigotho/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JKigotho/subscriptions","organizations_url":"https://api.github.com/users/JKigotho/orgs","repos_url":"https://api.github.com/users/JKigotho/repos","events_url":"https://api.github.com/users/JKigotho/events{/privacy}","received_events_url":"https://api.github.com/users/JKigotho/received_events","type":"User","site_admin":false},"created_at":"2015-08-15T10:32:09Z","updated_at":"2015-08-15T10:32:09Z","body":"Hi Alex,\n\nlooks like the latest version i'm able to get from the net is 3.0.0, which\ndoesn't have pagebreak functionality, but i see we're currently at 3.0.9.\n\nDo you think you could assist wit a link where i can get 3.0.9?\n\non my second and third queries, i'll send you a file and code once i'm able\nto consistently reporduce it.\n\nThanks and regards.\n\n\n\n\n\nOn Sat, Aug 15, 2015 at 5:02 AM, Alex <notifications@github.com> wrote:\n\n> 992392f\n> <https://github.com/awalker89/openxlsx/commit/992392f512d9cd688c23b597e75e784e00c2fb00>\n> adds pageBreak functionality. see ?pageBreak.\n>\n> Do you have examples I can run for your 2nd and 3rd queries?\n>\n> —\n> Reply to this email directly or view it on GitHub\n> <https://github.com/awalker89/openxlsx/issues/117#issuecomment-131279743>.\n>\n"}}