On 4/11/2010 11:41 PM, Ramon F. Herrera wrote:
Hello all,
My first POI app generates a spreadsheet based on the Loan Calculator
example provided. See snippet below.
Notice how all the values are hardwired in advance, not typed. The
problem is that Excel complains about them (*). I can type new,
identical values and their corresponding formats are acknowledged and
applied by Excel (but only interactively): the numerical values become
right-justified, the correct number of decimals is displayed, etc.
What statement should I add in order to tell Excel: "Upon opening the
file, please apply the formats provided to the values inserted by
'setCellValue()'?
Perhaps I am doing things in the wrong order?
Bonus question: My spreadsheet looks better if seen at 85%. Can I
specify such zoom factor inside the *.xlsx file?
Thx,
-Ramon
(*) I get the little upper-left triangle and the warning sign:
"The number in this cell is formatted as text or preceded by an
apostrophe."
---------------------
cell = row.createCell(2);
cell.setCellValue("HS-114");
cell.setCellStyle(styles.get("text"));
cell = row.createCell(3);
cell.setCellValue("40");
cell.setCellStyle(styles.get("integer"));
cell = row.createCell(4);
cell.setCellValue("0.1875");
cell.setCellStyle(styles.get("4-decimal_number"));
cell = row.createCell(5);
cell.setCellValue("17.88");
cell.setCellStyle(styles.get("2-decimal_number"));
Dear Ramon,
Had you RTFM, you would have discovered that all you had to do was
remove the double quotes from the numeric values.
Things make so much sense after you solve them.
Note: The zoom factor question remains open...
Thx,
-RFH
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
