Re: [libreoffice-users] calc: file database

On Thu, 2012-02-23 at 23:16 +0100, pcpconsulting wrote:
> I repeat.
> with F4 I can see some database, 3 calc and 1 odb.
> I click right on them but not database are listed, same window as in 
> tools-option-libreoffice base-database. Not db listed at all. Also If I 
> add a new database after reopen the window not database are listed. But 
> still they are open with F4(source data)
> regards
> Fabio

and if you go to
Insert->link to external data 

You don't see anything there either?



> On 23/02/2012 23:10, drew wrote:
> > On Thu, 2012-02-23 at 23:00 +0100, pcpconsulting wrote:
> > > Dear drew
> > >
> > > I tried but nothing happen. Not data source I can find. Not data range
> > > are open.
> > > How I can delete link for these database if I can not know where they
> > > are stored.
> > hmm - I'm a bit stumped.
> >
> > If you did find for all .odb files, do you see any of the registered
> > names matching odb file name?
> >
> > //drew
> >
> >
> > > On 23/02/2012 22:39, drew wrote:
> > > > On Thu, 2012-02-23 at 22:23 +0100, pcpconsulting wrote:
> > > > > Thank Drew
> > > > >
> > > > > but I cancelled all files before named libreoffice on my computer, so
> > > > > the file /.libreoffice was deleted.
> > > > > After that I reinstalled libreoffice3.5 .
> > > > > So you can tell me where calc store the source data. I can try to delete
> > > > > from the files.
> > > > > Regards
> > > > > Fabio
> > > > Right - from within Calc
> > > > Data->Define Range
> > > >
> > > > You will see a list of data ranges.
> > > > Select a named range.
> > > > Click on the More button
> > > > If the data is linked from an external data source it will be listed on
> > > > the next to last line of the dialog.
> > > >
> > > > //drew
> > > >
> > > > > On 23/02/2012 22:00, drew wrote:
> > > > > > On Thu, 2012-02-23 at 21:51 +0100, pcpconsulting wrote:
> > > > > > > My OS , as I wrote before, is linux ubunut 10.4
> > > > > > > oops - missed it.
> > > > > > Ok the configuration file used to be at
> > > > > > ~/.libreoffice
> > > > > >
> > > > > > it is not at
> > > > > > ~/.cofigure/libreoffice
> > > > > >
> > > > > > If you haven't done so yet, double check that old location and rename it
> > > > > > so that it won't be found - it might not hurt to rename the new one
> > > > > > also, that way a new one will be created from scratch on next startup ot
> > > > > > the application.
> > > > > >
> > > > > > //drew
> > > > > >
> > > > > > > On 23/02/2012 21:46, drew wrote:
> > > > > > > > On Thu, 2012-02-23 at 21:35 +0100, pcpconsulting wrote:
> > > > > > > > > Many thanks Drew
> > > > > > > > >
> > > > > > > > > but it is just the problem.
> > > > > > > > > Now I removed all libreoffice program, removed all files regarding
> > > > > > > > > libreoffice in my computer, removed all from the terminal.
> > > > > > > > > I reinstalled libreoffice 3.5.
> > > > > > > > > When I go to
> > > > > > > > >
> > > > > > > > > tools>      option>      libreoffice base>database no database are open. But if I search 
> > > > > > > > > (F4) on calc appear some database(calc) that I used before.
> > > > > > > > > Also I can not remove these database.
> > > > > > > > > More: if I go tools>      option>      libreoffice base>database and I add a new 
> > > > > > > > > database I can not see the database in the window when I reopen. And in the source data 
> > > > > > > > > (F4) still appear the old database.
> > > > > > > > > Please help me.
> > > > > > > > > Thanks
> > > > > > > > Howdy Fabio
> > > > > > > >
> > > > > > > > WEll, that sucks..
> > > > > > > >
> > > > > > > > My first thought is the configuration settings - between 3.4 and 3.5 the
> > > > > > > > location for user configuration data moved. Where to exactly depends on
> > > > > > > > you OS - so your OS? (if Windows which one xp, vista, 7)
> > > > > > > >
> > > > > > > > thanks
> > > > > > > >
> > > > > > > > //drew
> > > > > > > >
> > > > > > > > > On 23/02/2012 19:46, drew wrote:
> > > > > > > > > > On Thu, 2012-02-23 at 09:24 +0100, pcpconsulting wrote:
> > > > > > > > > > > I have a problem with link to database in calc.
> > > > > > > > > > >
> > > > > > > > > > > I use libreoffice 3.5 on linux ubuntu 10.4
> > > > > > > > > > > Before was installed libreoffice 3.3
> > > > > > > > > > >
> > > > > > > > > > > Now when I press F4 in calc appear some database where old, used before
> > > > > > > > > > > installing libreoffice 3.5
> > > > > > > > > > >
> > > > > > > > > > > If I go on tools>      option>      libreoffice base>database  no database are
> > > > > > > > > > > open ( except Bibliography that I have eliminate).
> > > > > > > > > > > Also If I add a new database and I close and reopen ......libreoffice
> > > > > > > > > > > base>      database do not appear any database. It is empty.
> > > > > > > > > > > Please if somebody can help me.
> > > > > > > > > > Hello Fabio
> > > > > > > > > >
> > > > > > > > > > When you create a new database under base there is an option to register
> > > > > > > > > > the database name.
> > > > > > > > > >
> > > > > > > > > > 1- be sure to use that option if you want to see the database from Calc
> > > > > > > > > >
> > > > > > > > > > 2- you can also register existing Base files using tools>      option>
> > > > > > > > > > libreoffice base>database dialog. Simply open that and add in one of the
> > > > > > > > > > new files you created.
> > > > > > > > > >
> > > > > > > > > > If that doesn't help you out ping back, OK.
> > > > > > > > > >
> > > > > > > > > > //drew
> > > -- 
> > > For unsubscribe instructions e-mail to: users+help@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



-- 
For unsubscribe instructions e-mail to: users+help@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