https://bugs.documentfoundation.org/show_bug.cgi?id=163941
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|normal |enhancement --- Comment #5 from Eike Rathke <[email protected]> --- 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.. -- You are receiving this mail because: You are the assignee for the bug.
