Search found 2 matches
- Tue Dec 01, 2009 9:06 am
- Forum: XLSReadWriteII 3/4/5
- Topic: Error #VALUE! on opening a file created with TXLSReadWriteII
- Replies: 6
- Views: 7036
Re: Error #VALUE! on opening a file created with TXLSReadWriteII
Hey, thanks for updated version, the formulas work now up to column 'IV'. But after that there are still problems, at least with AsFloatRef, AsFormulaRef and AsFormula. The issues are best illustrated by this example: XLS3 := TXLSReadWriteII4.Create(nil); XLS3.Version := xvExcel2007; XLS3.Sheet[0].A...
- Tue Nov 24, 2009 1:08 pm
- Forum: XLSReadWriteII 3/4/5
- Topic: Error #VALUE! on opening a file created with TXLSReadWriteII
- Replies: 6
- Views: 7036
Re: Error #VALUE! on opening a file created with TXLSReadWriteII
I have similar error with latest version 4.00.25 when trying to make excel 2007 file. Modified example code: procedure TForm1.Button1Click(Sender: TObject); var XLS: TXLSReadWriteII4; begin XLS := TXLSReadWriteII4.Create(nil); XLS.Version := xvExcel2007; try XLS.Sheet[0].AsFloatRef['A2'] := 1; XLS.S...