Unknown Element "xdr: col" exception

[d3nton]

I got an error: 'Unknown Element "xdr: col" exception' when reading this xlsx file:
http://www.file-upload.net/download-818 ... t.zip.html

It seems that XLSReadWrite cannot read <xdr:oneCellAnchor> elements: see xml tag in xl\drawing\drawing1.xml.

Code: Select all

begin
  ExcelFile5 := TXLSReadWriteII5.Create(nil);
  ExcelFile5.Filename := 'C:\test.xlsx';
  ExcelFile5.Read;
end.

Could you please fix this.
Thank you .

[larsa]

Hello

Fixed in update 5.20.05

[d3nton]

Hello.

Unfortunately it is not yet fixed in update 5.20.05. Now, I got an EIntOverflow in xpgPXML.pas
function TXpgReadXML.QNameHashB: longword; in the while loops:
->a := a * 378551;

Thanks for your help.

[larsa]

Hello

You have turned on overflow checking. Please turn that off.

[kooths]

I am using Version 5.20.30, but still get the error

Row 0: Unknown Element "xdr:col"

when trying to open the Excel2007-file zipped into this file:

http://www.diwax.de/testfile.zip

The same happens with similar files containing graphs (the "xdr:col" tag is in the drawing1.xml, drawing2.xml, and drawing3.xml files of the excel file structure). When using the Excel97 version of this file (saved under Excel) and opening it with XLSReadWrite5 everything is fine. But then saving it with XLSReadWrite5 as an Excel2007 file removes the charts and more or less corrupts the file.

By the way, we did not face these problems with exactly the same excel files when working still with XLSReadWrite4.

Help is strongly appreciated.

Thanks in advance and greetings from Berlin

Stefan Kooths

[larsa]

Hello

This is fixed (again) in update 5.20.32