Can't get Spanish distionary to stay selected

users
#21

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?

#22

Many Thanks Drew

I have resolved now with command purge - remove -clean all libreoffice and after reinstalled.
But I have this problem now: I work with calc linked to another file in calc as database with about 5000 rows.
The first file calc use many (cerca.vert -in Italian as I am) lookup and now is not fast , more and more less than libreoffice3.3 .
Can you suggest me something
Regards
Fabio

#23

Hi Fabio

Yes, you are not the first person to comment on that. I'm fairly certain
that I saw an open issue on the subject, I am positive I;ve seen it
discussed amongst the developers - so all I can tell you is that it is
being worked on - not a log of help today, but...

//drew

<snip>

#24

Am 23.02.2012 09:24, 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
> database do not appear any database. It is empty.
Please if somebody can help me.
Regards
Fabio

Let's start with the first chain link. Seemingly you have some collection of spreadsheets you want to read as if they were a database.
For several reasons the sheets of a calculator program are the worst container medium to store data for any database purposes.

1) Anyhow, how do the data look like? Can you post a few lines of data here? Just copy the first 3 lines of a list and paste into your mail client.
2) Are there more than one database-like lists in one spreadsheet document? Do these lists share the same structure of fields (columns)?
3) Are there many spreadsheets you want to use like that? Do they also share the same structure of columns?
4) Are you sure that your data are consistent across columns, sheets and documents? Can you be sure that date columns contain nothing but dates and numeric columns contain nothing but numbers?

#25

I have removed libreoffice 3.5 from my computer linux ubuntu and I have reinstalled version 3.3.4
because operating with calc appear very slow.
I use one file in calc linked to another one as dabase with 4000 rows. When I open the first one it is so slow that I can not work.

Fabio

#26

Am 27.02.2012 10:43, pcpconsulting wrote:

I have removed libreoffice 3.5 from my computer linux ubuntu and I have
reinstalled version 3.3.4
because operating with calc appear very slow.
I use one file in calc linked to another one as dabase with 4000 rows.
When I open the first one it is so slow that I can not work.

Fabio

Nobody forces you to use a calculator as a database surrogate.

#27

Thanks for the support.
Anyway is more easy that macros in database. With other releases works fine. So it is not my mistake.

#28

Hi :slight_smile:
It might be the version of java you are using.  Earlier versions of LibreOffice seem to prefer earlier versions of java (the 6u21 release seemed best) but the 3.5.0 needs java 7 which still doesn't seem to have been officially released yet.
http://java.com/en/download/index.jsp
Regards from
Tom :slight_smile:

#29

Am 27.02.2012 11:22, Tom Davies wrote:

Hi :slight_smile:
It might be the version of java you are using. Earlier versions of LibreOffice seem to prefer earlier versions of java (the 6u21 release seemed best) but the 3.5.0 needs java 7 which still doesn't seem to have been officially released yet.
http://java.com/en/download/index.jsp
Regards from
Tom :slight_smile:

Would you please stop spreading this totally wrong information again and again? Calc does not depend on Java by any means.
Unless the operating system is Linux there is no Java related performance problem in any office component. There is a massive performance problem if (and only if) when Base accesses a Java database on Linux (Linux AND Base AND Java-DB). This very particular problem has been cured in 3.5 and older office versions could use a distinct Java version as a work-around.

Back on topic: It is completely impossible to give any qualified advice without knowing what you actually do with your spreadsheet.
See also this overly lengthy and pointless discussion which at least may give some hints about what may be wrong with your spreadsheet: http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=47995

#30

Oh, come on Andreas, he reported an obvious *problem* between two versions - one works fine with his files, the other (newest/latest/greatest) is dramatically slower... obviously *something* *changed*, and *not* for the better.

Fabio... I hope you will take the time to go open a regression bug for this problem...

#31

Am 27.02.2012 14:10, Tanstaafl wrote:

Am 27.02.2012 10:43, pcpconsulting wrote:

I have removed libreoffice 3.5 from my computer linux ubuntu and I have
reinstalled version 3.3.4
because operating with calc appear very slow.
I use one file in calc linked to another one as dabase with 4000 rows.
When I open the first one it is so slow that I can not work.

Nobody forces you to use a calculator as a database surrogate.

Oh, come on Andreas, he reported an obvious *problem* between two
versions - one works fine with his files, the other
(newest/latest/greatest) is dramatically slower... obviously *something*
*changed*, and *not* for the better.

No, he did not report anything at all. He just complains.

#32

No. I did not open the bug, but I was in contact for other problems and the question has been submitted to the developers.
I am not the first to check this.
I hope for the future.
Bye
Fabio

#33

4000 rows is nothing. Shouldn't be a problem for LibreOffice Calc. A
few years ago the maximum number of rows (for OpenOffice.org Calc –
there was no LibreOffice back then) was 32 000 (2¹⁵-768), then they
changed it to 65 536 (2¹⁶), and finally they changed it to 1 048 576
(2²⁰). What was the point, if OpenOffice.org/LibreOffice is not
supposed to be able to handle even 4000 rows?
Speed has always been an issue for LibreOffice/OpenOffice.org, even
though they worked a lot for speed improvements a couple of years ago.