Copy Cells To WordPad Without TABs

DroopyPawn

I want to create some text in a Calc spreadsheet with one character in each cell. Then I need to copy and paste that text into WordPad but without the TAB characters being inserted between each cell/character. Can this be done?

I could write a visual basic program to eliminate the Tab characters but I'd rather just use OpenOffice and WordPad (or Write).
_________________
Gary Shepherd
www.16tracks.com

DroopyPawn · Posted: Mon Jul 07, 2008 2:40 pm Post subject:

Also, is it possible to view the text in Calc WITHOUT the cell grid lines being visible?
_________________
Gary Shepherd
www.16tracks.com

DroopyPawn · Posted: Mon Jul 07, 2008 2:42 pm Post subject:

Okay, I found how to hide the grid lines but I still need help with removing the Tab characters.
_________________
Gary Shepherd
www.16tracks.com

DroopyPawn · Posted: Mon Jul 07, 2008 3:01 pm Post subject:

Another Option....

Rather than copying and pasting my text into a text editor, it would be even better if I could print the text directly from Calc. However, Calc inserts a little bit of space between each cell. Is there a way to NOT print this tiny space?

For example...
If my cells each contain one em-dash, it would print like this "-----------".
But what I want should look like this " ———-" - without the tiny little spaces.
_________________
Gary Shepherd
www.16tracks.com

jrkrideau · Posted: Tue Jul 08, 2008 4:53 am Post subject:

DroopyPawn · Posted: Tue Jul 08, 2008 7:48 am Post subject:

I figured out a way to remove the Tab characters but I'd still like to be able to print from Calc without the tiny spaces showing up in the printout.
_________________
Gary Shepherd
www.16tracks.com

jrkrideau · Posted: Wed Jul 09, 2008 5:53 am Post subject:

RickRandom · Super User Joined: 27 Jan 2006 Posts: 1082 Location: UK

JohnV · Posted: Wed Jul 09, 2008 10:21 am Post subject:

Select and copy the Calc cells. Open a Writer doc and do Edit > Paste Special > Unformatted text. Then do a Find & Replace for \t (tabs), replace with nothing or a space and check Regular Expressions. Now you copy & paste to WordPad.

DroopyPawn · Posted: Wed Jul 09, 2008 12:52 pm Post subject:

The problem is that I need each character monospaced. They all need to be the same width so that columns and rows line up correctly. That's not a problem when using a monospaced font like Courier New. But the font that I have to use for some of the stuff is not monospaced. Copying all the text to one cell will cause some of the text to align incorrectly.
_________________
Gary Shepherd
www.16tracks.com

David

DroopyPawn · Posted: Thu Jul 10, 2008 10:30 am Post subject:

The problem with using a table is that I still get spaces between the characters. Using Calc makes it easy to edit the data. But the data needs to be printed a certain way. Basically, I'm doing music (tablature). One character per cell.
_________________
Gary Shepherd
www.16tracks.com

machinegun · General User Joined: 24 Mar 2005 Posts: 7

how about

format
column
optimal width = 0

David · Posted: Sat Jul 12, 2008 7:37 pm Post subject:

DroopyPawn · Posted: Sun Jul 13, 2008 12:54 pm Post subject:

There are a few programs that will do some of what I want. But I want more control over the output. Editing tools like copy/paste are much easier to do with a spreadsheet. And I can put tips and memos in the music easily in a spreadsheet.
_________________
Gary Shepherd
www.16tracks.com