Axolot Data

Can you send me the two project definitions for Delphi 10 and Delphi 10.2? I would add the LIBSUFFIX myself..

Hi, We purchased the components with source (which is fine), but the name of the bpl files do not follow the standard naming procedures. there is a vcl230.bpl for Delphi 10 Seattle and a vcl250.bpl vor Delphi 10.2.3 Tokyo if I compile my project with runtime packages enabled, I have to add only vcl ...

Thank you for your bugfix. With the latest version 6.00.30, I can report that deleting rows works and nice XLS documents are created!

Thank you! I can confirm that it is working now.

I'm sorry, but I discovered another problem with merged cells and deleted rows. Following example: https://i.imgur.com/JMjcY1h.png On the left side, you see the original file. Here, I delete rows from index 21 to index 28 (marked yellow). The result is in the middle: merged cells remain at row index...

For backwards compatibility we still use indexed palettes. Unfortunately when saving the XLSX files with modified palettes, the palette gets not saved and the XLS file will have different colors than specified. I found the following workaround to generate the palette before saving the file. Is there...

I installed the updated components and can confirm that it is working now.

Just solved this problem: there is a different property to set the pattern color: try LDoc := TXLSReadWriteII5.Create(nil); LDoc.Sheets[0].AsString[3,3] := ''; LFormat := LDoc.CmdFormat; LFormat.BeginEdit(LDoc[0]); LFormat.Fill.PatternStyle := efpLightGrid; LFormat.Fill.PatternColor.IndexColor := xc...

The exception is gone, thank you.

After I load an older excel file (xls) with VBA modules included, the xls reader is generating an exception. The problem is that substreams with type 6 are not handled in a case statement. https://i.imgur.com/IpOst2P.png This is disturbing. Proposal: just skip over that modules (or add an option to ...

While I can confirm that it works for: It does not work for: - thw row and formatting is deleted but the merged cell is moved to row 4.



The merged cell remains, even if I delete row 5.

Unfortunetaly I found another issue while deleting rows in an excel sheet. If I use merged cells and delete a range of rows (including the merged cells), they will not get deleted and remain in the document. The result is unsatisfactory because the remaing rows are affected. Example screenshot: http...

I've isolated the problem and I think I can describe it: the problem is caused by deleting specific rows. After that, the corresponding ranges are not updated correctly in TXLSFormulaHandler.AdjustCellRowsChanged. Example: define a named range: Tabelle1!$C$5:$C$10 call DeleteRows(0, 4, 6); the named...

I can confirm that it is working now for both filetypes, xls and xlsx. Thank you!

Thank your for the bug fix. I downloaded the latest version and now the diagonal border is showing up in the xlsx file. It does not work if I use the old file format, though. uses XlsReadWriteII5, XLSCmdFormat5, Xc12DataStyleSheet5, Xc12Utils5, SysUtils; procedure testd(); var LDoc: TXLSReadWriteII5...