https://bugs.documentfoundation.org/show_bug.cgi?id=156520
--- Comment #7 from ady <[email protected]> --- > (In reply to ady from comment #5) > > An empty field could, potentially, had meant "no pattern is (forced to be) > > recognized as date". > That's the point, cells always have some format and no patters means text. > (And you can change this on import.) The reporter might or might not refer (in part at least) to the importing dialogue, but in comment 5 I wasn't. Have one cell with default standard format and type in something that might potentially be interpreted as date but that you don't want it to be interpreted as such. Other than preceding the/each value with an apostrophe or pre-formatting the cell(s) as text, the value will be interpreted as date. Using the import dialogue has its own column-formatting capabilities - that's a different case. Usually this behavior is helpful, but for some reason the reporter is having a different, almost opposite situation (with some resulting request). We all raised valid questions; I would suggest waiting for feedback from the reporter to clarify the use-case, needs, and request. -- You are receiving this mail because: You are the assignee for the bug.
