I create a new table with an integer primary key.
I set the Autovalue to Yes.
I save the new table.
I open the table to create records.
The Autovalue of the primary key does not works.
If I edit the table the setting of the Autovalue is not to Yes but to No.
It is impossible to create a table with Autovalue primary key.
Which database do you use? If you chose the embedded Firebird-Database it doesn't work yet. It's Bug69949 . The embedded HSQLDB works here with AutoValue.
I use HSQLDB.
The OS of my PC is Windows 7.
Can't confirm for OpenSUSE 12.3, 64bit rpm Linux, LO 22.214.171.124
Autovalue works as expected. Could create a table with it, could see the value. We must find someone with Win7, I think.
I cannot confirm it. I have created a new database table with the embedded HSQLDB. The primary key has type INTEGER and autovalue works as expected, when opening the table.
How do you try to enter new records?
I work with Version: 126.96.36.199 Build ID: d7dbbd7842e6a58b0f521599204e827654e1fb8b on Windows 7 (32bit).
Can you please attach the .odb file, where autovalue does not work?
Is this post relevant?
Created attachment 95164 [details]
It's just a test to see if the setting of autovalue to Yes is maintained after saving
I have uninstalled the version 4.2.11 and installed the version 4.1.5.
The problem is the same : the setting of autovalue to yes is not maintened after saving the table.
I have on the same PC a Oracle VM Box with Debian installed and Libre Office. Autovalue works perfectly on this virtual machine.
On pc Debian x86-64 with 4.2 sources updated some days ago, I don't reproduce the problem with the attachment and following comment 6.
I don't know how it could have an impact but just to be sure, could you rename your LO directory profile (see https://wiki.documentfoundation.org/UserProfile) and give it a new try?
François: any update here? BTW, there's now 4.2.4 LO version.
Hello Francois, *,
I cannot confirm your bug with LO Version: 188.8.131.52 Build-ID: 9ed0c4329cf13f882dab0ee8b9ecd7b05e4aafbb (parallel installed, following the instructions from https://wiki.documentfoundation.org/Installing_in_parallel) with Germanophone lang- as well as helppack on Debian Testing i686, sorry ... :( Did you try to rename your profile, as Julien has recommended it to you in comment #7? Does it change anything? And which Java version are you using?
It would be nice, if you could answer our comments, so we can change the status back to unconfirmed ... ;)
Sorry for the inconvenience and have a nice evening
I have just found the solution to my problem.
In Tools/Options/LibreOfficeBase/Connexions/ActiveConnexionPool the port
com.sem.star.sdbcx.comp.hsqldb.Driver was set to yes.
Setting it to no was the solution to the problem.
> Julien Nabet <email@example.com> changed:
> What |Removed |Added
> Status|UNCONFIRMED |NEEDINFO
> Ever confirmed|0 |1
> --- Comment #8 from Julien Nabet <firstname.lastname@example.org> ---
> FranÃ§ois: any update here? BTW, there's now 4.2.4 LO version.
> You are receiving this mail because:
> You reported the bug.
François: do you reproduce this with 4.2.6 LO version? Also, would you have some time to give a try to prerelease 4.3.0RC2? (see http://www.libreoffice.org/download/pre-releases/)
Lionel: put you in cc since you might be interested in this one.
On pc Debian x86-64 with master sources updated today, I could reproduce this.
I noticed that when editing the table, the autovalue and other fields are disabled ("greyed") with pool connection for the driver enabled.
Would it be on purpose?
Adding self to CC if not already on
Dear Bug Submitter,
This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INVALID due to lack of needed information.
For more information about our NEEDINFO policy please read the wiki located here:
If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed.
Thank you for helping us make LibreOffice even better for everyone!
This NEEDINFO message was generated on: 2015-07-18
As I had wroten in Comment 10 my problem is solved.
Now I use the 184.108.40.206 version without any more problem.
The setting of autovalue to yes is maintained after saving.
(In reply to Desfontaine François from comment #15)
> As I had wroten in Comment 10 my problem is solved.
> Now I use the 220.127.116.11 version without any more problem.
> The setting of autovalue to yes is maintained after saving.
So let us set this bug to "Resolved" and "Worksforme".
I was giving a try to tdf#42905 that I could reproduce and found (again! since I was already in cc) this bug on Google searching "hsqldb autovalue".
1) Isn't it a dup?
2) ActiveConnexionPool is disabled by default and even if I enable it, com.sun.star.sdbcx.comp.hsqldb.Driver is already to NO and it doesn't work.
Did I miss something?