Tint value is not read correctly

[H-Hervert]

I code in C#. I use NPOI(version 2.5.5).

I have this excel file whose extention is .xlsx:

I editted the Excel sheet via NPOI.

code:

private void button_editByNpoi_Click(object sender, EventArgs e)
        {
            string filePath = destFileName;

            IWorkbook workbook;
            using (FileStream fs = new FileStream(filePath, FileMode.Open, FileAccess.Read))
            {
                workbook = new XSSFWorkbook(fs);
            }

            /*
            //1枚目のシートを取得
            ISheet sheet = workbook.GetSheetAt(0);

            //セルを取得
            IRow row = sheet.GetRow(1);
            ICell cell = row.GetCell(1);

            //セルに書き込み
            //cell.SetCellValue("a");
            */

            using (FileStream fs = new FileStream(filePath, FileMode.Create, FileAccess.Write))
            {
                //上書き保存する。
                workbook.Write(fs);
            }
        }

As the result, I got this excel sheet:

the light gray color has gone after editting. How can I keep the color?

[tonyqus]

こにじわ
This looks to be a bug. Can you share your Excel file?

[H-Hervert]

I attached the Excel file. Please refer to this.

template - コピー.xlsx

[tonyqus]

something wrong with the styles.xml in the xlsx file

The tint value is lost because the original tint value uses scentific numberic value. Btw, is this file generated by Microsoft Office directly or from 3rd party software?

[H-Hervert]

something wrong with the styles.xml in the xlsx file

The tint value is lost because the original tint value uses scentific numberic value. Btw, is this file generated by Microsoft Office directly or from 3rd party software?

This file was generated by Microsoft Office directly.

[lukasz-gabryel]

Why you closed this ticket? I have this same problem, and this bug still exists.

[H-Hervert]

As @lukasz-gabryel mentioned, the bug has not been fixed yet, right? When will it be fixed?

[H-Hervert]

@tonyqus Has this bug fixed?

[tonyqus]

Yes, it will be available in 2.6.0

[H-Hervert]

Yes, it will be available in 2.6.0

I see. So it will be fixed in 2.6.0. And 2.6.0 hasn't been finalized yet at the moment. Do you have the timeline for when 2.6.0 will be released?

[tonyqus]

The planned release date is Oct, 2022. Release note is here: #742