Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ExcelListener class placed in downloads
Message
From
01/01/2007 14:23:56
 
 
To
29/12/2006 18:25:10
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01180997
Message ID:
01181232
Views:
24
I fixed 2 problems

1. Created XML file causes encoding error for some data.

in Render() I changed line
cContents = STRCONV(cContentsToBeRendered, 6)
to
cContents = STRCONV(strt(strt(strt(cContentsToBeRendered, ;
   '&','&amp;'),'>','&gt;' ),'<','&lt;'),9)
2. Since color columns in frx file can have value -1,
REPLACE in AfterReport() causes error. I changed replace to
REPLACE ALL cExcelInterior WITH 'Solid,';
    	+ RIGHT(TRANSFORM(RGB(FillRed,FillGreen,FillBlue),'@0'),6) + ',' ;
		+ RIGHT(TRANSFORM(RGB(PenRed,PenGreen,PenBlue),'@0'),6) ;
	FOR ( FillRed # 255 OR FillGreen # 255 OR FillBlue # 255 ;
				OR PenRed # 0 OR PenGreen # 0 OR PenBlue # 0 ) ;
    AND FillRed # -1 AND FillGreen # -1 AND FillBlue #-1 AND ;
	     PenRed # -1 AND PenGreen # -1 AND PenBlue # -1
Unresolved issue:

Fontcharset support. RESOID field in frx file. In VFP9 this field
contains Fontcharset value for rows where OBJTYPE is 5 and 8 (text
fields and labels)

STRCONV() must be called with nRegionalIdentifier parameter in Render()

CharsetTolocale() method in frxcursor class can be used
to convert Fontcharset value to nRegionalIdentifier.

How to call CharsetTolocale() in Render() ?
Andrus
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform