Dear user,
To give you the complete explanation, Excel is the one that has limitation.
BeGraphic uses the Exel API that has been very limited until Excel2010:
- Until Excel 2007, Excel didn't give the color of the conditional formating. Therefore BeGraphic has to recalculate the result of your "conditional formatting". That is why today BeGraphic is only taking simple cases into account.
- Within Excel2010, there is a new way to directly access the result of the conditional formatting. In the future version2 of BeGraphic (both editions: Lite & Pro), we will take advantage of this solution. That is why we advise you to take Excel2010.
BeGraphic version2 (both editions: Lite & Pro) will be launched in 2012 march.
We'll let you know.