You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openoffice.apache.org by Jianyuan Li <li...@gmail.com> on 2012/06/07 10:08:13 UTC
Shape/Form control alt text import and export for Excel 2003
Hi, All,
In Excel 2003, for shape and form control, there is an attribute named "alt
text". But Aoo shape and form control do not have an attribute similar like
it. So when Aoo import them, this attribute will be omitted. And on
exporting it as an Excel 2003 file, this attribute will not be exported. So
on opening the export file in Excel 2003, incorrect attribute value will be
shown. There is a bug related to it:
https://issues.apache.org/ooo/show_bug.cgi?id=119659
To fix this issue, is there someone having a good solution? How about
import alt text as the title(in shape description dialog) in Aoo? And then
export the Aoo title as Excel 2007 alt text?
Re: Shape/Form control alt text import and export for Excel 2003
Posted by Oliver-Rainer Wittmann <or...@googlemail.com>.
Hi,
On 07.06.2012 10:08, Jianyuan Li wrote:
> Hi, All,
>
> In Excel 2003, for shape and form control, there is an attribute named "alt
> text". But Aoo shape and form control do not have an attribute similar like
> it. So when Aoo import them, this attribute will be omitted. And on
> exporting it as an Excel 2003 file, this attribute will not be exported. So
> on opening the export file in Excel 2003, incorrect attribute value will be
> shown. There is a bug related to it:
> https://issues.apache.org/ooo/show_bug.cgi?id=119659
>
> To fix this issue, is there someone having a good solution? How about
> import alt text as the title(in shape description dialog) in Aoo? And then
> export the Aoo title as Excel 2007 alt text?
>
I think it is a good idea to use the AOO's shape|form control attribute "title"
for the import and export of Microsoft Excel 2003 shape|form control attribute
"alt text".
Best regards, Oliver.
[Call for review][Issue 119903 fixed]Shape/Form control alt text
import and export for Excel 2003
Posted by Jianyuan Li <li...@gmail.com>.
For this topic, issue 119903 was created and has been fixed. Please help
review. Thanks!
The fix is only for Excel 2003 form control alt text import and export. I
used the AOO's Form control attribute "Description" for the import and
export of Microsoft Excel 2003 Form control attribute "alt text".
Issue desc: https://issues.apache.org/ooo/show_bug.cgi?id=119903
Patch: https://issues.apache.org/ooo/attachment.cgi?id=78233&action=diff
UT sample: https://issues.apache.org/ooo/attachment.cgi?id=78234
2012/6/8 Jianyuan Li <li...@gmail.com>
> Thanks for the reminder. The discussion has been logged in defect comments.
> https://issues.apache.org/ooo/show_bug.cgi?id=119903
>
>
> 2012/6/8 zhangjf <zh...@apache.org>
>
>> I suggest you log this discussion into the bug as comments too.
>> Although this mail list will be archived too, it is helpful to find
>> all it's related background and technical info in one single place.
>>
>> zhangjf
>>
>> On Fri, Jun 8, 2012 at 4:03 PM, Jianyuan Li <li...@gmail.com>
>> wrote:
>> > Thanks for everyone.
>> > I will use "Description" for Alt text because Alt text allow multiple
>> lines
>> > which are supported by "Description" other than "Title". I have tried
>> with
>> > "Title", multiple lines will become as one line with return removed
>> after
>> > import.
>> >
>> > 2012/6/8 Armin Le Grand <Ar...@me.com>
>> >
>> >> Hi Jianyuan Li,
>> >>
>> >>
>> >> On 07.06.2012 10:08, Jianyuan Li wrote:
>> >>
>> >>> Hi, All,
>> >>>
>> >>> In Excel 2003, for shape and form control, there is an attribute named
>> >>> "alt
>> >>> text". But Aoo shape and form control do not have an attribute similar
>> >>> like
>> >>> it. So when Aoo import them, this attribute will be omitted. And on
>> >>> exporting it as an Excel 2003 file, this attribute will not be
>> exported.
>> >>> So
>> >>> on opening the export file in Excel 2003, incorrect attribute value
>> will
>> >>> be
>> >>> shown. There is a bug related to it:
>> >>> https://issues.apache.org/ooo/**show_bug.cgi?id=119659<
>> https://issues.apache.org/ooo/show_bug.cgi?id=119659>
>> >>>
>> >>> To fix this issue, is there someone having a good solution? How about
>> >>> import alt text as the title(in shape description dialog) in Aoo? And
>> then
>> >>> export the Aoo title as Excel 2007 alt text?
>> >>>
>> >>>
>> >> There are 'Title', 'Description' and 'Name' properties for each shape.
>> >> "alt text" sounds more like many lines, so I would suggest to use
>> >> 'Description' for it, maybe there is also a good fit for 'Title'. The
>> >> property 'Name' should be a short string and is shown in the navigator,
>> >> maybe also a good candidate to add something useful.
>> >>
>> >> HTH!
>> >>
>> >> Sincerely,
>> >> Armin
>> >> --
>> >> ALG
>> >>
>> >>
>>
>
>
Re: Shape/Form control alt text import and export for Excel 2003
Posted by Jianyuan Li <li...@gmail.com>.
Thanks for the reminder. The discussion has been logged in defect comments.
https://issues.apache.org/ooo/show_bug.cgi?id=119903
2012/6/8 zhangjf <zh...@apache.org>
> I suggest you log this discussion into the bug as comments too.
> Although this mail list will be archived too, it is helpful to find
> all it's related background and technical info in one single place.
>
> zhangjf
>
> On Fri, Jun 8, 2012 at 4:03 PM, Jianyuan Li <li...@gmail.com>
> wrote:
> > Thanks for everyone.
> > I will use "Description" for Alt text because Alt text allow multiple
> lines
> > which are supported by "Description" other than "Title". I have tried
> with
> > "Title", multiple lines will become as one line with return removed after
> > import.
> >
> > 2012/6/8 Armin Le Grand <Ar...@me.com>
> >
> >> Hi Jianyuan Li,
> >>
> >>
> >> On 07.06.2012 10:08, Jianyuan Li wrote:
> >>
> >>> Hi, All,
> >>>
> >>> In Excel 2003, for shape and form control, there is an attribute named
> >>> "alt
> >>> text". But Aoo shape and form control do not have an attribute similar
> >>> like
> >>> it. So when Aoo import them, this attribute will be omitted. And on
> >>> exporting it as an Excel 2003 file, this attribute will not be
> exported.
> >>> So
> >>> on opening the export file in Excel 2003, incorrect attribute value
> will
> >>> be
> >>> shown. There is a bug related to it:
> >>> https://issues.apache.org/ooo/**show_bug.cgi?id=119659<
> https://issues.apache.org/ooo/show_bug.cgi?id=119659>
> >>>
> >>> To fix this issue, is there someone having a good solution? How about
> >>> import alt text as the title(in shape description dialog) in Aoo? And
> then
> >>> export the Aoo title as Excel 2007 alt text?
> >>>
> >>>
> >> There are 'Title', 'Description' and 'Name' properties for each shape.
> >> "alt text" sounds more like many lines, so I would suggest to use
> >> 'Description' for it, maybe there is also a good fit for 'Title'. The
> >> property 'Name' should be a short string and is shown in the navigator,
> >> maybe also a good candidate to add something useful.
> >>
> >> HTH!
> >>
> >> Sincerely,
> >> Armin
> >> --
> >> ALG
> >>
> >>
>
Re: Shape/Form control alt text import and export for Excel 2003
Posted by zhangjf <zh...@apache.org>.
I suggest you log this discussion into the bug as comments too.
Although this mail list will be archived too, it is helpful to find
all it's related background and technical info in one single place.
zhangjf
On Fri, Jun 8, 2012 at 4:03 PM, Jianyuan Li <li...@gmail.com> wrote:
> Thanks for everyone.
> I will use "Description" for Alt text because Alt text allow multiple lines
> which are supported by "Description" other than "Title". I have tried with
> "Title", multiple lines will become as one line with return removed after
> import.
>
> 2012/6/8 Armin Le Grand <Ar...@me.com>
>
>> Hi Jianyuan Li,
>>
>>
>> On 07.06.2012 10:08, Jianyuan Li wrote:
>>
>>> Hi, All,
>>>
>>> In Excel 2003, for shape and form control, there is an attribute named
>>> "alt
>>> text". But Aoo shape and form control do not have an attribute similar
>>> like
>>> it. So when Aoo import them, this attribute will be omitted. And on
>>> exporting it as an Excel 2003 file, this attribute will not be exported.
>>> So
>>> on opening the export file in Excel 2003, incorrect attribute value will
>>> be
>>> shown. There is a bug related to it:
>>> https://issues.apache.org/ooo/**show_bug.cgi?id=119659<https://issues.apache.org/ooo/show_bug.cgi?id=119659>
>>>
>>> To fix this issue, is there someone having a good solution? How about
>>> import alt text as the title(in shape description dialog) in Aoo? And then
>>> export the Aoo title as Excel 2007 alt text?
>>>
>>>
>> There are 'Title', 'Description' and 'Name' properties for each shape.
>> "alt text" sounds more like many lines, so I would suggest to use
>> 'Description' for it, maybe there is also a good fit for 'Title'. The
>> property 'Name' should be a short string and is shown in the navigator,
>> maybe also a good candidate to add something useful.
>>
>> HTH!
>>
>> Sincerely,
>> Armin
>> --
>> ALG
>>
>>
Re: Shape/Form control alt text import and export for Excel 2003
Posted by Jianyuan Li <li...@gmail.com>.
Thanks for everyone.
I will use "Description" for Alt text because Alt text allow multiple lines
which are supported by "Description" other than "Title". I have tried with
"Title", multiple lines will become as one line with return removed after
import.
2012/6/8 Armin Le Grand <Ar...@me.com>
> Hi Jianyuan Li,
>
>
> On 07.06.2012 10:08, Jianyuan Li wrote:
>
>> Hi, All,
>>
>> In Excel 2003, for shape and form control, there is an attribute named
>> "alt
>> text". But Aoo shape and form control do not have an attribute similar
>> like
>> it. So when Aoo import them, this attribute will be omitted. And on
>> exporting it as an Excel 2003 file, this attribute will not be exported.
>> So
>> on opening the export file in Excel 2003, incorrect attribute value will
>> be
>> shown. There is a bug related to it:
>> https://issues.apache.org/ooo/**show_bug.cgi?id=119659<https://issues.apache.org/ooo/show_bug.cgi?id=119659>
>>
>> To fix this issue, is there someone having a good solution? How about
>> import alt text as the title(in shape description dialog) in Aoo? And then
>> export the Aoo title as Excel 2007 alt text?
>>
>>
> There are 'Title', 'Description' and 'Name' properties for each shape.
> "alt text" sounds more like many lines, so I would suggest to use
> 'Description' for it, maybe there is also a good fit for 'Title'. The
> property 'Name' should be a short string and is shown in the navigator,
> maybe also a good candidate to add something useful.
>
> HTH!
>
> Sincerely,
> Armin
> --
> ALG
>
>
Re: Shape/Form control alt text import and export for Excel 2003
Posted by Armin Le Grand <Ar...@me.com>.
Hi Jianyuan Li,
On 07.06.2012 10:08, Jianyuan Li wrote:
> Hi, All,
>
> In Excel 2003, for shape and form control, there is an attribute named "alt
> text". But Aoo shape and form control do not have an attribute similar like
> it. So when Aoo import them, this attribute will be omitted. And on
> exporting it as an Excel 2003 file, this attribute will not be exported. So
> on opening the export file in Excel 2003, incorrect attribute value will be
> shown. There is a bug related to it:
> https://issues.apache.org/ooo/show_bug.cgi?id=119659
>
> To fix this issue, is there someone having a good solution? How about
> import alt text as the title(in shape description dialog) in Aoo? And then
> export the Aoo title as Excel 2007 alt text?
>
There are 'Title', 'Description' and 'Name' properties for each shape.
"alt text" sounds more like many lines, so I would suggest to use
'Description' for it, maybe there is also a good fit for 'Title'. The
property 'Name' should be a short string and is shown in the navigator,
maybe also a good candidate to add something useful.
HTH!
Sincerely,
Armin
--
ALG
Re: Shape/Form control alt text import and export for Excel 2003
Posted by ZuoJun Chen <zj...@gmail.com>.
Hi, Jianyuan
I think this problem may exist on those documentation objects which
has alternative text or object description properties, such as Chart, OLE,
Fontwork, etc. Currently the import filter does not parse alt text, The
solution that import alt text as the title sounds good to me:)
2012/6/7 Jianyuan Li <li...@gmail.com>
> Hi, All,
>
> In Excel 2003, for shape and form control, there is an attribute named "alt
> text". But Aoo shape and form control do not have an attribute similar like
> it. So when Aoo import them, this attribute will be omitted. And on
> exporting it as an Excel 2003 file, this attribute will not be exported. So
> on opening the export file in Excel 2003, incorrect attribute value will be
> shown. There is a bug related to it:
> https://issues.apache.org/ooo/show_bug.cgi?id=119659
>
> To fix this issue, is there someone having a good solution? How about
> import alt text as the title(in shape description dialog) in Aoo? And then
> export the Aoo title as Excel 2007 alt text?
>