- 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..