https://bugs.freedesktop.org/show_bug.cgi?id=82765

--- Comment #3 from [email protected] ---
I looked again into the file I attached yesterday and found that in style
Untitled 1, 2, and 3 the number format was messed up like you described it (#"
"###" "###" "###" "###" "##0)

When I created the attached test file I did the following
- Select column
- right click select Format cell > Numbers
- set format to 0.0
- clicked OK
- selected column
- Format > Conditional format > conditions
- select condition (e. g. greater than) 
- select New Style > Background > select ONLY a color > OK
- added second and third CF the same way
- clicked OK
>> I did NOT look into the number format when I created a New Style
>> I only checked Number Format by right clicking to the cell > Format cells > 
>> Numbers and there it was always - even after applying the new style Untitled 
>> -  as set (0.0)

I just repeated the above described procedure again and got the same result.

With your hint about the number format in Untitled format I looked into the
Untitled Style > Modify > Numbers > Decimal Place = 1 and then all cells with
this format show correct format 0.0.

For my understanding the bug is now that the number format first applied to a
cell remains when it is checked by right clicking to a cell and go Format Cells
> Numbers but in reality the format from the CF is applied but not visible when
checking the applied format directly at the cell by right clicking and go
Format Cells > Numbers.

Side note on importance settings: You have more experience, thus just go ahead.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to