This project has moved and is read-only. For the latest updates, please go here.

Formulas in named ranges causing corruption on saving file

Jan 4, 2013 at 6:52 AM
Edited Jan 4, 2013 at 6:54 AM

Are formulas in named ranges supported?  I'm having trouble with a spreadsheet which has some pre-defined named ranges in it.  When I save the file, the file is corrupted and can't be opened by excel  The range is defined as,


The file with this named range is called test_simple.xlsm

When I run the following code, the resulting file test_simple1.xlsm can't be opend by Excel (complains of corruption).  Any help would be appreciated.


var tmp = @"c:\temp\test_simple1.xlsm";
            File.Copy(@"c:\temp\test_simple.xlsm", tmp, true);

            using (ExcelPackage oo = new ExcelPackage(new FileInfo(tmp)))