get wrong text with GetRows

[KngStr]

Description

We got some problem with wrong cell format.

Steps to reproduce the issue:

rows _ := xlsx.GetRows(xlsx.GetSheetName(0))
fmt.Println(rows)

Use this file for test:Sample.xlsx

Describe the results you received:

年月日

Describe the results you expected:
This is what I got from office

988766248979,
312312333,

Output of go version:

(paste your output here)

Excelize version or commit ID:

787453c6f0b256fdf2c0454a0a694ee79ea52675

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

• Windows 10
• office 16
• go 1.18.2

[KngStr]

Thanks for this quick fix. But it still have some problem.

This bug is not only for date type.
If we change to the other type, it will get wrong text again.

It seems like if SharedString is used, excel will use this instead.

从修复的代码向来看是否不正确？
ms excel中单元格数据如果是引用的SharedString中的则无论单元格式设置为何另存为csv时都会使用SharedString中的数据。
当前修复只排除了日期类型，如果换一种类型则继续出现错误结果。

[xuri]

Thanks for your feedback. Which type you have changed to? Could you provide a file attachment without confidential info?

[KngStr]

Sample2.xlsx

What we got from GetRows

988766248979,,
312312333,日期类型,
312312333312312333,数值类型,
¥312312333312312333,货币类型,
312312333,时间类型,
" ",分数类型,
,,以上数据都引用了sharedString表中的数据，无论单元格格式设置为何都不会影响到结果

What we got from ms excel

988766248979,,
312312333,日期类型,
312312333,数值类型,
312312333,货币类型,
312312333,时间类型,
312312333,分数类型,
,,
,,
,,以上数据都引用了sharedString表中的数据，无论单元格格式设置为何都不会影响到结果

[KngStr]

Sorry. We still believe this maybe not the correct one.
SharedString seems like...

[xuri]

Sorry, I don't understand what's means that "SharedString seems like...". Could you show us cases for more details?

[KngStr]

We are wondering if this will be right.

File in xlsx

CellTypeSharedString

We try to fix

[KngStr]

Thanks.

[xuri]

I have fixed this issue. Please upgrade to the master branch code, and this patch will be released on the next version.

[KngStr]

OK. Thanks.