Is there any way for Calc to reliably accept all plain text data into cells?
I need to create a table of test results (from Fiddler) where each cell would look like this; 0:00:00.046. I have formatted the cells as text. Calc changes my data, for the example above to 00:00:00:05, perhaps formatting it as Time but I am not sure on this point
edit: note for posterity; pasting the same data copied from Notepad++ does not exhibit this auto-rounding of the number as when the text source is Fiddler. I have raised a bug just in case this changing behavior is not by design (https://bugs.freedesktop.org/show_bug.cgi?id=74138)