EPPlus
EPPlus copied to clipboard
EPPlus sets addresses of defined names as absolute, even if it was relative when read from file.
A first fix for this will be to add an overload on Workbook.Names.Add and Worksheet.Names.Add that controls if a relative address should be retained. Next step will be to shift names in formula calculation if the address is relative which will be a separate activity.