topic conditional formatting using macro in QlikView https://community.qlik.com/t5/QlikView/conditional-formatting-using-macro/m-p/343640#M126887 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am exporting pivot tables to excel and I have few negative values in pivot which are enclosed in brackets without - sign in my QVW file. Now when I export this pivot table to excel, brackets are getting removed and - sign is coming. Please suggest how to add barckets in excel using GetProperties method.</P><P></P><P>I have tried to get the solution from API guide but it is very confusing and I need this solution urgently. Please help.</P><P></P><P>Thanks,</P><P>Kirti</P></BODY></HTML> Wed, 09 May 2012 09:01:30 GMT 2012-05-09T09:01:30Z conditional formatting using macro https://community.qlik.com/t5/QlikView/conditional-formatting-using-macro/m-p/343640#M126887 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am exporting pivot tables to excel and I have few negative values in pivot which are enclosed in brackets without - sign in my QVW file. Now when I export this pivot table to excel, brackets are getting removed and - sign is coming. Please suggest how to add barckets in excel using GetProperties method.</P><P></P><P>I have tried to get the solution from API guide but it is very confusing and I need this solution urgently. Please help.</P><P></P><P>Thanks,</P><P>Kirti</P></BODY></HTML> Wed, 09 May 2012 09:01:30 GMT https://community.qlik.com/t5/QlikView/conditional-formatting-using-macro/m-p/343640#M126887 2012-05-09T09:01:30Z conditional formatting using macro https://community.qlik.com/t5/QlikView/conditional-formatting-using-macro/m-p/343641#M126888 <HTML><HEAD></HEAD><BODY><P>Also, my text is getting wrapped automatically when exported to excel. I want column width same as my QVW file in excel too. </P><P></P><P>Please suggest syntax using GetPorperties method.</P><P></P><P>Thanks,</P><P>Kirti</P></BODY></HTML> Wed, 09 May 2012 09:41:14 GMT https://community.qlik.com/t5/QlikView/conditional-formatting-using-macro/m-p/343641#M126888 2012-05-09T09:41:14Z conditional formatting using macro https://community.qlik.com/t5/QlikView/conditional-formatting-using-macro/m-p/343642#M126889 <HTML><HEAD></HEAD><BODY><P> Why not run a macro in Excel that changes the format to the desired appearance?</P></BODY></HTML> Wed, 09 May 2012 12:18:25 GMT https://community.qlik.com/t5/QlikView/conditional-formatting-using-macro/m-p/343642#M126889 m_woolf 2012-05-09T12:18:25Z