I am on the road for the next few days, but I will figure out how to file a bug report when I get back.
"Tom [via Document Foundation Mail Archive]" <[email protected]> wrote: > > >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 <[email protected]> >>To: [email protected] >>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 >>[email protected] >>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: >[email protected] >>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: >[email protected] >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 > > > > > >_______________________________________________ >If you reply to this email, your message will be added to the >discussion below: >http://nabble.documentfoundation.org/Calc-bug-when-sheet-is-deleted-named-ranges-are-un-defined-tp4019919p4020305.html > >To unsubscribe from Calc bug - when sheet is deleted, named ranges are >un-defined, visit >http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4019919&code=YmJsYWNrbW9vckBibGFja2dhdGUubmV0fDQwMTk5MTl8LTYxNzM2MDc2Nw== -- Sent from my Android phone with K-9 Mail. Please excuse my brevity. -- View this message in context: http://nabble.documentfoundation.org/Calc-bug-when-sheet-is-deleted-named-ranges-are-un-defined-tp4019919p4020313.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: [email protected] 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
