Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


** Reply to message from Jean-Baptiste Faure <jbf.faure@orange.fr> on Sat, 05
Mar 2011 07:11:20 +0100

See my response below.

Hi Cliff,

Have you tried "Paste special" options ?

JBF

Le 05/03/2011 04:46, Cliff Scott a écrit :
Hi Y'all,

I've run into a major issue with Calc from LO and OOo and was wondering if
anyone else had seen it and if there was a way around it.

I have an Excel Spreadsheet that has a number of pages with about 10 columns.
Most pages have 2 hidden columns and the 2nd hidden column's value is from a
table lookup on another sheet in the same spreadsheet. I use this to
calculate billing on the usage of a number of aircraft. The table lookup is
based on date and aircraft number. I want to copy the rows for the current
billing period to Writer to submit a billing report to finance. I've always
just used Excel and Word to do it with no problems. In trying to switch to LO
when I paste to Writer I get a blank frame box. Double clicking on the box
brings up a "mini" spreadsheet and working with that I can eventually get the
copied rows to display, however the total column comes up with a Err 501.
Expanding the hidden columns is no help. The table look up column also shows
Err 501 after pasting. An indication of the source of the problem may be that
Writer shows the paragraph type as OLE. If I do the copy from Excel and paste
to Writer all is well. Also if I copy from a page with no table look up it is
ok so the problem seems to be that I tries to link to the table rather than
just copying the displayed values. Help! I would really like to move to LO
with this. Any suggestions gratefully received.

--
Cliff
I posted the above several days ago and have had no replies so looking over
what I wrote thought that maybe I need to clarify things.

I have imported an Excel spreadsheet into Calc. No problems, it comes in just
fine.

What I want to do is mark a block of several rows and columns, copy the
displayed values as a table and paste into a Writer document. The unusual
situation here is that there are 2 hidden columns and the values in those
columns are calculated to give me the col. & row numbers to do a table lookup
which with other data in cells in that row is used in the calculation of the
value that appears in the "total" cell for that row. 

My problem is that when I do a copy from Calc and then paste into Writer that
what shows up in Writer is an empty Frame box. If I double click in the box
then a "mini spread sheet" appears and I can scroll and expand it to get the
block of data that I wanted with one exception - the total cells now say Err
501 and not the values that were displayed in Calc. The paragraph type is
also set to OLE which I think is the problem.

The real question is: How do I get it to just copy the values and not be
fancy and try to link to what ever it is trying to link to. In Excel this
works fine, although it copies even the hidden columns and their values, but
I can deal with this if necessary. LO doesn't copy the hidden columns which
is great, but for some reason won't copy just the value in the calculated
cell. If I unhide the two columns then one is copied ok, but the other also
has an Err 501.

Has anyone encountered a problem similar to this? Is there a setting to tell
it to copy just the cell values without trying to link anywhere?

Ideas? Thanks for any and all suggestions.

BTW, OOo also does the same thing.

--
Cliff


Hi Jean-Baptiste,

Thanks for the suggestion. I'm sure I tried it before, but maybe I was
dreaming. Yes, Paste-special does work. Sorry for unnecessarily bothering
everyone. 

Now I have to figure out how to write a macro to select the correct Paste
Special option and paste in one key stroke operation. Pulling down the
options from the Paste toolbar object makes it a two click process which
isn't bad, but the keystroke macro would be ideal.

--
Cliff

-- 
Unsubscribe instructions: E-mail to users+help@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.