Re: [libreoffice-users] LO Calc copy/paste problem

** 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 ***