I have a spreadsheet with some defined constants， for example, A1 is 3e8 and the name of A1 is defined as speed_of_light. Now I would like to copy these pre-defined constants to a new spreadsheet, so I can use these constants. The problem is the name of the cell is lost during this process, I can no longer use speed_of_light at the new spread sheet.
How can I copy the named cell to a new spreadsheet without loose its name?
Thanks a lot for your help!