https://bugs.documentfoundation.org/show_bug.cgi?id=166585
Bug ID: 166585
Summary: Chart doesn't like errors in PivotTable source
Product: LibreOffice
Version: 7.3.2.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 200817
--> https://bugs.documentfoundation.org/attachment.cgi?id=200817&action=edit
This is the file with the error
The source data is from my weight training.
I make a pivot table with the three fields: the date when I did my weight
training, the name of the exercise and the average weight.
Then I create a line graph to show how well I'm progressing with each exercise.
However one day I skipped one particular exercise, so the pivot table is
correct to show #value! for that one exercise.
But then the chart goes wrong.
I noticed the exercise I that was furthest right in the pivot table doesn't
have any point on the line graph for the last date.
All the other exercises all show wrong data on the date that I skipped that one
exercise.
It's like the chart is just picking the data from the wrong exercise for that
one date and it's just completely wrong. With curls I'm lifting 6, 7, 8, 9 KG
ball park figure, but that one date I'm lifting 25 kg, which is very wrong,
it's just picking the numbers from the wrong columns.
--
You are receiving this mail because:
You are the assignee for the bug.
