Hi Cor

I hope I am doing the correct thing by sending the requested files with this mail?

Please let me know if I need to do things differently (this is my first bug report)

Instructions to reproduce the problem:

Look at the VLookups in FILE1 on the sheet "MASTER SUMMARY" columns C to I. They refer to the named range KPLAN1

1. Copy the content of "Sheet1", FILE2, and paste to the sheet "ROUNDING", FILE1
2. Return to sheet "MASTER SUMMARY" and look at the formulas: the named range "BAND_TWO" has replaced KPLAN1 (BAND_TWO is a named range, Sheet "ROUNDING", cell E7)
3. Try editing one of the VLookups, replacing BAND_TWO with KPLAN1 - when I do this it immediately reverts to BAND_TWO, and returns ERR 502

I hope that you can see what is happening?

Regards

Adrian

Read our blog, become a Facebook fan, follow us on Twitter or see product images and more on Flickr

Brabantia (UK) Limited's standard conditions of sale apply to all goods purchased from Brabantia (UK) Limited to the exclusion of any other terms and conditions. A full copy of Brabantia's standard conditions of sale can be found on our website at http://brabantia.com/en/legal-information/

Brabantia (UK) Limited, registered in England & Wales with company number 4936679, is authorised for the sale of Brabantia Branded products for resale in the United Kingdom only. Contact our local representatives whose details are available at our website on http://brabantia.com/en/company/offices/ for sales of Brabantia Branded products outside of the United Kingdom. Please note you may not supply, distribute or sell Brabantia Branded products bought from Brabantia (UK) Limited outside of the European Economic Area.

Price and product proposals must be accepted within 30 days to be valid.

> -----Original message-----
> From: bugzilla-daemon@freedesktop.org
> Sent: Wed 31-07-2013 14:29
> Subject: [Bug 67581] Copying cells with named ranges from one spreadsheet to another corrupts formula references to preexisting named ranges in target spreadsheet
> To: Adrian Wagland <a.wagland@brabantia.com>;
> Cor Nouws changed bug 67581

> What | Removed | Added
> --- | --- | ---
> CC |  | cno@nouenoff.nl
> Summary | COPYING CELLS WITH NAMED RANGES FROM ONE SPREADSHEET TO ANOTHER CORRUPTS FORMULA REFERENCES TO PREEXISTING NAMED RANGES IN TARGET SPREADSHEET | Copying cells with named ranges from one spreadsheet to another corrupts formula references to preexisting named ranges in target spreadsheet

> Comment # 1 on bug 67581 from Cor Nouws

>     Thanks for the clear description, Adrian. I 'muted' the summary, was a bit LOUD ;)  Do you pls, for the ease of people doing QA, have some test files? Best, Cor

> You are receiving this mail because:
> - You reported the bug.

Click here for the Brabantia disclaimer.