 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Roman
Guest
|
 Posted: Wed Jul 19, 2006 8:12 am Post subject: Delphi, Excel |
 |
|
Hi,
I have a Delphi (6) application that works with an Excel sheet.
When I do:
xls.ActiveSheet.Cells[1,1].NumberFormat := '###.##0';
xls.ActiveSheet.Cells[1,1].Formula := '=IF(G6>I6;G6-I6;"")';
or
xls.ActiveSheet.Cells[1,1].NumberFormat := '###.##0';
xls.ActiveSheet.Cells[1,1].Value := '=IF(G6>I6;G6-I6;"")';
I get an "OLE Error 800A03EC" exception. Other funtions like "=SUM(A1:A10)" work fine.
Can anybody help me?
Best regards,
Roman |
|
| Back to top |
|
 |
Roman
Guest
|
| Posted: Thu Jul 20, 2006 8:12 am Post subject: Re: Delphi, Excel |
|
|
"Oliver Townshend" <oliveratzipdotcomdotau> wrote:
| Quote: | xls.ActiveSheet.Cells[1,1].NumberFormat := '###.##0';
xls.ActiveSheet.Cells[1,1].Formula := '=IF(G6>I6;G6-I6;"")';
use commas not semicolons in your formula.
Oliver Townshend
|
Thank You very much for your answer an have a nice day
Roman |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
