In this in-depth series on LibreOffice we examine Writer, Calc and Impress
We take a look at one of the most powerful, but somewhat frightening, features of modern spreadsheets. But knowing the basics of pivot tables should make them a bit less frightening to the newcomer.
Comment #1 posted on 2015-01-18 12:30:21 by Steve Bickle
What version of LibreOffice was the example created in?
Ahuka,
Thats a really clear explanation of pivot tables, I'm sure I'll find a good use for these at some point. Thanks.
When trying to create a pivot table on the sample sheet you provided, It resulted in #VALUE errors in the totals of the resulting table. So I updated to the latest version of LibreOffice. I still had the same problem.
So then I then use a clean sheet with the data-set from sheet 1 of your example, then pivot tables worked fine as you described.
Hence the question about what version of LibreOffice was the sheet created with?
I ask because there may be a compatibility bug between versions that I should report.
Steve
Comment #2 posted on 2015-01-18 12:33:47 by Steve Bickle
Last comment really belongs on ep 1655
OOPS!
Comment #3 posted on 2015-01-19 19:48:00 by Kevin O'Brien
LibreOffice Version
It was 4.1.6.2. I know that is not the most current version, but I do
these in advance and schedule them out.
Leave Comment
Note to Verbose Commenters
If you can't fit everything you want to say in the comment below then you really should record a response show instead.
Note to Spammers
All comments are moderated. All links are checked by humans. We strip out all html. Feel free to record a show about yourself, or your industry, or any other topic we may find interesting. We also check shows for spam :).
