incubator-ooo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lei Wang <l...@apache.org>
Subject Re: request for enchancement of the define name function in calc
Date Wed, 08 Aug 2012 09:27:40 GMT
Hi,

May be Shao Zhi do not clearly state his proposal. Let me try again.

Excel 2007 can define same name for different sheet. When AOO loading a
xlsx file which has duplicated defined name, AOO will only change the name.
But any other place which uses the defined name is not changed, which will
cause problems.

We want to do some enhancement. This enhancement will be completed in 2
steps.

In step 1, we want to just focus on the interoperability with sheet scoped
defined name in Excel.
When user open a Excel file which has range based defined name, the
duplicated range name will be kept. AOO will use sheet scoped name in prior
to workbook scoped name when do calculation. And some indicator is shown in
name define dialog.
In step 1 we will not modify the ODF file format. When save Excel xls/xlsx
file with sheet scoped defined name to ods file, AOO will rename sheet
scoped defined name as "sheet_name" plus "defined name", like
SheetName_DefinedName.

In step 2, we want to support create worksheet scope defined name from GUI.
At that time, we will modify ODF file format to save sheet scoped range
name in ods. We will refer the file format from LibreOffice if their
implementation is in ODF standard or ODF standard candidate.


On Wed, Aug 8, 2012 at 5:00 PM, Regina Henschel <rb.henschel@t-online.de>wrote:

> 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<https://issues.apache.org/ooo/show_bug.cgi?id=120478>
>>
>>
>

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