[Libreoffice-bugs] [Bug 122727] New: opening ods file (saved in Office 5.3) and adding new data in office 6.0.7.3; pivot table refresh get errors

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 122727
           Summary: opening ods file (saved in Office 5.3) and adding new
                    data in office 6.0.7.3; pivot table refresh get errors
           Product: LibreOffice
           Version: 6.0.7.3 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: dragsidor at yahoo.com

Description:
pivot table refresh get errors for pages saved in office 5.2 and edited in
office 6.0.7.3

Steps to Reproduce:
1. open file made in office 5.2
2. add new data
3. data refresh pivot table
4. get error in calculation that office 5.2 doesn't

Actual Results:
B5 of pivot table give 37.03


Expected Results:
B5 of pivot table should give 925.72
like "DATE" J96 give


Reproducible: Always


User Profile Reset: No



Additional Info:
it should give 925.72

In this bug repport page I don't see where I can attach documents, so I put
this files in the e-mail.
Thank you,
Dragos 
dragsidor at yahoo.com

-- 
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/20190115/ab8e619c/attachment.html>