https://bugs.documentfoundation.org/show_bug.cgi?id=156748
Bug ID: 156748 Summary: CALC adopting Excel border line weights has corrupted existing sheets especially with Conditional Formatting Product: LibreOffice Version: 7.4.7.2 release Hardware: All OS: Windows (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: that.man.co...@gmail.com Description: Existing sheet cells have been defined with the original LO line weights for outline borders. When cells are conditionally formatted, the border line weight is defined - initially as standard weight. Recent changes have implemented new line weights as the original LO standard weights clashed with the EXCEL heavier standard line weights. Original LO standard line weights in existing sheets remain as their former weights. New cell border weights in existing sheets are constructed using the new default so inconsistency of outlines is creeping into existing sheets If Conditional formatting is applied then the new EXCEL defaults are applied, thereby creating outline anomalies. SEE ATTACHED SCREEN IMAGE Steps to Reproduce: Using any sheet containing outline formatting created BEFORE the new line weights were adopted. Create any conditional formatting to change the characteristics of the fill colour and observe that the outline weight is now changed to the new weight. ISODD(ROW()) is a simple condition to flip fill colours This is probably to be expected as the new condition will imply the new weights but surely something needs to be in place to either update all existing line weights on all sheets to ensure consistency of weights or ensure the user is aware of the inconsistent line weights and any possible manual settings to obviate the anomaly. The obverse also applies. If an existing CF contains the original LO Line Weights and is applied to a newly outlined array then the CF corrupts the later EXCEL weight outlines with the original LO weights Actual Results: See Attached Image Expected Results: Consistent line weights Reproducible: Always User Profile Reset: No Additional Info: Version: 7.4.7.2 (x64) / LibreOffice Community Build ID: 723314e595e8007d3cf785c16538505a1c878ca5 CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: sv-SE (en_GB); UI: en-GB Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.