Can this defined name issue be considered in your enhancement? https://issues.apache.org/ooo/show_bug.cgi?id=119565
Regards -- Jianyuan 2012/8/8 shzh zhao <aoo.zhaos...@gmail.com> > hi, > > here is an interoperability issue in Aoo. > When loading VBA that contains defined name in Aoo, the names are changed > to a new one if the name is limited > in a worksheet in MS office.This will cause big problem. > > After my investigation,I found it is an limitation of Aoo. Because MS Excel > 2003 can support worksheet scope defined name. but it can't be set in UI. > and Excel 2007 can define duplicate name for different sheet in its name > manager dialog. > When AOO loading a xlsx/xls file which has duplicated defined name, AOO > will only change the name to a unique one. But any other place which uses > the defined name is not changed, this is the root cause. > > this enchancement will be completed in 2 steps. > in Currently step, just focus on the interoperability of MS defined > name.,and not modify the ODF file format. > > if MS office defined range names with a sheet or a work book,import it in > Aoo, > make the name of work book in the original,but with a flag of global > name,for example,the name is "Name_1",it will be "Name_1" as before in > the define name dialog. > make the name of work sheet to the original,but with a flag of sheet > name,for > example,the name is "Name_1",it will be "Name_1 (sheet 1)" in the define > name > dialog if the name is defined in the sheet 1. > > here is the issue link: > https://issues.apache.org/ooo/show_bug.cgi?id=120478 > > -- > * > > > mailto: *aoo.zhaos...@gmail.com <https://google.com/profiles> > <https://google.com/profiles> >
