[libreoffice-users] Re: Calc bug - when sheet is deleted, named ranges are un-defined

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]" <ml-node+s969070n4020305h35@n3.nabble.com> 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 <bblackmoor@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
> > bblackmoor@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+help@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+help@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
>
>
>
>
>
> _______________________________________________
> 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: users+help@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