Issue 61543 - Data Pilot treats some number-formatted cells as date-formatted cells
Summary: Data Pilot treats some number-formatted cells as date-formatted cells
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.0.1
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2006-02-02 20:54 UTC by kalleanka
Modified: 2017-05-20 11:11 UTC (History)
1 user (show)

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

Example of buggy Data Pilot (6.81 KB, application/vnd.sun.xml.calc)
2006-02-02 20:56 UTC, kalleanka
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description kalleanka 2006-02-02 20:54:52 UTC
The search function of the issue tracker didn't work for me so this may already 
be a reported bug...

This bug is a bit hard to describe so look at the example file that I've 
Data Pilot treats some of the cells that I've manually set to be Number cells 
(Right Click -> Format Cells...-> Numbers -> Number) as Date cells. Whether this 
happens or not seems to have to do with what number i put in the cell.
If you download the attached example and change the value in cell B5 to eg 1.5 
and then refresh the Data Pilot it will work as expected.
Comment 1 kalleanka 2006-02-02 20:56:07 UTC
Created attachment 33800 [details]
Example of buggy Data Pilot
Comment 2 frank 2006-03-10 13:46:41 UTC
Hi Niklas,

as Issue 22315 is closed as double to Issue 1145 and this one is fixed, this
Issue seems somehow different. So please have a look at it.

Comment 3 niklas.nebel 2006-07-14 18:12:12 UTC
changing target
Comment 4 Martin Hollmichel 2007-11-09 16:52:39 UTC
change target from 2.x to 3.x according to
Comment 5 Marcus 2017-05-20 11:11:21 UTC
Reset assigne to the default "".