Compatibility issue of Google Sheets offline browser extension

[eaglexiang]

Description

Steps to reproduce the issue:

1. 通过 excelize 生成文件，只填充 string，不设置任何风格
2. 通过 MS Office 打开文件
3. 通过 Google Chrome 打开文件

Describe the results you received:

1. 通过 MS Office 打开文件，所有格子默认无背景色
2. 通过 Google Chrome 打开文件，所有填充过文字的格子背景色为黑色，未填充文字的格子无背景色

Describe the results you expected:

既然我在生成代码时未设置风格，那么 excel 文件不应该自带黑色背景。考虑到 MS Office 打开显示正常，不排除是格式兼容性问题。

Output of go version:

go version go1.15.7 linux/amd64

Excelize version or commit ID:

v2.3.2

Environment details (OS, Microsoft Excel™ version, physical, etc.):

Linux version 5.4.0-58-generic (buildd@lcy01-amd64-004) (gcc version 9.3.0 (Ubuntu 9.3.0-17ubuntu1~20.04)) #64-Ubuntu SMP Wed Dec 9 08:16:25 UTC 2020

[xuri]

Did you mean that open generated file with Google Sheets or some application extensions in the Google Chrome ? Could you provide a spreadsheet attachment without confidential info?

[eaglexiang]

Did you mean that open generated file with Google Sheets or some application extensions in the Google Chrome ? Could you provide a spreadsheet attachment without confidential info?

是的，用 Google Sheets 打开会有默认的黑色背景

Book1.xlsx

[eaglexiang]

上面提供的是我生成 excel 的环境。

下面是我打开 excel 环境：

操作系统:

版本	Windows 10 家庭中文版
版本号	20H2
操作系统版本	19042.746

Google Chrome:

版本 88.0.4324.104（正式版本） （64 位）

Google文档、表格及幻灯片的Office编辑扩展程序:

版本
135.360.369

[xuri]

I have tested Google Sheets open your attachment with the following browser in macOS 11.1, it works well and I think this issue doesn't belong to Excelize, maybe you should be feedback to Google Sheets.

Google Chrome 88.0.4324.96 (x86_64)
Safari 14.0.2 (16610.3.7.1.9)
Microsoft Edge 87.0.664.75 (64-bit)

[eaglexiang]

但是我用 MS Office 手动生成或修改 xlsx 文件并在相同环境打开，显示是正常的。

[xuri]

It seems your attachment passed the ECMA-376, ISO/29500 Open Office XML spec compatibility checks, so it maybe compatibility issue of Google Sheets.

[xuri]

Hi @eaglexiang, this issue occurs in extension, but the online version's Google Sheets work well. I will be closing this issue.

[eaglexiang]

也许不同版本的 Google Sheets 确实对 xlsx 有不同的兼容性，但我仍然认为导致这个问题的主要原因是 excelize 生成了不标准的 xml。我试着进行修复并提了 PR