Axolot Data

Hi After populating and saving a xlsx workbook, containing a Pivot, we get the below error when opening the saved file in excel. Removed Part: /xl/pivotTables/pivotTable1.xml part with XML error. (PivotTable view) No attribute name may appear more than once in the same start tag or empty element tag...

Hi Lars, When my XLS file loads, it finds a named item with 'xsntNone' type. I am not sure what this is, but it is in the report template created by a user so it is outside my control. You can get a cleaned copy (28kb) of the XLS here: http://s000.tinyupload.com/index.php?file_id=5954232225671672006...

Below code should insert an image at halfway in the first cell's row and column (0.5, 0.5). It works for Excel2007 format, but not for Excel97. XLS := TXLSReadWriteII5.Create(self); XLS.Version := xvExcel97; XLS.Sheets[0].Drawing.InsertImage('image.jpg', 0, 0, 0.5, 0.5, 0.75); For Excel97 format, it...

Hi,

What is the recommended way to copy images from a template sheet to a new sheet in the same workbook?

This caused file corruption 10 years ago (viewtopic.php?f=9&t=1568). Is there any way to do it yet?

Thanks,
Carl

Hi, After updating to the latest XLSRW6 for some bug fixes, we found a new issue with generated files sometimes being corrupt. I traced it to below code change in the following function. procedure TXLSNames_Int.AdjustSheetDelete(const ASheetIndex, ACount: integer); This is in the latest version and ...

Hi Lars, A developer on my team asked if I can post the following possible issue he found. He tried to register an account for this forum, but says registration is not working? We found an issue when calling the following method in XLSSheetData5.pas : function TXLSWorksheet.GetIsDateTime(ACol, ARow:...

Hi, When I try to hide sheets on the old XLS format, it is still visible in the workbook when I view it. Visibility only seems to work for XLSX format. XLS.Version := xvExcel97; Sheet := XLS.Add; Sheet.Visibility := x12vVeryHidden; //I also tried x12vHidden. XLS.SaveToFile('Test.xls'); Regards, Carl

Thanks Lars,

When is the next update scheduled?

Regards,
Carl

After some debugging, I found the following in XLSSheetData5.pas: I think it should be: Let me know if this is right. Thanks!

Hi,

I would like to copy a format from one cell and then apply that format to multiple cells. What is the fastest (performance) way to do this? I have looked at the FormatCells example, but cannot figure out how to get existing formats from cells in the spreadsheet.

Thanks,
Carl

Hi, This code fails when trying to set print areas or repeating rows on sheets with spaces in the names. Sheet.PrintSettings.PrintArea(1, 1, 2, 2); If the sheet name is "Client Information", I get an error saying E4016: Uknown sheet name "Information" Is there another way to set ...