https://bugs.documentfoundation.org/show_bug.cgi?id=149139
--- Comment #9 from JohnTweed <[email protected]> --- I suppose the real difference between CALC and Mac's NUMBERS is how the change in formatting a column works. When importing into CALC, if the column is made TEXT then no formatting will change that even if the TEXT is all numerical/time/date. When importing into NUMBERS, it seems that the column remains TEXT until a format is changed. The action of choosing a MM:SS format converts the text into the correct type, assuming that is a possible conversion. So NUMBERS seems to post-process the pasted data, whereas CALC tries to pre-process the pasted data, but with a limited selection of conversion operations. -- You are receiving this mail because: You are the assignee for the bug.
