Potential Problems with Passwords and with Charts.

[Guest]

Hello, I am currently using the trial version of XLSReadWriteII version 3. It has proved very useful so far, but I have some questions for you that I hope can be resolved:

1. There is an OnPassword event that is called if the spreadsheet has a file-level password (in Excel, File..Save As...Tools...General Options), but the event is not fired for workbook level passwords (in Excel Tools...Protect Workbook). Is this as designed or can this be implemented?

2. I am testing the ReadPictures demo and have a spreadsheet that contains the following:

Sheet1 (normal worksheet)
ChartSheet (a chart sheet with AN ADDITIONAL chart object added)
Sheet2 (normal worksheet with an image)

The image displays ok, but the application crashes on exit - here is snip of the crash transcript:

main thread ($9fc):
004b4123 +23 ReadPictures.exe RecordStorageChart2 586 +3 TChartRecord.Destroy
00403844 +08 ReadPictures.exe System TObject.Free
00455dca +16 ReadPictures.exe Contnrs TObjectList.Notify
00443191 +59 ReadPictures.exe Classes TList.Delete
004434f3 +5f ReadPictures.exe Classes TList.SetCount
00443127 +07 ReadPictures.exe Classes TList.Clear
004430db +0f ReadPictures.exe Classes TList.Destroy
004b415c +5c ReadPictures.exe RecordStorageChart2 594 +11 TChartRecord.Destroy
...
...
...

Can you confirm if this is a bug and if it will be fixed for future versions?

Thanks, and keep up the good work.

[larsa]

Hello

1. The OnPassword event is only used for encrypted files, as these can not be read without the password. When a single worsheet is password protected, the file is not encrypted, and the password is not needed.

2. Can you please send me the excel file that causes this problem?


Lars Arvidsson

[larsa]

Hello

I don't have any problems with the file you sent me. No crash on exit.


Lars Arvidsson

[Guest]

Lars,

The crash in ReadPictures.exe has been resolved in the latest build, thanks.

Good support!