https://bugs.documentfoundation.org/show_bug.cgi?id=122715
--- Comment #8 from ady <[email protected]> --- The Pivot Table is imported differently in Calc than in Excel. Be careful not to click on row 4, so as not modify the Pivot Table itself. Examples (cells) to compare between Excel and Calc: _ F4, Calc does not consider the column as part of the PT. _ F18 (900 <> 0) _ B18:C19 (grouped, empty vs another item) So row 18 complicates the comparison of differences, and generates the offset in the resulting sums. _ B27:C30 (Excel) vs B29:C32 (Calc) and their respective values in column F. _ B44:C45 (Excel) vs B48:C49 (Calc) and their respective values in column F. _ B54:C55 (Excel) vs B58:C59 (Calc) and their respective values in column F. _ B59 (Excel) vs B63 (Calc). Obviously that, starting from row 18, each row has different values in column F; some might coincide, but only by chance. IOW, Calc imports differently column F and row 18 in the Pivot Table, shifting the rest of the content and calculations. -- You are receiving this mail because: You are the assignee for the bug.
