Issue 53244 - TIMESTAMP and TIME are not imported in datapilot
Summary: TIMESTAMP and TIME are not imported in datapilot
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: 680m122
Hardware: PC Windows XP
: P3 Trivial with 3 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
: 81848 (view as issue list)
Depends on:
Reported: 2005-08-12 12:38 UTC by Regina Henschel
Modified: 2017-05-20 11:13 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description Regina Henschel 2005-08-12 12:38:56 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"
(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
Comment 1 frank 2005-09-12 15:12:30 UTC
Hi Niklas,

one for you I think.

Comment 2 Regina Henschel 2007-11-18 20:52:28 UTC
*** Issue 81848 has been marked as a duplicate of this issue. ***
Comment 3 Regina Henschel 2007-11-18 20:54:05 UTC
Example documents are attached to issue 81848
Comment 4 zenyatta 2008-02-22 14:31:50 UTC
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.

Comment 5 Marcus 2017-05-20 11:13:51 UTC
Reset assigne to the default "".