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 > -- Seuls des formats ouverts peuvent assurer la pérennité de vos documents. -- 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 ***
