How do I copy a cell without CR and LF being appended to end? [closed]
When I click on a Calc cell and hit ctrl-c (or cmd-c), it copies the contents of that cell to the clipboard as expected. BUT, it also appends two additional characters to the end of the copied contents: a carriage return (CR, ASCII dec. code 13) and a linefeed (LF, ASCII dec. code 10). Since I've been experiencing this for a while, and on both Windows and Mac platforms, I'm assuming this is by design. Is there a setting that would allow me to change this behavior so that it just includes the contents of the cell? (I know I can copy from the cell editing box and get just the contents but for my use that is too cumbersome a workaround.) Also, why does it add these?
Try the following sequence of keys:
If the cell contains a value - F2->Ctrl+Home->Ctrl+C (or cmd-c)->Esc
If the cell contains a formula - F2->F9->Enter->Ctrl+C (or cmd-c)->Esc
Yes, it will require extra keypresseds. Simply press Backspace after insertion.
Perhaps your problem can solve simple macro that will delete all line breaks from the text in the clipboard