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 Extension	Assignee:	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

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

2023-02-21 08:47:40 EST

see also https://www.eclipse.org/forums/index.php/t/1112552/

Comment 2 Eclipse Genie

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 3 Eclipse Genie

2023-02-21 08:55:30 EST

Gerrit change https://git.eclipse.org/r/c/nattable/org.eclipse.nebula.widgets.nattable/+/200042 was merged to [master].
Commit: http://git.eclipse.org/c/nattable/org.eclipse.nebula.widgets.nattable.git/commit/?id=c5a73bcf731e63b71eeaeb4e71e2a99ff0ff0085

Comment 4 Eclipse Genie

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 5 Eclipse Genie

2023-02-22 08:31:05 EST

Gerrit change https://git.eclipse.org/r/c/nattable/org.eclipse.nebula.widgets.nattable/+/200089 was merged to [master].
Commit: http://git.eclipse.org/c/nattable/org.eclipse.nebula.widgets.nattable.git/commit/?id=27feb062e331c01513fe15c32738827ba075bf54

Comment 6 Eclipse Genie

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 7 Eclipse Genie

2023-02-24 01:40:00 EST

Gerrit change https://git.eclipse.org/r/c/nattable/org.eclipse.nebula.widgets.nattable/+/200158 was merged to [master].
Commit: http://git.eclipse.org/c/nattable/org.eclipse.nebula.widgets.nattable.git/commit/?id=68f11320b05837f12536609d64e5758028235d92

Comment 8 Dirk Fauth

2023-03-31 03:44:57 EDT

Fixed with 2.1.0