https://issues.apache.org/ooo/show_bug.cgi?id=122856
--- Comment #12 from Clarence GUO <clarence.guo...@gmail.com> --- Once resave the sample by MS Excel without any change, reopen the sample by MS Excel, you can see all conditional formatting lost by both MS Excel 2003 and 2010. Then reopen this file by AOO3.4.0 or AOO4.0, now their results are same, don't show any number formats like that in Excel. So seems Excel doesn't support such formula usage on conditional formatting then Excel abandon them. With Oliver's simple ODS, even resave to XLS by AOO3.4.0, I can see conditional formatting different between Excel 2003 and 2010. So the issue of conditional formatting difference on different Excel version is not introduced by AOO3.4.1. Furthermore, I copy the cells from Oliver's simple ODS to Excel, and try to create same conditional formatting, but I failed on both Excel 2003 and 2010, no conditional formatting show on these cells. Maybe that can illustrate again that such formula usage on conditional formatting cannot support by Excel. But I'm not expert on conditional formatting, is anybody can confirm my conclusion? If my conclusion is true, then there's feature difference between AOO and Excel. Then as Pat said the sample was converted from ODS, maybe in this case it is an invalid sample. -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. You are watching all bug changes.
