- Select a range of cells - Apply bolean or any time/date format to the cell selection - Enter numbers into the cells Note that these numbers to are not displayed in the selected format. Workaround: Re-select the cells and apply number format after values have been entered. Perhaps other formats besides boolean and time are also affected. This remains to be found out. Please have a look at the attached video that visualizes the bug.
Created attachment 197666 [details] Video of the bug
Created attachment 197667 [details] Video of the bug
Please attach a sample file. I think this issue was already reported, but I can't find it now.
I'm not sure a sample file is helpful, the point is to have empty cells, and the repro steps are all manual. I can confirm both in a recent daily build and in 3.3.0. Setting it to NEW for now, if it turns out to be a duplicate, it can be closed as one.
Number formats _are_ applied to blank cells, but if a number is typed into a pre-formatted cell then a Boolean or DateTime format is changed to Number. This is on *purpose* because usually no one wants to see a numeric number input value formatted as TRUE or DateTime and it would rather confuse people if it was. The only thing we could sensibly do is if on a Boolean formatted cell the input is 0 or 1 then preserve the Boolean format, else for any other value remove the format as it is currently done. If that wouldn't confuse people..
(In reply to Eike Rathke from comment #5) > ...but if a number is typed into a > pre-formatted cell then a Boolean or DateTime format is changed to Number. > This is on *purpose* because usually no one wants to see a numeric number > input value formatted as TRUE or DateTime and it would rather confuse people > if it was. Hello Eike, Thank you for your comments, which I agree with. (Although Excel and ONLYOFFICE solve this differently) I think the current implementation in LibreOffice makes sense. I will therefore close this issue. I will change the issue's summary for the remaining request: > The only thing we could sensibly do is if on a Boolean formatted cell the input is 0 or 1 then preserve the Boolean format, else for any other value remove the format as it is currently done. If that wouldn't confuse people..
Correction of Comment 6 as this issue should be kept for the request on entering 0 or 1 in boolean formatted cells: Hello Eike, Thank you for your comments, which I agree with. (Although Excel and ONLYOFFICE solve this differently) I think the current implementation in LibreOffice makes sense. I will change the issue's summary for the remaining request: > The only thing we could sensibly do is if on a Boolean formatted cell the input is 0 or 1 then preserve the Boolean format, else for any other value remove the format as it is currently done. If that wouldn't confuse people..