https://bugs.freedesktop.org/show_bug.cgi?id=33899
Ian Goddard <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #21 from Ian Goddard <[email protected]> --- This affects more than dates. Format a column as fraction. Enter 1/2 in one cell. Enter 3/4 in the next row. Sum them in the next row. Expected result is 1 1/4. Actual result is 0. There's also a further date anomoly. One date format is quarters, e.g. 2nd quarter 2012. If you attempt to enter this autocorrupt leaps in after the "d" and converts the "nd" to a single superscript character and the string goes unrecognised as a date. The root of the problem is that there are at least 3 possible data types number, date and text (I don't know the internals - possibly there are more) but data is being treated as one of these, text, before the user has entered sufficient information for the intended data type to be deduced. Premature and irreversible assignment of data type seems to me to be a serious design issue. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
