Heads up: LibreOffice Calc adds quotation marks when copying data from multi-line cells

Copy data from LibreOffice Calc

When you copy data from multi-line cells in LibreOffice Calc, quotation marks are automatically added, which you may not want.

For example with license keys:

09:46:24 [✔] pascal:~> icdiff license license_copy 
license                           license_copy                           
===== LICENSE BEGIN =====         "===== LICENSE BEGIN =====             
00000yIeXfhGSbt"yULWQR9n          00000yIeXfhGSbt""yULWQR9n        
olysFAv105bHmKOiqbxRX"Yr          olysFAv105bHmKOiqbxRX""Yr        
===== LICENSE END =====           ===== LICENSE END ====="

See how the copied license is wrapped in quotes and has its inner quotes doubled.

Probably this is due to Calc's internal data representation. The quotes are added so it knows the copied content belongs together, to prevent itself from writing each line into its own row.

Pascal Roth Over 9 years ago