{"action":"closed","issue":{"url":"https://api.github.com/repos/ClosedXML/ClosedXML/issues/328","repository_url":"https://api.github.com/repos/ClosedXML/ClosedXML","labels_url":"https://api.github.com/repos/ClosedXML/ClosedXML/issues/328/labels{/name}","comments_url":"https://api.github.com/repos/ClosedXML/ClosedXML/issues/328/comments","events_url":"https://api.github.com/repos/ClosedXML/ClosedXML/issues/328/events","html_url":"https://github.com/ClosedXML/ClosedXML/issues/328","id":232554397,"number":328,"title":"IndexOutOfRangeException when trying to delete first column of named range","user":{"login":"aldobrynin","id":9074893,"avatar_url":"https://avatars1.githubusercontent.com/u/9074893?v=3","gravatar_id":"","url":"https://api.github.com/users/aldobrynin","html_url":"https://github.com/aldobrynin","followers_url":"https://api.github.com/users/aldobrynin/followers","following_url":"https://api.github.com/users/aldobrynin/following{/other_user}","gists_url":"https://api.github.com/users/aldobrynin/gists{/gist_id}","starred_url":"https://api.github.com/users/aldobrynin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/aldobrynin/subscriptions","organizations_url":"https://api.github.com/users/aldobrynin/orgs","repos_url":"https://api.github.com/users/aldobrynin/repos","events_url":"https://api.github.com/users/aldobrynin/events{/privacy}","received_events_url":"https://api.github.com/users/aldobrynin/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/ClosedXML/ClosedXML/milestones/2","html_url":"https://github.com/ClosedXML/ClosedXML/milestone/2","labels_url":"https://api.github.com/repos/ClosedXML/ClosedXML/milestones/2/labels","id":2412827,"number":2,"title":"v0.88","description":null,"creator":{"login":"igitur","id":145854,"avatar_url":"https://avatars2.githubusercontent.com/u/145854?v=3","gravatar_id":"","url":"https://api.github.com/users/igitur","html_url":"https://github.com/igitur","followers_url":"https://api.github.com/users/igitur/followers","following_url":"https://api.github.com/users/igitur/following{/other_user}","gists_url":"https://api.github.com/users/igitur/gists{/gist_id}","starred_url":"https://api.github.com/users/igitur/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/igitur/subscriptions","organizations_url":"https://api.github.com/users/igitur/orgs","repos_url":"https://api.github.com/users/igitur/repos","events_url":"https://api.github.com/users/igitur/events{/privacy}","received_events_url":"https://api.github.com/users/igitur/received_events","type":"User","site_admin":false},"open_issues":4,"closed_issues":28,"state":"open","created_at":"2017-03-27T08:24:29Z","updated_at":"2017-06-22T11:53:45Z","due_on":null,"closed_at":null},"comments":1,"created_at":"2017-05-31T12:52:36Z","updated_at":"2017-06-22T11:53:45Z","closed_at":"2017-06-22T11:53:45Z","body":"Hi!\r\nWhen I'm deleting first column (only the first one) of named range in my worksheet I get InvalidOperationException. If you delete second, third... last one - it works as expected. (Removes column and updates named range address ranges).\r\n\r\nHere is the unit test code which reproduces bug:\r\n```c#\r\n        [Test]\r\n        public void DeleteColumnUsedInNamedRange()\r\n        {\r\n            var wb = new XLWorkbook();\r\n            IXLWorksheet ws = wb.AddWorksheet(\"Sheet1\");\r\n            ws.FirstCell().SetValue(\"Test\").Style.Font.SetBold();\r\n            ws.FirstColumn().CopyTo(ws.Column(2));\r\n            ws.FirstColumn().CopyTo(ws.Column(3));\r\n            ws.NamedRanges.Add(\"range\", \"A1:C1\");\r\n\r\n            ws.Column(1).Delete();\r\n\r\n            Assert.IsTrue(ws.Cell(\"A1\").Style.Font.Bold);\r\n            Assert.AreEqual(\"Test\",ws.Cell(\"B1\").GetValue<string>());\r\n            Assert.IsEmpty(ws.Cell(\"C1\").GetValue<string>());\r\n        }"}}
{"actor":{"display_login":"igitur"}}