Excel requires repair of rubyXL opened and saved xlsx

[aldhsu]

Opening this file and saving it in rubyXL produces errors in it that need to be repaired by Excel.

<?xml version="1.0" encoding="UTF-8" standalone="true"?>

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

<logFileName>error028200_01.xml</logFileName>

<summary>Errors were detected in file 'C:\Users\Kinesis\Downloads\Stockland_2013_GRESB_Report.xlsx'</summary>


-<removedRecords summary="Following is a list of removed records:">

<removedRecord>Removed Records: Named range from /xl/workbook.xml part (Workbook)</removedRecord>

</removedRecords>

</recoveryLog>

Any help would be greatly appreciated!

[aldhsu]

Resolution:

I dug around in the XML and I have noticed this:

Some weirdness around the the definedNames: [1]Lists!$B$1:$B$3

• I removed this entry because it seems to be a referencing a file that doesn't exist

Issue may be related to referencing external files. This issue can be closed.

[weshatheleopard]

It is a known issue. External links may go wrong because rubyXL does not track them properly yet. It requires a lot of work to fix, and it's in distant plans.

[HDLP9]

I ran into this issue and "fixed it" by:

1. opening the excel and allowing Excel to repair it
2. use the new repaired excel as the template for RubyXL to open

And the error just got fixed for new exports. I really don't know why but it worked.

Give it a try.

Duplicate of #230