FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour Set option R1C1 in excel
Posts: 1195
Joined: Mon Oct 17, 2005 05:41 AM
Set option R1C1 in excel
Posted: 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
Posts: 1392
Joined: Mon May 14, 2007 09:49 AM
Re: Set option R1C1 in excel
Posted: Fri Mar 24, 2023 12:52 PM

if oExc:ReferenceStyle =-4150 //xlR1C1

.............

endif

Posts: 1195
Joined: Mon Oct 17, 2005 05:41 AM
Re: Set option R1C1 in excel
Posted: Fri Mar 24, 2023 01:34 PM
Thank you, it's working fine :D
Regards,

Marc



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

Continue the discussion