"bad formatting" error in xls file

Questions and answers on how to use XLSReadWriteII 3/4/5.
Post Reply
shochberg
Posts: 17
Joined: Fri Aug 01, 2008 3:09 pm

"bad formatting" error in xls file

Post by shochberg »

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 4.00.11 -
it's whatever you have posted as the latest, but it seems to be 4.00.10).

Anyway, once I do that, it manages to damage a
file I've been using for the past 4 months with no problem using an older
verison of XLSRWII4. I did not change my code - just recompiled with your
update. After reading and writing the file with XLS, I open it in Excel, and Excel returns:

"Excel encountered an error and had to remove some formatting to avoid
corrupting the workbook. Please re-check your formatting carefully."

This is really interesting since I do not add any formatting in my code - I simply read and write existing cells. Yet each time Excel fixes this file and I rerun it using the newly compiled app, I get this error.

Please tell me how to fix this or direct me to an earlier release that works
correctly.
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: "bad formatting" error in xls file

Post by larsa »

Hello

I can't reproduce this. Please download the latest update.
Lars Arvidsson, Axolot Data
shochberg
Posts: 17
Joined: Fri Aug 01, 2008 3:09 pm

Re: "bad formatting" error in xls file

Post by shochberg »

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.
Post Reply