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