The procedure below will also reproduce the bug. (I did this to see if moving the named ranges to a different tab would make any difference. It did not.)
1) Open Bulletproof_Blues_CSH_b0.11.ods in LibreOffice calc. Note that on sheet "Attributes", in the column "Benchmark", it says "Lift: 225 lbs.". Note that sheet "Tables" has a number of named ranges ("ATTRIBUTE_LIST", for example). 2) Rename sheet "Tables" to "Tables_old." 3) Create new sheet to the right of "Tables_old" called "Tables". 4) Select all of the entered data on "Tables_old". 5) Cut the data from "Tables_old". 6) Paste the data from "Tables_old" to "Tables". 7) Delete sheet "Tables_old". 8) Delete sheet 'PrintSheet". 9) Save document as Bulletproof_Blues_CSH_b0.12.ods 10) Close LibreOffice Calc. 11) Open LibreOffice Calc. 12) Open Bulletproof_Blues_CSH_b0.12.ods in LibreOffice calc. 13) Note that sheet on "Attributes", in the column "Benchmark", it says "#NAME?". Note that many -- but not all -- of the named ranges on sheet "Tables" are no longer defined ("ATTRIBUTE_LIST", for example). -- Kind regards, Brandon Blackmoor bblackm...@blackgate.net 2012-11-21 -- View this message in context: http://nabble.documentfoundation.org/Calc-bug-when-sheet-is-deleted-named-ranges-are-un-defined-tp4019919p4020046.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted