[Libreoffice-bugs] [Bug 113307] Conditional formatting: false cell number format displayed that's defined by a cell style

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=113307

Timur <gtimur at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Severity|normal                      |minor

--- Comment #5 from Timur <gtimur at gmail.com> ---
I'm still not sure what is the exact bug here. We need to better explain it.

1. C2:D2 have CF: 
- if cell value is INT(C2), apply style Whole numbers (it doesn't)
- if cell value is not INT(C2), apply style Decimal numbers (which it does for
C2 and D2, can be seen if Decimal numbers is red).

2. C2 cell value is 90,9 but instead of seing Decimal numbers (from CF) I guess
we see applied direct formatting that overrides style formatting (see Bug
93300) and that is Number with 0 decimal places. 

3. What I don't understand is why D2 on fileopen shows Decimal numbers although
it has the same direct formatting as C2. Is it related to Bug 114860 or there's
some "perfectly logical explanation".

4. D2 has value of "4.90649064906491" and cached cell content of "5". Why does
it show 4,906 on fileopen? Why does it change to 5 on recalc or some change? 
I guess there's the answer to the original bug report that 5 is pasted (similat
to what Thomas noted). 
Since recalc changes view, I'll set to minor. 

Different with OO 3.3 (90,9 and 5), LO 4.0 and  LO 4.2 (90,9 and 4,906). Repro
6.0 and 6.3+ (91 and 4,906).

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190115/6a19d001/attachment.html>