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

On Wed, Nov 21, 2012, at 10:20, Jay Lozier [via Document Foundation Mail
Archive] wrote:
> I am not able to reproduce the problem with 3.6.3.2 on Linux Mint 13. 
> Can you post either the actual before/after files on Nabble or an 
> example set?


I have reproduced this on two different computers, both running:

LibreOffice Version 3.6.3.2 (Build ID: 58f22d5)
Windows 7, Service Pack 1

Steps to reproduce:

1)  Open Bulletproof_Blues_CSH_b0.11.ods in LibreOffice calc.
    http://www.kaloscomics.com/wp-content/uploads/2012/11/Bulletproof_Blues_CSH_b0.11.ods
    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) Delete sheet 'PrintSheet".

3) Save document as Bulletproof_Blues_CSH_b0.12.ods

4) Close LibreOffice Calc.

5) Open LibreOffice Calc.

6) Open Bulletproof_Blues_CSH_b0.12.ods in LibreOffice calc.
    http://www.kaloscomics.com/wp-content/uploads/2012/11/Bulletproof_Blues_CSH_b0.12.ods

7) 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-tp4019919p4020042.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