FIX: XFRX_CopyToXLSX() don't export right strings

Created by martinajindrova
Dec 30, 2017
min read

KB-20171229-02

Version

before XFRX 17.3.1

Symptoms

Output file don't contain string GMPB11001943.

Sample Code

SET PATH TO x:\xfrx\xfrx-dev\xfrx\
SET DEFA TO x:\xfrx\xfrx-dev\xfrx\lcPath=JUSTPATH(SYS(16))+"\"*** Create data 
CREATE CURSOR output (codart C(20), libart C(30)) 
** 1er record
APPEND BLANK IN output 
REPLACE codart WITH "PRRCFF1612" IN output 
REPLACE libart WITH "reduction a souder  FF 16-12" IN output 
** 2eme record 
APPEND BLANK IN output 
REPLACE codart WITH "GMPB11001943" IN output 
REPLACE libart WITH "securite manque d'huile" IN output
*** Export data
** Adding procdure
SET PROCEDURE TO xfrx.fxp ADDITIVE  
** Create XLSX 
?XFRX_CopyToXLSX('output',lcPath+"xx.xlsx",,"xx",.T.,.T.)

Work arround

Use dynamic formating.