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