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.
