From c5cc500b886366a99641eaa7bc24613f6066fd79 Mon Sep 17 00:00:00 2001
From: Ri Xu <xuri.me@gmail.com>
Date: Mon, 26 Dec 2016 18:06:12 +0800
Subject: - Fix issue: pivot cache and extending spreadsheetML missing; -
 Compatibility improved: relationship namespace in `workbook.xml` has been
 changed (`xmlns:mc`, `xmlns:x15` and `mc:Ignorable` added)

---
 sheet.go | 13 +++++++++++--
 1 file changed, 11 insertions(+), 2 deletions(-)

(limited to 'sheet.go')

diff --git a/sheet.go b/sheet.go
index 351a537..16b9a60 100644
--- a/sheet.go
+++ b/sheet.go
@@ -70,7 +70,7 @@ func (f *File) setWorkbook(name string, rid int) {
 	if err != nil {
 		fmt.Println(err)
 	}
-	f.saveFileList(`xl/workbook.xml`, replaceRelationshipsNameSpace(string(output)))
+	f.saveFileList(`xl/workbook.xml`, workBookCompatibility(replaceRelationshipsNameSpace(string(output))))
 }
 
 // Read and unmarshal workbook relationships of XLSX.
@@ -118,7 +118,7 @@ func (f *File) setAppXML() {
 // horrible hack to fix that after the XML marshalling is completed.
 func replaceRelationshipsNameSpace(workbookMarshal string) string {
 	oldXmlns := `<workbook xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">`
-	newXmlns := `<workbook xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships">`
+	newXmlns := `<workbook xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x15" xmlns:x15="http://schemas.microsoft.com/office/spreadsheetml/2010/11/main">`
 	return strings.Replace(workbookMarshal, oldXmlns, newXmlns, -1)
 }
 
@@ -200,5 +200,14 @@ func workBookCompatibility(workbookMarshal string) string {
 	workbookMarshal = strings.Replace(workbookMarshal, `></tabColor>`, ` />`, -1)
 	workbookMarshal = strings.Replace(workbookMarshal, `></pageSetUpPr>`, ` />`, -1)
 	workbookMarshal = strings.Replace(workbookMarshal, `></pane>`, ` />`, -1)
+	workbookMarshal = strings.Replace(workbookMarshal, `<extLst></extLst>`, ``, -1)
+	workbookMarshal = strings.Replace(workbookMarshal, `<fileRecoveryPr />`, ``, -1)
+	workbookMarshal = strings.Replace(workbookMarshal, `<workbookProtection />`, ``, -1)
+	workbookMarshal = strings.Replace(workbookMarshal, `<pivotCaches></pivotCaches>`, ``, -1)
+	workbookMarshal = strings.Replace(workbookMarshal, `<externalReferences></externalReferences>`, ``, -1)
+	workbookMarshal = strings.Replace(workbookMarshal, `<workbookProtection></workbookProtection>`, ``, -1)
+	workbookMarshal = strings.Replace(workbookMarshal, `<definedNames></definedNames>`, ``, -1)
+	workbookMarshal = strings.Replace(workbookMarshal, `<fileRecoveryPr></fileRecoveryPr>`, ``, -1)
+	workbookMarshal = strings.Replace(workbookMarshal, `<workbookPr />`, ``, -1)
 	return workbookMarshal
 }
-- 
cgit v1.2.1