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 from base - paste in calc

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
bramkuijper
General User
General User


Joined: 03 Sep 2006
Posts: 5

PostPosted: Sun Sep 03, 2006 1:51 pm    Post subject: copy from base - paste in calc Reply with quote

Is there any way possible to copy-paste rows of values from base to calc?

If I copy this row of text values from a table in Base::
Code:

Blah
Blah
Blah
Blah
Blah


and paste it into an already opened spreadsheet in Calc [i just click on the first cell that's available], and I just get one single cell filled with Blah:
Code:

Blah

instead of 5 subsequent cells. Great. That's quite some loss of data [especially if you're a company with some big financial puppys that just need to be copy-pasted sometimes]

anybody knows a solution to this?

* prepared for an answer that it is not possible, grabs his old copy of M$ office and starts to install wine...[/code]
Back to top
View user's profile Send private message
DrewJensen
Super User
Super User


Joined: 06 Jul 2005
Posts: 2616
Location: Cumberland, MD

PostPosted: Sun Sep 03, 2006 2:28 pm    Post subject: Re: copy from base - paste in calc Reply with quote

bramkuijper wrote:


* prepared for an answer that it is not possible, grabs his old copy of M$ office and starts to install wine...[/code]


Keep your copy MS Office in the bookcase -

First I have to go feed the kids...but then I will show you a solution.

If you like open a blank Calc file. Hit F4, open a database table and select only a few records from the grid on the right of the database window. Drag these to the sheet...this will give you a hint as to the solution.

Granted it is not as nice as copy / paste..but it works with queries also..

Till later.


Drew
Back to top
View user's profile Send private message Send e-mail Visit poster's website
bramkuijper
General User
General User


Joined: 03 Sep 2006
Posts: 5

PostPosted: Mon Sep 04, 2006 12:16 pm    Post subject: Reply with quote

OK, admitted, that did work indeed. thanks a lot!
Back to top
View user's profile Send private message
DrewJensen
Super User
Super User


Joined: 06 Jul 2005
Posts: 2616
Location: Cumberland, MD

PostPosted: Mon Sep 04, 2006 12:49 pm    Post subject: Reply with quote

sorry, I never got back...but as I think about it..that was, is, the easiest way.
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
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