On Fri, 30 Sep 2016, Fende wrote:
I use POI library to create xlsx files using the class XSSFWorkbook. If i open the created file with double-click using "Windows Explorer", Excel 2007 runs ok i can see the numbers correctly. But opening the same file from Excel 2007, using Menu -> Open, every number with 8 or more digits is truncated to the first digit.
If you want Excel to display a number in a certain way, eg ensure a certain number of digits are shown, then you need to create a cell style with that formatting, and apply it to the cells. Relying on Excel to magically pick the right format is error prone at best
http://poi.apache.org/spreadsheet/quick-guide.html#DataFormats Nick --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-mail: user-h...@poi.apache.org
