| Summary: | conditional format not working due to direct formating with style:data-style-name | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Oliver Brinzing <oliver.brinzing> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED NOTABUG | ||
| Severity: | normal | CC: | ilmari.lauhakangas, malteo, markus.mohrhard, raal, xiscofauli |
| Priority: | medium | Keywords: | bibisected, bisected, regression |
| Version: | 5.3.3.2 release | ||
| Hardware: | All | ||
| OS: | All | ||
| See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=123659 | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Bug Depends on: | |||
| Bug Blocks: | 87351 | ||
| Attachments: | demo_conditional_format_aoo | ||
Yep, it's ok in 3.6.7.2 Arch Linux 64-bit, KDE Plasma 5 Version: 5.5.0.0.alpha0+ Build ID: c855400e9686ddd8bcba5691393f839f6f52c966 CPU threads: 8; OS: Linux 4.11; UI render: default; VCL: kde4; Locale: fi-FI (fi_FI.UTF-8); Calc: group Built on June 2nd 2017 Arch Linux 64-bit Version 3.6.7.2 (Build ID: e183d5b) This seems to have begun at the below commit. Adding Cc: to Markus Mohrhard; Could you possibly take a look at this one? Thanks da7753060ea125a2bdf21e7af87367142ae59467 is the first bad commit commit da7753060ea125a2bdf21e7af87367142ae59467 Author: Norbert Thiebaud <nthiebaud@gmail.com> Date: Sat Apr 2 21:31:18 2016 -0700 source 2c728b0ae7f52691b1a3d5ab555225f5e8ac95a5 author Markus Mohrhard <markus.mohrhard@googlemail.com> 2016-02-03 19:28:40 (GMT) committer Eike Rathke <erack@redhat.com> 2016-03-31 16:13:52 (GMT) commit 2c728b0ae7f52691b1a3d5ab555225f5e8ac95a5 (patch) tree 879ced4a17952e3e95ae77a95bfa66dc81a5a2be parent eaced256be7e5c2ebcea01d14b2f521629e22848 (diff) tdf#93300, handle hard formatting with cond format correct This was a bug in OOo and old LibreOffice versions that we fixed later. Conditional formatting should not overwrite hard formatting. FWIW, as of LO 7.4.5 the zero value in cell A2 is not displayed, as per conditional format. |
Created attachment 133576 [details] demo_conditional_format_aoo i have several spreadsheet documents originally created with aoo, where zero values will be hidden using conditional formating - but LO will show zero values. steps to reproduce: - open attached spreadsheet with LO -> cell A2 will show 0,00 - open same spreadsheet with aoo412 -> cell A2 is empty the problems is caused due to an existing "style:data-style-name="N4"" attribute: <office:automatic-styles> <style:style style:name="ce3" style:family="table-cell" style:parent-style-name="DecimalNumber" style:data-style-name="N4"> <style:map style:condition="cell-content()=0" style:apply-style-name="HideEmptyValues" style:base-cell-address="Tabelle1.A2"/> </style:style> </office:automatic-styles> the attribute seems to override the conditional formating data style.