Axolot Data

Hi, I have checked version 5.20.06a and I continue to have access violation , when I try to set the width two times on same column. XLS[0].Columns.SetColWidth(0, 0, 2500); XLS[0].Columns.SetColWidth(2, 2, 2500); XLS[0].Columns.SetColWidth(0, 0, 2500); XLS[0].Columns.SetColWidth(2, 2, 2500); my conf...

Hi, I have checked version 5.20.06a and I continue to have access violation , when I try to set the width two times on same column. XLS[0].Columns.SetColWidth(0, 0, 2500); XLS[0].Columns.SetColWidth(2, 2, 2500); XLS[0].Columns.SetColWidth(0, 0, 2500); XLS[0].Columns.SetColWidth(2, 2, 2500); my confi...

Hi, this is the demo http://dox.bg/files/dw?a=5f81fd1239 the problem with the roundup function is from the delimiter character. in xvExcel97 it is ; in xvExcel2007 with ; will rise "E4007: Missing right paranthesis". if you use , for delimiter then no errors in the xvExcel2007 but in the x...

ok i will make an example, but if i remeber corectly the problem was caused by this division '/8' - for the round problem in xvExcel2007 mode

You should check for if FileExists(OpenDialog1.Files ) then begin instead of if FileExists(OpenDialog1.FileName) then begin Better invest in a local variable holding that value. I don't understand you. what's the point with the savedialog or opendialog when XLSReadWriteII crashes when you write the...

Hi, if you try XLS[0].AsFormula[3 * J + 2, I] := 'ROUNDUP(' + ColToText(3 * J + 1) + IntToStr(I + 1) + '/8;0)'; in xvExcel2007 mode if you try the same in xvExcel97 mode, no problems. another case if you try in xvExcel97 mode this XLS[0].AsFormula[1, I] := 'SUM(' + ColToText(1) + IntToStr(IFirst + 1...

Hi, now i'm testing this component for Delphi xe4. i'm receiving this error in two cases. doping the component on the form. changing the name to XLS. XLS.clear; XLS[0].Name := 'Sheet1'; XLS.FileName := SaveDialog1.FileName; XLS.Write; and if I execute second time XLS.clear; or try to close the form,...

Hi, thank you for the fixes in the demo. now rises error (Invalid pointer operation) only when you start with = also when you start with = accept the error select one cell add + and try to select another cell you can't. or if you eventually select some cell it rises another error List Index out of b...

Hi, with the compiled demo from download section under windows 8 pro 64 bit when you start it and you try to type in some cell like E7 or other cell around the application rise error "Invalid floating point operation" when you click File->New it's seems ok for a while like if you enter 10-...

Hi,

when create a xvExcel97 file and just open it with excel 2007 or excel 2010 and try to cloes it immediately, the excel whant to save changes.
when the file is is xvExcel2007 no that problem

Hi, when using Editexample and open a file in xvExcel2007 in Sheet1 cell A1 contains '=Sheet2!A1+Sheet3!A1' and just open it for editing (with double click or F2) and hit the enter (the value continue to be '=Sheet2!A1+Sheet3!A1') strangely this is transformed into '=Sheet5!$A$1+Unknown eptg[00]' wh...

Hi,

when open xvExcel2007 file in Editexample, the cell which contains cyrillic text value show the text in some other encoding

Hi,

when XLSReadWriteII4 is set ot version xvExcel2007 and using

XLSReadWriteII41.Sheet[0].AsFormula[3,1] := 'Sheet2!D1+Sheet3!D1+Sheet4!D1' ;

when you save the file, Cell[3,1] contains only '(Sheet2!$D$1)'

if xvExcel97 all is correct, Cell[3,1] contains 'Sheet2!D1+Sheet3!D1+Sheet4!D1'