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
