Skip to main content
aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorDirk Fauth2023-02-24 06:28:31 +0000
committerDirk Fauth2023-02-24 06:28:31 +0000
commit68f11320b05837f12536609d64e5758028235d92 (patch)
tree4039437ef31988e67a23e142a7b1c6e7db5453e8
parent27feb062e331c01513fe15c32738827ba075bf54 (diff)
downloadorg.eclipse.nebula.widgets.nattable-68f11320b05837f12536609d64e5758028235d92.tar.gz
org.eclipse.nebula.widgets.nattable-68f11320b05837f12536609d64e5758028235d92.tar.xz
org.eclipse.nebula.widgets.nattable-68f11320b05837f12536609d64e5758028235d92.zip
Bug 581562 - Numbers are not exported to Excel with the correct format
Removed the default format for Number values to support not setting a format as it was before. Signed-off-by: Dirk Fauth <dirk.fauth@googlemail.com> Change-Id: I0630cfb295bc9c2cc5c065c01f8d973081fc7e79
-rw-r--r--org.eclipse.nebula.widgets.nattable.examples/src/org/eclipse/nebula/widgets/nattable/examples/_800_Integration/_811_GroupBySummaryFixedSummaryRowExample.java5
-rw-r--r--org.eclipse.nebula.widgets.nattable.extension.poi/src/org/eclipse/nebula/widgets/nattable/extension/poi/PoiExcelExporter.java4
2 files changed, 5 insertions, 4 deletions
diff --git a/org.eclipse.nebula.widgets.nattable.examples/src/org/eclipse/nebula/widgets/nattable/examples/_800_Integration/_811_GroupBySummaryFixedSummaryRowExample.java b/org.eclipse.nebula.widgets.nattable.examples/src/org/eclipse/nebula/widgets/nattable/examples/_800_Integration/_811_GroupBySummaryFixedSummaryRowExample.java
index d0c7355b..8f361cac 100644
--- a/org.eclipse.nebula.widgets.nattable.examples/src/org/eclipse/nebula/widgets/nattable/examples/_800_Integration/_811_GroupBySummaryFixedSummaryRowExample.java
+++ b/org.eclipse.nebula.widgets.nattable.examples/src/org/eclipse/nebula/widgets/nattable/examples/_800_Integration/_811_GroupBySummaryFixedSummaryRowExample.java
@@ -307,6 +307,11 @@ public class _811_GroupBySummaryFixedSummaryRowExample extends AbstractNatExampl
formatter,
DisplayMode.NORMAL,
ColumnLabelAccumulator.COLUMN_LABEL_PREFIX + 3);
+ configRegistry.registerConfigAttribute(
+ ExportConfigAttributes.NUMBER_FORMAT,
+ "0.00", //$NON-NLS-1$
+ DisplayMode.NORMAL,
+ ColumnLabelAccumulator.COLUMN_LABEL_PREFIX + 3);
configRegistry.registerConfigAttribute(
ExportConfigAttributes.EXPORT_FORMATTER,
diff --git a/org.eclipse.nebula.widgets.nattable.extension.poi/src/org/eclipse/nebula/widgets/nattable/extension/poi/PoiExcelExporter.java b/org.eclipse.nebula.widgets.nattable.extension.poi/src/org/eclipse/nebula/widgets/nattable/extension/poi/PoiExcelExporter.java
index 6dd4afe8..b89d01a0 100644
--- a/org.eclipse.nebula.widgets.nattable.extension.poi/src/org/eclipse/nebula/widgets/nattable/extension/poi/PoiExcelExporter.java
+++ b/org.eclipse.nebula.widgets.nattable.extension.poi/src/org/eclipse/nebula/widgets/nattable/extension/poi/PoiExcelExporter.java
@@ -418,10 +418,6 @@ public abstract class PoiExcelExporter implements ILayerExporter {
ExportConfigAttributes.NUMBER_FORMAT,
DisplayMode.NORMAL,
cell.getConfigLabels());
-
- if (dataFormat == null) {
- return (exportDisplayValue instanceof Double || exportDisplayValue instanceof Float) ? "0.00" : "0"; //$NON-NLS-1$//$NON-NLS-2$
- }
}
return dataFormat;

Back to the top