If I copy a rectangular array of cells that all contain numbers from one Calc doc and paste it into another, a few cells are pasted with type=String ( TYPE() gives 2 ) whereas most get pasted as type Number. Those pasted as String of course don’t get included in SUM(…) and the like.
Why is this and can I prevent it?
In the source Calc doc the columns containing the ‘copy’ cells are Formatted with ‘Number Format’ set to “Number”.
( If I export the destination doc as .xls I can see the bad cells have ‘’ whereas the good ones have ‘’.)