Axolot Data

Tested in 5.10.21, still I can't set page orientation. Please fix this.

Is there any update on this, Lars? I know you plan to deal with charts later, but this seems to be a small bug, because everything else related to chart works normally. With the "Series[0].Values := ... " commented, I get the chart with all its settings, even with X-values. It just lacks Y...

Hello Is there a macros support for Excel97? The sample code from BIFF_VBA5.pas works but Excel 2003 crashes trying to open output file. xlsRW.BIFF.ReadMacros := true; xlsRW.VBA.EditVBA := True; // Add a VBA module and a procedure. with xlsRW.VBA.AddModule('Module1',vmtMacro) do begin Source.Text :=...

I get the same error "SST String is Nil" when trying to format a single cell. The code is: xlsRW := TXLSReadWriteII5.Create(nil); xlsRW.Filename := 'test.xlsx'; with xlsRW[0] do begin AsString[0, 0] := 'Test string'; with Cell[0, 0] do begin HorizAlignment := chaCenter; FontStyle := [xfsBo...

Hello

Can't set landscape orientation for Excel97. Output document has portrait mode, even with an explicit setting:

Can't get frozen panes working for Excel 97. The code above does nothing.
There is also TXLSWorksheet.FreezePanes method, but it doesn't work either, and it causes document scroll failure.
Tested on version 5.10.16. Please help.

Nevermind1003, thanks for reply. I checked again and found AsRichText working in 5.10.16. It seems the parser has been fixed.

Hello Please provide an example to add note to a cell. For Excel97, the following code works: Result := xlsRW[0].Drawing.BIFFDrawing.Notes.Add; Result.Text := text; BIFFDrawing is nil for Excel2007 mode, so I can't use it. Samples directory has an example called "Comment" that works for Ex...

Hello Need charts support also. After porting my code to version 5, got an error on this line when trying to set values for series: Series[0].Values := 'Data!$B$2:$B$102'; The error is below: Exception EAccessViolation: Access violation at address 00000000. Read of address 00000000 (OS exception) ex...

Hello I try to insert some rich text into a cell with this code: xlsRW.AsRichText[2, row] := '{\rtf1\ansi \ansicpg1252{\fonttbl{\f0\fnil Times New Roman}} \f0\fs22\ a \f0\fs22\ = 1000 }'; The result must be a simple text with a different font size for letter "a". As for version 4, this wor...