This closes #1162, improve the compatibility with alternate content

Preserve alternate content in the workbook, worksheet, and drawingML

1 files changed, 7 insertions, 0 deletions

diff --git a/sheet.go b/sheet.go
index b440fb9..78fcaf2 100644
--- a/sheet.go
+++ b/sheet.go
@@ -158,6 +158,13 @@ func (f *File) workSheetWriter() {
 			if sheet.SheetPr != nil || sheet.Drawing != nil || sheet.Hyperlinks != nil || sheet.Picture != nil || sheet.TableParts != nil {
 				f.addNameSpaces(p.(string), SourceRelationship)
 			}
+			if sheet.DecodeAlternateContent != nil {
+				sheet.AlternateContent = &xlsxAlternateContent{
+					Content: sheet.DecodeAlternateContent.Content,
+					XMLNSMC: SourceRelationshipCompatibility.Value,
+				}
+			}
+			sheet.DecodeAlternateContent = nil
 			// reusing buffer
 			_ = encoder.Encode(sheet)
 			f.saveFileList(p.(string), replaceRelationshipsBytes(f.replaceNameSpaceBytes(p.(string), buffer.Bytes())))