I don't believe that this behaviour could be (easily) adjusted. While exporting or copying to excel some kind of TRIM will be applied and removed these chars. I think the reason is a meta-data error/incompatibility between QlikView and Excel then if I copy (as whole table into the switchboard) such table-chart into Notepad++ and copy it there again and paste it into Excel those control-chars remain.
Further worked it by exporting not to Excel else into a textfile like a *.qvo but I'm not sure if this resulting format is what you want. Then remained the possibility to work afterwards with some macros or to make the whole export + adjustment within vbs - attached is an recent post to fill missing dimension-values after copying the object and which could serve as starting-point if such a solution will be preferred.
Of course the easiest way is to avoid such linebreaks maybe with another specialized chart-object which only purpose is to export and which won't used from your users.
- Marcus
