I don't think you can restrict what goes in a cell in Excel without using VBA. If you need to do that you are better off with a database anyway. Besides, VBA cannot be parsed by POI, so even if you do restrict the contents of a cell that way, you can't detect it with POI.
-----Original Message----- From: Blake Watson [mailto:blake.wat...@pnmac.com] Sent: Tuesday, June 27, 2017 12:26 PM To: POI Users List <user@poi.apache.org> Subject: Re: Intended Cell Type >> but doesn't mean that's what will be written there. Not in Excel-land. This presents some challenges when you're trying to actually restrict what might go there. >>You could try entering a date and format it as "#,##0.00". Yeah. And I could format the values according to whats in there, which would remove the scientific notation aspect, but which would also put commas in exported numbers. Excel's a hell of a thing.
