Axolot Data

Hi Lars, I have some files created by another Delphi third-party component that assign a relationship ID other than rId1,2,3, etc. Those are causing exceptions when I use your component to modify and re-save the file. I've found the problem to be that in XLSXMLExcel4.pas, you rewrite most, but not a...

Lars,

The version history on the bbs shows 4.00.35 as the latest. I have 4.00.41, and Mr. Stadler refers to 4.00.45 in his post. What should I be using for Delphi 2007?

Thanks.

Scott Hochberg
Postage Saver Software
savepostage.com

I found that using the deleterows function seemed to use a memory and then not release it. Repeated calls to deleterows caused the memory usage to overrun available memory on any file of significant size. I got around my problem by counting the rows I wanted to delete and then using a single deleter...

[DCC Error] MAIN.PAS(10): F1026 File not found: 'XLSPNGImage.dcu'

is corrected if I copy the .dcu files from the PNGImage folder to the D2007 folder. Perhaps the installer should be corrected to do that.

Thanks.

I get a similar issue using Dephi 2007:

[DCC Error] MAIN.PAS(10): F1026 File not found: 'XLSPNGImage.dcu'

S

Now that I have installed the file you sent, the application that had the problem works fine, but another that uses XLS now refuses to compile, giving me the following error: [DCC Error] Decoder.dpr(18): F2051 Unit DrawingObjChart4 was compiled with a different version of Escher4.TEscherDrawing Now ...

OK, since you fixed the last one, let's try another, please I am attaching (in a separate email) two files. The first, 12-17-08original.xls, has formulas beginning in column U. I then performed the following action on this file to create a second set of blank rows following the original set. XLSRead...

Thank you for your prompt reply and correction of this issue.

(Note to readers: I received a revised file from Lars offline via email.)

S

Yet another hint - if you save the .xls file I sent as a .xlsx file, XLS works correctly. If the file is then resaved as .xls, it fails again.

S

Some additional information. The upper row 2, col 1 cell ("Harbauer" in the file I emailed) shows a little dotted box for chart formatting when you click on it. If I hit my delete key to make that box disappear, and then save the file without again clicking on that cell, the file runs prop...

OK, now I installed 4.00.12, and it appeared to fix the problem I previously reported, and no other problems were evident. So I released the product to the field and now I am getting reports of yet another new crash. I can't tell exactly in what version of XLS this problem was introduced, since I sk...

Thank you. The new file seems to work correctly. I assume I still need to manually move the files in the PNGImage folder into the D2007 folder for the compile to work correctly, so that is what I have done.

OK, I "guessed" that what I had to do to compile the most current download on XLSRWII4 D2007 was to take the files from the PNGImage folder and put them in the Package folder. If that's not right, then tell me what I should be doing to get my app to compile using 4.00.10 (or perhaps it is ...

>>These files where missing in the D2007 package, but this is fixed in the latest update (4.00.11). Very well, except that when I download the registered version for Delphi 2007 I get 4.00.10 (at least according to the changes.txt file), not 4.00.11, and then get the compile error reported above, ma...

I did hear back from Lars - he assured me that he will fix this in an upcoming update. However, in the meantime, there is a workaround. XLS can be set to create the temp file in memory, so there is no naming conflict. If you are using XLS to read Excel 2007 files, you should add XLS.TempFileMode := ...