incubator-ooo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Regina Henschel <rb.hensc...@t-online.de>
Subject Re: request for enchancement of the define name function in calc
Date Wed, 08 Aug 2012 09:00:00 GMT
Hi shzh zhao,

there is no need for modifying ODF, named-expressions with scope on one 
sheet are already specified and LibreOffice reads and writes such documents.

I think the order should be the other way round. First make AOO read and 
write such named-expressions in ODF and then improve the import and 
export filter.

Kind regards
Regina

shzh zhao schrieb:
> 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
>


Mime
View raw message