[libreoffice-users] named data ranges

Hello again
I appear to be experiencing a problem with named data ranges lo 5.2.2.2 x64 win 7.

Q. Is it possible and permissible to define overlapping data ranges? I want a range named mdec 
which will be A1:B25 and another xlit B1:C25 (the col B values are common) to use in lookups. 

I have set them up and they appear ok in the Define Database Range dialog. However, when i try to 
enter xlit as the range in a formula i find that it automatically gets changed to mdec.

Im going now to try with the ranges defined explicitly instead of using the names, but i wonder if 
this problem sounds at all familiar to anyone, and if theres anything i can do about it?

Thanks
Gary

-- 
To unsubscribe e-mail to: users+unsubscribe@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