Date type number format support

[diudiudiuu]

如果我选择 以元年形式显示第一年,输出会变成 2022-6-2 而不是 令和4年6月2日
如果我没有选择 以元年形式显示第一年,输出正常

下面是我的代码 以及模板
test.xlsx

package main

import (
	"fmt"

	"github.com/xuri/excelize/v2"
)

func main() {
	f, err := excelize.OpenFile("0_mock.xlsx")
	if err != nil {
		fmt.Println(err)
		return
	}


	// 根据指定路径保存文件
	if err := f.SaveAs("aaaaa.xlsx"); err != nil {
		fmt.Println(err)
	}
}

[xuri]

Thanks for your feedback. This issue is similar with #62, #660, #675, #759, and #1055. The Excelize not support to parse all the number formats of the cell. This feature are working in progress. As the documentation says, if the cell format can be applied to the value of a cell, the applied value will be returned, otherwise the original value will be returned. I will close this and merge it into issue #660 is still discussing this feature.