topic-21362

Board index FiveWin for Harbour/xHarbour xBrowse to EXCEL

Posts: 6983

Joined: Fri Oct 07, 2005 07:07 PM

xBrowse to EXCEL
Posted: 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

Richard Chidiak

Posts: 946

Joined: Thu Oct 06, 2005 07:05 PM

Re: xBrowse to EXCEL
Posted: 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

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: xBrowse to EXCEL
Posted: Tue Apr 19, 2011 01: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

Otto

Posts: 6983

Joined: Fri Oct 07, 2005 07:07 PM

Re: xBrowse to EXCEL
Posted: Tue Apr 19, 2011 01: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

FiveTech Support Forums

Continue the discussion