Apache OpenOffice (AOO) Bugzilla – Issue 61543
Data Pilot treats some number-formatted cells as date-formatted cells
Last modified: 2017-05-20 11:11:21 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 attached. 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.
Created attachment 33800 [details] Example of buggy Data Pilot
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. Frank
changing target
change target from 2.x to 3.x according to http://wiki.services.openoffice.org/wiki/Target_3x
Reset assigne to the default "issues@openoffice.apache.org".