mercoledì 18 aprile 2012

Error on exporting XLS from a web document? Try checking the freeform !

Yesterday  I was checking a web document with a problem on exporting in XLS format:
while opening the exported document, office answered with this error:
HTML ERROR in Cell Value
The error message continued with a log placed in a windows temporary  folder containing a series of values without a specific difference with all the other values. The values were all in a specific column.

The problem was with the xls formatting of the column:
MSTR exported the column as number containing text:

The source of the problem was...
the Freeform mapping in the dataset underneath the document !

The value in the column was mapped as attribute ID (numeric) instead of attribute DESC (textual).
Modifing the mapping the problem was solved.

Excuse my English. I hope the content is more interesting.

problem:
xls exporting from web document, "HTML ERROR in Cell Value"


solution:
correct Freeform mapping





4 commenti:

  1. Thank you very much for your good information.
    As I noted in the ... given information is very usefull to every student who ever want to learn about
    Microstrategy Online Training





    RispondiElimina
  2. Questo commento è stato eliminato dall'autore.

    RispondiElimina
  3. Very informative ..i suggest this blog to my friends..Thank you for sharing

    MicroStrategy Online Training Bangalore

    RispondiElimina