Ask Your Question

daily values by column not recognized as a date

asked 2017-09-06 16:26:16 +0200

Wololo gravatar image


I have created a pivot table in LO calc. My source data is in the same file, on 7 columns and 105 rows. One column ("Day") has daily values, e.g. 03/21/2017, 03/11/2014, etc...

in the pivot table configuration, i set the field "Day" by column, and the result is following column headers (11 columns in this example) :

  • 41642 41643 41644 41645 41646 41647 41648 41649 41650 41651 41652 ...

Obvisouly, the daily values are not recognized as such by the software.

On the contrary, if i set the field "Day" by row, the result is:

  • Tuesday, March 21 2017
  • Tuesday, March 11 2014
  • ...

Can anyone help ? My goal is to set the day by column, and in a next step to group the days by year and month.

Many thanks in advance,

LO Calc version

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-09-07 07:52:08 +0200

pierre-yves samyn gravatar image


I reproduce the problem... but I dot not reproduce if I move the Data field in the Row Fields:


See DayColumn.ods


edit flag offensive delete link more

answered 2017-09-07 10:11:17 +0200

Wololo gravatar image

Thanks pierre-yves samyn for looking on my problem. From your screenshot i don't see that you reproduced the issue. The day values in the column headers of the pivot table are correct, aren't they ?

I attach a screenshot to show the issue from my side. image description

Thanks and regards

edit flag offensive delete link more


@Wololo: my screenshot shows the result after the workaround (mode Data field in Row Fields).

pierre-yves samyn gravatar imagepierre-yves samyn ( 2017-09-07 10:47:15 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-09-06 16:26:16 +0200

Seen: 30 times

Last updated: Sep 07 '17