topic-28838

Board index FiveWin for Harbour/xHarbour Problem with making a Excel-file

Posts: 1467

Joined: Mon Oct 10, 2005 11:26 AM

Problem with making a Excel-file
Posted: Thu Jul 10, 2014 10:45 AM

Hello,

While making an Excel-file, I use this code :

oSheet:Range("F:G"):Set("Numberformat","### ### ##0.00")

Why is this code working very well if my application is build with xHarbour Builder? And why is this code returning an error if my application is build with Harbour?

The error I get is :

Argument error: set

Anyone any idea?

Thanks in advance.

Regards,

Michel D.
Genk (Belgium)

_____________________________________________________________________________________________

I use : FiveWin for (x)Harbour v. 25.12 - Harbour 3.2.0 (May 2025) - xHarbour Builder (January 2020) - Bcc773

Enrico Maria Giordano

Posts: 9020

Joined: Thu Oct 06, 2005 08:17 PM

Re: Problem with making a Excel-file
Posted: Thu Jul 10, 2014 11:29 AM

Michel,

try this:

Code (fw): Select all Collapse

oSheet:Range("F:G"):Numberformat = "### ### ##0.00"

EMG

Enrico Maria Giordano

e.m.giordano@emagsoftware.it
http://www.emagsoftware.it
http://www.emagsoftware.it/emgmusic
http://www.emagsoftware.it/spectrum
http://www.emagsoftware.it/tbosg

driessen

Posts: 1467

Joined: Mon Oct 10, 2005 11:26 AM

Re: Problem with making a Excel-file
Posted: Thu Jul 10, 2014 02:11 PM

Enrico,

Thanks a lot for your help. It works fine now.

Regards,

Michel D.
Genk (Belgium)

_____________________________________________________________________________________________

I use : FiveWin for (x)Harbour v. 25.12 - Harbour 3.2.0 (May 2025) - xHarbour Builder (January 2020) - Bcc773

FiveTech Support Forums

Continue the discussion