Apache OpenOffice (AOO) Bugzilla – Issue 53244
TIMESTAMP and TIME are not imported in datapilot
Last modified: 2017-05-20 11:13:51 UTC
(1)Open new OOo-base-document and generate a registered database with a table, that contents fields with type TIMESTAMP, type DATE, type TIME, and some type that works, like INTEGER. (2)Fill the table with some data, so that no record has empty fields. (3)save it (4)Open new OOo-calc-document (5)Use Data-DataPilot-Start, Selection "Data source registered in OpenOffice.org" (5)Selection Database: your new one; Type: Sheet; DataSource: your new datatable (6)Drag all field buttons to "row field", OK (7)Notice that the fields with type TIMESTAMP and TIME are empty. It is not a problem in general. You can use this fields without problems with controls in a form in that same sheet. It seem to be a specific problem of DataPilot.
Hi Niklas, one for you I think. Frank
*** Issue 81848 has been marked as a duplicate of this issue. ***
Example documents are attached to issue 81848
confirm this issue both on linux and winxp. i think thi issue must be elected as bug; not a defect it's very important to be solved quickly for business adoption. datapilot is very important. regards alessandro
Reset assigne to the default "issues@openoffice.apache.org".