Set option R1C1 in excel

Set option R1C1 in excel

Postby Marc Vanzegbroeck » Fri Mar 24, 2023 10:01 am

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
Marc Vanzegbroeck
 
Posts: 1159
Joined: Mon Oct 17, 2005 5:41 am
Location: Belgium

Re: Set option R1C1 in excel

Postby Natter » Fri Mar 24, 2023 12:52 pm

if oExc:ReferenceStyle =-4150 //xlR1C1
.............
endif
Natter
 
Posts: 1222
Joined: Mon May 14, 2007 9:49 am

Re: Set option R1C1 in excel

Postby Marc Vanzegbroeck » Fri Mar 24, 2023 1:34 pm

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

FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
Marc Vanzegbroeck
 
Posts: 1159
Joined: Mon Oct 17, 2005 5:41 am
Location: Belgium


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: Google [Bot] and 93 guests

cron