Long story short, I can't change the cell type before Excel sheets hit my system. Users are for some reason changing the cell type to 'Special' in Excel and then picking obscure Locale's to fit their formatting(because they're idiots). Sometimes it's a Chinese variant, others it's Portuguese, etc. The users are trying to put in values like 00001 that look normal in Excel but when Poi reads these values, they are coming in as Cell.STRING and the value is '1' in this case. The system needs to read the raw value as 00001 just like the user entered it. I need those beginning 0's. Any way to get around this without making the users change?
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
