Hi :) Have you been able to post a bug-report about this already? Sounds like people might have narrowed it down quite a bit (to specific LO version and specific OS?) Also tried the standard rename User Profile and a couple other things? So, time for a bug-report? http://wiki.documentfoundation.org/Bug_Report Regards from Tom :)
>________________________________ > From: bblackmoor <bblackm...@blackgate.net> >To: users@global.libreoffice.org >Sent: Wednesday, 21 November 2012, 16:13 >Subject: [libreoffice-users] Re: Calc bug - when sheet is deleted, named >ranges are un-defined > >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 > > > > -- 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