Ask Your Question

Pivot tables version not working in v

asked 2019-03-10 14:27:18 +0100

razor gravatar image

Hi I have version and a cvs file which I use to create a pivot table have no problems, but on another computer with version using the same data file the pivot table is created without any data in the tables. Any one having the same problem.image description(/upfiles/15522239605968652.jpg)

edit retag flag offensive close merge delete


Can't possibly your two systems have different LO locales configured, and your csv being linked using "default" language - so that on a system with a different locale, its import gives strings where numbers expected?

See also

Mike Kaganski gravatar imageMike Kaganski ( 2019-03-10 16:44:43 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-03-10 16:49:11 +0100

razor gravatar image

updated 2019-03-10 17:04:55 +0100

Ok just uninstalled from computer and installed the copy that is installed on the computer that the pivot table works on opend the same data cvs file and its not worked totally baffled. ![screen shot] ok sorted needed Detect special numbers to be ticked.image description

edit flag offensive delete link more


You should also change the Column-type of 3rd and 4th Column from Standard to Date d/m/y

karolus gravatar imagekarolus ( 2019-03-10 17:45:01 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-03-10 14:27:18 +0100

Seen: 65 times

Last updated: Mar 10 '19