I'm sorry, I did'nt test my changes carefully.
With my changes Excel show each character as two characters and Openoffice 2 hangs. To fix this
I changed xml_file_header to
TEXT TO lcRetVal TEXTMERGE NOSHOW PRETEXT 2
<?xml version="1.0" encoding="Windows-<<TRANSFORM(CPCURRENT())>>"?>
<?mso-application progid="Excel.Sheet"?>
ENDTEXT
and conversion in .Render() to
cContents = ;
STRCONV(strt(strt(strt(cContentsToBeRendered,'&','&'),'>','>' ),'<','<'),6)
However, this does not allow to implement fontcharset.
Any idea how to create xml file which has UTF-8, UTF-16 or similar encoding?
Empty line is shown between each detail line.
How to remove those empty lines ?
>Later I'll extract the default code in ApplyExcelStyle which really should be outside the class because it is specific to my situation.
I changed the code so it works without Excel installed, just creates file. Openoffice can open generated files also.
Andrus