Read more

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

Pascal Roth
December 11, 2014Software engineer

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.

Illustration online protection

Rails Long Term Support

Rails LTS provides security patches for old versions of Ruby on Rails (2.3, 3.2, 4.2 and 5.2)

  • Prevents you from data breaches and liability risks
  • Upgrade at your own pace
  • Works with modern Rubies
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.

Posted by Pascal Roth to makandra dev (2014-12-11 09:28)