Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index

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.


Unsubscribe instructions: E-mail to
List archive:
*** All posts to this list are publicly archived for eternity ***


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.