[Libreoffice-bugs] [Bug 130829] New: Wrong formula in sheet with Pivot Table

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=130829

            Bug ID: 130829
           Summary: Wrong formula in sheet with Pivot Table
           Product: LibreOffice
           Version: 7.0.0.0.alpha0+ Master
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: suokunlong at 126.com

Created attachment 158066
  --> https://bugs.documentfoundation.org/attachment.cgi?id=158066&action=edit
Test XLSX file

Steps to Reproduce:
1. Open the attached xlsx file with Calc.
2. Compare with MSO ("expected screenshot")

Expected Result:
The formulas in column D should be set on the same rows as "cat" and "dog".

Current Result:
The formulas in column D are set on the wrong rows. Due to this, if you do
"Data > Calculation > Force Recalculation (Ctrl + Shift + F9), you will get
#VALUE! in cell D4.

Actually the reason for this bug may be due to the fact that Calc inserted a
new row (i.e., row 3 which is showing as "Data").

Reproduced in both 6.3 branch and the current master. Fedora 31 x64.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200221/064a88f3/attachment-0001.htm>