The copying and pasting seems to work in that the appropriate value appears in the cell. However, if this cell is part of a SUM function the value in that cell is not recognized. If the value is typed into the cell the SUM function works correctly. Am I doing something wrong?
Hello,
this most probably happens since the copied content isn’t recognized as a number but text (watch left alignment of text instead of right alignment of numbers) and SUM treats text as 0 (zero). You may also take decimal delimiter into account - dot . vs. comma , (may be MS calculator uses a different one than your LibreOffice locale requires).
You may need to use Edit -> Find & Replace and eliminate all non-numeric characters using:
Search [^[[:digit:],]] or [^[[:digit:].]] (depending on your locale)
Replace keep empty
Other Options [X] Current selection only and [X] Regular expressions
Thank you for the explanation… In effect it means that ms calculator is not convenient to use with Libreoffice Calc. I have previously operated this same spreadsheet with Ubuntu 18.04 with their in-built calculator without this problem. Is there a more appropriate calculator to use in Windows 10 to interface with Libreoffice Calc. (Sorry, perhaps this is not a question appropriate to this forum.) Regards.