Rober,
To calculate column width HSSFSheet.autoSizeColumn uses Java2D classes
that throw exception if graphical environment is not available.
However, some tasks such as computing text layout can be
done in a headless mode, that is in the absence of graphical
environment.
To use headless mode
I tried 3.0-rc4 and I have an existing excel spreadsheet template with formulas
that I read and updated.
The formula =SUMPRODUCT(--(B5:B995=Some 1),--(K5:K995=Not Tested)) is lost
after the re-write.
I see #REF! in its place.
Any ideas why this is happening?
I'm not even touching the cell
