| View previous topic :: View next topic |
| Author |
Message |
bramkuijper
General User
Joined: 03 Sep 2006
Posts: 5
|
 Posted: Sun Sep 03, 2006 1:51 pm Post subject: copy from base - paste in calc |
 |
|
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:
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 |
|
 |
DrewJensen
Super User
Joined: 06 Jul 2005
Posts: 2616
Location: Cumberland, MD
|
| Posted: Sun Sep 03, 2006 2:28 pm Post subject: Re: copy from base - paste in calc |
|
|
| 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 |
|
|
bramkuijper
General User
Joined: 03 Sep 2006
Posts: 5
|
| Posted: Mon Sep 04, 2006 12:16 pm Post subject: |
|
|
| OK, admitted, that did work indeed. thanks a lot! |
|
| Back to top |
|
|
DrewJensen
Super User
Joined: 06 Jul 2005
Posts: 2616
Location: Cumberland, MD
|
| Posted: Mon Sep 04, 2006 12:49 pm Post subject: |
|
|
| sorry, I never got back...but as I think about it..that was, is, the easiest way. |
|
| Back to top |
|
|
|
