Shape.AlternativeText blank in .XLSX


#1

I may have found a bug. If I loop through the Shapes collection and check the Shape.AlternativeText when using an Excel 2000 file, Aspose.Cells correctly returns the string value.

If I save the file as 2007 format (.xlsx), Aspose reports the AlternativeText as being empty.

The attached VS 2010 C# project demonstrates this.

Thanks,

Jeff


CheckBox.AlternativeText blank after saving the workbook
#2

Hi Jeff,

Thanks for your posting.

We will look into the problem you stated and get back to you as soon as possible.


#3

Hi Jeff,

Thanks for your sample code, I can reproduce this bug. I have simplified the code to test this scenario and also attached the sources excel files and output screenshot for a reference.

C#


Workbook wbXlsx = new Workbook(@“C:\Downloads\srcAltText.xlsx”);

string altTextXlsx = wbXlsx.Worksheets[0].Shapes[0].AlternativeText;


Workbook wbXls = new Workbook(@“C:\Downloads\srcAltText.xls”);

string altTextXls = wbXls.Worksheets[0].Shapes[0].AlternativeText;


Console.WriteLine("Alt-Text-Xlsx: " + altTextXlsx);

Console.WriteLine("Alt-Text-Xls: " + altTextXls);



#4

Hi,

I have logged this bug with id: CELLSNET-23525


#5

Hi,

We have resolved this issue in Aspose.Cells for .NET 5.2.1.3.


#6

The issues you have found earlier (filed as 23525) have been fixed in this update.


This message was posted using Notification2Forum from Downloads module by aspose.notifier.

#7

I just downloaded version 5.2.2 and one of the two errors in my test program was fixed, however, the other still exists: when a 2000-format (.xls) file is saved to 2007 format (.xlsx) using Aspose.Cells, the Shape.AlternativeText is not preserved. When I open the newly saved .xlsx the alt text is blank.

I didn't notice until today that your simplified test version dropped one of my tests, which illustrates the problem.You can refer to my original test to see the issue. It should say:

Re-open 2007 file 'ExcelSourceSAVED.xlsx' and check shapes...'
Shape 'Picture 2' Alt=''

Note that Alt is empty.

Thanks,

Jeff


#8

Hi,

Yes we noticed this problem although it works fine with native/existing Excel 2007 XLSX files.

I have re-opened the issue and will figure it out soon.

Thank you.


#9

Hi Jeff,

Thanks for posting the missed test case.

We have fixed this issue. Please download the Aspose.Cells for .NET 5.2.2.1


#10

Unfortunately I have found the same problem with OleObject images (images placed into Excel using Insert > Bitmap object).

1. Aspose.Cells does not read in the AlternativeText of the OleObject from a pre-existing 2007 format file. This text is what you set under the Format Picture > Web tab.

2. Aspose.Cells does not save the AlternativeText when saving an .xls to .xlsx format. If I do Workbook.Save to Xlsx format, then open the file manually in Excel, the alt text is blank.

The new ZIP file "AsposeCellsAltTextTest_20110211.zip" I have attached illustrates the problem.

Thanks,

Jeff


#11

Hi,

Thanks for providing us the sample project.

I am able to reproduce the issues you have described. I have re-opened your ticket “CELLSNET-23525” again. We will soon look into it.

Thank you.


#12

Hi,

Please try the Aspose.Cells for .NET 5.2.2.6. We have fixed the issue you mentioned.


#13

That works great. Thank you very much.

Jeff


#14

The issues you have found earlier (filed as ) have been fixed in this update. This message was posted using BugNotificationTool from Downloads module by MuzammilKhan