you have done to dynamically right ?? that is the data is like that? if that is the case than NPrinting will not alter that representation. Check in Qlikview how your merging the cell ? if they are using any text object on top of that then it will not have any effect in the NPrinting

For 2, is there anyway the set all the cells as text? Since I have format the cells in qvw expressins, if set ExcelExportMixedAsText to 0 will lost all the format in excel. If set it to 1, some sell will show as text,but some cells still number. It's really pain.