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.

Growing Rails Applications in Practice

Check out our e-book. Learn to structure large Ruby on Rails codebases with the tools you already know and love.

• Introduce design conventions for controllers and user-facing models
• Create a system for growth
• Build applications to last

Read more Show archive.org snapshot

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.