[Libreoffice-bugs] [Bug 123923] New: Exporting to XLSX makes Excel show error and drop pivot table, if table's data has Err:504 instead of #REF!

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 123923
           Summary: Exporting to XLSX makes Excel show error and drop
                    pivot table, if table's data has Err:504 instead of
                    #REF!
           Product: LibreOffice
           Version: 6.2.1.1 rc
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mikekaganski at hotmail.com

Created attachment 149786
  --> https://bugs.documentfoundation.org/attachment.cgi?id=149786&action=edit
Exporting this to XLSX makes Excel to drop pivot table

When a pivot table is based on data including a formula like this:

> =COUNTIF(#REF!;0)

then saving the spreadsheet to XLSX produces a file that MS Excel opens with
error like

> We found a problem with some content in `file.xlsx`. Do you want us to try to
> recover as much as we can? If you trust the source of this workbook, click Yes.

And confirming this drops the pivot table.

The attachment contains a minimal reproducer.

Tested with Version: 6.2.2.1 (x64)
Build ID: fcd633fb1bf21b0a99c9acb3ad6e526437947b01
CPU threads: 12; OS: Windows 10.0; UI render: default; VCL: win; 
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: CL

-- 
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/20190307/84de1702/attachment.html>