{"action":"created","issue":{"url":"https://api.github.com/repos/tfussell/xlnt/issues/77","repository_url":"https://api.github.com/repos/tfussell/xlnt","labels_url":"https://api.github.com/repos/tfussell/xlnt/issues/77/labels{/name}","comments_url":"https://api.github.com/repos/tfussell/xlnt/issues/77/comments","events_url":"https://api.github.com/repos/tfussell/xlnt/issues/77/events","html_url":"https://github.com/tfussell/xlnt/issues/77","id":186231282,"number":77,"title":"need explanation with reference row","user":{"login":"sukoi26","id":23014567,"avatar_url":"https://avatars.githubusercontent.com/u/23014567?v=3","gravatar_id":"","url":"https://api.github.com/users/sukoi26","html_url":"https://github.com/sukoi26","followers_url":"https://api.github.com/users/sukoi26/followers","following_url":"https://api.github.com/users/sukoi26/following{/other_user}","gists_url":"https://api.github.com/users/sukoi26/gists{/gist_id}","starred_url":"https://api.github.com/users/sukoi26/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sukoi26/subscriptions","organizations_url":"https://api.github.com/users/sukoi26/orgs","repos_url":"https://api.github.com/users/sukoi26/repos","events_url":"https://api.github.com/users/sukoi26/events{/privacy}","received_events_url":"https://api.github.com/users/sukoi26/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-10-31T08:45:19Z","updated_at":"2016-10-31T10:27:56Z","closed_at":null,"body":"in this code :\r\n```\r\n auto ws1 = wb.get_active_sheet();\r\n    ws1.set_title(\"range names\");\r\n\r\n        // set style\r\n    auto cell = ws1.get_cell(\"A10\");\r\n\r\n    cell.set_fill(xlnt::fill::solid(xlnt::color::yellow()));\r\n    ws1.get_cell(\"A10\").set_value(\"Fill Yellow\");\r\n\r\n    ws1.get_cell(\"A11\").set_value(xlnt::date(2010, 7, 13));\r\n\r\n //   for(xlnt::row_t row = 1; row < 40; row++)\r\n    xlnt::row_t row = 1;\r\n    for(xlnt::cell_reference(1, row); row < 40; row++)\r\n    {\r\n        // 10 c by  40 \r\n        std::vector<int> to_append(10, 0);\r\n        std::iota(std::begin(to_append), std::end(to_append), 0);\r\n        ws1.append(to_append);\r\n    }\r\n```\r\nthe ws.append function write after the last cell row  reference (11 here)\r\nhow to write  the values at the \"A1\" cell ? ws1 location of the reference  cell\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/tfussell/xlnt/issues/comments/257260010","html_url":"https://github.com/tfussell/xlnt/issues/77#issuecomment-257260010","issue_url":"https://api.github.com/repos/tfussell/xlnt/issues/77","id":257260010,"user":{"login":"sukoi26","id":23014567,"avatar_url":"https://avatars.githubusercontent.com/u/23014567?v=3","gravatar_id":"","url":"https://api.github.com/users/sukoi26","html_url":"https://github.com/sukoi26","followers_url":"https://api.github.com/users/sukoi26/followers","following_url":"https://api.github.com/users/sukoi26/following{/other_user}","gists_url":"https://api.github.com/users/sukoi26/gists{/gist_id}","starred_url":"https://api.github.com/users/sukoi26/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sukoi26/subscriptions","organizations_url":"https://api.github.com/users/sukoi26/orgs","repos_url":"https://api.github.com/users/sukoi26/repos","events_url":"https://api.github.com/users/sukoi26/events{/privacy}","received_events_url":"https://api.github.com/users/sukoi26/received_events","type":"User","site_admin":false},"created_at":"2016-10-31T10:27:55Z","updated_at":"2016-10-31T10:27:55Z","body":"I tried it without success\r\n```\r\n    xlnt::row_t row = 1;\r\n    for(xlnt::cell_reference(1, row); row < 40; row++)\r\n\r\n    {\r\n        // 10 c by  40 l\r\n        std::vector<int> to_append(10, 0);\r\n        std::iota(std::begin(to_append), std::end(to_append), 0);\r\n        //ws1.append(to_append);\r\n        xlnt::cell_reference next(1, 1);\r\n\r\n     for (auto cell : to_append)\r\n        {\r\n        ws1.get_cell(next).set_value(cell);\r\n        std::cout << ws1.get_cell(next) << std::endl;\r\n        next.set_column_index(next.get_column_index() + 1);\r\n        }\r\n\r\n    }\r\n```"}}
{"actor":{"display_login":"sukoi26"}}