xbrowse ToCalc() oSheet:SetString error ?

ShumingWang

Posts: 474

Joined: Sun Oct 30, 2005 06:37 AM

xbrowse ToCalc() oSheet:SetString error ?
Posted: Mon Sep 26, 2011 08:15 AM

Hi,
Xbrowse METHOD ToCalc()
oSheet:GetCellByPosition( nCol-1, nRow-1 ):SetString = oCol:cHeader

Error description: (DOS Error -2147352573) WINOLE/1006 Argument error: _SETSTRING

Best regards!
Shuming Wang

http://www.xtech2.top
Mobile:(86)13802729058
Email:100200651@qq.com
QQ:100200651
Weixin: qq100200651

Antonio Linares

Posts: 44158

Joined: Thu Oct 06, 2005 05:47 PM

Re: xbrowse ToCalc() oSheet:SetString error ?
Posted: Sat Jul 28, 2012 10:32 AM

Did someone find the solution to this error ? thanks

regards, saludos

Antonio Linares
www.fivetechsoft.com

Enrico Maria Giordano

Posts: 9020

Joined: Thu Oct 06, 2005 08:17 PM

Re: xbrowse ToCalc() oSheet:SetString error ?
Posted: Sat Jul 28, 2012 11:45 AM

Please check the value of nCol and nRow. They must range from 0 upward (I don't know what the maximum value is).

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

anserkk

Posts: 1335

Joined: Fri Jun 13, 2008 11:04 AM

Re: xbrowse ToCalc() oSheet:SetString error ?
Posted: Mon Jul 30, 2012 05:21 AM

Please test after changing the line 7152 xbrowse.prg

FROM

Code (fw): Select all Collapse

      oSheet:GetCellByPosition( nCol-1, nRow-1 ):SetString = oCol:cHeader

TO

Code (fw): Select all Collapse

      oSheet:GetCellByPosition( nCol-1, nRow-1 ):SetString(oCol:cHeader)

Please comment out the line 7184

Code (fw): Select all Collapse

OTHERWISE
//     oSheet:GetColumns():GetByIndex( nCol-1 ):NumberFormat:="@"

Please let us know the results.

Regards

Anser

ShumingWang

Posts: 474

Joined: Sun Oct 30, 2005 06:37 AM

Re: xbrowse ToCalc() oSheet:SetString error ?
Posted: Mon Jul 30, 2012 10:19 AM

Yes!
THis change works fine!
Thanks !
Shuming Wang

http://www.xtech2.top
Mobile:(86)13802729058
Email:100200651@qq.com
QQ:100200651
Weixin: qq100200651

Antonio Linares

Posts: 44158

Joined: Thu Oct 06, 2005 05:47 PM

Re: xbrowse ToCalc() oSheet:SetString error ?
Posted: Mon Jul 30, 2012 11:34 AM

Anser,

many thanks! :-)

regards, saludos

Antonio Linares
www.fivetechsoft.com

Biel EA6DD

Posts: 682

Joined: Tue Feb 14, 2006 09:48 AM

Re: xbrowse ToCalc() oSheet:SetString error ?
Posted: Mon Nov 26, 2012 06:17 PM

Hi Antonio,
I have the same problem with FW 12.09 (Error description: (DOS Error -2147352573) WINOLE/1006 Argument error: _SETSTRING) .

The proposed changes by Anser are working ok for me, avoiding erros. Will be nice if u can include these changes in the lib. TKS

Saludos desde Mallorca
Biel Maimó
http://bielsys.blogspot.com/

Antonio Linares

Posts: 44158

Joined: Thu Oct 06, 2005 05:47 PM

Re: xbrowse ToCalc() oSheet:SetString error ?
Posted: Wed Dec 12, 2012 10:44 AM

Biel, Anser,

Added, many thanks for the reminder! :-)

regards, saludos

Antonio Linares
www.fivetechsoft.com

FiveTech Support Forums

Continue the discussion