https://issues.apache.org/ooo/show_bug.cgi?id=124844
--- Comment #8 from mroe <[email protected]> --- Sorry, my fault. I tried first =Date(…); then I changed it to =Date(…)+1. In this case it stays as date. > > And it works also for TIME(); try =TIME(12;13;14)+1. But the problem is, > I don 't think that we should worry about such special cases, user can apply > a cell formatting if required. All cases are special cases. And every "automagic" behaviour satisfies always only a (lesser or bigger) piece of users. In addition to issue 124807: Changing a format should only be acceptable for unformatted cells. Especially if a cell style with a number format is applied to a cell only _this_ number format should be used and not been overwritten! -- You are receiving this mail because: You are the assignee for the issue. You are watching all issue changes.
