title: EPPlus - Named Range is there but not working
body: <p>Similar to
  <a href="https://stackoverflow.com/questions/21871976/epplus-named-range-is-not-populated">EPPlus - Named Range is not populated</a><br>
  In his case, his ranges were at the workbook level but he was looking at the worksheet level.
  My EP code shows a count of 0 ranges at the workbook level and 15 at the sheet level, as it should be.
  Opening the worksheet.Names shows all 15, with proper names.</p>
  
  <p>Retrieve a range, and the formula is correct with<br>
  "OFFSET(Sheet1!$A$33, 0, Sheet1!_CurrentMonth, 1, 55 -Sheet1!_CurrentMonth)", but almost everything else returns an exception on evaluation.<br>
  It reports 1 column, which is incorrect.<br>
  And the 'FullAddress' looks correct with "'Sheet1'!_Fund1Projected", but 'FullAddressAbsolute' gives "$#REF!$-1"</p>
  
  <p>Lastly, I'm using a template, xltm, to create a spreadsheet, xlsm.</p>
  
  <pre><code>        public static void CreateChart()
      {
          var excelFullPath = "C:\\Users\\username\\Documents\\Excel\\Templates\\";
          var excelFileName = "LowCashBalanceChart.xlsm";
          FileInfo newFile = new FileInfo(excelFullPath + excelFileName);
          if (newFile.Exists)
             newFile.Delete();
          FileInfo template = new FileInfo(excelFullPath + "Sample Chart.xltm");
          using (ExcelPackage xlPackage = new ExcelPackage(newFile, template))
          {
              ExcelWorksheet worksheet = xlPackage.Workbook.Worksheets["Sheet1"]; //xlPackage.Workbook.Worksheets.FirstOrDefault(); 
              ExcelNamedRange namedRange;
              namedRange = xlPackage.Workbook.Names["_Fund1Projected"]; // fails, no ranges at the WB level
              namedRange = worksheet.Names["_Fund1Projected"]; // this one works               
              for (int rowIndex = namedRange.Start.Row; rowIndex &lt;= namedRange.End.Row; rowIndex++)  // Exception on range.Start
              // 'namedRange.Start' threw an exception of type 'System.ArgumentOutOfRangeException'
              {
                  for (int columnIndex = namedRange.Start.Column; columnIndex &lt;= namedRange.End.Column; columnIndex++)
                  {
                      worksheet.Cells[rowIndex, columnIndex].Value = (rowIndex * 100 + columnIndex).ToString();
  
                  }
              }
  
              xlPackage.Save();
          }
      }
  </code></pre>
  
  <p>I looked at the code on GitHub, but nothing stands out.<br>
  Tried it with the ranges at the workbook level as well with the same results. </p>