Problem description: Trying to fill a field of type TIME with data results in error message, record is not saved. Steps to reproduce: 1. create a table containing a field of type TIME 2. Open table and try to fill in data (e.g. 1:00:00) 3. Try to save the record Current behavior: The Record is NOT saved, instead the following error is diplayed: --------------------------------- Error inserting the new record Error-Code: -1 For input string: "5900000000.999999999" --------------------------------- (floating number seems to depend on entered time value) Expected behavior: Record is saved without problem, like e.g. in 3.6.6.2 Operating System: All Version: 4.1.0.1 rc Last worked in: 3.6.6.2 release
adding Lionel to CC
Hello Nino, *, I can confirm it with LO Version: 4.1.0.1 Build ID: 1b3956717a60d6ac35b133d7b0a0f5eb55e9155 and installed Germanophone lang- as well as helppack under Debian Testing AMD64 ... :( HTH Thomas.
In general, please don't set bug status to NEW before a second person has reproduced the problem. Reproduced with embedded DB (HSQLDB).
fyi: also works well in 4.0.4. @Lionel resp. initial bug status: I know but we've had a mailing list discussion before, so I already knew the bug was confirmed by Thomas.
Lionel Elie Mamane committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=b45b566e172938fd82f2be610c6c9dace87d4248 fdo#66216 fix DBTypeConversion::toTimeString format The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Lionel Elie Mamane committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=ac146c16c0f4707aa8a26e479902a124e4e1b7e4 fdo#66216 fix DBTypeConversion::toTime overflow The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Lionel Elie Mamane committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=83dc5c075884dfdb71952aa2617cc6f63dcc56ad fdo#66216 JDBC no fractional second in time format The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Fix for 4.1.0 submitted to gerrit for review
Lionel Elie Mamane committed a patch related to this issue. It has been pushed to "libreoffice-4-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=fe89aa916601e53637259c757a4da433fbc4feda&h=libreoffice-4-1 fdo#66216 fix DBTypeConversion::toTimeString format It will be available in LibreOffice 4.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Lionel Elie Mamane committed a patch related to this issue. It has been pushed to "libreoffice-4-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=82593374493c967bbb1ba15d005470d7f108ae87&h=libreoffice-4-1 fdo#66216 fix DBTypeConversion::toTime overflow It will be available in LibreOffice 4.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Lionel Elie Mamane committed a patch related to this issue. It has been pushed to "libreoffice-4-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=f4fcf5464c249fe15d5e8d3dd09df8b377bcd559&h=libreoffice-4-1 fdo#66216 JDBC no fractional second in time format It will be available in LibreOffice 4.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.