I have the following problem:
I have an Excel where the text is with blanks.
When I load the Excel the blanks are not displayed in a listbox.
Is there a chance to display blanks in a listbox?
Try this code:
SET Verbatim = 1;
(ooxml, embedded labels, table is Tabelle1);
Normally all field values are automatically stripped of preceding and succeeding blank characters (ASCII 32) before being loaded into the QlikView database. Setting this variable to 1 suspends the stripping of blank characters.
set Verbatim = 1;
Thanks! It's so easy!
Retrieving data ...