Summary: | Conditional Formatting breaks cell formatting | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | armin |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | normal | CC: | buzea.bogdan, raal |
Priority: | medium | Keywords: | bibisected, bisected, regression |
Version: | 7.0.4.2 release | ||
Hardware: | x86-64 (AMD64) | ||
OS: | Linux (All) | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | Eike Rathke | |
Bug Depends on: | |||
Bug Blocks: | 87351 | ||
Attachments: |
ODS file demonstrating the bug
Screenshot how the bug looks in LO 7.0.4.2 Screenshow how the file looks in LO 6.1.5.2 |
Created attachment 175615 [details]
Screenshot how the bug looks in LO 7.0.4.2
Created attachment 175616 [details]
Screenshow how the file looks in LO 6.1.5.2
This seems to have begun at the below commit. Adding Cc: to Eike Rathke; Could you possibly take a look at this one? Thanks c3dc960a90a62f0343f99cc63f4e446ea8292426 is the first bad commit commit c3dc960a90a62f0343f99cc63f4e446ea8292426 Author: Jenkins Build User <tdf@pollux.tdf> Date: Sun Oct 27 00:18:08 2019 +0200 source 2b0626161d3ef7c4a51007018d13ec391d3a2b04 https://git.libreoffice.org/core/+/2b0626161d3ef7c4a51007018d13ec391d3a2b04 In attachment 175614 [details] from comment 0, the conditional format uses the "Untitled2" style, which has the "General" number format. Before LO 7.0, the base direct format is modified only by applying the border in the "Untitled2" style. Since LO 7.0, the base direct format is basically avoided/ignored when the conditional format is applied, and so the number format from the "Untitled2" style completely overrides the "date" direct format. IDK whether this was done on purpose for LO 7.0, or this is some unwanted consequence of some other decision/change. I guess only Eike can answer that(?). |
Created attachment 175614 [details] ODS file demonstrating the bug The error occurred in an ODS file being edited the last time with LO 6.1.5 when the behavior was as I expected. I have a list of data where in the first column are timestamps and other data right to it. I created a conditional format to create a border on the top if the difference of the timestamp in the first column to the one in the row above is above a limit (to make lines between the days). The timestamps are all formatted with "DD.MM.YY hh:mm" (done by LO automatically on input). In the first cell of a day, starting with LO 7.0.4.2 (not having tried any version between 6.1.5 and 7.0.4.2!) the cell formatting is ignored and the value is displayed as a number.