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