Bug 70425

Summary: EDITING: Embedded Firebird - Copying integer values from Calc to Base impossible
Product: LibreOffice Reporter: robert
Component: DatabaseAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: major    
Priority: high CC: iplaw67, lo_bugs, racoon
Version: 4.2.0.0.alpha0+ Master   
Hardware: x86-64 (AMD64)   
OS: Linux (All)   
Whiteboard:
i915 platform: i915 features:
Attachments: Package with database and Calc-document for the data - copy and paste

Description robert 2013-10-13 14:30:00 UTC
Created attachment 87557 [details]
Package with database and Calc-document for the data - copy and paste

Open the package of the attachment. There is a database with 3 different tables. The tables differ in the field-type of the primary-key-field "ID".

There is also a Calc-document with data for this tables.

Mark The data of one of the tables in the Calc-document and try to paste them to one table of the database. The tables with an integer or smallinteger primary-key won't accept the data:
Warning
Incorrect type for setString
Continue anyway?

OK, lets continue. One row would be added with, but the ID isn't the ID of the original table.
When you paste to the table Name_Varchar it would work.

Seems there are only characters allowed when pasting to Base-Firebird.
Comment 1 Terrence Enger 2013-10-13 17:57:18 UTC
I see this on Linux with master commit 95e95e0, fetched 2013-09-19.

Will somebody with Windows or Mac please test, so that we can tell
whether other platforms are afflicted?

Thanks,
Terry.
Comment 2 racoon 2014-07-10 19:17:44 UTC
I am using LibreOffice Version 4.2.5.2 on Windows and have this issue too.
Comment 3 racoon 2014-08-05 11:55:42 UTC
No one wants to fix this problem? The bug still exists in 4.3.0.4 (Windows)...
Comment 4 Alex Thurgood 2015-01-03 17:41:11 UTC
Adding self to CC if not already on

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.