Axolot Data

Hello
how is it possible to retrieve the calculation engine version from a file created with Excel 2007 and write the same value to the file created by XLSReadWriteII ?
thanks
Max

Lars, this should not be happen. If I - calculate the worksheet with XLSReadWrite - save it, close the application - reopen it with exel - close excel the file should close without asking anything from excel. OR If I - calculate the worksheet with XLSReadWrite - save it, close the application - righ...

Hi Lars, in versions older than 5.20.23 , there was this problem with a file with formulas: 1) perform the "XLSReadWriteII51.Calculate;" before writing 2) open the file with Excel 3) close the file without touching it : a message appears "do you want to save the changes made to file ....

Actually I have the same error (error with files created by non-excel software) with your internal ZLib too. This morning I asked to my customer to provide the file in the "old" .xls format and everything worked fine, so the .xlsx generated by Apache POI 3.12 will be not an issue for me in...

Hi Lars, one of my customers sent me an excel 2007 file created with the library Apache POI 3.12 and code developed in Java+SpringBatch. The resulting .xlsx file can be opened by Excel 2007 but not with xlsreadwriteII 5 component. The error is: "ZLib decompress error" Note: if I use Winrar...

Hello Lars, do you have some news? The problem is frustrating for a registered users like me. "XLSReadWriteII Copyright(c) 2014 Axolot Data" still persist on a clean install D2007 version. Also the demo nag screen is displayed in my application. xlsSpreadSheet_d2007_reg.exe the xlsReadWrit...

Hello Lars,
downloaded and clean install, I see the new xlsreadwriteII version is 5.20.41.

But the problem still persist, I only insalled D2207 version, xlsSpreadSheet_d2007_reg.exe
Let me know, thanks.

-Massimo

Hello Lars, I confirm the "XLSReadWriteII Copyright(c) 2014 Axolot Data" on a clean install of XLSSpreadSheet 2 actual last version 2.00.06 dowloaded today, which is using XLSReadWrite 5.0 5.20.39 I downloaded the D2007 version, maybe it is the only one with the demo component in it: xlsSp...

I am using the XLSReadWriteII component shipped with XLSSpreadSheet2. Hope this helps, maybe the supplied component is a demo ? All previous libraries was uninstalled. No demo component are in my ststem, I'm also owner in years of a XLSReadWriteII 5.0 valid licence. Please note I'm also waiyng an an...

Hi Lars, in the main page and on every new page created, in cell A1 ( column 0 and row 0) there is always written "XLSReadWriteII Copyright(c) 2014 Axolot Data" by default. Is it possible to have an empty spreadsheet like before ? Version is 5.20.39 , file created in xvExcel2007 let me kno...

Hello Lars, some months ago I tested with Excel 2007 and worked. Now I re-tested with Excel 2007 and works. Some users have Excel 2010 / 2013 and they claims the error is the same as post #1 here. I check the generated files and seems a difference in headers: - generated by XLSReadWrite “[Content_Ty...

Thanks Lars, waiting for the update. As today it is still 5.20.21.

Hello Lars, here is my simple code: procedure TForm1.Button1Click(Sender: TObject); begin (* XLS.Version is xvExcel2007; *) XLS.Filename := 'c:\Temp.xlsx'; XLS.Sheets[0].AsString[1,1] := '1'; XLS.Sheets[0].AsString[1,2] := '2'; XLS.Sheets[0].AsFormula[1,3] := 'B2+B3'; XLS.Calculate; XLS.Write; end; ...

Hello Lars,
thanks, your suggestion is working, but.... in print preview, after page 14 and for all remaining 34 pages, the header is not duplicated. Only empty cells.

Hello Lars, about point 1 : everything is fine now, thanks ! about point 2: the question is not related to the monitor resolution, but if I set a column width = 100 using pixelwidth, when I open it with Excel 2007 / 2010 the column width is 98. Is there any correction I need to add to width calculat...