xBrowse to EXCEL

xBrowse to EXCEL

Postby Otto » Tue Apr 19, 2011 10:07 am

If I export from xBrowse to Excel with the build in :toEXCEL() method I get with values with a decimal place wrong values in EXCEL.
Could someone please help.
Thanks in advance
Otto

Image
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
User avatar
Otto
 
Posts: 6330
Joined: Fri Oct 07, 2005 7:07 pm

Re: xBrowse to EXCEL

Postby Richard Chidiak » Tue Apr 19, 2011 10:51 am

Otto

XbrNumFormat( 'E', .T. )

Hth

Richard CHIDIAK
http://www.cbati.com

Uestudio
Fwh 13.05 Harbour 3.2 MSVC 2013
User avatar
Richard Chidiak
 
Posts: 946
Joined: Thu Oct 06, 2005 7:05 pm
Location: France

Re: xBrowse to EXCEL

Postby nageswaragunupudi » Tue Apr 19, 2011 1:40 pm

Richard Chidiak wrote:Otto

XbrNumFormat( 'E', .T. )

Hth

Richard CHIDIAK

Mr Otto
If the above advice of Mr. Richard does not work, please try setting oBrw:lExcelCellWise := .t. while defining the browse.

Please let us know the results.
Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10631
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: xBrowse to EXCEL

Postby Otto » Tue Apr 19, 2011 1:56 pm

Thank you Richard, thank you Mr. Rao,

The suggestion from Mr. Rao (oBrw:lExcelCellWise := .t.) is working.
XbrNumFormat has no effect.
Thank you again.
Best regards,
Otto
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
User avatar
Otto
 
Posts: 6330
Joined: Fri Oct 07, 2005 7:07 pm


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 99 guests