[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]"
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
>>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
>
>
>
>
>
>___
>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+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
[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
[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
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-tp4019919p4020042.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
[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:
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
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-tp4019919p4020041.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
[libreoffice-users] Re: Calc bug - when sheet is deleted, named ranges are un-defined
On Wed, Nov 21, 2012, at 1:08, Jay Lozier [via Document Foundation Mail Archive] wrote: > > On 11/21/2012 12:43 AM, bblackmoor wrote: >> I've found a bug in LibreOffice Calc. If I have named ranges in a sheet >> (let's call it Sheet 7), and I delete a sheet to the left of that sheet >> (let's call it Sheet 6), some (not all) of the named ranges in Sheet 7 >> disappear. The data is still there on the sheet, but the name of the range >> is gone. If you look at Insert >> Names >> Manage... , some of the named >> ranges that had been defined on Sheet 7 are simply not there anymore. >> >> Is this a known bug? Is there a workaround that doesn't involve either >> re-naming ranges or never deleting any sheets? > > Which version of LO are using and what OS are using? LibreOffice Version 3.6.3.2 (Build ID: 58f22d5) Windows 7, Service Pack 1 -- 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-tp4019919p4019922.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
[libreoffice-users] Calc bug - when sheet is deleted, named ranges are un-defined
I've found a bug in LibreOffice Calc. If I have named ranges in a sheet (let's call it Sheet 7), and I delete a sheet to the left of that sheet (let's call it Sheet 6), some (not all) of the named ranges in Sheet 7 disappear. The data is still there on the sheet, but the name of the range is gone. If you look at Insert >> Names >> Manage... , some of the named ranges that had been defined on Sheet 7 are simply not there anymore. Is this a known bug? Is there a workaround that doesn't involve either re-naming ranges or never deleting any sheets? -- View this message in context: http://nabble.documentfoundation.org/Calc-bug-when-sheet-is-deleted-named-ranges-are-un-defined-tp4019919.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
