OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Copy Cells To WordPad Without TABs
Goto page 1, 2  Next
 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
DroopyPawn
General User
General User


Joined: 30 Jun 2004
Posts: 39
Location: Fox, OK

PostPosted: Mon Jul 07, 2008 2:35 pm    Post subject: Copy Cells To WordPad Without TABs Reply with quote

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
Back to top
View user's profile Send private message Visit poster's website Yahoo Messenger
DroopyPawn
General User
General User


Joined: 30 Jun 2004
Posts: 39
Location: Fox, OK

PostPosted: Mon Jul 07, 2008 2:40 pm    Post subject: Reply with quote

Also, is it possible to view the text in Calc WITHOUT the cell grid lines being visible?
_________________
Gary Shepherd
www.16tracks.com
Back to top
View user's profile Send private message Visit poster's website Yahoo Messenger
DroopyPawn
General User
General User


Joined: 30 Jun 2004
Posts: 39
Location: Fox, OK

PostPosted: Mon Jul 07, 2008 2:42 pm    Post subject: Reply with quote

Okay, I found how to hide the grid lines but I still need help with removing the Tab characters.
_________________
Gary Shepherd
www.16tracks.com
Back to top
View user's profile Send private message Visit poster's website Yahoo Messenger
DroopyPawn
General User
General User


Joined: 30 Jun 2004
Posts: 39
Location: Fox, OK

PostPosted: Mon Jul 07, 2008 3:01 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Visit poster's website Yahoo Messenger
jrkrideau
Super User
Super User


Joined: 08 Aug 2005
Posts: 6732
Location: Kingston ON Canada

PostPosted: Tue Jul 08, 2008 4:53 am    Post subject: Reply with quote

DroopyPawn wrote:
Okay, I found how to hide the grid lines but I still need help with removing the Tab characters.


I think the easiest way would be to concatinate the cells and export the resultling column.
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2
Back to top
View user's profile Send private message
DroopyPawn
General User
General User


Joined: 30 Jun 2004
Posts: 39
Location: Fox, OK

PostPosted: Tue Jul 08, 2008 7:48 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Visit poster's website Yahoo Messenger
jrkrideau
Super User
Super User


Joined: 08 Aug 2005
Posts: 6732
Location: Kingston ON Canada

PostPosted: Wed Jul 09, 2008 5:53 am    Post subject: Reply with quote

DroopyPawn wrote:
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.


How ? Enquiring minds want to know Smile
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2
Back to top
View user's profile Send private message
RickRandom
Super User
Super User


Joined: 27 Jan 2006
Posts: 1082
Location: UK

PostPosted: Wed Jul 09, 2008 7:55 am    Post subject: Re: Copy Cells To WordPad Without TABs Reply with quote

DroopyPawn wrote:
I need to copy and paste that text into WordPad but without the TAB characters being inserted between each cell/character.
What do you want between the characters? If nothing, then I'd agree with the concatenate suggestion, e.g. n a spare cell:

=CONCATENATE(A14;B14;C14;D14;E14)

or

=A14&B14&C14&D14&E14

then print these cells, not the source data.

(A bit cumbersome to do all the concatenation if many cells.)

Maybe a Paste Special option in Word Pad?
Back to top
View user's profile Send private message
JohnV
Administrator
Administrator


Joined: 07 Mar 2003
Posts: 9183
Location: Lexinton, Kentucky, USA

PostPosted: Wed Jul 09, 2008 10:21 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
DroopyPawn
General User
General User


Joined: 30 Jun 2004
Posts: 39
Location: Fox, OK

PostPosted: Wed Jul 09, 2008 12:52 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Visit poster's website Yahoo Messenger
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Wed Jul 09, 2008 3:08 pm    Post subject: Re: Copy Cells To WordPad Without TABs Reply with quote

DroopyPawn wrote:
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.


Why not do it directly in a Writer Table?

David.
Back to top
View user's profile Send private message
DroopyPawn
General User
General User


Joined: 30 Jun 2004
Posts: 39
Location: Fox, OK

PostPosted: Thu Jul 10, 2008 10:30 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Visit poster's website Yahoo Messenger
machinegun
General User
General User


Joined: 24 Mar 2005
Posts: 7

PostPosted: Sat Jul 12, 2008 5:55 pm    Post subject: Reply with quote

how about

format
column
optimal width = 0
Back to top
View user's profile Send private message
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Sat Jul 12, 2008 7:37 pm    Post subject: Reply with quote

DroopyPawn wrote:
Basically, I'm doing music (tablature)....


Is there not specialty software for doing that?

David.
Back to top
View user's profile Send private message
DroopyPawn
General User
General User


Joined: 30 Jun 2004
Posts: 39
Location: Fox, OK

PostPosted: Sun Jul 13, 2008 12:54 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Visit poster's website Yahoo Messenger
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Goto page 1, 2  Next
Page 1 of 2

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group