Can anyone help me to get a solution for this issue:
While importing a file(excel), the formats are being preserved only if it contains more than one formatted data in each column. If the entire text formatted with the same style ,then it is not preserving.
Following are some examples
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /> Sample text Result Text contains formatted value Not preserving the format Not preserving the format Text contains formatted value Not preserving the format Text contains formatted value Preserving the format Text contains formatted value Preserving the format Text contains formatted Preserving the format
Text contains formatted value
value