https://bugs.documentfoundation.org/show_bug.cgi?id=170398
--- Comment #9 from ady <[email protected]> --- Created attachment 205240 --> https://bugs.documentfoundation.org/attachment.cgi?id=205240&action=edit CF vs DF vs DF+SF Is this about importing an xlsx file that was originally created in Excel? If that is the case, perhaps the import should rather consider the conditions (for negative numbers in this example), and create a second Custom CF (or rather a second rule within the same Custom CF). This could be tricky when saving back the same file as xlsx. Does Excel deal with CF using Style Format exclusively, as LO Calc does? I don't think so (but I could be wrong). Unfortunately, in terms of Calc, the “correct” way to achieve the OP’s desired effect is to use adequate Styles (and Conditional Formats with adequate rules). Anyway, I repeat, the conflict is not really about CF; this is Direct Format vs Style Format in Calc (i.e. same issue happens without using CF). I am attaching an ods file to show that. (In reply to Heiko Tietze from comment #8) > If CF is active any color setting on the cell whether DF or per CS is > ignored by Excel. Shall we do the same? Or consider it as freedom for the > user. Please note that the question is relevant for exporting (to xls(x)), but not about saving as ods. Questions about why similar xlsx vs ods files look different will rise anyway; ATM such question is about Excel. If any DF/SF logic is modified, be prepare for the question to possibly be about Calc instead. Before changing this DF/SF logic (even if it is about import/export), I would suggest asking for opinions from _experienced_ Calc developers and users. -- You are receiving this mail because: You are on the CC list for the bug.
