Hi
I have version 5.3.4.2 and a cvs file which I use to create a pivot table have no problems, but on another computer with version 6.1.5.2 using the same data file the pivot table is created without any data in the tables.
Any one having the same problem.
(/upfiles/15522239605968652.jpg)
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 Vlookup formulas fail when Calc opened in another language
Ok just uninstalled 6.1.5.2 from computer and installed the 5.3.4.2 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.
You should also change the Column-type of 3rd and 4th Column from Standard to Date d/m/y