Bug 141071 - FORMATTING: Conditional formatted cells ignore own formatting options
Summary: FORMATTING: Conditional formatted cells ignore own formatting options
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.7.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-03-17 04:09 UTC by dmitry.gredyushko
Modified: 2021-04-15 01:47 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
The file reproducing the bug (9.37 KB, application/ods)
2021-03-17 04:47 UTC, dmitry.gredyushko 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description dmitry.gredyushko 2021-03-17 04:09:16 UTC 
Description:
When a conditional format applies to a cell, it breaks the formatting options of the cell.
For example, the cell with a number format 0,00000000 after applying a conditional format acts like it would have standard format (with E- and unlimited decimal digits).

Steps to Reproduce:
1. Set the number format 0.00000000 for the cell.
2. Enter the value 0.000012345 into the cell.
3. See how it present the number value (0.00001235).
4. Set a conditional style for the cell.
5. See how it present the number value now (1.2345E-05).

Actual Results:
1.2345E-05

Expected Results:
0.00001235


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Version: 7.1.1.2 (x64) / LibreOffice Community
Build ID: fe0b08f4af1bacafe4c7ecc87ce55bb426164676
CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: Skia/Vulkan; VCL: win
Locale: ru-RU (ru_RU); UI: ru-RU
Calc: threaded
Comment 1 dmitry.gredyushko 2021-03-17 04:47:46 UTC 
Created attachment 170521 [details]
The file reproducing the bug

I could not reproduce the bug on another file.
Thats why I attach this file.
Comment 2 m_a_riosv 2021-03-17 12:20:32 UTC 
'cf1' style has the standard format for numbers while C4 has a direct format, change that format or change default format to what you like.