Axolot Data

Hi. If I remove line "XLS[1].Name := 'Sheet2';" then new sheet really have name Sheet2, but I got error in line "excel[0].AsFormula[0, 0] := 'Sheet2!B1';" Project Project3.exe raised exception class XLSRWException with message 'Error in formula Sheet2!B2 Unknown name SHEET2'. If ...

sorry for double message

Hi. I try to set reference in formula to another sheet but get error Project Project3.exe raised exception class XLSRWException with message 'Error in formula 'Sheet2'!B1 Unknown name Sheet2'. My code var excel: TXLSReadWriteII5; begin excel := TXLSReadWriteII5.Create(nil); excel.Version := xvExcel9...

Sparklines are tiny charts that reside in a cell in Excel.
Starts in Excel 2010.
Adds from ribbon Insert -> Line.

Bug is easy to reproduce.
Create Excel file with sparkline.
TXLSReadWriteII5.LoadFromFile
Do nothing
TXLSReadWriteII5.SaveToFile

New file has no sparklines.

Regards, Anton.

Hi.
I grouped columns in Excel (VB command Columns("E:J").Select Selection.Columns.Group) and saved file in Excel97 format.
When I open file with TXLSReadWriteII5 and save it again (no other actions) column grouping disappears.
Same actions with XLXS works fine.
Regards.

Hi.
This code generates error 'Can not convert XLSX to XLS' because FBIFF is not created until I load Excel97 file from disk How can I create new Excel97 file?

Regards.
Moisha.

Hi. Procedure TXLSWorksheet.AutoWidthCol calculates column width using function TCanvas.TextWidth. This function works for single lines only. I suggest the next improvement for function TXLSWorksheet.AutoWidthCol: var tw: integer; r: TRect; begin ....... S := GetAsFmtString(ACol,FCells.IterCellRow);...

The problem is easy to reproduce xls := TXLSReadWriteII5.Create(nil); xls[0].AsFormula[1, 1] := 'IF(A1="";'#13'"1";"0")'; Code fails and memory leak present: TXLSTokenizerList is not destroed. MS Excel has no problems parsing such expressions. I suggest the next improve...

Hi Lars. Do not know why it may happen, but sometimes FManager.Workbook.DefinedNames .Ptgs=nil. May be the reason is link to non exisiting external file. Such link is bad case but SaveToFile should not fail. I made little improvement in my copy of source code (if (Name.Ptgs <> nil) before each use o...

Hi.
We use Delphi XE4 Update 1, it's the only update for XE4.
Find in source code commented lines marked "make compiler happy".
Uncommenting did the trick, no warnings now.
Regards.

Hi. Just upgraded v5 to v6. Got multiple warnings during compile. Some of them (i.e. Implicit string cast from 'AnsiChar' to 'string') are just copiler paranoia but the others make me a little nervous. [dcc32 Warning] XLSZip5.pas(269): W1035 Return value of function 'TXLSZipArchive.AddFolderChain' m...

Is this issue fixed?
I'he got XLSReadWriteII 5 v5.20.85 and the same problem.

Hi.

Code fails on last XLSReadWriteII 5 for XE4 from http://www.axolot.com/components/f_downloadreg.htm.
Is version 5 supported or it is nessessary to buy version 6 for further support?

Regards.
Anton.

Here is code generating described error. program AddNameErr; {$APPTYPE CONSOLE} {$R *.res} uses System.SysUtils, XLSSheetData5, XLSReadWriteII5; var xls: TXLSReadWriteII5; sheet: TXLSWorksheet; begin xls := TXLSReadWriteII5.Create(nil); sheet := xls.Add(); sheet.Name := 'one two'; try xls.Names.Add(...

I Downloaded last XLSReadWriteII 5 for XE4 from http://www.axolot.com/components/f_downloadreg.htm.
File BIFF_EncodeFormulaII5.pas