https://bugs.documentfoundation.org/show_bug.cgi?id=165614
Werner Tietz <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC|[email protected] | Resolution|--- |NOTABUG Status|UNCONFIRMED |RESOLVED --- Comment #3 from Werner Tietz <[email protected]> --- (In reply to Eyal Rozenberg from comment #2) > It's not close to impossible, it _is_ impossible, at the moment - because LO > treats dates as no more than formatted numbers. Otherwise I would have filed > a bug about making it easier. Calc knows exactly 2 types of data: Text and floats. > > > **clear Direct Formatting** means **clear Direct Formatting** fullstop! > > Indeed, but clearing formatting must not make a simple number from a date. what else than a float? > > > > In case your User wish to apply Standard-Date-Format > > > That's only incidentally the case. In my case, the user wants to do what > they say they want to do: Clear any formatting that was applied directly. > > > * should apply some respective Cell-STYLE (recommended) > > They don't want to apply some particular cell style; and the cells in the > selected range may have different styles, which should of course should not > be replaced. > > * or hit **twice** the Date-Format-Button in the Toolbar > > ... and would not want to do this either, since the range of cells includes > many non-date cells. In other words: $User wants to select any random mix of Input ( including random mix of Formatting ) and calc should call $AI to resolve the Formatting-issues?? I'm out! -- You are receiving this mail because: You are the assignee for the bug.
