Axolot Data

Hello, I searched for a way to sort by multiple columns (first D then A, for example) and I saw in the release notes that version 5.10 had " New Sort method for sorting columns. Can sort on multiple columns. ". But the 2 overloaded Sort() functions do not seem to allow to sort on multiple ...

Thank you very much !
Olivier

Hi Lars,

Thank you very much for your quick response.

Did you mean June 3, which is a Wednesday ?
July 3 is a Friday.

Very best regards,

Olivier

Hello,

Will we receive an email announcement when XLSReadWriteII 6 is compatible with Delphi 10.4 Sydney ?
Very best regards,

Olivier Beltrami

OK. I sent you a file by email.

Hi, I am trying to sort an XLS sheet using the TXlsSheet.Sort() method (the one with row1 row2 col1 col2 ...) but I cannot get it to work. Either I select all columns and then things are sorted according to the 0th row, or I select specific rows and then only these columns are sorted making the shee...

Hello,

After upgrading to 6.00.16, last summer, the problem with "Excel crashed when printing files generated by the component" went away. But sometime since then, it is now back in version 6.00.25.

Very best regards,

Olivier

I am finding that processes that go though a 4000 row Excel file are now taking 5-10 times longer with XLSReadWriteII 6 than with XLSReadWriteII 5. Is this normal ?

I just sent you the sample project by email.

OK, I'll put something together later today or tomorrow.

Hello, I am returning to the topic of conversion of Formatting Ranges from v.4 to v.5, which remained open when you left on holidays in June. I have spent most of the past 6 weeks adapting the code that used to format with " Range.Items[] " to use " CmdFormat ". What a nightmare ...

AutoRowHeight don't works with wrapped text. You can't get the line count of wrapped text as that is not calculated. This is the reason why AutoRowHeight don't works with wrapped text. I have found a way to calculate the number of lines, and Height, using TCanvas and DrawText, based on the font and...

Thank you for your prompt reply. Over the weekend I have continued replacing ranges with CmdFormat, and things are looking better. The sample project was a nice place to start. But now, after spending a few days in the conversion, I have some conceptual questions (BTW: I am always using xcfmMerge): ...

Thank you Lars, this has helped in the reports that I have converted. However, I am still getting a lot of oddities in the 60+ reports that I migrated from v4 to v5; text set in cells not appearing, first default sheet being buggy and needing to add a new sheet and delete the default sheet, autosize...

Hi, Code such as the one below xls.Sheets[0].Range.Items[0,0,7,0].FontStyle := [xfsBold]; xls.Sheets[0].Range.Items[0,0,7,0].FillPatternForeColor := XColorToRGB(xcGray25); which worked fine with XLSReadWrite 4, now crashes systematically with v.5 (access violation or Index 27 out of bounds) Did the ...