Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 581562

Summary: Numbers are not exported to Excel with the correct format
Product: [Technology] NatTable Reporter: Dirk Fauth <dirk.fauth>
Component: POI ExtensionAssignee: Dirk Fauth <dirk.fauth>
Status: CLOSED FIXED QA Contact:
Severity: normal    
Priority: P3    
Version: 2.0.5   
Target Milestone: 2.1.0   
Hardware: PC   
OS: Windows 10   
See Also: https://git.eclipse.org/r/c/nattable/org.eclipse.nebula.widgets.nattable/+/200042
https://git.eclipse.org/c/nattable/org.eclipse.nebula.widgets.nattable.git/commit/?id=c5a73bcf731e63b71eeaeb4e71e2a99ff0ff0085
https://git.eclipse.org/r/c/nattable/org.eclipse.nebula.widgets.nattable/+/200089
https://git.eclipse.org/c/nattable/org.eclipse.nebula.widgets.nattable.git/commit/?id=27feb062e331c01513fe15c32738827ba075bf54
https://git.eclipse.org/r/c/nattable/org.eclipse.nebula.widgets.nattable/+/200158
https://git.eclipse.org/c/nattable/org.eclipse.nebula.widgets.nattable.git/commit/?id=68f11320b05837f12536609d64e5758028235d92
Whiteboard:

Description Dirk Fauth CLA 2023-02-21 08:47:08 EST
When exporting a table to Excel, number values are not exported with a number format. Currently the PoiExcelExporter does only set a dataFormat for Calendar and Date values.

To fix this there should be correct default values for Integer and Double values. And it should be possible to override the defaults by configuring different values via ExportConfigAttributes.DATE_FORMAT.
Comment 1 Dirk Fauth CLA 2023-02-21 08:47:40 EST
see also https://www.eclipse.org/forums/index.php/t/1112552/
Comment 2 Eclipse Genie CLA 2023-02-21 08:50:19 EST
New Gerrit change created: https://git.eclipse.org/r/c/nattable/org.eclipse.nebula.widgets.nattable/+/200042
Comment 4 Eclipse Genie CLA 2023-02-22 08:23:53 EST
New Gerrit change created: https://git.eclipse.org/r/c/nattable/org.eclipse.nebula.widgets.nattable/+/200089
Comment 6 Eclipse Genie CLA 2023-02-24 01:28:48 EST
New Gerrit change created: https://git.eclipse.org/r/c/nattable/org.eclipse.nebula.widgets.nattable/+/200158
Comment 8 Dirk Fauth CLA 2023-03-31 03:44:57 EDT
Fixed with 2.1.0