We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

daily values by column not recognized as a date [closed]

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

Wololo gravatar image

updated 2020-08-06 22:25:12 +0200

Alex Kemp 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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-06 22:25:47.846102

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

Question Tools

1 follower


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

Seen: 67 times

Last updated: Sep 07 '17