Set option R1C1 in excel

Post Reply
Marc Vanzegbroeck
Posts: 1159
Joined: Mon Oct 17, 2005 5:41 am
Location: Belgium
Contact:

Set option R1C1 in excel

Post by Marc Vanzegbroeck »

Hi,

Is there a way to check the R1C1 option in excel from FW?

Thanks,
Regards,
Marc

FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
Natter
Posts: 1226
Joined: Mon May 14, 2007 9:49 am

Re: Set option R1C1 in excel

Post by Natter »

if oExc:ReferenceStyle =-4150 //xlR1C1
.............
endif
Marc Vanzegbroeck
Posts: 1159
Joined: Mon Oct 17, 2005 5:41 am
Location: Belgium
Contact:

Re: Set option R1C1 in excel

Post by Marc Vanzegbroeck »

Thank you, it's working fine :D
Regards,
Marc

FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
Post Reply