Axolot Data

Hi, Larsa.

I'm user.
But there were no questions to ask.
Of couse I saw the code.
My question was - "Am I right saying that...".
Now I see that I'm right.

Thank you!

Hi! I have a question about TXLSReadWriteII5.LocalizedFormulas property. I see that this property affects writing formulas: if LocalizedFormulas is FALSE, then I must use dot in numbers, and comma as list separator when I write formula using TXLSWorksheet.AsFormula. Owerwise I must use localized cha...

As I know Excel itself cannot make row autoheight in case of merged cells with text wrap. The only way is to calculate and set row height directly. alexey.t, what was the solution of a problem? I'm simply interested, because I also sometimes have to solve problem with merged cells and text wrap. But...

Hi Michael,

I do the same task like this:
It works fine

It looks like that maximum length of string is 32766, but not 32767. Simple example prooves it: const cMax = 32766; // no exception // cMax = 32767; // exception "Write XML buffer owerflow" occures. var xls: TXLSReadWriteII5; begin xls := TXLSReadWriteII5.Create(nil); xls[0].AsString[0,0] ...

If you call TXLSWorksheet.FreezePanes with two 0 arguments, then created XLSX cannot be read in Microsoft Office 2016 Professional Plus VL September 2018, v.16.0.4738.1000. I haven't investigated sources yet, but I think that TXLSWorksheet.FreezePanes should ignore two 0 arguments. Or description of...

Hello! Finally I get access to sources. And I know now how to do subj. May be it would be helpful for other developers. type TXLSWorksheetHack = class(TXLSWorksheet) end; var xls: TXLSReadWriteII5; i: integer; begin xls := TXLSReadWriteII5.Create(nil); ... fill xls for i := 0 to xls.Count-1 do TXLSW...

How can I set PageBreakPreview mode?

I only found this enumeration type in Package\D2007\Xc12DataWorksheet5.hpp:
"enum TXc12SheetViewType { x12svtNormal, x12svtPageBreakPreview, x12svtPageLayout };"

But I cannot understand - what property of Worksheet I must set.