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

            Bug ID: 93715
           Summary: Open Excel Pivot Table in LO Calc causes Excel to
                    crash.
           Product: LibreOffice
           Version: 5.0.1.2 release
          Hardware: Other
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: major
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs@lists.freedesktop.org
          Reporter: kjor...@lkjcpa.com

This is my first bug report, but I did not find any previous reports that were
an exact match. [Please note that I am reporting this for Calc 5.x, but I also
experienced the problem in Calc 4.x (latest version) before upgrading to see if
that solved the problem.]

Here is my report:

Date of report: 2015.0827

Subject: "Open Excel Pivot Table in LO Calc causes Excel to crash."

Excel version: 2007 (12.0.6727.5000) SP3 MSO (12.0.6728.5000)

LibreOffice version: 5.0.0.5 (x64) Build ID:
1b1a90865e348b492231e1c451437d7a15bb262b

============START TEST 1===============

[Step 1]
  Create Excel Data and Pivot in new workbook. Save file in xlsx format.

[Step 2]
  Open workbook in LibreOffice Calc. Adjust column widths for content. Save
file in xlsx format.

[Step 3]
  Open workbook in Excel.

[RESULT]
  Error shown below:


"Excel found unreadable content in 'Excel_LO_TEST_1.xlsx'. Do you want to
recover the contents of this workbook? If you trust the source of this
workbook, click Yes."

[Answered 'Yes']

"Excel was able to open the file by repairing or removing the unreadable
content.

"Repaired Records: PivotTable report from
/xl/pivotCache/pivotCacheDefinition1.xml part (PivotTable cache)"

--------------------Start of Log Record---------------------
<?xml version="1.0" encoding="UTF-8" standalone="true"?>

-<recoveryLog
xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main";>

<logFileName>error040320_01.xml</logFileName>

<summary>Errors were detected in file 'C:\Users\Owner\LKJ-OtherFiles\Google
Drive\Misc TESTS\Excel_LO_TEST\Excel_LO_TEST_1.xlsx'</summary>


-<repairedRecords summary="Following is a list of repairs:">

<repairedRecord>Repaired Records: PivotTable report from
/xl/pivotCache/pivotCacheDefinition1.xml part (PivotTable
cache)</repairedRecord>

</repairedRecords>

</recoveryLog>
--------------------End of Log Record---------------------

[Step 4]
  Refreshed Pivot Table

[RESULT]
  Excel crashes, restarts, and lists recovered files.

[Step 5]
  Save Autosave file and original file (with changes made by Excel).

[Step 6]
  Open Autosave file and refresh pivot table.

[RESULT]
  Excel crashes without restart or recovery.

[Step 7]
  Open original file (with changes made by Excel) and refresh pivot table.

[RESULT]
  Excel crashes without restart or recovery.

============END TEST 1===============

============START TEST 2===============

[STEP 1]
  Make a copy of Excel workbook created in TEST 1 STEP 1.

[STEP 2]
  Open workbook with LibreOffice Calc. Make no changes. "Save as" in xlsx
format and close file.

[STEP 3]
  Open workbook with Excel.

[RESULT]
  Same error as in TEST 1 STEP 3.

[STEP 4]
  Do not open log or select files to save. Instead, refresh pivot for selected
file.

[RESULT]
  Same as TEST 1 STEP 6 and STEP 7.  
============END TEST 2===============

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to