Search found 3 matches
- 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...
- 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...
- 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...