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

Say thanks

Last edit

Over 9 years ago

Henning Koch

Keywords

paste, excel

License

Source code in this card is licensed under the MIT License.

Heads up: LibreOffice Calc AutoCorrect will change characters when pasting multi-line text

If you paste multiple lines of text into a cell, Calc's AutoCorrect will change the first character of the last line to uppercase:

foo  =>  foo
bar      bar
baz      Baz

To fix this, go to Tools / AutoCorrect Options, choose the *O...

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

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

Copy data from LibreOffice Calc

Related cards: