[libreoffice-users] Re: [calc]when link to external data, which is libreoffice .odb file, OK button disabled

On 01/06/14 07:50, Larry Evans wrote:
> On 01/05/14 16:53, mariosv wrote:> Please take a look to documentation:
>  >
> https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Calc_Guide
>
>  > Chapter 10 Linking Calc Data
>  > Linking to registered data
>  >
> sources..................................................................................18
>
>  > Viewing data
>  >
> sources.................................................................................................................
>
>  > 19
>  > Editing data
>  >
> sources..................................................................................................................
>
>  > 20
>  > Launching Base to work on data
>  >
> sources..................................................................................
>
>  > 20
>  > Using data sources in Calc
>  >
> spreadsheets..................................................................................
>
>  > 20
>  >
>  > Miguel Ángel.
>  >
>
> Thank you very much Miguel.  The reference you gave was *much*
> better than the help provided by my pressing the Help button
> in calc.
>
> Following the instructions in the reference you gave, I was able to
> copy the database data to calc.  Then I tried OLE linking from calc to
> the database.  It appeared to work in calc.  Then I changed the
> database, expecting the changes to be propagated to calc; however, the
> libreoffice just closed (both calc and base and the writer which I was
> using to read the LibreOffice_Calc_Guide you gave).  When I attempted
> to reopen the Writer doc, it worked.  I closed the Writer doc and
> attempted to open the calc document.  Both CPU's kept jumping up and
> down (high of 100% or around there) and memory use gradually rose to
> 89% before LibreOffice again stopped.
>
> Have you any suggestion about how to recover the data
> (it was a toy example; so, no big deal if I can't
> recover) and how to avoid this problem in the future?
>
> BTW, my OS and LibreOffice version were given in my OP.
>
>
> -regards,
> Larry
I was able to open the base file w/o problem.
I'll just delete the calc file and create a new calc
and try again.

I tried finding a bug for this here:

  https://bugs.freedesktop.org/query.cgi

using search strings:

  ole link calc base

then:

  ole link calc

then:

  ole link

but got zero bugs found.

-regards,
Larry




--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted