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 <[email protected]> > 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 <[email protected]> > >> 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 <[email protected]> >> 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 <[email protected]> >> > >> >> 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 >> >> >> >> >> > >
