From d89a42213b4a32535e93185dedf41fe7a7fc1940 Mon Sep 17 00:00:00 2001
From: mitao <2763622819@qq.com>
Date: 星期五, 04 四月 2025 01:57:13 +0800
Subject: [PATCH] bug修改
---
medicalWaste-system/src/main/java/com/sinata/system/config/AutoColumnWidthStrategy.java | 7 ++++++-
1 files changed, 6 insertions(+), 1 deletions(-)
diff --git a/medicalWaste-system/src/main/java/com/sinata/system/config/AutoColumnWidthStrategy.java b/medicalWaste-system/src/main/java/com/sinata/system/config/AutoColumnWidthStrategy.java
index 01a4fa2..0a8623c 100644
--- a/medicalWaste-system/src/main/java/com/sinata/system/config/AutoColumnWidthStrategy.java
+++ b/medicalWaste-system/src/main/java/com/sinata/system/config/AutoColumnWidthStrategy.java
@@ -20,11 +20,14 @@
if (needSetWidth) {
Map<Integer, Integer> maxWidthMap = cache.computeIfAbsent(writeSheetHolder.getSheetNo(), k -> new HashMap<>());
int columnWidth = calculateWidth(cellDataList, cell, isHead);
+ if (columnWidth >= 16) {
+ columnWidth = 16;
+ }
if (columnWidth > 0) {
columnWidth = Math.min(columnWidth, 255); // 最大支持255字符
if (columnWidth > maxWidthMap.getOrDefault(cell.getColumnIndex(), 0)) {
maxWidthMap.put(cell.getColumnIndex(), columnWidth);
- writeSheetHolder.getSheet().setColumnWidth(cell.getColumnIndex(), columnWidth * 256);
+ writeSheetHolder.getSheet().setColumnWidth(cell.getColumnIndex(), columnWidth * 255);
}
}
}
@@ -41,6 +44,8 @@
return cellData.getStringValue().getBytes().length;
case NUMBER:
return cellData.getNumberValue().toString().getBytes().length;
+ case DATE:
+ return cellData.getDateValue().toString().getBytes().length;
default:
return -1;
}
--
Gitblit v1.7.1