Issue with writing comments

Questions and answers on how to use XLSReadWriteII 5.
Post Reply
paulwiik
Posts: 2
Joined: Thu Apr 18, 2013 8:08 am

Issue with writing comments

Post by paulwiik »

Just downloaded version 5.10.17 of XLSReadWriteII

I'm experiencing a couple of issues when using the Comments functionality. The issues might be related.
Tested in Delphi 2005 and Delphi 5. Same issues in both environments.

Issue #1:
Run the "SampleComment" application.
"Read" an existing xlsx that have only one comment placed in cell B5.
Click Add1
Click Write
Try to open file in Excel.
- authorID in "comments1.xml" is set to 1 (authorId="1"), all though there are now only 1 author in the <authors> listing.
Issue #1:

Issue #2 (Have not debugged this):
Run the "SampleComment" application.
Click Add1, Click Add2
Click Write
- Open File in Excel. Looks fine. Close Excel.
Click Add2
Click Write
Try to open file in Excel again. - "Excel found unreadable content in 'test.xlsx'. Do you want to recover the contents of this workbook? ..."

Best Regards,
Paul
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: Issue with writing comments

Post by larsa »

Hello

This is fixed in 5.10.18
Lars Arvidsson, Axolot Data
paulwiik
Posts: 2
Joined: Thu Apr 18, 2013 8:08 am

Re: Issue with writing comments

Post by paulwiik »

Hi,

Thank you for the quick turnaround.
Just downloaded and tested version 5.10.18.
Issue #1 is fixed.

However, I don't think #2 is fixed (or the following is another unrelated issue) :

To replicate :
Run the "SampleComment" application.
Click "Write" (new file)
- open in Excel. Works fine (just displays the empty newly created spreadsheet). Close Excel.
Click "Write" again (to the same file).
- Open in Excel. -> error "Excel found unreadable content in '<filename>'. Do you want to recover the contents of this workbook?..."

It seems that an instance of TXLSReadWriteII5 doesn't like to be written two times.

Best Regards,
Paul
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: Issue with writing comments

Post by larsa »

Hello

This is fixed in update 5.10.19
Lars Arvidsson, Axolot Data
Post Reply