Search found 3 matches

by Lothar
Fri Dec 19, 2008 4:05 pm
Forum: XLSReadWriteII 3/4/5
Topic: Formating Cells - Countryspecific problem
Replies: 0
Views: 2479

Formating Cells - Countryspecific problem

Hi all, I have an excel file which includes formatted Data. If I format a cell to Date, Excel writes as Format m/d/yy even I am in Germany and the order is dd.mm.yyyy. This way Excel Shows it. BUT if I add Dates with the xlsReadWriteII4-Component and Format 'dd/mm/yyy' or 'DD.MM.YYYY' then the old d...
by Lothar
Thu May 29, 2008 9:03 am
Forum: XLSReadWriteII 3/4/5
Topic: Exception with MoveCells
Replies: 1
Views: 2364

Solution

I found the solution myself: I just searched further for this problem, and I found - Longword(Row1 + DestRow)); That means, that the sign gets turned for the DestRow, and indeed, when I call the procedure with row -6 then it works ! So corrected would be: TCell(Cells ).SetPos(TCell(Cells ).Col - Col...
by Lothar
Wed May 28, 2008 9:16 am
Forum: XLSReadWriteII 3/4/5
Topic: Exception with MoveCells
Replies: 1
Views: 2364

Exception with MoveCells

Hello, I get always exceptions "access violation" when I use MoveCells. Here a simple excample: procedure TForm1.btn_MoveClick(Sender: TObject); var intC,intR : integer; XLS: TXLSReadWriteII4; begin XLS := TXLSReadWriteII4.Create(Self); XLS.Filename := 'Move1.xls'; for intC := 0 to 20 do b...