I require mixed data-types in a column, i.e. a combination of percentage, number, decimal, string. I am able to generate excel, however on opening it says: 'Excel found unreadable content. Do you want to recover contents of the workbook'. On choosing 'Yes' option, it opens. This is one issue regarding the unreadable content.
Second is the excel shows all the cells formatted as that particular data-type which I specified, however doesn't let me do calculation if I do on same types after applying filter :(
I require mixed data-types in a column, i.e. a combination of percentage, number, decimal, string. I am able to generate excel, however on opening it says: 'Excel found unreadable content. Do you want to recover contents of the workbook'. On choosing 'Yes' option, it opens. This is one issue regarding the unreadable content.
Second is the excel shows all the cells formatted as that particular data-type which I specified, however doesn't let me do calculation if I do on same types after applying filter :(