incubator-ooo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From shzh zhao <>
Subject request for enchancement of the define name function in calc
Date Wed, 08 Aug 2012 07:21:51 GMT

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:


mailto: * <>

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message