alibaba/easyexcel

CellWriteHandler里设置千位符后需要在Excel中双击才显示

Open

#4109 opened on Apr 17, 2025

View on GitHub
 (0 comments) (0 reactions) (0 assignees)Java (33,728 stars) (7,599 forks)batch import
help wanted

Description

异常代码

WriteCellStyle writeCellStyle = cellData.getOrCreateStyle(); // 字体策略 WriteFont contentWriteFont = new WriteFont(); // 字体大小 contentWriteFont.setFontHeightInPoints((short) 11); contentWriteFont.setFontName("微软雅黑"); writeCellStyle.setWriteFont(contentWriteFont); writeCellStyle.setBorderLeft(BorderStyle.THIN); writeCellStyle.setBorderRight(BorderStyle.THIN); writeCellStyle.setBorderTop(BorderStyle.THIN); writeCellStyle.setBorderBottom(BorderStyle.THIN); // 这里可以对cell进行任何操作 if (cell.getColumnIndex() > 0 && cell.getColumnIndex() > 3) { DataFormatData dataForma = new DataFormatData(); cellData.setType(CellDataTypeEnum.NUMBER); dataForma.setFormat("#,##0"); // 这个需要看模板，因为一个单元格会有多个 WriteCellData writeCellStyle.setHorizontalAlignment(HorizontalAlignment.RIGHT); writeCellStyle.setDataFormatData(dataForma); } 下载Excel后千位符的单元格没有生效，需要双击一下才能显示

Image

Contributor guide

Tech stack
java
Domain
backend
Issue type
bug
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-3 hours
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
fresh
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
clear
Prerequisites
JavaEasyExcel basicsApache POI data formats
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
60
Research direction
Investigate the CellWriteHandler class to understand how DataFormatData is applied to cell styles. The issue shows that setting a #,##0 format does not display until double clicking, suggesting the format is not being recognized as a number format. Look at how EasyExcel registers data formats with the underlying POI workbook, and ensure the cell type is set to numeric before applying the number format. Also check if there is a need to set the cell's data format index instead of just the format string. Reference similar issues in EasyExcel's GitHub issues related to number formatting.