** Reply to message from Jean-Baptiste Faure <[email protected]> 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 [email protected] List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
