Excel does not format cells based on the values exported by Xporter

[Andreas Haaken _APTIS_]

I use teh Xporter plugin to export a list of Issues, which have a due date. 

I want to format the cells with the date based on the realtion to the actual date: red backgroudn, if the due date has passed today --> (A2>=Today())

This works fine in a static Excel sheet, but as a result of an Export, the cell does not change the fomat.  If I go into the cell (valuebar) and then press enter to input the data again, the format changes as expected.  But I cannot jump into any cell and re enter the value again.

Does anyone solved this problem in Excel?

[Mafalda de Azevedo Mendes]

Hi @Andreas Haaken _APTIS_

The workaround to that problem is to manually perform a Replace All "/" with "/". Yes, you have to replace with the same character, just for Excel to scroll through the document and calculate the expressions.

That way, Excel will render all formulas in the worksheet.
The other option is to create a macro to do that replacing.

If you have more questions feel free to ask.

Best regards,

Xpand Add-Ons Team