https://bugs.documentfoundation.org/show_bug.cgi?id=163941
--- Comment #6 from OfficeUser <[email protected]> --- (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.. -- You are receiving this mail because: You are the assignee for the bug.
