The green data bar lines mentioned in bug 90511 didnt get fixed with the patches Markus submitted and i believe this to be due to the order of the rules in LO is different from how it is in Excel. Excel ------ C5:E30 F5:F30 F5:F29 C4:E30 LO ------ C4:E30 C5:E30 F5:F29 F5:F30 This maybe caused by the fact that C5:E30 and F5:F30 have multiple rules with the same range which appear above and below C4:E30 and F5:F29 with Excels rules list, while in LO they are all grouped under one entry in the manage conditional formatting dialog. I assumed this is the case, as deleting F5:F29 in LO fixes the problem.
(In reply to Yousuf (Jay) Philips from comment #0) > LO > ------ > C4:E30 > C5:E30 > F5:F29 > F5:F30 Confirming I see this in Format - Conditional Formatting - Manage. In comment 12 of bug 90511 Darshan commented about the effect of this: "Note the color of the Data Bar is set to "Orange" in Excel but shows Green in Calc." Win 7 Pro 64-bit Version: 5.1.0.0.alpha1+ Build ID: be8512f99bc9ab18e55aabe01cc0ab1e6baea9e6 TinderBox: Win-x86@39, Branch:master, Time: 2015-06-08_05:58:40 Locale: fi-FI (fi_FI)
Created attachment 120311 [details] excel conditional formatting manager Just to further clarify what i meant in the description, here is the full list Excel ------ C5:E30 Color Scale Light Orange to Orange F5:F30 Data Bar Orange F5:F30 Data Bar Brown F5:F29 Data Bar Green C4:E30 Color Scale Orange to Yellow C5:E30 Color Scale Light Orange to Orange C5:E30 Color Scale Yellow to Orange F5:F30 Data Bar Orange F5:F30 Data Bar Light Orange F5:F30 Data Bar Blue
As might have been obvious from my comment in the other bug report this is a WONTFIX.
Must have missed it, closing.
Markus, If I understand this correctly, Calc's evaluation rules differ from Excel's. Why can't this be left open as an enhancement? Is there a reason we couldn't implement both models like we do with the formula syntax(Calc A1 vs Excel A1)?